Payroll
Content
PAYROLL CALCULATOR
ID
Employee Name
1001
PERIOD ENDING:
Reg Hours
Worked
50
Vacatio
n Hours
5
1002
E
40
1003
B
35
3
1008
D
50
5
1011
E
40
1012
V
40
1025
E
36
1032
D
40
5
1049
F
40
1
Totals
8
371
24
Sick
Hours
Overti
me
Hours
1
1
2
5
Overtim
e Rate
$15.00
1
2
1
1
#REF!
3
$18.00
Gross
Pay
Taxes and
Ded's
Other
Ded's
$20.00
4/8/2013
Net Pay
COMPANY NAME:
Hourly
Wage
Tax
Status
ADVENTURE WORKS
Federal
Allow.
State
Tax
Federal
Income Tax
Soc. Security
Tax
Medicare
Tax
Total Taxes
Withheld
Insurance
Deduction
Other Reg.
Deduction
Total Reg.
Deductions
#REF!
#REF!
#REF!
$10.00
1
4
2.30%
28.00%
6.30%
1.45%
#REF!
$20.00
$40.00
$60.00
#REF!
#REF!
#REF!
$8.00
1
1
2.30%
28.00%
6.30%
1.45%
#REF!
-
$10.00
$10.00
#REF!
#REF!
#REF!
$14.00
1
3
2.30%
28.00%
6.30%
1.45%
#REF!
$18.00
$20.00
$38.00
#REF!
#REF!
#REF!
$20.00
1
0
2.30%
28.00%
6.30%
1.45%
#REF!
$15.00
#REF!
#REF!
#REF!
$10.00
1
0
2.30%
28.00%
6.30%
1.45%
#REF!
$20.00
$40.00
$60.00
#REF!
#REF!
#REF!
$12.00
1
4
2.30%
28.00%
6.30%
1.45%
#REF!
$20.00
$40.00
$60.00
#REF!
#REF!
$25.00
#REF!
$12.00
1
2
2.30%
28.00%
6.30%
1.45%
#REF!
$25.00
$20.00
$45.00
#REF!
#REF!
$50.00
#REF!
$10.00
1
3
2.30%
28.00%
6.30%
1.45%
#REF!
#REF!
#REF!
$23.00
#REF!
$15.00
1
2
2.30%
28.00%
6.30%
1.45%
#REF!
#REF!
#REF!
#REF!
#REF!
$15.00
$25.00
$143.00
$25.00
$170.00
#REF!
ID
Employee Name
1001
PERIOD ENDING:
Reg Hours
Worked
50
Vacatio
n Hours
5
1002
E
40
1003
B
35
3
1008
D
50
5
1011
E
40
1012
V
40
1025
E
36
1032
D
40
5
1049
F
40
1
Totals
8
371
24
Sick
Hours
Overti
me
Hours
1
1
2
5
Overtim
e Rate
$15.00
1
2
1
1
#REF!
3
$18.00
Gross
Pay
Taxes and
Ded's
Other
Ded's
$20.00
4/8/2013
Net Pay
COMPANY NAME:
Hourly
Wage
Tax
Status
ADVENTURE WORKS
Federal
Allow.
State
Tax
Federal
Income Tax
Soc. Security
Tax
Medicare
Tax
Total Taxes
Withheld
Insurance
Deduction
Other Reg.
Deduction
Total Reg.
Deductions
#REF!
#REF!
#REF!
$10.00
1
4
2.30%
28.00%
6.30%
1.45%
#REF!
$20.00
$40.00
$60.00
#REF!
#REF!
#REF!
$8.00
1
1
2.30%
28.00%
6.30%
1.45%
#REF!
-
$10.00
$10.00
#REF!
#REF!
#REF!
$14.00
1
3
2.30%
28.00%
6.30%
1.45%
#REF!
$18.00
$20.00
$38.00
#REF!
#REF!
#REF!
$20.00
1
0
2.30%
28.00%
6.30%
1.45%
#REF!
$15.00
#REF!
#REF!
#REF!
$10.00
1
0
2.30%
28.00%
6.30%
1.45%
#REF!
$20.00
$40.00
$60.00
#REF!
#REF!
#REF!
$12.00
1
4
2.30%
28.00%
6.30%
1.45%
#REF!
$20.00
$40.00
$60.00
#REF!
#REF!
$25.00
#REF!
$12.00
1
2
2.30%
28.00%
6.30%
1.45%
#REF!
$25.00
$20.00
$45.00
#REF!
#REF!
$50.00
#REF!
$10.00
1
3
2.30%
28.00%
6.30%
1.45%
#REF!
#REF!
#REF!
$23.00
#REF!
$15.00
1
2
2.30%
28.00%
6.30%
1.45%
#REF!
#REF!
#REF!
#REF!
#REF!
$15.00
$25.00
$143.00
$25.00
$170.00
#REF!
