Schedule K Sample Claims Report and Invoice Format.xlsx
XLSX spreadsheet 27 KB Posted
- Solicitation number
- RFP 171 260000002410 2
- Issued by
- Michigan
About this file
This file contains invoice and claims reporting templates for Behavioral Health and Substance Use Disorder (BH/SUD) Benefits administration under RFP No. 260000002410 for the State of Michigan's State Health Plan PPO. The document provides standardized formats for regular invoicing, quarterly reporting, and year-end financial reporting that vendors must follow when billing for BH/SUD services. Regular invoices must include the invoice date, invoice period (weekly, bi-weekly, or monthly), and itemized breakdowns of total claims, administrative fees, and applicable taxes across five benefit categories: Actives, COBRA (including Active & Retiree COBRA), SERS, SPRS, JRS, and MRS. The templates specify that Applied Behavior Analysis (ABA) cases must be identified separately, and all claims taxes must be reported separately and rolled up to quarterly and year-end reports.
Quarterly and year-end reporting requirements include comprehensive claims reports, administrative fee summaries, claims tax documentation, and an estimated liability report for incurred but unpaid claims segregated by claims less than one year and claims greater than one year. The document also includes a claims lag report template that tracks incurred claims by month and their corresponding paid dates over a twelve-month period, enabling analysis of payment timing patterns. Actives and retiree data must be submitted monthly in separate sections. These reporting and invoicing formats establish the financial accounting framework for the BH/SUD benefits administration contract and ensure consistent, detailed tracking of all claims and administrative costs across all covered populations.
View the file
Other files
Show all 19
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
Regular Invoicing
| Schedule K Sample Claims Report and Invoice Format | |||
| RFP No. 260000002410 | |||
| Behavioral Health and Substance Use Disorder Benefits (BH/SUD) for State Health Plan PPO | |||
| Regular Invoicing Sample Format | |||
| Invoice date | 5/12/26 | (must date invoice and include range covered, weekly, bi-weekly or monthly, as appropriate) | |
| Invoice period | 5/3/2026 - 5/9/2026 | ||
| Invoicing | Total Claims | Total Admin | Total Tax* |
| Actives | $ - 0 | $ - 0 | $ - 0 |
| COBRA (includes Active & Retiree COBRA) | $ - 0 | $ - 0 | $ - 0 |
| SERS | $ - 0 | $ - 0 | $ - 0 |
| SPRS | $ - 0 | $ - 0 | $ - 0 |
| JRS | $ - 0 | $ - 0 | $ - 0 |
| MRS | $ - 0 | $ - 0 | $ - 0 |
| Total | $ - 0 | $ - 0 | $ - 0 |
| * Claims taxes must be reported separately where applicable. These must then roll up to quarterly and year end reports. |
| **ABA cases must be identified separately. |
&"Arial,Bold"&9&K0070C0STATE OF MICHIGAN&K01+000 RFP No. 190000000717 Schedule H - Sample Claims report and Invoice Format
Quarterly and Year-end
| Sample SOM Insurance Quarterly and Year-end Claims Invoice Report | |
| Reporting period | |
| Paid Claims | Total Invoiced 10/1/25 - 9/30/26 |
| Actives | $ - 0 |
| COBRA (includes Active & Retiree COBRA) | |
| SERS | $ - 0 |
| SPRS | $ - 0 |
| JRS | $ - 0 |
| MRS | $ - 0 |
| Total | $ - 0 |
| (should match | |
| invoice totals | |
| billed and paid | |
| for the period) | |
| Administrative Fees | Total Admin 10/1/25 - 9/30/26 |
| Actives | $ - 0 |
| COBRA (includes Active & Retiree COBRA) | |
| SERS | $ - 0 |
| SPRS | $ - 0 |
| JRS | $ - 0 |
| MRS | $ - 0 |
| Total | $ - 0 |
| (should match admin totals on invoices for the period) |
| Claims Taxes | Total Tax 10/1/25 - 9/30/26 |
| Actives | $ - 0 |
| COBRA (includes Active & Retiree COBRA) | |
| SERS | $ - 0 |
| SPRS | $ - 0 |
| JRS | $ - 0 |
| MRS | $ - 0 |
| Total | $ - 0 |
| (should match applicable tax totals on invoices for the period) |
(For year end only) Estimated Liability for Incurred but Unpaid Claims
| as of September 30, 2026 | Claims less than one year | Claims greater than one year | |
| Actives | $ - 0 | $ - 0 | |
| COBRA (includes Active & Retiree COBRA) | $ - 0 | $ - 0 | |
| SERS | $ - 0 | $ - 0 | |
| SPRS | $ - 0 | $ - 0 | |
| JRS | $ - 0 | $ - 0 | |
| MRS | $ - 0 | $ - 0 | |
| Total | $ - 0 | $ - 0 |
Quarterly and Year End Financial Reporting
Lag Report
| Sample Claim Lag Report | |
| Incurred Claims 10/01/25 through 09/30/26 | |
| Vendor: | Actives and Retiree data must be submitted monthly in two separate sections or tabs |
Shaded area to include applicable values
| Incurred Date | ||||||||||||||
| Paid Date | Prior | 10/01/25 | 11/01/25 | 12/01/25 | 01/01/26 | 02/01/26 | 03/01/26 | 04/01/26 | 05/01/26 | 06/01/26 | 07/01/26 | 08/01/26 | 09/01/26 | |
| Period | 10/31/25 | 11/30/25 | 12/31/25 | 01/31/26 | 02/28/26 | 03/31/26 | 04/30/26 | 05/31/26 | 06/30/26 | 07/31/26 | 08/31/26 | 09/30/26 | Total Paid |
| 10/01/24 - 10/31/24 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| 11/01/24 - 11/30/24 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 12/01/24 - 12/31/24 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||
| 01/01/25 - 01/31/25 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||
| 02/01/25 - 02/28/25 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| 03/01/25 - 03/31/25 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| 04/01/25 - 04/30/25 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| 05/01/25 - 05/31/25 | $0 | $0 | $0 | $0 | $0 | |||||||
| 06/01/25 - 06/30/25 | $0 | $0 | $0 | $0 | ||||||||
| 07/01/25 - 07/31/25 | $0 | $0 | $0 | |||||||||
| 08/01/25 - 08/31/25 | $0 | $0 | ||||||||||
| 09/01/25 - 09/30/25 | $0 | |||||||||||
| 10/01/25 - 10/31/25 | $0 | |||||||||||
| 11/01/25 - 11/30/25 | $0 | |||||||||||
| 12/01/25 - 12/31/25 | $0 | |||||||||||
| 01/01/26 - 01/31/26 | $0 | |||||||||||
| 02/01/26 - 02/28/26 | $0 | |||||||||||
| 03/01/26 - 03/31/26 | $0 | |||||||||||
| 04/01/26 - 04/30/26 | $0 | |||||||||||
| 05/01/26 - 05/31/26 | $0 | |||||||||||
| 06/01/26 - 06/30/26 | $0 | |||||||||||
| 07/01/26 - 07/31/26 | $0 | |||||||||||
| 08/01/26 - 08/31/26 | $0 | |||||||||||
| 09/01/26 - 09/30/26 | $0 |
Total $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Lag Report State of Michigan
2019 MCSC BH/SA RFP
File details come from the government source that posted it. Updated .