Sample 60-day pilot reconciliation report
This is what a center receives during the pilot: the baseline reconciliation table, the ranked follow-up list, and the day-60 scorecard. Every center, child reference, voucher, and dollar figure on this page is synthetic. Synthetic and illustrative. Not representative of typical financial results.
The center is “Example Center (synthetic)” and the rows were designed so every reconciliation status appears once. A real report carries your records, your identifiers, and your period.
Baseline reconciliation · Example Center (synthetic) · one month
One row per child-authorization for the baseline period, plus any payment line that matched no record.
| Ref | Voucher / auth | Care level / rate | Units auth. | Units attended | Copay | Expected $ | Billed $ | Reimbursed $ | Difference | Status | Likely cause | Action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A-01 | AUTH-SAMPLE-01 | Toddler / $38 day | 20 | 20 | $40 | $720 | $720 | $720 | $0 | Matched | Paid as expected | None needed |
| A-02 | AUTH-SAMPLE-02 | Preschool / $34 day | 20 | 18 | $50 | $562 | $562 | $528 | -$34 | Short-paid | 2 absences over the cap | Documented follow-up sent; awaiting response |
| A-03 | AUTH-SAMPLE-03 | Infant / $42 day | 22 | 22 | $0 | $924 | $924 | none yet | -$924 | Pending | No payment line this remittance | Track on the next payment report |
| PAY-0003 | AUTH-SAMPLE-99 | Not on the ledger | n/a | n/a | n/a | n/a | n/a | $310 | +$310 | Unmatched | No claim record matches this payment line | Identify the source record with the agency reference |
| A-04a / A-04b | CASE-SAMPLE-04 | Toddler / $38 day | 38 | 38 | $76 | $1,368 | $1,368 | $684 | -$684 | Ambiguous | One household payment, two candidate children | Assign with the case reference before posting |
| A-05 | AUTH-SAMPLE-05 | School age / $28 day | 15 | 12 | $30 | $306 | $306 | $420 | +$114 | Potential overpayment or recoupment review | Paid above the expected amount | Hold and review with the agency before relying on it |
Status key: Matched · Unmatched · Ambiguous · Pending · Short-paid · Potential overpayment or recoupment review.
Summary, kept separate
Short-paid $34 + unmatched $310 + overpayment review $114
Documented follow-up on the short-paid and unmatched lines
Confirmed on the following remittance after a documented action
A count of corrected records, not a dollar amount
Confirmed received counts only dollars confirmed received after a documented action; it does not claim the action was the sole cause of payment. Identified dollars are not a promise of recovery. The pending $924 and the ambiguous $684 are tracked separately until they land in one of the four measures.
Day-60 scorecard (synthetic)
| Measure | Value | Method |
|---|---|---|
| Dollars identified | $458 across 3 lines | Short-paid $34 + unmatched $310 + overpayment review $114 |
| Dollars actioned | $344 | Documented follow-up on the short-paid and unmatched lines |
| Dollars confirmed received | $34 | Confirmed on the following remittance after a documented action |
| Record corrections completed | 2 | A count of corrected records, not a dollar amount |
| Voucher-risk cases flagged for review | 1 | Configured absence threshold; flagged, not prevented |
| Days to close the month | 12 to 4 | Center-reported baseline vs pilot-period observation; estimated, not independently audited |
| Recommended next workflow | Remittance review cadence | Documented in the follow-up list |