I have completed some of this already but have gotten confused and lost as other class mates are stating different things. If I did something wrong just correct it. Thanks

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. (I HAVE ATTACHED THIS ALREADY AS FINAL PROJECT)

To complete this assignment, use your completed payroll register from your previous submissions. (I HAVE ATTACHED THIS AS NORTH COUNTRY HOTEL)

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

Prepare a W2 for 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. Write your changes in the text box provided to the right of the 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-- 7-Jan 7-Jan 7-Jan 12-Jan Payroll Cash Cash 6,433.26 Salaries & Wages Expense Employee FIT Payable Employee SIT Payable Employee SUTA Payable Employee CIT Payable FICA Taxes Payables-Employee OASDI FICA Taxes Payables-Employee HI 401K Contribution Payable Health Insurance Premium Payables Salaries & Wages Payable 9,627.71 Payroll Tax Expense FICA Tax Payable-Employer OASDI FICA Tax Payable-Employer HI FUTA Tax Payable-Employer SUTA Tax Payable-Employer 1,867.77 6,433.26 730.08 164.29 67.41 82.14 596.92 139.61 564.00 850.00 6,433.26 596.92 139.60 577.66 553.59 Page 21 JOURNAL DATE 20-- DEBIT DESCRIPTION CREDIT Page 22 JOURNAL DATE 20-- DEBIT CREDIT DESCRIPTION Page 23 JOURNAL DATE DEBIT CREDIT 20-- DESCRIPTION GENERAL LEDGER ACCOUNT: CASH BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan ACCOUNT: 1 Balance 7 Cash 6,433.26 100,000.32 93,567.06 PAYROLL CASH BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan ACCOUNT: 1 Balance 7 Payroll Cash 5,486.66 11,919.92 6,433.26 FICA TAXES PAYABLE - EMPLOYEE OASDI BALANCE DATE 20-- ITEM Taxes paid last quarter $7,157.31 DEBIT CREDIT DEBIT CREDIT Jan. ACCOUNT: 1 Balance 7 FICA Taxes Payable -Employee OASDI 594.67 1,191.59 596.92 FICA TAXES PAYABLE - EMPLOYEE HI BALANCE DATE ITEM 20-- Taxes paid last quarter $1,673.88 Jan. 1 Balance 7 FICA Taxes Payable - Employee HI ACCOUNT: DEBIT CREDIT DEBIT CREDIT 166.68 306.29 139.61 EMPLOYEES FIT PAYABLE BALANCE DATE 20-- Jan. ACCOUNT: ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $15,854.00 1 Balance 7 Employees FIT Payable 730.08 5,350.26 6,080.34 EMPLOYEES SIT PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 7 Employees SIT Payable 1,134.66 1,298.95 164.29 EMPLOYEES SUTA PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 7 Employees SUTA Payable 200.00 267.41 67.41 EMPLOYEES CIT PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 7 Employees CIT Payable HEALTH INSURANCE PREMIUMS PAYABLE 82.14 320.00 402.14 BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 7 Health Insurance 1,200.00 2,050.00 850.00 401K/SIMPLE CONTRIBUTIONS PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 1 Balance 7 401K/Simple 2,500.86 3,064.86 564.00 FICA TAXES PAYABLE - EMPLOYER OASDI BALANCE DATE 20-- Jan. ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $7,157.25 1 Balance 7 FICA Taxes Payable - Employer OASDI 596.92 594.70 1,191.62 ACCOUNT: FICA TAXES PAYABLE - EMPLOYER HI BALANCE DATE ITEM 20-- Taxes paid last quarter $1,673.87 Jan. 1 Balance 7 FICA Taxes Payable - Employer HI ACCOUNT: DEBIT CREDIT DEBIT CREDIT 166.67 306.27 139.60 SUTA TAXES PAYABLE - EMPLOYER BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. 1 Balance 7 SUTA Taxes Payable - Employer 553.59 350.00 903.59 DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping X MN S.S. ACCOUNT NO. 000-00-1534 UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 40 1/7 HRS. RATE 0.00 YEAR-TO-DATE 1 CUMULATIVE 16.75 670.00 2 25.13 AMOUNT S $ W/H MARITAL $ $ $ ALLOW. STATUS DEDUCTIONS EARNINGS HRS. Nikki SALARY Health Insurance (Pre-tax FIT) $55/payperiod 20___ 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.26 720.26 44.66 10.44 58.00 12.81 5.04 6.40 25.00 55.00 502.91 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 UNION DUES OTHER WEEKLY RATE OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS RATE 1/7 AMOUNT HRS. RATE 0.00 40 13.25 530.00 0 19.88 AMOUNT 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 0.00 530.00 32.86 7.69 38.00 8.74 3.71 4.37 38.00 55.00 341.63 3 4 QTR. TOT. YR. TOT. OCCUPATION STATUS NET PAID FICA 2 DEPARTMENT MARITAL ALLOW. DEDUCTIONS EARNINGS HRS. 1 CUMULATIVE W W/H $ $ HOURLY RATE PAYDAY YEAR-TO-DATE Stephanie $ $ SALARY Health Insurance (Pre-tax FIT) $55/payperiod 20___ FIRST Barr OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST M Hospitality Housekeeping MN F x 000-00-2415 Duginski OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE UNION DUES OTHER WEEKLY RATE HOURLY RATE Health Insurance (Pre-tax FIT) $105/payperiod 20___ OVERTIME EARNINGS PAYDAY RATE AMOUNT 40 1/7 HRS. RATE 0.00 12.50 500.00 5 18.75 AMOUNT W/H MARITAL $ $ ALLOW. STATUS DEDUCTIONS EARNINGS YEAR-TO-DATE 1 CUMULATIVE J $ $ OVERTIME RA REGULAR EARNINGS HRS. Samual SALARY 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.06 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 UNION DUES OTHER WEEKLY RATE OVERTIME RA OVERTIME EARNINGS PAYDAY RATE AMOUNT 1/7 HRS. RATE 0.00 40 14.90 596.00 1 22.35 AMOUNT MARITAL ALLOW. STATUS DEDUCTIONS EARNINGS YEAR-TO-DATE 1 CUMULATIVE P W/H $ $ HOURLY RATE REGULAR EARNINGS HRS. Morgan $ $ SALARY Health Insurance (Pre-tax FIT) $105/payperiod 20___ 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.15 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN x S.S. ACCOUNT NO. NAME - LAST FIRST Hines Terrance F 000-00-7826 J OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE OTHER 20___ REGULAR EARNINGS OVERTIME EARNINGS HRS. RATE AMOUNT 1 39 1/7 HRS. RATE 0.00 11.85 462.15 0 17.78 $ CUMULATIVE AMOUNT W/H MARITAL ALLOW. STATUS DEDUCTIONS EARNINGS YEAR-TO-DATE OVERTIME RA WEEKLY RATE Health Insurance (Pre-tax FIT) $105/payperiod PAYDAY HOURLY RATE $ $ $ SALARY UNION DUES 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 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 DEDUCTIONS INFORMATION HEALTH INSURANCE OTHER AMOUNT 1 1/7 HRS. RATE 0.00 40 26.38 1,055.00 12 39.56 AMOUNT S $ $ $ $ WEEKLY RATE CUMULATIVE W/H MARITAL ALLOW. STATUS DEDUCTIONS EARNINGS RATE Adamao OVERTIME RA OVERTIME EARNINGS PAYDAY HRS. Jama HOURLY RATE REGULAR EARNINGS YEAR-TO-DATE FIRST SALARY UNION DUES Health Insurance (Pre-tax FIT) $55/payperiod 20___ 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.72 1,529.72 94.84 22.18 258.04 28.00 10.71 14.00 75.00 55.00 971.95 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Office Supervisor MN x S.S. ACCOUNT NO. 000-00-4567 OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE UNION DUES NAME - LAST FIRST F Lee SALARY OTHER WEEKLY RATE Min $ $ S monthly W/H MARITAL ALLOW. STATUS 20___ OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 40 1/7 HRS. RATE 0.00 YEAR-TO-DATE 1 CUMULATIVE DEDUCTIONS EARNINGS HRS. 18.75 $ $ HOURLY RATE Health Insurance (Pre-tax FIT) $105/payperiod 750.00 0 28.13 AMOUNT 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 0.00 750.00 46.50 10.88 0.00 11.70 5.25 5.85 60.00 105.00 504.82 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Office Accounting X MN S.S. ACCOUNT NO. 000-00-5537 UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS PAYDAY RATE AMOUNT 1/7 HRS. RATE 0.00 YEAR-TO-DATE 1 CUMULATIVE 40 24.25 970.16 1 36.38 AMOUNT N monthly W/H MARITAL ALLOW. STATUS DEDUCTIONS EARNINGS HRS. Tammi $ $ $ $ SALARY 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.54 62.41 14.59 96.00 17.93 7.05 8.97 55.00 55.00 689.59 2 3 4 QTR. TOT. YR. TOT. 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 Vick OTHER Tomika HOURLY RATE $ $ $ OVERTIME RA $ SALARY WEEKLY RATE N monthly W/H MARITAL ALLOW. STATUS 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 Country Hotel and Resort 675 Sunnybrook Lane Northern MN 12345 000-00-7826 1 Wages, tips, other compensation 2 Federal income tax withheld 00-1111123 $462.15 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 P000123 13 Statutory employee 16 State wages, tips, etc. Retirement plan X 14 Other 17 State income tax $6.34 Third-party sick pay 18 Local wages, tips, etc. 12c 12d 19 Local income tax 20 Locality Name Type your corrections below. For the Period Ending: Jan. 07, 20XX Regular Earnings No. Employee Marital Status Allow. Hours Hourly Rate Overtime Earnings Earnings Hours Hourly Rate 300 Adams, Nikki S 2 40 $ 16.75 $ 670.00 2 $ 25.13 111 Barr, Stephanie S 1 40 $ 13.25 $ 530.00 0 $ 19.88 208 Duginski, Samuel M 3 40 $ 12.50 $ 500.00 5 $ 18.75 198 Glander, Morgan M 5 40 $ 14.90 $ 596.00 1 $ 22.35 189 Hines, Terrance M 4 39 $ 11.85 $ 462.15 0 $ 17.78 68 Jama, Adamo S 0 40 $ 26.38 $ 1,055.00 12 $ 39.56 45 Lee, Min M 8 40 $ 18.75 $ 750.00 0 $ 28.13 17 Rorberts, Tammi S 2 40 $ 24.25 $ 970.16 1 $ 36.38 12 Vick, Tomika M 6 40 $ 26.77 $ 1,070.77 0 $ 40.15 9 Yo, Margaret M 4 $ 2,346.15 $ 8,950.23 Totals North Country Hotel and Resort Payroll Register Overtime Earnings FICA Total Gross Earnings Earnings $ $ 50.25 - Health Plan 401K / Simple OASDI HI FIT SIT $ 720.25 $ 55.00 $ 25.00 $ 44.66 $ 10.44 $ 58.00 $ 12.81 $ 530.00 $ 55.00 $ 38.00 $ 32.86 $ 7.69 $ 38.00 $ 8.74 $ 4.00 $ 8.74 $ 93.75 $ 593.75 $ 105.00 $ 52.00 $ 36.81 $ 8.61 $ 22.35 $ 618.35 $ 105.00 $ 28.00 $ 38.34 $ 8.97 $ - $ 9.71 $ 462.15 $ 105.00 $ 40.00 $ 28.65 $ 6.70 $ - $ 6.34 $ 1,529.75 $ 55.00 $ 75.00 $ 94.84 $ 22.18 258.04 $ 28.00 $ 750.00 $ 105.00 $ 60.00 $ 46.50 $ 10.88 $ - $ 11.70 $ 1,006.54 $ 55.00 $ 55.00 $ 62.41 $ 14.59 $ 96.00 $ 17.93 $ 1,070.77 $ 105.00 $ 66.00 $ 66.39 $ 15.53 $ 27.00 $ 18.00 $ 2,346.15 $ 105.00 $ 125.00 $ 145.46 $ 34.02 $ 249.04 $ 42.32 $ 9,627.71 $ 850.00 $ 564.00 $ 596.92 $ 139.60 $ 730.08 $ 164.27 $ $ $ $ $ $ 474.75 36.38 677.48 $ Net Pay CIT SUTA Check No. Taxable Earnings Amount OASDI HI Income Taxes FUTA $ 6.40 $ 5.04 21313 $ 502.90 $ 720.25 $ 720.25 $ 640.25 $ 720.25 $ 4.37 $ 3.71 21314 $ 341.64 $ 530.00 $ 530.00 $ 437.00 $ 530.00 $ 4.37 $ 4.16 21315 $ 370.07 $ 593.75 $ 593.75 $ 436.75 $ 593.75 $ 4.85 $ 4.33 21316 $ 419.16 $ 618.35 $ 618.35 $ 485.35 $ 618.35 $ 3.17 $ 3.24 21317 $ 269.05 $ 462.15 $ 462.15 $ 317.15 $ 462.15 $ 14.00 $ 10.71 21318 $ 971.98 $ 1,529.75 $ 1,529.75 $ 1,399.75 $ 1,529.75 $ 5.85 $ 5.25 21319 $ 504.83 $ 750.00 $ 750.00 $ 585.00 $ 750.00 $ 8.97 $ 7.05 21320 $ 689.60 $ 1,006.54 $ 1,006.54 $ 896.54 $ 1,006.54 $ 9.00 $ 7.50 21321 $ 756.37 $ 1,070.77 $ 1,070.77 $ 899.77 $ 1,070.77 $ 21.16 $ 16.42 21322 $ 1,607.73 $ 2,346.15 $ 2,346.15 $ 2,116.15 $ 2,346.15 $ 82.14 $ 67.39 $ 6,433.31 $ 9,627.71 $ 9,627.71 $ 8,213.71 $ 9,627.71 Employer Taxes Taxable Earnings Rate OASDI $ 9,627.71 6.2% HI $ 9,627.71 1.45% FUTA $ 9,627.71 1% SUTA $ 9,627.71 5.75% s SUTA $ 720.25 $ 530.00 $ 593.75 $ 618.35 $ 462.15 $ 1,529.75 $ 750.00 $ 1,006.54 $ 1,070.77 $ 2,346.15 $ 9,627.71 er Taxes OASDI Tax $ 596.92 $ HI Tax 139.60 FUTA Tax $ 57.77 $ SUTA Tax 553.59