22-Payments by Month 0825.xlsx

XLSX spreadsheet 24 KB Posted

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

About this file

This document is a detailed payments spreadsheet from UnitedHealthcare for Fort Bend Independent School District (FBIDS), covering medical and administrative payments from January through August 2025. The spreadsheet tracks various payment categories including medical, all other payments, and capitation payments across multiple plan options and population segments, with a total payment volume of approximately $13,306,059 during the tracked period.

The payment breakdown reveals granular financial details for different plan classifications (labeled A through AI), with medical payments constituting the largest expense category. The document appears to be supporting documentation for a stop loss insurance contract, which aligns with the related state and local contract opportunity describing FBIDS's solicitation for stop loss insurance services. The payment data suggests a comprehensive administrative services arrangement with UnitedHealthcare, demonstrating monthly variations in medical and administrative expenses across different plan options and population segments.

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
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
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
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
23-Payments By Month 1223.xlsx XLSX spreadsheet
24-Payments By Month 1224.xlsx XLSX spreadsheet
8-Vendor Acknowledgement Form.pdf PDF
9-CIQ Forms-Updated 8.14.25.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

Text version

Cover Page

Payments by Month
September 16, 2025

Customer Name: Fort Bend Independent School District

Member Group ID: 000902915 902915

Originating Member Group Contract ID: 902915

All Filter Details: Report Filter:

{Benefit Type Category}=Dental Benefit, Managed Pharmacy Benefit, Medical Benefit, Vision Benefit, HRA Benefit - Medical, HRA Benefit - Pharmacy, Physician, Outpatient Facility, Pharmacy, Inpatient Facility, Unknown, HRA/HSA/FSA Benefit And {Member Group ID}=000902915 - Fort Bend Independent School District And {Book Year/Month}=2025-08, 2025-07, 2025-06, 2025-05, 2025-04, 2025-03, 2025-02, 2025-01 And {Funding Arrangement Category}=Administrative Services Only

Report Limits:

{All Other Payments} <> 0 Or {Dental Payments} <> 0 Or {Vision Payments} <> 0 Or {Medical Payments} <> 0 Or {Pharmacy Payments} <> 0 Or {Total Payments} <> 0 Or {Capitation Payments} <> 0

Prompt 1: SELECT A MEMBER GROUP ID {Member Group ID}=000902915 - Fort Bend Independent School District Prompt 2: SELECT A DATE TYPE Book Dates Prompt 3: ADD MORE DETAILS TO THIS REPORT Common Member Group ID, Common Member Group Contract ID Prompt 4: LIMIT THE REPORT'S CUSTOMER STRUCTURE

Prompt 5: LIMIT THE REPORT'S RESULTS.

Prompt 6: SELECT BOOK DATES 2025-08, 2025-07, 2025-06, 2025-05, 2025-04, 2025-03, 2025-02, 2025-01

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.

Payments by Month

Payments by Month
Common Member Group IDCommon Member Group Contract IDBook Year/MonthDental PaymentsCapitation PaymentsAll Other PaymentsMedical PaymentsVision PaymentsPharmacy PaymentsTotal Payments
902915A2025-01$0$0$0$3$0$0$3
2025-02$0$0$0($157)$0$0($157)
2025-06$0$0$0($2,036)$0$0($2,036)
2025-07$0$0$0($108)$0$0($108)
2025-08$0$0$0($48)$0$0($48)
Total$0$0$0($2,347)$0$0($2,347)
AA2025-02$0$0$0($432)$0$0($432)
Total$0$0$0($432)$0$0($432)
AB2025-02$0$0$0($182)$0$0($182)
Total$0$0$0($182)$0$0($182)
AC2025-01$0$0$122,140$1,292,321$0$0$1,414,461
2025-02$0$0$101,230$1,016,460$0$0$1,117,690
2025-03$0$0$107,485$1,469,962$0$0$1,577,447
2025-04$0$0$83,698$1,406,191$0$0$1,489,889
2025-05$0$0$61,129$1,207,367$0$0$1,268,496
2025-06$0$0$63,488$2,412,579$0$0$2,476,067
2025-07$0$0$57,355$2,479,976$0$0$2,537,330
2025-08$0$0$29,905$1,394,773$0$0$1,424,678
Total$0$0$626,429$12,679,630$0$0$13,306,059
AD2025-01$0$0$0$38$0$0$38
Total$0$0$0$38$0$0$38
AE2025-01$0$0$6,600$11,130$0$0$17,730
2025-02$0$0$3,855$3,770$0$0$7,625
2025-03$0$0$5,911$28$0$0$5,939
2025-04$0$0$4,517$2,167$0$0$6,684
2025-05$0$0$4,017$2,614$0$0$6,631
2025-06$0$0$3,497$1,592$0$0$5,089
2025-07$0$0$3,223$20,904$0$0$24,128
2025-08$0$0$1,618$314$0$0$1,932
Total$0$0$33,237$42,520$0$0$75,756
AF2025-01$0$0$8,466$1,210,645$0$0$1,219,111
2025-02$0$0$5,278$1,150,975$0$0$1,156,253
2025-03$0$0$3,937$904,430$0$0$908,367
2025-04$0$0$2,145$1,722,001$0$0$1,724,147
2025-05$0$0$3,409$788,713$0$0$792,122
2025-06$0$0$2,370$926,850$0$0$929,220
2025-07$0$0$2,444$1,657,719$0$0$1,660,162
2025-08$0$0$3,888$1,070,372$0$0$1,074,261
Total$0$0$31,938$9,431,705$0$0$9,463,643
AG2025-01$0$0$41,082$14,536$0$0$55,619
2025-02$0$0$28,647$10,083$0$0$38,730
2025-03$0$0$28,094$383$0$0$28,477
2025-04$0$0$28,332$4,395$0$0$32,727
2025-05$0$0$20,043$1,060$0$0$21,103
2025-06$0$0$22,325$1,587$0$0$23,912
2025-07$0$0$26,245$1,620$0$0$27,865
2025-08$0$0$12,593$257$0$0$12,850
Total$0$0$207,361$33,921$0$0$241,282
AI2025-01$0$0$24,973$12,976$0$0$37,949
2025-02$0$0$24,357$2,658$0$0$27,015
2025-03$0$0$24,827($4,147)$0$0$20,680
2025-04$0$0$18,567$4,399$0$0$22,966
2025-05$0$0$14,292($2,873)$0$0$11,419
2025-06$0$0$20,203$35,507$0$0$55,710
2025-07$0$0$11,851$81,261$0$0$93,112
2025-08$0$0$7,863$2,095$0$0$9,958
Total$0$0$146,933$131,876$0$0$278,809

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.

Payments by Month - Detail

Common Member Group IDMember Group IDCommon Member Group Contract IDCommon Plan Option IDCommon Population IDCommon Plan Option NameCommon Population NameCustomer Attribute 1Customer Attribute 2Customer Attribute 3Customer Attribute 4Book Year/MonthDental PaymentsCapitation PaymentsAll Other PaymentsMedical PaymentsVision PaymentsPharmacy PaymentsTotal Payments
902915000902915A001000000002025-02$0$0$0($157)$0$0($157)
902915000902915A001000000002025-06$0$0$0($2,036)$0$0($2,036)
902915000902915A001000100012025-08$0$0$0($49)$0$0($49)
902915000902915A004000400042025-01$0$0$0$3$0$0$3
902915000902915A004000400042025-07$0$0$0($108)$0$0($108)
902915000902915A004000400042025-08$0$0$0$1$0$0$1
902915000902915AA001000000002025-02$0$0$0($432)$0$0($432)
902915000902915AB001000000002025-02$0$0$0($182)$0$0($182)
902915000902915AC007000000002025-04$0$0$0$458$0$0$458
902915000902915AC007000100012025-01$0$0$0($583)$0$0($583)
902915000902915AC007000700072025-01$0$0$122,140$1,285,469$0$0$1,407,609
902915000902915AC007000700072025-02$0$0$101,230$1,017,755$0$0$1,118,985
902915000902915AC007000700072025-03$0$0$107,485$1,469,962$0$0$1,577,447
902915000902915AC007000700072025-04$0$0$83,698$1,405,734$0$0$1,489,432
902915000902915AC007000700072025-05$0$0$61,129$1,207,367$0$0$1,268,496
902915000902915AC007000700072025-06$0$0$63,488$2,412,579$0$0$2,476,067
902915000902915AC007000700072025-07$0$0$57,355$2,478,507$0$0$2,535,862
902915000902915AC007000700072025-08$0$0$29,905$1,393,205$0$0$1,423,109
902915000902915AC008000800082025-01$0$0$0$7,436$0$0$7,436
902915000902915AC008000800082025-02$0$0$0($8)$0$0($8)
902915000902915AC008000800082025-07$0$0$0$1,469$0$0$1,469
902915000902915AC008000800082025-08$0$0$0$1,568$0$0$1,568
902915000902915AC915000700072025-02$0$0$0($1,287)$0$0($1,287)
902915000902915AD009000900092025-01$0$0$0$38$0$0$38
902915000902915AE010001000102025-01$0$0$6,600$11,130$0$0$17,730
902915000902915AE010001000102025-02$0$0$3,855$7,993$0$0$11,848
902915000902915AE010001000102025-03$0$0$5,911$23$0$0$5,935
902915000902915AE010001000102025-04$0$0$4,517$2,192$0$0$6,709
902915000902915AE010001000102025-05$0$0$4,017$2,606$0$0$6,623
902915000902915AE010001000102025-06$0$0$3,497$1,592$0$0$5,089
902915000902915AE010001000102025-07$0$0$3,223$20,904$0$0$24,128
902915000902915AE010001000102025-08$0$0$1,618$314$0$0$1,932
902915000902915AE012001200122025-03$0$0$0$4$0$0$4
902915000902915AE012001200122025-04$0$0$0($4)$0$0($4)
902915000902915AE019001900192025-04$0$0$0($21)$0$0($21)
902915000902915AE019001900192025-05$0$0$0$8$0$0$8
902915000902915AE915001000102025-02$0$0$0($4,223)$0$0($4,223)
902915000902915AF013000000002025-02$0$0$0$373$0$0$373
902915000902915AF013001300132025-01$0$0$8,466$1,196,966$0$0$1,205,431
902915000902915AF013001300132025-02$0$0$5,278$1,134,062$0$0$1,139,340
902915000902915AF013001300132025-03$0$0$3,937$891,350$0$0$895,287
902915000902915AF013001300132025-04$0$0$2,145$1,718,059$0$0$1,720,204
902915000902915AF013001300132025-05$0$0$3,409$786,348$0$0$789,757
902915000902915AF013001300132025-06$0$0$2,370$846,035$0$0$848,405
902915000902915AF013001300132025-07$0$0$2,444$1,635,626$0$0$1,638,070
902915000902915AF013001300132025-08$0$0$3,888$1,038,532$0$0$1,042,420
902915000902915AF014001400142025-01$0$0$0$13,679$0$0$13,679
902915000902915AF014001400142025-02$0$0$0$16,655$0$0$16,655
902915000902915AF014001400142025-03$0$0$0$13,080$0$0$13,080
902915000902915AF014001400142025-04$0$0$0$3,943$0$0$3,943
902915000902915AF014001400142025-05$0$0$0$2,365$0$0$2,365
902915000902915AF014001400142025-06$0$0$0$80,815$0$0$80,815
902915000902915AF014001400142025-07$0$0$0$22,093$0$0$22,093
902915000902915AF014001400142025-08$0$0$0$31,840$0$0$31,840
902915000902915AF915001300132025-02$0$0$0($115)$0$0($115)
902915000902915AG015000000002025-01$0$0$0$131$0$0$131
902915000902915AG015001500152025-01$0$0$41,082$14,431$0$0$55,514
902915000902915AG015001500152025-02$0$0$28,647$21,233$0$0$49,880
902915000902915AG015001500152025-03$0$0$28,094$744$0$0$28,838
902915000902915AG015001500152025-04$0$0$28,332$4,401$0$0$32,733
902915000902915AG015001500152025-05$0$0$20,043$1,082$0$0$21,125
902915000902915AG015001500152025-06$0$0$22,325$1,587$0$0$23,912
902915000902915AG015001500152025-07$0$0$26,245$1,620$0$0$27,865
902915000902915AG015001500152025-08$0$0$12,593$257$0$0$12,849
902915000902915AG016001600162025-01$0$0$0($26)$0$0($26)
902915000902915AG016001600162025-02$0$0$0$15$0$0$15
902915000902915AG016001600162025-03$0$0$0($361)$0$0($361)
902915000902915AG016001600162025-04$0$0$0($6)$0$0($6)
902915000902915AG016001600162025-05$0$0$0($22)$0$0($22)
902915000902915AG016001600162025-08$0$0$0$0$0$0$0
902915000902915AG915001500152025-02$0$0$0($11,165)$0$0($11,165)
902915000902915AI020002000202025-01$0$0$24,973$13,015$0$0$37,988
902915000902915AI020002000202025-02$0$0$24,357$7,398$0$0$31,755
902915000902915AI020002000202025-03$0$0$24,827($4,120)$0$0$20,707
902915000902915AI020002000202025-04$0$0$18,567$4,394$0$0$22,962
902915000902915AI020002000202025-05$0$0$14,292($2,882)$0$0$11,411
902915000902915AI020002000202025-06$0$0$20,203$35,507$0$0$55,710
902915000902915AI020002000202025-07$0$0$11,851$81,261$0$0$93,112
902915000902915AI020002000202025-08$0$0$7,863$2,099$0$0$9,962
902915000902915AI021002100212025-01$0$0$0($39)$0$0($39)
902915000902915AI021002100212025-02$0$0$0$15$0$0$15
902915000902915AI021002100212025-03$0$0$0($27)$0$0($27)
902915000902915AI021002100212025-04$0$0$0$4$0$0$4
902915000902915AI021002100212025-05$0$0$0$9$0$0$9
902915000902915AI021002100212025-08$0$0$0($4)$0$0($4)
902915000902915AI915002000202025-02$0$0$0($4,755)$0$0($4,755)

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 .