Can someone please help me with this project.

I need help with #1 Payroll for the four employee.

#2 Payroll report that summarizes december payroll data. #3 Payroll that summarizes 4th quarter (oct-dec) and form 941 for 4th quarter #4 Payroll that summarize payroll for the entire year and form 940

#5 calculate SUTA TAX owned by employer #6 Complete form A W-2 for each of the four employee #7 complete form W-3 for ellipses corp. Please help me with these. Thank you

In order to complete the exercises in this chapter, you must use QuickBooks Pro 2019. To register for the five- month trial software from Intuit that will allow you to work with sample company files, see the instructions on the inside front cover of this book or go to: lablearning.com/qbd-install One-Month Project NOTE! QuickBooks portable company files needed to complete these exercises are included in the Student Exercise Files download for this course. Within that download you'll also find the "Using QuickBooks for Payroll file. Be sure to review that file and complete the instructions prior to beginning this project Ellipses Corp. is a small business that operates in Herndon, VA. The company is located at 10 Period Lane, Herndon, VA 20170. Its federal identification number is 77-7777777. its state identification number is 12-345678999F-012, its state unemployment number is 1234567890, and its president, who signs all tax forms, is John Parker (telephone #571-555-0073). The company does not wish to name a third-party designee on forms. Within QuickBooks the industry associated with the company is General Service-based Business and the business type is Corporation. Ellipses Corp. is on a weekly payroll schedule. During 2019 four individuals are employed by Ellipses Corp. These employees are as follows: Name Address Social Security # Federal W/H Allowances State W/H Allowances Marital Status Hunter Cranston 85 Southern Road Herndon, VA 2017 111-11-1111 2 2 Married Allison Harrison 203A Pine Court Herndon, VA 20170 777-77-7777 4 3 Married John Parker 212 Tradition Lane Herndon, VA 20170 444-44-4444 1 1 Single Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 333 33-3333 2 2 Married Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 18, 2019. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with her last day of work on Friday, December 20. All employees of Ellipses Corp. work a regular 40 hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid weekly on Monday for the previous week (which runs from Saturday through Friday, although employees never work on weekends). The SUTA tax rate applicable to Ellipses Corp. is 2.53%, while the SUTA wage base in Virginia is $8,000. Note that QuickBooks defaults to a Social Security wage base of $128.400 in the Ellipses Corp. company file. Although this amount differs from the 2019 wage base, please utilize this amount when completing the payroll cycle. Earnings and voluntary deduction information for each of the four employees is as follows: Regular Wage Rate Annual Salary Weekly 401(k) Deduction Weekly Charitable Contribution $18/hour N/A S5 Name Hunter Cranston Allison Harrison John Parker Pierre Sternberg 6% of gross pay 5% of gross pay $24/hour N/A S5 N/A $205,400 N/A $25 N/A $111,800 10% of gross pay N/A The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as I of 11/30/2019. Note that retirement deductions are made in association with the Williams Insurance Agency Payroll data for each of the four employees for the first three quarters of the year, as well as for the months of October and November, is as follows: Hunter Cranston Gross Federal Period Earnings Income Tax State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction cont. $439.92 $580.32 $135.72 $561.60 $65 $439.92 $580.32 $135.72 $561.60 $65 $9,360 1st quarter 2nd quarter $455 $9,360 $455 3rd quarter 59,360 $455 $439.92 $580.32 $135.72 $561.60 $65 October $3,600 $175 $169.20 $223.20 $52.20 $216 S25 November $3,123 $128 $146.78 $193,63 $45.28 $187.38 $20 Federal Income Tax State Social Income Tax Security Tax $592.80 $773.76 Medicare 401(k) Tax Deduction Charitable Cont. Allison Harrison Gross Period Earnings 1st quarter $12,480 2nd quarter $12,480 3rd quarter $12,480 October $4,800 $624 $180.96 $624 $65 $624 $592.80 $773.76 $180.96 5624 $65 $624 $592.80 $273.76 $180.96 $624 $65 1 $240 $228 $297.60 $69.60 $240 $25 November $4,164 $163 $197.79 S258.17 $60.38 S208.20 $20 John Parker Federal Income Tax $12,308.57 Gross Period Earnings 1st quarter $51,350 2nd quarter S51,350 3rd quarter $51,350 October $19,750 $12,308.57 $12,308,57 $4.734.24 $3,787 24 State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction Cont. $2,567.50 $3,183.70 $744.58 SO $325 $2,567.50 $3,183.70 $744.58 0 $325 $2,567.50 $1,593,40 S744.58 50 $325 $987.50 $0 S286.38 SO 5125 November $15,800 $790 SO S229.10 SO $100 Federal Income Tax State Social Income Tax Security Tax Medicare 401(k) Tax Deduction Charitable Cont. Pierre Sternberg Gross Period Earnings 1st quarter SO 2nd quarter SO 3rd quarter SO SO so SO SO SO $0 $O $0 $0 SO SO 88 SO SO SO $0 SO October SO $0 SO SO SO SO SO November $2.150 $185.53 S96.75 $133.30 $31.18 5215 SO Note that all tax payments and filings are made on the due date and that the company is a monthly depositor. Use Password as the password for the QuickBooks company file. Based on the data provided here, you will complete the following 1. Within QuickBooks, process payroll for December for each of the four employees. When calculating federal income tax withholding, use the withholding tables where possible and refer to the percentage method only when necessary. Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Calculate and enter the Social Security and Medicare taxes, paying attention to the cumulative pay. Employees may be subject to Additional Medicare Tax, so watch cumulative pay and calculate when applicable. This is necessary because you do not have a purchased payroll subscription. Note that all charitable contributions are remitted to the organizations on the final day of each month Note that as of December 7. Hunter Cranston requests that his federal withholding allowances increase from two to three. (Ellipses Corp. makes this change.) Payroll checks are remitted to the employees in the same order (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account that is used solely for these payments. The dates for the first pay period you enter may need to be changed. This bank account has been established within QuickBooks to reflect a balance of $500,000 as of January 1, 2019 The first payroll check written in December is check #735. The following information will be required for the processing of payroll for the two employees who are compensated with an hourly wage: Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison November 30 40 41 December 7 39 37 December 14 38 36 December 21 24 0 WARNING! The above dates are weekly start dates Refer to a calendar to determine the weekly end dates and associated pay dates Dates in QuickBooks may not be correct for the first pay period you are entering Check them and make changes accordingly Keep in mind that taxisability and payment amounts are determined based on the weekly pay dates 2. Within QuickBooks, create a Payroll Report that summarizes December payroll data (in the same mannet that a payroll register summarizes such data). Export the report to Microsoft Excel. 3. Within QuickBooks, create a Payroll Report that summarizes 4th quarter (October-December) payroll data. Export the report to Microsoft Excel. Then complete Form 941 for the 4th quarter. Note that based on the lookback period, the company is a monthly depositor that made timely payments throughout the entire year. Although Virginia quarterly state payroll forms are also filed by Ellipses Corp., you will not complete these. 4. Within QuickBooks, create a Payroll Report that summarizes payroll data for the entire year. Export the report to Microsoft Excel. Then complete Form 940 for Ellipses Corp. Note that 401(k) deductions are taxable for FUTA and that FUTA payments are made only when required (i.e., if the employer is permitted to postpone the payment of these taxes, it will do so until a point in time when payment must be remitted). 5. Calculate total SUTA tax owed by the employer. Although Ellipses Corp. will file state forms in which this figure is reported, you are required to calculate only the total amount owed for the year and provide it to your instructor via a Microsoft Excel file. 6. Based on the QuickBooks reports previously generated, complete Copy A of Form W-2 for each of the four employees. State wages were the same as federal wages subject to federal withholding tax for each of the four employees, and the state identification number for Ellipses Corp, was given at the beginning of the project. 7. Based on the QuickBooks reports previously generated, complete Form W-3 for Ellipses Corp. Note that the company files the paper version of the form and selects "None apply" in the kind of Employer section. In order to complete the exercises in this chapter, you must use QuickBooks Pro 2019. To register for the five- month trial software from Intuit that will allow you to work with sample company files, see the instructions on the inside front cover of this book or go to: lablearning.com/qbd-install One-Month Project NOTE! QuickBooks portable company files needed to complete these exercises are included in the Student Exercise Files download for this course. Within that download you'll also find the "Using QuickBooks for Payroll file. Be sure to review that file and complete the instructions prior to beginning this project Ellipses Corp. is a small business that operates in Herndon, VA. The company is located at 10 Period Lane, Herndon, VA 20170. Its federal identification number is 77-7777777. its state identification number is 12-345678999F-012, its state unemployment number is 1234567890, and its president, who signs all tax forms, is John Parker (telephone #571-555-0073). The company does not wish to name a third-party designee on forms. Within QuickBooks the industry associated with the company is General Service-based Business and the business type is Corporation. Ellipses Corp. is on a weekly payroll schedule. During 2019 four individuals are employed by Ellipses Corp. These employees are as follows: Name Address Social Security # Federal W/H Allowances State W/H Allowances Marital Status Hunter Cranston 85 Southern Road Herndon, VA 2017 111-11-1111 2 2 Married Allison Harrison 203A Pine Court Herndon, VA 20170 777-77-7777 4 3 Married John Parker 212 Tradition Lane Herndon, VA 20170 444-44-4444 1 1 Single Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 333 33-3333 2 2 Married Note that Pierre Sternberg was hired in November, and his first day of work was Monday, November 18, 2019. Additionally, due to an economic downturn, Allison Harrison was laid off in mid-December, with her last day of work on Friday, December 20. All employees of Ellipses Corp. work a regular 40 hour workweek (thus all hours worked over 40 in a given week are overtime hours), receive overtime pay at a rate of 1.5 times the regular wage rate, and are paid weekly on Monday for the previous week (which runs from Saturday through Friday, although employees never work on weekends). The SUTA tax rate applicable to Ellipses Corp. is 2.53%, while the SUTA wage base in Virginia is $8,000. Note that QuickBooks defaults to a Social Security wage base of $128.400 in the Ellipses Corp. company file. Although this amount differs from the 2019 wage base, please utilize this amount when completing the payroll cycle. Earnings and voluntary deduction information for each of the four employees is as follows: Regular Wage Rate Annual Salary Weekly 401(k) Deduction Weekly Charitable Contribution $18/hour N/A S5 Name Hunter Cranston Allison Harrison John Parker Pierre Sternberg 6% of gross pay 5% of gross pay $24/hour N/A S5 N/A $205,400 N/A $25 N/A $111,800 10% of gross pay N/A The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as I of 11/30/2019. Note that retirement deductions are made in association with the Williams Insurance Agency Payroll data for each of the four employees for the first three quarters of the year, as well as for the months of October and November, is as follows: Hunter Cranston Gross Federal Period Earnings Income Tax State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction cont. $439.92 $580.32 $135.72 $561.60 $65 $439.92 $580.32 $135.72 $561.60 $65 $9,360 1st quarter 2nd quarter $455 $9,360 $455 3rd quarter 59,360 $455 $439.92 $580.32 $135.72 $561.60 $65 October $3,600 $175 $169.20 $223.20 $52.20 $216 S25 November $3,123 $128 $146.78 $193,63 $45.28 $187.38 $20 Federal Income Tax State Social Income Tax Security Tax $592.80 $773.76 Medicare 401(k) Tax Deduction Charitable Cont. Allison Harrison Gross Period Earnings 1st quarter $12,480 2nd quarter $12,480 3rd quarter $12,480 October $4,800 $624 $180.96 $624 $65 $624 $592.80 $773.76 $180.96 5624 $65 $624 $592.80 $273.76 $180.96 $624 $65 1 $240 $228 $297.60 $69.60 $240 $25 November $4,164 $163 $197.79 S258.17 $60.38 S208.20 $20 John Parker Federal Income Tax $12,308.57 Gross Period Earnings 1st quarter $51,350 2nd quarter S51,350 3rd quarter $51,350 October $19,750 $12,308.57 $12,308,57 $4.734.24 $3,787 24 State Social Medicare 401(k) Charitable Income Tax Security Tax Tax Deduction Cont. $2,567.50 $3,183.70 $744.58 SO $325 $2,567.50 $3,183.70 $744.58 0 $325 $2,567.50 $1,593,40 S744.58 50 $325 $987.50 $0 S286.38 SO 5125 November $15,800 $790 SO S229.10 SO $100 Federal Income Tax State Social Income Tax Security Tax Medicare 401(k) Tax Deduction Charitable Cont. Pierre Sternberg Gross Period Earnings 1st quarter SO 2nd quarter SO 3rd quarter SO SO so SO SO SO $0 $O $0 $0 SO SO 88 SO SO SO $0 SO October SO $0 SO SO SO SO SO November $2.150 $185.53 S96.75 $133.30 $31.18 5215 SO Note that all tax payments and filings are made on the due date and that the company is a monthly depositor. Use Password as the password for the QuickBooks company file. Based on the data provided here, you will complete the following 1. Within QuickBooks, process payroll for December for each of the four employees. When calculating federal income tax withholding, use the withholding tables where possible and refer to the percentage method only when necessary. Additionally, for simplicity, calculate the state income tax withholding as 5% of each employee's taxable pay (which is the same as taxable pay for FWT). Recall that state income tax withholding would ordinarily be calculated using the applicable state's withholding tables. Calculate and enter the Social Security and Medicare taxes, paying attention to the cumulative pay. Employees may be subject to Additional Medicare Tax, so watch cumulative pay and calculate when applicable. This is necessary because you do not have a purchased payroll subscription. Note that all charitable contributions are remitted to the organizations on the final day of each month Note that as of December 7. Hunter Cranston requests that his federal withholding allowances increase from two to three. (Ellipses Corp. makes this change.) Payroll checks are remitted to the employees in the same order (Cranston, Harrison, Parker, Sternberg) each pay period and are written from a bank account that is used solely for these payments. The dates for the first pay period you enter may need to be changed. This bank account has been established within QuickBooks to reflect a balance of $500,000 as of January 1, 2019 The first payroll check written in December is check #735. The following information will be required for the processing of payroll for the two employees who are compensated with an hourly wage: Weekly Hours Worked Weekly Start Date Hunter Cranston Allison Harrison November 30 40 41 December 7 39 37 December 14 38 36 December 21 24 0 WARNING! The above dates are weekly start dates Refer to a calendar to determine the weekly end dates and associated pay dates Dates in QuickBooks may not be correct for the first pay period you are entering Check them and make changes accordingly Keep in mind that taxisability and payment amounts are determined based on the weekly pay dates 2. Within QuickBooks, create a Payroll Report that summarizes December payroll data (in the same mannet that a payroll register summarizes such data). Export the report to Microsoft Excel. 3. Within QuickBooks, create a Payroll Report that summarizes 4th quarter (October-December) payroll data. Export the report to Microsoft Excel. Then complete Form 941 for the 4th quarter. Note that based on the lookback period, the company is a monthly depositor that made timely payments throughout the entire year. Although Virginia quarterly state payroll forms are also filed by Ellipses Corp., you will not complete these. 4. Within QuickBooks, create a Payroll Report that summarizes payroll data for the entire year. Export the report to Microsoft Excel. Then complete Form 940 for Ellipses Corp. Note that 401(k) deductions are taxable for FUTA and that FUTA payments are made only when required (i.e., if the employer is permitted to postpone the payment of these taxes, it will do so until a point in time when payment must be remitted). 5. Calculate total SUTA tax owed by the employer. Although Ellipses Corp. will file state forms in which this figure is reported, you are required to calculate only the total amount owed for the year and provide it to your instructor via a Microsoft Excel file. 6. Based on the QuickBooks reports previously generated, complete Copy A of Form W-2 for each of the four employees. State wages were the same as federal wages subject to federal withholding tax for each of the four employees, and the state identification number for Ellipses Corp, was given at the beginning of the project. 7. Based on the QuickBooks reports previously generated, complete Form W-3 for Ellipses Corp. Note that the company files the paper version of the form and selects "None apply" in the kind of Employer