Question

1 Approved Answer

Posted on Jul 18, 2024

need help finishing 2021 part a tax deposit template data comes from bieg and toalnd payroll accounting 2021 chapter 7 appendix a Summary of Quarterly

need help finishing 2021 part a tax deposit template

data comes from bieg and toalnd payroll accounting 2021 chapter 7 appendix a

image text in transcribed

Summary of Quarterly Totals After completing the payroll registers and employee earnings record, use this form to summarize the quarterly totals and compute the employer's payroll taxes for OASDI, HI, FUTA, and SUTA. Use the round function when computing taxes. The format is: round(cell reference * tax rate, 2). The summary will help you complete the deposits and forms. Use Excel formulas throughout. (Complete all colored cells.) October and November are partailly completed for you, but formulas have been removed. The October 941 taxes have been provided to guide your calculations for November and December. OASDI Wage HI Wage ER HI Tax FUTA Wage ER OASDI Tax Tax Q4 941 Taxes Total Earnings OASDI HI FIT SIT SUTA CIT Simple Withholding Withholding Withholding Withholding Withholding Withholding Pension 9-Oct 15,456.77 958.33 224.14 836.00 474.55 9.25 598.37 23-Oct 15,778.37 978.26 228.80 868.00 484.42 9.45 610.81 31,235.14 1,936.59 452.94 1,704.00 958.97 18.70 1,209.18 15,456.77 15,778.37 31,235.14 958.32 978.26 1,936.58 15,456.77 15,778.37 31,235.14 224.12 228.79 452.91 3,818.00 692.00 4,510.00 ER FUTA SUTA Wage ER SUTA Tax 22.91 4,778.00 176.26 4.15 4,778.00 176.26 27.06 9,556.00 352.52 Monthly Total 6,483.02 4,748.00 6-Nov 13-Nov 20-Nov Monthly Total 15,411.54 2,079.32 13,922.09 31,412.95 955.53 128.92 863.18 1,947.63 223.49 30.15 201.89 455.53 897.00 193.00 605.00 1,695.00 473.16 63.84 427.43 964.43 9.22 1.25 8.34 18.81 596.62 80.49 538.96 1,216.07 15,411.54 2,079.32 13,922.09 31,412.95 955.52 128.92 863.17 1,947.61 15,411.54 2,079.32 13,922.09 31,412.95 223.47 30.15 201.87 455.49 175.15 0 65.96 241.11 1,650.00 1,650.00 1,788.00 6,536.00 4-Dec 14-Dec 18-Dec Monthly Total Quarterly Totals Enter tax rates in table below. Link these cells when creating your formulas above. Tax Rate OASDI 6.20% HI 1.45% FUTA 0.60% SUTA ER 3.6890% Note: The transaction numbers correspond to the transaction numbers in your text. See the text for additional instructions. Transaction No. 9 Sample Federal Deposit Information Worksheet Employer Identification Number 00-0000660 Name Glo-Brite Paint Compan Month Tax Year Ends 12 Amount of Deposit 6,483.02 Type of Tax (Form Number) 941 Tax Period 4th Qtr Phone Number (215) 555-9559 Address City, State, Zip 2215 Salvador St. Philadelphia, PA 19175-0682 Transaction No. 22 D Federal Deposit Information Worksheet Employer Identification Number Name Month Tax Year Ends Amount of Deposit Type of Tax (Form Number) Tax Period Phone Number Address City, State, Zip Transaction No. 30 D Federal Deposit Information Worksheet Employer Identification Number Name Month Tax Year Ends Amount of Deposit Type of Tax (Form Number) Tax Period Phone Number Address City, State, Zip Note: The transaction numbers correspond to the transaction numbers in your text. See the text for additional instructions. Transaction No. 12 Sample State Filing Information Worksheet Company Name Glo-Brite Paint Co. Payment Frequency Semi-monthly Employer Account # 3300 Gross Compensation 17,490.86 Employer ID # 00-0000660 PA Withholding Tax 537.00 Employer Password GBPCOM Credits Quarter Ending Date 12/31/XX Interest Telephone Number (215) 555-9559 Payment 537.00 Transaction No. 16 State Filing Information Worksheet Company Name Payment Frequency Employer Account # Gross Compensation Employer ID # PA Withholding Tax Employer Password Credits Quarter Ending Date Interest Telephone Number Payment Transaction No. 24 Deposit of Dec 4th SIT Withheld State Filing Information Worksheet Company Name Payment Frequency Employer Account # Gross Compensation Employer ID # PA Withholding Tax Employer Password Credits Quarter Ending Date Interest Telephone Number Payment Transaction No. 28 State Filing Information Worksheet Deposit of Dec 18th SIT Withheld Total Quarter 4 State Income Tax Deposits (sum J16+J32+J48+J64) Company Name Payment Frequency Employer Account # Gross Compensation Employer ID # PA Withholding Tax Employer Password Credits Quarter Ending Date Interest Telephone Number Payment Note: The transaction numbers correspond to the transaction numbers in your text. See the text for additional instructions. Transaction No. 10 Sample Monthly Wage Tax 1 Tax Due GLO-BRITE PAINT COMPANY 2215 SALVADOR STREET PHILADELPHLA, PA 19175-0662 Account #: 0001855 Tax Type: '01 Period/Yr 10/XX From: 10/1 To: 10/31 Due Date: 11/16 1,209.18 Deposit of October CIT Taxes 2 Interest and Penalty See Summary of Quarterly Totals for data used to compute this value. Signature: Sopko Philadelphia Revenue Department P.O. Box 3040 Philadelphia, PA 19101-8040 3 Total Due (Line 1 & 2) 1,209.18 Make checks payable to: CITY OF PHILADELPHIA Phone #: (215) 555-9559 Transaction No. 23 Deposit of November CIT withhed Monthly Wage Tax 1 Tax Due GLO-BRITE PAINT COMPANY 2215 SALVADOR STREET PHILADELPHLA, PA 19175.0682 Account #: "0001855 Tax Type: '01 Period/Yr 10/XX From: 11/1 To: 11/30 Due Date: 12/15 2 Interest and Penalty 3 Total Due (Line 1 & 2) Signature: Philadelphia Revenue Department P.O. Box 3040 Philadelphia, PA 19101-8040 Make checks payable to CITY OF PHILADELPHIA Phone #: Transaction No. 31 Deposit of December CIT Withheld Monthly Wage Tax 1 Tax Due CLO-HITE PAINT COMPANY 2215 SALVADOR STREET PHILADELPHIA, PA 19175.0632 Account #: 0001855 Tax Type: 01 Period/Yr 10/XX From: 12/1 To: 12/31 Due Date: 1/15 2 Interest and Penalty 3 Total Due (Line 1 & 2) Signature: Philadelphia Revenue Department P.O. Box 3040 Philadelphia, PA 19101-8040 Make checks payable to: CITY OF PHILADELPHIA Phone #: Total Quarter 4 City Income Tax Deposits (sum L11+L25+L39) Summary of Quarterly Totals After completing the payroll registers and employee earnings record, use this form to summarize the quarterly totals and compute the employer's payroll taxes for OASDI, HI, FUTA, and SUTA. Use the round function when computing taxes. The format is: round(cell reference * tax rate, 2). The summary will help you complete the deposits and forms. Use Excel formulas throughout. (Complete all colored cells.) October and November are partailly completed for you, but formulas have been removed. The October 941 taxes have been provided to guide your calculations for November and December. OASDI Wage HI Wage ER HI Tax FUTA Wage ER OASDI Tax Tax Q4 941 Taxes Total Earnings OASDI HI FIT SIT SUTA CIT Simple Withholding Withholding Withholding Withholding Withholding Withholding Pension 9-Oct 15,456.77 958.33 224.14 836.00 474.55 9.25 598.37 23-Oct 15,778.37 978.26 228.80 868.00 484.42 9.45 610.81 31,235.14 1,936.59 452.94 1,704.00 958.97 18.70 1,209.18 15,456.77 15,778.37 31,235.14 958.32 978.26 1,936.58 15,456.77 15,778.37 31,235.14 224.12 228.79 452.91 3,818.00 692.00 4,510.00 ER FUTA SUTA Wage ER SUTA Tax 22.91 4,778.00 176.26 4.15 4,778.00 176.26 27.06 9,556.00 352.52 Monthly Total 6,483.02 4,748.00 6-Nov 13-Nov 20-Nov Monthly Total 15,411.54 2,079.32 13,922.09 31,412.95 955.53 128.92 863.18 1,947.63 223.49 30.15 201.89 455.53 897.00 193.00 605.00 1,695.00 473.16 63.84 427.43 964.43 9.22 1.25 8.34 18.81 596.62 80.49 538.96 1,216.07 15,411.54 2,079.32 13,922.09 31,412.95 955.52 128.92 863.17 1,947.61 15,411.54 2,079.32 13,922.09 31,412.95 223.47 30.15 201.87 455.49 175.15 0 65.96 241.11 1,650.00 1,650.00 1,788.00 6,536.00 4-Dec 14-Dec 18-Dec Monthly Total Quarterly Totals Enter tax rates in table below. Link these cells when creating your formulas above. Tax Rate OASDI 6.20% HI 1.45% FUTA 0.60% SUTA ER 3.6890% Note: The transaction numbers correspond to the transaction numbers in your text. See the text for additional instructions. Transaction No. 9 Sample Federal Deposit Information Worksheet Employer Identification Number 00-0000660 Name Glo-Brite Paint Compan Month Tax Year Ends 12 Amount of Deposit 6,483.02 Type of Tax (Form Number) 941 Tax Period 4th Qtr Phone Number (215) 555-9559 Address City, State, Zip 2215 Salvador St. Philadelphia, PA 19175-0682 Transaction No. 22 D Federal Deposit Information Worksheet Employer Identification Number Name Month Tax Year Ends Amount of Deposit Type of Tax (Form Number) Tax Period Phone Number Address City, State, Zip Transaction No. 30 D Federal Deposit Information Worksheet Employer Identification Number Name Month Tax Year Ends Amount of Deposit Type of Tax (Form Number) Tax Period Phone Number Address City, State, Zip Note: The transaction numbers correspond to the transaction numbers in your text. See the text for additional instructions. Transaction No. 12 Sample State Filing Information Worksheet Company Name Glo-Brite Paint Co. Payment Frequency Semi-monthly Employer Account # 3300 Gross Compensation 17,490.86 Employer ID # 00-0000660 PA Withholding Tax 537.00 Employer Password GBPCOM Credits Quarter Ending Date 12/31/XX Interest Telephone Number (215) 555-9559 Payment 537.00 Transaction No. 16 State Filing Information Worksheet Company Name Payment Frequency Employer Account # Gross Compensation Employer ID # PA Withholding Tax Employer Password Credits Quarter Ending Date Interest Telephone Number Payment Transaction No. 24 Deposit of Dec 4th SIT Withheld State Filing Information Worksheet Company Name Payment Frequency Employer Account # Gross Compensation Employer ID # PA Withholding Tax Employer Password Credits Quarter Ending Date Interest Telephone Number Payment Transaction No. 28 State Filing Information Worksheet Deposit of Dec 18th SIT Withheld Total Quarter 4 State Income Tax Deposits (sum J16+J32+J48+J64) Company Name Payment Frequency Employer Account # Gross Compensation Employer ID # PA Withholding Tax Employer Password Credits Quarter Ending Date Interest Telephone Number Payment Note: The transaction numbers correspond to the transaction numbers in your text. See the text for additional instructions. Transaction No. 10 Sample Monthly Wage Tax 1 Tax Due GLO-BRITE PAINT COMPANY 2215 SALVADOR STREET PHILADELPHLA, PA 19175-0662 Account #: 0001855 Tax Type: '01 Period/Yr 10/XX From: 10/1 To: 10/31 Due Date: 11/16 1,209.18 Deposit of October CIT Taxes 2 Interest and Penalty See Summary of Quarterly Totals for data used to compute this value. Signature: Sopko Philadelphia Revenue Department P.O. Box 3040 Philadelphia, PA 19101-8040 3 Total Due (Line 1 & 2) 1,209.18 Make checks payable to: CITY OF PHILADELPHIA Phone #: (215) 555-9559 Transaction No. 23 Deposit of November CIT withhed Monthly Wage Tax 1 Tax Due GLO-BRITE PAINT COMPANY 2215 SALVADOR STREET PHILADELPHLA, PA 19175.0682 Account #: "0001855 Tax Type: '01 Period/Yr 10/XX From: 11/1 To: 11/30 Due Date: 12/15 2 Interest and Penalty 3 Total Due (Line 1 & 2) Signature: Philadelphia Revenue Department P.O. Box 3040 Philadelphia, PA 19101-8040 Make checks payable to CITY OF PHILADELPHIA Phone #: Transaction No. 31 Deposit of December CIT Withheld Monthly Wage Tax 1 Tax Due CLO-HITE PAINT COMPANY 2215 SALVADOR STREET PHILADELPHIA, PA 19175.0632 Account #: 0001855 Tax Type: 01 Period/Yr 10/XX From: 12/1 To: 12/31 Due Date: 1/15 2 Interest and Penalty 3 Total Due (Line 1 & 2) Signature: Philadelphia Revenue Department P.O. Box 3040 Philadelphia, PA 19101-8040 Make checks payable to: CITY OF PHILADELPHIA Phone #: Total Quarter 4 City Income Tax Deposits (sum L11+L25+L39)