Work a reconciliation sheet end to end
Upload a principal's settlement data, review the matches, decide each line, and let the sheet close — the full reconciliation workflow in ClaimDS.
Reconciliation is where a principal's settlement claims meet your records, line by line. Working a sheet is a matter of getting every line to a clean decision — and ClaimDS structures that so nothing settles until it's been accounted for.
The shape of the work
Upload brings the data in and auto-matches what it can; you then decide each line, resolving the matched ones, the unmatched ones, and anything you held. The line states — matched, held, approved, rejected, written-off — are the map of where each line is.
Work the sheet
Follow the numbered steps below. For the concept behind a single match, see reconcile a claim to a credit note; if a line won't tie out, see a claim won't reconcile.
Step-by-step
Upload the sheet
From Claims → Reconciliation, upload the principal's settlement data, usually from an Excel template. ClaimDS reads the rows and tries to match each one automatically against your open claims.
Review the automatic matches
Each row is either matched to a claim or left unmatched. Start by scanning what matched cleanly, then turn to the unmatched rows, which need your attention.
Decide each matched line
For a matched line, approve it (settle at the agreed amount), hold it for negotiation, or reject it. Approved and rejected are final.
Resolve the unmatched lines
For an unmatched line, match it to the right claim by hand and then decide it, or reject it if it doesn't belong.
Close out the held lines
For a line you held, once you've spoken with the partner, either approve it at the amount you agreed or write it off. Then the sheet has no undecided lines left.
Let the sheet close
When every line has reached a final state, the sheet closes on its own. ClaimDS produces the sheet's factsheet, and the approved lines flow on toward accrual and settlement.
Frequently asked
What does the sheet's factsheet capture?
A frozen, verifiable summary of the closed sheet — every line's final state and decision. It's tamper-evident, so it stands up as an audit record. See What is a factsheet.
Can I reopen a line after approving it?
No — approved, rejected and written-off are terminal states. That's deliberate, so the reconciliation trail can't be quietly changed after the fact.
Still stuck?
Book a demo and we'll walk through it on your own data — or just talk to us.