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.

Claims runs
Plan deposits
Sage Intacct
Bank activity
Chase
Plan rules
Match plans
Funding need
Bank match
Review queue
Microsoft Excel

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.

Next claims payment cyclePLAN-1042 · As of Nov 10
Payment run · Nov 12
BAT-112Medical claims ACH
$160K
BAT-113Medical claims check run
$92K
Claims due$252K
Additional sponsor funding$210K
Available plan cash
$42K
Sponsor cutoff
Nov 11, 3 pm PT
DEP-109 · $60K expected
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.

Prior claims payment batchBAT-107
$176K
Chase
Cleared bank activityBNK-807 · Nov 7
$168K
$8K openFinance · Trace payment

Reconcile partial claims payments
Match each payment batch to its bank reference and value date. Assign any uncleared balance to finance for follow-up.

Restricted claims detailMember records stay with authorized reviewers
Plan totals only
Sponsor funding noticePLAN-1042 · Draft
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.

Explore the platform

Measure the funding and reconciliation cycle

Advance notice

More time
to fund

Track how much notice each sponsor gets before the funding cutoff and flag requests that miss it.

Bank clearance

Open items
with owners

Track uncleared claims dollars and days open by plan, bank reference and follow-up owner.

Close support

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

Chase

Bank activity and plan rules

Bank references and value dates Funding cutoffs by plan

Claims funding and reconciliation in your approved environment

  1. 1Match plan and reference IDs
  2. 2Project funding by cutoff
  3. 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

Review private cloud deployment

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
Claims batches
Sponsor deposits
ChaseBank activity
Sage Intacct
Plan cash balance
Funding cutoffs
Microsoft Excel
Claims funding reviewPLAN-1042 · As of Nov 10
For review
Funding due · Nov 11, 3 pm PT$210K
Prior batch open$8K
Payment run Nov 12 · USD $K
ItemAmountBasis
BAT-112 · Medical claims ACH160Approved
BAT-113 · Medical claims check run92Approved
Available plan cash−42Cleared
Additional funding due210By cutoff
Pending deposit DEP-109 · Not cleared60Excluded
Finance approval required
Learn

Map your funding cycle

Map sponsor deposits, claim batches, bank cutoffs and who owns the review.

Design

Set plan cutoffs and access

Set each plan’s funding cutoff and decide who can access detailed claims.

Automate

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.

We’ll use your information to respond to your request. Privacy Policy