FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Leave Accounting Reports Chart
(In Task Order)

Updated November 1, 2011 - View Changes

Start of Month Reports

Rpt # Database Updated Report Name Request Screen Dates Required Summary
156 HMCU1, HM8U2 Vacation & Sick Leave Accrual Exceptions HSRPT, HNKLA LA Process Date - End of Month Accrues vacation/sick leave, moves agency to new LA month.
196 HM9U1, HM8U2 Posting Report HSRPT, HNKLA LA Process Date - End of Month Run only if future-dated leave was entered. Posts leave in request status & a start date in the current LA month.

Payroll Related Reports

Rpt # Database Updated Report Name Request Screen Dates Required Summary
594 HUAU1, HUEU1 Payroll Transactions Generated HNKLA LA Process Date - End of Month Makes payroll batches for overtime/comp time payments & LWOP docks. Run before trial payroll.
557 HM9U1, HM8U2 Leave Payment Audit HNKLA LA Warrant Start Date
LA Warrant End Date
Checks payroll history & updates HM9U1 that payment/docks actually occurred. Run after last payroll has been completed.
595 -- Leave Payroll Reconciliation Report HNKLA Start Date
End Date
Shows leave accounting payments/docks not paid/docked by payroll. Run after last payroll for month completed.

After completing all data entry for a month

Rpt # Database Updated Report Name Request Screen Dates Required Summary
Ø53 HMCU1, HM8U2 Hourly Adjustment Process for Actual Time Worked HSRPT, HNKLA LA Process Date - 1st of Month
LA Warrant Start Date
LA Warrant End Date
Adjusts accruals for hourly employees according to hours paid. Not needed for agencies without hourly employees.
569 -- Proj. Annual Leave to Be Converted to Sick Leave at FYE HNKLA LA Process Date - End of Month Calculates how much vacation an employee will have at the fiscal year end(if no more is taken) and how much of that ending balance will be converted to sick leave.
597 HM9U1, HM8U2 Actual/Forecasted Time Forfeitures as of MM/DD/CCYY HNKLA LA Process Date - End of Month Forfeits aged comp & holiday comp, warns of forfeitures within 90 days.
537 -- Employee Leave Summary HNKLA LA Process Date - End of Month Shows monthly leave balances & activity for each employee.

This report may be run in an “E” edit mode prior to running the final report. If your agency is on the Employee Information System (EIS), no summary is generated using this option and an actual report is available with your agency download.

Month-End Reports

Rpt # Database Updated Report Name Request Screen Dates Required Summary
199 -- FLSA O.T./Comp Time Activity HSRPT, HNKLA End Date - End of Month Shows Overtime & Comp time activity for the month.
561 -- Sick Leave Pool Activity HNKLA Start Date
End Date
Shows sick leave pool activity for the month.
563 -- Employee Leave Balances HNKLA LA Process Date - End of Month Balances for vac, sick leave, OT, comp & holiday comp.
565 -- Employee Leave Accrued Report HNKLA LA Process Date - End of Month Shows amount of vacation and sick leave accrued.

Year-End Processing

Rpt # Database Updated Report Name Request Screen Dates Required Summary
574 -- Compensable Leave Report For Fiscal Year CCYY HNKLA -- Long-term liability for the Annual Financial Report.
158 HMCU1, HM8U2, HMOU2, HM9U1 Leave Rollover Exception Listing HSRPT, HNKLA -- Moves an agency from one fiscal year to the next by creating new records for all databases showing information on a yearly basis. Does not produce printed output.
567 -- Fiscal Year End Excess Vacation Leave HNKLA LA Process Date - Sept. 1 of new fiscal year Shows vacation leave converted to sick leave. Run with or after 158. Dates are for the new fiscal year.

On Request Reports

Rpt # Database Updated Report Name Request Screen Dates Required Summary
573 -- Employee FMLA/Parental Leave Authorization HNKLA LA Process Date - End of Month Shows employees' FMLA activity and balances.
Changes to this Document
11/11/11 Clarified that report 537 can be run in the edit mode prior to running the final report.
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy