ACCT 1130 – Payroll Accounting Project Complete the Payroll Project using the following Steps: STEP #1: Download the Excel spreadsheet and immediately save it by replacing the words “Your_Name” with...

1 answer below »
I attached a file


ACCT 1130 – Payroll Accounting Project Complete the Payroll Project using the following Steps: STEP #1: Download the Excel spreadsheet and immediately save it by replacing the words “Your_Name” with your First_Last name. Leave all other words in the file name. STEP #2: Review the Excel spreadsheet. It contains all of the information and templates you need to complete the Spring 2021 Payroll Project for ACCT 1130. Review all tabs carefully to understand the information being given to you. Company Information: Harbor, Inc. is a small business that operates in Woodstock, VT. The company is located at 14 The Greenway, Woodstock, VT 05091. Its Federal Employer Identification Number is 33-3333333, and its president, who signs all tax forms, is Melanie Blair (telephone #802-555-6853). The company does not wish to name a third-party designee on forms. During 2020 five individuals are employed by Harbor, Inc. These employees are as follows: Employee Name Employee Address Employee Social Security # Federal W/H Allowances Marital Status Cindy Nix 2819 East 3rd Street, Woodstock, VT 05091 123-45-6789 1 Single Jackson Tate 5514 Hwy. 301, Apt. #203, Chester, VT 05074 987-65-4321 2 Married Joint Melanie Blair 234 Lester Road, Woodstock VT 05093 432-98-7654 2 Single Lois Campbell 28 Chamblee Street, Woodstock, VT 05091 666-55-4444 2020 W-4 Sections 2,3,4 are blank Married Joint Your Name 1031 Burlington Street, Woodstock, VT 05091 111-22-5555 2020 W-4 Sections 2&4 are blank Single Notes: · Lois Campbell was hired in September, and her first day of work was Monday, September 21. On her 2020 W-4 Form Lois left sections 2, 3, and 4 blank. Lois files as married filing jointly on her tax return. · Cindy Nix was laid off in late November, with her last day of work on Friday, November 20. · Employees Nix and Tate work a regular 40-hour workweek while Employee "Your Name" works a regular 35-hour workweek. All hours in excess of an employee's regular work hours are considered overtime. Overtime is paid at 1.5 times the regular wage rate and employees are paid weekly on Sunday for the most recent week which runs Monday through Sunday. Employees do not work on weekends. · The first 3 quarters of the year have passed, and all payroll-related activity has been properly accounted for as of 9/30/2020. You will find the quarterly payroll data on each employee's EER. Wage, Salary, and Voluntary Deductions for Employees: Employee 4th Qtr Section 125 401(k) Charitable Contributions RegularWage Rate Annual Salary Cindy Nix $0/pay period Same as previous $10/pay period $14/hour Jackson Tate $0/pay period Same as previous $5/pay period $18/hour Melanie Blair $0/pay period Same as previous $15/pay period $262,000.44 Lois Campbell $0/pay period Same as previous $0/pay period $94,000.40 Your Name $50/pay period Same as previous $0/pay period $17/hour Weekly Hours Worked during the 4th Quarter: Week # of Qtr 4 Weekly Start Date Paycheck Date Cindy Nix Jackson Tate Your Name 1 September 28, 2020 October 4, 2020 40.0 44.0 35.0 2 October 5, 2020 October 11, 2020 42.0 37.0 37.5 3 October 12, 2020 October 18, 2020 38.0 40.0 39.0 4 October 19, 2020 October 25, 2020 40.0 46.5 35.0 5 October 26, 2020 November 1, 2020 43.5 42.0 36.0 6 November 2, 2020 November 8, 2020 40.0 45.0 37.0 7 November 9, 2020 November 15, 2020 39.0 40.0 40.0 8 November 16, 2020 November 22, 2020 41.0 34.5 36.0 9 November 23, 2020 November 29, 2020 0.0 40.0 38.5 10 November 30, 2020 December 6, 2020 0.0 41.0 37.0 11 December 7, 2020 December 13, 2020 0.0 43.5 35.0 12 December 14, 2020 December 20, 2020 0.0 42.5 35.0 13 December 21, 2020 December 27, 2020 0.0 40.0 37.0 Note: Tax Liability and payment amounts are determined based on the weekly pay dates. Step #3: Using the data given in the information from the first 3 quarters, complete the EER for each employee for the 4th quarter payroll periods. When calculating the FIT withholdings, use the Tax Tables when possible and the Percentage Method as necessary. Calculate the State Income Tax Withholding as 5% of the wages taxable for Federal withholdings. Keep all earnings and deductions at the same level as they were in the first 3 quarters, except where Section 125 deductions start during the 4th quarter. (See table above.) After recording all of the 4th quarter payroll information, your check figures for the EER's are as follows: Employee Name Y-T-D Net Pay Y-T-D Gross Pay Nix $19,408.37 $26,414.50 Tate $29,836.97 $37,948.50 Blair $173,082.51 $262,000.44 Campbell $19,557.02 $25,307.80 Your Name $21,437.39 $29,150.46 Step #4: After the EER for each employee is correct based on the check figures above, complete each of the 13 Payroll Registers for each pay period based on the data from the EER on each date. (Minor rounding differences (less than $.09) are expected and can be ignored.) NOTE: Do not move forward with the project until your check figures match the above numbers. If you move forward with incorrect data, your Project Grade will be a maximum of 35%. After completing all of the 4th quarter PRRs, the total Net Pay for each PRR should match the check figures as follows: Date Net Pay 10/4/2020 $6,383.53 10/11/2020 $6,310.85 10/18/2020 $6,326.85 10/25/2020 $6,401.45 11/1/2020 $6,385.42 11/8/2020 $6,409.18 11/15/2020 $6,358.18 11/22/2020 $6,234.24 11/29/2020 $5,926.51 12/6/2020 $5,918.39 12/13/2020 $5,931.20 12/20/2020 $5,911.64 12/27/2020 $5,898.83 Step #5: After the PRR for each period is correct based on the check figures above, complete the 13 Payroll Payment Journal Entries on the next tab. (Minor rounding differences (less than $.09) are expected and can be ignored.) Step #6: Complete the Medicare Calculation Sheet on the next tab. Step #7: Complete the FUTA/SUTA Calculation Sheet on the next tab. Remember that all employees except Campbell have already met the threshold for maximum wages for FUTA/SUTA taxes. The SUTA tax rate applicable to Harbor, Inc. is 2.5%, while the SUTA wage base in Vermont is $16,100. Based on your calculations and your Payroll records already completed, complete the Employee Payroll Taxes Journal entries on the next tab. Step #8: Review the 3rd Quarter 941 calculations on the next tab, and then complete the 941 calculations for the 4th quarter on the following tab. Once this sheet is completed, you can complete the Tax Payment Journal Entries on the next tab. Step #9: Complete IRS Form 941 for the 4th Quarter. Step #10: Complete the Form 940 Calculations on the next tab. Step #11: Complete IRS Form 940 for 2020. (Hint: since your FUTA taxes are so low, you have not made any payments during 2020.) Step #12: Complete the FUTA Journal Entry and the SUTA Tax Calculation on the next 2 tabs. Step #13: Fill in the 4th quarter numbers for each employee on the W-2 Calculation Sheet. Once this is done, the W-3 calculation sheet will automatically be populated with the numbers needed for the W-3 Form. Step #14: Complete IRS Form W-2 for each employee and the IRS Form W-3 for Harbor, Inc.
Answered 11 days AfterApr 11, 2021

Answer To: ACCT 1130 – Payroll Accounting Project Complete the Payroll Project using the following Steps: STEP...

Riddhi answered on Apr 18 2021
144 Votes
cindy-nix-q50frx2y.pdf
form9402020-ckdj2vry-hpnt015e.pdf
Form 940 for 2019: Employer's Annual Federal Unemployment (FUTA) Tax Return
Department of the Treasury — Internal Revenue Service
850113
OMB No. 1545-0028
Employer identification number
(EIN)

Name (not your trade name)
Trade name (if any)
Address
Number Street Suite or room number
City State ZIP code
Foreign country name Foreign province/county Foreign postal code
Read the separate instructions before you complete this form. Please type or print within the boxes.
Type of Return
(Check all that apply.)
a. Amended
b. Successor employer
c. No payments to employees in
2019
d. Final: Business closed or
stopped paying wages
Go to www.irs.gov/Form940 for
instructions and the latest information.
Part 1: Tell us about your return. If any line does NOT apply, leave it blank. See instructions before completing Part 1.
1a If you had to pay state unemployment tax in one state only, enter the state abbreviation . 1a
1 b If you had to pay state unemployment tax in more than one state, you are a multi-state
employer . . . . . . . . . . . . . . . . . . . . . . . . . . . 1b
Check here.
Complete Schedule A (Form 940).
2 If you paid wages in a state that is subject to CREDI
T REDUCTION . . . . . . . . 2 Check here.
Complete Schedule A (Form 940).
Part 2: Determine your FUTA tax before adjustments. If any line does NOT apply, leave it blank.
3 Total payments to all employees . . . . . . . . . . . . . . . . . . . 3 .
4 Payments exempt from FUTA tax . . . . . . . 4 .
Check all that apply: 4a Fringe benefits
4b Group-term life insurance
4c Retirement/Pension
4d Dependent care
4e Other
5 Total of payments made to each employee in excess of
$7,000 . . . . . . . . . . . . . . . . 5 .
6 Subtotal (line 4 + line 5 = line 6) . . . . . . . . . . . . . . . . . . . . 6 .
7 Total taxable FUTA wages (line 3 – line 6 = line 7). See instructions . . . . . . . . . 7 .
8 FUTA tax before adjustments (line 7 x 0.006 = line 8) . . . . . . . . . . . . . 8 .
Part 3: Determine your adjustments. If any line does NOT apply, leave it blank.
9 If ALL of the taxable FUTA wages you paid were excluded from state unemployment tax,
multiply line 7 by 0.054 (line 7 × 0.054 = line 9). Go to line 12 . . . . . . . . . . 9 .
10

If SOME of the taxable FUTA wages you paid were excluded from state unemployment tax,
OR you paid ANY state unemployment tax late (after the due date for filing Form 940),
complete the worksheet in the instructions. Enter the amount from line 7 of the worksheet . . 10 .
11 If credit reduction applies, enter the total from Schedule A (Form 940) . . . . . . . 11 .
Part 4: Determine your FUTA tax and balance due or overpayment. If any line does NOT apply, leave it blank.
12 Total FUTA tax after adjustments (lines 8 + 9 + 10 + 11 = line 12) . . . . . . . . . 12 .
13 FUTA tax deposited for the year, including any overpayment applied from a prior year . 13 .
14 Balance due. If line 12 is more than line 13, enter the excess on line 14.
• If line 14 is more than $500, you must deposit your tax.
• If line 14 is $500 or less, you may pay with this return. See instructions . . . . . . . 14 .
15 Overpayment. If line 13 is more than line 12, enter the excess on line 15 and check a box below 15 .
▶ You MUST complete both pages of this form and SIGN it. Check one: Apply to next return. Send a refund.
Next ■▶
For Privacy Act and Paperwork Reduction Act Notice, see the back of the Payment Voucher. Cat. No. 11234O Form 940 (2019)
850212
Name (not your trade name) Employer identification number (EIN)
Part 5: Report your FUTA tax liability by quarter only if line 12 is more than $500. If not, go to Part 6.
16

Report the amount of your FUTA tax liability for each quarter; do NOT enter the amount you deposited. If you had no liability for
a quarter, leave the line blank.
16a 1st quarter (January 1 – March 31) . . . . . . . . . 16a .
16b 2nd quarter (April 1 – June 30) . . . . . . . . . . 16b .
16c 3rd quarter (July 1 – September 30) . . . . . . . . 16c .
16d 4th quarter (October 1 – December 31) . . . . . . . 16d .
17 Total tax liability for the year (lines 16a + 16b + 16c + 16d = line 17) 17 . Total must equal line 12.
Part 6: May we speak with your third-party designee?
Do you want to allow an employee, a paid tax preparer, or another person to discuss this return with the IRS? See the instructions
for details.
Yes. Designee's name and phone number
Select a 5-digit Personal Identification Number (PIN) to use when talking to IRS
No.
Part 7: Sign here. You MUST complete both pages of this form and SIGN it.
Under penalties of perjury, I declare that I have examined this return, including accompanying schedules and statements, and to the
best of my knowledge and belief, it is true, correct, and complete, and that no part of any payment made to a state unemployment
fund claimed as a credit was, or is to be, deducted from the payments made to employees. Declaration of preparer (other than
taxpayer) is based on all information of which preparer has any knowledge.
✗Sign your name here
Date / /
Print your
name here
Print your
title here
Best daytime phone
Paid Preparer Use Only Check if you are self-employed
Preparer's name PTIN
Preparer's
signature Date / /
Firm's name (or yours
if self-employed) EIN
Address Phone
City State ZIP code
Page 2 Form 940 (2019)
Form 940-V,
Payment Voucher
Purpose of Form
Complete Form 940-V if you’re making a payment with
Form 940. We will use the completed voucher to credit
your payment more promptly and accurately, and to
improve our service to you.
Making Payments With Form 940
To avoid a penalty, make your payment with your 2019
Form 940 only if your FUTA tax for the fourth quarter
(plus any undeposited amounts from earlier quarters) is
$500 or less. If your total FUTA tax after adjustments
(Form 940, line 12) is more than $500, you must make
deposits by electronic funds transfer. See When Must
You Deposit Your FUTA Tax? in the Instructions for Form
940. Also see sections 11 and 14 of Pub. 15 for more
information about deposits.
▲!
CAUTION
Use Form 940-V when making any payment with
Form 940. However, if you pay an amount with
Form 940 that should’ve been deposited, you
may be subject to a penalty. See Deposit
Penalties in section 11 of Pub. 15.
Specific Instructions
Box 1—Employer Identification Number (EIN). If you
don’t have an EIN, you may apply for one online by
visiting the IRS website at www.irs.gov/EIN. You may also
apply for an EIN by faxing or mailing Form SS-4 to the
IRS. If you haven’t received your EIN by the due date of
Form 940, write “Applied For” and the date you applied in
this entry space.
Box 2—Amount paid. Enter the amount paid with
Form 940.
Box 3—Name and address. Enter your name and
address as shown on Form 940.
• Enclose your check or money order made payable to
“United States Treasury.” Be sure to enter your EIN,
“Form 940,” and “2019” on your check or money order.
Don’t send cash. Don’t staple Form 940-V or your
payment to Form 940 (or to each other).
• Detach Form 940-V and send it with your payment and
Form 940 to the address provided in the Instructions for
Form 940.
Note: You must also complete the entity information
above Part 1 on Form 940.
✁ ▼ Detach Here and Mail With Your Payment and Form 940. ▼


Fo
rm 940-V
Department of the Treasury
Internal Revenue Service
Payment Voucher
▶ Don't staple or attach this voucher to your payment.
OMB No. 1545-0028
2019
1 Enter your employer identification number (EIN). 2
Enter the amount of your payment. ▶
Make your check or money order payable to “United States Treasury”
Dollars Cents
3 Enter your business name (individual name if sole proprietor).
Enter your address.
Enter your city, state, and ZIP code or your city, foreign country name, foreign province/county, and foreign postal code.
Form 940 (2019)
Privacy Act and Paperwork Reduction Act Notice.
We ask for the information on this form to carry out the
Internal Revenue laws of the United States. We need it
to figure and collect the right amount of tax. Chapter
23, Federal Unemployment Tax Act, of Subtitle C,
Employment Taxes, of the Internal Revenue Code
imposes a tax on employers with respect to employees.
This form is used to determine the amount of the tax that
you owe. Section 6011 requires you to provide the
requested information if you are liable for FUTA tax under
section 3301. Section 6109 requires you to provide your
identification number. If you fail to provide this
information in a timely manner or provide a false or
fraudulent form, you may be subject to penalties.
You’re not required to provide the information
requested on a form that is subject to the Paperwork
Reduction Act unless the form displays a valid OMB
control number. Books and records relating to a form or
instructions must be retained as long as their contents
may become material in the administration of any Internal
Revenue law.
Generally, tax returns and return information are
confidential, as required by section 6103. However,
section 6103 allows or requires the IRS to disclose or
give the information shown on your tax return to others
as described in the Code. For example, we may disclose
your tax information to the Department of Justice for civil
and criminal litigation, and to cities, states, the District of
Columbia, and U.S. commonwealths and possessions to
administer their tax laws. We may also disclose this
information to other countries under a tax treaty, to
federal and state agencies to enforce federal nontax
criminal laws, or to federal law enforcement and
intelligence agencies to combat terrorism.
The time needed to complete and file this form will vary
depending on individual circumstances. The estimated
average time is:
Recordkeeping . . . . . . . . . . 9 hr., 19 min.
Learning about the law or the form . . 1 hr., 23 min.
Preparing, copying, assembling, and
sending the form to the IRS . . . . . 1 hr., 36 min.
If you have comments concerning the accuracy of
these time estimates or suggestions for making
Form 940 simpler, we would be happy to hear from
you. You can send us comments from
www.irs.gov/FormComments. Or you can send your
comments to Internal Revenue Service, Tax Forms and
Publications Division, 1111 Constitution Ave. NW,
IR-6526, Washington, DC 20224. Don’t send Form 940 to
this address. Instead, see Where Do You File? in the
Instructions for Form 940.
Version A, Cycle 2
Fillable fields: Font = 10pt Times; Color =Black; Checkmark=Cross
INTERNAL USE ONLY
DRAFT AS OF
April 24, 2019
Version A, Cycle 2
INTERNAL USE ONLY
DRAFT AS OF
April 24, 2019
Version A, Cycle 2
INTERNAL USE ONLY
DRAFT AS OF
April 24, 2019
2019 Form 940
SE:W:CAR:MP
Employer's Annual Federal Unemployment (FUTA) Tax Return
Form   940 for 2019:
Form 940 for 2019: Cat. No. 11234O.
Employer's Annual Federal Unemployment (FUTA) Tax Return
Department of the Treasury — Internal Revenue Service
850113
OMB No. 1545-0028
O M B No. 1545-0028. For Privacy Act and Paperwork Reduction Act Notice, see the back of the Payment Voucher.
Employer identification number
(EIN)

Address
Read the separate instructions before you complete this form. Please type or print within the boxes.
Type of Return(Check all that apply.)
a. Amended
b. Successor employer
c. No payments to employees in 2019
d. Final: Business closed orstopped paying wages
Go to www.irs.gov/Form940 for instructions and the latest information.
Part 1:
Tell us about your return. If any line does NOT apply, leave it blank. See instructions before completing Part 1.
1
a
If you had to pay state unemployment tax in one state only, enter the state abbreviation
1a
1

b
If you had to pay state unemployment tax in more than one state, you are a multi-state employer
1b
Check here.Complete Schedule A (Form 940). 
2
If you paid wages in a state that is subject to CREDIT REDUCTION
2
Check here.Complete Schedule A (Form 940).
Part 2:
Determine your FUTA tax before adjustments. If any line does NOT apply, leave it blank. 
3
Total payments to all employees
3
4
Payments exempt from FUTA tax
4
Check all that apply:
4a
4b
4c
4d
4e
5
Total of payments made to each employee in excess of  $7,000
5
6
Subtotal (line 4 + line 5 = line 6)
6
7
Total taxable FUTA wages (line 3 – line 6 = line 7). See instructions
7
8
FUTA tax before adjustments (line 7 x 0.006 = line 8)
8
Part 3:
Determine your adjustments. If any line does NOT apply, leave it blank. 
9
If ALL of the taxable FUTA wages you paid were excluded from state unemployment tax,  multiply line 7 by 0.054  (line 7 × 0.054 = line 9). Go to line 12
9
10
If SOME of the taxable FUTA wages you paid were excluded from state unemployment tax,  OR you paid ANY state unemployment tax late (after the due date for filing Form 940), complete the worksheet in the instructions. Enter the amount from line 7 of the worksheet
10
11
If credit reduction applies, enter the total from Schedule A (Form 940) 
11
Part 4:
Determine your FUTA tax and balance due or overpayment. If any line does NOT apply, leave it blank.
12
Total FUTA tax after adjustments (lines 8 + 9 + 10 + 11 = line 12)
12
13
FUTA tax...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here