need help finishing 2021 short version publisher template

data comes from bieg and toalnd payroll accounting 2021 chapter 7 appendix a

S.S. ACCOUNT NO NAME - LAST FIRST MIDDLE DEPARTMENT OCCUPATION WORKS IN(STATE SEXF Plant Mixer Operator PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES 000-00-3481 OTHER BONNO SALARY VEEKLY RATE HOURLY RATE OVERTIME RATE $55,000 - $.30/M $8 each pay 20_ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HAS. RATE AMOUNT HRS RATE AMOUNT YEAR-TO-DATE 10.293.40 1,028.60 11,322.00 1 1 1019 80 17.60 1,408.00 0.00 12.730.001 2 10/23 80 17.60 1,408.00 4 26.40 105.60 14,243.60 3 116 80] 17.60 1,408.00 0.001 15,651.601 4 1120 64 17.60 1.126.40 0.001 16,778.00 5 1214 80 17.60 1,408.00 8 35.20 281.60 18,467.60 6 12/18 80] 17.60 1.408.00 12 35.20 422.40 20.298.00 QTR. TOT 464 8.166.40 809.60 8,976.00 YR TOT. 18.459.80 1.838.20 20.298.00 Checkpoint 8,976.00 20,298.00 FICA OASDI 701.96 87.30 93.84 87.30 69.84 104.76 113.48 556.52 1.258.48 H 164.17 20.42 21.95 20.42 | 16.33 24.50 26.54 130.16 294.33 FIT 810.00 45.00 55.00 45.00) 17.00 Anthony Victor $ WIH FILING $ ALLOW. STATUS $ 17.60 $ 26.40 N/A MFJ DEDUCTIONS NET PAID OTHER | CK SIT SUTA CIT SIMPLE DEDUCTIONS NO. AMOUNT 347.59 6.79 438.30 216.80 8,636.39 43.23 0.84 54.51 8.00 672 1.148.70 46.47 0.91 58.59 24.50 682) 1.212.34 43.23 0.84 54.51 8.00 692 1.148.70 24 E ng 34.58) 0.68 43.61 24.50 703 919 919.86 54971 1.01 65.41 7121 1,442.05 56.19 1.10 70.86 723 1.562.23 275.57 5.38 347.49 7.433.88 623.16 12.17 785.79 16.070 27 Checkpoint S.S. ACCOUNT NO NAME - LAST FIRST MIDDLE DEPARTMENT OCCUPATION WORKS IN [STATE SEX MF Sales Sales Manager PA X OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES $88,000 -- $.30/M 20_ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS RATE AMOUNT HRS RATE AMOUNT YEAR-TO-DATE n! 23.125.000 23.125.00 1 1019 80 2.250.00 25,375.00 2 10/23 80 2.250.00 2,200 27,625.00 3 116 80 2.250.00 2,200 29,875.00 4 1120 80 2.250.00 32,125.000 5 124 80 2.250.00 11.12 34,375.00 61 12018 80 2.250.00 36,625.000 QTR. TOT 480 13,500.00 13,500.00 YR TOT. 36,625.00 36,625.00 Checkpoint 13,500.00 36,625.00 000-00-8645 FERGUSON James Claude SALARY $ $ 58.500 /yr WIH FILING OTHER VEEKLY RATE $ 1,125.00 ALLOW STATUS HOURLY RATE $ 28.13 OVERTIME RATE N/A MF. DEDUCTIONS NET PAID FICA OTHER CK OASDI H FIT SIT SUTA CIT SIMPLE DEDUCTIONS NO AMOUNT 1.433.75 335.31 2,291.001 709.94 13.88 895 22 132 30 17,313.60 139.50 32.63 139.00 69.08 1.35 87.10 673 1,781.34 139.50 32.63 139.00 69.08 1.35 87.10 26.40 683 1,754.94 139.50 32.63 139.00 69.08 1.35 87.10 693 1,781.34 139.50 32.63 80.00 69.08 1.35 87.10 500.00 26.40 704 1,313.94 139.50 32.63 69.08 1.35 87.10 500.00 713 1.420.34 139.50 32.63 69.08 1.35 87.10 500.00 26.40 724 1.393.94 837.00 195.78 414.48 8.10 522.60 1,500.00 79.20 9.445.84 2.270.75 531.09 1,124.42 21.98 1.417.82 1,500.00 211.50 26.759.44 Checkpoint DEPARTMENT OCCUPATION WORKS IN (STATE S.S. ACCOUNT NO. NAME - LAST FIRST SEX MF MIDDLE Office X 000-00-4567 Executive Secretary PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES FORD SALARY OTHER VEEKLY RATE HOURLY RATE OVERTIME RATE FIT 639.00 $48,000-$.30/M 20_ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS RATE AMOUNT HRS RATE AMOUNT YEAR-TO-DATE 6,300.00 6,300.00 1 10/9 80 1.220.00 7,520.00 2 10/23 80 1.220.00 8,740.00 3 116 800 1.220.000 9,960.00 4 1120 80 1.220.000 11,180.00 5 124 80 1.280.000 12,460.00 6 12018 80 1.280.000 13.740.000 QTR. TOT 4801 7.440.00 7,440.00) YR TOT. 13.740.00 13.740.00 Checkpoint 7,440.00 13,740.00 FICA OASDI 390.60 75.64 75.64 75.64 75.64 79.36 79.36 461.28 851.88 H 91.350 17.69 17.69 17.69 17.69 18.56 18.56 107.88 199.23 82.00 82.00 82.00 82.00 Catherine Louise $ 2,643.33 /mo WIH FILING $ 610.00 ALLOW STATUS $ 15.25 $ 22.88 N/A S DEDUCTIONS NET PAID OTHER . SIT SUTA CIT SIMPLE DEDUCTIONS NO AMOUNT 193.41 3.78 243.89 37.80 4.700.17 37.45 0.73 47.23 674 959.26 37.45 0.73 47.23 14.40 684 944.86 37.45 0.73 47 23 694 959.26 37.45 0.73 47.23 14.40 705 944.86 39.30 0.77 49.55 1,092.46 39.30 0.77 49.55 1,092.46 228.40 4.46 288.02 5.993.16 421.81 8.24 531.91 10.693.33 Checkpoint F 000-00-9352 M Sales Sales Representative PA X OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES OTHER MANN SALARY WEEKLY RATE HOURLY RATE OVERTIME RATE $53.000 -- 5.30/M 20__ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS. RATE AMOUNT HRS. RATE AMOUNT YEAR-TO-DATE 5,400.00 5,400.00 1 1079 80 1,350.00 6,750.00 2 12 10/23 80 1,350.00 8,100.00 a 3 176 80 1,350.00 9,450.00 a 4 1120 80 1,350.00 10 800 ml 5 1214 80 1,350.00 12,150.00 6 61 12/18 80 13,500.00 OTR TOT 480 8,100.00 | YR. TOT. 13,500.00 13,500.00 Checkpoint 8,100.00 13,500.00 FICA OASDI 334.80 83.70 83.70 83.70 83.70 HI 78.30 19.58 19.58 19.58 19.58 19.58 19.58 117.48 195.78 FIT 332.00 39.00 39.00 39.000 15.00 Dewey Wilson $ 2.925 /mo. WIH FILING $ 675.00 ALLOW STATUS $ 16.88 $ N/A MFJ DEDUCTIONS NET PAID OTHER CK SIT SUTA CIT SIMPLE DEDUCTIONS NO AMOUNT 165.78 3.24 209.04 31.50 4.245.34 41.45 0.81 52.26 675 1,113.20 41.45 0.81 52.26 15.90 685 1,097.30 41.45 0.81 52.26 695 1,113.20 41.45 0.81 52.26 250.00 15.90 706 871.30 41.451 0.81 52.26 250.00 715 902.20 41.45 0.81 52.26 250.00 15.90 726 886.30 248.70 4.86 313.56 750.00 47.70 5,983.50 414.48 8.10 522.601 750.00 79.20 10,228.84 Checkpoint 83.70 1,350.00 8,100.00 83.70 502.20 837.00 S.S. ACCOUNT NO NAME - LAST FIRST MIDDLE DEPARTMENT OCCUPATION WORKS IN(STATE SEX Admini- M F strative President PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES 000-00-1534 O'NEILL SALARY WIH Joseph $ 60.000 /yr. $ 2.307.69 $ Tyler FILING STATUS OTHER BI-WEEKLY RATE ALLOW HOURLY RATE OVERTIME RATE DEDUCTIONS CUMULATIVE EARNINGS $90,000 -- $.30/M 20_ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS RATE AMOUNT HRS RATE AMOUNT YEAR-TO-DATE 42,692.27 1 1049 80 2,307.69 2 10/23 80 2,307.69 3 116 80 2.307.69 14 1120 80 2.307.69 15 1214 16 12/18 QTR TOT YR. TOT Checkpoint FICA OASDI 2,646.92 143.08 ) 143.08 143.08 143.08 42.692.27 44,999.96 47,307.65 49,615.34 51.923.03 TTI HI 619.04 33.46 33.46 33.46 33.46 FIT SIT 6,116.00 1.310.65 146.00 70.85 146.00 70.85 146.001 70.85 65.00 70.85 N/A MFJ NET PAID OTHER CK SIMPLE DEDUCTIONS NO AMOUNT 202.50 30.118.84 676 1.823.58 27.00 686 1,796 58 696 1,823.58 700.000 27.00 707 1.177.58 SUTA CIT 25.62 1,652.70 1.38 89.34 1.38 89.34 1.38 89.34 1.38 89.34 Checkpoint DEPARTMENT OCCUPATION WORKS IN(STATE S.S. ACCOUNT NO. NAME - LAST FIRST MIDDLE SEX M F X 000-00-6337 Office Time Clerk PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES OTHER RUSSELL SALARY WEEKLY RATE HOURLY RATE OVERTIME RATE CUMULATIVE EARNINGS $47.000 -- 5.30/M 20_ REGULAR EARNINGS OVERTIME EARNINGS PAYDAY HRS. RATE AMOUNT JHRS RATE AMOUNT YEAR-TO-DATE 6,240.00 1 10/9 80 1,200.00 2 10/23 80 1.200.00 3 116 78 1.170.00 SI 14 1120 78 1,170.00 5 1214 80 1,260.00 16 12/14 72 2.394.00 QTR TOT 468 8.394.00 YR. TOT 14.634.00 Checkpoint 8,394.00 FICA OASDI 386.881 74.40 74.40 72.54 72.54 78.12 148.43 520.43 907.311 6,240.00 7,440.00 8,640.00 9,810.001 10.980.00 12,240.00 14.634.00 8,394.00 14.634.00 14,634.00 HI 90.48 17.40 17.40 16.97 16.97 18.27 34.71 121.72 212 20 FIT 642.00 80.00 80.00 75.00 75.00 Virginia Aloise 2,600 /mo WIH FILING $ 600.00 ALLOW STATUS $ 15.00 $ 22 50 N/A S DEDUCTIONS NET PAID OTHER CK SIT SUTA CIT SIMPLE DEDUCTIONS NO. AMOUNT 191.56 3.74 241.56 31.50 4,652.28 36.84 0.72 46.45 677 944. 19 36.84 0.72 46.45 14.10 687 930.09 35.921 0.70 45.29 697 923.58 35.92 0.70 45.29 14.10 708 909.48 38.68 0.76 48.78 717 1,075.39 0.00 1.44 0.00 14.70 722 2.194.72 184.20 5.04 232 26 42.90 6,977.45 375.76 8.78 473.82 74.40 11,629.73 Checkpoint 310.00 952.00 M F 000-00-1223 Plant Electrician PA OTHER DEDUCTIONS INFORMATION GROUP INSURANCE UNION DUES RYAN SALARY WEEKLY RATE HOURLY RATE OTHER OVERTIME RATE / $56.000 -- 5.30/M $8 each pay 20_ REGULAR EARNINGS OVERTIME EARNINGS CUMULATIVE PAYDAY EARNINGS HRS RATE AMOUNT HRS RATE AMOUNT YEAR-TO-DATE 13,287.50 1,397.80 14.685.30 1 1049 80] 18.00 1,440.00 0.001 16.125.30 2 1023