Settlements & reconciliation

A claim won't reconcile

When a claim and its credit note don't tie out in ClaimDS, 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. Left unresolved, gaps like these are exactly how rebate claims slip through the cracks.

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.