Can you help with this please?

Note:You will need to use thePayroll Register Templatefor your Continuing Payroll Problem- North Country Hotel and Resort Payroll submissions. The completed payroll register is used to complete the payroll problem for your final submission.

You will need to submit thePayroll Problem Templateusing each of the following worksheets: Journal, General Ledger, Employee's Earnings Record, W2, and 941 North Country Hotel and Resort EOY.

Employee Earnings Record Worksheet

January 7: Use the information from the payroll register to complete each employee's earnings record. Complete the highlighted cells for each employee.

Journal Worksheet

January 7: Prepare the journal entry to transfer cash from the regular Cash account to the Payroll cash account for the net amount of the total payroll.POST to the General Ledger Worksheet.

January 7: Prepare the journal entry to record the employee's payroll, payroll taxes and net pay for the January 7 pay week.POST to the General Ledger Worksheet.

January 7: Prepare the journal entry to record the employer's taxes and liabilities created.POST to the General Ledger Worksheet.

.

January 12: Prepare the journal entry to record the pay checks are issued to employees.POST to the General Ledger Worksheet.

January 15: North Country Hotel and Resort is a monthly depositor and pays its FICA taxes and federal income taxes on the 15th of the following month. Use the January 1 beginning balances in the FICA and FIT accounts to record the deposit of the December taxes.POST to the General Ledger Worksheet.

January 15: Prepare the journal entry the deposit of the December city taxes. City taxes are due on the 15th of the following month. Use the January 1 balances.POST to the General Ledger Worksheet.

January 15: State tax (SIT) is due. Prepare the journal entry to deposit the State income taxes. Use the January 1 balances.POST to the General Ledger Worksheet.

W2 Worksheet

Terrance Hinz. January 7 was her last day of work. Terrance's address is 755 Woodridge Ave, Hoover MN 12345. North Country Hotel and Resort EIN is 00-1111123. The Employer State ID is P000123. The employer address is 675 Sunnybrook Lane, Northern MN 12345. Be sure to complete the highlighted cells.

941 Worksheet

The quarterly report was filed on a 941. A new employee has completed a rough draft of Form 941 (see 941 workbook page) for the quarter ending December of last year. You are auditing the form before submitting it. The balances from last quarter are in the general ledger accounts. The company is a semiweekly depositor. Indicate any changes or errors that should be made to the form before it is signed and submitted. There are 7 errors on the 941 form.

January 19: On January 1, North Country Hotel and Resort hired an independent contractor to develop scheduling software. This is a year contract for $120,000/annual. The contractor is paid bi-weekly on Fridays. The first pay period is for the week January 1-5 and January 8-12. Payday is January 19. Independent contractors are not employees, so the accounts payable department would normally issue the checks and generate a 1099 at the end of the year. Calculate the first paycheck payment to the independent contractor and record the journal entry. For our example you can use Salaries and Wages Expense and Cash accounts.

Page 20 JOURNAL DATE DESCRIPTION DEBIT CREDIT 20-- Jan 7 Payroll Cash Cash 7 Salaries and Wages Expense Employee FIT Payable Employee SIT Payable Employee SUTA Payable Employee CIT Payable FICA Taxes Payable - Employee OASDI FICA Taxes Payable - Employee HI 401K Contributions Payable Health Insurance Premiums Payable Salaries and Wages Payable 9,627.71 7 Payroll Taxes Expense OASDI Taxes Payable - Employer HI Taxes Payable - Employer FUTA Taxes Payable - Employer SUTA Taxes Payable - Employer 1,347.88 730.08 164.27 67.39 82.14 596.92 139.60 564.00 850.00 6,433.31 596.92 139.60 57.77 553.59 12 Salaries and Wages Payable Payroll Cash 6,433.31 15 Employee FIT Payable Cash 15 Employee SIT Payable Cash 15 Employee SUTA Cash 15 Employee CIT Payable Cash 15 FICA - Employee OASDI Cash 15 FICA - Employee HI Cash 5,350.26 19 Cash 6,433.31 5,350.26 1,134.66 1,134.66 200.00 200.00 320.00 320.00 594.67 594.67 166.68 166.68 Page 21 JOURNAL DATE 20-- DESCRIPTION DEBIT CREDIT Page 22 JOURNAL DATE 20-- DESCRIPTION DEBIT CREDIT Page 23 JOURNAL DATE 20-- DESCRIPTION DEBIT CREDIT GENERAL LEDGER ACCOUNT: CASH BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan ACCOUNT: 1 Balance 7 Payroll Cash 15 15 15 19 6,433.26 6,872.98 320.00 1,134.66 4,615.38 100,000.32 93,567.06 86,694.08 86,374.08 85,239.42 80,624.04 PAYROLL CASH BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan ACCOUNT: 1 Balance 5,486.66 FICA TAXES PAYABLE - EMPLOYEE OASDI BALANCE DATE 20-- ITEM Taxes paid last quarter $7,157.31 DEBIT CREDIT DEBIT CREDIT Jan. ACCOUNT: 1 Balance 594.67 FICA TAXES PAYABLE - EMPLOYEE HI BALANCE DATE 20-- Jan. ACCOUNT: ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $1,673.88 1 Balance 166.68 EMPLOYEES FIT PAYABLE BALANCE DATE 20-- Jan. ACCOUNT: ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $15,854.00 1 Balance EMPLOYEES SIT PAYABLE 5,350.26 BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 1,134.66 EMPLOYEES SUTA PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 200.00 EMPLOYEES CIT PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. 1 Balance 320.00 ACCOUNT: HEALTH INSURANCE PREMIUMS PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 1,200.00 401K/SIMPLE CONTRIBUTIONS PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 2,500.86 FICA TAXES PAYABLE - EMPLOYER OASDI BALANCE DATE 20-- Jan. ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $7,157.25 1 Balance 594.70 ACCOUNT: FICA TAXES PAYABLE - EMPLOYER HI BALANCE DATE 20-- Jan. ACCOUNT: ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $1,673.87 1 Balance 166.67 SUTA TAXES PAYABLE - EMPLOYER BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. 1 Balance 350.00 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping X MN S.S. ACCOUNT NO. 000-00-1534 UNION DUES OTHER Health Insurance (Pre-tax FIT) $55/payperiod 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. RATE AMOUNT 1 40 1/7 HRS. RATE 0.00 16.75 670.00 2 25.13 Nikki AMOUNT S SALARY $ W/H MARITAL WEEKLY RATE $ ALLOW. STATUS HOURLY RATE $ 16.75 OVERTIME RA $ 25.13 CUMULATIVE 2 S DEDUCTIONS EARNINGS YEAR-TO-DATE FIRST Adams OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 50.25 720.25 44.66 10.44 58.00 12.81 5.04 6.40 25.00 55.00 502.90 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN S.S. ACCOUNT NO. x 000-00-2212 OTHER REGULAR EARNINGS OVERTIME EARNINGS RATE 0.00 YEAR-TO-DATE 1 1/7 2 3 4 QTR. TOT. YR. TOT. AMOUNT 40 13.25 530.00 HRS. RATE AMOUNT 0.00 13.25 OVERTIME RA $ 19.88 CUMULATIVE W W/H MARITAL ALLOW. STATUS 1 S DEDUCTIONS EARNINGS HRS. HOURLY RATE WEEKLY RATE Health Insurance (Pre-tax FIT) $55/payperiod 20___ Stephanie $ $ $ SALARY UNION DUES PAYDAY FIRST Barr OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 530.00 32.86 7.69 38.00 8.74 3.71 4.37 38.00 55.00 341.64 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN S.S. ACCOUNT NO. x 000-00-2415 UNION DUES OTHER Health Insurance (Pre-tax FIT) $105/payperiod 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. RATE AMOUNT 1 40 1/7 HRS. RATE 0.00 12.50 500.00 5 18.75 AMOUNT Samual J SALARY $ W/H MARITAL WEEKLY RATE $ ALLOW. STATUS HOURLY RATE $ 12.50 OVERTIME RA $ 18.75 CUMULATIVE 3 M DEDUCTIONS EARNINGS YEAR-TO-DATE FIRST Duginski OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 93.75 593.75 36.81 8.61 4.00 8.74 4.16 4.37 52.00 105.00 370.07 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN S.S. ACCOUNT NO. x 000-00-2726 OTHER REGULAR EARNINGS OVERTIME EARNINGS RATE 1/7 2 3 4 QTR. TOT. YR. TOT. HRS. RATE 0.00 YEAR-TO-DATE 1 AMOUNT 40 14.90 596.00 1 22.35 14.90 OVERTIME RA $ 22.35 CUMULATIVE AMOUNT P W/H MARITAL ALLOW. STATUS 5 M DEDUCTIONS EARNINGS HRS. HOURLY RATE WEEKLY RATE Health Insurance (Pre-tax FIT) $105/payperiod 20___ Morgan $ $ $ SALARY UNION DUES PAYDAY FIRST Glander OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 22.35 618.35 38.34 8.97 0.00 9.71 4.33 4.85 28.00 105.00 419.16 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN S.S. ACCOUNT NO. x 000-00-7826 UNION DUES OTHER Health Insurance (Pre-tax FIT) $105/payperiod 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. RATE AMOUNT 1 39 1/7 HRS. RATE 0.00 11.85 AMOUNT J $ W/H MARITAL WEEKLY RATE $ ALLOW. STATUS HOURLY RATE $ 11.85 OVERTIME RA $ 17.78 4 M DEDUCTIONS NET PAID FICA OASDI 0.00 462.15 Terrance SALARY CUMULATIVE EARNINGS YEAR-TO-DATE FIRST Hines OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 462.15 28.65 6.70 0.00 6.34 3.24 3.17 40.00 105.00 269.05 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Office Human Resources MN S.S. ACCOUNT NO. x 000-00-6923 OTHER REGULAR EARNINGS OVERTIME EARNINGS RATE 1/7 2 3 4 QTR. TOT. YR. TOT. HRS. RATE 0.00 YEAR-TO-DATE 1 AMOUNT 40 26.38 1,055.00 12 39.56 $ CUMULATIVE AMOUNT S 39.56 W/H MARITAL ALLOW. STATUS 0 S DEDUCTIONS EARNINGS HRS. OVERTIME RA WEEKLY RATE Health Insurance (Pre-tax FIT) $55/payperiod 20___ HOURLY RATE Adamao $ $ 1,055.00 $ 26.38 SALARY UNION DUES PAYDAY FIRST Jama OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 474.75 1,529.75 94.84 22.18 258.04 28.00 10.71 14.00 75.00 55.00 971.99 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Office Supervisor MN S.S. ACCOUNT NO. x 000-00-4567 UNION DUES OTHER Health Insurance (Pre-tax FIT) $105/payperiod 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. RATE AMOUNT 1 40 1/7 HRS. RATE 0.00 18.75 AMOUNT 0.00 750.00 Min S SALARY $ WEEKLY RATE $ 750.00 HOURLY RATE $ 18.75 OVERTIME RA $ 28.13 CUMULATIVE 3,250 monthly W/H MARITAL ALLOW. STATUS 8 M DEDUCTIONS EARNINGS YEAR-TO-DATE FIRST Lee OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 750.00 46.50 10.88 0.00 11.70 5.25 5.85 60.00 105.00 504.83 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Office Accounting MN S.S. ACCOUNT NO. X 000-00-5537 OTHER WEEKLY RATE HOURLY RATE OVERTIME EARNINGS PAYDAY 1/7 2 3 4 QTR. TOT. YR. TOT. AMOUNT HRS. RATE 0.00 YEAR-TO-DATE 1 CUMULATIVE 40 24.25 970.15 1 36.38 AMOUNT Tammi 4,204 monthly 970.15 24.25 N 26.38 W/H MARITAL ALLOW. STATUS 2 S DEDUCTIONS EARNINGS RATE $ OVERTIME RA REGULAR EARNINGS HRS. $ $ $ SALARY UNION DUES Health Insurance (Pre-tax FIT) $55/payperiod 20___ FIRST Rorberts OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F NET PAID FICA OASDI OTHER HI FIT SIT SUTA CIT SIMPLE DEDUCTIONS AMOUNT 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 36.38 1,006.53 62.41 14.59 96.00 17.93 7.05 8.97 55.00 55.00 689.59 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Sales Sales MN S.S. ACCOUNT NO. X 000-00-2244 OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE Health Insurance (Pre-tax FIT) $105/payperiod UNION DUES NAME - LAST FIRST F OTHER Vick Tomika SALARY $ 4,640 monthly WEEKLY RATE $ 1,070.77 HOURLY RATE $ 26.77 OVERTIME RA $ 40.16 N W/H MARITAL ALLOW. STATUS 6 M Form W2 Wage and Tax Statement 20XX a Employee's Social Secuirty Number b Emplolyer identification number (EIN) c Employer's name, address, and ZIP Code North County Hotel and Resort 675 Sunnybrook Lane Northern, MN 12345 00-1111123 1 Wages, tips, other compensation 2 Federal income tax withheld $269.05 3 Social security wages $462.15 5 Medicare wages and tips $462.15 7 Social security tips $0.00 4 Social security tax withheld $28.65 6 Medicare tax withheld $6.70 8 Allocated tips 9 10 Dependent care benefits 11 Nonqualified plans 12a 12b d Control Number e Employee's First name and initial Terrance Last Name Hines f Employee's address and ZIP Code 755 Woodridge Ave Hoover, MN 12345 15 State Employer's State ID Number MN P000123 13 Statutory employee 16 State wages, tips, etc. $269.05 Retirement plan X 14 Other 17 State income tax $6.34 Third-party sick pay 18 Local wages, tips, etc. $269.05 12c 12d 19 Local income tax $269.05 20 Locality Name Type your corrections below. 1 2 3 4 5 6 7