Boston Company recently hired you to prepare the monthly payroll along with other accounting tasks on...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Boston Company recently hired you to prepare the monthly payroll along with other accounting tasks on October 1. You will need to create an Excel workbook for your Payroll Register, Earnings Report, General Journal and General Ledger. You will find attached several pdf forms that will assist you in preparing their final returns. All employees are paid monthly with the Manager and President being paid a salary and the other two being paid an hourly rate. Both you and the Salesperson are not considered white-collar employees, so the company is responsible to pay you overtime for time worked beyond 40 hours per week. NOTE: All excel workbooks should be created from scratch and no template should be used. Using a template is considered collusion and will result in an automatic zero for the project. The following taxes are levied upon Boston Company and its employees Federal Income Taxes (FIT) - Please use the attached tax tables. O Use the wage-bracket method when able · • . • . Other deductions The President and Manager currently put money into the company sponsored SIMPLE Retirement Plan. As a new employee you will not be allowed to participate. While the company does match these, that is handled by a CPA company and is not your responsibility to keep track of. You will be required to use it when calculating the employees net pay and other deductions. The State of Nebraska for SIT allows for the same benefits as the Federal government for FIT calculations. • Use the percentage method when needed Taxes are deposited according to the following schedule • Federal Taxes - OASDI, HI and FIT taxes must be deposited on or before the 15th of the month following the month in which the taxes were withheld State - States taxes are deposited quarterly. The must be remitted along with the 941N by the month following the end of the quarter . Nebraska State Income Taxes (SIT) - 6.84% Nebraska State Unemployment Taxes (SUTA) - 3.08% on the first $9,000 of wages Federal Unemployment Taxes (FUTA) - .6% on the first $7,000 of wages FICA (OASDI) - 6.2% on the first $142,800 of gross earnings FICA (HI)-1.45% on total gross earnings. . SUTA taxes are deposited quarterly. The must be remitted along with the 941N by the month following the end of the quarter FUTA taxes are deposited in accordance with Federal guidelines. NOTE: Please be sure you use a fictitious SSN for your W-2. Company Information: Boston Company 1010 Prdv Road Grand Island, NE 68803 Federal ID # 00-0000880 State ID # 000-00-5500 1 Employee Information: Noah Boston, President, SSN# 000-00-4813, 315 N Shore Drive, Grand Island, NE 68803 James Jones, Manager, SSN# 000-00-6458, 3200 Indian Road, Grand Island, NE 68803 Kylee Miller, Sales, SSN# 000-00-5694, 1919 Avenue L, Grand Island, NE 68801 {Student} Employee Information to date: Noah Boston James Jones Kylee Miller {Student} Annual Salary 176,304 150,396 FIT Payable SIT Payable Account Earnings OASDI 132,228 8,198.14 112,797 36,750 2,278.50 Hourly Martial Rate Status M S M S Noah Boston James Jones Kylee Miller {Student} Balances in General Ledger accounts at 9/30/2021: Cash FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable 21.00 15.00 SIMPLE Payable Wages Expense Payroll Tax Expense HI 1,917.31 6,993.41 1,635.56 YTD as of 9/30/2021 W/H Allow 3 0 1 0 Account # 100 210 211 212 213 214 215 240 510 520 532.88 2,655.00 SIT SIMPLE Net FIT 13,134.55 9,014.40 8,100.00 91,863.60 12,030.60 7,515.31 4,500.00 80,122.12 2,463.70 28,819.92 Balance 128,962.00 3,882.24 907.94 126.00 6.16 3,091.13 6,331.14 SIMPLE Deduction 281,775.00 22,513.40 900 500 2 The following transactions and events occurred during the last quarter of the year 10/15 Prepare a journal entry to record the deposit of Federal Taxes from the prior month and post to the appropriate General Ledger. (NOTE: the amount due is the same as the balance carry forward from the General Ledger. This include the deposit of FICA and FIT taxes) 10/31 SUTA Taxes were paid for the previous quarter 10/31 SIT Taxes were paid for the previous quarter 10/31 Prepare the payroll for the last day of the period of October. There were 5 weeks during October, and you worked the following hours during those 5 weeks (42, 36, 49, 31, 49) Kylee recently went to part-time and worked the following hours (21, 35, 16, 28, 17) NOTE: Be sure you record the both the employees and the employers Journal Entries. PROCESS: Prepare Register, then Employee Earnings, prepare your Journal Entry and then Post to the General Ledger 11/15 Prepare a journal entry to record the deposit of Federal Taxes from the prior month and post to the appropriate General Ledger. 11/20 Kylee submitted a new W-4 that changed her allowances to 2. This will take effect on the Nov 30 paycheck. 11/30 Prepare the payroll for the last day of the period of November There were 4 weeks during November, and you worked the following hours during those weeks (50, 45, 40, 47) Kylee worked the following hours (15, 30, 35, 26) 12/4 Joel submitted a new W-4 that changed exemptions to 1 12/15 Prepare a journal entry to record the deposit of Federal Taxes from the prior month and post to the appropriate General Ledger. 12/31 Prepare the payroll for the last day of the period of December There were 4 weeks during December, and you worked the following hours during those weeks (40, 45, 48, 46) Kylee worked the following hours (20, 15, 25, 16) Prepare all journal entries needed in January to pay taxes due. Be sure you date them properly. NOTE: Do not post these to the General Ledger Required: • Using the above transactions complete the Payroll Register, Earnings Reports, Journal Entries and General Ledger accounts you created using your excel knowledge. (please be sure these are created in 1 excel workbook) Complete the proper yearend tax forms by using the attached pdf files: o Form 941 (Pages 1 & 2 Only) o Form 941N (Nebraska) o Forms Ul-11T & UI-11W (Nebraska) o Form 940 o Form W-2 (one for each employee) O Form W-3 Answer the following questions on a blank excel worksheet in your workbook. Be sure to show your work for each calculation. o The total payroll tax expense incurred by the employer on salaries and wages paid during the quarter ended December 31 was o The total payroll tax expense incurred by the employer on the total earnings of Noah Boston during the fourth quarter was o Boston has decided to give all current employees (including himself) a bonus payment during January equal to 6% of their total gross pay for last year. Determine the total amount he will pay in bonus payments and total amount of payroll tax expenses associated with these bonuses. Boston Company recently hired you to prepare the monthly payroll along with other accounting tasks on October 1. You will need to create an Excel workbook for your Payroll Register, Earnings Report, General Journal and General Ledger. You will find attached several pdf forms that will assist you in preparing their final returns. All employees are paid monthly with the Manager and President being paid a salary and the other two being paid an hourly rate. Both you and the Salesperson are not considered white-collar employees, so the company is responsible to pay you overtime for time worked beyond 40 hours per week. NOTE: All excel workbooks should be created from scratch and no template should be used. Using a template is considered collusion and will result in an automatic zero for the project. The following taxes are levied upon Boston Company and its employees Federal Income Taxes (FIT) - Please use the attached tax tables. O Use the wage-bracket method when able · • . • . Other deductions The President and Manager currently put money into the company sponsored SIMPLE Retirement Plan. As a new employee you will not be allowed to participate. While the company does match these, that is handled by a CPA company and is not your responsibility to keep track of. You will be required to use it when calculating the employees net pay and other deductions. The State of Nebraska for SIT allows for the same benefits as the Federal government for FIT calculations. • Use the percentage method when needed Taxes are deposited according to the following schedule • Federal Taxes - OASDI, HI and FIT taxes must be deposited on or before the 15th of the month following the month in which the taxes were withheld State - States taxes are deposited quarterly. The must be remitted along with the 941N by the month following the end of the quarter . Nebraska State Income Taxes (SIT) - 6.84% Nebraska State Unemployment Taxes (SUTA) - 3.08% on the first $9,000 of wages Federal Unemployment Taxes (FUTA) - .6% on the first $7,000 of wages FICA (OASDI) - 6.2% on the first $142,800 of gross earnings FICA (HI)-1.45% on total gross earnings. . SUTA taxes are deposited quarterly. The must be remitted along with the 941N by the month following the end of the quarter FUTA taxes are deposited in accordance with Federal guidelines. NOTE: Please be sure you use a fictitious SSN for your W-2. Company Information: Boston Company 1010 Prdv Road Grand Island, NE 68803 Federal ID # 00-0000880 State ID # 000-00-5500 1 Employee Information: Noah Boston, President, SSN# 000-00-4813, 315 N Shore Drive, Grand Island, NE 68803 James Jones, Manager, SSN# 000-00-6458, 3200 Indian Road, Grand Island, NE 68803 Kylee Miller, Sales, SSN# 000-00-5694, 1919 Avenue L, Grand Island, NE 68801 {Student} Employee Information to date: Noah Boston James Jones Kylee Miller {Student} Annual Salary 176,304 150,396 FIT Payable SIT Payable Account Earnings OASDI 132,228 8,198.14 112,797 36,750 2,278.50 Hourly Martial Rate Status M S M S Noah Boston James Jones Kylee Miller {Student} Balances in General Ledger accounts at 9/30/2021: Cash FICA Taxes Payable - OASDI FICA Taxes Payable - HI FUTA Taxes Payable SUTA Taxes Payable 21.00 15.00 SIMPLE Payable Wages Expense Payroll Tax Expense HI 1,917.31 6,993.41 1,635.56 YTD as of 9/30/2021 W/H Allow 3 0 1 0 Account # 100 210 211 212 213 214 215 240 510 520 532.88 2,655.00 SIT SIMPLE Net FIT 13,134.55 9,014.40 8,100.00 91,863.60 12,030.60 7,515.31 4,500.00 80,122.12 2,463.70 28,819.92 Balance 128,962.00 3,882.24 907.94 126.00 6.16 3,091.13 6,331.14 SIMPLE Deduction 281,775.00 22,513.40 900 500 2 The following transactions and events occurred during the last quarter of the year 10/15 Prepare a journal entry to record the deposit of Federal Taxes from the prior month and post to the appropriate General Ledger. (NOTE: the amount due is the same as the balance carry forward from the General Ledger. This include the deposit of FICA and FIT taxes) 10/31 SUTA Taxes were paid for the previous quarter 10/31 SIT Taxes were paid for the previous quarter 10/31 Prepare the payroll for the last day of the period of October. There were 5 weeks during October, and you worked the following hours during those 5 weeks (42, 36, 49, 31, 49) Kylee recently went to part-time and worked the following hours (21, 35, 16, 28, 17) NOTE: Be sure you record the both the employees and the employers Journal Entries. PROCESS: Prepare Register, then Employee Earnings, prepare your Journal Entry and then Post to the General Ledger 11/15 Prepare a journal entry to record the deposit of Federal Taxes from the prior month and post to the appropriate General Ledger. 11/20 Kylee submitted a new W-4 that changed her allowances to 2. This will take effect on the Nov 30 paycheck. 11/30 Prepare the payroll for the last day of the period of November There were 4 weeks during November, and you worked the following hours during those weeks (50, 45, 40, 47) Kylee worked the following hours (15, 30, 35, 26) 12/4 Joel submitted a new W-4 that changed exemptions to 1 12/15 Prepare a journal entry to record the deposit of Federal Taxes from the prior month and post to the appropriate General Ledger. 12/31 Prepare the payroll for the last day of the period of December There were 4 weeks during December, and you worked the following hours during those weeks (40, 45, 48, 46) Kylee worked the following hours (20, 15, 25, 16) Prepare all journal entries needed in January to pay taxes due. Be sure you date them properly. NOTE: Do not post these to the General Ledger Required: • Using the above transactions complete the Payroll Register, Earnings Reports, Journal Entries and General Ledger accounts you created using your excel knowledge. (please be sure these are created in 1 excel workbook) Complete the proper yearend tax forms by using the attached pdf files: o Form 941 (Pages 1 & 2 Only) o Form 941N (Nebraska) o Forms Ul-11T & UI-11W (Nebraska) o Form 940 o Form W-2 (one for each employee) O Form W-3 Answer the following questions on a blank excel worksheet in your workbook. Be sure to show your work for each calculation. o The total payroll tax expense incurred by the employer on salaries and wages paid during the quarter ended December 31 was o The total payroll tax expense incurred by the employer on the total earnings of Noah Boston during the fourth quarter was o Boston has decided to give all current employees (including himself) a bonus payment during January equal to 6% of their total gross pay for last year. Determine the total amount he will pay in bonus payments and total amount of payroll tax expenses associated with these bonuses.
Expert Answer:
Related Book For
Auditing An International Approach
ISBN: 978-0071051415
6th edition
Authors: Wally J. Smieliauskas, Kathryn Bewley
Posted Date:
Students also viewed these accounting questions
-
The bookkeeper for Oglesby Company asks you to prepare the following accrued adjusting entries at December 31. 1. Interest on notes payable of $400 is accrued. 2. Services provided but not recorded...
-
The bookkeeper for Forseth Company asks you to prepare the following accrual adjusting entries at December 31. (a) Interest on notes payable of $300 is accrued. (b) Service revenue earned but...
-
The bookkeeper for Juaquin Company asks you to prepare the following accrued adjusting entries at December 31. 1. Interest on notes payable of $400 is accrued. 2. Services provided but not recorded...
-
Which message does the following application print? A. Hello! B. Goodbye! C. See you again! D. It does not compile because of line g1. E. It does not compile because of line g2. F. None of the above....
-
Between the three basic forms of business ownership, describe the ability of each form to access capital.
-
A building that was purchased December 31, 1983, for $2,400,000 was originally estimated to have a life of 50 years with no salvage value at the end of that time. Depreciation has been recorded...
-
Defendants Jack and Claire Lein owned and lived on Willow Creek Farm from 1980 through 2004. The farm manager, Stewart, and his girlfriend, plaintiff Tambra Curtis, also lived on the farm during this...
-
Home Products Company manufactures a complete line of kitchen glassware. The Beverage Division specializes in 12-ounce drinking glasses. Erin Fisher, the superintendent of the Beverage Division,...
-
Ricardo works for Bank B and is talking about loans with a consumer. He provides the consumer with a general explanation regarding the basic qualifications of a loan. Although the consumer plans to...
-
AD Enterprise was established in June 2023. During the first month of the operation of the business, these events and transactions occurred: June 1 Mr. AD invested $100,000 cash in exchange into the...
-
A toy rocket moving vertically upward passes by a 2.2 {m {m m}} -high window whose sill is 8.0 {m {m m}} above the ground. The rocket takes 0.17 {m {m s}} to travel the 2.2 {m {m m}} height of the...
-
Zap Industries had a tentative general business credit in 2018 of \(\$ 60,000\). Its tax liability in 2017 was \(\$ 20,000\). Its tax liability before the general business credit in 2018 is \(\$...
-
An external confirmation sent to a customer: a. provides strong evidence for the accuracy, valuation, and allocation assertion when the customer agrees with the balance owing. b. requests information...
-
During the following years Adolpho T. (single) had (1) withheld, (2) paid (by check - presumably estimated tax payments or paid with the extension) and (3) received a refund of the following amounts...
-
Why do most companies underforecast than overforecast? Cite a situation when overforecasting may be better.
-
The assertion of cut-off: a. reflects that all assets and liabilities that should have been recorded are recorded. b. ensures that events have been recorded in the correct accounts. c. is an...
-
Can narratology go beyond the limits of description? Is it possible for narratology to perform interpretation scope?
-
B made an issue of 150,000 $1 ordinary shares at a premium of 20% the proceeds of which is received by cheque. What is the correct journal to record this? A. Bank Share capital Share premium B. Bank...
-
What is the role of the auditors understanding of the business and its risks in performing analytical procedures?
-
Why does an inventory of Rolex watches have a high inherent risk, and why does the auditor expect management to have strong controls over this inventory?
-
Compare the quality inspection reports of the CPAB and PCAOB. Do the PA firms in the United States and Canada have similar quality control problems?
-
Smart Manufacturing Systems Pty Ltds accountant recently prepared the following data from the companys accounting records for the year ended 30 June 2019. Factory overhead is applied at the rate of...
-
During the year ended 30 June 2019, Beautiful Bottles Pty Ltd incurred the following costs in connection with its production activities. Required (a) Calculate the relationship between factory...
-
Telecommunications company Toronto Ltd signed a 15year deal to sell capacity on its cable network to a rival company for $200 million. The deal was completed on the last day of Toronto Ltds financial...
Study smarter with the SolutionInn App