Excel File Edit View Insert Format Tools Data Window Help 34%)D Sun Dec 16 10:22 AM Copy of Payroll Project Excel Template1 Search Sheet PayroHome Insert Draw Page Layout Formulas Data Review View Share ^ AutoSum Wrap Text E,E| |- | $, % ,1-oo.co| Conditional Format Cell Formatting as Table Sty es Merge & Center. Insert Delete Format Sort Clear Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates x Vf Excel Instructions A3 3 Exccl Instructions 4 CAUTION: Read Appendix B for specific instructions relating to these templates. 1. Ealee de aeropeiate nun bees/temula is the shaded Gran cella An aitetisk m will appear 10 de sight of aa incotteel aswet. B 2. A forila begins with an eqs sign consist af any af the folkuing ckment: 0 Cell efcrences, including cell addresses such as B52,s well as named cells and ss 1 Values and sext 13 14 3. You ean enter a formala ino a cell monually typing it in) ar hy pointing to the cells 1 To ente aformdmaly, follow hese stepac Move the cell pointer 1D Typeanols sig o signal the fact that the cell conains a formala Type the Comia then presEnles r to the cell th you nt o hol the fotmola 20 4. Roanding These templase have heen omottrd to roud numbers tn either the neaest whale number or the nest. For eaple, 23 5. Remember e your work. When sing yaur workboak, Exeel overwrises the previous copy of yaur file. Yoa an save your work at any time 24 Yoa cane e ile o he curentsor you may want so keep miple versions of yor work by swing each suecessive version under a ditferent 25 TO MPE the curent nane, you c sclect Hle, Sawe fromthe menu bar or cbck on the disk Kon in the saddend toolba. 26 It ix recommended the ywa save the file in a new name that identifics the file yours, sacht hapter_7 lang veruon Your Names! 27 To sae nder a differens name, follow dese siepa 28 Select File, Save As to display the Save As Type deop-box, chose Excel Workbookxlsx Select the falder in which ta store the workhook Ener the new ilename lo the Flle nane bo Click Sve. 32 34 36 Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records | + | Ready 16 JOURNAL POST REF DATE 20-- Oct DESCRIPTION DEBIT CREDIT 9 Payroll Cash Cash 12,052.01 12,052.01 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 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Pavable -OASD FICA Taxes Pavable - Hl Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 958.33 224.14 1,118.00 474.55 10.85 602.89 16.00 12,052.01 56 20.1 20.2 9 Payroll Taxes 1,381.11 FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Pavable Emplover 958.32 224.12 22.91 175.76 20 Employees SIT Paya 25 474.55 Cash 474.55 12 12,115.19 23 Pavroll Cash Cash 12,115.19 JOURNAL Page 42 POST REF DEBIT DATE 20-- Oct DESCRIPTION CREDIT 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 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable -OASDI FICA Taxes Payable HI Employees FIT Paya Employees SIT Paya Emplovees SUTA Pavable Employees CIT Pa Group Insurance Premiums Collected Union Dues Pavable Payroll Cash 978.26 228.80 1,148.00 484.42 11.07 615.43 181.20 16.00 12,115.19 ble ble yable 56 20.1 20.2 21 23Payroll Taxes 1,386.96 978.26 FICA Taxes Payable - OASDI FICA Taxes Payable HI FUTA Taxes Payable SUTA Taxes Payable Employer 228.79 4.15 175.76 Nov. 4 Employees SIT Paya ble 25 484.42 Cash 484.42 6 lUnion Dues Pavable 28 32.00 Cash 32.00 JOURNAL Page 43 POST REF DATE 20-- Nov DESCRIPTION DEBIT CREDIT 6 Payroll Cash Cash 12 11,893.4:2 11,893.4:2 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 6 Admin istrative Salaries Office Salaries Sales Salaries Plant Wages 2,307.69 4,605.85 3,600.00 4,898.00 FICA Taxes Pavable - OASDI FICA Taxes Pavable - HI Emplovees FIT Pavable Emplovees SIT Payable Emplovees SUTA Pavable Employees CIT Paya Union Dues Payable Payroll Cash 955.53 223.49 1,238.00 473.16 10.82 601.12 16.00 11,893.4:2 ble 56 20.1 20.2 6 lPavroll Taxes 1,343.71 FICA Taxes Pavable - OASDI FICA Taxes Pavable - HI SUTA Taxes Pavable - Emplover 955.52 223.47 164.72 13 Payroll Cash Cash 12 1,428.45 1,428.45 103 104 JOURNAL Page 44 POST REF 06 DATE 07 20-- 08 Nov 109 110 DESCRIPTION DEBIT CREDIT 13 Office Salaries 2,079.32 52 20.1 20.2 FICA Taxes Pavable -OASD FICA Taxes Pavable -HI Employees FIT Payable Employees SIT Payable Emplovees SUTA Pavable Emplovees CIT Payable Group Insurance Premiums Collected Payroll Cash 128.92 30.15 331.00 63.84 112 113 25 25.1 26 115 116 81.10 14.40 1,428.45 159.07 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 13 Payroll Taxes FICA Taxes Payable - OASD FICA Taxes Pavable - Hl 56 20.1 20.2 128.92 30.15 16 FICA Taxes Payabe-OASDI FICA Taxes Payable-HI Employee FIT Payable 20.1 20.2 3,873.17 905.85 2,266.00 Cash 7,045.02 16 Employee CIT Payable 26 1,218.32 Cash 1,218.32 18 Employees SIT Payable 537.00 Cash 537.00 9,216.00 20 Payroll Cash Cash 9,216.00 20 Administrative Salaries 2,307.69 3,398.00 Office Salaries 52 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 29 12 20 Administrative Salaries Office Salaries Sales Salaries Plant Wages 2,307.69 3,398.00 3,600.00 4,616.40 FICA Taxes Payable - OASDI FICA Taxes Pavable HI Employees FIT Paya Employees SIT Payable Employees SUTA Payable Employees CIT Paya Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Pavable Payroll Cash 863.18 201.89 828.00 427.43 9.77 543.02 166.80 16.00 1,650.00 9,216.00 ble ble JOURNAL Page 45 POST REF DATE 20-- Nov DESCRIPTION DEBIT CREDIT 56 20.1 20.2 20 Payroll Taxes 1,113,15 FICA Taxes Payable - OASDI FICA Taxes Payable -HI SUTA Taxes Pavable - Emplover 863.17 201.87 48.11 4 5 789012345678901234567890123456789 JOURNAL Page 47- POST. REF DATE 20-- DESCRIPTION DEBIT CREDIT JOURNAL Page 48 POST REF DATE 20- DESCRIPTION DEBIT CREDIT JOURNAL Page 49 POST REF DESCRIPTION DEBIT DATE 20- CREDIT AG AH Al AL AO AQ AR AS AT AU Net Pald Taxable Eamin Labor Cost Distribution Group Union Ck. NAME Ins. Dues SIMPLE No. AmountOASDI HI FUTA Admin Plant 5 Payday, October 9, 20- 6 Bonno, A 672 1,14814 1408.00 14 673 1,784.45 08.00 2,250.00 2,250.00 933.79,220.00,220.00 Check Total eamings- 15,456.771 1.408.00 Net paid 12,052.01 8 Ford. C 9 Mann, D 0 O'Neill, J 11 Russell, V 675 1.112.66 1,350.00 1,350.00 1,350.001,350.00 1,350.00 676 1,777.67 2.307.69 2,307.69 896.721,200.00 1,200.00 678 1,171.45 1,440.001,440.00 6791,573.83 2.050.00 2,050.00 2,307.69 60.00 1,200.00 1,200.00 13 Sokowski, T 680 762.90 1,008.001,008.00 1,008.001,008.00 1,008.00 15 Williams, R. 890.40 1,223.08 1,223.08 19TOTALS 12.052011 15.45677|||54567 3.818.0 4778.00 2.307.691 4551.081 3.500.001 4.898.00 heck Total eamings 15,778.37 Payday. October 23, 20- F 1801 8.00 682 1,211.74 1,513.60 1,513.60 683 1,758.05 2,250.00 2,250.00 919.391220.00 1,220.00 1.350.00 1,350.00 686 1,750.672,307.69 2,307.69 882.621 1.200.001 1,200.00 688 1,318.93 1.656.00 1,656.00 6891,549.83 2.050.00 2,050.00 Net paid 12,115.19 1,350.00 24 Mann, D 25 O'Neill, J 6851,096.76 250.001,350.00 2,307.69 26 Russell, V 28 Sokowski, T 30 Williams, R. 1,200.00 2.050.00 690 751.20 1,008.001,008.00 442.001,008.00 1,008.00 876.001,223.08 1,223.08 34 TOTALS 181.20 16.00 12,115.19 15,778.3715,778.37 692.00 4,778.00 2,307.69 4,651.08 3,600.00 5,219.60 heck Total eamings15,411.54 November 6, 20- 36 Bonno, A 692 1,148.14 1,408.001,408.00 693 1,784.45 2,250.00 2,250.00 1.408.00 Net paid 11,893.42 Excel File Edit View Insert Format Tools Data Window Help 34%)D Sun Dec 16 10:22 AM Copy of Payroll Project Excel Template1 Search Sheet PayroHome Insert Draw Page Layout Formulas Data Review View Share ^ AutoSum Wrap Text E,E| |- | $, % ,1-oo.co| Conditional Format Cell Formatting as Table Sty es Merge & Center. Insert Delete Format Sort Clear Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates x Vf Excel Instructions A3 3 Exccl Instructions 4 CAUTION: Read Appendix B for specific instructions relating to these templates. 1. Ealee de aeropeiate nun bees/temula is the shaded Gran cella An aitetisk m will appear 10 de sight of aa incotteel aswet. B 2. A forila begins with an eqs sign consist af any af the folkuing ckment: 0 Cell efcrences, including cell addresses such as B52,s well as named cells and ss 1 Values and sext 13 14 3. You ean enter a formala ino a cell monually typing it in) ar hy pointing to the cells 1 To ente aformdmaly, follow hese stepac Move the cell pointer 1D Typeanols sig o signal the fact that the cell conains a formala Type the Comia then presEnles r to the cell th you nt o hol the fotmola 20 4. Roanding These templase have heen omottrd to roud numbers tn either the neaest whale number or the nest. For eaple, 23 5. Remember e your work. When sing yaur workboak, Exeel overwrises the previous copy of yaur file. Yoa an save your work at any time 24 Yoa cane e ile o he curentsor you may want so keep miple versions of yor work by swing each suecessive version under a ditferent 25 TO MPE the curent nane, you c sclect Hle, Sawe fromthe menu bar or cbck on the disk Kon in the saddend toolba. 26 It ix recommended the ywa save the file in a new name that identifics the file yours, sacht hapter_7 lang veruon Your Names! 27 To sae nder a differens name, follow dese siepa 28 Select File, Save As to display the Save As Type deop-box, chose Excel Workbookxlsx Select the falder in which ta store the workhook Ener the new ilename lo the Flle nane bo Click Sve. 32 34 36 Excel Instructions Journal General Ledger Payroll Register Employees' Earnings Records | + | Ready 16 JOURNAL POST REF DATE 20-- Oct DESCRIPTION DEBIT CREDIT 9 Payroll Cash Cash 12,052.01 12,052.01 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 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Pavable -OASD FICA Taxes Pavable - Hl Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable Union Dues Payable Payroll Cash 958.33 224.14 1,118.00 474.55 10.85 602.89 16.00 12,052.01 56 20.1 20.2 9 Payroll Taxes 1,381.11 FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Pavable Emplover 958.32 224.12 22.91 175.76 20 Employees SIT Paya 25 474.55 Cash 474.55 12 12,115.19 23 Pavroll Cash Cash 12,115.19 JOURNAL Page 42 POST REF DEBIT DATE 20-- Oct DESCRIPTION CREDIT 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 Administrative Salaries Office Salaries Sales Salaries Plant Wages FICA Taxes Payable -OASDI FICA Taxes Payable HI Employees FIT Paya Employees SIT Paya Emplovees SUTA Pavable Employees CIT Pa Group Insurance Premiums Collected Union Dues Pavable Payroll Cash 978.26 228.80 1,148.00 484.42 11.07 615.43 181.20 16.00 12,115.19 ble ble yable 56 20.1 20.2 21 23Payroll Taxes 1,386.96 978.26 FICA Taxes Payable - OASDI FICA Taxes Payable HI FUTA Taxes Payable SUTA Taxes Payable Employer 228.79 4.15 175.76 Nov. 4 Employees SIT Paya ble 25 484.42 Cash 484.42 6 lUnion Dues Pavable 28 32.00 Cash 32.00 JOURNAL Page 43 POST REF DATE 20-- Nov DESCRIPTION DEBIT CREDIT 6 Payroll Cash Cash 12 11,893.4:2 11,893.4:2 51 52 53 54 20.1 20.2 24 25 25.1 26 28 12 6 Admin istrative Salaries Office Salaries Sales Salaries Plant Wages 2,307.69 4,605.85 3,600.00 4,898.00 FICA Taxes Pavable - OASDI FICA Taxes Pavable - HI Emplovees FIT Pavable Emplovees SIT Payable Emplovees SUTA Pavable Employees CIT Paya Union Dues Payable Payroll Cash 955.53 223.49 1,238.00 473.16 10.82 601.12 16.00 11,893.4:2 ble 56 20.1 20.2 6 lPavroll Taxes 1,343.71 FICA Taxes Pavable - OASDI FICA Taxes Pavable - HI SUTA Taxes Pavable - Emplover 955.52 223.47 164.72 13 Payroll Cash Cash 12 1,428.45 1,428.45 103 104 JOURNAL Page 44 POST REF 06 DATE 07 20-- 08 Nov 109 110 DESCRIPTION DEBIT CREDIT 13 Office Salaries 2,079.32 52 20.1 20.2 FICA Taxes Pavable -OASD FICA Taxes Pavable -HI Employees FIT Payable Employees SIT Payable Emplovees SUTA Pavable Emplovees CIT Payable Group Insurance Premiums Collected Payroll Cash 128.92 30.15 331.00 63.84 112 113 25 25.1 26 115 116 81.10 14.40 1,428.45 159.07 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 13 Payroll Taxes FICA Taxes Payable - OASD FICA Taxes Pavable - Hl 56 20.1 20.2 128.92 30.15 16 FICA Taxes Payabe-OASDI FICA Taxes Payable-HI Employee FIT Payable 20.1 20.2 3,873.17 905.85 2,266.00 Cash 7,045.02 16 Employee CIT Payable 26 1,218.32 Cash 1,218.32 18 Employees SIT Payable 537.00 Cash 537.00 9,216.00 20 Payroll Cash Cash 9,216.00 20 Administrative Salaries 2,307.69 3,398.00 Office Salaries 52 51 52 53 54 20.1 20.2 24 25 25.1 26 27 28 29 12 20 Administrative Salaries Office Salaries Sales Salaries Plant Wages 2,307.69 3,398.00 3,600.00 4,616.40 FICA Taxes Payable - OASDI FICA Taxes Pavable HI Employees FIT Paya Employees SIT Payable Employees SUTA Payable Employees CIT Paya Group Insurance Premiums Collected Union Dues Payable SIMPLE Contributions Pavable Payroll Cash 863.18 201.89 828.00 427.43 9.77 543.02 166.80 16.00 1,650.00 9,216.00 ble ble JOURNAL Page 45 POST REF DATE 20-- Nov DESCRIPTION DEBIT CREDIT 56 20.1 20.2 20 Payroll Taxes 1,113,15 FICA Taxes Payable - OASDI FICA Taxes Payable -HI SUTA Taxes Pavable - Emplover 863.17 201.87 48.11 4 5 789012345678901234567890123456789 JOURNAL Page 47- POST. REF DATE 20-- DESCRIPTION DEBIT CREDIT JOURNAL Page 48 POST REF DATE 20- DESCRIPTION DEBIT CREDIT JOURNAL Page 49 POST REF DESCRIPTION DEBIT DATE 20- CREDIT AG AH Al AL AO AQ AR AS AT AU Net Pald Taxable Eamin Labor Cost Distribution Group Union Ck. NAME Ins. Dues SIMPLE No. AmountOASDI HI FUTA Admin Plant 5 Payday, October 9, 20- 6 Bonno, A 672 1,14814 1408.00 14 673 1,784.45 08.00 2,250.00 2,250.00 933.79,220.00,220.00 Check Total eamings- 15,456.771 1.408.00 Net paid 12,052.01 8 Ford. C 9 Mann, D 0 O'Neill, J 11 Russell, V 675 1.112.66 1,350.00 1,350.00 1,350.001,350.00 1,350.00 676 1,777.67 2.307.69 2,307.69 896.721,200.00 1,200.00 678 1,171.45 1,440.001,440.00 6791,573.83 2.050.00 2,050.00 2,307.69 60.00 1,200.00 1,200.00 13 Sokowski, T 680 762.90 1,008.001,008.00 1,008.001,008.00 1,008.00 15 Williams, R. 890.40 1,223.08 1,223.08 19TOTALS 12.052011 15.45677|||54567 3.818.0 4778.00 2.307.691 4551.081 3.500.001 4.898.00 heck Total eamings 15,778.37 Payday. October 23, 20- F 1801 8.00 682 1,211.74 1,513.60 1,513.60 683 1,758.05 2,250.00 2,250.00 919.391220.00 1,220.00 1.350.00 1,350.00 686 1,750.672,307.69 2,307.69 882.621 1.200.001 1,200.00 688 1,318.93 1.656.00 1,656.00 6891,549.83 2.050.00 2,050.00 Net paid 12,115.19 1,350.00 24 Mann, D 25 O'Neill, J 6851,096.76 250.001,350.00 2,307.69 26 Russell, V 28 Sokowski, T 30 Williams, R. 1,200.00 2.050.00 690 751.20 1,008.001,008.00 442.001,008.00 1,008.00 876.001,223.08 1,223.08 34 TOTALS 181.20 16.00 12,115.19 15,778.3715,778.37 692.00 4,778.00 2,307.69 4,651.08 3,600.00 5,219.60 heck Total eamings15,411.54 November 6, 20- 36 Bonno, A 692 1,148.14 1,408.001,408.00 693 1,784.45 2,250.00 2,250.00 1.408.00 Net paid 11,893.42
