Scribd
Upload
91 views13 pages

Payroll Summary Report

This document contains payroll information for 10 employees for the periods of 9-Oct and 23-Oct. It includes each employee's name, earnings, overtime hours worked, deductions taken for Social Security, Medicare, federal and state unemployment taxes. Totals are provided for gross earnings, Social Security, Medicare, FUTA and SUTA deductions for each period. Calculations are also shown for the FUTA and SUTA tax rates based on each employee's gross wages.

Uploaded by

ruqia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
91 views13 pages

Payroll Summary Report

This document contains payroll information for 10 employees for the periods of 9-Oct and 23-Oct. It includes each employee's name, earnings, overtime hours worked, deductions taken for Social Security, Medicare, federal and state unemployment taxes. Totals are provided for gross earnings, Social Security, Medicare, FUTA and SUTA deductions for each period. Calculations are also shown for the FUTA and SUTA tax rates based on each employee's gross wages.

Uploaded by

ruqia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 13

23-Oct

Regular Over time earning Reglr


Employee name Opg 9-Oct
4 Bonno A V 10293.4 1408 1028.6 0 1408
5 Ferguson, James C. 23125 2250 0 2250
2 Ford C L 6300 1220 0 1220
4 Mann, Dewey W 5400 1350 0 1350
3 O’Neill, Joseph T 42692.27 2307.69 0 2307.69
1 Russel V.A 6240 1200 0 1200
4 Ryan N.A 13287.5 1440 1397.8 0 1440
2 Sokowski, Thomas J 16650 2050 0 2050
1 Student 5550 1008 0 1008
0 William R V 10260 1223.08 0 1223.08

0.006 Futa Calculation Opg 9-Oct 23-Oct Total 7000

Ford 6300 700 7000 7000


Man 5400 1350 250 7000 7000
Russal 6240 760 7000 7000
Student 5550 1008 442 7000 7000

0.03689 SUTA Calculation


Ford 6300 1220 1220 8740 10000
Man 5400 1350 1350 8100 10000
Russal 6240 1200 1200 8640 10000
Student 5550 1008 1008 7566 10000

Gross OASDI HI FUTA SUTA


9-Oct Totals 15456.77 958.32 224.12 22.91 176.26
23-Oct Totals 15778.37 978.26 228.79 4.15 176.26
23-Oct 9-Oct
Overtime

105.6 14243.6
27625
8740
8100
47307.65
8640
216 17781.3
20750
7566
12706.16

Remaining balance

0
0
0
0

1260
1900
1360
2434
Regular
Hours Extra Regular
Allowance worked hour time loRate Extra h Regular 1 Extra 1
Plant 4 Bonno A V 80 17.6 1408
Sales 5 Ferguson, James C. 80 28.13 2250
Off 2 Ford C L 80 15.25 1220
sales 4 Mann, Dewey W 80 16.88 1350
Adm 3 O’Neill, Joseph T 80 2307.69
Off 1 Russel V.A 80 15 1200
Plant 4 Ryan N.A 80 18 1440
Plant 2 Sokowski, Thomas J 80 2050
Off 1 Student 72 14 1008
Off 0 William R V 80 15.29 1223.08

23 rd Oct
Plant 4 Bonno A V 80 4 17.6 26.4 1408 105.6
Sales 5 Ferguson, James C. 80 28.13 2250
Off 2 Ford C L 80 15.25 1220
sales 4 Mann, Dewey W 80 16.88 1350
Adm 3 O’Neill, Joseph T 80 2307.69
Off 1 Russel V.A 80 15 1200
Plant 4 Ryan N.A 80 8 18 27 1440 216
Plant 2 Sokowski, Thomas J 80 2050
Off 1 Student 72 14 1008
Off 0 William R V 80 15.29 1223.08
Earning Deductions
0.062 0.0145 0.0307 0.0006
6.2 1.45 3.07 0.06 3.8809
Gross FICA
C
k
Other Healt .
Gross OASDI HI FIT SIT SUTA CIT Deductio h
n ins N
o
.
1408 87.30 $ 20.42 31 43.23 $ 0.84 $ 54.64 $ 8.00
2250 139.50 $ 32.63 104 69.08 $ 1.35 $ 87.32
1220 75.64 $ 17.69 83 37.45 $ 0.73 $ 47.35
1350 83.70 $ 19.58 25 41.45 $ 0.81 $ 52.39
2307.69 143.08 $ 33.46 150 70.85 $ 1.38 $ 89.56
1200 74.40 $ 17.40 99 36.84 $ 0.72 $ 46.57
1440 89.28 $ 20.88 33 44.21 $ 0.86 $ 55.88 $ 8.00
2050 127.10 $ 29.73 138 62.94 $ 1.23 $ 79.56
1008 62.50 $ 14.62 75 30.95 $ 0.60 $ 39.12
1223.08 75.83 $ 17.73 121 37.55 $ 0.73 $ 47.47
15456.77 958.33 $ 224.14 828 474.55 9.25 599.86 16.00 ###
-

1513.6 93.84 $ 21.95 46.47 0.91 58.74 8


2250 139.50 $ 32.63 69.08 $ 1.35 $ 87.32
1220 75.64 $ 17.69 37.45 $ 0.73 $ 47.35
1350 83.70 $ 19.58 41.45 $ 0.81 $ 52.39
2307.69 143.08 $ 33.46 70.85 $ 1.38 $ 89.56
1200 74.40 $ 17.40 36.84 $ 0.72 $ 46.57
1656 102.67 $ 24.01 69.08 0.99 64.27 8
2050 127.10 $ 29.73 62.94 $ 1.23 $ 79.56
1008 62.50 $ 14.62 30.95 $ 0.60 $ 39.12
1223.08 75.83 $ 17.73 37.55 $ 0.73 $ 47.47
15778.37 978.26 $ 228.80 502.66 9.45 612.35
Net Amount

Amount

Amount

1162.57
1816.12
958.14
1127.07
1819.36
925.07
1187.89
1611.44
785.21
922.77
12,315.64
Regular
Hours Extra Regular
Allowance worked hour time loRate Extra h Regular 1 Extra 1
Plant 4 Bonno A V 80 4 17.6 26.4 1408 105.6
Sales 5 Ferguson, James C. 80 28.13 2250
Off 2 Ford C L 80 15.25 1220
sales 4 Mann, Dewey W 80 16.88 1350
Adm 3 O’Neill, Joseph T 80 2307.69
Off 1 Russel V.A 80 15 1200
Plant 4 Ryan N.A 80 8 18 27 1440 216
Plant 2 Sokowski, Thomas J 80 2050
Off 1 Student 72 14 1008
Off 0 William R V 80 15.29 1223.08

Gross OASDI HI FUTA SUTA

Totals 15778.37 978.26 228.79 582.06


0.062 0.0145 0.0307 0.0145 0.0006
6.2 1.45 3.07 0.06 3.8809
Earning Deductions
Gross FICA

Other
Health
Gross OASDI HI FIT SIT SUTA CIT Deductio
ins
n

1513.6 93.84 $ 21.95 41 46.47 $ 0.91 $ 58.74 $ 8.00


2250 139.50 $ 32.63 104 69.08 $ 1.35 $ 87.32
1220 75.64 $ 17.69 83 37.45 $ 0.73 $ 47.35
1350 83.70 $ 19.58 25 41.45 $ 0.81 $ 52.39
2307.69 143.08 $ 33.46 150 70.85 $ 1.38 $ 89.56
1200 74.40 $ 17.40 99 36.84 $ 0.72 $ 46.57
1656 102.67 $ 24.01 55 50.84 $ 0.99 $ 64.27 $ 8.00
2050 127.10 $ 29.73 138 62.94 $ 1.23 $ 79.56
1008 62.50 $ 14.62 75 30.95 $ 0.60 $ 39.12
1223.08 75.83 $ 17.73 121 37.55 $ 0.73 $ 47.47
15778.37 978.26 $ 228.80 860 484.42 9.45 612.34 16.00
612.35

1,350.22 12,589.10
Amount
C
k
total .
deductio Amount
ns N
o
.
$ 270.91 1242.69
$ 433.88 1816.12
#NAME? 958.14
1127.07
1819.36
925.07
1350.22
1611.44
785.21
922.77
#NAME?
### 12,558.09
Working

1 549
61
610

Annual earning
Bonno A V
Ford C L
Russel V.A
Ryan N.A
Student
William R V
Ferguson, James C.
Mann, Dewey W
O’Neill, Joseph T
Sokowski, Thomas J

3 Ryan Sunday earning

Ryan N.A 0

$8 is deducted each
payday from the
plant workers
4 Banno & Ryan

5 Tax calculations are to be taken to three decimal places and then rounded to tw

Use tax tables for


biweekly payroll
6 period.
d then rounded to two places.
9-Oct-19
DR
Administrative Salaries 2307.69
Office Salaries 4651.08
Sales Salaries 3600
Plant Wages 4898
FICA-OASDI Payable  958.33
FICA-HI Payable  $ 224.14
FIT Payable  828
SIT Payable  474.55
SUTA Payable  9.25
CIT Payable 599.86
Group Insurance Payable 
Health Insurance Payable 
Wages Payable /cash 12315.64
Union Dues payable 16
9-Oct 23-Oct
DR CR
Payroll Taxes Expense  1381.61 1387.46
FICA-OASDI Payable  958.32 978.26
FICA-HI Payable  224.12 228.79
FUTA Payable  22.91 4.15
SUTA Payable  176.26 176.26
Wages Payable
CASH

You might also like