What are the requirements to upload my payroll deduction file?
Here are the instructions and requirements to upload your payroll deduction files:
Your file must be in Excel format.
The Excel file can only have one tab. You must upload your product, reimbursement and annuity files separately. You cannot submit multiple tabs in a worksheet.
The first three columns are required and must be:
-Full Social Security number (with or without dashes)
-Full name: Last name, First name
-Deduction amount: in numeric form, with or without a dollar sign
Providing a fourth column with insurance type is NOT required but may provide better results for comparison. If your file has a fourth column but does not match ours, that column will be ignored.
For more reliable and faster reconciliation processing, please use these type codes:
PRODUCT TYPE CODES:
ACCID = Accident Insurance
CANCR = Cancer Insurance
CRITI = Critical Illness Insurance
CRITG = Group Critical Illness Insurance
DISAB = Disability Income Insurance
SDISB = Short-Term Disability Income Insurance
LDISB = Long-Term Disability Income Insurance
ILIFE = Universal Life Insurance provided by Texas Life Insurance Company
LIFE = Life Insurance
MED = Hospital Indemnity Insurance and Hospital GAP Plan Insurance
REIMBURSEMENT TYPE CODES:
3PR = Individual Premium Reimbursement
URM = Healthcare Flexible Spending Account
DDC = Dependent Care Account
HRA = Health Reimbursement Arrangement
LPF = Limited Purpose Flexible Spending Account
EPP = Employer Paid Prescription Plan
DEBIT = Benefits Debit Card Fee
ANNUITY TYPE CODES:
403(b) = 403(b)
457(b) = 457(b)