Excel InstructionsCAUTION: 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 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_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
9 Payroll Cash
Cash
POST.
REF.
DEBIT
12
11
12.291,11
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.651,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.381,61
23 Payroll Cash
Cash
23 Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employee FIT Payable
Employee SIT Payable
Employee SUTA Payable
CREDIT
12.291,11
958,33
224,14
882,00
474,55
9,25
601,39
16,00
12.291,11
958,32
224,12
22,91
176,26
Page 42
JOURNAL
DATE
20–
DESCRIPTION
Employee CIT Payable
Union Dues Payable
Payroll Cash
23 Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
FUTA Taxes Payable – HI
SUTA Taxes Payable – Employer
Payroll Cash
Cash
Administrative Salaries
Office Salaries
Sales Salaries
Plant Wages
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
Employee FIT Payable
Employee SIT Payable
Employee SUTA Payable
Employee CIT Payable
Union Dues Payable
Payroll Cash
POST.
REF.
DEBIT
CREDIT
Page 43
JOURNAL
DATE
20–
DESCRIPTION
Payroll Taxes
FICA Taxes Payable – OASDI
FICA Taxes Payable – HI
FUTA Taxes Payable – HI
SUTA Taxes Payable – Employer
POST.
REF.
DEBIT
CREDIT
Page 44
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
Page 45
JOURNAL
DATE
20–
DESCRIPTION
POST.
REF.
DEBIT
CREDIT
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):
29.129,49
29.129,49
Your debits and credits should be equal after each journal entry is complete
Cumulative Journal Checkpoint Through Month Ending
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
20–
Oct.
1 Balance
9
a
J41
199.846,33
12.291,11 187.555,22
CREDIT
Debit
Balance
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 12
PAYROLL CASH
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
9
9
J41
J41
Checkpoints
Debit
Balance
12.291,11
12.291,11
12.291,11
0,00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 20.1
FICA TAXES PAYABLE – OASDI
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
9
J41
J41
958,33
958,32
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-958,33 Dec. 31, 20-1.916,65
Credit
Balance
ACCOUNT:
ACCOUNT NO. 20.2
FICA TAXES PAYABLE – HI
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
9
J41
J41
224,14
224,12
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-224,14 Dec. 31, 20-448,26
Credit
Balance
ACCOUNT:
ACCOUNT NO. 21
FUTA TAXES PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
1 Balance
9
a
J41
22,91
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-392,94 Dec. 31, 20-415,85
Credit
Balance
ACCOUNT:
ACCOUNT NO. 22
SUTA TAXES PAYABLE – EMPLOYER
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
J41
176,26
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-176,26 Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 24
EMPLOYEES FIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
J41
882,00
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-882,00 Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 25
EMPLOYEES SIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
J41
474,55
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-474,55 Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 25.1
EMPLOYEES SUTA PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
J41
Checkpoints
Debit
Balance
9,25
DEBIT
CREDIT
Oct. 31, 20-Nov. 30, 20-9,25 Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 26
EMPLOYEES CIT PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
J41
601,39
DEBIT
Checkpoints
Debit
Balance
CREDIT
Oct. 31, 20-Nov. 30, 20-601,39 Dec. 31, 20–
Credit
Balance
ACCOUNT:
DATE
20–
ACCOUNT NO. 27
GROUP INSURANCE PREMIUMS COLLECTED
ITEM
POST.
REF.
Checkpoints
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 28
UNION DUES PAYABLE
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
20–
Oct.
9
J41
Checkpoints
Debit
Balance
16,00
DEBIT
CREDIT
Oct. 31, 20-Nov. 30, 20-16,00 Dec. 31, 20–
Credit
Balance
ACCOUNT:
DATE
20–
ACCOUNT NO. 29
SIMPLE CONTRIBUTIONS PAYABLE
ITEM
POST.
REF.
Checkpoints
Debit
Balance
BALANCE
DEBIT
CREDIT
DEBIT
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 51
ADMINISTRATIVE SALARIES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
a
J41
Checkpoints
Debit
Balance
2.307,69
42.692,27
44.999,96
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 52
OFFICE SALARIES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
a
J41
Checkpoints
Debit
Balance
4.651,08
28.350,00
33.001,08
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 53
SALES SALARIES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
a
J41
Checkpoints
Debit
Balance
3.600,00
28.525,00
32.125,00
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 54
PLANT WAGES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
a
J41
Checkpoints
Debit
Balance
4.898,00
42.657,30
47.555,30
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
ACCOUNT:
ACCOUNT NO. 56
PAYROLL TAXES
DATE
ITEM
POST.
REF.
BALANCE
DEBIT
CREDIT
DEBIT
20–
Oct.
1 Balance
9
a
J41
Checkpoints
Debit
Balance
1.381,61
14.353,07
15.734,68
CREDIT
Oct. 31, 20-Nov. 30, 20-Dec. 31, 20–
Credit
Balance
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
GLO-BRITE PAINT COMPANY
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,60
80
80
80
80
80
80 18,00
80
72 14,00
80
TOTALS
Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A. (Hourly)
M 4
8 8 8 8 8 4
Ferguson, J.
M 5
8 8 8 8 8
Ford, C.
S 2
4 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. (Hourly)
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
84
80
76
80
80
80
80
80
72
80
17,60
28,13
15,25
16,88
28,85
15,00
18,00
25,63
14,00
15,29
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
Mann, D.
M 0
8 8 8 8 8
O’Neill, J.
M 3
8 8 8 8 8
Russell, V.
S 2
8 8 8 8 6
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 7 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
78
80 18,00
80
72 14,00
79
TOTALS
6
8
135
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.008,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.008,00
1.223,08
87,30
139,50
75,64
83,70
143,08
74,40
89,28
127,10
62,50
75,83
20,42
32,63
17,69
19,58
33,46
17,40
20,88
29,73
14,62
17,73
33,00
107,00
85,00
27,00
152,00
102,00
35,00
140,00
78,00
123,00
43,23
69,08
37,45
41,45
70,85
36,84
44,21
62,94
30,95
37,55
0,84
1,35
0,73
0,81
1,38
0,72
0,86
1,23
0,60
0,73
15.456,77
15.456,77
958,33
224,14
882,00
474,55
9,25
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.008,00
1.223,08
93,84
139,50
75,64
83,70
143,08
74,40
102,67
127,10
62,50
75,83
21,95
32,63
17,69
19,58
33,46
17,40
24,01
29,73
14,62
17,73
43,00
107,00
85,00
27,00
152,00
102,00
7,00
140,00
78,00
123,00
46,47
69,08
37,45
41,45
70,85
36,84
50,84
62,94
30,95
37,55
0,91
1,35
0,73
0,81
1,38
0,72
0,99
1,23
0,60
0,73
15.778,37
978,26
228,80
864,00
484,42
9,45
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.008,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.008,00
1.207,85
87,30
139,50
75,64
83,70
143,08
72,54
89,28
127,10
62,50
74,89
20,42
32,63
17,69
19,58
33,46
16,97
20,88
29,73
14,62
17,51
33,00
107,00
85,00
27,00
152,00
43,23
69,08
37,45
41,45
70,85
35,92
44,21
62,94
30,95
37,08
0,84
1,35
0,73
0,81
1,38
0,70
0,86
1,23
0,60
0,72
15.411,54
15.411,54
955,53
223,49
404,00
473,16
9,22
2.079,32
2.079,32
128,92
30,15
268,00
63,84
1,25
2.079,32
2.079,32
128,92
30,15
268,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.008,00
1.223,08
15.456,77
Payday, November 13, 20– For Period Ending November 14, 20-Williams, R.
S 0
6 8 7 7 6
D D 8
TOTALS
Amount
Overtime Earnings
4 26,40
105,60
8 27,00
216,00
321,60
No. W/H Allow.
NAME
Marital Status
PAYROLL REGISTER
Time Record
S M T W T
GLO-BRITE PAINT COMPANY
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.
M 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,60
80
80
80
80
78
80 18,00
80
72 14,00
TOTALS
Payday, December 4, 20– For Period Ending November 28, 20-Bonno, A.
M 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
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
8 8 8 8 6
8
Ryan, N.
M 4
8 8 8 4 8
10
Sokowski, T.
M 2
8 8 8 8 8
8
(Student)
S 1
8 8 8 4 8
8
Woods, B.
1
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
P
A
I
D
H
O
L
I
D
A
Y
8
8
8
8
8
8
8
8
8
8
80
80
80
80
80
80
76
80
80
72
17,60
18,00
14,00
15,00
TOTALS
Payday, December 14, 20– For Period Ending December 12, 20-Russell, V.
S 2
8 8 8 8 8
8
TOTALS
Quarter Totals
Annual Totals
Rate
Per
Hrs. Hour
8
8
8
152
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
9
8
8
8
8
8
8
8
8
8
8
8
8
8
8
80 17,60
80
80
80
80
80 18,00
80
79 14,00
80
80
Amount
Deductions
Total
Earnings
OASDI
HI
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.008,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.008,00
69,84
139,50
75,64
83,70
143,08
72,54
89,28
127,10
62,50
16,33
32,63
17,69
19,58
33,46
16,97
20,88
29,73
14,62
13.922,09
13.922,09
863,18
201,89
1.689,60
2.250,00
1.280,00
1.350,00
2.307,69
1.260,00
1.449,00
2.050,00
1.008,00
1.080,00
104,76
139,50
79,36
83,70
143,08
78,12
89,84
127,10
62,50
66,96
24,50
32,63
18,56
19,58
33,46
18,27
21,01
29,73
14,62
15,66
15.724,29
974,92
228,02
2.394,00
2.394,00
148,43
34,71
2.394,00
2.394,00
148,43
34,71
1.408,00
2.250,00
1.280,00
1.350,00
2.307,69
1.260,00
1.368,00
2.050,00
1.008,00
1.080,00
8 35,20
281,60
3 27,00
81,00
15.361,69
TOTALS
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
8
Mann, D.
M 0
8 8 8 8 8
8
O’Neill, J.
M 4
8 8 8 8 8
8
Ryan, N.
M 4
8 9 9 9 9
10
Sokowski, T.
S 2
8 8 8 8 8
8
(Student)
S 1
8 8 9 8 8
8
Woods, B.
S 1
8 8 8 8 8
8
Young, P.
S 1
8 8 8 8 8
8
Amount
Overtime Earnings
1.408,00
2.250,00
1.280,00
1.350,00
77.307,69
1.440,00
2.050,00
994,00
1.200,00
1.260,00
90.539,69
362,60
12 35,20
422,40
7 27,00
189,00
611,40
FIT
0,00
0,00
SIT
SUTA
34,58
69,08
37,45
41,45
70,85
35,92
44,21
62,94
30,95
0,68
1,35
0,73
0,81
1,38
0,70
0,86
1,23
0,60
427,43
8,34
51,87
69,08
39,30
41,45
70,85
38,68
44,48
62,94
30,95
33,16
1,01
1,35
0,77
0,81
1,38
0,76
0,87
1,23
0,60
0,65
482,76
9,43
1,44
0,00
0,00
1,44
1.830,40
2.250,00
1.280,00
1.350,00
77.307,69
1.629,00
2.050,00
994,00
1.200,00
1.260,00
113,48
26,54
139,50
32,63
79,36
18,56
83,70
19,58
4.598,48 1.120,96
101,00
23,62
127,10
29,73
61,63
14,41
74,40
17,40
78,12
18,27
56,19
69,08
39,30
41,45
2.373,35
50,01
62,94
30,52
36,84
38,68
1,10
1,35
0,77
0,81
46,38
0,98
1,23
0,60
0,72
0,76
91.151,09
5.456,77 1.321,70
0,00 2.798,36
54,70
171.917,47 10.464,34 2.492,90
314.142,04 19.282,26 4.555,17
2.418,00 5.204,52
18.335,00 9.570,81
103,08
188,42
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
SIMPLE
0,00
16,00
672
673
674
675
676
677
678
679
680
681
0,00
613,90
0,00
16,00
0,00
599,62
0,00
16,00
0,00
Payday, November 13, 20– For Period Ending November 14, 20-Williams, R.
80,90
14,40
TOTALS
80,90
14,40
0,00
HI
FUTA
SUTA
Admin.
Office
Sales
Plant
1.160,43
1.812,90
956,02
1.124,94
1.817,13
921,95
1.185,74
1.609,24
782,11
920,65
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.008,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.008,00
1.223,08
12.291,11
15.456,77
15.456,77
1.240,54
1.812,90
956,02
1.124,94
1.817,13
921,95
1.398,06
1.609,24
782,11
920,65
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.008,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.008,00
1.223,08
12.583,54
15.778,37
15.778,37
1.160,43
1.812,90
956,02
1.124,94
1.817,13
998,35
1.220,74
1.749,24
860,11
1.030,66
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.008,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.008,00
1.207,85
12.730,52
15.411,54
15.411,54
1.491,86
2.079,32
2.079,32
1.491,86
2.079,32
2.079,32
1.408,00
2.250,00
700,00
1.350,00
1.220,00
1.350,00
Total earnings
Net paid
15.456,77
12.291,11
1.220,00
1.350,00
2.307,69
760,00
1.200,00
1.200,00
1.440,00
2.050,00
1.008,00
1.008,00
3.818,00
4.778,00
1.008,00
1.223,08
2.307,69
4.651,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.778,37
12.352,34
1.220,00
1.350,00
2.307,69
1.200,00
1.200,00
1.656,00
2.050,00
442,00
1.008,00
692,00
4.778,00
1.008,00
1.223,08
2.307,69
4.651,08
3.600,00
5.219,60
Checkpoints
Payday, November 6, 20– For Period Ending October 31, 20-Bonno, A.
54,78
8,00
Ferguson, J.
87,54
Ford, C.
47,47
Mann, D.
52,52
O’Neill, J.
89,79
Russell, V.
45,52
Ryan, N.
56,03
8,00
Sokowski, T.
79,76
(Student)
39,22
Williams, R.
46,99
TOTALS
OASDI
Checkpoints
Payday, October 23, 20– For Period Ending October 17, 20-Bonno, A. (Hourly)
58,89
8,00
Ferguson, J.
87,54
Ford, C.
47,47
Mann, D.
52,52
O’Neill, J.
89,79
Russell, V.
46,69
Ryan, N. (Hourly)
64,43
8,00
Sokowski, T.
79,76
(Student)
39,22
Williams, R.
47,59
TOTALS
Amount
Labor Cost Distribution
Checkpoints
For Period Ending October 3, 20-54,78
8,00
87,54
47,47
52,52
89,79
46,69
56,03
8,00
79,76
39,22
47,59
601,39
Ck.
No.
Taxable Earnings
0,00
1.408,00
2.250,00
760,00
1.350,00
Total earnings
Net paid
15.411,54
12.157,52
1.220,00
1.350,00
2.307,69
860,00
1.170,00
1.440,00
2.050,00
1.008,00
0,00
3.978,00
1.008,00
1.207,85
2.307,69
4.605,85
3.600,00
4.898,00
Checkpoints
2.079,32
0,00
0,00
0,00
2.079,32
Total earnings
Net paid
0,00
0,00
2.079,32
1.491,86
Deductions
NAME
Net Paid
CIT
Group
Ins.
Union
Dues
SIMPLE
October 9, 20,
20–20–For
3, 20-Payday, November
ForPeriod
PeriodEnding
EndingOctober
November
14, 20-Bonno, A.
43,82
8,00
Ferguson, J.
87,54
Ford, C.
47,47
Mann, D.
52,52
O’Neill, J.
89,79
Russell, V.
45,52
Ryan, N.
56,03
8,00
Sokowski, T.
79,76
(Student)
39,22
TOTALS
541,67
0,00
16,00
0,00
Payday, December 4, 20– For Period Ending November 28, 20-Bonno, A.
65,74
8,00
Ferguson, J.
87,54
Ford, C.
49,80
Mann, D.
52,52
O’Neill, J.
89,79
Russell, V.
49,02
Ryan, N.
56,38
8,00
Sokowski, T.
79,76
(Student)
39,22
Woods, B.
42,02
TOTALS
611,79
0,00
16,00
0,00
Payday, December 14, 20– For Period Ending December 12, 20-Russell, V.
14,70
TOTALS
0,00
14,70
0,00
0,00
Payday, December 18, 20– For Period Ending December 12, 20-Bonno, A.
71,22
8,00
Ferguson, J.
87,54
Ford, C.
49,80
Mann, D.
52,52
O’Neill, J.
3.007,81
Ryan, N.
63,38
8,00
Sokowski, T.
79,76
(Student)
38,67
Woods, B.
46,69
Young, P.
49,02
TOTALS
Quarter Totals
Annual Totals
3.546,41
6.595,68
12.129,21
0,00
16,00
29,10 96,00
959,50 240,00
0,00
0,00
0,00
Ck.
No.
Amount
Taxable Earnings
OASDI
HI
FUTA
Labor Cost Distribution
SUTA
Admin.
Office
Sales
Plant
Checkpoints
953,15
1.919,90
1.041,02
1.151,94
1.969,13
998,35
1.220,74
1.749,24
860,11
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.008,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.008,00
1.126,40
11.863,58
13.922,09
13.922,09
1.433,72
1.919,90
1.092,21
1.151,94
1.969,13
1.075,15
1.228,42
1.749,24
860,11
921,55
1.689,60
2.250,00
1.280,00
1.350,00
2.307,69
1.260,00
1.449,00
2.050,00
1.008,00
1.080,00
1.689,60
2.250,00
1.280,00
1.350,00
2.307,69
1.260,00
1.449,00
2.050,00
1.008,00
1.080,00
1.080,00
1.080,00
13.401,37
15.724,29
15.724,29
1.080,00
1.080,00
2.194,72
2.394,00
2.394,00
2.194,72
2.394,00
2.394,00
1.553,87
1.919,90
1.092,21
1.151,94
66.160,71
1.382,01
1.749,24
848,17
1.023,95
1.075,15
1.830,40
2.250,00
1.280,00
1.350,00
64.269,28
1.629,00
2.050,00
994,00
1.200,00
1.260,00
1.830,40
2.250,00
1.280,00
1.350,00
77.307,69
1.629,00
2.050,00
994,00
1.200,00
1.260,00
1.200,00
1.260,00
1.200,00
1.260,00
77.957,15
78.112,68
91.151,09
2.460,00
2.460,00
2.250,00
50,00
1.220,00
Total earnings
Net paid
13.922,09
9.407,78
1.350,00
2.307,69
1.170,00
1.440,00
2.050,00
926,00
0,00
976,00
1.008,00
2.307,69
3.398,00
3.600,00
4.616,40
Checkpoints
Total earnings
Net paid
2.250,00
15.724,29
10.948,37
1.280,00
1.350,00
2.307,69
1.260,00
1.449,00
2.050,00
1.008,00
1.080,00
2.307,69
4.628,00
3.600,00
3.499,00
Checkpoints
2.394,00
0,00
0,00
0,00
2.394,00
Total earnings
Net paid
0,00
2.394,00
2.194,72
0,00
Checkpoints
1.830,40
2.250,00
Total earnings
Net paid
91.151,09
1.280,00
1.350,00
77.307,69
1.629,00
2.050,00
994,00
1.200,00
1.260,00
77.307,69
3.474,00
4.860,00
5.509,40
144.513,85 158.879,06 171.917,47
8.050,00 18.050,00 88.846,14 29.881,33 22.860,00 28.640,40
248.881,67 301.103,63 314.142,04 73.540,00 101.540,00 131.538,41 58.231,33 51.385,00 71.297,70
Checkpoints-Annual
Total earnings
Qtr’s taxable OASDI earnings
Total earnings for FIT
Total earnings for SIT/CIT
Total earnings for FUTA
314.142,04
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
Plant
Mixer Operator
PA
SEX
M F
x
S.S. ACCOUNT NO.
000-00-3481
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
NAME – LAST
FIRST
BONNO
Anthony
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$55,000 –$.30/M
20___
PAYDAY
HRS.
RATE
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
QTR. TOT.
YR. TOT.
$8 each pay
REGULAR EARNINGS
80
80
80
64
80
80
464
17,60
17,60
17,60
17,60
17,60
17,60
AMOUNT
OVERTIME EARNINGS
HRS. RATE
10.293,40
1.408,00
1.408,00
1.408,00
1.126,40
1.408,00
1.408,00
8.166,40
18.459,80
4
26,40
8
12
35,20
35,20
Checkpoint
OVERTIME RATE
CUMULATIVE
EARNINGS
AMOUNT
1.028,60
0.00
105,60
0.00
0.00
281,60
422,40
809,60
1.838,20
11.322,00
12.730,00
14.243,60
15.651,60
16.778,00
18.467,60
20.298,00
8.976,00
20.298,00
8.976,00
20.298,00
DEPARTMENT
OCCUPATION
WORKS IN (STATE)
Sales
Sales Manager
PA
SEX
M F
x
FICA
OASDI
701,96
87,30
93,84
87,30
69,84
104,76
113,48
556,52
1.258,48
HI
164,17
20,42
21,95
20,42
16,33
24,50
26,54
130,16
294,33
FIT
SIT
810,00
33,00
43,00
33,00
33,00
347,59
43,23
46,47
43,23
34,58
51,87
56,19
275,57
623,16
S.S. ACCOUNT NO.
000-00-8645
OTHER
FERGUSON
$
$
$
$
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
QTR. TOT.
YR. TOT.
CUMULATIVE
EARNINGS
HRS.
80
80
80
80
80
80
480
RATE
AMOUNT
HRS. RATE
23.125,00
2.250,00
2.250,00
2.250,00
2.250,00
2.250,00
2.250,00
13.500,00
36.625,00
Checkpoint
23.125,00
25.375,00
27.625,00
29.875,00
32.125,00
34.375,00
36.625,00
13.500,00
36.625,00
13.500,00
36.625,00
CIT
6,79
0,84
0,91
0,84
0,68
1,01
1,10
5,38
12,17
SIMPLE
440,51
54,78
58,89
54,78
43,82
65,74
71,22
349,23
789,74
OTHER
CK.
DEDUCTIONS NO.
216,80
8,00
24,50
8,00
24,50
8,00
8,00
81,00
297,80
AMOUNT
672
682
692
703
712
723
8.634,18
1.160,43
1.224,04
1.160,43
903,65
1.433,72
1.553,87
7.436,14
16.070,32
MIDDLE
James
58.500 /yr.
1.125,00
28,13
Claude
W/H
MARITAL
ALLOW.
STATUS
5
M
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
M
NET PAID
FIRST
WEEKLY RATE
$88,000 — $.30/M
REGULAR EARNINGS
STATUS
4
SUTA
NAME – LAST
HOURLY RATE
20___
17,60
26,40
MARITAL
ALLOW.
Checkpoint
SALARY
UNION DUES
Victor
W/H
DEDUCTIONS
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
MIDDLE
1.433,75
139,50
139,50
139,50
139,50
139,50
139,50
837,00
2.270,75
OTHER
HI
335,31
32,63
32,63
32,63
32,63
32,63
32,63
195,78
531,09
FIT
2.291,00
107,00
107,00
107,00
107,00
107,00
107,00
642,00
2.933,00
SIT
SUTA
709,94
69,08
69,08
69,08
69,08
69,08
69,08
414,48
1.124,42
Checkpoint
13,88
1,35
1,35
1,35
1,35
1,35
1,35
8,10
21,98
CIT
899,72
87,54
87,54
87,54
87,54
87,54
87,54
525,24
1.424,96
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
132,30
26,40
500,00
500,00
500,00
1.500,00
1.500,00
26,40
26,40
79,20
211,50
673
683
693
704
713
724
17.309,10
1.812,90
1.786,50
1.812,90
1.286,50
1.312,90
1.286,50
9.298,20
26.607,30
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Office
Executive Secretary
x
PA
000-00-4567
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
FORD
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$48,000–$.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
RATE
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
QTR. TOT.
AMOUNT
HRS. RATE
80
80
80
80
80
80
480
YR. TOT.
6.300,00
7.520,00
8.740,00
9.960,00
11.180,00
12.460,00
13.740,00
7.440,00
13.740,00
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
MARITAL
ALLOW.
STATUS
2
S
NET PAID
FICA
390,60
75,64
75,64
75,64
75,64
79,36
79,36
461,28
851,88
OTHER
HI
91,35
17,69
17,69
17,69
17,69
18,56
18,56
107,88
199,23
FIT
SIT
SUTA
639,00
85,00
193,41
37,45
37,45
37,45
37,45
39,30
39,30
228,40
421,81
3,78
0,73
0,73
0,73
0,73
0,77
0,77
4,46
8,24
CIT
SIMPLE
245,11
47,47
47,47
47,47
47,47
49,80
49,80
289,48
534,59
CK.
DEDUCTIONS NO.
AMOUNT
37,80
674
684
694
705
714
725
4.698,95
956,02
1.041,02
1.041,02
1.041,02
1.092,21
1.092,21
6.263,50
10.962,45
Checkpoint
13.740,00
7.440,00
Louise
W/H
DEDUCTIONS
OASDI
AMOUNT
6.300,00
1.220,00
1.220,00
1.220,00
1.220,00
1.280,00
1.280,00
7.440,00
13.740,00
YEAR-TO-DATE
1
CUMULATIVE
Catherine
2.643,33 /mo.
610,00
15,25
22,88
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Sales
Sales Representative
x
PA
000-00-9352
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
MANN
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$53,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
TR. TOT.
YR. TOT.
CUMULATIVE
80
80
80
80
80
80
480
RATE
AMOUNT
HRS. RATE
5.400,00
1.350,00
1.350,00
1.350,00
1.350,00
1.350,00
1.350,00
8.100,00
13.500,00
Checkpoint
5.400,00
6.750,00
8.100,00
9.450,00
10.800,00
12.150,00
13.500,00
8.100,00
13.500,00
8.100,00
13.500,00
Wilson
W/H
MARITAL
ALLOW.
STATUS
4
M
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
Dewey
2.925 /mo.
675,00
16,88
334,80
83,70
83,70
83,70
83,70
83,70
83,70
502,20
837,00
OTHER
HI
78,30
19,58
19,58
19,58
19,58
19,58
19,58
117,48
195,78
FIT
SIT
332,00
27,00
27,00
27,00
11,00
11,00
11,00
114,00
446,00
165,78
41,45
41,45
41,45
41,45
41,45
41,45
248,70
414,48
SUTA
3,24
0,81
0,81
0,81
0,81
0,81
0,81
4,86
8,10
CIT
210,10
52,52
52,52
52,52
52,52
52,52
52,52
315,12
525,22
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
31,50
250,00
250,00
250,00
750,00
750,00
Checkpoint
675
685
695
706
715
726
4.244,28
1.124,94
1.124,94
1.124,94
890,94
890,94
890,94
6.047,64
10.291,92
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
President
x
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 RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
RATE
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
80
80
80
80
80
80
480
TR. TOT.
AMOUNT
HRS. RATE
YR. TOT.
42.692,27
44.999,96
47.307,65
49.615,34
51.923,03
54.230,72
131.538,41
88.846,14
131.538,41
Checkpoint
WORKS IN (STATE)
SEX
Tyler
W/H
MARITAL
ALLOW.
STATUS
3
M
NET PAID
FICA
OTHER
HI
2.646,92
619,04
143,08
33,46
143,08
33,46
143,08
33,46
143,08
33,46
143,08
33,46
4.598,48 1.120,96
5.313,88 1.288,26
7.960,80 1.907,30
FIT
6.116,00
152,00
152,00
152,00
SIT
SUTA
1.310,65
70,85
70,85
70,85
70,85
70,85
2.373,35
2.727,60
4.038,25
25,62
1,38
1,38
1,38
1,38
1,38
46,38
53,28
78,90
CIT
1.661,03
89,79
89,79
89,79
89,79
89,79
3.007,81
3.456,76
5.117,79
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
202,50
676
686
696
707
716
727
27,00
700,00
700,00
700,00
2.100,00
2.100,00
27,00
27,00
81,00
283,50
30.110,51
1.817,13
1.790,13
1.817,13
1.242,13
1.269,13
65.433,71
73.369,36
103.479,87
Checkpoint
131.538,41
88.846,14
OCCUPATION
DEPARTMENT
Joseph
60.000 /yr.
1.153,85 bi-wkly $2,307.69
28,85
DEDUCTIONS
OASDI
AMOUNT
42.692,27
2.307,69
2.307,69
2.307,69
2.307,69
2.307,69
77.307,69
88.846,14
131.538,41
YEAR-TO-DATE
10/9
CUMULATIVE
EARNINGS
HRS.
1
MIDDLE
M F
Administrative
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Office
Time Clerk
x
PA
000-00-6337
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
RUSSELL
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$47,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/14
TR. TOT.
YR. TOT.
CUMULATIVE
80
80
78
78
78
152
546
RATE
AMOUNT
HRS. RATE
6.240,00
1.200,00
1.200,00
1.170,00
1.170,00
1.260,00
2.394,00
8.394,00
14.634,00
Checkpoint
6.240,00
7.440,00
8.640,00
9.810,00
10.980,00
12.240,00
14.634,00
8.394,00
14.634,00
8.394,00
14.634,00
Aloise
W/H
MARITAL
ALLOW.
STATUS
1
S
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
Virginia
2.600 /mo.
600,00
15,00
22,50
386,88
74,40
74,40
72,54
72,54
78,12
148,43
520,43
907,31
OTHER
HI
90,48
17,40
17,40
16,97
16,97
18,27
34,71
121,72
212,20
FIT
SIT
642,00
102,00
102,00
191,56
36,84
36,84
35,92
35,92
38,68
0,00
184,20
375,76
204,00
846,00
SUTA
3,74
0,72
0,72
0,70
0,70
0,76
1,44
5,04
8,78
CIT
SIMPLE
242,78
46,69
46,69
45,52
45,52
49,02
233,44
476,22
Checkpoint
CK.
DEDUCTIONS NO.
AMOUNT
31,50
14,10
14,10
14,70
42,90
74,40
677
687
697
708
717
4.651,06
921,95
907,85
998,35
984,25
1.075,15
2.194,72
7.082,27
11.733,33
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Plant
Electrician
x
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
PAYDAY
EARNINGS
HRS.
RATE
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
QTR. TOT.
OVERTIME RATE
CUMULATIVE
80
80
80
80
76
80
476
18,00
18,00
18,00
18,00
18,00
18,00
YR. TOT.
AMOUNT
13.287,50
1.440,00
1.440,00
1.440,00
1.440,00
1.368,00
1.440,00
8.568,00
21.855,50
HRS. RATE
8
3
7
27,00
27,00
27,00
Checkpoint
OCCUPATION
DEPARTMENT
1.397,80
0.00
216,00
0.00
0.00
81,00
189,00
486,00
1.883,80
14.685,30
16.125,30
17.781,30
19.221,30
20.661,30
22.110,30
23.739,30
9.054,00
23.739,30
9.054,00
23.739,30
WORKS IN (STATE)
SEX
18,00
27,00
MARITAL
ALLOW.
STATUS
4
M
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
Allen
W/H
910,49
89,28
102,67
89,28
89,28
89,84
101,00
561,35
1.471,84
OTHER
HI
212,94
20,88
24,01
20,88
20,88
21,01
23,62
131,28
344,22
FIT
1.070,00
35,00
35,00
SIT
SUTA
450,84
44,21
50,84
44,21
44,21
44,48
50,01
277,96
728,80
8,81
0,86
0,99
0,86
0,86
0,87
0,98
5,42
14,23
CIT
571,36
56,03
64,43
56,03
56,03
56,38
63,38
352,28
923,64
SIMPLE
200,00
200,00
200,00
600,00
600,00
CK.
DEDUCTIONS NO.
235,70
8,00
24,80
8,00
24,80
8,00
25,80
99,40
335,10
AMOUNT
678
688
698
709
718
728
11.225,16
1.185,74
1.388,26
1.185,74
1.003,94
1.028,42
1.164,21
6.956,31
18.181,47
Checkpoint
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Plant
Supervisor
x
PA
000-00-8832
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
SOKOWSKI
Thomas
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$80,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
QTR. TOT.
YR. TOT.
CUMULATIVE
80
80
80
80
80
80
480
RATE
AMOUNT
HRS. RATE
16.650,00
2.050,00
2.050,00
2.050,00
2.050,00
2.050,00
2.050,00
12.300,00
28.950,00
Checkpoint
16.650,00
18.700,00
20.750,00
22.800,00
24.850,00
26.900,00
28.950,00
12.300,00
28.950,00
12.300,00
28.950,00
1.025,00
25,63
MARITAL
ALLOW.
STATUS
2
M
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
James
W/H
1.032,30
127,10
127,10
127,10
127,10
127,10
127,10
762,60
1.794,90
OTHER
HI
241,43
29,73
29,73
29,73
29,73
29,73
29,73
178,38
419,81
FIT
2.002,00
140,00
140,00
SIT
511,16
62,94
62,94
62,94
62,94
62,94
62,94
377,64
888,80
SUTA
9,99
1,23
1,23
1,23
1,23
1,23
1,23
7,38
17,37
CIT
SIMPLE
647,80
79,76
79,76
79,76
79,76
79,76
79,76
478,56
1.126,36
Checkpoint
CK.
DEDUCTIONS NO.
AMOUNT
94,50
24,00
24,00
24,00
72,00
166,50
679
689
699
710
719
729
12.110,82
1.609,24
1.585,24
1.749,24
1.725,24
1.749,24
1.725,24
10.143,44
22.254,26
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Office
Accounting Trainee
PA
Student
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$39,000 — $.30/M
20___
OVERTIME RATE
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
RATE
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/20
5
12/4
6
12/18
QTR. TOT.
CUMULATIVE
72
72
72
72
72
71
431
14,00
14,00
14,00
14,00
14,00
14,00
YR. TOT.
AMOUNT
HRS. RATE
5.550,00
1.008,00
1.008,00
1.008,00
1.008,00
1.008,00
994,00
6.034,00
11.584,00
5.550,00
6.558,00
7.566,00
8.574,00
9.582,00
10.590,00
11.584,00
6.034,00
11.584,00
Checkpoint
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
STATUS
1
S
NET PAID
FICA
344,10
62,50
62,50
62,50
62,50
62,50
61,63
374,13
718,23
OTHER
HI
80,48
14,62
14,62
14,62
14,62
14,62
14,41
87,51
167,99
FIT
SIT
SUTA
409,00
78,00
170,38
30,95
30,95
30,95
30,95
30,95
30,52
185,27
355,65
3,33
0,60
0,60
0,60
0,60
0,60
0,60
3,60
6,93
CIT
SIMPLE
215,93
39,22
39,22
39,22
39,22
39,22
38,67
234,77
450,70
CK.
DEDUCTIONS NO.
AMOUNT
32,40
4.294,38
782,11
848,41
860,11
848,41
860,11
836,47
5.035,62
9.330,00
680
690
700
711
720
730
11,70
11,70
11,70
35,10
67,50
Checkpoint
11.584,00
6.034,00
MARITAL
DEDUCTIONS
OASDI
AMOUNT
14,00
21,00
W/H
ALLOW.
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Office
Programmer
x
PA
000-00-6741
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
WILLIAMS
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
$48,000 — $.30/M
20___
REGULAR EARNINGS
OVERTIME RATE
OVERTIME EARNINGS
PAYDAY
EARNINGS
HRS.
YEAR-TO-DATE
1
10/9
2
10/23
3
11/6
4
11/13
CUMULATIVE
80
80
79
136
RATE
AMOUNT
HRS. RATE
Virginia
W/H
MARITAL
ALLOW.
STATUS
0
S
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
Ruth
2.650 /mo.
611,54
15,29
22,94
OTHER
HI
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
5.733,33
15.993,33
5.733,33
15.993,33
355,47
991,59
83,12
231,89
FIT
1.606,00
123,00
123,00
121,00
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
314,98
37,55
37,55
37,08
63,84
6,16
0,73
0,73
0,72
1,25
399,19
47,59
47,59
46,99
80,90
59,40
176,02
491,00
3,43
9,59
223,07
622,26
28,80
88,20
14,40
14,40
AMOUNT
681
691
701
702
7.089,38
920,65
906,25
909,66
1.759,86
5
6
QTR. TOT.
YR. TOT.
375
Checkpoint
5.733,33
15.993,33
Checkpoint
4.496,42
11.585,80
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Office
Programmer
X
PA
000-00-1587
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
Woods
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
OVERTIME RATE
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
EARNINGS
HRS.
RATE
AMOUNT
HRS. RATE
Anne
W/H
MARITAL
ALLOW.
STATUS
1
S
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
Beth
2.600
600,00
15,00
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.
72
80
152
1.080,00
1.200,00
2.280,00
2.280,00
YR. TOT.
1.080,00
2.280,00
2.280,00
2.280,00
Checkpoint
15,66
17,40
33,06
33,06
33,16
36,84
70,00
70,00
0,65
0,72
1,37
1,37
WORKS IN (STATE)
SEX
42,02
46,69
88,71
88,71
721
731
14,10
14,10
14,10
921,55
1.009,85
1.931,40
1.931,40
Checkpoint
2.280,00
2.280,00
OCCUPATION
DEPARTMENT
66,96
74,40
141,36
141,36
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
Sales
Field Sales Representative
X
PA
000-00-6057
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
Young
Paul
$2730/Month
$
630,00
$
15,75
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
OVERTIME RATE
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
EARNINGS
HRS.
RATE
AMOUNT
HRS. RATE
MARITAL
ALLOW.
STATUS
1
S
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
Winston
W/H
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
YEAR-TO-DATE
1
2
3
4
5
6
12/18
QTR. TOT.
YR. TOT.
80
80
1.260,00
1.260,00
1.260,00
Checkpoint
1.260,00
1.260,00
1.260,00
1.260,00
1.260,00
78,12
78,12
78,12
18,27
18,27
18,27
38,68
38,68
38,68
0,76
0,76
0,76
49,02
49,02
49,02
Checkpoint
14,70
14,70
14,70
732
1.060,45
1.060,45
1.060,45
OCCUPATION
DEPARTMENT
WORKS IN (STATE)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
$
$
$
$
SALARY
UNION DUES
OTHER
WEEKLY RATE
HOURLY RATE
OVERTIME RATE
20___
REGULAR EARNINGS
OVERTIME EARNINGS
PAYDAY
CUMULATIVE
EARNINGS
HRS.
RATE
AMOUNT
HRS. RATE
MARITAL
STATUS
DEDUCTIONS
NET PAID
FICA
OASDI
AMOUNT
W/H
ALLOW.
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)
SEX
S.S. ACCOUNT NO.
NAME – LAST
FIRST
MIDDLE
M F
OTHER DEDUCTIONS INFORMATION
GROUP INSURANCE
UNION DUES
$
$
$
$
SALARY
OTHER
WEEKLY RATE
HOURLY RATE
OVERTIME RATE
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
MARITAL
ALLOW.
STATUS
DEDUCTIONS
NET PAID
FICA
OASDI
OTHER
HI
FIT
SIT
SUTA
CIT
SIMPLE
CK.
DEDUCTIONS NO.
AMOUNT
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
