Schedule H Quarterly Vendor Reconciliation Report.xlsx

This document is a Schedule H Quarterly Vendor Reconciliation Report associated with Request for Proposal No. 250000003097, appearing to be related to a health plan administrative data tracking initiative. The spreadsheet is designed for health plan administrators to provide 24 months of comprehensive data validation, covering employees/subscribers/contract owner members and their corresponding enrollment and payment metrics across medical, pharmacy, dental, and vision services. The reporting template spans a two-year period from January 2023 through December 2024, with monthly columns for tracking key performance indicators and reconciliation data.

The report template allows for detailed quarterly tracking of member enrollment and financial information, enabling precise monitoring of health plan participation and associated costs. While specific pricing terms, funding sources, or precise contract details are not explicitly outlined in this document, the structured format suggests a systematic approach to vendor performance evaluation and reconciliation. The spreadsheet is marked as "Informational only" and indicates that bidders should not complete or submit the form with their proposal, implying it is a reference tool for potential contractors to understand the expected reporting requirements for the health plan contract.