60.1K

Verified Solution

Link Copied!

I'm working on a payroll accounting project in which I need to setup an excel payroll spreadsheet, however I'm having an issue in one section to balance my payroll taxes. The correct number for my balanced payroll should be 28,098.13, however I'm coming up with 28,057.86. I'm off by 40.27. Can anyone review the following screenshots & help me determine where I went wrong (the payroll screenshots seem to be squeezed small due to their width. Try right-clicking and open in a new window, to enlarge)? I've spent countless hours trying to figure this out with no success.

The total is based on 3 dates: Dec 4th, Dec 14th, & Dec 18th:

Dec 4th Payroll (I've highlighted the records I've used to calculate my payroll taxes):

Here's my Dec 4th Journal entry:

Here's Dec 14th Payroll (only 1 record):

Here's Dec 14th Journal:

Dec 18th Payroll:

Dec 18th Journal:

And finally, here's my Ledger. Again, my balanced payroll should be 28,098.13, however I'm coming up with 28,057.86. I'm off by 40.27:

Any idea what I'm doing wrong?

Thanks

Deductions Not Paid Labor Cost Ck. FIT CIT Dues SIMPLE No. AmountOASD FUTA NAME Hi HI SUTA Admin Sales Plant TOTALS 863.18 201.89 639.00 427.43 8.34541.67 281.60 24.50 18.56 2,307.69 143.08 33.46 1,689.60 104.76 139.50 9.38 83.70 8.00 80 1,889.80 250.00 280.00 1,280.00 836.94 1,350.00 1,350.00 00.00 716 1,200.13 2,307.69 2,307.89 712 1,372.72 1 00.00 713 51,368.90 250.00715 7 250.00 39.30 49.80 714 1,000.21 1,280.00 92.00 65.00 Mann, D Noil, J 78.12 1,260.00 81.001.449.00 2,050.00 18.27 29.73 15.66 90.00 985.151 1,449.00 050.00 8.00 200,00 718 1,011.42 1449.001449.00 1,008.01,008.00 1,008.00 1,080.00 66.96 87.00 0.65 834.55 1,080.00 1,080.00 1,008.00 TOTALS POST REF DESCRIPTION DEBIT DATE 20 CREDIT 4 Payroll Taxes 56 20.1 20.2 1,224.38 974.91 228.00 15.42 6.05 FICA Taxes Payable -OASDI FICA Taxes Payable - HI SUTA Taxes Payable-Employer FUTA Taxes Payable Per Hour Amount Group Union Total Ins. Dues SIMPLE No. Amount OASDI Plan ASDI FIT SIT SUTA CIT HI FUTA SUTA 183.14 56 20.1 20.2 14 Payroll Taxes Expenses 148.43 34.71 FICA Taxes Payable -OASDI FICA Taxes Payable H axable Rate Geoup Union Ck. Dues SIMPLE No. Total Amount Hrs. HourAmount FIT CIT Amount HI Pant Paydey, December 18. 20 Bonno, A 51.00 69.08 250.00 1.280.00 79.36 ,280.00 1.280.00 Mann, D ONel 7.307.69 4.598.48 1.120.96 373.35 48.38 27.00 00200.00 728 79.7624.00 11.70 5.00 14.70 TOTALS 90,539.69 611.4091.151.09 5.456.7 321 2.798.36 54.7 3,546.41 182.10 18.00 4.950.00 47.650.34 88.012.68 91.151.09 2,460.002 2.460.00 307.693.474.004,860.00 5.509.40 6,883.99 56 20.1 20.2 21 18 Payroll Taxes 5,456.79 1,321.69 14.76 90.75 FICA Taxes Payable -OASDI FICA Taxes Payable Hl FUTA Taxes Payable SUTA Taxes Payable- Employeer ACCOUNT NO. 56 ACCOUNT PAYROLL TAXES POST REF 1 BALANCE DEBIT DATE 20 Oct. TEM DEBIT CREDIT CREDIT 1 Balance 23 13 14,353.07 15,734.68 17,122.14 18,476.28 18,635.35 19,766.35 20,990.73 21,173.87 28,057.86 1,381.61 1,387.46 1,354.14 159.07 1,131.00 1,224.38 183.14 6,883.99 J41 J42 J43 J44 J45 J46 J46 J47 7 Nov 4 Dec 4 18 Deductions Not Paid Labor Cost Ck. FIT CIT Dues SIMPLE No. AmountOASD FUTA NAME Hi HI SUTA Admin Sales Plant TOTALS 863.18 201.89 639.00 427.43 8.34541.67 281.60 24.50 18.56 2,307.69 143.08 33.46 1,689.60 104.76 139.50 9.38 83.70 8.00 80 1,889.80 250.00 280.00 1,280.00 836.94 1,350.00 1,350.00 00.00 716 1,200.13 2,307.69 2,307.89 712 1,372.72 1 00.00 713 51,368.90 250.00715 7 250.00 39.30 49.80 714 1,000.21 1,280.00 92.00 65.00 Mann, D Noil, J 78.12 1,260.00 81.001.449.00 2,050.00 18.27 29.73 15.66 90.00 985.151 1,449.00 050.00 8.00 200,00 718 1,011.42 1449.001449.00 1,008.01,008.00 1,008.00 1,080.00 66.96 87.00 0.65 834.55 1,080.00 1,080.00 1,008.00 TOTALS POST REF DESCRIPTION DEBIT DATE 20 CREDIT 4 Payroll Taxes 56 20.1 20.2 1,224.38 974.91 228.00 15.42 6.05 FICA Taxes Payable -OASDI FICA Taxes Payable - HI SUTA Taxes Payable-Employer FUTA Taxes Payable Per Hour Amount Group Union Total Ins. Dues SIMPLE No. Amount OASDI Plan ASDI FIT SIT SUTA CIT HI FUTA SUTA 183.14 56 20.1 20.2 14 Payroll Taxes Expenses 148.43 34.71 FICA Taxes Payable -OASDI FICA Taxes Payable H axable Rate Geoup Union Ck. Dues SIMPLE No. Total Amount Hrs. HourAmount FIT CIT Amount HI Pant Paydey, December 18. 20 Bonno, A 51.00 69.08 250.00 1.280.00 79.36 ,280.00 1.280.00 Mann, D ONel 7.307.69 4.598.48 1.120.96 373.35 48.38 27.00 00200.00 728 79.7624.00 11.70 5.00 14.70 TOTALS 90,539.69 611.4091.151.09 5.456.7 321 2.798.36 54.7 3,546.41 182.10 18.00 4.950.00 47.650.34 88.012.68 91.151.09 2,460.002 2.460.00 307.693.474.004,860.00 5.509.40 6,883.99 56 20.1 20.2 21 18 Payroll Taxes 5,456.79 1,321.69 14.76 90.75 FICA Taxes Payable -OASDI FICA Taxes Payable Hl FUTA Taxes Payable SUTA Taxes Payable- Employeer ACCOUNT NO. 56 ACCOUNT PAYROLL TAXES POST REF 1 BALANCE DEBIT DATE 20 Oct. TEM DEBIT CREDIT CREDIT 1 Balance 23 13 14,353.07 15,734.68 17,122.14 18,476.28 18,635.35 19,766.35 20,990.73 21,173.87 28,057.86 1,381.61 1,387.46 1,354.14 159.07 1,131.00 1,224.38 183.14 6,883.99 J41 J42 J43 J44 J45 J46 J46 J47 7 Nov 4 Dec 4 18

Answer & Explanation Solved by verified expert

See Answer