24-Payments By Month 1224.xlsx

12 KB Posted

Attached to
Stop Loss Insurance
Solicitation number
RFP 26-023KB
Issued by
Fort Bend County, Texas

About this file

Written by GovTribe AI ·

The document is a confidential UnitedHealthcare payments spreadsheet for policy number 000902915, detailing monthly benefit payments across various benefit categories for the year 2024. The spreadsheet is related to a stop loss insurance solicitation by Fort Bend Independent School District in Texas, with payment data broken down by policy suffix (A, AA, AC, AD, AE, AF, AG, AI) and covering benefit types including medical, dental, vision, pharmacy, FSA, and HRA benefits.

The payment data reveals significant monthly variations, with total payments ranging from negative amounts to over $1.4 million per month across different policy suffixes. The policy appears to be structured under an Administrative Services Only (ASO) funding arrangement, with total payments for 2024 showing AC suffix payments at $16,452,536, AF suffix payments at $14,977,020, and other suffixes having varying payment levels. The document is marked as containing confidential and proprietary business information, with strict guidelines for handling and protecting the data.

View the file

Other files

File Type Posted
20-Membership Managed Ad Hoc 1223.xlsx XLSX spreadsheet
25-Fort Bend ISD 2025 Stop Loss RFP 26-023KB Data Exhibits.pdf PDF
6-General Provisions for Purchasing Solicitations and Contracts (3.3.25).pdf PDF
10-PRE-EMPLOYMENT OR PRE-SERVICE AFFIDAVIT FOR EDUCATIONAL ENTITIES.pdf PDF
15-Exhibit 5. Fort Bend ISD Kelsey UHC Charter Plan SBC 2025.pdf PDF
16-Exhibit 6. Fort Bend ISD Choice HSA Plan SBC 2025.pdf PDF
18-Exhibit 8. Fort Bend ISD Kelsey UHC Charter Plan SPD 2025.pdf PDF
22-Payments by Month 0825.xlsx XLSX spreadsheet
23-Payments By Month 1223.xlsx XLSX spreadsheet
8-Vendor Acknowledgement Form.pdf PDF
9-CIQ Forms-Updated 8.14.25.pdf PDF
12-Exhibit 2. Fort Bend ISD Stop Loss Policy.pdf PDF
13-Exhibit 3. Fort Bend ISD Stop Loss Policy Amendment.pdf PDF
17-Exhibit 7. Fort Bend ISD Choice HSA Plan SPD 2025.pdf PDF
2-Suspension and Debarment Certification.pdf PDF
21-Membership Managed Ad Hoc 1224.xlsx XLSX spreadsheet
7-Sample FBISD Agreement for Services FBISD (6.2.25).pdf PDF
1-Insurance Requirements.pdf PDF
11-Exhibit 1. Fort Bend ISD Stop Loss RFP Workbook RFP 26-023KB.xlsx XLSX spreadsheet
14-Exhibit 4. Fort Bend ISD Surest Plan SBC 2025.pdf PDF
19-Membership Managed Ad Hoc 0825.xlsx XLSX spreadsheet
26-RFP 26-023KB Stop Loss Scope of Work.pdf PDF
3-Form 1295 Instructions - How to Complete the Form.pdf PDF
4-EDGAR Certifications (2 CFR Section 200 REQUIRED PROVISIONS).pdf PDF
5-Sample DPA - Data Protection Agreement Addendum (v4.1).pdf PDF
Show all 25

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Payments By Month

Payments By Month
Report Filter:
({Benefit Type Category} = Dental Benefit, FSA Benefit, Managed Pharmacy Benefit, Medical Benefit, Vision Benefit, HRA Benefit - Medical, HRA Benefit - Pharmacy) And ({-Policy Number} = 000902915) And ({Book Year/Month} = 2024-12, 2024-11, 2024-10, 2024-09, 2024-08, 2024-07, 2024-06, 2024-05, 2024-04, 2024-03, 2024-02, 2024-01) And ({Funding Arrangement Category} = Administrative Services Only)
'-Policy NumberSuffixBenefit PaymentMedicalTotal
Book Year/MonthPaymentsPayments
000902915A2024-02($33,531)($33,531)
000902915A2024-04($12)($12)
000902915A2024-10($1,822)($1,822)
000902915A2024-11$904$904
000902915A2024-12($301)($301)
000902915ATotal($34,763)($34,763)
000902915AA2024-01$10,155$10,155
000902915AA2024-11($81)($81)
000902915AA2024-12$19$19
000902915AATotal$10,093$10,093
000902915AC2024-01$1,294,661$1,294,661
000902915AC2024-02$1,440,044$1,440,044
000902915AC2024-03$1,290,683$1,290,683
000902915AC2024-04$1,310,683$1,310,683
000902915AC2024-05$1,311,705$1,311,705
000902915AC2024-06$1,361,098$1,361,098
000902915AC2024-07$1,469,301$1,469,301
000902915AC2024-08$1,407,899$1,407,899
000902915AC2024-09$1,173,753$1,173,753
000902915AC2024-10$1,569,370$1,569,370
000902915AC2024-11$1,412,331$1,412,331
000902915AC2024-12$1,411,008$1,411,008
000902915ACTotal$16,452,536$16,452,536
000902915AD2024-08($47)($47)
000902915AD2024-10($57)($57)
000902915AD2024-12($156)($156)
000902915ADTotal($260)($260)
000902915AE2024-01$601,342$601,342
000902915AE2024-02$1,296,392$1,296,392
000902915AE2024-03$62,635$62,635
000902915AE2024-04($12,703)($12,703)
000902915AE2024-05($170)($170)
000902915AE2024-06$64,348$64,348
000902915AE2024-07$29,530$29,530
000902915AE2024-08$46,900$46,900
000902915AE2024-09$6,122$6,122
000902915AE2024-10$16,246$16,246
000902915AE2024-11($31,713)($31,713)
000902915AE2024-12$20,406$20,406
000902915AETotal$2,099,336$2,099,336
000902915AF2024-01$272,031$272,031
000902915AF2024-02$504,059$504,059
000902915AF2024-03$700,917$700,917
000902915AF2024-04$1,277,240$1,277,240
000902915AF2024-05$1,166,507$1,166,507
000902915AF2024-06$1,212,796$1,212,796
000902915AF2024-07$1,189,546$1,189,546
000902915AF2024-08$1,679,733$1,679,733
000902915AF2024-09$1,734,140$1,734,140
000902915AF2024-10$1,103,786$1,103,786
000902915AF2024-11$2,555,607$2,555,607
000902915AF2024-12$1,580,659$1,580,659
000902915AFTotal$14,977,020$14,977,020
000902915AG2024-01$1,496,519$1,496,519
000902915AG2024-02$201,763$201,763
000902915AG2024-03$55,730$55,730
000902915AG2024-04$121,017$121,017
000902915AG2024-05$291,749$291,749
000902915AG2024-06$89,827$89,827
000902915AG2024-07$133,912$133,912
000902915AG2024-08$31,763$31,763
000902915AG2024-09$34,747$34,747
000902915AG2024-10$73,181$73,181
000902915AG2024-11$36,691$36,691
000902915AG2024-12$24,957$24,957
000902915AGTotal$2,591,857$2,591,857
000902915AI2024-01$1,204,743$1,204,743
000902915AI2024-02$674,481$674,481
000902915AI2024-03$198,676$198,676
000902915AI2024-04($2,204)($2,204)
000902915AI2024-05$41,011$41,011
000902915AI2024-06($34,147)($34,147)
000902915AI2024-07$38,047$38,047
000902915AI2024-08($27,256)($27,256)
000902915AI2024-09$8,948$8,948
000902915AI2024-10$33,799$33,799
000902915AI2024-11$34,614$34,614
000902915AI2024-12($313)($313)
000902915AITotal$2,170,397$2,170,397
This document contains UnitedHealthcare’s confidential and/or proprietary business information (PBI). PBI may only be used by
the recipient person/entity to which it is addressed. Recipient is liable for using and protecting UnitedHealthcare’s PBI from
further disclosure or misuse, consistent with recipient’s contractual obligations under any applicable administrative services
agreement, group policy contract, non-disclosure agreement or other applicable contract or law, including but not limited to the
U.S. Freedom of Information Act and state freedom of information law exemptions for “trade secrets”. The document may also
contain protected health information (PHI) and must be handled according to applicable state and federal law, including, but not
limited to HIPAA. Recipients who misuse information may be subject to both civil and criminal penalties.

File details come from the government source that posted it. Updated .