Payroll Register and Payroll Journal Entry

Mary Losch operates a travel agency called Marys Luxury Travel. She has five employees, all of whom are paid on a weekly basis. The travel agency uses a payroll register, individual employee earnings records, and a general journal.

Marys Luxury Travel uses a weekly federal income tax withholding table. Refer to Figure 8-4 in the text. The payroll data for each employee for the week ended March 22, 20, are given. Employees are paid 1 times the regular rate for working over 40 hours a week.

Name No. of

Allowances Marital

Status Total Hours

Worked Mar. 1622

Rate Total Earnings

Jan. 1Mar. 15

Bacon, Andrea 4 M 44 $14.00 $6,300.00

Cole, Andrew 1 S 40 15.00 6,150.00

Hicks, Melvin 3 M 44 13.50 5,805.00

Leung, Cara 1 S 36 14.00 5,600.00

Melling, Melissa 2 M 40 14.50 5,945.00

Social Security tax is withheld from the first $128,400 of earnings at the rate of 6.2%. Medicare tax is withheld at the rate of 1.45%, and city earnings tax at the rate of 1%, both applied to gross pay. Bacon and Leung have $15 withheld and Cole and Hicks have $10 withheld for health insurance. Bacon and Leung have $20 withheld to be invested in the travel agencys credit union. Cole has $38.75 withheld and Hicks has $18.75 withheld under a savings bond purchase plan.

Marys Luxury Travels payroll is met by drawing checks on its regular bank account. The checks were issued in sequence, beginning with Check No. 423.

Required:

1. Prepare a payroll register for Marys Luxury Travel for the week ended March 22, 20--. (In the Taxable Earnings/Unemployment Compensation column, enter the same amounts as in the Social Security column.) Total the amount columns.

If required, round your answers to the nearest cent.

Payroll Register for Period Ended March 22 20--

Earnings Taxable Earnings Deductions

Name No. of Allow. Marit. Status

Regular

Overtime

Total Cumulative Total Unemploy. Comp. Social Security Federal Income Tax Social Security Tax Medicare Tax

City Tax Health Insurance Other

Total Net Pay Ck. No.

Bacon, Andrea 4 M fill in the blank 9b4f5a041fd6faa_1 fill in the blank 9b4f5a041fd6faa_2 fill in the blank 9b4f5a041fd6faa_3 fill in the blank 9b4f5a041fd6faa_4 fill in the blank 9b4f5a041fd6faa_5 fill in the blank 9b4f5a041fd6faa_6 fill in the blank 9b4f5a041fd6faa_7 fill in the blank 9b4f5a041fd6faa_8 fill in the blank 9b4f5a041fd6faa_9 fill in the blank 9b4f5a041fd6faa_10 fill in the blank 9b4f5a041fd6faa_11

Credit Union

fill in the blank 9b4f5a041fd6faa_13 fill in the blank 9b4f5a041fd6faa_14 fill in the blank 9b4f5a041fd6faa_15 fill in the blank 9b4f5a041fd6faa_16

Cole, Andrew 1 S fill in the blank 9b4f5a041fd6faa_17 fill in the blank 9b4f5a041fd6faa_18 fill in the blank 9b4f5a041fd6faa_19 fill in the blank 9b4f5a041fd6faa_20 fill in the blank 9b4f5a041fd6faa_21 fill in the blank 9b4f5a041fd6faa_22 fill in the blank 9b4f5a041fd6faa_23 fill in the blank 9b4f5a041fd6faa_24 fill in the blank 9b4f5a041fd6faa_25 fill in the blank 9b4f5a041fd6faa_26

Bonds

fill in the blank 9b4f5a041fd6faa_28 fill in the blank 9b4f5a041fd6faa_29 fill in the blank 9b4f5a041fd6faa_30 fill in the blank 9b4f5a041fd6faa_31

Hicks, Melvin 3 M fill in the blank 9b4f5a041fd6faa_32 fill in the blank 9b4f5a041fd6faa_33 fill in the blank 9b4f5a041fd6faa_34 fill in the blank 9b4f5a041fd6faa_35 fill in the blank 9b4f5a041fd6faa_36 fill in the blank 9b4f5a041fd6faa_37 fill in the blank 9b4f5a041fd6faa_38 fill in the blank 9b4f5a041fd6faa_39 fill in the blank 9b4f5a041fd6faa_40 fill in the blank 9b4f5a041fd6faa_41 fill in the blank 9b4f5a041fd6faa_42

Bonds

fill in the blank 9b4f5a041fd6faa_44 fill in the blank 9b4f5a041fd6faa_45 fill in the blank 9b4f5a041fd6faa_46 fill in the blank 9b4f5a041fd6faa_47

Leung, Cara 1 S fill in the blank 9b4f5a041fd6faa_48 fill in the blank 9b4f5a041fd6faa_49 fill in the blank 9b4f5a041fd6faa_50 fill in the blank 9b4f5a041fd6faa_51 fill in the blank 9b4f5a041fd6faa_52 fill in the blank 9b4f5a041fd6faa_53 fill in the blank 9b4f5a041fd6faa_54 fill in the blank 9b4f5a041fd6faa_55 fill in the blank 9b4f5a041fd6faa_56 fill in the blank 9b4f5a041fd6faa_57

Credit Union

fill in the blank 9b4f5a041fd6faa_59 fill in the blank 9b4f5a041fd6faa_60 fill in the blank 9b4f5a041fd6faa_61 fill in the blank 9b4f5a041fd6faa_62

Melling, Melissa 2 M fill in the blank 9b4f5a041fd6faa_63 fill in the blank 9b4f5a041fd6faa_64 fill in the blank 9b4f5a041fd6faa_65 fill in the blank 9b4f5a041fd6faa_66 fill in the blank 9b4f5a041fd6faa_67 fill in the blank 9b4f5a041fd6faa_68 fill in the blank 9b4f5a041fd6faa_69 fill in the blank 9b4f5a041fd6faa_70 fill in the blank 9b4f5a041fd6faa_71 fill in the blank 9b4f5a041fd6faa_72 fill in the blank 9b4f5a041fd6faa_73 fill in the blank 9b4f5a041fd6faa_74

fill in the blank 9b4f5a041fd6faa_75 fill in the blank 9b4f5a041fd6faa_76 fill in the blank 9b4f5a041fd6faa_77 fill in the blank 9b4f5a041fd6faa_78 fill in the blank 9b4f5a041fd6faa_79 fill in the blank 9b4f5a041fd6faa_80 fill in the blank 9b4f5a041fd6faa_81 fill in the blank 9b4f5a041fd6faa_82 fill in the blank 9b4f5a041fd6faa_83 fill in the blank 9b4f5a041fd6faa_84 fill in the blank 9b4f5a041fd6faa_85 fill in the blank 9b4f5a041fd6faa_86 fill in the blank 9b4f5a041fd6faa_87 fill in the blank 9b4f5a041fd6faa_88

Feedback

Enter earnings for each employee in the first six columns and calculate deductions based on the information in the problem data. Select the type of other deduction, calculate net pay, and assign a check number. Be sure to use the correct marital status table and the correct column and row to determine federal income tax. Total the columns and verify that the amounts calculate across.

2. Assuming that the wages for the week ended March 22 were paid on March 24, prepare the journal entry for the payment of the payroll.

Page: 1

DATE ACCOUNT TITLE DOC.

NO. POST.

REF. DEBIT CREDIT

1 20--

Mar. 24

Wages and Salaries Expense

fill in the blank c77789f3df96f7f_2 fill in the blank c77789f3df96f7f_3 1

2

Employee Federal Income Tax Payable

fill in the blank c77789f3df96f7f_5 fill in the blank c77789f3df96f7f_6 2

3

Social Security Tax Payable

fill in the blank c77789f3df96f7f_8 fill in the blank c77789f3df96f7f_9 3

4

Medicare Tax Payable

fill in the blank c77789f3df96f7f_11 fill in the blank c77789f3df96f7f_12 4

5

City Tax Payable

fill in the blank c77789f3df96f7f_14 fill in the blank c77789f3df96f7f_15 5

6

Health Insurance Premiums Payable

fill in the blank c77789f3df96f7f_17 fill in the blank c77789f3df96f7f_18 6

7

Credit Union Payable

fill in the blank c77789f3df96f7f_20 fill in the blank c77789f3df96f7f_21 7

8

U.S. Savings Bonds Payable

fill in the blank c77789f3df96f7f_23 fill in the blank c77789f3df96f7f_24 8

9

Cash

fill in the blank c77789f3df96f7f_26 fill in the blank c77789f3df96f7f_27 9

10 Payroll for week ended March 22 10