{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Deferred Comp Wksht rvsd 062025","One-Time Deduct Form (1DED)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Deferred Comp Wksht rvsd 062025","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,1,6,7]]}
[null,null,"DEFERRED COMPENSATION WORKSHEET  "]
[]
["Step #",null,"INSTRUCTIONS:"]
[1,"ENTER total amount listed on \"Employee Deduction Summary\" screen in HRM for each deduction type in the Employee Deduction Amount column below"]
[2,"ENTER total gross amount of separation pay as indicated in \"SEPARATION GROSS PAY\" section "]
[3,"ENTER any other deductions to be withheld such as credit union, United Way, dues, child support, garnishments, bankruptcies, levies,etc."]
[4,"ENTER deferred compensation deduction amount (MUST NOT EXCEED amount listed in the \"MAX ALLOWED\" column) for the appropriate deduction type/plan "]
[5,"If NET PAY is less than than zero, reduce deferred compensation deduction amount as needed; if greater than zero move on to step 6"]
[6,"COMPLETE Required Fields on the \"One-Time Deduct Form (OTDED)\" tab"]
[7,"PRINT, SIGN, DATE and SUBMIT the One-Time Deduction Form (OTDED) to HRM for processing"]
[]
[]
["Step 1",null,"Deduction Type",null,"Deduction Plan","Employee Deduction Amount","*MAX ALLOWED ","Calendar Year Deferral Limit "]
[null,null,"GWEST",null,"GWEST"]
[null,null,"PERAF",null,"PERAF",null,{"$f":"H15-SUM(F14:F24)","v":23500},23500]
[null,null,"Age 50 & over (during year of deferral):"]
[null,null,"50GWT",null,"50GWT"]
[null,null,"50PER",null,"50PER",null,{"$f":"H18-SUM(F14:F24)","v":31000},31000]
[null,null,"Age 60-63 (during year of deferral):"]
[null,null,"CU63G",null,"CU63G"]
[null,null,"CU63P",null,"CU63P",null,{"$f":"H21-SUM(F17:F27)","v":34750},34750]
[null,null,"Catch up deferral (within 3 yrs retirement):"]
[null,null,"C/UGW",null,"C/UGW"]
[null,null,"C/UPR",null,"C/UPR",null,{"$f":"H24-SUM(F14:F24)","v":47000},47000]
[]
[]
["Step 2",null,"SEPARATION GROSS PAY "]
[]
[]
[null,null,"OTHER DEDUCTIONS TAKEN "]
["Step 3",null,"a. Credit Union","="]
[null,null,"b. United Way","="]
[null,null,"c. Dues","="]
[null,null,"d. Child Support","="]
[null,null,"e. Garnishments/Bankruptcy/Levies","="]
[null,null,"f. Roth *MAX Allowed Column","=",null,"(RTHGW, RTHRS,50RGW, 50RRS,C63GR, C63RR, CURGW, CURRS)"]
[null,null,"d.Other miscellaneous deductions","="]
[null,null,"Total OTHER DEDUCTIONS AMOUNT","=",{"$f":"SUM(E31:E37)","v":0}]
[]
["Step 4",null,"a. GWEST AMT","=",null,"(Enter amounts in fields 3a thru 3f on 1DED form)"]
[null,null,"b. PERAF AMT","="]
[null,null,"c. 50GWT AMT","="]
[null,null,"d. 50PER AMT","="]
[null,null,"d. CU63G AMT","="]
[null,null,"e. CU63P AMT","="]
[null,null,"f. C/UGW AMT","="]
[null,null,"g. C/UPR  AMT ","="]
[null,null,"TOTAL DEFERRED COMP AMOUNT          ","=",{"$f":"SUM(E40:E47)","v":0}]
[]
[null,null,"FEDERAL TAX                      ","=",{"$f":"0.22*(E27)","v":0}]
[null,null,"STATE TAX                           ","=",{"$f":"0.05*(E27)","v":0}]
[null,null,"FICA TAX   (6.2%)                         ","=",{"$f":"0.062*(E27)","v":0}]
[null,null,"MEDICARE TAX                    ","=",{"$f":"ROUND(0.0145*E27,2)","v":0}]
[null,null,"TOTAL TAXES                      ","=",{"$f":"SUM(E50:E53)","v":0}]
[null,null,"TOTAL DEDUCTIONS            ","=",{"$f":"SUM(E48+E54)","v":0}]
[null,null,"FEDERAL TAX SAVINGS (ded)   ","=",{"$f":"0.22*(E48)","v":0},"(Enter this as negative amount on 1DED form)"]
[null,null,"STATE TAX SAVINGS (ded)     ","=",{"$f":"0.05*(E48)","v":0},"(Enter this as negative amount on 1DED form)"]
[null,null,"TOTAL TAX SAVINGS             ","=",{"$f":"SUM(E56:E57)","v":0}]
[]
["Step 5",null,"NET PAY                               ","=",{"$f":"E27-E55+E58-E38","v":0},"(This number must be greater than zero)"]
[]
[]
[null,null,"Control + c will clear Sheet"]

{"sheet":"One-Time Deduct Form (1DED)","index":1,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":false,"merged":[[6,0,6,5],[15,0,15,3]]}
[null,null,"STATE OF ALABAMA"]
[null,null,"ONE TIME DEDUCTION (1DED)"]
[null,null,"  EMPOWER/RETIREMENT SYSTEMS DEFERRAL"]
[]
["Complete this form if an employee wants a lump sum deferred compensation amount withheld from separation pay."]
[]
["The completed form must be emailed to the Payroll Section of the Comptroller's Office, payroll@comptroller.alabama.gov, no later than five to seven business days prior to deadline for payroll processing. "]
[]
["Agency Number:",0,"Payroll Number:",0]
[]
["Employee ID:",0]
[]
["Employee Name:"]
[]
["Reason for Adjustment:"]
[]
[]
["Effective Date for 1DED:"]
[null,"(mm/dd/yy)"]
[]
[null,"DEDUCTION (Enter GHRS deduction codes for Deduction Type and Plan)"]
[]
[null,"TYPE","PLAN","AMOUNT"]
[null,"GWEST","GWEST"]
[null,"PERAF","PERAF",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E41","v":0}]
["Age 50 & over (during year of deferral):","50GWT","50GWT",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E42","v":0}]
[null,"50PER","50PER",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E43","v":0}]
["Catchup Deferral (withhin 3 yrs retirement):","CU63G","CU63G",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E44","v":0}]
[null,"CU63P","CU63P",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E45","v":0}]
[null,"C/UGW","C/UGW",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E46","v":0}]
[null,"C/UPR","C/UPR",{"$f":"+'Deferred Comp Wksht rvsd 062025'!E47","v":0}]
[null,"FDTAX","FDTAX",{"$f":"-'Deferred Comp Wksht rvsd 062025'!E56","v":0}]
[null,"STTAX","STTAX",{"$f":"-'Deferred Comp Wksht rvsd 062025'!E57","v":0}]
[]
["Authorized Departmental Approval:"]
[]
["Submitted by:"]
[]
["Phone #: "]
[]
[]
["For Comptroller's Use Only:"]
[]
["OTDED"]
["Processed by:",null,null,"Date:"]
["Verified by:",null,null,"Date:"]