USPS Reports Guide –
USPS Reports by Number –
Report 959 Benefit Totals Reported to ERS
This report displays total amounts for retirement and fees, insurance, TexFlex and deferred compensation plans. It is produced only with a final payroll when any of these deductions are taken or canceled for an agency. Report 959 provides the total amounts or summed amounts of the detail interfaced to ERS daily by agency. The total amounts reported will sum any cancellations that reduced amounts processed during the nightly cycle reflecting the information interfaced to ERS.
An electronic file with the detail for each employee with a deduction listed is also created and sent to ERS when a final payroll is processed through USAS.
Report Criteria
| Category | Benefits Administration |
|---|---|
| Distribution | Agency |
| Frequency | Final Payroll (This report is produced during the USPS nightly cycle for each agency with information to report.) |
| Form | 111 |
| Sort Sequence | N/A |
| Page Break | Agency, Doc |
| Parameters | Automatically runs with agencies' final payrolls |
| Databases Used | H0H, H0B, HOM, HOI |
| Selection Criteria | All employees on an agency's final payroll with calculated pensionable earnings or a deduction for flex deductions, flex deduction fees, employee insurance, state insurance contributions, payroll health insurance contribution, opt-out credit, pre-tax employee retirement, post-tax employee retirement, employee retirement fees, employer retirement contributions, employer retirement fees, 401(k) loan deductions, 401(k) contributions, 457 loan deductions, 457 contributions, employee LECOS retirement contributions and employer LECOS retirement contributions, Roth contributions, limited flex spending, tobacco, dental discount program, state HSA, employee HSA, CSA transit/vanpool, CSA parking. |
| Produce Output? | Yes |
| Request Screen | N/A |
| Posting Report? | No |
| Additional Notes | This report is created nightly with an agency's final payroll. A detailed interface of the totals for all agencies is sent to ERS via EFT daily. It is called the CPA Daily Reporting File. |
Report Headings
- FROM/TO DERIVED
- Displays the report number, agency name, run date, agency number, report heading, run time and USAS document number.
- TOTAL RECORDS DERIVED
- Displays the total number of records for the agency including the agency header and trailer record.
- PENSIONABLE EARNINGS DERIVED
- Displays the total dollar amount of pensionable earnings reported for a final payroll.
- EMPLOYEE INSURANCE DERIVED
- Displays the total dollar amount of employee insurance, flex and non-flex deductions for a final payroll.
- 401K CONTRIBUTIONS DERIVED
- Displays the total dollar amount of 401(k) contributions for a final payroll.
- PRE-TAX EMPLOYEE RET DERIVED
- Displays the total dollar amount of pre-tax employee retirement contributions for a final payroll.
- EMPLOYEE HSA DERIVED
- Displays the total dollar amount of employee health savings account contribution for a final payroll.
- ROTH 401K CONTRIBUTIONS DERIVED
- Displays the total dollar amount of Roth 401(k) contributions for a final payroll.
- POST-TAX EMPLOYEE RET DERIVED
- Displays the total dollar amount of post-tax employee retirement contributions for a final payroll.
- DENTAL DISCOUNT PROG DERIVED
- Displays the total dollar amount of employee dental discount program for a final payroll.
- 401K LOAN DEDUCTIONS DERIVED
- Displays the total dollar amount of 401(k) loan deductions for a final payroll.
- EMPLOYEE LECOS CONTR DERIVED
- Displays the total dollar amount of employee LECOS retirement contributions for a final payroll.
- TOBACCO USER PREMIUM DERIVED
- 457 CONTRIBUTIONS DERIVED
- Displays the total dollar amount of 457 contributions deducted for a final payroll.
- EMPLOYER RET CONTR DERIVED
- Displays the total dollar amount of employer retirement contributions deducted for a final payroll.
- OPT OUT CREDIT DERIVED
- Displays the total dollar amount of opt out credits for a final payroll.
- ROTH 457 CONTRIBUTIONS DERIVED
- Displays the total dollar amount of Roth 457 contributions for a final payroll.
- PAYROLL RET CONT DERIVED
- Displays the total dollar amount for agency paid retirement contributions for a final payroll.
- STATE INS CONTR DERIVED
- Displays the total dollar amount of state insurance contributions for a final payroll.
- 457 LOAN DEDUCTIONS DERIVED
- Displays the total dollar amount of 457 loan deductions for a final payroll.
- EMPLOYER LECOS CONTR DERIVED
- Displays the total dollar amount of employer LECOS retirement contributions for a final payroll.
- PAYROLL HLTH INS CON DERIVED
- Displays the total dollar amount for agency-paid payroll health insurance contributions for a final payroll.
- CSA TRANSIT/VANPOOL DERIVED
- Displays the total dollar amount of Commuter Spending Account transportation/vanpool deductions for a final payroll.
- EMPLOYEE RET FEES DERIVED
- Displays the total dollar amount of employee retirement fees deducted for a final payroll.
- STATE HSA DERIVED
- Displays the total dollar amount of state-paid health savings account contribution for a final payroll.
- CSA PARKING DERIVED
- Displays the total dollar amount of Commuter Spending Account parking deductions for a final payroll.
- EMPLOYER RET FEES DERIVED
- Displays the total dollar amount of employer retirement fees deducted for a final payroll.
- FLEX DEDUCTIONS DERIVED
- Displays the total dollar amount of FSA Health and FSA Day Care deductions for a final payroll.
- FLEX DEDUCTION FEES DERIVED
- Displays the total dollar amount of FSA fee deductions for a final payroll.
- LIMITED FLEX SPENDING DERIVED
- Displays the total dollar amount of employee limited flexible spending account contribution for a final payroll.
Sample Report
REPORT: 959 STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: MM/DD/YYYY
BENEFIT TOTALS REPORTED TO ERS RUN TIME: 22:38:06
DOCUMENT: XXXXXXXX
TOTAL RECORDS : 4,283
PENSIONABLE EARNINGS : 16,988,693.94 EMPLOYEE INSURANCE : 674,078.62 401K CONTRIBUTIONS : 320,188.02
PRETAX EMPLOYEE RET : 1,084,904.90 EMPLOYEE HSA : 0.0 ROTH 401K CONTRIBUTIONS : 15,200.60
POSTTAX EMPLOYEE RET : 0.00 DENTAL DISCOUNT PROG : 0.00 401K LOAN DEDUCTIONS : 137,862.00
EMPLOYEE LECOS CONT : 0.00 TOBACCO USER PREMIUM : 33,690.00 457 CONTRIBUTIONS : 82,549.00
EMPLOYER RET CONT : 1,161,007.77 OPT OUT CREDIT : 1,680.00 ROTH 457 CONTRIBUTIONS : 11,502.00
PAYROLL RET CONT : 0.00 STATE INS CONTR : 2,052,832.30 457 LOAN DEDUCTIONS : 125,230.00
EMPLOYER LECOS CONTR : 0.00 PAYROLL HLTH INS CON : 144,893.93 CSA TRANSIT/VANPOOL : 2,700.00
EMPLOYEE RET FEES : 0.00 STATE HSA : 0.00 CSA PARKING : 1,300.00
EMPLOYER RET FEES : 0.00 FLEX DEDUCTIONS : 210,358.00
FLEX DEDUCTION FEES : 0.00
LIMITED FLEX SPENDING : 0.00