Payroll Accounting 2012 Continuing Payroll Problem a

Topics: Payroll tax, Tax, Federal Insurance Contributions Act tax Pages: 4 (703 words) Published: December 8, 2012
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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Kipley Company Payroll Register (Continuing Payroll Problem a) Essay
  • Essay about Payroll Accounting
  • Current Liabilities and Payroll Accounting Essay
  • Payroll Essay
  • Payroll Essay
  • Payroll Essay
  • Payroll Accounting Research Paper
  • Payroll Essay

Become a StudyMode Member

Sign Up - It's Free