“You will be completing the Payroll Project Short Version on pg 7-16 on your textbook. It is also found in Appendix A of your text. In either event you are picking up a project midway through a quarter and will want to read the background for the company given at the beginning of Chapter 7. Appendix A walks you through the preceding Nov 20th payroll in Excel so you can see how the entries work. Some personal info changes at the end of November that will change wage calculations in the first December payroll (promotions, etc).
Excel Instructions
CAUTION: Read Appendix A for specific instructions relating to these templates.
1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
2. A formula begins with an equals sign (=) and can consist of any of the following elements:
Operators such as + (for addition), – (for subtraction), * (for multiplication), and / (for division).
Cell references, including cell addresses such as B52, as well as named cells and ranges
Values and text
Worksheet functions (such as SUM)
3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells.
To enter a formula manually, follow these steps:
Move the cell pointer to the cell that you want to hold the formula.
Type an equals sign (=) to signal the fact that the cell contains a formula.
Type the formula, then press Enter.
4. Rounding: These templates have not been formatted to round numbers to either the nearest whole number or the nearest cent. For example,
17.65 x 1.5=26.475. The template will display 26.48 but hold 26.475. If you want to use 26.48 you will need to use Excel’s rounding function.
In order to tell Excel to round to the nearest whole penny you must enter the formula as: =round(17.65*1.5,2). This tells Excel to multiply 17.65 x 1.5,
then round to 2 decimals. Excel will now display and hold the amount as 26.48.
5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can save your work at any time.
You can save the file to the current name, or you may want to keep multiple versions of your work by saving each successive version under a different name.
To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolbar.
It is recommended that you save the file to a new name that identifies the file as yours, such as Chapter_7_long_version_Your_Name.xlsx
To save under a different name, follow these steps:
Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx)
Select the folder in which to store the workbook.
Enter the new filename in the File name box.
Click Save.
Page 41
JOURNAL
DATE
20–
Oct.
DESCRIPTION
POST.
REF.
DEBIT
9 Payroll Cash
Cash
12
11
12,436.46
9 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Union Dues Payable
Payroll Cash
51
52
53
54
20.1
20.2
24
25
25.1
26
28
12
2,307.69
4,723.08
3,600.00
4,898.00
9 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
FUTA Taxes Payable
SUTA Taxes Payable – Employer
56
20.1
20.2
21
22
1,390.21
20 Employees SIT Payable
Cash
25
11
476.76
23 Payroll Cash
Cash
12
11
12,494.94
CREDIT
12,436.46
962.79
225.18
806.00
476.76
9.30
596.28
16.00
12,436.46
962.78
225.17
23.34
178.92
476.76
12,494.94
Page 42
JOURNAL
DATE
20–
Oct.
Nov.
DESCRIPTION
POST.
REF.
DEBIT
23 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
Payroll Cash
51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
12
2,307.69
4,723.08
3,600.00
5,219.60
23 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
FUTA Taxes Payable
SUTA Taxes Payable – Employer
56
20.1
20.2
21
22
1,395.19
4 Employees SIT Payable
Cash
25
11
486.63
6 Union Dues Payable
Cash
28
11
32.00
CREDIT
982.72
229.84
840.00
486.63
9.50
608.64
182.10
16.00
12,494.94
982.72
229.83
3.72
178.92
486.63
32.00
Page 43
JOURNAL
DATE
20–
Nov.
DESCRIPTION
POST.
REF.
DEBIT
6 Payroll Cash
Cash
12
11
12,335.83
6 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Union Dues Payable
Payroll Cash
51
52
53
54
20.1
20.2
24
25
25.1
26
28
12
2,307.69
4,677.85
3,600.00
4,898.00
6 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
SUTA Taxes Payable – Employer
56
20.1
20.2
22
1,362.30
13 Payroll Cash
Cash
12
11
1,578.92
CREDIT
12,335.83
959.99
224.53
868.00
475.37
9.27
594.55
16.00
12,335.83
959.98
224.51
177.81
1,578.92
Page 44
JOURNAL
DATE
20–
Nov.
DESCRIPTION
POST.
REF.
DEBIT
13 Office Salaries
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Payroll Cash
52
20.1
20.2
24
25
25.1
26
27
12
2,079.32
13 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
56
20.1
20.2
159.07
16 FICA Taxes Payabe-OASDI
FICA Taxes Payable-HI
Employee FIT Payable
Cash
20.1
20.2
24
11
3,891.01
910.02
1,646.00
16 Employee CIT Payable
Cash
26
11
1,204.92
18 Employees SIT Payable
Cash
25
11
539.21
20 Payroll Cash
Cash
12
11
9,538.43
20 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employees FIT Payable
Employees SIT Payable
Employees SUTA Payable
Employees CIT Payable
Group Insurance Premiums Collected
Union Dues Payable
SIMPLE Contributions Payable
Payroll Cash
51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
29
12
2,307.69
3,470.00
3,600.00
4,616.40
CREDIT
128.92
30.15
182.00
63.84
1.25
79.84
14.40
1,578.92
128.92
30.15
6,447.03
1,204.92
539.21
9,538.43
867.64
202.93
576.00
429.64
8.39
537.36
167.70
16.00
1,650.00
9,538.43
Page 45
JOURNAL
DATE
20–
Nov.
DESCRIPTION
20 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
SUTA Taxes Payable – Employer
POST.
REF.
56
20.1
20.2
22
DEBIT
CREDIT
1,139.16
867.63
202.91
68.62
Page 46
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
Page 47
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
Page 48
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
Page 49
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
Page 50
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
Total debits and credits (calculated automatically):
125,953.15 125,953.15
Your debits and credits should be equal after each journal entry is complete
Cumulative Journal Checkpoint Through Month Ending
59,572.70
125,953.15
October 31, 20-November 30, 20–
December 31, 20-January 31, 20–
GENERAL LEDGER
Checkpoints
ACCOUNT:
ACCOUNT NO. 11
CASH
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
12,436.46
476.76
12,494.94
486.63
32.00
12,335.83
1,578.92
6,447.03
1,204.92
539.21
9,538.43
199,846.33
187,409.87
186,933.11
174,438.17
173,951.54
173,919.54
161,583.71
160,004.79
153,557.76
152,352.84
151,813.63
142,275.20
20–
Oct.
Nov.
1 Balance
9
20
23
4
6
6
13
16
16
16
20
a
J41
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
CREDIT
Debit
Balance
Oct. 31, 20– 174,438.17
Nov. 30, 20– 142,275.20
Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 12
PAYROLL CASH
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
Nov.
9
9
23
23
6
6
13
13
20
20
J41
J41
J41
J42
J43
J43
J43
J44
J44
J44
Checkpoints
12,436.46
12,436.46
12,494.94
12,494.94
12,335.83
12,335.83
1,578.92
1,578.92
9,538.43
9,538.43
12,436.46
0.00
12,494.94
0.00
12,335.83
0.00
1,578.92
0.00
9,538.43
0.00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Debit
Balance
0.00
0.00
Credit
Balance
ACCOUNT:
ACCOUNT NO. 20.1
FICA TAXES PAYABLE – OASDI
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
9
23
23
6
6
13
13
16
20
20
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
Checkpoints
Debit
Balance
962.79
962.78
982.72
982.72
959.99
959.98
128.92
128.92
3,891.01
867.64
867.63
962.79
1,925.57
2,908.29
3,891.01
4,851.00
5,810.98
5,939.90
6,068.82
2,177.81
3,045.45
3,913.08
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
3,891.01
3,913.08
ACCOUNT:
ACCOUNT NO. 20.2
FICA TAXES PAYABLE – HI
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
9
23
23
6
6
13
13
16
20
20
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
Checkpoints
Debit
Balance
225.18
225.17
229.84
229.83
224.53
224.51
30.15
30.15
910.02
202.93
202.91
225.18
450.35
680.19
910.02
1,134.55
1,359.06
1,389.21
1,419.36
509.34
712.27
915.18
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
910.02
915.18
ACCOUNT:
ACCOUNT NO. 21
FUTA TAXES PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
1 Balance
9
23
a
J41
J42
Checkpoints
Debit
Balance
23.34
3.72
392.94
416.28
420.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
420.00
420.00
ACCOUNT:
ACCOUNT NO. 22
SUTA TAXES PAYABLE – EMPLOYER
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
23
6
20
J41
J42
J43
J45
Checkpoints
Debit
Balance
178.92
178.92
177.81
68.62
178.92
357.84
535.65
604.27
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
357.84
604.27
ACCOUNT:
ACCOUNT NO. 24
EMPLOYEES FIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
23
6
13
16
20
J41
J42
J43
J44
J44
J44
Checkpoints
Debit
Balance
806.00
840.00
868.00
182.00
1,646.00
576.00
806.00
1,646.00
2,514.00
2,696.00
1,050.00
1,626.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
1,646.00
1,626.00
ACCOUNT:
ACCOUNT NO. 25
EMPLOYEES SIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
20
23
4
6
13
18
20
J41
J41
J42
J42
J43
J44
J44
J44
Checkpoints
Debit
Balance
476.76
476.76
486.63
486.63
475.37
63.84
539.21
429.64
476.76
0.00
486.63
0.00
475.37
539.21
0.00
429.64
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
486.63
429.64
ACCOUNT:
ACCOUNT NO. 25.1
EMPLOYEES SUTA PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
23
6
13
20
J41
J42
J43
J44
J44
Checkpoints
Debit
Balance
9.30
9.50
9.27
1.25
8.39
9.30
18.80
28.07
29.32
37.71
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
18.80
37.71
ACCOUNT:
ACCOUNT NO. 26
EMPLOYEES CIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
23
6
13
16
20
J41
J42
J43
J44
J44
J44
Checkpoints
Debit
Balance
596.28
608.64
594.55
79.84
1,204.92
537.36
596.28
1,204.92
1,799.47
1,879.31
674.39
1,211.75
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
1,204.92
1,211.75
ACCOUNT:
ACCOUNT NO. 27
GROUP INSURANCE PREMIUMS COLLECTED
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
23
13
20
J42
J44
J44
Checkpoints
Debit
Balance
182.10
14.40
167.70
182.10
196.50
364.20
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
182.10
364.20
ACCOUNT:
ACCOUNT NO. 28
UNION DUES PAYABLE
DATE
ITEM
POST.
REF.
Checkpoints
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Oct.
Nov.
9
23
6
6
20
J41
J42
J42
J43
J44
16.00
16.00
32.00
16.00
16.00
16.00
32.00
0.00
16.00
32.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
32.00
32.00
ACCOUNT:
ACCOUNT NO. 29
SIMPLE CONTRIBUTIONS PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20–
Nov.
20
J44
Checkpoints
Debit
Balance
1,650.00
1,650.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
0.00
1,650.00
ACCOUNT:
ACCOUNT NO. 51
ADMINISTRATIVE SALARIES
DATE
ITEM
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
2,307.69
2,307.69
2,307.69
2,307.69
CREDIT
DEBIT
20–
Oct.
Nov.
1 Balance
9
23
6
20
Checkpoints
42,692.27
44,999.96
47,307.65
49,615.34
51,923.03
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Debit
Balance
47,307.65
51,923.03
Credit
Balance
ACCOUNT:
ACCOUNT NO. 52
OFFICE SALARIES
DATE
ITEM
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
J44
4,723.08
4,723.08
4,677.85
2,079.32
3,470.00
CREDIT
DEBIT
20–
Oct.
Nov.
1 Balance
9
23
6
13
20
Checkpoints
28,350.00
33,073.08
37,796.16
42,474.01
44,553.33
48,023.33
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Debit
Balance
37,796.16
48,023.33
Credit
Balance
ACCOUNT:
ACCOUNT NO. 53
SALES SALARIES
DATE
ITEM
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
3,600.00
3,600.00
3,600.00
3,600.00
CREDIT
DEBIT
20–
Oct.
Nov.
1 Balance
9
23
6
20
Checkpoints
28,525.00
32,125.00
35,725.00
39,325.00
42,925.00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Debit
Balance
35,725.00
42,925.00
Credit
Balance
ACCOUNT:
ACCOUNT NO. 54
PLANT WAGES
DATE
ITEM
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
4,898.00
5,219.60
4,898.00
4,616.40
CREDIT
DEBIT
20–
Oct.
Nov.
1 Balance
9
23
6
20
Checkpoints
42,657.30
47,555.30
52,774.90
57,672.90
62,289.30
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Debit
Balance
52,774.90
62,289.30
Credit
Balance
ACCOUNT:
ACCOUNT NO. 56
PAYROLL TAXES
DATE
ITEM
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
J45
1,390.21
1,395.19
1,362.30
159.07
1,139.16
CREDIT
DEBIT
20–
Oct.
Nov.
1 Balance
9
23
6
13
20
Checkpoints
14,353.07
15,743.28
17,138.47
18,500.77
18,659.84
19,799.00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Debit
Balance
17,138.47
19,799.00
Credit
Balance
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, K.
O’Neill, J.
Russell, S.
Ryan, J.
Sokowski, T.
(Student)
Williams, R.
No. W/H Allow.
N/AME
Filing Status
PAYROLL REGISTER
Time Record
S M T W T
Regular Earnings
Rate
Per
F S S M T W T F S Hrs. Hour
For Period Ending October 3, 20-MFJ N/A
8 8 8 8 8
MFJ N/A
8 8 8 8 8
S
N/A
8 8 8 8 8
MFJ N/A
8 8 8 8 8
MFJ N/A
8 8 8 8 8
S
N/A
8 8 8 8 8
MFJ N/A
8 8 8 8 8
MFJ N/A
8 8 8 8 8
S
N/A
8 8 8 8 4
S
N/A
8 8 D 8 8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4
8
80 17.60
80
80
80
80
80
80 18.00
80
72 15.00
80
TOTALS
Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A.
MFJ N/A
8 8 8 8 8 4
Ferguson, J.
MFJ N/A
8 8 8 8 8
Ford, C.
S
N/A
8 8 8 8 8
Mann, K
MFJ N/A
8 8 8 8 8
O’Neill, J.
MFJ N/A
8 8 8 8 8
Russell, S.
S
N/A
8 8 8 8 8
Ryan, J.
MFJ N/A
8 8 8 8 8
Sokowski, T.
MFJ N/A
8 8 8 8 8
(Student)
S
N/A
8 8 8 8 4
Williams, R.
S
N/A
8 8 8 8 8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8 8
8
4
8
80 17.60
80
80
80
80
80
80 18.00
80
72 15.00
80
TOTALS
Payday, November 6, 20– For Period Ending October 31, 20-Bonno, A.
MFJ N/A
8 8 8 8 8
Ferguson, J.
MFJ N/A
8 8 8 8 8
Ford, C.
S
N/A
8 8 8 8 8
Mann, K
MFJ N/A
8 8 8 8 8
O’Neill, J.
MFJ N/A
8 8 8 8 8
Russell, S.
S
N/A
8 8 8 8 6
Ryan, J.
MFJ N/A
8 8 8 8 8
Sokowski, T.
S
N/A
8 8 8 8 8
(Student)
S
N/A
8 8 8 8 4
Williams, R.
S
N/A
8 8 8 7 8
Amount
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4
8
80 17.60
80
80
80
80
78
80 18.00
80
72 15.00
79
TOTALS
6
8
136
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Deductions
Total
Earnings
OASDI
HI
FIT
SIT
SUTA
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,440.00
2,050.00
1,080.00
1,223.08
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,440.00
2,050.00
1,080.00
1,223.08
87.30
139.50
75.64
83.70
143.08
74.40
89.28
127.10
66.96
75.83
20.42
32.63
17.69
19.58
33.46
17.40
20.88
29.73
15.66
17.73
40.00
136.00
79.00
36.00
142.00
76.00
44.00
112.00
62.00
79.00
43.23
69.08
37.45
41.45
70.85
36.84
44.21
62.94
33.16
37.55
0.84
1.35
0.73
0.81
1.38
0.72
0.86
1.23
0.65
0.73
15,528.77
15,528.77
962.79
225.18
806.00
476.76
9.30
1,513.60
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,656.00
2,050.00
1,080.00
1,223.08
93.84
139.50
75.64
83.70
143.08
74.40
102.67
127.10
66.96
75.83
21.95
32.63
17.69
19.58
33.46
17.40
24.01
29.73
15.66
17.73
52.00
136.00
79.00
36.00
142.00
76.00
66.00
112.00
62.00
79.00
46.47
69.08
37.45
41.45
70.85
36.84
50.84
62.94
33.16
37.55
0.91
1.35
0.73
0.81
1.38
0.72
0.99
1.23
0.65
0.73
15,850.37
982.72
229.84
840.00
486.63
9.50
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
1,207.85
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
1,207.85
87.30
139.50
75.64
83.70
143.08
72.54
89.28
127.10
66.96
74.89
20.42
32.63
17.69
19.58
33.46
16.97
20.88
29.73
15.66
17.51
40.00
136.00
79.00
36.00
142.00
74.00
44.00
179.00
62.00
76.00
43.23
69.08
37.45
41.45
70.85
35.92
44.21
62.94
33.16
37.08
0.84
1.35
0.73
0.81
1.38
0.70
0.86
1.23
0.65
0.72
15,483.54
15,483.54
959.99
224.53
868.00
475.37
9.27
2,079.32
2,079.32
128.92
30.15
182.00
63.84
1.25
2,079.32
2,079.32
128.92
30.15
182.00
63.84
1.25
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,440.00
2,050.00
1,080.00
1,223.08
15,528.77
Payday, November 13, 20– For Period Ending November 14, 20-Williams, R.
S
N/A
6 8 7 7 6
D D 8
TOTALS
GLO-BRITE PAINT COMPANY
4 26.40
105.60
8 27.00
216.00
321.60
No. W/H Allow.
N/AME
Filing Status
PAYROLL REGISTER
Time Record
S M T W T
Regular Earnings
Rate
Per
F S S M T W T F S Hrs. Hour
Payday, November 20, 20– For Period Ending November 14, 20-Bonno, A.
MFJ N/A
8 8 8 8 8
Ferguson, J.
MFJ N/A
8 8 8 8 8
8
Ford, C.
S
N/A
8 8 8 8 8
8
Mann, K
MFJ N/A
8 8 8 8 8
8
O’Neill, J.
MFJ N/A
8 8 8 8 8
8
Russell, S.
S
N/A
6 8 8 8 8
8
Ryan, J.
MFJ N/A
8 8 8 8 8
8
Sokowski, T.
S
N/A
8 8 8 8 8
8
(Student)
S
N/A
8 8 8 8 4
8
TOTALS
GLO-BRITE PAINT COMPANY
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4
64 17.60
80
80
80
80
78
80 18.00
80
72 15.00
Amount
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Deductions
Total
Earnings
OASDI
HI
FIT
SIT
SUTA
1,126.40
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
1,126.40
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
69.84
139.50
75.64
83.70
143.08
72.54
89.28
127.10
66.96
16.33
32.63
17.69
19.58
33.46
16.97
20.88
29.73
15.66
12.00
76.00
79.00
10.00
60.00
74.00
24.00
179.00
62.00
34.58
69.08
37.45
41.45
70.85
35.92
44.21
62.94
33.16
0.68
1.35
0.73
0.81
1.38
0.70
0.86
1.23
0.65
13,994.09
13,994.09
867.64
202.93
576.00
429.64
8.39
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
62,936.09 3,902.06
912.63
205,160.66 12,719.98 2,974.90
3,272.00
19,189.00
1,932.24
6,298.53
37.71
123.05
Payday, December 4, 20– For Period Ending November 28, 20-Bonno, A.
MFJ N/A
Ferguson, J.
MFJ N/A
Ford, C.
S
N/A
Mann, K
MFJ N/A
O’Neill, J.
MFJ N/A
Russell, S.
S
N/A
Ryan, J.
MFJ N/A
Sokowski, T.
S
N/A
(Student)
S
N/A
Woods, B.
S
N/A
TOTALS
Payday, December 14, 20– For Period Ending December 12, 20-Russell, S.
S
N/A
TOTALS
Payday, December 18, 20– For Period Ending December 12, 20-Bonno, A.
MFJ N/A
Ferguson, J.
MFJ N/A
Ford, C.
S
N/A
Mann, K
MFJ N/A
O’Neill, J.
MFJ N/A
Ryan, J.
MFJ N/A
Sokowski, T.
S
N/A
(Student)
S
N/A
Woods, B.
S
N/A
Young, P.
S
N/A
TOTALS
QTR
YEAR
Deductions
N/AME
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, K.
O’Neill, J.
Russell, S.
Ryan, J.
Sokowski, T.
(Student)
Williams, R.
TOTALS
Net Paid
CIT
Group
Ins.
Union
Dues
Ck.
SIMPLE No.
0.00
16.00
672
673
674
675
676
677
678
679
680
681
0.00
608.64
182.10
16.00
682
683
684
685
686
687
688
689
690
691
0.00
594.55
0.00
16.00
692
693
694
695
696
697
698
699
700
701
0.00
Payday, November 13, 20– For Period Ending November 14, 20-Williams, R.
79.84
14.40
TOTALS
79.84
14.40
0.00
HI
1,154.15
1,785.04
962.64
1,116.62
1,828.31
948.56
1,177.48
1,638.28
860.10
965.28
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,440.00
2,050.00
1,080.00
1,223.08
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,440.00
2,050.00
1,080.00
1,223.08
12,436.46
15,528.77
15,528.77
1,215.81
1,758.64
948.24
1,100.72
1,801.31
934.46
1,323.10
1,614.28
847.50
950.88
1,513.60
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,656.00
2,050.00
1,080.00
1,223.08
1,513.60
2,250.00
1,220.00
1,350.00
2,307.69
1,200.00
1,656.00
2,050.00
1,080.00
1,223.08
12,494.94
15,850.37
15,850.37
1,154.15
1,785.04
962.64
1,116.62
1,828.31
924.94
1,177.48
1,571.28
860.10
955.27
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
1,207.85
1,408.00
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
1,207.85
12,335.83
15,483.54
15,483.54
1,578.92
2,079.32
2,079.32
1,578.92
2,079.32
2,079.32
FUTA
SUTA
Admin.
Office
Sales
Plant
1,408.00
2,250.00
700.00
1,350.00
1,220.00
1,350.00
Total earnings
Net paid
15,528.77
12,436.46
1,220.00
1,350.00
2,307.69
760.00
1,200.00
1,200.00
1,440.00
2,050.00
1,080.00
1,080.00
3,890.00
4,850.00
1,080.00
1,223.08
2,307.69
4,723.08
3,600.00
4,898.00
1,513.60
2,250.00
250.00
1,220.00
1,350.00
Total earnings
Net paid
15,850.37
12,494.94
1,220.00
1,350.00
2,307.69
1,200.00
1,200.00
1,656.00
2,050.00
370.00
1,080.00
620.00
4,850.00
1,080.00
1,223.08
2,307.69
4,723.08
3,600.00
5,219.60
Checkpoints
Payday, November 6, 20– For Period Ending October 31, 20-Bonno, A.
54.06
8.00
Ferguson, J.
86.40
Ford, C.
46.85
Mann, K
51.84
O’Neill, J.
88.61
Russell, S.
44.93
Ryan, J.
55.29
8.00
Sokowski, T.
78.72
(Student)
41.47
Williams, R.
46.38
TOTALS
OASDI
Checkpoints
Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A.
58.12
16.50
8.00
Ferguson, J.
86.40
26.40
Ford, C.
46.85
14.40
Mann, K
51.84
15.90
O’Neill, J.
88.61
27.00
Russell, S.
46.08
14.10
Ryan, J.
63.59
16.80
8.00
Sokowski, T.
78.72
24.00
(Student)
41.47
12.60
Williams, R.
46.96
14.40
TOTALS
Amount
Labor Cost Distribution
Checkpoints
For Period Ending October 3, 20-54.06
8.00
86.40
46.85
51.84
88.61
46.08
55.29
8.00
78.72
41.47
46.96
596.28
Taxable Earnings
0.00
1,408.00
2,250.00
1,220.00
1,350.00
Total earnings
Net paid
15,483.54
12,335.83
1,220.00
1,350.00
2,307.69
1,170.00
1,170.00
1,440.00
2,050.00
1,080.00
0.00
4,820.00
1,080.00
1,207.85
2,307.69
4,677.85
3,600.00
4,898.00
Checkpoints
702
2,079.32
0.00
0.00
0.00
2,079.32
Total earnings
Net paid
0.00
0.00
2,079.32
1,578.92
Deductions
N/AME
Net Paid
CIT
Group
Ins.
Union
Dues
Ck.
SIMPLE No.
Payday, October
9, 20,
20–20–For
3, 20-November
ForPeriod
PeriodEnding
EndingOctober
November
14, 20-Bonno, A.
43.25
16.50
8.00
Ferguson, J.
86.40
26.40
500.00
Ford, C.
46.85
14.40
Mann, K
51.84
15.90
250.00
O’Neill, J.
88.61
27.00
700.00
Russell, S.
44.93
14.10
Ryan, J.
55.29
16.80
8.00
200.00
Sokowski, T.
78.72
24.00
(Student)
41.47
12.60
TOTALS
537.36
167.70
16.00 1,650.00
Taxable Earnings
Amount
OASDI
HI
FUTA
925.22
1,318.64
948.24
876.72
1,183.31
910.84
980.68
1,547.28
847.50
1,126.40
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
1,126.40
2,250.00
1,220.00
1,350.00
2,307.69
1,170.00
1,440.00
2,050.00
1,080.00
9,538.43
13,994.09
13,994.09
Labor Cost Distribution
SUTA
Admin.
Office
Sales
Plant
Checkpoints
703
704
705
706
707
708
709
710
711
1,126.40
2,250.00
40.00
550.00
1,220.00
1,350.00
2,307.69
190.00
1,170.00
1,440.00
2,050.00
1,080.00
0.00
1,860.00
1,080.00
2,307.69
3,470.00
3,600.00
4,616.40
Checkpoints
Payday, December 4, 20– For Period Ending November 28, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, K
O’Neill, J.
Russell, S.
Ryan, J.
Sokowski, T.
(Student)
Woods, B.
TOTALS
0.00
0.00
0.00
0.00
Total earnings
Net paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Checkpoints
Payday, December 14, 20– For Period Ending December 12, 20-Russell, S.
TOTALS
0.00
0.00
0.00
0.00
Total earnings
Net paid
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Checkpoints
Payday, December 18, 20– For Period Ending December 12, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, K
O’Neill, J.
Ryan, J.
Sokowski, T.
(Student)
Woods, B.
Young, P.
TOTALS
QTR
YEAR
0.00
0.00
2,416.67 364.20
7,877.81 1,294.60
0.00
0.00
64.00 1,650.00
208.00 1,650.00
Total earnings
Net paid
Total earnings
Net paid
Checkpoints-Annual
Total earnings
Qtr’s taxable OASDI earnings
Total earnings for FIT
Total earnings for SIT/CIT
Total earnings for FUTA
0.00
0.00
0.00
0.00
0.00
48,384.58 62,936.09 62,936.09
4,510.00
152,824.79 205,160.66 205,160.66 70,000.00
16,380.00
99,870.00
0.00
0.00
0.00
0.00
9,230.76 19,673.33 14,400.00 19,632.00
13,994.09
9,538.43
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Plant
Mixer Operator
PA
000-00-3481
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
$55,000 –$.30/M
$9 each pay
N/AME – LAST
FIRST
BONNO
Anthony
$
$
$
$
SALARY
OTHER
WEEKLY RATE
HOURLY RATE
20___
PAYDAY
REGULAR EARNINGS
HRS.
RATE
AMOUNT
17.60
17.60
17.60
17.60
10,293.40
1,408.00
1,408.00
1,408.00
1,126.40
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
6
12/4
12/18
80
80
80
64
OVERTIME EARNINGS
HRS. RATE
4
26.40
OVERTIME RATE
CUMULATIVE
EARNINGS
1,028.60
0.00
105.60
0.00
0.00
0.00
0.00
11,322.00
12,730.00
14,243.60
15,651.60
16,778.00
Victor
17.60
26.40
W/H
FILING
ALLOW.
STATUS
N/A
MFJ
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
MIDDLE
701.96
87.30
93.84
87.30
69.84
HI
FIT
SIT
164.17
20.42
21.95
20.42
16.33
810.00
40.00
52.00
40.00
12.00
347.59
43.23
46.47
43.23
34.58
SUTA
CIT
6.79
0.84
0.91
0.84
0.68
SIMPLE
434.74
54.06
58.12
54.06
43.25
OTHER
CK.
DEDUCTIONS NO.
216.80
8.00
24.50
8.00
24.50
AMOUNT
672
682
692
703
8,639.95
1,154.15
1,215.81
1,154.15
925.22
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Sales
Sales Manager
PA
000-00-8645
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
FERGUSON
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$88,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
YEAR-TO-DATE
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
80
80
80
80
RATE
AMOUNT
HRS. RATE
23,125.00
2,250.00
2,250.00
2,250.00
2,250.00
AMOUNT
23,125.00
25,375.00
27,625.00
29,875.00
32,125.00
Jamie
58,500 /yr.
1,125.00
28.13
FILING
ALLOW.
STATUS
N/A
MFJ
NET PAID
FICA
OTHER
OASDI
HI
FIT
SIT
1,433.75
139.50
139.50
139.50
139.50
335.31
32.63
32.63
32.63
32.63
2,291.00
136.00
136.00
136.00
76.00
709.94
69.08
69.08
69.08
69.08
SUTA
QTR. TOT.
YR. TOT.
Checkpoint
Hadi
W/H
DEDUCTIONS
EARNINGS
HRS.
1
CUMULATIVE
MIDDLE
Checkpoint
13.88
1.35
1.35
1.35
1.35
CIT
887.95
86.40
86.40
86.40
86.40
SIMPLE
CK.
DEDUCTIONS NO.
132.30
26.40
500.00
26.40
673
683
693
704
AMOUNT
17,320.87
1,785.04
1,758.64
1,785.04
1,318.64
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Office
Administrative Assistant
PA
000-00-4567
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
FORD
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$50,000–$.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
RATE
AMOUNT
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
80
80
80
80
6,300.00
7,520.00
8,740.00
9,960.00
11,180.00
Louise
W/H
FILING
ALLOW.
STATUS
N/A
S
NET PAID
FICA
OASDI
AMOUNT
6,300.00
1,220.00
1,220.00
1,220.00
1,220.00
YEAR-TO-DATE
10/9
HRS. RATE
Catherine
2,733.33 /mo.
640.00
16.00
24.00
DEDUCTIONS
EARNINGS
HRS.
1
CUMULATIVE
MIDDLE
390.60
75.64
75.64
75.64
75.64
OTHER
HI
FIT
SIT
91.35
17.69
17.69
17.69
17.69
639.00
79.00
79.00
79.00
79.00
193.41
37.45
37.45
37.45
37.45
SUTA
3.78
0.73
0.73
0.73
0.73
CIT
SIMPLE
241.91
46.85
46.85
46.85
46.85
CK.
DEDUCTIONS NO.
AMOUNT
37.80
14.40
14.40
674
684
694
705
4,702.15
962.64
948.24
962.64
948.24
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Sales
Sales Representative
PA
000-00-9352
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
MANN
Kari
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$53,000 — $.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
YEAR-TO-DATE
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
80
80
80
80
RATE
AMOUNT
HRS. RATE
5,400.00
1,350.00
1,350.00
1,350.00
1,350.00
5,400.00
6,750.00
8,100.00
9,450.00
10,800.00
FILING
ALLOW.
STATUS
MFJ
NET PAID
334.80
83.70
83.70
83.70
83.70
OTHER
HI
FIT
SIT
78.30
19.58
19.58
19.58
19.58
332.00
36.00
36.00
36.00
10.00
165.78
41.45
41.45
41.45
41.45
SUTA
3.24
0.81
0.81
0.81
0.81
CIT
207.35
51.84
51.84
51.84
51.84
SIMPLE
CK.
DEDUCTIONS NO.
31.50
15.90
250.00
QTR. TOT.
YR. TOT.
Checkpoint
W/H
N/A
FICA
OASDI
AMOUNT
Casey
2,925 /mo.
675.00
16.88
DEDUCTIONS
EARNINGS
HRS.
1
CUMULATIVE
MIDDLE
Checkpoint
15.90
675
685
695
706
AMOUNT
4,247.03
1,116.62
1,100.72
1,116.62
876.72
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Administrative
President
PA
000-00-1534
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
O’NEILL
$
$
$
$
SALARY
UNION DUES
OTHER
BI-WEEKLY RATE
HOURLY RATE
$90,000 — $.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
RATE
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
HRS. RATE
AMOUNT
42,692.27
2,307.69
2,307.69
2,307.69
2,307.69
YEAR-TO-DATE
10/9
AMOUNT
80
80
80
80
42,692.27
44,999.96
47,307.65
49,615.34
51,923.03
Joseph
60,000 /yr.
2,307.69
Tyler
W/H
FILING
ALLOW.
STATUS
N/A
MFJ
DEDUCTIONS
EARNINGS
HRS.
1
CUMULATIVE
MIDDLE
NET PAID
FICA
OTHER
OASDI
HI
FIT
2,646.92
143.08
143.08
143.08
143.08
619.04
33.46
33.46
33.46
33.46
6,116.00
142.00
142.00
142.00
60.00
SIT
SUTA
1,310.65
70.85
70.85
70.85
70.85
25.62
1.38
1.38
1.38
1.38
CIT
1,639.30
88.61
88.61
88.61
88.61
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
202.50
27.00
700.00
27.00
30,132.24
1,828.31
1,801.31
1,828.31
1,183.31
676
686
696
707
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Office
Time Clerk
PA
000-00-6337
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
RUSSELL
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$49,000 — $.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
YEAR-TO-DATE
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/14
80
80
78
78
RATE
AMOUNT
HRS. RATE
6,240.00
1,200.00
1,200.00
1,170.00
1,170.00
6,240.00
7,440.00
8,640.00
9,810.00
10,980.00
Parker
FILING
ALLOW.
STATUS
S
NET PAID
386.88
74.40
74.40
72.54
72.54
OTHER
HI
FIT
SIT
90.48
17.40
17.40
16.97
16.97
642.00
76.00
76.00
74.00
74.00
191.56
36.84
36.84
35.92
35.92
SUTA
3.74
0.72
0.72
0.70
0.70
CIT
SIMPLE
239.60
46.08
46.08
44.93
44.93
QTR. TOT.
YR. TOT.
Checkpoint
W/H
N/A
FICA
OASDI
AMOUNT
Serdar
2,730 /mo.
630.00
15.75
23.63
DEDUCTIONS
EARNINGS
HRS.
1
CUMULATIVE
MIDDLE
Checkpoint
CK.
DEDUCTIONS NO.
31.50
14.10
14.10
677
687
697
708
AMOUNT
4,654.24
948.56
934.46
924.94
910.84
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Plant
Electrician
PA
000-00-1223
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
$56,000 — $.30/M
$9 each pay
N/AME – LAST
FIRST
RYAN
Jeri
$
$
$
$
SALARY
OTHER
WEEKLY RATE
HOURLY RATE
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
RATE
AMOUNT
10/9
80
80
80
80
18.00
18.00
18.00
18.00
13,287.50
1,440.00
1,440.00
1,440.00
1,440.00
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
HRS. RATE
8
27.00
1,397.80
0.00
216.00
0.00
0.00
0.00
0.00
14,685.30
16,125.30
17,781.30
19,221.30
20,661.30
18.00
27.00
FILING
ALLOW.
STATUS
N/A
MFJ
NET PAID
FICA
OASDI
AMOUNT
Mischa
W/H
DEDUCTIONS
EARNINGS
HRS.
YEAR-TO-DATE
1
OVERTIME RATE
CUMULATIVE
MIDDLE
910.49
89.28
102.67
89.28
89.28
OTHER
HI
FIT
SIT
212.94
20.88
24.01
20.88
20.88
1,070.00
44.00
66.00
44.00
24.00
450.84
44.21
50.84
44.21
44.21
SUTA
8.81
0.86
0.99
0.86
0.86
CIT
563.89
55.29
63.59
55.29
55.29
SIMPLE
200.00
CK.
DEDUCTIONS NO.
235.70
8.00
24.80
8.00
24.80
AMOUNT
11,232.63
1,177.48
1,323.10
1,177.48
980.68
678
688
698
709
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Plant
Supervisor
PA
000-00-8832
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
SOKOWSKI
Thomas
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$80,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
YEAR-TO-DATE
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
80
80
80
80
RATE
AMOUNT
HRS. RATE
16,650.00
2,050.00
2,050.00
2,050.00
2,050.00
AMOUNT
16,650.00
18,700.00
20,750.00
22,800.00
24,850.00
James
1,025.00
25.63
FILING
ALLOW.
STATUS
N/A
S
NET PAID
FICA
OTHER
OASDI
HI
FIT
SIT
1,032.30
127.10
127.10
127.10
127.10
241.43
29.73
29.73
29.73
29.73
2,002.00
112.00
112.00
179.00
179.00
511.16
62.94
62.94
62.94
62.94
SUTA
9.99
1.23
1.23
1.23
1.23
CIT
SIMPLE
639.33
78.72
78.72
78.72
78.72
QTR. TOT.
YR. TOT.
Checkpoint
W/H
DEDUCTIONS
EARNINGS
HRS.
1
CUMULATIVE
MIDDLE
Checkpoint
CK.
DEDUCTIONS NO.
94.50
24.00
24.00
679
689
699
710
AMOUNT
12,119.29
1,638.28
1,614.28
1,571.28
1,547.28
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
Office
Accounting Trainee
PA
S.S. ACCOUNT NO.
FIRST
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$42,000 — $.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
RATE
72
72
72
72
15.00
15.00
15.00
15.00
AMOUNT
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
HRS. RATE
5,550.00
6,630.00
7,710.00
8,790.00
9,870.00
15.00
22.50
W/H
FILING
ALLOW.
STATUS
N/A
S
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
5,550.00
1,080.00
1,080.00
1,080.00
1,080.00
YEAR-TO-DATE
1
CUMULATIVE
EARNINGS
HRS.
MIDDLE
Student
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
344.10
66.96
66.96
66.96
66.96
OTHER
HI
FIT
SIT
80.48
15.66
15.66
15.66
15.66
409.00
62.00
62.00
62.00
62.00
170.38
33.16
33.16
33.16
33.16
SUTA
3.33
0.65
0.65
0.65
0.65
CIT
SIMPLE
213.11
41.47
41.47
41.47
41.47
CK.
DEDUCTIONS NO.
AMOUNT
32.40
12.60
12.60
4,297.20
860.10
847.50
860.10
847.50
680
690
700
711
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Office
Programmer
PA
000-00-6741
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
N/AME – LAST
FIRST
WILLIAMS
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$48,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/13
80
80
79
136
QTR. TOT.
375
RATE
AMOUNT
HRS. RATE
Virginia
W/H
FILING
ALLOW.
STATUS
N/A
S
NET PAID
FICA
OASDI
AMOUNT
Ruth
2,650 /mo.
611.54
15.29
22.94
DEDUCTIONS
EARNINGS
HRS.
MIDDLE
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
10,260.00
1,223.08
1,223.08
1,207.85
2,079.32
10,260.00
11,483.08
12,706.16
13,914.01
15,993.33
636.12
75.83
75.83
74.89
128.92
148.77
17.73
17.73
17.51
30.15
1,606.00
79.00
79.00
76.00
182.00
314.98
37.55
37.55
37.08
63.84
6.16
0.73
0.73
0.72
1.25
393.96
46.96
46.96
46.38
79.84
59.40
5,733.33
15,993.33
5,733.33
15,993.33
355.47
991.59
83.12
231.89
416.00
2,022.00
176.02
491.00
3.43
9.59
220.14
614.10
28.80
88.20
4,450.35
11,544.96
4,450.35
11,544.96
14.40
14.40
681
691
701
702
7,094.61
965.28
950.88
955.27
1,578.92
5
6
YR. TOT.
Checkpoint
5,733.33
15,993.33
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Office
Programmer
PA
000-00-1587
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
N/AME – LAST
FIRST
Woods
$
$
$
$
SALARY
OTHER
WEEKLY RATE
HOURLY RATE
$47,000 — $.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
RATE
AMOUNT
HRS. RATE
Anne
W/H
FILING
ALLOW.
STATUS
N/A
S
NET PAID
FICA
OASDI
AMOUNT
Beth
2,600 /mo.
600.00
15.00
DEDUCTIONS
EARNINGS
HRS.
MIDDLE
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
YEAR-TO-DATE
1
2
3
4
5
12/4
6
12/18
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
S.S. ACCOUNT NO.
Sales
Field Sales Representative
PA
000-00-6057
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
N/AME – LAST
FIRST
Young
Paul
$
$
$
$
SALARY
OTHER
WEEKLY RATE
HOURLY RATE
$49,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
RATE
AMOUNT
HRS. RATE
AMOUNT
Winston
2,730 /mo.
630.00
15.75
STATUS
S
NET PAID
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
1
2
3
4
5
12/18
QTR. TOT.
YR. TOT.
Checkpoint
FILING
ALLOW.
N/A
YEAR-TO-DATE
6
W/H
DEDUCTIONS
EARNINGS
HRS.
MIDDLE
Checkpoint
CK.
DEDUCTIONS NO.
AMOUNT
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
S.S. ACCOUNT NO.
N/AME – LAST
OTHER
WEEKLY RATE
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
FIRST
$
$
$
$
SALARY
HOURLY RATE
OVERTIME RATE
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
RATE
AMOUNT
HRS. RATE
FILING
STATUS
NET PAID
FICA
OASDI
AMOUNT
W/H
ALLOW.
DEDUCTIONS
EARNINGS
HRS.
MIDDLE
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
YEAR-TO-DATE
1
2
3
4
5
6
QTR. TOT.
YR. TOT.
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
S.S. ACCOUNT NO.
N/AME – LAST
OTHER
WEEKLY RATE
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
FIRST
$
$
$
$
SALARY
HOURLY RATE
OVERTIME RATE
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
1
2
3
4
5
6
QTR. TOT.
YR. TOT.
RATE
AMOUNT
HRS. RATE
AMOUNT
W/H
FILING
ALLOW.
STATUS
DEDUCTIONS
EARNINGS
HRS.
YEAR-TO-DATE
CUMULATIVE
MIDDLE
NET PAID
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT