Schedule K Sample Claims Report and Invoice Format.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Behavioral Health and Substance Use Disorder Benefits Admin
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

File Type Posted
Schedule L Disruption Analysis.xlsx XLSX spreadsheet
Schedule B Pricing.xlsx XLSX spreadsheet
Schedule N SLA Report Format.xlsx XLSX spreadsheet
Schedule E Data Security Requirements.docx DOCX document
Schedule H2 GeoAccess Retirees.xlsm XLSM spreadsheet
Schedule H1 GeoAccess Actives.xlsm XLSM spreadsheet
Schedule M4 Claims Repricing Retiree FY2025.xlsx XLSX spreadsheet
Schedule J Service Availability.xlsx XLSX spreadsheet
Exhibit 2 to Schedule E HIPAA BAA.docx DOCX document
Schedule I HIPAA 834 File Layouts.pdf PDF
Schedule D Service Level Agreement for Hybrid.docx DOCX document
Schedule M2 Claims Repricing Active FY2025.xlsx XLSX spreadsheet
Hybrid Contract Terms.docx DOCX document
Schedule M1 Claims Repricing Active FY2024.xlsx XLSX spreadsheet
Proposal Instruct Vendor Questions Wksht.docx DOCX document
Schedule M3 Claims Repricing Retiree FY2024.xlsx XLSX spreadsheet
Schedule F Plan Designs.pdf PDF
Schedule G Section 2 Software Table.xlsx XLSX spreadsheet
Schedule C Insurance Requirements.docx DOCX document
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 date5/12/26(must date invoice and include range covered, weekly, bi-weekly or monthly, as appropriate)
Invoice period5/3/2026 - 5/9/2026
InvoicingTotal ClaimsTotal AdminTotal 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 ClaimsTotal 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 FeesTotal 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 TaxesTotal 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, 2026Claims less than one yearClaims 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 DatePrior10/01/2511/01/2512/01/2501/01/2602/01/2603/01/2604/01/2605/01/2606/01/2607/01/2608/01/2609/01/26
Period10/31/2511/30/2512/31/2501/31/2602/28/2603/31/2604/30/2605/31/2606/30/2607/31/2608/31/2609/30/26Total 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 .