Glo Brite Paint Co Accounting Project

/in /by

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–
JOURNAL Page 43
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20–
JOURNAL Page 44
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20–
JOURNAL Page 45
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20–
JOURNAL Page 46
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20–
JOURNAL Page 47
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20–
JOURNAL Page 48
DATE DESCRIPTION POST. REF. DEBIT CREDIT
20–
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): 26,491.16 26,491.16
Your debits and credits should be equal after each journal entry is complete
Cumulative Journal Checkpoint Through Month Ending
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–
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
ACCOUNT: PAYROLL CASH ACCOUNT NO. 12 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 9 J41 11,097.25 11,097.25 Dec. 31, 20–
9 J41 11,097.25 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–
20– Nov. 30, 20–
Oct. 9 J41 878.09 878.09 Dec. 31, 20–
9 J41 878.09 1,756.18
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–
20– Nov. 30, 20–
Oct. 9 J41 205.37 205.37 Dec. 31, 20–
9 J41 205.36 410.73
ACCOUNT: FUTA TAXES PAYABLE ACCOUNT NO. 21 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 1 Balance a 392.94 Dec. 31, 20–
9 J41 19.68 412.62
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–
20– Nov. 30, 20–
Oct. 9 J41 128.01 128.01 Dec. 31, 20–
ACCOUNT: EMPLOYEES FIT PAYABLE ACCOUNT NO. 24 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 9 J41 965.00 965.00 Dec. 31, 20–
ACCOUNT: EMPLOYEES SIT PAYABLE ACCOUNT NO. 25 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 9 J41 434.82 434.82 Dec. 31, 20–
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– Nov. 30, 20–
Oct. 9 J41 9.94 9.94 Dec. 31, 20–
ACCOUNT: EMPLOYEES CIT PAYABLE ACCOUNT NO. 26 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 9 J41 556.30 556.30 Dec. 31, 20–
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–
20– Nov. 30, 20–
Dec. 31, 20–
ACCOUNT: UNION DUES PAYABLE ACCOUNT NO. 28 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 9 J41 16.00 16.00 Dec. 31, 20–
ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE ACCOUNT NO. 29 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Dec. 31, 20–
ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT NO. 51 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 1 Balance a 42,692.27 Dec. 31, 20–
9 J41 2,307.69 44,999.96
ACCOUNT: OFFICE SALARIES ACCOUNT NO. 52 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 1 Balance a 28,350.00 Dec. 31, 20–
9 J41 3,353.08 31,703.08
ACCOUNT: SALES SALARIES ACCOUNT NO. 53 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 1 Balance a 28,525.00 Dec. 31, 20–
9 J41 3,600.00 32,125.00
ACCOUNT: PLANT WAGES ACCOUNT NO. 54 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 1 Balance a 42,657.30 Dec. 31, 20–
9 J41 4,902.00 47,559.30
ACCOUNT: PAYROLL TAXES ACCOUNT NO. 56 Checkpoints
Debit Credit
POST. BALANCE Balance Balance
DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20–
20– Nov. 30, 20–
Oct. 1 Balance a 14,013.23 Dec. 31, 20–
9 J41 1,231.14 15,244.37

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
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. Total earnings
Ferguson, J. Net paid
Ford, C.
Mann, D.
O’Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
Payday, November 6, 20– For Period Ending October 31, 20– Checkpoints
Bonno, A. Total earnings
Ferguson, J. Net paid
Ford, C.
Mann, D.
O’Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Williams, R.
TOTALS
Payday, November 13, 20– For Period Ending November 14, 20– Checkpoints
Williams, R. Total earnings
Net paid
TOTALS
Payday, November 20, 20– For Period Ending November 14, 20– Checkpoints
Bonno, A. Total earnings
Ferguson, J. Net paid
Ford, C.
Mann, D.
O’Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
TOTALS
Payday, December 4, 20– For Period Ending November 28, 20– Checkpoints
Bonno, A. Total earnings
Ferguson, J. Net paid
Ford, C.
Mann, D.
O’Neill, J.
Russell, V.
Ryan, N.
Sokowski, T.
(Student)
Woods, B.
TOTALS
Payday, December 14, 20– For Period Ending December 12, 20– Checkpoints
Russell, V. Total earnings
Net paid
TOTALS
Payday, December 18, 20– For Period Ending December 12, 20– Checkpoints
Bonno, A. Total earnings
Ferguson, J. Net paid
Ford, C.
Mann, D.
O’Neill, J.
Mark Sears: Caution: OASDI is not calculated on full pay for O’Neill this pay period. Ryan, N.
Sokowski, T.
(Student)
Woods, B.
Young, P.
TOTALS

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 $8 each pay HOURLY RATE $ 17.65 4 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 0.00
3 11/6 0.00
4 11/20 0.00
5 12/4 0.00
6 12/18 0.00
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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 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
3 11/6
4 11/20
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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 $ 1,950 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 450.00 ALLOW. STATUS
$35,000–$.30/M HOURLY RATE $ 11.25 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
3 11/6
4 11/20
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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 HOURLY RATE $ 16.88 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 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
3 11/6
4 11/20
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint 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 HOURLY RATE $ 28.85 3 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
3 11/6
4 11/20
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint 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,495 /mo. W/H MARITAL
GROUP INSURANCE UNION DUES OTHER WEEKLY RATE $ 345.00 ALLOW. STATUS
$27,000 — $.30/M HOURLY RATE $ 8.63 1 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
3 11/6
4 11/20
5 12/4
6 12/14
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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 $8 each pay 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 0.00
3 11/6 0.00
4 11/20 0.00
5 12/4 0.00
6 12/18 0.00
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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 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 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
3 11/6
4 11/20
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
DEPARTMENT OCCUPATION WORKS IN (STATE) SEX S.S. ACCOUNT NO. NAME – LAST FIRST MIDDLE
Office Accounting Trainee PA M F Student
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
3 11/6
4 11/20
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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 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
3 11/6
4 11/13
5
6
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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
1
2
3
4
5 12/4
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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
1
2
3
4
5
6 12/18
QTR. TOT.
YR. TOT.
Checkpoint Checkpoint
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
1
2
3
4
5
6
QTR. TOT.
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
1
2
3
4
5
6
QTR. TOT.
YR. TOT.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"