>BEGIN >VERSION 03.02 >COUNT 26 >BEGIN payroll /***************************************************************************/ /* Payroll tables Federal */ /* Updated - 12/14/21 effective 01/01/22 cbf */ /* 1 - 4 Payroll Table ID */ /* 6 - 20 Payroll Table Description */ /* 22 Table Type - R or P */ /* */ /* 1 - 15 Amount in $ to be added to the result of the calculation */ /* 17 - 31 Percentage or rate to be multiplied by */ /* the amount of base which exceeds the following amount */ /* 33 - 47 Minimum of a particular range in the table */ /***************************************************************************/ >BEGIN TABLE FET1 FET1 FED PAY TABLE-S P 0.00 0.00 0.00 0.00 10.00 4350.00 1027.50 12.00 14625.00 4807.50 22.00 46125.00 15213.50 24.00 93425.00 34647.50 32.00 174400.00 49335.50 35.00 220300.00 162718.00 37.00 544250.00 >END TABLE FET1 >BEGIN TABLE FET2 FET2 FED PAY TABLE-O P 0.00 0.00 0.00 0.00 10.00 13000.00 2055.00 12.00 33550.00 9615.00 22.00 96550.00 30427.00 24.00 191150.00 69295.00 32.00 353100.00 98671.00 35.00 444900.00 174253.50 37.00 660850.00 >END TABLE FET2 >BEGIN TABLE FET3 FET3 FED PAY TABLE-H P 0.00 0.00 0.00 0.00 10.00 10800.00 1465.00 12.00 25450.00 6415.00 22.00 66700.00 13708.00 24.00 99850.00 33148.00 32.00 180850.00 47836.00 35.00 226750.00 161218.50 37.00 550700.00 >END TABLE FET3 >BEGIN TABLE FET5 FET5 FED BONUS TABLE P 0.00 22.00 0.00 220000.00 37.00 1000000.00 >END TABLE FET5 >BEGIN TABLE FET6 FET6 FEDPAYTABLE-SHW P 0.00 0.00 0.00 0.00 10.00 6475.00 513.75 12.00 11613.00 2403.75 22.00 27363.00 7606.75 24.00 51013.00 17323.75 32.00 91500.00 24667.75 35.00 114450.00 81359.00 37.00 276425.00 >END TABLE FET6 >BEGIN TABLE FET7 FET7 FEDPAYTABLE-OHW P 0.00 0.00 0.00 0.00 10.00 12950.00 1027.50 12.00 23225.00 4807.50 22.00 54725.00 15213.50 24.00 102025.00 34647.50 32.00 183000.00 49335.50 35.00 228900.00 87126.75 37.00 336875.00 >END TABLE FET7 >BEGIN TABLE FET8 FET8 FEDPAYTABLE-HHW P 0.00 0.00 0.00 0.00 10.00 9700.00 732.50 12.00 17025.00 3207.50 22.00 37650.00 6854.00 24.00 54225.00 16574.00 32.00 94725.00 23918.00 35.00 117675.00 80609.25 37.00 279650.00 >END TABLE FET8 /****************************************************************/ /* Payroll Deductions */ /* */ /* 1 - 6 Deduction ID */ /* 8 - 22 Deduction Description */ /* 24 Deduction Type: F, I, U, S, L, or O */ /* 26 Subject Work Locations: A or S */ /* 28 Base Type: E, D, U, or N */ /* 30 - 35 Base Deduction ID */ /* 37 - 38 Calculation Method: FP, FR, FA, PT, or RT */ /* 40 - 54 Fixed Percent/Rate */ /* 56 - 61 Withholding Account */ /* 63 - 68 Withholding Subaccount */ /* New Line */ /* 1 Withhold from Employee: Y or N */ /* 3 - 17 Min YTD Subject Wages/Hours */ /* 19 - 33 Max YTD Subject Wages/Hours */ /* */ /* Payroll Exemptions and Credits */ /* */ /* 1 Marital Status ID */ /* 3 - 6 Payroll Table ID (repeat as needed) */ /* */ /* 8 - 11 Exemption/Credit ID */ /* 13 - 27 Exemption/Credit Description */ /* 29 Exemption/Credit Flag: E or C */ /* 31 Base Type: E, U, D, P, O, or N */ /* 33 - 38 Base Deduction ID */ /* 40 - 41 Calculation Method: FP, FR, FA, PT, or RT */ /* 43 - 57 Fixed Percent/Rate/Amount */ /* 60 - 74 Exemption Code (for 2.52 Payroll) */ /* New Line */ /* 8 - 11 Payroll Table ID */ /* 13 - 27 Exemption/Credit Minimum */ /* 29 - 43 Exemption/Credit Maximum (repeat as needed) */ /****************************************************************/ >begin deduction FED1 FED1 FED INC TAX F A E PT 0.00 2110 000000 Y 0.00 0.00 A FEE1 FEDERAL EXEMPT E P FR 4300.00 PEREXMP 0.00 0.00 H FET3 J FET2 M FET1 S FET1 U FET8 W FET7 Y FET6 >end deduction FED1 >begin deduction FED2 FED2 FICA/EMPLOYEE I A E FP 6.20 2120 000000 Y 0.00 147000.00 >end deduction FED2 >begin deduction FED3 FED3 FICA/EMPLOYER I A E FP 6.20 2130 000000 N 0.00 147000.00 >end deduction FED3 >begin deduction FED4 FED4 FUTA TAX U A E FP 0.60 2160 000000 N 0.00 7000.00 >end deduction FED4 >begin deduction FED5 FED5 FED BONUS DEDT F A E PT 0.00 2110 000000 Y 0.00 0.00 A FET5 >end deduction FED5 >begin deduction FED6 FED6 FICAMED/EMPLOYE I A E FP 1.45 2121 000000 Y 0.00 0.00 >end deduction FED6 >begin deduction FED7 FED7 FICAMED/EMPLOYR I A E FP 1.45 2131 000000 N 0.00 0.00 >end deduction FED7 >begin deduction FED9 FED9 ADD MEDICARE TX I A E FP 0.90 2121 000000 Y 200000.00 999999999.99 >end deduction FED9 >end payroll records >END