RFP_5800_SLW3033_ATT_5_v1.xlsx

This is a Financial Reconciliation Ledger for the City of Austin documenting worker's compensation transactions (TIBS - Texas Injury Benefit System) processed between May 31, 2026, and June 5, 2026. The ledger covers payments distributed across multiple City of Austin departments, including the Police Department, Fire Department, Austin Energy, Austin Water Utility, Fleet Services, Emergency Medical Services, Austin Resource Recovery, Transportation and Public Works, Aviation, Parks & Recreation, Development Services Department, Animal Services, Austin Transportation, and Watershed Protection & Development. The report tracks 134 total transactions comprising 127 payments and 7 reversals, with transaction dates ranging from June 1 through June 5, 2026.

The ledger records individual employee claims with corresponding loss dates, claim durations, payment methods (VPay, VPay-EFT, and Check), and claim amounts ranging from $1.45 to $4,876.00. Payment statuses include active duty, limited duty status (typically 40 or 53 hours per week), no duty status, and waiting periods. The total value of all transactions is $75,852.85, with voided transactions totaling $5,343.35 and active payments representing the remainder. The document indicates this relates to the City's workers' compensation third-party administration service procurement, which the City seeks to source from qualified third-party administrator firms with public sector experience.