I need this assignment done for accounting. Its about accounting. the info is in excel its about payroll.

Page 20 JOURNAL DATE DESCRIPTION DEBIT CREDIT 20-- JOURNAL Page 21 DATE 20-- DESCRIPTION DEBIT CREDIT Page 22 JOURNAL DATE DESCRIPTION DEBIT CREDIT 20-- Page 23 JOURNAL DATE 20-- DESCRIPTION DEBIT CREDIT GENERAL LEDGER ACCOUNT: CASH BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan ACCOUNT: 1 Balance 100,000.32 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-- Jan. ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $7,157.31 1 Balance 594.67 ACCOUNT: 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 Taxes paid last quarter $15,854.00 1 Balance CREDIT 5,350.26 EMPLOYEES SIT PAYABLE BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. 1 Balance 1,134.66 ACCOUNT: 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. ACCOUNT: 1 Balance 320.00 HEALTH INSURANCE PREMIUMS PAYABLE BALANCE DATE 20-- ITEM DEBIT CREDIT DEBIT CREDIT 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. ACCOUNT: ITEM DEBIT CREDIT DEBIT CREDIT Taxes paid last quarter $7,157.25 1 Balance 594.70 FICA TAXES PAYABLE - EMPLOYER HI BALANCE DATE ITEM DEBIT CREDIT DEBIT CREDIT 20-- Jan. ACCOUNT: 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 WEEKLY RATE HOURLY RATE OVERTIME EARNINGS PAYDAY RATE AMOUNT HRS. RATE 0.00 AMOUNT 0.00 STATUS NET PAID FICA OASDI 0.00 MARITAL ALLOW. DEDUCTIONS EARNINGS HRS. 1 CUMULATIVE S W/H $ OVERTIME RA REGULAR EARNINGS YEAR-TO-DATE Nikki $ $ $ SALARY Health Insurance (Pre-tax FIT) $55/payperiod 20___ FIRST Adams OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping x MN S.S. ACCOUNT NO. 000-00-2212 UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS PAYDAY YEAR-TO-DATE 1 CUMULATIVE RATE AMOUNT 0.00 HRS. RATE AMOUNT 0.00 MARITAL ALLOW. STATUS NET PAID FICA OASDI 0.00 W W/H DEDUCTIONS EARNINGS HRS. Stephanie $ $ $ $ SALARY Health Insurance (Pre-tax FIT) $55/payperiod 20___ FIRST Barr OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE 0.00 DEDUCTIONS AMOUNT 0.00 0.00 1/7 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN S.S. ACCOUNT NO. NAME - LAST FIRST Duginski Samual F 000-00-2415 J Hospitality Housekeeping MN x 000-00-2415 Duginski OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE UNION DUES OTHER OVERTIME EARNINGS PAYDAY AMOUNT 1 HRS. RATE 0.00 YEAR-TO-DATE MARITAL $ $ $ ALLOW. STATUS CUMULATIVE DEDUCTIONS EARNINGS RATE W/H WEEKLY RATE OVERTIME RA REGULAR EARNINGS HRS. SALARY HOURLY RATE Health Insurance (Pre-tax FIT) $105/payperiod 20___ Samual $ AMOUNT OASDI 0.00 0.00 NET PAID FICA OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 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 HOURLY RATE OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS PAYDAY 1 CUMULATIVE RATE AMOUNT 0.00 HRS. RATE AMOUNT 0.00 MARITAL ALLOW. STATUS NET PAID FICA OASDI 0.00 P W/H DEDUCTIONS EARNINGS HRS. YEAR-TO-DATE Morgan $ $ $ $ SALARY Health Insurance (Pre-tax FIT) $105/payperiod 20___ FIRST Glander OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 2 3 4 QTR. TOT. YR. TOT. DEPARTMENT OCCUPATION WORKS IN (STATE) SEX M Hospitality Housekeeping MN OTHER DEDUCTIONS INFORMATION x S.S. ACCOUNT NO. NAME - LAST FIRST F 000-00-7826 Hines SALARY Terrance $ J W/H MARITAL HEALTH INSURANCE UNION DUES OTHER Health Insurance (Pre-tax FIT) $105/payperiod 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. RATE AMOUNT 1 HRS. RATE 0.00 $ $ OVERTIME RA $ CUMULATIVE AMOUNT 0.00 STATUS NET PAID FICA OASDI 0.00 ALLOW. DEDUCTIONS EARNINGS YEAR-TO-DATE HOURLY RATE WEEKLY RATE OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 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 UNION DUES OTHER WEEKLY RATE HOURLY RATE OVERTIME RA REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. 1 CUMULATIVE RATE AMOUNT 0.00 HRS. RATE AMOUNT 0.00 MARITAL ALLOW. STATUS NET PAID FICA OASDI 0.00 S W/H DEDUCTIONS EARNINGS YEAR-TO-DATE Adamao $ $ $ $ SALARY Health Insurance (Pre-tax FIT) $55/payperiod 20___ FIRST Jama OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 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 Health Insurance (Pre-tax FIT) $105/payperiod UNION DUES NAME - LAST FIRST F Lee SALARY OTHER WEEKLY RATE HOURLY RATE Min $ $ $ S monthly W/H MARITAL ALLOW. STATUS Health Insurance (Pre-tax FIT) $105/payperiod 20___ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. 1 CUMULATIVE DEDUCTIONS EARNINGS RATE AMOUNT HRS. RATE 0.00 YEAR-TO-DATE $ OVERTIME RA AMOUNT 0.00 OASDI 0.00 NET PAID FICA OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 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 HRS. 1 CUMULATIVE RATE AMOUNT 0.00 HRS. RATE AMOUNT 0.00 W/H MARITAL ALLOW. STATUS NET PAID FICA OASDI 0.00 N monthly DEDUCTIONS EARNINGS YEAR-TO-DATE Tammi $ $ $ $ SALARY Health Insurance (Pre-tax FIT) $55/payperiod 20___ FIRST Rorberts OTHER DEDUCTIONS INFORMATION HEALTH INSURANCE NAME - LAST F OTHER HI 0.00 FIT 0.00 SIT 0.00 SUTA 0.00 0.00 CIT 0.00 SIMPLE DEDUCTIONS 0.00 AMOUNT 0.00 0.00 1/7 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 SALARY OTHER WEEKLY RATE HOURLY RATE OVERTIME RA Tomika $ $ $ $ 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 1 Wages, tips, other compensation 2 Federal income tax withheld 3 Social security wages 4 Social security tax withheld 5 Medicare wages and tips 6 Medicare tax withheld 7 Social security tips 8 Allocated tips 9 10 Dependent care benefits 11 Nonqualified plans 12a 12b d Control Number e Employee's First name and initial Last Name f Employee's address and ZIP Code 15 State Employer's State ID Number 13 Statutory employee 16 State wages, tips, etc. Retirement plan X 14 Other 17 State income tax 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 S 2 40 $ 16.75 Hourly Rate 300 Adams, Nikki 111 Barr, Stephanie S 1 40 $ 13.25 208 Duginski, Samuel M 3 40 $ 12.50 198 Glander, Morgan M 5 40 $ 14.90 189 Hines, Terrance M 4 39 $ 11.85 68 Jama, Adamo S 0 40 $ 26.38 45 Lee, Min M 8 40 $ 18.75 17 Rorberts, Tammi S 2 40 $ 24.25 12 Vick, Tomika M 6 40 $ 26.77 9 Yo, Margaret M 4 Totals You will need to submit the Payroll Problem Template using each of the following worksheets: Journal, General Ledger, Em Employee Earnings Record Worksheet January 7: Use the information from the payroll register to complete each employee's earnings Journal Worksheet January 7: Prepare the journal entry to transfer cash from the regular Cash account to the Payr January 7: Prepare the journal entry to record the employee's payroll, payroll taxes and net pay January 7: Prepare the journal entry to record the employer's taxes and liabilities created. POS . January 12: Prepare the journal entry to record the pay checks are issued to employees. January 15: North Country Hotel and Resort is a monthly depositor and pays its FICA taxes and January 15: Prepare the journal entry the deposit of the December city taxes. City taxes are du January 15: State tax (SIT) is due. Prepare the journal entry to deposit the State income taxes. W2 Worksheet Prepare a W2 for Terrance Hinz. January 7 was her last day of work. Terrance's address is 755 941 Worksheet The quarterly report was filed on a 941. A new employee has completed a rough draft of Form 9 January 19: On January 1, North Country Hotel and Resort hired an independent contractor to North Country Ho Payroll R gular Earnings Overtime Earnings Earnings Hours $ 670.00 $ 530.00 $ 500.00 5 $ 596.00 1 $ 462.15 $ 1,055.00 $ 750.00 $ 970.15 $ 1,070.77 $ 2,346.15 $ 8,950.23 2 12 1 Hourly Rate Earnings $ 25.13 $ $ 19.88 $ 18.75 $ 93.75 $ 22.35 $ 22.35 $ 17.78 $ 39.56 $ $ 28.13 $ 36.38 $ $ 40.15 $ 50.25 474.75 36.38 677.48 Total Gross Earnings $ 720.25 $ 530.00 $ 593.75 $ 618.35 $ 462.15 $ 1,529.75 $ 750.00 $ 1,006.53 $ 1,070.77 $ 2,346.15 $ 9,627.71 $ 9,627.71 Journal, General Ledger, Employee's Earnings Record, W2, and 941 North Country Hotel and Resort EOY. employee's earnings record. Complete the highlighted cells for each employee. h account to the Payroll cash account for the net amount of the total payroll. POST to the General Ledg roll taxes and net pay for the January 7 pay week. POST to the General Ledger Worksheet. abilities created. POST to the General Ledger Worksheet. to employees. POST to the General Ledger Worksheet. ays its FICA taxes and federal income taxes on the 15th of the following month. Use the January 1 beginn xes. City taxes are due on the 15th of the following month. Use the January 1 balances. POST to the Ge e State income taxes. Use the January 1 balances. POST to the General Ledger Worksheet. ance's address is 755 Woodridge Ave, Hoover MN 12345. North Country Hotel and Resort EIN is 00-1111 rough draft of Form 941 (see 941 workbook page) for the quarter ending December of last year. You are pendent contractor to develop scheduling software. This is a year contract for $120,000/annual. The contr North Country Hotel and Resort Payroll Register FICA Health Plan $ 401K / Simple OASDI HI FIT SIT CIT SUTA 55.00 $ 25.00 $ 44.66 $ 10.44 $ 58.00 $ 12.81 $ 6.40 $ 5.04 $ 55.00 $ 38.00 $ 32.86 $ 7.69 $ 38.00 $ 8.74 $ 4.37 $ 3.71 $ 105.00 $ 52.00 $ 36.81 $ 8.61 $ 4.00 $ 8.74 $ 4.37 $ 4.16 $ 105.00 $ 28.00 $ 38.34 $ 8.97 $ - $ 9.71 $ 4.85 $ 4.33 $ 105.00 $ 40.00 $ 28.65 $ 6.70 $ - $ 6.34 $ 3.17 $ 3.24 $ 55.00 $ 75.00 $ 94.84 $ 22.18 $ 258.04 $ 28.00 $ 14.00 $ 10.71 $ 105.00 $ 60.00 $ 46.50 $ 10.88 - $ 11.70 $ 5.85 $ 5.25 $ 55.00 $ 55.00 $ 62.41 $ 14.59 $ 96.00 $ 17.93 $ 8.97 $ 7.05 $ 105.00 $ 66.00 $ 66.39 $ 15.53 $ 27.00 $ 18.00 $ 9.00 $ 7.50 $ 105.00 $ 125.00 $ 145.46 $ 34.02 $ 249.04 $ 42.32 $ 21.16 $ 16.42 $ 850.00 $ 564.00 $ 596.92 $ 139.61 $ 730.08 $ 164.29 $ 82.14 $ 67.41 $ 3,194.45 $ to the General Ledger Worksheet. Worksheet. e the January 1 beginning balances in the FICA and FIT accounts to record the deposit of the December t ces. POST to the General Ledger Worksheet. Worksheet. Resort EIN is 00-1111123. The Employer State ID is P000123. The employer address is 675 Sunnybrook r of last year. You are auditing the form before submitting it. The balances from last quarter are in the gen 000/annual. The contractor is paid bi-weekly on Fridays. The first pay period is for the week January 1-5 a Net Pay Check No. Taxable Earnings Amount OASDI Income Taxes HI FUTA 21313 $ 502.90 $ 720.25 $ 720.25 $ 640.25 $ 720.25 21314 $ 341.63 $ 530.00 $ 530.00 $ 437.00 $ 530.00 21315 $ 370.06 $ 593.75 $ 593.75 $ 436.75 $ 593.75 21316 $ 419.15 $ 618.35 $ 618.35 $ 485.35 $ 618.35 21317 $ 269.05 $ 462.15 $ 462.15 $ 317.15 $ 462.15 21318 $ 971.98 $ 1,529.75 $ 1,529.75 $ 1,399.75 $ 1,529.75 21319 $ 504.82 $ 750.00 $ 750.00 $ 585.00 $ 750.00 21320 $ 689.58 $ 1,006.53 $ 1,006.53 $ 896.53 $ 1,006.53 21321 $ 756.35 $ 1,070.77 $ 1,070.77 $ 899.77 $ 1,070.77 21322 $ 1,607.73 $ 2,346.15 $ 2,346.15 $ 2,116.15 $ 2,346.15 $ 6,433.26 $ 9,627.71 $ 9,627.71 $ 8,213.71 $ 9,627.71 $ 6,433.26 $ 8,213.71 Employer Taxes Taxable OASDI Earnings Rate $ 9,627.71 0.0620 OASDI Tax $ 596.92 HI Tax HI $ 9,627.71 0.0145 osit of the December taxes. POST to the General Ledger Worksheet. FUTA SUTA $ 9,627.71 $ 9,627.71 $ 139.60 FUTA Tax 0.006 $ 57.77 0.0575 SUTA Tax $ 553.59 ss is 675 Sunnybrook Lane, Northern MN 12345. Be sure to complete the highlighted cells. quarter are in the general ledger accounts. The company is a semiweekly depositor. Indicate any change e week January 1-5 and January 8-12. Payday is January 19. Independent contractors are not employee s SUTA $ 720.25 $ 530.00 $ 593.75 $ 618.35 $ 462.15 $ 1,529.75 $ 750.00 $ 1,006.53 $ 1,070.77 $ 2,346.15 $ 9,627.71 . Indicate any changes or errors that should be made to the form before it is signed and submitted. Write ors are not employees, so the accounts payable department would normally issue the checks and genera and submitted. Write your changes in the text box provided to the right of the form. he checks and generate a 1099 at the end of the year. Calculate the first paycheck payment to the indepe payment to the independent contractor and record the journal entry. For our example you can use Salarie e you can use Salaries and Wages Expense and Cash accounts