Calculate claims
funding gaps
Use approved claims and cleared cash to show sponsors how much to fund and by when. Match payments to bank activity and flag what’s still open.
Follow each plan from funding notice to bank clearance
For administrators of self-funded health plans. Use each plan’s funding cutoff and cleared cash to prepare the sponsor request, then match claims payments by bank reference and value date.
- Available plan cash
- $42K
- Sponsor cutoff
- Nov 11, 3 pm PT
Excluded until cleared
Calculate what the sponsor needs to fund
Total approved ACH and check runs. Subtract cleared plan cash and show the sponsor how much is due before the funding cutoff.
Reconcile partial claims payments
Match each payment batch to its bank reference and value date. Assign any uncleared balance to finance for follow-up.
- Amount due
- $210K
- Funding cutoff
- Nov 11, 3 pm PT
Send sponsors plan totals only
Prepare the plan ID, funding amount and cutoff for sponsor review. Keep claim-level details within approved access controls.
Measure the funding and reconciliation cycle
More time
to fund
Track how much notice each sponsor gets before the funding cutoff and flag requests that miss it.
Open items
with owners
Track uncleared claims dollars and days open by plan, bank reference and follow-up owner.
Traceable
plan cash
Track time to tie each plan’s month-end cash balance to posted sponsor deposits and claims disbursements.
How Mage fits
Run the workflow within your approved data boundary
Review a private cloud deployment with your security team. Start with plan and batch totals. Before processing protected health information, confirm the permitted records, access controls, safeguards and required business associate agreements.
Your systems
Claims batches
Approved ACH and check runs Plan IDs and payment dates
Sponsor funding
Funding requests and deposits Expected and cleared amounts
Bank activity and plan rules
Bank references and value dates Funding cutoffs by plan
Claims funding and reconciliation in your approved environment
- 1Match plan and reference IDs
- 2Project funding by cutoff
- 3Check bank clearance
Prepared for review
Funding notice
Plan ID, amount and cutoff for finance to approve
Bank reconciliation
Deposits and payments matched to cleared activity
Exception register
Open amount, source record and follow-up owner
Finance reviews the exceptions and approves notices before they go to sponsors.
Give finance a claims funding workbook
Start with one self-funded plan. Reconcile the sponsor request, bank match register and open exceptions against finance’s records before using production data.
Explore all solutions| Item | Amount | Basis |
|---|---|---|
| BAT-112 · Medical claims ACH | 160 | Approved |
| BAT-113 · Medical claims check run | 92 | Approved |
| Available plan cash | −42 | Cleared |
| Additional funding due | 210 | By cutoff |
| Pending deposit DEP-109 · Not cleared | 60 | Excluded |
Map your funding cycle
Map sponsor deposits, claim batches, bank cutoffs and who owns the review.
Set plan cutoffs and access
Set each plan’s funding cutoff and decide who can access detailed claims.
Validate one payment cycle
Use sample data to check funding forecasts and bank matches before launch.
Talk through your claims funding workflow
Tell us how you prepare funding notices and reconcile claims payments today. We’ll review your source systems, timing rules and HIPAA deployment requirements with you.