Schedule R Payment Discrepancy Report Template.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- HMO Services for MPSERS
- Solicitation number
- RFP 171 230000003226 2
- Issued by
- Michigan
About this file
This is a Schedule R Payment Discrepancy Report Template associated with RFP No. 230000003226, designed for use by MPSERS (Michigan Public School Employees' Retirement System) or a related entity to document and track payment discrepancies. The template serves as a standardized form for recording subscriber payment issues, with columns for capturing subscriber identifying information including name and social security number, member number, the month in which a discrepancy occurred, and detailed description or notes regarding the nature of the issue. The document includes fields for categorizing the type of discrepancy, noting the month for which an adjustment should be applied, recording the amount billed to a group, documenting the actual payment amount received, and tracking the remaining balance. The template also includes a column for MPSERS responses to reported discrepancies.
This reporting tool appears to be part of a payment reconciliation and audit process rather than a procurement of goods or services. The template facilitates systematic documentation and resolution of payment variances between billed amounts and actual payments received, enabling organizations to identify patterns, track corrections, and maintain accurate financial records related to subscriber accounts and group payments within the MPSERS system.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Schedule B Pricing.xlsx | XLSX spreadsheet | |
| Schedule I2 PPO Medicare Summary of Benefits.pdf | ||
| Schedule I4 Medicare Prescription Drug Summary of Benefits.pdf | ||
| Schedule F Definitions.docx | DOCX document | |
| Schedule G - Contractor Performance Evaluation Survey.doc | DOC document | |
| Schedule I1 PPO Non Medicare Summary of Benefits.pdf | ||
| Schedule K 834 Use Case and Example.docx | DOCX document | |
| Schedule M HMO Census Data REVISED.xlsx | XLSX spreadsheet | |
| Schedule J Dependent Coverage.pdf | ||
| Schedule P TRR Report Template.xlsx | XLSX spreadsheet | |
| Schedule L Benefit Comparison and Actuarial Attestation.xlsx | XLSX spreadsheet | |
| Schedule H HMO Benefits Summary and Claims Paid Data.xlsx | XLSX spreadsheet | |
| Schedule I3 Non-Medicare Prescription Drug Summary of Benefits.pdf | ||
| 230000003226 HMO Services RFP.docx | DOCX document | |
| Schedule N Section 2 Solutions Table.xlsx | XLSX spreadsheet | |
| 230000003226 Questions Answers.pdf | ||
| Schedule Q RFI Report Template.xlsx | XLSX spreadsheet |
Show all 17
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
Sheet1
| Schedule R Payment Discrepancy Report Template |
| RFP No. 230000003226 |
SUBSCRIBER NAME SSN MEMBER # MONTH OCCURRED DESCRIPTION/NOTES TYPE NOTES MONTH ADJ FOR AMOUNT BILLED GROUP PAYMENT AMOUNT BALANCE MPSERS RESPONSE
File details come from the government source that posted it. Updated .