Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone please help with this project... what kind of information do you need? this is all i have i put it everthing In order
Can someone please help with this project...
what kind of information do you need? this is all i have i put it everthing
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-3456789997-012, its state unemployment number is 1234567890, and its president, who signs all tax forma, 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: Social Security Federal W/H Allowances State W/H Allowances 2 Marital Status 111-11-1111 2 Married 777-77-7777 4 3 Name Address Hunter Cranston 85 Southern Road Herndon, VA 20170 Allison Harrison 203A Pine Court Herndon, VA 20170 John Parker 212 Tradition Lane Herndon, VA 20170 Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 Married 444-44-4444 1 1 Single 333-33-3333 2 2 Married 1 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: Name Regular Wage Rate Annual Salary Weekly Charitable Contribution Hunter Cranston $18/hour N/A $5 Allison Harrison $24/hour Weekly 401(k) Deduction 6% of gross pay 5% of gross pay N/A 10% of gross pay N/A $5 N/A $205,400 John Parker Pierre Sternberg $25 N/A S111,800 N/A The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as 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: I Hunter Cranston Gross Period Earnings 1st quarter $9,360 Federal Income Tax State Social Income Tax Security Tax Medicare Tax 401(k) Charitable Deduction Cont. $455 $439.92 $580.32 $135.72 $561.60 2nd quarter $65 59,360 $455 $439.92 $580.32 $135.72 $561.60 3rd quarter $65 59,360 $455 $439.92 $580.32 $135.72 $561.60 October $65 $3,600 $175 $169.20 $223.20 $52.20 November $216 $25 $3,123 $128 $146.78 $193.63 $45.28 $187.38 $20 Federal Income Tax Allison Harrison Gross Period Earnings 1st quarter $12,480 2nd quarter $12,480 3rd quarter $12,480 State Social Income Tax Security Tax $592.80 $773.76 Medicare Tax 401(k) Deduction Charitable Cont. $624 $180.96 $624 $65 $624 $592 80 $773.76 $180.96 $624 $65 $624 $592.80 $773.76 $180.96 $624 October $4,800 $65 $240 $228 $297.60 $69.60 November S240 $25 $4,164 $163 $197.79 $258.17 $60.38 S208.20 $20 John Parker Gross Period Earnings 1st quarter $51,350 Federal Income Tax $12,308.57 State Social Income Tax Security Tax $2,567.50 $3,183.70 Medicare 401(k) Deduction Tax Charitable cont. 2nd quarter $744.58 50 $51,350 $325 $12,308.57 $2,567 50 $3,183.70 $744.58 3rd quarter $0 $51,350 $12,308.57 $325 $2,567.50 $1,593.40 October $744.58 SO $19,750 $325 $4,734 24 $987.50 SO November $286.38 SO $15,800 $3,787.24 S125 5790 SO $229.10 $0 $100 Pierre Sternberg Gross Earnings Federal Income Tax Period 1st quarter State Social Income Tax Security Tax so SO Medicare Tax 401(k) Deduction Charitable Cont. SO SO $O SO SO 2nd quarter SO SO SO 50 $0 $0 $0 3rd quarter SO so SO SO SO SO October SO SO SO SO SO 8 November 8 8 8 $2,150 $185.53 S96.75 $133.30 $31.18 $215 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 I 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 tax liability and payment amounts are determined based on the weekly pay dates. * Export a Payroll report for Dec payroll data in Excel * Export a Payroll report for 4Q data in Excel Complete IRS Form 941 for 4Q Export a Payroll report for the year * Complete IRS Form 940 for the year * Calculate SUTA tax owed * Create Copy A of IRS Form W-2 for each of the 4 employees Create IRS Form W-3 for Ellipses Corp * * Export a Payroll report for Dec payroll data in Excel * Export a Payroll report for 4Q data in Excel Complete IRS Form 941 for 4Q Export a Payroll report for the year * Complete IRS Form 940 for the year * Calculate SUTA tax owed * Create Copy A of IRS Form W-2 for each of the 4 employees Create IRS Form W-3 for Ellipses Corp 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-3456789997-012, its state unemployment number is 1234567890, and its president, who signs all tax forma, 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: Social Security Federal W/H Allowances State W/H Allowances 2 Marital Status 111-11-1111 2 Married 777-77-7777 4 3 Name Address Hunter Cranston 85 Southern Road Herndon, VA 20170 Allison Harrison 203A Pine Court Herndon, VA 20170 John Parker 212 Tradition Lane Herndon, VA 20170 Pierre Sternberg 41 Seward Boulevard Herndon, VA 20170 Married 444-44-4444 1 1 Single 333-33-3333 2 2 Married 1 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: Name Regular Wage Rate Annual Salary Weekly Charitable Contribution Hunter Cranston $18/hour N/A $5 Allison Harrison $24/hour Weekly 401(k) Deduction 6% of gross pay 5% of gross pay N/A 10% of gross pay N/A $5 N/A $205,400 John Parker Pierre Sternberg $25 N/A S111,800 N/A The first 11 months of the year have passed, and all payroll-related activity has been properly accounted for as 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: I Hunter Cranston Gross Period Earnings 1st quarter $9,360 Federal Income Tax State Social Income Tax Security Tax Medicare Tax 401(k) Charitable Deduction Cont. $455 $439.92 $580.32 $135.72 $561.60 2nd quarter $65 59,360 $455 $439.92 $580.32 $135.72 $561.60 3rd quarter $65 59,360 $455 $439.92 $580.32 $135.72 $561.60 October $65 $3,600 $175 $169.20 $223.20 $52.20 November $216 $25 $3,123 $128 $146.78 $193.63 $45.28 $187.38 $20 Federal Income Tax Allison Harrison Gross Period Earnings 1st quarter $12,480 2nd quarter $12,480 3rd quarter $12,480 State Social Income Tax Security Tax $592.80 $773.76 Medicare Tax 401(k) Deduction Charitable Cont. $624 $180.96 $624 $65 $624 $592 80 $773.76 $180.96 $624 $65 $624 $592.80 $773.76 $180.96 $624 October $4,800 $65 $240 $228 $297.60 $69.60 November S240 $25 $4,164 $163 $197.79 $258.17 $60.38 S208.20 $20 John Parker Gross Period Earnings 1st quarter $51,350 Federal Income Tax $12,308.57 State Social Income Tax Security Tax $2,567.50 $3,183.70 Medicare 401(k) Deduction Tax Charitable cont. 2nd quarter $744.58 50 $51,350 $325 $12,308.57 $2,567 50 $3,183.70 $744.58 3rd quarter $0 $51,350 $12,308.57 $325 $2,567.50 $1,593.40 October $744.58 SO $19,750 $325 $4,734 24 $987.50 SO November $286.38 SO $15,800 $3,787.24 S125 5790 SO $229.10 $0 $100 Pierre Sternberg Gross Earnings Federal Income Tax Period 1st quarter State Social Income Tax Security Tax so SO Medicare Tax 401(k) Deduction Charitable Cont. SO SO $O SO SO 2nd quarter SO SO SO 50 $0 $0 $0 3rd quarter SO so SO SO SO SO October SO SO SO SO SO 8 November 8 8 8 $2,150 $185.53 S96.75 $133.30 $31.18 $215 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 I 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 tax liability and payment amounts are determined based on the weekly pay dates. * Export a Payroll report for Dec payroll data in Excel * Export a Payroll report for 4Q data in Excel Complete IRS Form 941 for 4Q Export a Payroll report for the year * Complete IRS Form 940 for the year * Calculate SUTA tax owed * Create Copy A of IRS Form W-2 for each of the 4 employees Create IRS Form W-3 for Ellipses Corp * * Export a Payroll report for Dec payroll data in Excel * Export a Payroll report for 4Q data in Excel Complete IRS Form 941 for 4Q Export a Payroll report for the year * Complete IRS Form 940 for the year * Calculate SUTA tax owed * Create Copy A of IRS Form W-2 for each of the 4 employees Create IRS Form W-3 for Ellipses Corp Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started