Settlements & reconciliation

A claim won't reconcile

When a claim and its credit note don't tie out in ClaimDS, here's how to find the difference — a quantity gap, a price change or a missing document — and clear it.

A line that won't reconcile is ClaimDS doing its job — it's refusing to let a claim and a credit note that disagree quietly settle anyway. Clearing it is a matter of finding why they disagree and then either correcting the data or recording the difference properly.

Why a line doesn't tie out

Reconciliation compares a claim to the credit-note line meant to settle it. When they don't match, it's almost always a quantity difference, a price difference, or a document that's missing or attached to the wrong line. The sheet flags the line so it can't slip through.

How to resolve it

Follow the steps below. The principle: correct genuine data errors at source, but record genuine commercial differences as their own claim — never force a match. For the full reconciliation flow, see Reconcile a claim to a credit note.

How to resolve it

  1. Open the exception on the sheet

    On the reconciliation sheet, find the line that isn't tying out — it's flagged by its state colour — and open it. ClaimDS shows the claim amount alongside the credit-note amount so the gap is visible.

  2. Identify the kind of difference

    Most mismatches are one of three things — a quantity difference (the claimed and settled quantities differ), a price difference (the rate changed), or a missing or wrong document. Read the line to see which one applies.

  3. Correct a data difference

    If the claim or credit-note figure is simply wrong, correct it at source so both sides agree. Because ClaimDS reconciles against the underlying records, fixing the source clears the exception cleanly.

  4. Raise a genuine difference as its own claim

    If the difference is real — a short-claim or a price adjustment that genuinely changed the amount — raise it as its own claim rather than forcing the line to match. That keeps the trail honest and settles the right figure.

  5. Re-check and confirm the sheet

    Once the line ties out, confirm the sheet. The reconciled amount becomes the figure Settlement uses, so the difference never silently flows into a payout or your GST returns.

Frequently asked

Should I just edit the number so it matches?

Only if the number was genuinely wrong. If the amounts differ for a real reason, raise that difference as a claim — overwriting it hides a problem that will resurface at settlement or in your returns.

Where do I see everything still open across principals?

The Expected settlements view under Reconciliation gives a principal-aging picture of what's still outstanding, so unreconciled differences don't get lost.

Still stuck?

Book a demo and we'll walk through it on your own data — or just talk to us.

A claim won't reconcile — ClaimDS