Claims paid
Month-end
plan reporting
Mage matches paid claims, sponsor funding and fees by plan, then prepares a reconciled workbook for finance to review.
Deposits
Plan fees
Ledger
Match plan
Compare
Check totals
Plan report
Open items
Know what changed before the sponsor review
Match claims payments, sponsor deposits and fees to the right plan and month, then explain the change on a consistent cash basis.
Plan cash bridgePLAN-014 · USD thousands · Paid basis
+$8KOct net movement
Opening cashOpen207
Funding receivedFunds+1,320
Claims paidClaims−1,248
Fees paidFees−64
Closing cashClose215
Explain the change in plan cash
Show how sponsor funding, paid claims and fees add up to the cash the plan carries into the next month.
Posted bank receiptsBNK-R02 · USD
$1,338KMatched to plan$1,320KPLAN-014 · Oct funding
Held for review$18KDEP-382 · Missing plan ID
Hold unmatched deposits
Keep deposits without a plan reference out of funding totals and send them to treasury for review.
Claims registerCLM-R03$1,248KLedger controlGL-R02$1,248KClaims paid · report lineSame plan, cutoff and paid basis
$1,248KTrace claims to the ledger
Tie paid claims to the register and ledger control, and keep approved source revisions with the report.
Make each sponsor’s month-end close easier to review
Quicker
plan close
Measure hours from the last claims or bank file to a plan workbook ready for finance review.
Sponsor
variances
Track which questions about funding, paid claims and fees finance can answer from the workbook and its source records.
Unassigned
funding
Track the dollar value and age of sponsor deposits held before releasing each plan report.
How Mage fits
Keep plan reporting within your data controls
Report plan funds separately from administrator revenue using your existing claims, banking and accounting records. For workflows subject to HIPAA, agree on private cloud deployment, data access and any required agreements with your security team before using protected health information.
Your systems
Claims payments
Paid batches and posting dates
Bank and fee records
Sponsor deposits, fees and statement references
Plan ledger
Opening balance, controls and reporting rules
The workflow behind each sponsor report
- 1Match plans and periods
- 2Check against controls
- 3Explain monthly changes
Prepared for finance
Plan financial report
Claims paid, sponsor funding and fees by month
Source basis
Approved revisions and reconciled control totals
Open items
Held receipts and assigned review owners
Finance approves the close.
Give finance a reconciled workbook for every plan close
We build the workbook around your plan IDs, funding cutoff and ledger checks so finance can review the close before it goes to sponsors.
Explore all solutionsCedar GateBank receipts
Fee scheduleSage ledgerClose rules
Plan financial reportPLAN-014 · Oct 2026 close
For reviewClosing plan cash$215K
Deposit held$18K
| Plan cash | Sep | Oct | Change |
|---|---|---|---|
| Opening cash | 176 | 207 | +31 |
| Funding received | 1,235 | 1,320 | +85 |
| Claims paid | 1,150 | 1,248 | +98 |
| Fees paid | 54 | 64 | +10 |
| Net movement | 31 | 8 | −23 |
| Closing plan cash | 207 | 215 | +8 |
- Net movement change
- −$23K
- Excluded from funding
- DEP-382
Source basis
- CLM-R03
- BNK-R02
- FEE-R01
- GL-R02
Plan summarySource basisOpen items
Learn
Map the close
Map paid claims, cleared sponsor deposits and paid fees to the same plan and cutoff.
Design
Set close rules
Agree on plan IDs, ledger checks and who reviews receipts without a plan reference.
Automate
Build the report
Build a sponsor workbook with checked cash totals, explained variances and holds.
Scope your month-end plan report
Tell us how finance matches paid claims, sponsor deposits and fees to each employer plan, and what access and deployment controls your team requires.