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....
-
(a) Develop a landing sequence that gives priority to those aircraft with the highest cost of slack time. For example, Flight 616s 18.75 minutes of slack time (22 Ë 3.25) times $300 per minute...
-
What is the purpose of the allowance for the survivor benefit?
-
Which method of estimating uncollectible receivables focuses on net credit sales? a. Aging approach b. Percent-of-sales approach C. Net realizable value approach d. All of the above
-
The account balances for the noncash current assets of Allen Company are as follows: Net income for 2009 is $35,000. Depreciation expense is $22,000. Assume that all sales and all purchases are on...
-
Taylor Series stock is $562/sh today and its futures contract (due in 6 months) is $580. Dividends of $2 are expected in 1 month and 5 months. The interest rate is 4% p.a. (flat term structure with...
-
Suppose the prices of zero-coupon bonds paying $100 at maturity are: Price Time to maturity (years) $96.15 1 $90.70 2 $83.96 3 $76.29 4 Bond B1 B B3 B4 a. [1pt] What is the price of the 3-year coupon...
-
Write a Research Essay Abortion and Morality
-
What is the output of the following? A. e B. d C. ed D. None of the above 1: public class Legos { 2: 3: 4: 5: 6: 7: 8: 9: } public static void main(String[] args) { var sb = new StringBuilder();...
-
Which is one of the lines output by this code? A. [] B. [8, 10] C. [8, 9, 10] D. [10, 8] E. The code does not compile. 10: var list= new ArrayList (); 11: list.add (10); 12: list.add (9); 13:...
-
What is the result of compiling and executing the following class? A. The code does not compile due to line x. B. The code does not compile due to line y. C. 31 D. 61 public class Tolls { private...
-
What is the output of the following class? A. 2 B. 3 C. 4 D. None of the above 1: package rocket; 2: public class Countdown { 3: 4: 5: 6: 7: 8: } public static void main(String[] args) { var builder...
-
Which of the following can fill in the blank so the code prints true? var happy :) ( "; var really happy.trim(); var question = = System.out.println(really.equals(question)); A. happy.substring(0, B....
-
Write a recursive binarySearch function for an array of strings ( already sorted ) , that returns the indexes of all the strings whose first letter is b for example. For example, for anArray = {...
-
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?
-
The unadjusted trial balance of Innovative Computers Pty Ltd on 30 June 2025 is presented below. The following additional information is available. 1. The inventories as of 30 June 2025 were as...
-
The Z-spread of Bond A is 1.05% and the Z-spread of Bond B is 1.53%. All else equal, which statement best describes the relationship between the two bonds? A. Bond B is safer and will sell at a lower...
-
A four-year corporate bond with a 7% coupon has a Z-spread of 200 bps. Assume a flat yield curve with an interest rate for all maturities of 5% and annual compounding. The bond will most likely sell:...
Study smarter with the SolutionInn App