Advanced Payroll Project

Anonymous
timer Asked: Dec 18th, 2018
account_balance_wallet $35

Question description

I just need someone to copy and paste a ton of numbers into an Excel spreadsheet. The work is already done, just needs to be transferred.

Excel Instructions CAUTION: Read Appendix B for specific instructions relating to these templates. 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example, 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time. You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name. To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar. It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. Page 41 JOURNAL DATE 20-- Oct. DESCRIPTION 9 Payroll Cash Cash POST. REF. DEBIT 12 11 12.052,01 9 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20,1 20,2 24 25 25,1 26 28 12 2.307,69 4.651,08 3.600,00 4.898,00 9 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20,1 20,2 21 22 1.381,11 CREDIT 12.052,01 958,33 224,14 1.118,00 474,55 10,85 602,89 16,00 12.052,01 958,32 224,12 22,91 175,76 20 Employees SIT Payable Cash 25 11 474,55 23 Payroll Cash Cash 12 11 12.115,19 474,55 12.115,19 Page 42 JOURNAL DATE 20-- Oct. Nov. DESCRIPTION POST. REF. DEBIT 23 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable Payroll Cash 51 52 53 54 20,1 20,2 24 25 25,1 26 27 28 12 2.307,69 4.651,08 3.600,00 5.219,60 23 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable - Employer 56 20,1 20,2 21 22 1.386,96 CREDIT 978,26 228,80 1.148,00 484,42 11,07 615,43 181,20 16,00 12.115,19 978,26 228,79 4,15 175,76 4 Employees SIT Payable Cash 25 11 484,42 6 Union Dues Payable Cash 28 11 32,00 484,42 32,00 Page 43 JOURNAL DATE 20-- Nov. DESCRIPTION 6 Payroll Cash Cash POST. REF. DEBIT 12 11 11.893,42 6 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 51 52 53 54 20,1 20,2 24 25 25,1 26 28 12 2.307,69 4.605,85 3.600,00 4.898,00 6 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer 56 20,1 20,2 22 1.343,71 12 11 1.428,45 13 Payroll Cash Cash CREDIT 11.893,42 955,53 223,49 1.238,00 473,16 10,82 601,12 16,00 11.893,42 955,52 223,47 164,72 1.428,45 Page 44 JOURNAL DATE 20-- Nov. DESCRIPTION POST. REF. DEBIT 13 Office Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Payroll Cash 52 20,1 20,2 24 25 25,1 26 27 12 2.079,32 13 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI 56 20,1 20,2 159,07 16 FICA Taxes Payabe-OASDI FICA Taxes Payable-HI Employee FIT Payable Cash 20,1 20,2 24 11 3.873,17 905,85 2.266,00 16 Employee CIT Payable Cash 26 11 1.218,32 18 Employees SIT Payable Cash 25 11 537,00 20 Payroll Cash Cash 12 11 9.216,00 51 52 53 54 20,1 20,2 24 25 25,1 26 27 28 29 12 2.307,69 3.398,00 3.600,00 4.616,40 20 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payroll Cash CREDIT 128,92 30,15 331,00 63,84 1,46 81,10 14,40 1.428,45 128,92 30,15 7.045,02 1.218,32 537,00 9.216,00 863,18 201,89 828,00 427,43 9,77 543,02 166,80 16,00 1.650,00 9.216,00 Page 45 JOURNAL DATE 20-- Nov. Dec. DESCRIPTION 20 Payroll Taxes FICA Taxes Payable - OASDI FICA Taxes Payable - HI SUTA Taxes Payable - Employer POST. REF. 56 20,1 20,2 22 DEBIT 1.113,15 863,17 201,87 48,11 3 Employees SIT Payable Cash 25 11 427,43 4 Payroll Cash Cash 12 11 10.730,23 51 52 53 54 20,1 20,2 24 25 25,1 26 27 28 29 12 2.307,69 4.628,00 3.600,00 5.188,60 4 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable - OASDI Fica Taxes Payabble - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Payable Payroll Cash CREDIT 427,43 10.730,23 974,92 228,02 1.018,00 482,76 11,03 613,33 0,00 16,00 1.650,00 10.730,20 Page 46 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 47 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 48 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 49 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Page 50 JOURNAL DATE 20-- DESCRIPTION POST. REF. DEBIT CREDIT Total debits and credits (calculated automatically): 151.410,42 151.410,39 Your debits and credits should be equal after each journal entry is complete Cumulative Journal Checkpoint Through Month Ending 58.644,96 124.528,47 October 31, 20-November 30, 20-- December 31, 20-January 31, 20-- GENERAL LEDGER Checkpoints ACCOUNT: ACCOUNT NO. 11 CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 20 23 4 6 6 13 16 16 16 20 a J41 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 12.052,01 474,55 12.115,19 484,42 32,00 11.893,42 1.428,45 7.045,02 1.218,32 537,00 9.216,00 199.846,33 187.794,32 187.319,77 175.204,58 174.720,16 174.688,16 162.794,74 161.366,29 154.321,27 153.102,95 152.565,95 143.349,95 CREDIT Debit Balance Oct. 31, 20-- 175.204,58 Nov. 30, 20-- 143.349,95 Dec. 31, 20-- Credit Balance ACCOUNT: ACCOUNT NO. 12 PAYROLL CASH DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 20 20 J41 J41 J41 J42 J43 J43 J43 J44 J44 J44 Checkpoints 12.052,01 12.052,01 12.115,19 12.115,19 11.893,42 11.893,42 1.428,45 1.428,45 9.216,00 9.216,00 12.052,01 0,00 12.115,19 0,00 11.893,42 0,00 1.428,45 0,00 9.216,00 0,00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 0,00 0,00 Credit Balance ACCOUNT: ACCOUNT NO. 20.1 FICA TAXES PAYABLE - OASDI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 Checkpoints Debit Balance 958,33 958,32 978,26 978,26 955,53 955,52 128,92 128,92 3.873,17 863,18 863,17 958,33 1.916,65 2.894,91 3.873,17 4.828,70 5.784,22 5.913,14 6.042,06 2.168,89 3.032,07 3.895,24 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 3.873,17 3.895,24 ACCOUNT: ACCOUNT NO. 20.2 FICA TAXES PAYABLE - HI DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 9 23 23 6 6 13 13 16 20 20 J41 J41 J42 J42 J43 J43 J44 J44 J44 J44 J45 Checkpoints Debit Balance 224,14 224,12 228,80 228,79 223,49 223,47 30,15 30,15 905,85 201,89 201,87 224,14 448,26 677,06 905,85 1.129,34 1.352,81 1.382,96 1.413,11 507,26 709,15 911,02 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 905,85 911,02 ACCOUNT: ACCOUNT NO. 21 FUTA TAXES PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. 1 Balance 9 23 a J41 J42 Checkpoints Debit Balance 22,91 4,15 392,94 415,85 420,00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 420,00 420,00 ACCOUNT: ACCOUNT NO. 22 SUTA TAXES PAYABLE - EMPLOYER DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 20 J41 J42 J43 J45 Checkpoints Debit Balance 175,76 175,76 164,72 48,11 175,76 351,52 516,24 564,35 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 351,52 564,35 ACCOUNT: ACCOUNT NO. 24 EMPLOYEES FIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 J41 J42 J43 J44 J44 J44 Checkpoints Debit Balance 1.118,00 1.148,00 1.238,00 331,00 2.266,00 828,00 1.118,00 2.266,00 3.504,00 3.835,00 1.569,00 2.397,00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 2.266,00 2.397,00 ACCOUNT: ACCOUNT NO. 25 EMPLOYEES SIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 20 23 4 6 13 18 20 J41 J41 J42 J42 J43 J44 J44 J44 Checkpoints Debit Balance 474,55 474,55 484,42 484,42 473,16 63,84 537,00 427,43 474,55 0,00 484,42 0,00 473,16 537,00 0,00 427,43 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 484,42 427,43 ACCOUNT: ACCOUNT NO. 25.1 EMPLOYEES SUTA PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 20 J41 J42 J43 J44 J44 Checkpoints Debit Balance 10,85 11,07 10,82 1,46 9,77 10,85 21,92 32,74 34,20 43,97 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 21,92 43,97 ACCOUNT: ACCOUNT NO. 26 EMPLOYEES CIT PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 13 16 20 J41 J42 J43 J44 J44 J44 Checkpoints Debit Balance 602,89 615,43 601,12 81,10 1.218,32 543,02 602,89 1.218,32 1.819,44 1.900,54 682,22 1.225,24 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 1.218,32 1.225,24 ACCOUNT: ACCOUNT NO. 27 GROUP INSURANCE PREMIUMS COLLECTED DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 23 13 20 J42 J44 J44 Checkpoints Debit Balance 181,20 14,40 166,80 181,20 195,60 362,40 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 181,20 362,40 ACCOUNT: ACCOUNT NO. 28 UNION DUES PAYABLE DATE ITEM POST. REF. Checkpoints Debit Balance BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Oct. Nov. 9 23 6 6 20 J41 J42 J42 J43 J44 16,00 16,00 32,00 16,00 16,00 16,00 32,00 0,00 16,00 32,00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 32,00 32,00 ACCOUNT: ACCOUNT NO. 29 SIMPLE CONTRIBUTIONS PAYABLE DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT CREDIT 20-- Nov. 20 J44 Checkpoints Debit Balance 1.650,00 1.650,00 Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Credit Balance 0,00 1.650,00 ACCOUNT: ACCOUNT NO. 51 ADMINISTRATIVE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 2.307,69 2.307,69 2.307,69 2.307,69 42.692,27 44.999,96 47.307,65 49.615,34 51.923,03 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 47.307,65 51.923,03 Credit Balance ACCOUNT: ACCOUNT NO. 52 OFFICE SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J44 Checkpoints 4.651,08 4.651,08 4.605,85 2.079,32 3.398,00 28.350,00 33.001,08 37.652,16 42.258,01 44.337,33 47.735,33 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 37.652,16 47.735,33 Credit Balance ACCOUNT: ACCOUNT NO. 53 SALES SALARIES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 3.600,00 3.600,00 3.600,00 3.600,00 28.525,00 32.125,00 35.725,00 39.325,00 42.925,00 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 35.725,00 42.925,00 Credit Balance ACCOUNT: ACCOUNT NO. 54 PLANT WAGES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 20 a J41 J42 J43 J44 Checkpoints 4.898,00 5.219,60 4.898,00 4.616,40 42.657,30 47.555,30 52.774,90 57.672,90 62.289,30 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 52.774,90 62.289,30 Credit Balance ACCOUNT: ACCOUNT NO. 56 PAYROLL TAXES DATE ITEM POST. REF. BALANCE DEBIT CREDIT DEBIT 20-- Oct. Nov. 1 Balance 9 23 6 13 20 a J41 J42 J43 J44 J45 Checkpoints 1.381,11 1.386,96 1.343,71 159,07 1.113,15 14.289,12 15.670,23 17.057,19 18.400,90 18.559,97 19.673,12 CREDIT Oct. 31, 20-Nov. 30, 20-Dec. 31, 20-- Debit Balance 17.057,19 19.673,12 Credit Balance Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T Regular Earnings Rate Per F S S M T W T F S Hrs. Hour For Period Ending October 3, 20-M 4 8 8 8 8 8 M 5 8 8 8 8 8 S 2 8 8 8 8 8 M 4 8 8 8 8 8 M 3 8 8 8 8 8 S 1 8 8 8 8 8 M 4 8 8 8 8 8 M 2 8 8 8 8 8 S 1 8 8 8 8 4 S 0 8 8 D 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17,60 80 80 80 80 80 80 18,00 80 72 14,00 80 TOTALS Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. M 4 8 8 8 8 8 4 Ferguson, J. M 5 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 Mann, D. M 4 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 Russell, V. S 1 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 Sokowski, T. M 2 8 8 8 8 8 (Student) S 1 8 8 8 8 4 Williams, R. S 0 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17,60 80 80 80 80 80 80 18,00 80 72 14,00 80 TOTALS Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. M 4 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 Russell, V. S 2 8 8 8 8 6 Ryan, N. M 4 8 8 8 8 8 Sokowski, T. S 2 8 8 8 8 8 (Student) S 1 8 8 8 8 4 Williams, R. S 0 8 8 8 7 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 8 80 17,60 80 80 80 80 78 80 18,00 80 72 14,00 79 TOTALS Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. S 0 6 8 7 7 6 D D 8 TOTALS GLO-BRITE PAINT COMPANY 6 8 136 Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 87,30 139,50 75,64 83,70 143,08 74,40 89,28 127,10 62,50 75,83 20,42 32,63 17,69 19,58 33,46 17,40 20,88 29,73 14,62 17,73 45,00 135,00 107,00 39,00 191,00 127,00 49,00 175,00 97,00 153,00 43,23 69,08 37,45 41,45 70,85 36,84 44,21 62,94 30,95 37,55 0,99 1,58 0,85 0,95 1,62 0,84 1,01 1,44 0,71 0,86 15.456,77 15.456,77 958,33 224,14 1.118,00 474,55 10,85 1.513,60 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.656,00 2.050,00 1.008,00 1.223,08 93,84 139,50 75,64 83,70 143,08 74,40 102,67 127,10 62,50 75,83 21,95 32,63 17,69 19,58 33,46 17,40 24,01 29,73 14,62 17,73 55,00 135,00 107,00 39,00 191,00 127,00 69,00 175,00 97,00 153,00 46,47 69,08 37,45 41,45 70,85 36,84 50,84 62,94 30,95 37,55 1,06 1,58 0,85 0,95 1,62 0,84 1,16 1,44 0,71 0,86 15.456,77 321,60 15.778,37 978,26 228,80 1.148,00 484,42 11,07 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 1.207,85 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 1.207,85 87,30 139,50 75,64 83,70 143,08 72,54 89,28 127,10 62,50 74,89 20,42 32,63 17,69 19,58 33,46 16,97 20,88 29,73 14,62 17,51 45,00 135,00 107,00 117,00 191,00 98,00 49,00 249,00 97,00 150,00 43,23 69,08 37,45 41,45 70,85 35,92 44,21 62,94 30,95 37,08 0,99 1,58 0,85 0,95 1,62 0,82 1,01 1,44 0,71 0,85 15.411,54 15.411,54 955,53 223,49 1.238,00 473,16 10,82 2.079,32 2.079,32 128,92 30,15 331,00 63,84 1,46 2.079,32 2.079,32 128,92 30,15 331,00 63,84 1,46 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 4 26,40 105,60 8 27,00 216,00 No. W/H Allow. NAME Marital Status PAYROLL REGISTER Time Record S M T W T TOTALS Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. TOTALS Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Regular Earnings Rate Per F S S M T W T F S Hrs. Hour Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A. M 4 8 8 8 8 8 Ferguson, J. M 5 8 8 8 8 8 8 Ford, C. S 2 8 8 8 8 8 8 Mann, D. M 0 8 8 8 8 8 8 O'Neill, J. M 3 8 8 8 8 8 8 Russell, V. S 2 6 8 8 8 8 8 Ryan, N. M 4 8 8 8 8 8 8 Sokowski, T. S 2 8 8 8 8 8 8 (Student) S 1 8 8 8 8 4 8 GLO-BRITE PAINT COMPANY 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 4 64 17,60 80 80 80 80 78 80 18,00 80 72 14,00 Amount Overtime Earnings Rate Per Hrs. Hour Amount Deductions Total Earnings OASDI HI FIT SIT SUTA 1.126,40 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 1.126,40 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 69,84 139,50 75,64 83,70 143,08 72,54 89,28 127,10 62,50 16,33 32,63 17,69 19,58 33,46 16,97 20,88 29,73 14,62 17,00 64,00 107,00 81,00 86,00 98,00 29,00 249,00 97,00 34,58 69,08 37,45 41,45 70,85 35,92 44,21 62,94 30,95 0,79 1,58 0,85 0,95 1,62 0,82 1,01 1,44 0,71 13.922,09 13.922,09 863,18 201,89 828,00 427,43 9,77 Deductions NAME Payday, October 9, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Williams, R. TOTALS Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. For Period Ending October 3, 20-54,92 8,00 87,76 47,58 52,66 90,01 46,80 56,17 8,00 79,96 39,32 47,71 602,89 0,00 16,00 TOTALS 615,43 181,20 16,00 TOTALS 601,12 0,00 16,00 81,10 14,40 0,00 0,00 0,00 HI 1.148,14 1.784,45 933,79 1.112,66 1.777,67 896,72 1.171,45 1.573,83 762,90 890,40 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.440,00 2.050,00 1.008,00 1.223,08 12.052,01 15.456,77 15.456,77 FUTA SUTA Admin. Office Sales Plant 1.408,00 2.250,00 700,00 1.350,00 1.220,00 1.350,00 Total earnings Net paid 15.456,77 12.052,01 1.220,00 1.350,00 2.307,69 760,00 1.200,00 1.200,00 1.440,00 2.050,00 1.008,00 1.008,00 3.818,00 4.778,00 1.008,00 1.223,08 2.307,69 4.651,08 3.600,00 4.898,00 1.211,74 1.758,05 919,39 1.096,76 1.750,67 882,62 1.318,93 1.549,83 751,20 876,00 1.513,60 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.656,00 2.050,00 1.008,00 1.223,08 1.513,60 2.250,00 1.220,00 1.350,00 2.307,69 1.200,00 1.656,00 2.050,00 1.008,00 1.223,08 12.115,19 15.778,37 15.778,37 1.513,60 2.250,00 250,00 1.220,00 1.350,00 Total earnings Net paid 15.778,37 12.115,19 1.220,00 1.350,00 2.307,69 1.200,00 1.200,00 1.656,00 2.050,00 442,00 1.008,00 692,00 4.778,00 1.008,00 1.223,08 2.307,69 4.651,08 3.600,00 5.219,60 Checkpoints 692 693 694 695 696 697 698 699 700 701 Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R. 81,10 14,40 702 TOTALS OASDI Checkpoints 682 683 684 685 686 687 688 689 690 691 0,00 Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A. 54,92 8,00 Ferguson, J. 87,76 Ford, C. 47,58 Mann, D. 52,66 O'Neill, J. 90,01 Russell, V. 45,63 Ryan, N. 56,17 8,00 Sokowski, T. 79,96 (Student) 39,32 Williams, R. 47,11 Amount Labor Cost Distribution Checkpoints 672 673 674 675 676 677 678 679 680 681 0,00 Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A. 59,04 16,50 8,00 Ferguson, J. 87,76 26,40 Ford, C. 47,58 14,40 Mann, D. 52,66 15,90 O'Neill, J. 90,01 27,00 Russell, V. 46,80 14,10 Ryan, N. 64,59 16,80 8,00 Sokowski, T. 79,96 24,00 (Student) 39,32 11,70 Williams, R. 47,71 14,40 Taxable Earnings 1.148,14 1.784,45 933,79 1.034,66 1.777,67 900,12 1.171,45 1.499,83 762,90 880,41 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 1.207,85 1.408,00 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 1.207,85 11.893,42 15.411,54 15.411,54 1.408,00 2.250,00 1.010,00 1.350,00 Total earnings Net paid 15.411,54 11.893,42 1.220,00 1.350,00 2.307,69 1.110,00 1.170,00 1.440,00 2.050,00 1.008,00 0,00 4.478,00 1.008,00 1.207,85 2.307,69 4.605,85 3.600,00 4.898,00 Checkpoints 1.428,45 2.079,32 2.079,32 1.428,45 2.079,32 2.079,32 2.079,32 0,00 0,00 0,00 2.079,32 Total earnings Net paid 0,00 0,00 2.079,32 1.428,45 Deductions NAME Net Paid CIT Group Ins. Union Dues Ck. SIMPLE No. October 9, 20, 20--20--For 3, 20-Payday, November ForPeriod PeriodEnding EndingOctober November 14, 20-Bonno, A. 43,93 16,50 8,00 703 Ferguson, J. 87,76 26,40 500,00 704 Ford, C. 47,58 14,40 705 Mann, D. 52,66 15,90 250,00 706 O'Neill, J. 90,01 27,00 700,00 707 Russell, V. 45,63 14,10 708 Ryan, N. 56,17 16,80 8,00 200,00 709 Sokowski, T. 79,96 24,00 710 (Student) 39,32 11,70 711 TOTALS 543,02 166,80 16,00 1.650,00 Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Russell, V. Ryan, N. Sokowski, T. (Student) Woods, B. Taxable Earnings Amount OASDI HI 919,43 1.329,05 919,39 804,76 1.155,67 886,02 974,65 1.475,83 751,20 1.126,40 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 1.126,40 2.250,00 1.220,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 9.216,00 13.922,09 13.922,09 FUTA Labor Cost Distribution SUTA Admin. Office Sales Plant Checkpoints 1.126,40 2.250,00 Total earnings Net paid 1.220,00 300,00 1.350,00 2.307,69 1.170,00 1.440,00 2.050,00 1.008,00 0,00 1.308,00 1.008,00 2.307,69 3.398,00 3.600,00 4.616,40 Checkpoints Total earnings Net paid TOTALS Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V. Checkpoints Total earnings Net paid TOTALS Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A. Ferguson, J. Ford, C. Mann, D. O'Neill, J. Ryan, N. Sokowski, T. (Student) Woods, B. Young, P. TOTALS Checkpoints Total earnings Net paid 13.922,09 9.216,00 DEPARTMENT OCCUPATION WORKS IN (STATE) Plant Mixer Operator PA SEX M F x S.S. ACCOUNT NO. 000-00-3481 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST BONNO Anthony $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $55,000 --$.30/M 20___ PAYDAY HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 $8 each pay REGULAR EARNINGS 80 80 80 64 17,60 17,60 17,60 17,60 AMOUNT OVERTIME EARNINGS HRS. RATE 10.293,40 1.408,00 1.408,00 1.408,00 1.126,40 4 26,40 OVERTIME RATE CUMULATIVE EARNINGS AMOUNT 1.028,60 0.00 105,60 0.00 0.00 0.00 0.00 11.322,00 12.730,00 14.243,60 15.651,60 16.778,00 MIDDLE Victor 17,60 26,40 W/H MARITAL ALLOW. STATUS 4 M DEDUCTIONS FICA OASDI 701,96 87,30 93,84 87,30 69,84 HI 164,17 20,42 21,95 20,42 16,33 FIT SIT 810,00 45,00 55,00 45,00 17,00 0,00 0,00 347,59 43,23 46,47 43,23 34,58 NET PAID SUTA CIT 7,93 0,99 1,06 0,99 0,79 SIMPLE 441,60 54,92 59,04 54,92 43,93 OTHER CK. DEDUCTIONS NO. 216,80 8,00 24,50 8,00 24,50 AMOUNT 8.631,95 1.148,14 1.211,74 1.148,14 919,43 672 682 692 703 QTR. TOT. YR. TOT. Checkpoint Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE) Sales Sales Manager PA SEX M F x S.S. ACCOUNT NO. 000-00-8645 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE NAME - LAST FIRST FERGUSON $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $88,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 80 80 80 RATE AMOUNT HRS. RATE 23.125,00 2.250,00 2.250,00 2.250,00 2.250,00 23.125,00 25.375,00 27.625,00 29.875,00 32.125,00 James 58.500 /yr. 1.125,00 28,13 MARITAL ALLOW. STATUS 5 M NET PAID FICA 1.433,75 139,50 139,50 139,50 139,50 OTHER HI 335,31 32,63 32,63 32,63 32,63 FIT 2.291,00 135,00 135,00 135,00 64,00 SIT SUTA 709,94 69,08 69,08 69,08 69,08 QTR. TOT. YR. TOT. Checkpoint Claude W/H DEDUCTIONS OASDI AMOUNT MIDDLE Checkpoint 16,19 1,58 1,58 1,58 1,58 CIT 901,97 87,76 87,76 87,76 87,76 SIMPLE CK. DEDUCTIONS NO. AMOUNT 132,30 26,40 500,00 26,40 673 683 693 704 17.304,54 1.784,45 1.758,05 1.784,45 1.329,05 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Executive Secretary x PA 000-00-4567 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE FORD $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $50,000--$.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 HRS. RATE 80 80 80 80 6.300,00 7.520,00 8.740,00 9.960,00 11.180,00 Louise W/H MARITAL ALLOW. STATUS 2 S DEDUCTIONS NET PAID FICA OASDI AMOUNT 6.300,00 1.220,00 1.220,00 1.220,00 1.220,00 YEAR-TO-DATE 1 CUMULATIVE Catherine 2.733,33 /mo. 640,00 16,00 24,00 390,60 75,64 75,64 75,64 75,64 OTHER HI FIT SIT 91,35 17,69 17,69 17,69 17,69 639,00 107,00 107,00 107,00 107,00 193,41 37,45 37,45 37,45 37,45 SUTA 4,41 0,85 0,85 0,85 0,85 CIT SIMPLE 245,73 47,58 47,58 47,58 47,58 CK. DEDUCTIONS NO. AMOUNT 37,80 4.697,70 933,79 919,39 933,79 919,39 674 684 694 705 14,40 14,40 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Sales Representative x PA 000-00-9352 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE MANN $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $53,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 80 80 80 RATE AMOUNT HRS. RATE 5.400,00 1.350,00 1.350,00 1.350,00 1.350,00 5.400,00 6.750,00 8.100,00 9.450,00 10.800,00 Wilson MARITAL ALLOW. STATUS 0 M NET PAID FICA 334,80 83,70 83,70 83,70 83,70 OTHER HI FIT SIT 78,30 19,58 19,58 19,58 19,58 332,00 39,00 39,00 117,00 81,00 165,78 41,45 41,45 41,45 41,45 SUTA 3,78 0,95 0,95 0,95 0,95 CIT 210,62 52,66 52,66 52,66 52,66 SIMPLE CK. DEDUCTIONS NO. AMOUNT 31,50 15,90 250,00 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS OASDI AMOUNT Dewey 2.925 /mo. 675,00 16,88 Checkpoint 15,90 675 685 695 706 4.243,22 1.112,66 1.096,76 1.034,66 804,76 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST President x PA 000-00-1534 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE O'NEILL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $90,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 AMOUNT HRS. RATE 80 80 80 80 42.692,27 44.999,96 47.307,65 49.615,34 51.923,03 Joseph 60.000 /yr. 1.153,85 28,85 Tyler W/H MARITAL ALLOW. STATUS 3 M DEDUCTIONS NET PAID FICA OASDI AMOUNT 42.692,27 2.307,69 2.307,69 2.307,69 2.307,69 YEAR-TO-DATE 10/9 CUMULATIVE EARNINGS HRS. 1 MIDDLE M F Administrative 2.646,92 143,08 143,08 143,08 143,08 OTHER HI 619,04 33,46 33,46 33,46 33,46 FIT 6.116,00 191,00 191,00 191,00 86,00 SIT SUTA 1.310,65 70,85 70,85 70,85 70,85 29,88 1,62 1,62 1,62 1,62 CIT 1.665,17 90,01 90,01 90,01 90,01 SIMPLE CK. DEDUCTIONS NO. AMOUNT 202,50 676 686 696 707 27,00 700,00 27,00 30.102,11 1.777,67 1.750,67 1.777,67 1.155,67 TR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Time Clerk x PA 000-00-6337 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RUSSELL $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $49,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/14 CUMULATIVE 80 80 78 78 RATE AMOUNT HRS. RATE 6.240,00 1.200,00 1.200,00 1.170,00 1.170,00 6.240,00 7.440,00 8.640,00 9.810,00 10.980,00 Aloise MARITAL ALLOW. STATUS 2 S NET PAID FICA 386,88 74,40 74,40 72,54 72,54 OTHER HI FIT SIT 90,48 17,40 17,40 16,97 16,97 642,00 127,00 127,00 98,00 98,00 191,56 36,84 36,84 35,92 35,92 SUTA 4,37 0,84 0,84 0,82 0,82 CIT SIMPLE 243,38 46,80 46,80 45,63 45,63 TR. TOT. YR. TOT. Checkpoint W/H DEDUCTIONS OASDI AMOUNT Virginia 2.730 /mo. 630,00 15,75 23,63 Checkpoint CK. DEDUCTIONS NO. AMOUNT 31,50 14,10 14,10 677 687 697 708 4.649,83 896,72 882,62 900,12 886,02 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Plant Electrician x PA 000-00-1223 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE RYAN Norman $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $56,000 -- $.30/M 20___ $8 each pay REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 OVERTIME RATE CUMULATIVE 80 80 80 80 18,00 18,00 18,00 18,00 AMOUNT 13.287,50 1.440,00 1.440,00 1.440,00 1.440,00 HRS. RATE 8 27,00 1.397,80 0.00 216,00 0.00 0.00 0.00 0.00 14.685,30 16.125,30 17.781,30 19.221,30 20.661,30 18,00 27,00 MARITAL ALLOW. STATUS 4 M DEDUCTIONS NET PAID FICA OASDI AMOUNT Allen W/H 910,49 89,28 102,67 89,28 89,28 OTHER HI 212,94 20,88 24,01 20,88 20,88 FIT 1.070,00 49,00 69,00 49,00 29,00 SIT SUTA 450,84 44,21 50,84 44,21 44,21 10,28 1,01 1,16 1,01 1,01 CIT 572,79 56,17 64,59 56,17 56,17 SIMPLE 200,00 CK. DEDUCTIONS NO. 235,70 8,00 24,80 8,00 24,80 AMOUNT 678 688 698 709 11.222,26 1.171,45 1.318,93 1.171,45 974,65 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Plant Supervisor x PA 000-00-8832 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE SOKOWSKI Thomas $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $80,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 CUMULATIVE 80 80 80 80 RATE AMOUNT HRS. RATE 16.650,00 2.050,00 2.050,00 2.050,00 2.050,00 16.650,00 18.700,00 20.750,00 22.800,00 24.850,00 1.025,00 25,63 STATUS 2 S NET PAID FICA 1.032,30 127,10 127,10 127,10 127,10 OTHER HI 241,43 29,73 29,73 29,73 29,73 FIT 2.002,00 175,00 175,00 249,00 249,00 SIT 511,16 62,94 62,94 62,94 62,94 SUTA 11,66 1,44 1,44 1,44 1,44 CIT SIMPLE 649,42 79,96 79,96 79,96 79,96 QTR. TOT. YR. TOT. Checkpoint MARITAL ALLOW. DEDUCTIONS OASDI AMOUNT James W/H Checkpoint CK. DEDUCTIONS NO. AMOUNT 94,50 24,00 24,00 679 689 699 710 12.107,53 1.573,83 1.549,83 1.499,83 1.475,83 OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Accounting Trainee PA Student OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $39,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. RATE AMOUNT 10/9 2 10/23 3 11/6 4 11/20 5 12/4 6 12/18 72 72 72 72 HRS. RATE 14,00 14,00 14,00 14,00 5.550,00 6.558,00 7.566,00 8.574,00 9.582,00 MARITAL STATUS 1 S DEDUCTIONS NET PAID FICA OASDI AMOUNT 5.550,00 1.008,00 1.008,00 1.008,00 1.008,00 YEAR-TO-DATE 1 CUMULATIVE 14,00 21,00 W/H ALLOW. 344,10 62,50 62,50 62,50 62,50 OTHER HI FIT SIT 80,48 14,62 14,62 14,62 14,62 409,00 97,00 97,00 97,00 97,00 170,38 30,95 30,95 30,95 30,95 SUTA 3,89 0,71 0,71 0,71 0,71 CIT SIMPLE 216,47 39,32 39,32 39,32 39,32 CK. DEDUCTIONS NO. AMOUNT 32,40 4.293,28 762,90 751,20 762,90 751,20 680 690 700 711 11,70 11,70 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Programmer x PA 000-00-6741 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE WILLIAMS $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $48,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 10/9 2 10/23 3 11/6 4 11/13 CUMULATIVE 80 80 79 136 RATE AMOUNT HRS. RATE Virginia W/H MARITAL ALLOW. STATUS 0 S DEDUCTIONS NET PAID FICA OASDI AMOUNT Ruth 2.650 /mo. 611,54 15,29 22,94 OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT 10.260,00 1.223,08 1.223,08 1.207,85 2.079,32 10.260,00 11.483,08 12.706,16 13.914,01 15.993,33 636,12 75,83 75,83 74,89 128,92 148,77 17,73 17,73 17,51 30,15 1.606,00 153,00 153,00 150,00 331,00 314,98 37,55 37,55 37,08 63,84 7,18 0,86 0,86 0,85 1,46 400,18 47,71 47,71 47,11 81,10 59,40 5.733,33 15.993,33 5.733,33 15.993,33 355,47 991,59 83,12 231,89 787,00 2.393,00 176,02 491,00 4,03 11,21 223,63 623,81 28,80 88,20 4.075,26 11.162,63 4.075,26 11.162,63 14,40 14,40 681 691 701 702 7.087,37 890,40 876,00 880,41 1.428,45 5 6 QTR. TOT. YR. TOT. 375 Checkpoint 5.733,33 15.993,33 Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Office Programmer x PA 000-00-1587 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE Woods $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE $47,000 -- $.30/M 20___ OVERTIME RATE REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE Anne W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS NET PAID FICA OASDI AMOUNT Beth 2.600 /mo. 600,00 15,00 OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 12/4 6 12/18 QTR. TOT. YR. TOT. Checkpoint Checkpoint OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F Sales Field Sales Representative x PA 000-00-6057 OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES Young Paul $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE $49,000 -- $.30/M 20___ REGULAR EARNINGS OVERTIME RATE OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT Winston 2.730 /mo. 630,00 15,75 STATUS 1 S NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE 1 2 3 4 5 12/18 QTR. TOT. YR. TOT. Checkpoint MARITAL ALLOW. DEDUCTIONS YEAR-TO-DATE 6 W/H Checkpoint CK. DEDUCTIONS NO. AMOUNT OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE $ $ $ $ SALARY UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY CUMULATIVE EARNINGS HRS. RATE AMOUNT HRS. RATE MARITAL STATUS DEDUCTIONS NET PAID FICA OASDI AMOUNT W/H ALLOW. OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. OCCUPATION DEPARTMENT WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE M F OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES $ $ $ $ SALARY OTHER WEEKLY RATE HOURLY RATE OVERTIME RATE 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY EARNINGS HRS. YEAR-TO-DATE 1 2 3 4 5 6 QTR. TOT. YR. TOT. CUMULATIVE RATE AMOUNT HRS. RATE AMOUNT W/H MARITAL ALLOW. STATUS DEDUCTIONS NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE CK. DEDUCTIONS NO. AMOUNT

Tutor Answer

TabbyK
School: UCLA

Hi, it's done. Just let me know in case of anything.

Excel Instructions
CAUTION: Read Appendix B for specific instructions relating to these templates.
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
2. A formula begins with an equals sign (=) and can consist of any of the following elements:
Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division).
Cell references, including cell addresses such as B52, as well as named cells and ranges
Values and text
Worksheet functions (such as SUM)
3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells.
To enter a formula manually, follow these steps:
Move the cell pointer to the cell that you want to hold the formula.
Type an equals sign (=) to signal the fact that the cell contains a formula.
Type the formula, then press Enter.
4. Rounding: These templates have been formatted to round numbers to either the nearest whole number or the nearest cent. For example,
17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding function.
5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time.
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name.
To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar.
It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx
To save under a different name, follow these steps:
Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx)
Select the folder in which to store the workbook.
Enter the new filename in the File name box.
Click Save.

Page 41

JOURNAL
DATE
20--

Oct.

DESCRIPTION

9 Payroll Cash
Cash

POST.
REF.

DEBIT

12
11

12.052,01

9 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Union Dues Payable
Payroll Cash

51
52
53
54
20,1
20,2
24
25
25,1
26
28
12

2.307,69
4.651,08
3.600,00
4.898,00

9 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20,1
20,2
21
22

1.381,11

CREDIT

12.052,01

958,33
224,14
1.118,00
474,55
10,85
602,89
16,00
12.052,01

958,32
224,12
22,91
175,76

20 Employees SIT Payable
Cash

25
11

474,55

23 Payroll Cash
Cash

12
11

12.115,19

474,55

12.115,19

Page 42

JOURNAL
DATE
20--

Oct.

Nov.

DESCRIPTION

POST.
REF.

DEBIT

23 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
Payroll Cash

51
52
53
54
20,1
20,2
24
25
25,1
26
27
28
12

2.307,69
4.651,08
3.600,00
5.219,60

23 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20,1
20,2
21
22

1.386,96

CREDIT

978,26
228,80
1.148,00
484,42
11,07
615,43
181,20
16,00
12.115,19

978,26
228,79
4,15
175,76

4 Employees SIT Payable
Cash

25
11

484,42

6 Union Dues Payable
Cash

28
11

32,00

484,42

32,00

Page 43

JOURNAL
DATE
20--

Nov.

DESCRIPTION

6 Payroll Cash
Cash

POST.
REF.

DEBIT

12
11

11.893,42

6 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Union Dues Payable
Payroll Cash

51
52
53
54
20,1
20,2
24
25
25,1
26
28
12

2.307,69
4.605,85
3.600,00
4.898,00

6 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
SUTA Taxes Payable - Employer

56
20,1
20,2
22

1.343,71

12
11

1.428,45

13 Payroll Cash
Cash

CREDIT

11.893,42

955,53
223,49
1.238,00
473,16
10,82
601,12
16,00
11.893,42

955,52
223,47
164,72

1.428,45

Page 44

JOURNAL
DATE
20--

Nov.

DESCRIPTION

POST.
REF.

DEBIT

13 Office Salaries
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Payroll Cash

52
20,1
20,2
24
25
25,1
26
27
12

2.079,32

13 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI

56
20,1
20,2

159,07

16 FICA Taxes Payabe-OASDI
FICA Taxes Payable-HI
Employee FIT Payable
Cash

20,1
20,2
24
11

3.873,17
905,85
2.266,00

16 Employee CIT Payable
Cash

26
11

1.218,32

18 Employees SIT Payable
Cash

25
11

537,00

20 Payroll Cash
Cash

12
11

9.216,00

51
52
53
54
20,1
20,2
24
25
25,1
26
27
28
29
12

2.307,69
3.398,00
3.600,00
4.616,40

20 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash

CREDIT

128,92
30,15
331,00
63,84
1,46
81,10
14,40
1.428,45

128,92
30,15

7.045,02

1.218,32

537,00

9.216,00

863,18
201,89
828,00
427,43
9,77
543,02
166,80
16,00
1.650,00
9.216,00

Page 45

JOURNAL
DATE
20--

Nov.

Dec.

DESCRIPTION

20 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
SUTA Taxes Payable - Employer

POST.
REF.

56
20,1
20,2
22

DEBIT

1.113,15
863,17
201,87
48,11

3 Employees SIT Payable
Cash

25
11

427,43

4 Payroll Cash
Cash

12
11

10.730,23

51
52
53
54
20,1
20,2
24
25
25,1
26
27
28
29
12

2.307,69
4.628,00
3.600,00
5.188,60

4 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
Fica Taxes Payabble - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash

CREDIT

427,43

10.730,23

974,92
228,02
1.018,00
482,76
11,03
613,33
0,00
16,00
1.650,00
10.730,20

Page 46

JOURNAL
DATE
20--

Dec.

DESCRIPTION

4 Payroll Taxes Expense
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer
9 Union Dues Payable
Cash

POST.
REF.

56
20,1
20,2
21
22

DEBIT

1.255,30
974,91
228,00
6,48
45,91

28
11

32,00

12
11

2.194,48

14 Office Salaries Expense
FICA Taxes Payable- OASDI
FICA Taxes Payable- HI
Employees SUTA Payable
Group Insurance Premiums Collected
Payroll Cash

52
20,1
20,2
25,1
27
12

2.394,00

14 Payroll Taxes Expense
FICA Taxes Payable- OASDI
FICA Taxes Payable- HI

56
20,1
20,2

183,14

15 Employees FIT Payable
FICA Taxes Payable- OASDI
FICA Taxes Payable- HI
Cash

24
20,1
20,2
11

2.397,00
3.895,24
911,02

15 Employees CIT Payable
Cash

26
11

1.225,24

18 Employees SIT Payable
Cash

25
11

482,76

18 Group Insurance Premiums Collected
Cash

27
11

14,70

18 Payroll Cash
Cash

12
11

45.348,73

14 Payroll Cash
Cash

CREDIT

32,00

2.194,48

148,43
34,71
1,68
14,70
2.194,48

148,43
34,71

7.203,26

1.225,24

482,76

14,70

45.348,73

Page 47

JOURNAL
DATE
20--

Jan.

DESCRIPTION

POST.
REF.

DEBIT

18 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash

51
52
53
54
20,1
20,2
24
25
25,1
26
27
28
29
12

77.307,69
3.474,00
4.860,00
5.509,40

18 Payroll Taxes
FICA Taxes Payable - OASDI
FICA Taxes Payable - HI
FUTA Taxes Payable
SUTA Taxes Payable - Employer

56
20,1
20,2
21
22

6.809,31

6 Employees SIT Payable
Cash

25
11

2.798,36

8 Union Dues Payable
Cash

28
11

34,00

15 Employees FIT Payable
FICA Taxes Payable- OASDI
FICA Taxes Payable- HI
Cash

24
20,1
20,2
11

CREDIT

5.382,37
1.321,70
27.530,73
2.798,36
63,83
3.555,27
182,10
18,00
4.950,00
45.348,73

5.382,37
1.321,69
14,76
90,49

2.798,36

34,00
28.548,73
13.011,43
3.396,27
44.956,43

Page 48

JOURNAL
DATE
20--

Jan.

Feb.

DESCRIPTION

15 Employees CIT Payable
Cash
1 FUTA Taxes Payable
Cash
1 SUTA Taxes Payable- Employer
Employees SUTA Payable
Cash

POST.
REF.

DEBIT

26
11

4.168,60

21
11

441,24

22
25,1
11

700,75
120,51

CREDIT

4.168,60

441,24

821,26

Page 49

JOURNAL
DATE
20--

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Page 50

JOURNAL
DATE
20--

DESCRIPTION

POST.
REF.

DEBIT

CREDIT

Total debits and credits (calculated automatically):
362.924,32 362.924,29
Your debits and credits should be equal after each journal entry is complete

Cumulative Journal Checkpoint Through Month Ending
58.644,96
124.528,47

October 31, 20-November 30, 20--

December 31, 20-January 31, 20--

GENERAL LEDGER

Checkpoints
ACCOUNT:

ACCOUNT NO. 11

CASH

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.

Dec.

1 Balance
9
20
23
4
6
6
13
16
16
16
20
3
4
9
14
15
15
18
18
18

a
J41
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J44
J45
J45
J45
J46
J46
J46
J46
J46

12.052,01
474,55
12.115,19
484,42
32,00
11.893,42
1.428,45
7.045,02
1.218,32
537,00
9.216,00
427,43
10.730,23
32,00
2.194,48
7.203,27
1.225,24
482,76
14,70
45.348,73

199.846,33
187.794,32
187.319,77
175.204,58
174.720,16
174.688,16
162.794,74
161.366,29
154.321,27
153.102,95
152.565,95
143.349,95
142.922,52
132.192,29
132.160,29
129.965,81
122.762,54
121.537,30
121.054,54
121.039,84
75.691,11

CREDIT

Debit
Balance
Oct. 31, 20-- 175.204,58
Nov. 30, 20-- 143.349,95
Dec. 31, 20-- 75.691,11

Credit
Balance

ACCOUNT:

ACCOUNT NO. 12

PAYROLL CASH

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.

Dec.

9
9
23
23
6
6
13
13
20
20
4
4
14
14
18

J41
J41
J41
J42
J43
J43
J43
J44
J44
J44
J44
J45
J45
J46
J46

Checkpoints

12.052,01
12.052,01
12.115,19
12.115,19
11.893,42
11.893,42
1.428,45
1.428,45
9.216,00
9.216,00
10.730,23
10.730,23
2.194,48
2.194,48
45.348,73
45.348,73

12.052,01
0,00
12.115,19
0,00
11.893,42
0,00
1.428,45
0,00
9.216,00
0,00
10.730,23
0,00
2.194,48
0,00
45.348,73
0,00

CREDIT

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Debit
Balance
0,00
0,00
0,00

Credit
Balance

ACCOUNT:

ACCOUNT NO. 20.1

FICA TAXES PAYABLE - OASDI

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.

Nov.

Dec

Jan.

9
9
23
23
6
6
13
13
16
20
20
4
4
14
14
15
18
18
15

J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
J45
J46
J46
J46
J46
J46
J47
J47

Checkpoints
Debit
Balance

958,33
958,32
978,26
978,26
955,53
955,52
128,92
128,92
3.873,17
863,18
863,17
974,92
974,91
148,43
148,43
3.895,25
5.382,37
5.382,37
13.011,43

958,33
1.916,65
2.894,91
3.873,17
4.828,70
5.784,22
5.913,14
6.042,06
2.168,89
3.032,07
3.895,24
4.870,16
5.845,07
5.993,50
6.141,93
2.246,68
7.629,05
13.011,42
-0,01

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
3.873,17
3.895,24
13.011,45

ACCOUNT:

ACCOUNT NO. 20.2

FICA TAXES PAYABLE - HI

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.

Nov.

Dec.

9
9
23
23
6
6
13
13
16
20
20
4
4
14
14
15
18
18

J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
J45
J46
J46
J46
J46
J47
J47

Checkpoints
Debit
Balance

224,14
224,12
228,80
228,79
223,49
223,47
30,15
30,15
905,85
201,89
201,87
228,02
228,00
34,71
34,71
911,02
1.321,70
1.321,69

224,14
448,26
677,06
905,85
1.129,34
1.352,81
1.382,96
1.413,11
507,26
709,15
911,02
1.139,04
1.367,04
1.401,75
1.436,46
525,44
1.847,14
3.168,83

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
905,85
911,02
3.168,83

ACCOUNT:

ACCOUNT NO. 21

FUTA TAXES PAYABLE

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.

Dec

1 Balance
9
23
4
18

a
J41
J42
J46
J47

Checkpoints
Debit
Balance

22,91
4,15
6,48
14,76

392,94
415,85
420,00
426,48
441,24

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
420,00
420,00
441,24

ACCOUNT:

ACCOUNT NO. 22

SUTA TAXES PAYABLE - EMPLOYER

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.
Nov.
Dec.

9
23
6
20
4
18

J41
J42
J43
J45
J45
J47

Checkpoints
Debit
Balance

175,76
175,76
164,72
48,11
45,91
90,49

175,76
351,52
516,24
564,35
610,26
700,75

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
351,52
564,35
700,75

ACCOUNT:

ACCOUNT NO. 24

EMPLOYEES FIT PAYABLE

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.
Nov.

Dec.

9
23
6
13
16
20
4
15
18

J41
J42
J43
J44
J44
J44
J45
J46
J47

Checkpoints
Debit
Balance

1.118,00
1.148,00
1.238,00
331,00
2.266,00
828,00
1.018,00
2.397,00
27.530,73

1.118,00
2.266,00
3.504,00
3.835,00
1.569,00
2.397,00
3.415,00
1.018,00
28.548,73

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
2.266,00
2.397,00
28.548,73

ACCOUNT:

ACCOUNT NO. 25

EMPLOYEES SIT PAYABLE

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.

Nov.

Dec.

Jan.

9
20
23
4
6
13
18
20
3
4
18
18
6

J41
J41
J42
J42
J43
J44
J44
J44
J45
J45
J46
J47
J47

Checkpoints
Debit
Balance

474,55
474,55
484,42
484,42
473,16
63,84
537,00
427,43
427,43
482,76
482,76
2.798,36
2.798,36

474,55
0,00
484,42
0,00
473,16
537,00
0,00
427,43
0,00
482,76
0,00
2.798,36
0,00

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
484,42
427,43
2.798,36

ACCOUNT:

ACCOUNT NO. 25.1

EMPLOYEES SUTA PAYABLE

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.
Nov.

Dec.

9
23
6
13
20
4
14
18

J41
J42
J43
J44
J44
J45
J46
J47

Checkpoints
Debit
Balance

10,85
11,07
10,82
1,46
9,77
11,03
1,68
63,83

10,85
21,92
32,74
34,20
43,97
55,00
56,68
120,51

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
21,92
43,97
120,51

ACCOUNT:

ACCOUNT NO. 26

EMPLOYEES CIT PAYABLE

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.
Nov.

Dec.

Jan.

9
23
6
13
16
20
4
15
18
15

J41
J42
J43
J44
J44
J44
J45
J46
J47
J48

Checkpoints
Debit
Balance

602,89
615,43
601,12
81,10
1.218,32
543,02
613,33
1.225,24
3.555,27
4.168,60

602,89
1.218,32
1.819,44
1.900,54
682,22
1.225,24
1.838,57
613,33
4.168,60
0,00

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
1.218,32
1.225,24
4.168,60

ACCOUNT:

ACCOUNT NO. 27

GROUP INSURANCE PREMIUMS COLLECTED

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.
Nov.
Dec.

23
13
20
14
18
18

J42
J44
J44
J46
J46
J47

Checkpoints
Debit
Balance

181,20
14,40
166,80
14,70
14,70
182,10

181,20
195,60
362,40
377,10
362,40
544,50

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
181,20
362,40
544,50

ACCOUNT:

ACCOUNT NO. 28

UNION DUES PAYABLE

DATE

ITEM

POST.
REF.

Checkpoints
Debit
Balance

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Oct.
Nov.

Dec.

Jan.

9
23
6
6
20
4
9
18
8

J41
J42
J42
J43
J44
J45
J46
J47
J47

16,00
16,00
32,00
16,00
16,00
16,00
32,00
18,00
34,00

16,00
32,00
0,00
16,00
32,00
48,00
16,00
34,00
0,00

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
32,00
32,00
34,00

ACCOUNT:

ACCOUNT NO. 29

SIMPLE CONTRIBUTIONS PAYABLE

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

CREDIT

20--

Nov.
Dce.

20
4
18

J44
J45
J47

Checkpoints
Debit
Balance

1.650,00
1.650,00
4.950,00

1.650,00
3.300,00
8.250,00

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Credit
Balance
0,00
1.650,00
8.250,00

ACCOUNT:

ACCOUNT NO. 51

ADMINISTRATIVE SALARIES

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.
Dec.

1 Balance
9
23
6
20
4
18

a
J41
J42
J43
J44
J45
J47

2.307,69
2.307,69
2.307,69
2.307,69
2.307,69
77.307,69

42.692,27
44.999,96
47.307,65
49.615,34
51.923,03
54.230,72
131.538,41

CREDIT

Checkpoints
Debit
Balance
Oct. 31, 20-- 47.307,65
Nov. 30, 20-- 51.923,03
Dec. 31, 20-- 131.538,41

Credit
Balance

ACCOUNT:

ACCOUNT NO. 52

OFFICE SALARIES

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.

Dec.

1 Balance
9
23
6
13
20
4
14
18

a
J41
J42
J43
J44
J44
J45
J46
J47

Checkpoints

4.651,08
4.651,08
4.605,85
2.079,32
3.398,00
4.628,00
2.394,00
3.474,00

28.350,00
33.001,08
37.652,16
42.258,01
44.337,33
47.735,33
52.363,33
54.757,33
58.231,33

CREDIT

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Debit
Balance
37.652,16
47.735,33
58.231,33

Credit
Balance

ACCOUNT:

ACCOUNT NO. 53

SALES SALARIES

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.
Dec.

1 Balance
9
23
6
20
4
18

a
J41
J42
J43
J44
J45
J47

Checkpoints

3.600,00
3.600,00
3.600,00
3.600,00
3.600,00
4.860,00

28.525,00
32.125,00
35.725,00
39.325,00
42.925,00
46.525,00
51.385,00

CREDIT

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Debit
Balance
35.725,00
42.925,00
51.385,00

Credit
Balance

ACCOUNT:

ACCOUNT NO. 54

PLANT WAGES

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.
Dec.

1 Balance
9
23
6
20
4
18

a
J41
J42
J43
J44
J45
J47

Checkpoints

4.898,00
5.219,60
4.898,00
4.616,40
5.188,60
5.509,40

42.657,30
47.555,30
52.774,90
57.672,90
62.289,30
67.477,90
72.987,30

CREDIT

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Debit
Balance
52.774,90
62.289,30
72.987,30

Credit
Balance

ACCOUNT:

ACCOUNT NO. 56

PAYROLL TAXES

DATE

ITEM

POST.
REF.

BALANCE

DEBIT

CREDIT

DEBIT

20--

Oct.

Nov.

Dec

1 Balance
9
23
6
13
20
4
14
18

a
J41
J42
J43
J44
J45
J46
J46
J47

Checkpoints

1.381,11
1.386,96
1.343,71
159,07
1.113,15
1.255,30
183,14
6.809,31

14.289,12
15.670,23
17.057,19
18.400,90
18.559,97
19.673,12
20.928,42
21.111,56
27.920,87

CREDIT

Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--

Debit
Balance
17.057,19
19.673,12
27.920,89

Credit
Balance

Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.

No. W/H Allow.

NAME

Marital Status

PAYROLL REGISTER
Time Record

S M T W T

Regular Earnings

Rate
Per
F S S M T W T F S Hrs. Hour

For Period Ending October 3, 20-M 4
8 8 8 8 8
M 5
8 8 8 8 8
S 2
8 8 8 8 8
M 4
8 8 8 8 8
M 3
8 8 8 8 8
S 1
8 8 8 8 8
M 4
8 8 8 8 8
M 2
8 8 8 8 8
S 1
8 8 8 8 4
S 0
8 8 D 8 8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
4
8

80 17,60
80
80
80
80
80
80 18,00
80
72 14,00
80

TOTALS
Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A.
M 4
8 8 8 8 8 4
Ferguson, J.
M 5
8 8 8 8 8
Ford, C.
S 2
8 8 8 8 8
Mann, D.
M 4
8 8 8 8 8
O'Neill, J.
M 3
8 8 8 8 8
Russell, V.
S 1
8 8 8 8 8
Ryan, N.
M 4
8 8 8 8 8
Sokowski, T.
M 2
8 8 8 8 8
(Student)
S 1
8 8 8 8 4
Williams, R.
S 0
8 8 8 8 8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8 8
8
4
8

80 17,60
80
80
80
80
80
80 18,00
80
72 14,00
80

TOTALS
Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A.
M 4
8 8 8 8 8
Ferguson, J.
M 5
8 8 8 8 8
Ford, C.
S 2
8 8 8 8 8
Mann, D.
M 0
8 8 8 8 8
O'Neill, J.
M 3
8 8 8 8 8
Russell, V.
S 2
8 8 8 8 6
Ryan, N.
M 4
8 8 8 8 8
Sokowski, T.
S 2
8 8 8 8 8
(Student)
S 1
8 8 8 8 4
Williams, R.
S 0
8 8 8 7 8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
8
8

8
8
8
8
8
8
8
8
4
8

80 17,60
80
80
80
80
78
80 18,00
80
72 14,00
79

TOTALS
Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R.
S 0
6 8 7 7 6
D D 8
TOTALS

GLO-BRITE PAINT COMPANY

6

8

136

Amount

Overtime Earnings
Rate
Per
Hrs. Hour

Amount

Deductions

Total
Earnings

OASDI

HI

FIT

SIT

SUTA

1.408,00
2.250,00
1.220,00
1...

flag Report DMCA
Review

Anonymous
Posted this and got four bids within 15 minutes. Clearly lots of tutors on the platform, quality was pretty legit too.

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors