Excel Instructions using Excel 2010:
CAUTION: Read Appendix B 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 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 and hold 26.48, not 26.475. There is no need to use Excel's rounding function.
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_short_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
9 Payroll Cash
Cash
POST.
REF.
DEBIT
12
11
11,097.25
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
3,353.08
3,600.00
4,902.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,231.14
CREDIT
11,097.25
878.09
205.37
965.00
434.82
9.94
556.30
16.00
11,097.25
878.09
205.36
19.68
128.01
20 Employees SIT Payable
Cash
25
11
434.82
23 Payroll Cash
Cash
12
11
11,173.89
434.82
11,173.89
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
3,353.08
3,600.00
5,223.92
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,241.25
CREDIT
898.05
210.04
997.00
444.70
10.16
568.95
165.90
16.00
11,173.89
898.05
210.03
5.16
128.01
4 Employees SIT Payable
Cash
25
11
444.70
6 Union Dues Payable
Cash
28
11
32.00
444.70
32.00
Page 43
JOURNAL
DATE
20--
Nov.
DESCRIPTION
6 Payroll Cash
Cash
POST.
REF.
DEBIT
12
11
10,937.71
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
3,320.79
3,600.00
4,902.00
6 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,157.25
12
11
1,418.87
13 Payroll Cash
Cash
CREDIT
10,937.71
876.09
204.90
1,097.00
433.83
9.92
555.03
16.00
10,937.71
876.09
204.89
2.22
74.05
1,418.87
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,552.28
830.80
1,962.00
16 Employee CIT Payable
Cash
26
11
1,125.25
18 Employees SIT Payable
Cash
25
11
497.67
20 Payroll Cash
Cash
12
11
8,281.28
51
52
53
54
20.1
20.2
24
25
25.1
26
27
28
29
12
2,307.69
2,112.94
3,600.00
4,619.60
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
CREDIT
128.92
30.15
340.00
63.84
1.46
81.68
14.40
1,418.87
128.92
30.15
6,345.08
1,125.25
497.67
8,281.28
783.70
183.30
681.00
388.08
8.87
496.50
151.50
16.00
1,650.00
8,281.28
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
994.45
783.69
183.28
27.48
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
GENERAL LEDGER
ACCOUNT:
Checkpoints
CASH
DATE
ACCOUNT NO. 11
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
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
11,097.25
434.82
11,173.89
444.70
32.00
10,937.71
1,418.87
6,345.08
1,125.25
497.67
8,281.28
199,846.33
188,749.08
188,314.26
177,140.37
176,695.67
176,663.67
165,725.96
164,307.09
157,962.01
156,836.76
156,339.09
148,057.81
CREDIT
Debit
Credit
Balance
Balance
Oct. 31, 20-- 177,140.37
Nov. 30, 20-- 148,057.81
Dec. 31, 20--
ACCOUNT:
PAYROLL CASH
DATE
ITEM
ACCOUNT NO. 12
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
11,097.25
11,097.25
11,173.89
11,173.89
10,937.71
10,937.71
1,418.87
1,418.87
8,281.28
8,281.28
11,097.25
0.00
11,173.89
0.00
10,937.71
0.00
1,418.87
0.00
8,281.28
0.00
CREDIT
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-0.00
Nov. 30, 20-0.00
Dec. 31, 20--
ACCOUNT:
FICA TAXES PAYABLE - OASDI
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
9
23
23
6
6
13
13
16
20
20
Checkpoints
ACCOUNT NO. 20.1
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
878.09
878.09
898.05
898.05
876.09
876.09
128.92
128.92
3,552.28
783.70
783.69
878.09
1,756.18
2,654.23
3,552.28
4,428.37
5,304.46
5,433.38
5,562.30
2,010.02
2,793.72
3,577.41
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
3,552.28
3,577.41
ACCOUNT:
FICA TAXES PAYABLE - HI
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
9
23
23
6
6
13
13
16
20
20
Checkpoints
ACCOUNT NO. 20.2
J41
J41
J42
J42
J43
J43
J44
J44
J44
J44
J45
205.37
205.36
210.04
210.03
204.90
204.89
30.15
30.15
830.80
183.30
183.28
205.37
410.73
620.77
830.80
1,035.70
1,240.59
1,270.74
1,300.89
470.09
653.39
836.67
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
830.80
836.67
ACCOUNT:
FUTA TAXES PAYABLE
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
1 Balance
9
23
6
Checkpoints
ACCOUNT NO. 21
a
J41
J42
J43
19.68
5.16
2.22
392.94
412.62
417.78
420.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
417.78
420.00
ACCOUNT:
SUTA TAXES PAYABLE - EMPLOYER
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
23
6
20
Checkpoints
ACCOUNT NO. 22
J41
J42
J43
J45
128.01
128.01
74.05
27.48
128.01
256.02
330.07
357.55
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
256.02
357.55
ACCOUNT:
EMPLOYEES FIT PAYABLE
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
23
6
13
16
20
Checkpoints
ACCOUNT NO. 24
J41
J42
J43
J44
J44
J44
965.00
997.00
1,097.00
340.00
1,962.00
681.00
965.00
1,962.00
3,059.00
3,399.00
1,437.00
2,118.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
1,962.00
2,118.00
ACCOUNT:
EMPLOYEES SIT PAYABLE
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
20
23
4
6
13
18
20
Checkpoints
ACCOUNT NO. 25
J41
J41
J42
J42
J43
J44
J44
J44
434.82
434.82
444.70
444.70
433.83
63.84
497.67
388.08
434.82
0.00
444.70
0.00
433.83
497.67
0.00
388.08
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
444.70
388.08
ACCOUNT:
EMPLOYEES SUTA PAYABLE
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
23
6
13
20
Checkpoints
ACCOUNT NO. 25.1
J41
J42
J43
J44
J44
9.94
10.16
9.92
1.46
8.87
9.94
20.10
30.02
31.48
40.35
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
20.10
40.35
ACCOUNT:
EMPLOYEES CIT PAYABLE
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
9
23
6
13
16
20
Checkpoints
ACCOUNT NO. 26
J41
J42
J43
J44
J44
J44
556.30
568.95
555.03
81.68
1,125.25
496.50
556.30
1,125.25
1,680.28
1,761.96
636.71
1,133.21
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
1,125.25
1,133.21
ACCOUNT:
GROUP INSURANCE PREMIUMS COLLECTED
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Oct.
Nov.
23
13
20
J42
J44
J44
Checkpoints
ACCOUNT NO. 27
165.90
14.40
151.50
165.90
180.30
331.80
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
165.90
331.80
ACCOUNT:
UNION DUES PAYABLE
DATE
ITEM
Checkpoints
ACCOUNT NO. 28
POST.
REF.
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:
SIMPLE CONTRIBUTIONS PAYABLE
DATE
ITEM
POST.
REF.
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
20--
Nov.
20
Checkpoints
ACCOUNT NO. 29
J44
1,650.00
1,650.00
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20--
Credit
Balance
0.00
1,650.00
ACCOUNT:
ADMINISTRATIVE SALARIES
DATE
ITEM
ACCOUNT NO. 51
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
42,692.27
44,999.96
47,307.65
49,615.34
51,923.03
CREDIT
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 47,307.65
Nov. 30, 20-- 51,923.03
Dec. 31, 20--
ACCOUNT:
OFFICE SALARIES
DATE
ITEM
ACCOUNT NO. 52
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
J44
3,353.08
3,353.08
3,320.79
2,079.32
2,112.94
CREDIT
DEBIT
20--
Oct.
Nov.
1 Balance
9
23
6
13
20
28,350.00
31,703.08
35,056.16
38,376.95
40,456.27
42,569.21
CREDIT
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 35,056.16
Nov. 30, 20-- 42,569.21
Dec. 31, 20--
ACCOUNT:
SALES SALARIES
DATE
ITEM
ACCOUNT NO. 53
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
28,525.00
32,125.00
35,725.00
39,325.00
42,925.00
CREDIT
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 35,725.00
Nov. 30, 20-- 42,925.00
Dec. 31, 20--
ACCOUNT:
PLANT WAGES
DATE
ITEM
ACCOUNT NO. 54
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
4,902.00
5,223.92
4,902.00
4,619.60
CREDIT
DEBIT
20--
Oct.
Nov.
1 Balance
9
23
6
20
42,657.30
47,559.30
52,783.22
57,685.22
62,304.82
CREDIT
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 52,783.22
Nov. 30, 20-- 62,304.82
Dec. 31, 20--
ACCOUNT:
PAYROLL TAXES
DATE
ITEM
ACCOUNT NO. 56
POST.
REF.
DEBIT
BALANCE
a
J41
J42
J43
J44
J45
1,231.14
1,241.25
1,157.25
159.07
994.45
CREDIT
DEBIT
20--
Oct.
Nov.
1 Balance
9
23
6
13
20
14,013.23
15,244.37
16,485.62
17,642.87
17,801.94
18,796.39
CREDIT
Checkpoints
Debit
Credit
Balance
Balance
Oct. 31, 20-- 16,485.62
Nov. 30, 20-- 18,796.39
Dec. 31, 20--
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
No. W/H Allow.
NAME
Marital 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-M 4
8 8 8 8 8
M 5
8 8 8 8 8
S 2
8 8 8 8 8
M 4
8 8 8 8 8
M 3
8 8 8 8 8
S 1
8 8 8 8 8
M 4
8 8 8 8 8
M 2
8 8 8 8 8
S 1
8 8 8 8 4
S 0
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.65
80
80
80
80
80
80 18.00
80
72 7.50
80
TOTALS
Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A.
M 4
8 8 8 8 8 4
Ferguson, J.
M 5
8 8 8 8 8
Ford, C.
S 2
8 8 8 8 8
Mann, D.
M 4
8 8 8 8 8
O'Neill, J.
M 3
8 8 8 8 8
Russell, V.
S 1
8 8 8 8 8
Ryan, N.
M 4
8 8 8 8 8
Sokowski, T.
M 2
8 8 8 8 8
(Student)
S 1
8 8 8 8 4
Williams, R.
S 0
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.65
80
80
80
80
80
80 18.00
80
72 7.50
88
TOTALS
Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A.
M 4
8 8 8 8 8
Ferguson, J.
M 5
8 8 8 8 8
Ford, C.
S 2
8 8 8 8 8
8
8
8
GLO-BRITE PAINT COMP
8
8
8
8
8
8
8
8
8
8
8
8
80 17.65
80
80
Amount
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Total
Earnings
OASDI
1,412.00
2,250.00
900.00
1,350.00
2,307.69
690.00
1,440.00
2,050.00
540.00
1,223.08
1,412.00
2,250.00
900.00
1,350.00
2,307.69
690.00
1,440.00
2,050.00
540.00
1,223.08
87.54
139.50
55.80
83.70
143.08
42.78
89.28
127.10
33.48
75.83
14,162.77
14,162.77
878.09
1,517.92
2,250.00
900.00
1,350.00
2,307.69
690.00
1,656.00
2,050.00
540.00
1,223.08
94.11
139.50
55.80
83.70
143.08
42.78
102.67
127.10
33.48
75.83
14,162.77
321.92 14,484.69
898.05
1,412.00
2,250.00
900.00
1,412.00
2,250.00
900.00
87.54
139.50
55.80
1,412.00
2,250.00
900.00
1,350.00
2,307.69
690.00
1,440.00
2,050.00
540.00
1,223.08
4 26.48
105.92
8 27.00
216.00
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
No. W/H Allow.
NAME
Marital Status
PAYROLL REGISTER
M
M
S
M
S
S
S
0
3
2
4
2
1
0
Time Record
S M
8
8
8
8
8
8
8
T W T
8 8 8
8 8 8
8 8 8
8 8 8
8 8 8
8 8 8
8 8 7
F S S M
8
8
8
8
6
8
8
8
8
8
4
8
8
8
Regular Earnings
T
8
8
8
8
8
8
8
Rate
Per
W T F S Hrs. Hour
8 8 8
80
8 8 8
80
8 8 8
78
8 8 8
80 18.00
8 8 8
80
8 8 4
72 7.50
8 8 8
79
TOTALS
Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R.
S 0
6 8 7 7 6
D D 8
TOTALS
GLO-BRITE PAINT COMP
136
Amount
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
1,207.85
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Total
Earnings OASDI
1,350.00
83.70
2,307.69
143.08
672.94
41.72
1,440.00
89.28
2,050.00
127.10
540.00
33.48
1,207.85
74.89
14,130.48
14,130.48
876.09
2,079.32
2,079.32
128.92
2,079.32
2,079.32
128.92
No. W/H Allow.
NAME
Marital Status
PAYROLL REGISTER
Time Record
S M T W T
GLO-BRITE PAINT COMP
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.
M 4
8 8 8 8 8
Ferguson, J.
M 5
8 8 8 8 8
8
Ford, C.
S 2
8 8 8 8 8
8
Mann, D.
M 0
8 8 8 8 8
8
O'Neill, J.
M 3
8 8 8 8 8
8
Russell, V.
S 2
6 8 8 8 8
8
Ryan, N.
M 4
8 8 8 8 8
8
Sokowski, T.
S 2
8 8 8 8 8
8
(Student)
S 1
8 8 8 8 4
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
64 17.65
80
80
80
80
78
80 18.00
80
72 7.50
TOTALS
Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A.
M 4
8 8 8 8 8
8* 8 8 8
Ferguson, J.
M 5
8 8 8 8 8
8 8 8
Ford, C.
S 2
8 8 8 8 8
8 8 8
Mann, D.
M 0
8 8 8 8 8
8 8 8
O'Neill, J.
M 3
8 8 8 8 8
8 8 8
Russell, V.
S 2
8 8 8 8 8
8 8 8
Ryan, N.
M 4
8 10 8 4 8
9 10 8
Sokowski, T.
S 2
8 8 8 8 8
8 8 8
(Student)
S 1
8 8 8 4 8
8 8 8
Woods, B.
8 8 8 8
8 8 8
TOTALS
Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V.
TOTALS
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4
8
80
80
80
80
80
80
76
80
72
72
17.65
28.13
11.25
16.88
28.85
8.63
18.00
25.63
7.50
15.00
Amount
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Total
Earnings
OASDI
1,129.60
2,250.00
900.00
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
1,129.60
2,250.00
900.00
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
70.04
139.50
55.80
83.70
143.08
41.72
89.28
127.10
33.48
12,640.23
12,640.23
783.70
1,694.40
2,250.00
960.00
1,350.00
2,307.69
750.00
1,449.00
2,050.00
540.00
1,080.00
105.05
139.50
59.52
83.70
143.08
46.50
89.84
127.10
33.48
66.96
363.40 14,431.09
894.73
1,412.00
2,250.00
960.00
1,350.00
2,307.69
750.00
1,368.00
2,050.00
540.00
1,080.00
14,067.69
8 35.50
282.40
3 27.00
81.00
No. W/H Allow.
NAME
Marital 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, December 18, 20-- For Period Ending December 12, 20-Bonno, A.
M 5 4 8 8 8 8 8
8 8
Ferguson, J.
M 5
8 8 8 8 8
8
Ford, C.
S 2
8 8 8 8 8
4
Mann, D.
M 0
8 8 8 8 8
O'Neill, J.
M 3
8 8 8 8 8
Ryan, N.
M 2
8 9 9 9 9
10
Sokowski, T.
S 2
8 8 7 8 4
(Student)
S 1
8 8 8 8 8
4
Woods, B.
8 8 8 8 8
8
Young, P.
S 1
8 8 8 8 8
8
TOTALS
GLO-BRITE PAINT COMP
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
8
4
8
8
12.00
Amount
Overtime Earnings
Rate
Per
Hrs. Hour
Amount
Total
Earnings
OASDI
GLO-BRITE PAINT COMPANY
Deductions
NAME
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
HI
FIT
SIT
For Period Ending October 3, 20-20.47
49.00
43.35
32.63
143.00
69.08
13.05
62.00
27.63
19.58
43.00
41.45
33.46
197.00
70.85
10.01
51.00
21.18
20.88
53.00
44.21
29.73
180.00
62.94
7.83
32.00
16.58
17.73
155.00
37.55
205.37
965.00
434.82
Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A.
22.01
59.00
46.60
Ferguson, J.
32.63
143.00
69.08
Ford, C.
13.05
62.00
27.63
Mann, D.
19.58
43.00
41.45
O'Neill, J.
33.46
197.00
70.85
Russell, V.
10.01
51.00
21.18
Ryan, N.
24.01
75.00
50.84
Sokowski, T.
29.73
180.00
62.94
(Student)
7.83
32.00
16.58
Williams, R.
17.73
155.00
37.55
TOTALS
210.04
997.00
444.70
Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A.
20.47
49.00
43.35
Ferguson, J.
32.63
143.00
69.08
Ford, C.
13.05
62.00
27.63
SUTA
0.99
1.58
0.63
0.95
1.62
0.48
1.01
1.44
0.38
0.86
9.94
1.06
1.58
0.63
0.95
1.62
0.48
1.16
1.44
0.38
0.86
10.16
0.99
1.58
0.63
GLO-BRITE PAINT COMPANY
Deductions
NAME
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
HI
19.58
33.46
9.76
20.88
29.73
7.83
17.51
FIT
120.00
197.00
29.00
53.00
260.00
32.00
152.00
SIT
41.45
70.85
20.66
44.21
62.94
16.58
37.08
SUTA
0.95
1.62
0.47
1.01
1.44
0.38
0.85
204.90
1,097.00
433.83
9.92
Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R.
30.15
340.00
63.84
1.46
TOTALS
30.15
340.00
63.84
1.46
GLO-BRITE PAINT COMPANY
Deductions
NAME
HI
FIT
SIT
SUTA
Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A.
16.38
21.00
34.68
0.79
Ferguson, J.
32.63
68.00
69.08
1.58
Ford, C.
13.05
62.00
27.63
0.63
Mann, D.
19.58
84.00
41.45
0.95
O'Neill, J.
33.46
92.00
70.85
1.62
Russell, V.
9.76
29.00
20.66
0.47
Ryan, N.
20.88
33.00
44.21
1.01
Sokowski, T.
29.73
260.00
62.94
1.44
(Student)
7.83
32.00
16.58
0.38
TOTALS
183.30
681.00
388.08
8.87
Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A.
24.57
52.02
Ferguson, J.
32.63
69.08
Ford, C.
13.92
29.47
Mann, D.
19.58
41.45
O'Neill, J.
33.46
70.85
Russell, V.
10.88
23.03
Ryan, N.
21.01
44.48
Sokowski, T.
29.73
62.94
(Student)
7.83
16.58
Woods, B.
15.66
33.16
TOTALS
209.27
0.00
443.06
1.19
1.58
0.67
0.95
1.62
0.53
1.01
1.44
0.38
0.76
10.13
Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V.
TOTALS
GLO-BRITE PAINT COMPANY
Deductions
NAME
HI
FIT
SIT
SUTA
Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Ryan, N.
Sokowski, T.
(Student)
Woods, B.
Young, P.
TOTALS
Deductions
NAME
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
Net Paid
CIT
Group
Ins.
Union
Dues
Ck.
SIMPLE No.
For Period Ending October 3, 20-55.46
8.00
88.38
35.35
53.03
90.65
27.10
56.56
8.00
80.52
21.21
48.04
556.30
0.00
16.00
672
673
674
675
676
677
678
679
680
681
0.00
Payday, October 23, 20-- For Period Ending October 17, 20-Bonno, A.
59.62 16.50
8.00
Ferguson, J.
88.38 26.40
Ford, C.
35.35 10.50
Mann, D.
53.03 15.90
O'Neill, J.
90.65 27.00
Russell, V.
27.10
8.10
Ryan, N.
65.05 16.80
8.00
Sokowski, T.
80.52 24.00
(Student)
21.21
6.30
Williams, R.
48.04 14.40
TOTALS
568.95 165.90
16.00
682
683
684
685
686
687
688
689
690
691
0.00
Payday, November 6, 20-- For Period Ending October 31, 20-Bonno, A.
55.46
8.00
Ferguson, J.
88.38
Ford, C.
35.35
692
693
694
Amount
1,147.19
1,775.83
705.54
1,108.29
1,771.03
537.45
1,167.06
1,568.27
428.52
888.07
Taxable Earnings
OASDI
HI
1,412.00
2,250.00
900.00
1,350.00
2,307.69
690.00
1,440.00
2,050.00
540.00
1,223.08
1,412.00
2,250.00
900.00
1,350.00
2,307.69
690.00
1,440.00
2,050.00
540.00
1,223.08
11,097.25 14,162.77
14,162.77
1,211.02
1,749.43
695.04
1,092.39
1,744.03
529.35
1,312.47
1,544.27
422.22
873.67
1,517.92
2,250.00
900.00
1,350.00
2,307.69
690.00
1,656.00
2,050.00
540.00
1,223.08
1,517.92
2,250.00
900.00
1,350.00
2,307.69
690.00
1,656.00
2,050.00
540.00
1,223.08
11,173.89 14,484.69
14,484.69
1,147.19
1,775.83
705.54
1,412.00
2,250.00
900.00
1,412.00
2,250.00
900.00
Labor Cost Distribution
FUTA
SUTA
Admin.
Office
700.00
1,350.00
900.00
1,350.00
690.00
690.00
690.00
540.00
540.00
540.00
1,223.08
3,280.00
3,480.00
2,307.69 3,353.08
900.00
250.00
900.00
1,350.00
70.00
690.00
690.00
540.00
540.00
540.00
1,223.08
860.00
3,480.00
2,307.69 3,353.08
400.00
900.00
900.00
2,307.69
2,307.69
Deductions
NAME
Net Paid
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
CIT
53.03
90.65
26.43
56.56
80.52
21.21
47.44
TOTALS
555.03
Group
Ins.
0.00
Union
Dues
Ck.
SIMPLE No.
695
696
697
8.00
698
699
700
701
16.00
0.00
Payday, November 13, 20-- For Period Ending November 14, 20-Williams, R.
81.68 14.40
702
TOTALS
81.68
14.40
0.00
0.00
Amount
1,031.29
1,771.03
544.90
1,167.06
1,488.27
428.52
878.08
Taxable Earnings
OASDI
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
1,207.85
HI
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
1,207.85
10,937.71 14,130.48
14,130.48
1,418.87
2,079.32
2,079.32
1,418.87
2,079.32
2,079.32
FUTA
Labor Cost Distribution
SUTA
400.00
Admin.
Office
2,307.69
672.94
672.94
370.00
540.00
540.00
1,207.85
370.00
2,012.94
2,307.69 3,320.79
2,079.32
0.00
0.00
0.00 2,079.32
Deductions
NAME
Net Paid
CIT
Group
Ins.
Union
Dues
Ck.
SIMPLE No.
Payday, November 20, 20-- For Period Ending November 14, 20-Bonno, A.
44.37 16.50
8.00
Ferguson, J.
88.38 26.40
500.00
Ford, C.
35.35 10.50
Mann, D.
53.03 15.90
250.00
O'Neill, J.
90.65 27.00
700.00
Russell, V.
26.43
8.10
Ryan, N.
56.56 16.80
8.00
200.00
Sokowski, T.
80.52 24.00
(Student)
21.21
6.30
TOTALS
496.50 151.50
16.00 1,650.00
Payday, December 4, 20-- For Period Ending November 28, 20-Bonno, A.
66.56
8.00
Ferguson, J.
88.38
500.00
Ford, C.
37.71
Mann, D.
53.03
250.00
O'Neill, J.
90.65
700.00
Russell, V.
29.46
Ryan, N.
56.92
8.00
200.00
Sokowski, T.
80.52
(Student)
21.21
Woods, B.
42.42
TOTALS
566.86
0.00
16.00 1,650.00
Payday, December 14, 20-- For Period Ending December 12, 20-Russell, V.
TOTALS
703
704
705
706
707
708
709
710
711
Amount
917.84
1,324.43
695.04
801.39
1,149.03
536.80
970.26
1,464.27
422.22
Taxable Earnings
OASDI
HI
1,129.60
2,250.00
900.00
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
1,129.60
2,250.00
900.00
1,350.00
2,307.69
672.94
1,440.00
2,050.00
540.00
8,281.28 12,640.23
12,640.23
1,437.01
1,418.83
818.71
901.29
1,268.03
639.60
1,027.74
1,748.27
460.52
921.04
FUTA
Labor Cost Distribution
SUTA
Admin.
Office
900.00
2,307.69
0.00
207.06
672.94
540.00
540.00
747.06
2,307.69
2,112.94
1,694.40
2,250.00
960.00
1,350.00
2,307.69
750.00
1,449.00
2,050.00
540.00
1,080.00
1,694.40
2,250.00
960.00
1,350.00
2,307.69
750.00
1,449.00
2,050.00
540.00
1,080.00
540.00
1,080.00
540.00
1,080.00
10,641.04 14,431.09
14,431.09
1,080.00
1,620.00
2,307.69 2,250.00
960.00
2,307.69
750.00
Deductions
NAME
Net Paid
CIT
Group
Ins.
Union
Dues
Ck.
SIMPLE No.
Payday, December 18, 20-- For Period Ending December 12, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Ryan, N.
Sokowski, T.
(Student)
Woods, B.
Young, P.
TOTALS
Amount
Taxable Earnings
OASDI
HI
FUTA
Labor Cost Distribution
SUTA
250.00
Admin.
Office
Labor Cost Distribution
NAME
Payday, October 9, 20-Bonno, A.
Ferguson, J.
Ford, C.
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
Sales
Plant
Checkpoints
For Period Ending October 3, 20-1,412.00
Total earnings
2,250.00
Net paid
1,350.00
1,440.00
2,050.00
3,600.00 4,902.00
Payday, October 23, 20-- For Period Ending October 17,Checkpoints
20-Bonno, A.
1,517.92
Total earnings
Ferguson, J.
2,250.00
Net paid
Ford, C.
Mann, D.
1,350.00
O'Neill, J.
Russell, V.
Ryan, N.
1,656.00
Sokowski, T.
2,050.00
(Student)
Williams, R.
TOTALS
14,162.77
11,097.25
14,484.69
11,173.89
3,600.00 5,223.92
Payday, November 6, 20-- For Period Ending October 31,Checkpoints
20-Bonno, A.
1,412.00
Total earnings
Ferguson, J.
2,250.00
Net paid
Ford, C.
14,130.48
10,937.71
Labor Cost Distribution
NAME
Mann, D.
O'Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
Sales
1,350.00
Plant
1,440.00
2,050.00
3,600.00 4,902.00
Payday, November 13, 20-- For Period Ending NovemberCheckpoints
14, 20-Williams, R.
Total earnings
Net paid
TOTALS
0.00
0.00
2,079.32
1,418.87
Labor Cost Distribution
NAME
Sales
Plant
Payday, November 20, 20-- For Period Ending NovemberCheckpoints
14, 20-Bonno, A.
1,129.60
Total earnings
Ferguson, J.
2,250.00
Net paid
Ford, C.
Mann, D.
1,350.00
O'Neill, J.
Russell, V.
Ryan, N.
1,440.00
Sokowski, T.
2,050.00
(Student)
TOTALS
3,600.00 4,619.60
Payday, December 4, 20-- For Period Ending November Checkpoints
28, 20-Bonno, A.
1,694.40
Total earnings
Ferguson, J.
2,250.00
Net paid
Ford, C.
Mann, D.
1,350.00
O'Neill, J.
Russell, V.
Ryan, N.
1,449.00
Sokowski, T.
2,050.00
(Student)
Woods, B.
TOTALS
12,640.23
8,281.28
3,600.00 5,193.40
Payday, December 14, 20-- For Period Ending DecemberCheckpoints
12, 20-Russell, V.
Total earnings
Net paid
TOTALS
14,431.09
Labor Cost Distribution
NAME
Sales
Plant
Payday, December 18, 20-- For Period Ending DecemberCheckpoints
12, 20-Bonno, A.
Total earnings
Ferguson, J.
Net paid
Ford, C.
Mann, D.
O'Neill, J.
Ryan, N.
Sokowski, T.
(Student)
Woods, B.
Young, P.
TOTALS
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
Plant
Mixer Operator
PA
SEX
M F
S.S. ACCOUNT NO.
000-00-3481
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
$55,000 --$.30/M
$8 each pay
NAME - LAST
FIRST
BONNO
Anthony
$
$
$
$
SALARY
OTHER
WEEKLY RATE
HOURLY RATE
20___
PAYDAY
REGULAR EARNINGS
HRS.
RATE
AMOUNT
10/9
10/23
11/6
11/20
12/4
12/18
80
80
80
64
HRS. RATE
10,293.40
1,412.00
1,412.00
1,412.00
1,129.60
YEAR-TO-DATE
OVERTIME EARNINGS
17.65
17.65
17.65
17.65
26.48
OVERTIME R
CUMULATIVE
EARNINGS
AMOUNT
11,322.00
12,734.00
14,251.92
15,663.92
16,793.52
17.65
26.48
DEDUCTIONS
FICA
OASDI
1,028.60
0.00
105.92
0.00
0.00
0.00
0.00
W/H
ALLOW.
701.96
87.54
94.11
87.54
70.04
OTHER
HI
164.17
20.47
22.01
20.47
16.38
FIT
SIT
810.00
49.00
59.00
49.00
21.00
SUTA
347.59
43.35
46.60
43.35
34.68
CIT
7.93
0.99
1.06
0.99
0.79
SIMPLE
444.73
55.46
59.62
55.46
44.37
DEDUCTIONS
216.80
8.00
24.50
8.00
24.50
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
Sales
Sales Manager
PA
SEX
M F
S.S. ACCOUNT NO.
000-00-8645
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
NAME - LAST
FIRST
FERGUSON
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$88,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
10/9
10/23
11/6
11/20
12/4
12/18
CUMULATIVE
80
80
80
80
RATE
AMOUNT
HRS. RATE
23,125.00
2,250.00
2,250.00
2,250.00
2,250.00
AMOUNT
FICA
1,433.75
139.50
139.50
139.50
139.50
OTHER
HI
335.31
32.63
32.63
32.63
32.63
FIT
2,291.00
143.00
143.00
143.00
68.00
SIT
SUTA
709.94
69.08
69.08
69.08
69.08
QTR. TOT.
YR. TOT.
Checkpoint
W/H
ALLOW.
DEDUCTIONS
OASDI
23,125.00
25,375.00
27,625.00
29,875.00
32,125.00
James
58,500 /yr.
1,125.00
28.13
Checkpoint
16.19
1.58
1.58
1.58
1.58
CIT
908.35
88.38
88.38
88.38
88.38
SIMPLE
DEDUCTIONS
132.30
26.40
500.00
26.40
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Office
Executive Secretary
PA
000-00-4567
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
FORD
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$37,000--$.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
CUMULATIVE
PAYDAY
EARNINGS
HRS.
RATE
AMOUNT
10/9
10/23
11/6
11/20
12/4
12/18
HRS. RATE
AMOUNT
80
80
80
80
6,300.00
7,200.00
8,100.00
9,000.00
9,900.00
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
6,300.00
900.00
900.00
900.00
900.00
YEAR-TO-DATE
Catherine
2,080 /mo.
480.00
12.00
18.00
390.60
55.80
55.80
55.80
55.80
OTHER
HI
91.35
13.05
13.05
13.05
13.05
FIT
639.00
62.00
62.00
62.00
62.00
SIT
SUTA
193.41
27.63
27.63
27.63
27.63
4.41
0.63
0.63
0.63
0.63
CIT
SIMPLE
DEDUCTIONS
247.46
35.35
35.35
35.35
35.35
37.80
10.50
10.50
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Sales
Sales Representative
PA
000-00-9352
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
MANN
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$53,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
10/9
10/23
11/6
11/20
12/4
12/18
TR. TOT.
YR. TOT.
CUMULATIVE
80
80
80
80
RATE
AMOUNT
5,400.00
1,350.00
1,350.00
1,350.00
1,350.00
HRS. RATE
AMOUNT
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
5,400.00
6,750.00
8,100.00
9,450.00
10,800.00
Dewey
2,925 /mo.
675.00
16.88
334.80
83.70
83.70
83.70
83.70
OTHER
HI
78.30
19.58
19.58
19.58
19.58
FIT
332.00
43.00
43.00
120.00
84.00
SIT
165.78
41.45
41.45
41.45
41.45
SUTA
3.78
0.95
0.95
0.95
0.95
CIT
212.11
53.03
53.03
53.03
53.03
SIMPLE
DEDUCTIONS
31.50
15.90
250.00
15.90
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Administrative
President
PA
000-00-1534
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
O'NEILL
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$90,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
CUMULATIVE
PAYDAY
EARNINGS
HRS.
RATE
AMOUNT
10/9
10/23
11/6
11/20
12/4
12/18
HRS. RATE
AMOUNT
80
80
80
80
42,692.27
44,999.96
47,307.65
49,615.34
51,923.03
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
42,692.27
2,307.69
2,307.69
2,307.69
2,307.69
YEAR-TO-DATE
Joseph
60,000 /yr.
1,153.85
28.85
2,646.92
143.08
143.08
143.08
143.08
OTHER
HI
619.04
33.46
33.46
33.46
33.46
FIT
6,116.00
197.00
197.00
197.00
92.00
SIT
SUTA
1,310.65
70.85
70.85
70.85
70.85
29.88
1.62
1.62
1.62
1.62
CIT
1,676.95
90.65
90.65
90.65
90.65
SIMPLE
DEDUCTIONS
202.50
27.00
700.00
27.00
TR. TOT.
YR. TOT.
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
000-00-6337
RUSSELL
FIRST
M F
Office
Time Clerk
PA
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$29,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
10/9
10/23
11/6
11/20
12/4
12/14
TR. TOT.
YR. TOT.
CUMULATIVE
80
80
78
78
RATE
AMOUNT
6,240.00
690.00
690.00
672.94
672.94
HRS. RATE
AMOUNT
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
6,240.00
6,930.00
7,620.00
8,292.94
8,965.88
Virginia
1,625 /mo.
375.00
9.38
14.07
386.88
42.78
42.78
41.72
41.72
OTHER
HI
90.48
10.01
10.01
9.76
9.76
FIT
642.00
51.00
51.00
29.00
29.00
SIT
191.56
21.18
21.18
20.66
20.66
SUTA
4.37
0.48
0.48
0.47
0.47
CIT
245.11
27.10
27.10
26.43
26.43
SIMPLE
DEDUCTIONS
31.50
8.10
8.10
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Plant
Electrician
PA
000-00-1223
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
RYAN
Norman
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$56,000 -- $.30/M
20___
$8 each pay
REGULAR EARNINGS
OVERTIME EARNINGS
OVERTIME R
CUMULATIVE
PAYDAY
EARNINGS
HRS.
RATE
AMOUNT
13,287.50
1,440.00
1,440.00
1,440.00
1,440.00
YEAR-TO-DATE
10/9
10/23
11/6
11/20
12/4
12/18
80
80
80
80
18.00
18.00
18.00
18.00
HRS. RATE
27.00
AMOUNT
14,685.30
16,125.30
17,781.30
19,221.30
20,661.30
18.00
27.00
DEDUCTIONS
FICA
OASDI
1,397.80
0.00
216.00
0.00
0.00
0.00
0.00
W/H
ALLOW.
910.49
89.28
102.67
89.28
89.28
OTHER
HI
212.94
20.88
24.01
20.88
20.88
FIT
1,070.00
53.00
75.00
53.00
33.00
SIT
SUTA
450.84
44.21
50.84
44.21
44.21
10.28
1.01
1.16
1.01
1.01
CIT
576.84
56.56
65.05
56.56
56.56
SIMPLE
200.00
DEDUCTIONS
235.70
8.00
24.80
8.00
24.80
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Plant
Supervisor
PA
000-00-8832
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
SOKOWSKI
Thomas
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$80,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
10/9
10/23
11/6
11/20
12/4
12/18
QTR. TOT.
YR. TOT.
CUMULATIVE
80
80
80
80
RATE
AMOUNT
16,650.00
2,050.00
2,050.00
2,050.00
2,050.00
HRS. RATE
AMOUNT
ALLOW.
DEDUCTIONS
FICA
OASDI
16,650.00
18,700.00
20,750.00
22,800.00
24,850.00
W/H
1,025.00
25.63
1,032.30
127.10
127.10
127.10
127.10
OTHER
HI
241.43
29.73
29.73
29.73
29.73
FIT
2,002.00
180.00
180.00
260.00
260.00
SIT
511.16
62.94
62.94
62.94
62.94
SUTA
11.66
1.44
1.44
1.44
1.44
CIT
654.01
80.52
80.52
80.52
80.52
SIMPLE
DEDUCTIONS
94.50
24.00
24.00
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Office
Accounting Trainee
PA
Student
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$21,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
CUMULATIVE
PAYDAY
EARNINGS
HRS.
RATE
AMOUNT
10/9
10/23
11/6
11/20
12/4
12/18
72
72
72
72
HRS. RATE
AMOUNT
7.50
7.50
7.50
7.50
5,550.00
6,090.00
6,630.00
7,170.00
7,710.00
7.50
11.25
DEDUCTIONS
FICA
OASDI
5,550.00
540.00
540.00
540.00
540.00
YEAR-TO-DATE
W/H
ALLOW.
344.10
33.48
33.48
33.48
33.48
OTHER
HI
80.48
7.83
7.83
7.83
7.83
FIT
409.00
32.00
32.00
32.00
32.00
SIT
SUTA
170.38
16.58
16.58
16.58
16.58
3.89
0.38
0.38
0.38
0.38
CIT
SIMPLE
DEDUCTIONS
218.00
21.21
21.21
21.21
21.21
32.40
6.30
6.30
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
000-00-6741
WILLIAMS
FIRST
M F
Office
Programmer
PA
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
Ruth
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$48,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
10/9
10/23
11/6
11/13
CUMULATIVE
80
80
79
136
RATE
AMOUNT
HRS. RATE
AMOUNT
2,650 /mo.
611.54
15.29
22.94
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
DEDUCTIONS
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
155.00
155.00
152.00
340.00
314.98
37.55
37.55
37.08
63.84
7.18
0.86
0.86
0.85
1.46
403.01
48.04
48.04
47.44
81.68
59.40
5,733.33
15,993.33
5,733.33
15,993.33
355.47
991.59
83.12
231.89
802.00
2,408.00
176.02
491.00
4.03
11.21
225.20
628.21
28.80
88.20
14.40
14.40
5
6
QTR. TOT.
YR. TOT.
375
Checkpoint
5,733.33
15,993.33
Checkpoint
4,058.69
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Office
Programmer
PA
000-00-1587
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
Woods
Beth
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$47,000 -- $.30/M
20___
OVERTIME R
REGULAR EARNINGS
OVERTIME EARNINGS
CUMULATIVE
PAYDAY
EARNINGS
HRS.
RATE
AMOUNT
HRS. RATE
AMOUNT
W/H
600.00
15.00
ALLOW.
DEDUCTIONS
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
DEDUCTIONS
YEAR-TO-DATE
1
2
3
4
5
12/4
12/18
QTR. TOT.
YR. TOT.
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
Sales
Field Sales Representative
PA
000-00-6057
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
Young
Paul
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$32,000 -- $.30/M
20___
REGULAR EARNINGS
OVERTIME R
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
1
2
3
4
5
6
12/18
QTR. TOT.
YR. TOT.
CUMULATIVE
RATE
AMOUNT
HRS. RATE
AMOUNT
W/H
403.85
10.10
ALLOW.
DEDUCTIONS
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
DEDUCTIONS
Checkpoint
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
OVERTIME R
20___
REGULAR EARNINGS
OVERTIME EARNINGS
CUMULATIVE
PAYDAY
EARNINGS
HRS.
RATE
AMOUNT
HRS. RATE
AMOUNT
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
DEDUCTIONS
YEAR-TO-DATE
1
2
3
4
5
6
QTR. TOT.
YR. TOT.
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME - LAST
FIRST
M F
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
OVERTIME R
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
1
2
3
4
5
6
QTR. TOT.
YR. TOT.
CUMULATIVE
RATE
AMOUNT
HRS. RATE
AMOUNT
W/H
ALLOW.
DEDUCTIONS
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
DEDUCTIONS
MIDDLE
Victor
MARITAL
STATUS
M
NET PAID
CK.
NO.
AMOUNT
8,628.82
1,147.19
1,211.02
1,147.19
917.84
672
682
692
703
MIDDLE
Claude
MARITAL
STATUS
M
NET PAID
CK.
NO.
AMOUNT
673
683
693
704
17,298.16
1,775.83
1,749.43
1,775.83
1,324.43
MIDDLE
Louise
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
4,695.97
705.54
695.04
705.54
695.04
674
684
694
705
MIDDLE
Wilson
MARITAL
STATUS
M
NET PAID
CK.
NO.
AMOUNT
675
685
695
706
4,241.73
1,108.29
1,092.39
1,031.29
801.39
MIDDLE
Tyler
MARITAL
STATUS
M
NET PAID
CK.
NO.
AMOUNT
676
686
696
707
30,090.33
1,771.03
1,744.03
1,771.03
1,149.03
MIDDLE
Aloise
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
677
687
697
708
4,648.10
537.45
529.35
544.90
536.80
MIDDLE
Allen
MARITAL
STATUS
M
NET PAID
CK.
NO.
AMOUNT
11,218.21
1,167.06
1,312.47
1,167.06
970.26
678
688
698
709
MIDDLE
James
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
679
689
699
710
12,102.94
1,568.27
1,544.27
1,488.27
1,464.27
MIDDLE
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
4,291.75
428.52
422.22
428.52
422.22
680
690
700
711
MIDDLE
Virginia
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
681
691
701
702
7,084.54
888.07
873.67
878.08
1,418.87
4,058.69
11,143.23
11,143.23
MIDDLE
Anne
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
MIDDLE
Winston
MARITAL
STATUS
S
NET PAID
CK.
NO.
AMOUNT
MIDDLE
MARITAL
STATUS
NET PAID
CK.
NO.
AMOUNT
MIDDLE
MARITAL
STATUS
NET PAID
CK.
NO.
AMOUNT
