Argoel

profileletdue
122_u8part6_payroll_projectdavidbumford.xls
Home>Business & Finance homework help>Accounting homework help>Argoel

Excel Instructions

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_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.

Journal

JOURNAL Page 41
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Oct. 9 Payroll Cash 12 11,097.25
Cash 11 11,097.25
9 Administrative Salaries 51 2,307.69
Office Salaries 52 3,353.08
Sales Salaries 53 3,600.00
Plant Wages 54 4,902.00
FICA Taxes Payable - OASDI 20.1 878.09
FICA Taxes Payable - HI 20.2 205.37
Employees FIT Payable 24 965.00
Employees SIT Payable 25 434.82
Employees SUTA Payable 25.1 9.94
Employees CIT Payable 26 556.30
Union Dues Payable 28 16.00
Payroll Cash 12 11,097.25
9 Payroll Taxes 56 1,231.14
FICA Taxes Payable - OASDI 20.1 878.09
FICA Taxes Payable - HI 20.2 205.36
FUTA Taxes Payable 21 19.68
SUTA Taxes Payable - Employer 22 128.01
JOURNAL Page 42
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Oct. 20 Employees SIT Payables 25 434.82
Cash 11 434.82
23 Payroll Cash 12 11,173.89
Cash 11 11,173.89
23 Administrative Salaries 51 2,307.69
Office Salaries 52 3,353.08
Sales Salaries 53 3,600.00
Plant Wages 54 5,223.92
FICA Taxes Payable - OASDI 20.1 898.05
FICA Taxes Payable - HI 20.2 210.04
Employees FIT Payable 24 997.00
Employees SIT Payable 25 444.70
Employees SUTA Payable 25.1 10.16
Employees CIT Payable 26 568.95
Union Dues Payable 28 16.00
Group Insurance Premiums Collected 27 165.90
Payroll Cash 12 11,173.89
23 Payroll Taxes 56 1,241.26
FICA Taxes Payable - OASDI 20.1 898.05
FICA Taxes Payable - HI 20.2 210.04
FUTA Taxes Payable 21 5.16
SUTA Taxes Payable - Employer 22 128.01
JOURNAL Page 43
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Nov 4 Employees SIT Payable 25 444.70
Cash 11 444.70
6 Union Dues Payable 28 32.00
Cash 11 32.00
6 Payroll Cash 12 10,937.71
Cash 11 10,937.71
6 Administation Salaries 51 2,307.69
Office Salaries 52 3,320.79
Sales Salaries 53 3,600.00
Plant Wages 54 4,902.00
FICA Taxes Payable -OASDI 20.1 876.09
FICA Taxes Payable -HI 20.2 204.90
Employees FIT Payable 24 1,097.00
Employees SIT Payable 25 433.83
Employees SUTA Payable 25.1 9.92
Employees CIT Payable 26 555.03
Union Dues Payable 27 16.00
Payroll Cash 12 10,937.71
JOURNAL Page 44
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Nov 6 Payroll Taxes 56 1,157.26
FICA Taxable - OASDI 20.1 876.09
FICA Taxable - HI 20.2 204.90
FUTA Taxes Payable 21 2.22
SUTA Taxes Payable 22 74.05
13 Payroll Cash - R. Williams Final Pay 12 1,418.87
Cash 11 1,418.87
R. Williams Final Pay Deductions
13 Office Salaries 52 2,079.32
13 FICA Taxes Payable - OASDI 20.1 128.92
FICA Taxes Payable - HI 20.2 30.15
Employees FIT Payable 24 340.00
Employees SIT Payable 25 63.84
Employees SUTA Payable 25.1 1.46
Employees CIT Payable 26 81.68
Group Insurance Premiums Collected 27 14.40
Payroll Cash 12 1,418.87
13 Payroll Taxes 56 159.07
FICA Taxes Payable - OASDI 20.1 128.92
FICA Taxes Payable - HI 20.2 30.15
FUTA Taxes Payable 21 0.00
SUTA Taxes Payable 22 0.00
15 Employees CIT Payable 26 1,125.25
Cash 1,125.25
15 Employee FIT Payable 24 1,962.00
Cash 11 1,962.00
15 Employee SIT Payable 25 497.67
Cash 11 497.67
15 FICA Taxes Payable - OASDI (Oct) ER,EE 20.1 3,552.28
FICA Taxes Payable - HI (Oct) ER,EE 20.2 830.82
Cash 11 4,383.10
20 Payroll Cash 12 8,281.28
Cash 11 8,281.28
JOURNAL Page 45
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Nov. 20 Administrative Salaries 51 2,307.69
Office Salaries 52 2,112.94
Sales Salaries 53 3,600.00
Plant Wages 54 4,619.60
FICA Taxes Payable - OASDI 20.1 783.70
FICA Taxes Payable - HI 20.2 183.30
Employees FIT Payable 24 681.00
Employees SIT Payable 25 388.08
Employees SUTA Payable 25.1 8.87
Employees CIT Payable 26 496.50
Union Dues Payable 28 16.00
Group Insurance Premiums Collected 27 151.50
Simple Contributions Payable 29 1,650.00
Payroll Cash 12 8,281.28
20 Payroll Taxes 56 994.48
FICA Taxes Payable - OASDI 20.1 783.70
FICA Taxes Payable - HI 20.2 183.30
FUTA Taxas Payable 21 0.00
SUTA Taxas Payable 22 27.48
JOURNAL Page 46
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Dec. 3 Employees SIT Payable 25 388.08
Cash 11 388.08
4 Payroll Cash 12 9,771.04
Cash 11 9,771.04
4 Administation Salaries 51 2,307.69
Office Salaries 52 3,330.00
Sales Salaries 53 3,600.00
Plant Wages 54 5,149.84
FICA Taxes Payable -OASDI 20.1 894.73
FICA Taxes Payable -HI 20.2 209.27
Employees FIT Payable 24 870.00
Employees SIT Payable 25 443.06
Employees SUTA Payable 25.1 10.13
Employees CIT Payable 26 566.86
Union Dues Payable 28 16.00
Payroll Cash 12 9,771.04
4 Payroll Taxes 56 1,194.45
FICA Taxable - OASDI 20.1 894.73
FICA Taxable - HI 20.2 209.27
FUTA Taxes Payable 21 66.96
SUTA Taxes Payable 22 23.49
9 Union Dues Payable 28 32.00
Cash 11 32.00
14 Payroll Cash 12 1,306.44
Cash 11 1,306.44
14 Office Salaries 52 1,425.16
FICA Taxes Payable -OASDI 20.1 88.36
FICA Taxes Payable -HI 20.2 20.66
Group Insurance Premiums Collected 27 8.70
Employees SUTA Payable 25.1 1.00
14 Payroll Taxes 52 118.72
FICA Taxes Payable -OASDI 20.1 88.36
FICA Taxes Payable -HI 20.2 20.66
Group Insurance Premiums Collected 27 8.70
Employees SUTA Payable 25.1 1.00
JOURNAL Page 47
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Dec 15 FICA Taxes Payable - OASDI ER,EE 20.1 3,577.42
FICA Taxes Payable - HI ER,EE 20.2 836.69
Cash 11 4,414.11
15 Employees CIT Payable 24 1,133.21
Cash 11 1,133.21
15 Employee FIT Payable 25 2,118.00
Cash 11 2,118.00
18 Payroll Cash 12 37,381.42
Cash 11 37,381.42
18 Administrative Salaries 51 62,307.69
Office Salaries 52 2,692.50
Sales Salaries 53 4,407.70
Plant Wages 54 5,514.60
FICA Taxes Payable - OASDI 20.1 4,469.21
FICA Taxes Payable - HI 20.2 1,086.39
Employees FIT Payable 24 21,554.20
Employees SIT Payable 25 2,300.14
Employees SUTA Payable 25.1 52.46
Employees CIT Payable 26 2,942.97
Union Dues Payable 28 18.00
Group Insurance Premiums Collected 27 167.70
Simple Contributions Payable 29 4,950.00
Payroll Cash 12 37,381.42
18 Payroll Taxes 56 5,749.92
FICA Taxable - OASDI 20.1 4,469.21
FICA Taxable - HI 20.2 1,086.39
FUTA Taxes Payable 21 157.49
SUTA Taxes Payable 22 36.83
JOURNAL Page 48
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Jan 4 Employees SIT Payable 25 2,300.14
Cash 11 2,300.14
8 Union Dues Payable 28 18.00
Cash 11 18.00
JOURNAL Page 49
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
JOURNAL Page 50
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20--
Total debits and credits (calculated automatically): 270,729.95 267,817.07
Your debits and credits should be equal after each journal entry is complete
Cumulative Journal Checkpoint Through Month Ending
53,825.81 October 31, 20-- December 31, 20--
November 30, 20-- January 31, 20--

General Ledger

GENERAL LEDGER
Checkpoints
ACCOUNT: CASH ACCOUNT NO. 11 Debit Credit
Balance Balance
POST. BALANCE Oct. 31, 20-- 177,140.37
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Nov. 30, 20--
20-- Dec. 31, 20--
Oct. 1 Balance a 199,846.33
9 J41 11,097.25 188,749.08
20 J42 434.82 188,314.26
23 J42 11,173.89 177,140.37
Nov. 4 J43 444.70 176,695.67
6 J42 32.00 176,663.67
6 J43 10,937.71 165,725.96
13 J44 1,418.87 164,307.09
15 J44 1,125.25 163,181.84
15 J44 1,962.00 161,219.84
15 J44 497.67 160,722.17
15 J44 4,383.10 156,339.07
20 J44 8,281.28 148,057.79
Dec 3 J46 388.08 147,669.71
4 J46 9,771.04 137,898.67
9 J46 32.00 137,866.67
15 J46 1,306.44 136,560.23
18 J47 37,381.42 99,178.81
Jan 4 J47 2,300.14 96,878.67
8 J47 18.00 96,860.67
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: PAYROLL CASH ACCOUNT NO. 12 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00
20-- Nov. 30, 20-- 0.00
Oct. 9 J41 11,097.25 11,097.25 Dec. 31, 20-- 0.00
9 J41 11,097.25 0.00
20 J42 11,173.89 11,173.89
23 J42 11,173.89 0.00
Nov 6 J43 10,937.71 10,937.71
6 J43 10,937.71 0.00
13 Williams Final Pay J44 1,418.87 1,418.87
13 J44 1,418.87 0.00
20 J44 8,281.28 8,281.28
20 J45 8,281.28 0.00
Dec 4 J45 9,771.04 9,771.04
4 J45 9,771.04 0.00
15 Russell Estate Final Pay J46 1,306.44 1,306.44
15 J46 1,306.44 0.00
18 J47 37,381.42 37,381.42
18 J47 37,381.42 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
ACCOUNT: FICA TAXES PAYABLE - OASDI ACCOUNT NO. 20.1 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 3,552.28
20-- Nov. 30, 20-- 3,577.41
Oct. 9 J41 878.09 878.09 Dec. 31, 20-- 10,904.60
9 J41 878.09 1,756.18
23 J42 898.05 2,654.23
23 J42 898.05 3,552.28
Nov 6 J43 876.09 4,428.37
6 J44 876.09 5,304.46
13 J44 128.92 5,433.38
13 J44 128.92 5,562.30
15 J44 3,552.28 2,010.02
20 J45 783.70 2,793.72
20 J45 783.70 3,577.42
Dec 4 J46 894.73 4,472.15
4 J46 894.73 5,366.88
14 J46 88.36 5,455.24
14 J46 88.36 5,543.60
15 J47 3,577.42 1,966.18
18 J47 4,469.21 6,435.39
18 J47 4,469.21 10,904.60
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
ACCOUNT: FICA TAXES PAYABLE - HI ACCOUNT NO. 20.2 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 830.80
20-- Nov. 30, 20-- 836.67
Oct. 9 J41 205.37 205.37 Dec. 31, 20--
9 J41 205.36 410.73
23 J42 210.04 620.77
23 J42 210.04 830.81
Nov 6 J43 204.90 1,035.71
6 J44 204.90 1,240.61
13 J44 30.15 1,270.76
13 J44 30.15 1,300.91
16 J44 830.82 470.09
20 J45 183.30 653.39
20 J45 183.30 836.69
Dec 4 J46 209.27 1,045.96
4 J46 209.27 1,255.23
14 J46 20.66 1,275.89
15 J47 836.69 439.20
18 J47 1,086.39 1,525.59
18 J47 1,086.39 2,611.98
0.00
ACCOUNT: FUTA TAXES PAYABLE ACCOUNT NO. 21 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 417.78
20-- Nov. 30, 20-- 420.00
Oct. 1 Balance a 392.94 Dec. 31, 20--
9 J41 19.68 412.62
23 J42 5.16 417.78
Nov 6 J44 2.22 420.00
Dec 4 J46 66.96 486.96
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: SUTA TAXES PAYABLE - EMPLOYER ACCOUNT NO. 22 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 256.02
20-- Nov. 30, 20-- 357.55
Oct. 9 J41 128.01 128.01 Dec. 31, 20--
23 J42 128.01 256.02
Nov. 6 J44 74.05 330.07
20 J45 27.48 357.55
Dec 4 J46 23.49 381.04
15 J47 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: EMPLOYEES FIT PAYABLE ACCOUNT NO. 24 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 1,962.00
20-- Nov. 30, 20-- 2,118.00
Oct. 9 J41 965.00 965.00 Dec. 31, 20--
23 J42 997.00 1,962.00
Nov. 6 J43 1,097.00 3,059.00
13 J44 340.00 3,399.00
16 J44 1,962.00 1,437.00
20 J45 681.00 2,118.00
Dec 4 J46 870.00 2,988.00
15 J47 2,118.00 870.00
18 J47 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: EMPLOYEES SIT PAYABLE ACCOUNT NO. 25 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 444.70
20-- Nov. 30, 20-- 388.08
Oct. 9 J41 434.82 434.82 Dec. 31, 20--
20 J42 434.82 0.00
23 J42 444.70 444.70
Nov. 4 J43 444.70 0.00
6 J43 433.83 433.83
13 J44 63.84 497.67
15 J44 497.67 0.00
20 J46 388.08 388.08
Dec 3 J46 388.08 0.00
4 J46 443.06 443.06
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: EMPLOYEES SUTA PAYABLE ACCOUNT NO. 25.1 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 20.10
20-- Nov. 30, 20-- 40.35
Oct. 9 J41 9.94 9.94 Dec. 31, 20--
23 J42 10.16 20.10
Nov. 6 J43 9.92 30.02
13 J44 1.46 31.48
20 J45 8.87 40.35
Dec 4 J46 23.49 63.84
14 J46 1.00 64.84
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: EMPLOYEES CIT PAYABLE ACCOUNT NO. 26 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 1,125.25
20-- Nov. 30, 20-- 1,133.21
Oct. 9 J41 556.30 556.30 Dec. 31, 20--
23 J41 568.95 1,125.25
Nov. 6 J43 555.03 1,680.28
13 J44 81.68 1,761.96
15 J44 1,125.25 636.71
20 J45 496.50 1,133.21
Dec 4 J46 566.86 1,700.07
15 J47 1,133.21 566.86
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED ACCOUNT NO. 27 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 165.90
20-- Nov. 30, 20-- 331.80
Oct. 23 J42 165.90 165.90 Dec. 31, 20--
Nov. 13 J44 14.40 180.30
20 J45 151.50 331.80
Dec 14 J46 8.70 340.50
18 J47 167.70 508.20
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
ACCOUNT: UNION DUES PAYABLE ACCOUNT NO. 28 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 32.00
20-- Nov. 30, 20-- 32.00
Oct. 9 J41 16.00 16.00 Dec. 31, 20-- 34.00
23 J42 16.00 32.00
Nov. 4 J43 32.00 0.00
6 J43 16.00 16.00
20 J45 16.00 32.00
Dec 4 J46 16.00 48.00
9 J46 32.00 16.00
18 J47 18.00 34.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE ACCOUNT NO. 29 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00
20-- Nov. 30, 20-- 1,650.00
Nov. 20 J45 1,650.00 1,650.00 Dec. 31, 20-- 8,250.00
Dec 4 J46 1,650.00 3,300.00
Dec 18 J47 4,950.00 8,250.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
ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT NO. 51 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 47,307.65
20-- Nov. 30, 20-- 51,923.03
Oct. 1 Balance a 42,692.27 Dec. 31, 20-- 116,538.41
9 J41 2,307.69 44,999.96
23 J42 2,307.69 47,307.65
Nov 6 J43 2,307.69 49,615.34
20 J45 2,307.69 51,923.03
Dec 4 J45 2,307.69 54,230.72
18 J47 62,307.69 116,538.41
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: OFFICE SALARIES ACCOUNT NO. 52 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 35,056.16
20-- Nov. 30, 20-- 42,569.21
Oct. 1 Balance a 28,350.00 Dec. 31, 20-- 50,016.87
9 J41 3,353.08 31,703.08
23 J42 3,353.08 35,056.16
Nov. 6 J43 3,320.79 38,376.95
13 J44 2,079.32 40,456.27
20 J45 2,112.94 42,569.21
Dec 4 J46 3,330.00 45,899.21
14 J46 1,425.16 47,324.37
18 J47 2,692.50 50,016.87
0.00
0.00
0.00
0.00
0.00
ACCOUNT: SALES SALARIES ACCOUNT NO. 53 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 35,725.00
20-- Nov. 30, 20-- 42,925.00
Oct. 1 Balance a 28,525.00 Dec. 31, 20-- 50,932.70
9 J41 3,600.00 32,125.00
23 J42 3,600.00 35,725.00
Nov. 6 J43 3,600.00 39,325.00
20 J45 3,600.00 42,925.00
Dec 4 J45 3,600.00 46,525.00
18 J47 4,407.70 50,932.70
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
ACCOUNT: PLANT WAGES ACCOUNT NO. 54 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 52,783.22
20-- Nov. 30, 20-- 62,304.82
Oct. 1 Balance a 42,657.30 Dec. 31, 20--
9 J41 4,902.00 47,559.30
23 J42 5,223.92 52,783.22
Nov. 6 J43 4,902.00 57,685.22
20 J45 4,619.60 62,304.82
Dec 4 J46 5,149.84 67,454.66
18 J47 5,514.60 72,969.26
0.00
0.00
0.00
0.00
0.00
ACCOUNT: PAYROLL TAXES ACCOUNT NO. 56 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 16,485.62
20-- Nov. 30, 20--
Oct. 1 Balance a 14,013.23 Dec. 31, 20--
9 J41 1,231.14 15,244.37
23 J42 1,241.26 16,485.63
Nov. 6 J44 1,157.26 17,642.89
13 J44 159.07 17,801.96
20 J45 994.48 18,796.44
Dec 4 J46 1,194.45 19,990.89
15 J46 118.72 20,109.61
J47 0.00
0.00
0.00
0.00
0.00
0.00
0.00

Payroll Register

PAYROLL REGISTER GLO-BRITE PAINT COMPANY
Marital Status No. W/H Allow. Time Record Regular Earnings Overtime Earnings Total Earnings Deductions Net Paid Taxable Earnings Labor Cost Distribution
NAME S M T W T F S S M T W T F S Hrs. Rate Per Hour Amount Hrs. Rate Per Hour Amount OASDI HI FIT SIT SUTA CIT Group Ins. Union Dues SIMPLE Ck. No. Amount OASDI HI FUTA SUTA Admin. Office Sales Plant
Payday, October 9, 20-- For Period Ending October 3, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 8 8 80 17.65 1,412.00 1,412.00 87.54 20.47 49.00 43.35 0.99 55.46 8.00 672 1,147.19 1,412.00 1,412.00 1,412.00 Total earnings 14,162.77
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 143.00 69.08 1.58 88.38 673 1,775.83 2,250.00 2,250.00 2,250.00 Net paid 11,097.25
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 62.00 27.63 0.63 35.35 674 705.54 900.00 900.00 700.00 900.00 900.00
Mann, D. M 4 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 43.00 41.45 0.95 53.03 675 1,108.29 1,350.00 1,350.00 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 197.00 70.85 1.62 90.65 676 1,771.03 2,307.69 2,307.69 2,307.69
Russell, V. S 1 8 8 8 8 8 8 8 8 8 8 80 690.00 690.00 42.78 10.01 51.00 21.18 0.48 27.10 677 537.45 690.00 690.00 690.00 690.00 690.00
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 53.00 44.21 1.01 56.56 8.00 678 1,167.06 1,440.00 1,440.00 1,440.00
Sokowski, T. M 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 180.00 62.94 1.44 80.52 679 1,568.27 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 32.00 16.58 0.38 21.21 680 428.52 540.00 540.00 540.00 540.00 540.00
Williams, R. S 0 8 8 D 8 8 8 8 8 8 8 80 1,223.08 1,223.08 75.83 17.73 155.00 37.55 0.86 48.04 681 888.07 1,223.08 1,223.08 1,223.08
0.00 0.00
0.00 0.00
0.00 0.00
TOTALS 14,162.77 14,162.77 878.09 205.37 965.00 434.82 9.94 556.30 0.00 16.00 0.00 11,097.25 14,162.77 14,162.77 3,280.00 3,480.00 2,307.69 3,353.08 3,600.00 4,902.00
Payday, October 23, 20-- For Period Ending October 17, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 4 8 8 8 8 8 80 17.65 1,412.00 4 26.48 105.92 1,517.92 94.11 22.01 60.00 46.60 1.06 59.62 16.50 8.00 682 1,210.02 1,517.92 1,517.92 1,517.92 Total earnings 14,484.69
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 143.00 69.08 1.58 88.38 26.40 683 1,749.43 2,250.00 2,250.00 2,250.00 Net paid 11,173.89
Ford, C. S 2 4 8 8 8 8 8 8 8 8 8 76 900.00 900.00 55.80 13.05 62.00 27.63 0.63 35.35 10.50 684 695.04 900.00 900.00 900.00 900.00
Mann, D. M 4 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 43.00 41.45 0.95 53.03 15.90 685 1,092.39 1,350.00 1,350.00 250.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 197.00 70.85 1.62 90.65 27.00 686 1,744.03 2,307.69 2,307.69 2,307.69
Russell, V. S 1 8 8 8 8 8 8 8 8 8 8 80 690.00 690.00 42.78 10.01 51.00 21.18 0.48 27.10 8.10 687 529.35 690.00 690.00 70.00 690.00 690.00
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 8 27.00 216.00 1,656.00 102.67 24.01 75.00 50.84 1.16 65.05 16.80 8.00 688 1,312.47 1,656.00 1,656.00 1,656.00
Sokowski, T. M 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 180.00 62.94 1.44 80.52 24.00 689 1,544.27 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 32.00 16.58 0.38 21.21 6.30 690 422.22 540.00 540.00 540.00 540.00 540.00
Williams, R. S 0 8 8 8 8 8 8 8 8 8 8 80 1,223.08 1,223.08 75.83 17.73 155.00 37.55 0.86 48.04 14.40 691 873.67 1,223.08 1,223.08 1,223.08
0.00 0.00
0.00 0.00
0.00 0.00
TOTALS 14,162.77 321.92 14,484.69 898.05 210.04 998.00 444.70 10.16 568.95 165.90 16.00 0.00 11,172.89 14,484.69 14,484.69 860.00 3,480.00 2,307.69 3,353.08 3,600.00 5,223.92
Payday, November 6, 20-- For Period Ending October 31, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 8 8 80 17.65 1,412.00 1,412.00 87.54 20.47 49.00 43.35 0.99 55.46 8.00 692 1,147.19 1,412.00 1,412.00 1,412.00 Total earnings 14,130.48
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 143.00 69.08 1.58 88.38 693 1,775.83 2,250.00 2,250.00 2,250.00 Net paid 10,937.71
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 62.00 27.63 0.63 35.35 694 705.54 900.00 900.00 400.00 900.00
Mann, D. M 0 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 120.00 41.45 0.95 53.03 695 1,031.29 1,350.00 1,350.00 400.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 197.00 70.85 1.62 90.65 696 1,771.03 2,307.69 2,307.69 2,307.69
Russell, V. S 2 8 8 8 8 6 8 8 8 8 8 78 8.63 672.94 672.94 41.72 9.76 29.00 20.66 0.47 26.43 697 544.90 672.94 672.94 672.94 672.94
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 53.00 44.21 1.01 56.56 8.00 698 1,167.06 1,440.00 1,440.00 1,440.00
Sokowski, T. S 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 260.00 62.94 1.44 80.52 699 1,488.27 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 32.00 16.58 0.38 21.21 700 428.52 540.00 540.00 370.00 540.00 540.00
Williams, R. S 0 8 8 8 7 8 8 8 8 8 8 79 15.29 1,207.85 1,207.85 74.89 17.51 152.00 37.08 0.85 47.44 701 878.08 1,207.85 1,207.85 1,207.85
0.00 0.00
0.00 0.00
0.00 0.00
TOTALS 14,130.48 0.00 14,130.48 876.09 204.90 1,097.00 433.83 9.92 555.03 0.00 16.00 0.00 10,937.71 14,130.48 14,130.48 370.00 2,012.94 2,307.69 3,320.79 3,600.00 4,902.00
Payday, November 13, 20-- For Period Ending November 14, 20-- Checkpoints
Williams, R. + Dismissal Pay S 0 6 8 7 7 6 D D 8 6 8 56 15.29 2,079.32 2,079.32 128.92 30.15 340.00 63.84 1.46 81.68 14.40 702 1,418.87 2,079.32 2,079.32 2,079.32 Total earnings 2,079.32
0.00 0.00 Net paid 1,418.87
TOTALS 2,079.32 0.00 2,079.32 128.92 30.15 340.00 63.84 1.46 81.68 14.40 0.00 0.00 1,418.87 2,079.32 2,079.32 0.00 0.00 0.00 2,079.32 0.00 0.00
Payday, November 20, 20-- For Period Ending November 14, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 D D 8 8 8 64 17.65 1,129.60 1,129.60 70.04 16.38 22.00 34.68 0.79 44.37 16.50 8.00 703 916.84 1,129.60 1,129.60 1,129.60 Total earnings 12,640.23
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 68.00 69.08 1.58 88.38 26.40 500.00 704 1,324.43 2,250.00 2,250.00 2,250.00 Net paid 8,281.28
Ford, C. S 2 8 8 8 8 8 8 8 8 8 8 80 900.00 900.00 55.80 13.05 62.00 27.63 0.63 35.35 10.50 705 695.04 900.00 900.00 900.00
Mann, D. M 0 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 83.00 41.45 0.95 53.03 15.90 250.00 706 802.39 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 143.08 33.46 92.00 70.85 1.62 90.65 27.00 700.00 707 1,149.03 2,307.69 2,307.69 2,307.69
Russell, V. S 2 6 8 8 8 8 8 8 8 8 8 78 8.63 672.94 672.94 41.72 9.76 29.00 20.66 0.47 26.43 8.10 708 536.80 672.94 672.94 207.06 672.94
Ryan, N. M 4 8 8 8 8 8 8 8 8 8 8 80 18.00 1,440.00 1,440.00 89.28 20.88 33.00 44.21 1.01 56.56 16.80 8.00 200.00 709 970.26 1,440.00 1,440.00 1,440.00
Sokowski, T. S 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 260.00 62.94 1.44 80.52 24.00 710 1,464.27 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 8 4 8 8 8 8 4 72 7.50 540.00 540.00 33.48 7.83 32.00 16.58 0.38 21.21 6.30 711 422.22 540.00 540.00 540.00 540.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00
0.00 0.00
TOTALS 12,640.23 0.00 12,640.23 783.70 183.30 681.00 388.08 8.87 496.50 151.50 16.00 1,650.00 8,281.28 12,640.23 12,640.23 0.00 747.06 2,307.69 2,112.94 3,600.00 4,619.60
Payday, December 4, 20-- For Period Ending November 28, 20-- Checkpoints
Bonno, A. M 4 8 8 8 8 8 8 8 8 8 P 8 80 17.65 1,412.00 8 35.30 282.40 1,694.40 105.05 24.57 80.00 52.02 1.19 66.56 8.00 712 1,357.01 1,694.40 1,694.40 1,623.84 Total earnings 14,431.09
Ferguson, J. M 5 8 8 8 8 8 8 8 8 A 8 80 2,250.00 2,250.00 139.50 32.63 68.00 69.08 1.58 88.38 500.00 713 1,350.83 2,250.00 2,250.00 2,250.00 Net paid 9,771.04
Ford, C. S 2 8 8 8 8 8 8 8 8 I 8 80 960.00 960.00 59.52 13.92 71.00 29.47 0.67 37.71 714 747.71 960.00 960.00 960.00
Mann, D. M 0 8 8 8 8 8 8 8 8 D 8 80 1,350.00 1,350.00 83.70 19.58 83.00 41.45 0.95 53.03 250.00 715 818.29 1,350.00 1,350.00 1,350.00
O'Neill, J. M 3 8 8 8 8 8 8 8 8 H 8 80 2,307.69 2,307.69 143.08 33.46 92.00 70.85 1.62 90.65 700.00 716 1,176.03 2,307.69 2,307.69 2,307.69
Russell, V. S 2 8 8 8 8 8 8 8 8 O 8 80 750.00 750.00 46.50 10.88 38.00 23.03 0.53 29.46 717 601.60 750.00 750.00 750.00
Ryan, N. M 4 9 8 8 4 8 9 10 8 L 8 76 18.00 1,368.00 3 27.00 81.00 1,449.00 89.84 21.01 36.00 44.48 1.01 56.92 8.00 200.00 718 991.74 1,449.00 1,449.00 1,476.00
Sokowski, T. S 2 8 8 8 8 8 8 8 8 I 8 80 2,050.00 2,050.00 127.10 29.73 260.00 62.94 1.44 80.52 719 1,488.27 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 8 4 8 8 8 8 D 4 72 540.00 540.00 33.48 7.83 32.00 16.58 0.38 21.21 720 428.52 540.00 540.00 540.00 540.00
Woods, B. S 1 0 8 8 8 8 8 8 8 A 8 72 1,080.00 1,080.00 66.96 15.66 110.00 33.16 0.76 42.42 721 811.04 1,080.00 1,080.00 1,080.00 1,080.00 1,080.00
Y 0.00 0.00
0.00 0.00
TOTALS 14,067.69 363.40 14,431.09 894.73 209.27 870.00 443.06 10.13 566.86 0.00 16.00 1,650.00 9,771.04 14,431.09 14,431.09 1,080.00 1,620.00 2,307.69 3,330.00 3,600.00 5,149.84
Payday, December 14, 20-- For Period Ending December 12, 20-- Checkpoints
Russell, V. S 2 8 8 8 8 8 8 8 8 8 D 72 9.38 1,425.16 1,425.16 88.36 20.66 1.00 8.70 722 1,306.44 1,425.16 Total earnings 1,425.16
Payable to the Estate of Virginia A. Russell 0.00 0.00 Net paid 1,306.44
TOTALS 1,425.16 0.00 1,425.16 88.36 20.66 0.00 0.00 1.00 0.00 8.70 0.00 0.00 1,306.44 0.00 0.00 0.00 0.00 0.00 1,425.16 0.00 0.00
Payday, December 18, 20-- For Period Ending December 12, 20-- Checkpoints
Bonno, A. M 5 4 8 8 8 8 8 8 8 8 8 8 8 80 17.65 1,412.00 12 35.30 423.60 1,835.60 113.81 26.62 81.00 56.35 1.28 72.10 16.50 9.00 723 1,458.94 1,835.60 1,835.60 1,835.60 Total earnings
Ferguson, J. M 5 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 68.00 69.08 1.58 88.38 26.40 500.00 724 1,324.43 2,250.00 2,250.00 2,250.00 Net paid
Ford, C. S 2 8 8 8 8 8 4 8 8 8 8 76 960.00 960.00 59.52 13.92 71.00 29.47 0.67 37.71 11.10 725 736.61 960.00 960.00 960.00
Mann, D. M 0 8 8 8 8 8 8 8 8 8 8 80 1,350.00 1,350.00 83.70 19.58 83.00 41.45 0.95 53.03 15.90 250.00 726 802.39 1,350.00 1,350.00 1,350.00
O'Neill, J. M 4 8 8 8 8 8 8 8 8 8 8 80 62,307.69 62,307.69 3,687.08 903.46 20,712.00 1,912.85 43.62 2,447.45 27.00 4,000.00 727 28,574.23 3,687.08 62,307.69 62,307.69
Ryan, N. M 4 8 9 9 9 9 10 8 8 9 8 80 18.00 1,440.00 7 27.00 189.00 1,629.00 101.00 23.62 50.01 1.14 63.99 16.80 9.00 200.00 728 1,163.44 1,629.00 1,629.00 1,629.00
Sokowski, T. S 2 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 260.00 62.94 1.44 80.52 24.00 729 1,464.27 2,050.00 2,050.00 2,050.00
(Student) S 1 8 8 7 8 4 4 8 8 8 4 71 7.50 532.50 532.50 33.02 7.72 30.00 16.35 0.37 20.92 6.30 730 417.82 532.50 532.50 532.50 532.50 532.50
Woods, B. S 1 8 8 8 8 8 8 8 8 8 8 80 1,200.00 1,200.00 74.40 17.40 128.00 36.84 0.84 47.14 14.10 731 881.28 1,200.00 1,200.00 1,200.00 1,200.00 1,200.00
Young, P. S 1 8 8 8 8 8 8 8 8 8 8 80 807.70 807.70 50.08 11.71 69.00 24.80 0.57 31.73 9.60 732 610.21 807.70 807.70 807.70 807.70 807.70
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
TOTALS 74,309.89 612.60 74,922.49 4,469.21 1,086.39 21,502.00 2,300.14 52.46 2,942.97 167.70 18.00 4,950.00 37,433.62 16,301.88 74,922.49 2,540.20 2,540.20 62,307.69 2,692.50 4,407.70 5,514.60
Caution: OASDI is not calculated on full pay for O'Neill this pay period.

Employees' Earnings Records

DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Plant Mixer Operator PA M F 000-00-3481 BONNO Anthony Victor
x
OTHER DEDUCTIONS INFORMATION SALARY $ W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$55,000 --$.30/M $9 each pay HOURLY RATE $ 17.65 5 M
OVERTIME RATE $ 26.48 M
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID F
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 10,293.40 1,028.60 11,322.00 701.96 164.17 810.00 347.59 7.93 444.73 216.80 8,628.82
1 10/9 80 17.65 1,412.00 0.00 12,734.00 87.54 20.47 49.00 43.35 0.99 55.46 8.00 672 1,147.19
2 10/23 80 17.65 1,412.00 4 26.48 105.92 14,251.92 94.11 22.01 60.00 46.60 1.06 59.62 24.50 682 1,210.02
3 11/6 80 17.65 1,412.00 0.00 15,663.92 87.54 20.47 49.00 43.35 0.99 55.46 8.00 692 1,147.19
4 11/20 64 17.65 1,129.60 0.00 16,793.52 70.04 16.38 22.00 34.68 0.79 44.37 24.50 703 916.84
5 12/4 80 17.65 1,412.00 8 35.30 282.40 18,487.92 105.05 24.57 83.00 52.02 1.19 66.56 8.00 712 1,354.01
6 12/18 80 17.65 1,412.00 12 35.30 423.60 20,323.52 113.81 26.62 81.00 56.35 1.28 72.10 25.50 723 1,458.94
QTR. TOT. 464 8,189.60 811.92 9,001.52 558.09 130.52 344.00 276.35 6.30 353.57 0.00 98.50 7,234.19
YR. TOT. 18,483.00 1,840.52 20,323.52 1,260.05 294.69 1,154.00 623.94 14.23 798.30 0.00 315.30 15,863.01
Checkpoint 9,001.52 20,323.52 Checkpoint 7,239.19 15,868.01
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Sales Sales Manager PA M F 000-00-8645 FERGUSON James Claude
x
OTHER DEDUCTIONS INFORMATION SALARY $ 58,500 /yr. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 1,125.00 ALLOW. STATUS
$88,000 -- $.30/M $500.00 HOURLY RATE $ 28.13 5 M
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 23,125.00 23,125.00 1,433.75 335.31 2,291.00 709.94 16.19 908.35 132.30 17,298.16
1 10/9 80 2,250.00 25,375.00 139.50 32.63 143.00 69.08 1.58 88.38 673 1,775.83
2 10/23 80 2,250.00 27,625.00 139.50 32.63 143.00 69.08 1.58 88.38 26.40 683 1,749.43
3 11/6 80 2,250.00 29,875.00 139.50 32.63 143.00 69.08 1.58 88.38 693 1,775.83
4 11/20 80 2,250.00 32,125.00 139.50 32.63 68.00 69.08 1.58 88.38 500.00 26.40 704 1,324.43
5 12/4 80 2,250.00 34,375.00 139.50 32.63 68.00 69.08 1.58 88.38 500.00 713 1,350.83
6 12/18 80 2,250.00 36,625.00 139.50 32.63 68.00 69.08 1.58 88.38 500.00 26.40 724 1,324.43
QTR. TOT. 480 13,500.00 13,500.00 837.00 195.78 633.00 414.48 9.48 530.28 1,500.00 79.20 9,300.78
YR. TOT. 36,625.00 36,625.00 2,270.75 531.09 2,924.00 1,124.42 25.67 1,438.63 1,500.00 211.50 26,598.94
Checkpoint 13,500.00 36,625.00 Checkpoint 9,300.78 26,598.94
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Office Executive Secretary PA M F 000-00-4567 FORD Catherine Louise
x
OTHER DEDUCTIONS INFORMATION SALARY $ 2,080 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 480.00 ALLOW. STATUS
$37,000--$.30/M HOURLY RATE $ 12.00 2 S
OVERTIME RATE $ 16.88
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 6,300.00 6,300.00 390.60 91.35 639.00 193.41 4.41 247.46 37.80 4,695.97
1 10/9 80 900.00 7,200.00 55.80 13.05 62.00 27.63 0.63 35.35 674 705.54
2 10/23 76 900.00 8,100.00 55.80 13.05 62.00 27.63 0.63 35.35 10.50 684 695.04
3 11/6 80 900.00 9,000.00 55.80 13.05 62.00 27.63 0.63 35.35 694 705.54
4 11/20 80 900.00 9,900.00 55.80 13.05 62.00 27.63 0.63 35.35 10.50 705 695.04
5 12/4 80 960.00 10,860.00 59.52 13.92 71.00 29.47 0.67 37.71 714 747.71
6 12/18 80 960.00 11,820.00 59.52 13.92 71.00 29.47 0.67 37.71 11.10 725 736.61
QTR. TOT. 476 5,520.00 5,520.00 342.24 80.04 390.00 169.46 3.86 216.82 0.00 32.10 4,285.48
YR. TOT. 11,820.00 11,820.00 732.84 171.39 1,029.00 362.87 8.27 464.28 0.00 69.90 8,981.45
Checkpoint 5,520.00 11,820.00 Checkpoint 4,285.48 8,981.45
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Sales Sales Representative PA M F 000-00-9352 MANN Dewey Wilson
x
OTHER DEDUCTIONS INFORMATION SALARY $ 2,925 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 675.00 ALLOW. STATUS
$53,000 -- $.30/M $250.00 HOURLY RATE $ 16.88 0 M
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 5,400.00 5,400.00 334.80 78.30 332.00 165.78 3.78 212.11 31.50 4,241.73
1 10/9 80 1,350.00 6,750.00 83.70 19.58 43.00 41.45 0.95 53.03 675 1,108.29
2 10/23 80 1,350.00 8,100.00 83.70 19.58 43.00 41.45 0.95 53.03 15.90 685 1,092.39
3 11/6 80 1,350.00 9,450.00 83.70 19.58 116.00 41.45 0.95 53.03 695 1,035.29
4 11/20 80 1,350.00 10,800.00 83.70 19.58 80.00 41.45 0.95 53.03 250.00 15.90 706 805.39
5 12/4 80 1,350.00 12,150.00 83.70 19.58 80.00 41.45 0.95 53.03 250.00 715 821.29
6 12/18 80 1,350.00 13,500.00 83.70 19.58 80.00 41.45 0.95 53.03 250.00 15.90 726 805.39
QTR. TOT. 480 8,100.00 8,100.00 502.20 117.48 442.00 248.70 5.70 318.18 750.00 47.70 5,668.04
YR. TOT. 13,500.00 13,500.00 837.00 195.78 774.00 414.48 9.48 530.29 750.00 79.20 9,909.77
Checkpoint 8,100.00 13,500.00 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Admini- strative President PA M F 000-00-1534 O'NEILL Joseph Tyler
x
OTHER DEDUCTIONS INFORMATION SALARY $ 60,000 /yr. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 1,153.85 ALLOW. STATUS
$90,000 -- $.30/M $700.00 HOURLY RATE $ 28.85 4 M
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 42,692.27 42,692.27 2,646.92 619.04 6,116.00 1,310.65 29.88 1,676.95 202.50 30,090.33
1 10/9 80 2,307.69 44,999.96 143.08 33.46 197.00 70.85 1.62 90.65 676 1,771.03
2 10/23 80 2,307.69 47,307.65 143.08 33.46 197.00 70.85 1.62 90.65 27.00 686 1,744.03
3 11/6 80 2,307.69 49,615.34 143.08 33.46 197.00 70.85 1.62 90.65 696 1,771.03
4 11/20 80 2,307.69 51,923.03 143.08 33.46 92.00 70.85 1.62 90.65 700.00 27.00 707 1,149.03
5 12/4 80 2,307.69 54,230.72 143.08 33.46 92.00 70.85 1.62 90.65 700.00 716 1,176.03
6 12/18 80 62,307.69 116,538.41 3,687.08 903.46 20,712.00 1,912.85 43.62 2,447.45 4,000.00 27.00 727 28,574.23
QTR. TOT. 480 73,846.14 73,846.14 4,402.48 1,070.76 21,487.00 2,267.10 51.72 2,900.70 5,400.00 81.00 36,185.38
YR. TOT. 116,538.41 116,538.41 7,049.40 1,689.80 27,603.00 3,577.75 81.60 4,577.65 5,400.00 283.50 66,275.71
Checkpoint 73,846.14 116,538.41 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Office Time Clerk PA M F 000-00-6337 RUSSELL Virginia Aloise
x
OTHER DEDUCTIONS INFORMATION SALARY $ 1,625 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 375.00 ALLOW. STATUS
$29,000 -- $.30/M *Deceased 12/10 HOURLY RATE $ 9.38 2 S
OVERTIME RATE $ 12.95
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 6,240.00 6,240.00 386.88 90.48 642.00 191.56 4.37 245.11 31.50 4,648.10
1 10/9 80 690.00 6,930.00 42.78 10.01 51.00 21.18 0.48 27.10 677 537.45
2 10/23 80 690.00 7,620.00 42.78 10.01 51.00 21.18 0.48 27.10 8.10 687 529.35
3 11/6 78 8.63 672.94 8,292.94 41.72 9.76 29.00 20.66 0.47 26.43 697 544.90
4 11/20 78 8.63 672.94 8,965.88 41.72 9.76 29.00 20.66 0.47 26.43 8.10 708 536.80
5 12/4 80 750.00 9,715.88 46.50 10.88 38.00 23.03 0.53 29.46 717 601.60
6 12/14 72 1,425.16 11,141.04 88.36 20.66 0.00 1.00 8.70 722 1,306.44
QTR. TOT. 468 4,901.04 4,901.04 303.86 71.08 198.00 106.71 3.43 136.52 0.00 24.90 4,056.54
YR. TOT. 11,141.04 11,141.04 690.74 161.56 840.00 298.27 7.80 381.63 0.00 56.40 8,704.64
Checkpoint 4,901.04 11,141.04 Checkpoint 4,056.54 8,704.64
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Plant Electrician PA M F 000-00-1223 RYAN Norman Allen
x
OTHER DEDUCTIONS INFORMATION SALARY $ W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$56,000 -- $.30/M $9 each pay $200.00 HOURLY RATE $ 18.00 4 M
OVERTIME RATE $ 27.00
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 13,287.50 1,397.80 14,685.30 910.49 212.94 1,070.00 450.84 10.28 576.84 235.70 11,218.21
1 10/9 80 18.00 1,440.00 0.00 16,125.30 89.28 20.88 53.00 44.21 1.01 56.56 8.00 678 1,167.06
2 10/23 80 18.00 1,440.00 8 27.00 216.00 17,781.30 102.67 24.01 75.00 50.84 1.16 65.05 24.80 688 1,312.47
3 11/6 80 18.00 1,440.00 0.00 19,221.30 89.28 20.88 53.00 44.21 1.01 56.56 8.00 698 1,167.06
4 11/20 80 18.00 1,440.00 0.00 20,661.30 89.28 20.88 33.00 44.21 1.01 56.56 200.00 24.80 709 970.26
5 12/4 76 18.00 1,368.00 3 27.00 81.00 22,110.30 89.84 21.01 38.00 44.48 1.01 56.92 200.00 8.00 718 989.74
6 12/18 80 18.00 1,440.00 7 27.00 189.00 23,739.30 101.00 23.62 53.00 50.01 1.14 63.99 200.00 25.80 728 1,110.44
QTR. TOT. 476 8,568.00 486.00 9,054.00 561.35 131.28 305.00 277.96 6.34 355.64 600.00 99.40 6,717.03
YR. TOT. 21,855.50 1,883.80 23,739.30 1,471.84 344.22 1,375.00 728.80 16.62 932.48 600.00 335.10 17,935.24
Checkpoint 9,054.00 23,739.30 Checkpoint 6,724.03 17,942.24
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Plant Supervisor PA M F 000-00-8832 SOKOWSKI Thomas James
x
OTHER DEDUCTIONS INFORMATION SALARY $ W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 1,025.00 ALLOW. STATUS
$80,000 -- $.30/M HOURLY RATE $ 25.63 2 S
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 16,650.00 16,650.00 1,032.30 241.43 2,002.00 511.16 11.66 654.01 94.50 12,102.94
1 10/9 80 2,050.00 18,700.00 127.10 29.73 180.00 62.94 1.44 80.52 679 1,568.27
2 10/23 80 2,050.00 20,750.00 127.10 29.73 180.00 62.94 1.44 80.52 24.00 689 1,544.27
3 11/6 80 2,050.00 22,800.00 127.10 29.73 260.00 62.94 1.44 80.52 699 1,488.27
4 11/20 80 2,050.00 24,850.00 127.10 29.73 260.00 62.94 1.44 80.52 24.00 710 1,464.27
5 12/4 80 2,050.00 26,900.00 127.10 29.73 260.00 62.94 1.44 80.52 719 1,488.27
6 12/18 80 2,050.00 28,950.00 127.10 29.73 260.00 62.94 1.44 80.52 24.00 729 1,464.27
QTR. TOT. 480 12,300.00 12,300.00 762.60 178.38 1,400.00 377.64 8.64 483.12 0.00 72.00 9,017.62
YR. TOT. 28,950.00 28,950.00 1,794.90 419.81 3,402.00 888.80 20.30 1,137.13 0.00 166.50 21,120.56
Checkpoint 12,300.00 28,950.00 Checkpoint 9,017.62 21,120.56
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Office Accounting Trainee PA M F BUMFORD David Lee
OTHER DEDUCTIONS INFORMATION SALARY $ W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
$21,000 -- $.30/M HOURLY RATE $ 7.50 1 S
OVERTIME RATE $ 11.25
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 5,550.00 5,550.00 344.10 80.48 409.00 170.38 3.89 218.00 32.40 4,291.75
1 10/9 72 7.50 540.00 6,090.00 33.48 7.83 32.00 16.58 0.38 21.21 680 428.52
2 10/23 72 7.50 540.00 6,630.00 33.48 7.83 32.00 16.58 0.38 21.21 6.30 690 422.22
3 11/6 72 7.50 540.00 7,170.00 33.48 7.83 32.00 16.58 0.38 21.21 700 428.52
4 11/20 72 7.50 540.00 7,710.00 33.48 7.83 32.00 16.58 0.38 21.21 6.30 711 422.22
5 12/4 72 7.50 540.00 8,250.00 33.48 7.83 32.00 16.58 0.38 21.21 720 428.52
6 12/18 71 7.50 532.50 8,782.50 33.02 7.72 30.00 16.35 0.37 20.92 6.30 730 417.82
QTR. TOT. 431 3,232.50 3,232.50 200.42 46.87 190.00 99.25 2.27 126.97 0.00 18.90 2,547.82
YR. TOT. 8,782.50 8,782.50 544.52 127.35 599.00 269.63 6.16 344.97 0.00 51.30 6,839.57
Checkpoint 3,232.50 8,782.50 Checkpoint 2,547.82 6,839.57
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Office Programmer PA M F 000-00-6741 WILLIAMS Ruth Virginia
x
OTHER DEDUCTIONS INFORMATION SALARY $ 2,650 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 611.54 ALLOW. STATUS
$48,000 -- $.30/M *Terminated 11/13 HOURLY RATE $ 15.29 0 S
OVERTIME RATE $ 22.94
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 10,260.00 10,260.00 636.12 148.77 1,606.00 314.98 7.18 403.01 59.40 7,084.54
1 10/9 80 1,223.08 11,483.08 75.83 17.73 155.00 37.55 0.86 48.04 681 888.07
2 10/23 80 1,223.08 12,706.16 75.83 17.73 155.00 37.55 0.86 48.04 14.40 691 873.67
3 11/6 79 15.29 1,207.85 13,914.01 74.89 17.51 152.00 37.08 0.85 47.44 701 878.08
4 11/13 56 15.29 2,079.32 15,993.33 128.92 30.15 340.00 63.84 1.46 81.68 14.40 702 1,418.87
5 0.00 0.00 0.00 0.00 0.00 0.00 0.00
6 0.00 0.00 0.00 0.00 0.00 0.00 0.00
QTR. TOT. 295 5,733.33 5,733.33 355.47 83.12 802.00 176.02 4.03 225.20 0.00 28.80 4,058.69
YR. TOT. 15,993.33 15,993.33 991.59 231.89 2,408.00 491.00 11.21 628.21 0.00 88.20 11,143.23
Checkpoint 5,733.33 15,993.33 Checkpoint 4,058.69 11,143.23
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Office Programmer PA M F 000-00-1587 WOODS Beth Anne
x
OTHER DEDUCTIONS INFORMATION SALARY $ 2,600 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 600.00 ALLOW. STATUS
$47,000 -- $.30/M HOURLY RATE $ 15.00 1 S
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE
1
2
3
4
5 12/4 72 1,080.00 1,080.00 66.96 15.66 110.00 33.16 0.76 42.42 721 811.04
6 12/18 80 1,200.00 2,280.00 74.40 17.40 128.00 36.84 0.84 47.14 14.10 731 881.28
QTR. TOT. 152 2,280.00 2,280.00 141.36 33.06 238.00 70.00 1.60 89.56 0.00 14.10 1,692.32
YR. TOT. 2,280.00 2,280.00 141.36 33.06 238.00 70.00 1.60 89.56 0.00 14.10 1,692.32
Checkpoint 2,280.00 2,280.00 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Sales Sales Representative PA M F 000-00-6057 YOUNG Paul Winston
x
OTHER DEDUCTIONS INFORMATION SALARY $ 1750 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 403.85 ALLOW. STATUS
$32,000 -- $.30/M HOURLY RATE $ 10.10 1 S
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE
1
2
3
4
5
6 12/18 80 807.70 807.70 50.08 11.71 69.00 24.80 0.57 31.73 732 619.81
QTR. TOT. 80 807.70 807.70 50.08 11.71 69.00 24.80 0.57 31.73 0.00 0.00 619.81
YR. TOT. 807.70 807.70 50.08 11.71 69.00 24.80 0.57 31.73 0.00 0.00 619.81
Checkpoint 807.70 807.70 Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
Office Time Clerk PA M F 000-00-1502 ZIMMERMAN Richard Lloyd
x
OTHER DEDUCTIONS INFORMATION SALARY $ 1,430 W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 330.00 ALLOW. STATUS
$26,000 -- $.30/M HOURLY RATE $ 8.25 1 M
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 0.00
1 0.00 0.00
2
3
4
5
6
QTR. TOT. 0
YR. TOT.
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE
M F
OTHER DEDUCTIONS INFORMATION SALARY $ W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ ALLOW. STATUS
HOURLY RATE $
OVERTIME RATE $
20___ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE DEDUCTIONS NET PAID
PAYDAY HRS. RATE AMOUNT HRS. RATE AMOUNT EARNINGS FICA FIT SIT SUTA CIT SIMPLE OTHER CK.
OASDI HI DEDUCTIONS NO. AMOUNT
YEAR-TO-DATE 0.00 0.00
1 0.00
2 0.00
3 0.00
4 0.00
5 0.00
6 0.00
QTR. TOT. 0 0.00 0.00 0.00 0.00
YR. TOT. 0.00 0.00 0.00