Payroll Accounting 2012 Continuing Payroll Problem a

Only available on StudyMode
  • Topic: Payroll tax, Tax, Federal Insurance Contributions Act tax
  • Pages : 4 (703 words )
  • Download(s) : 1197
  • Published : December 8, 2012
Open Document
Text Preview
Name:

Ashley Pitchford

CAUTION: See "round" rules in Excel Instructions before calculating OT for salaried employees. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.

Continuing Payroll Problem-A KIPLEY COMPANY, INC.

PAYROLL REGISTER
FOR PERIOD ENDING

January 8, 20 - NO. OF W/H ALLOW.

REGULAR EARNINGS
HOURS WORKED HOURS WORKED

OVERTIME EARNINGS TOTAL AMOUNT EARNINGS OASDI FICA HI FIT SIT

DEDUCTIONS GROUP SUTA CIT SIMPLE INSURANCE HEALTH INSURANCE

MARITAL STATUS

EMPLOYEE

RATE PER HOUR

AMOUNT

RATE PER HOUR

11 Carson, Fran M. 12 Wilson, William A. 13 Utley, Harry T. 21 Fife, Lawrence R. 22 Smith, Lucy K. 31 Fay, Gretchen R. 32 Robey, Glenda B. 33 Schork, Thomas K. 51 Hardy, Barbara T. 99 Kipley, Carson C. Totals

S S M M S M M S M M

1 0 2 4 2 3 6 1 5 7

40 40 37.5 40 40 40 40 40 40 40

$7.50 $7.25 $8.10 $7.90 $9.75

300.00 290.00 303.75 316.00 390.00 515.00 392.31 542.31 348.46 1,000.00 4,397.83 4 $13.07 52.28 234.57 1.25 $19.32 24.15 6 $11.85 71.10 8 $10.88 87.04

300.00 377.04 303.75 387.10 390.00 539.15 392.31 542.31 400.74 1,000.00 4,632.40

18.60 23.38 18.83 24.00 24.18 33.43 24.32 33.62 24.85 62.00 287.21

4.35 5.47 4.40 5.61 5.66 7.82 5.69 7.86 5.81 14.50 67.17

18.00 35.00 21.00 13.00 48.00 28.00 163.00

9.21 11.58 9.33 11.88 11.97 16.55 12.04 16.65 12.30 30.70 142.21

0.24 0.30 0.24 0.31 0.31 0.43 0.31 0.43 0.32 0.80 3.69

9.00 11.31 9.11 11.61 11.70 16.17 11.77 16.27 12.02 30.00 138.96

20.00 50.00 40.00 50.00 20.00 40.00 50.00 60.00 30.00 80.00 440.00

0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 6.80

1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 1.65 16.50

JOURNAL
DATE DESCRIPTION DEBIT CREDIT

20-Jan. 12

Wages and Salaries FICA Taxes Payable - OASDI FICA Taxes Payable - HI Employees FIT Payable Employees SIT Payable Employees SUTA Payable Employees CIT Payable SIMPLE Deductions Payable Group...
tracking img