Nothing you paste leaves this page. Parsing and matching happen in your browser.

How it works

A cash reconciliation has three parts: what you started with, what the receipts say went out, and what is physically there now. The expected balance is the float less the expenses; the variance is whatever the count fails to explain.

Counting by denomination rather than by running total is what makes this reliable. It gives a checkable figure that a second person can verify without recounting, and it makes miscounts obvious — a variance that happens to equal one note of a particular denomination almost always is exactly that.

Expected = opening float + top-ups − recorded expenses · Variance = counted − expected

  • Float — the cash the drawer or tin is supposed to hold
  • Counted — the sum of denomination × count
  • Variance — counted less expected — negative means cash is missing

Worked example

A 25,000 float with 18,450 of receipts and a counted drawer

Inputs

Float25,000
Top-ups10,000
Expenses18,450

Results

Expected16,550
Counted16,050
Variance−500

A 500 shortfall that happens to equal exactly one note — the classic signature of a miscount or a missing receipt rather than anything worse.

Frequently asked questions

How do I enter the count?

One line per denomination: the note or coin value, then how many of them you counted. The tool multiplies and totals, so nothing has to be added up by hand.

What variance is acceptable?

Ideally zero. Small recurring shortfalls usually mean receipts are not being kept rather than anything dishonest, but the fix is the same: tighten the receipt discipline before the amounts grow.

What if the variance matches one denomination exactly?

Recount that denomination first. A variance equal to a single note or a round multiple of one is far more often a counting error than a missing payment.

Is my ledger data uploaded anywhere?

No. Every line you paste is parsed and matched inside your browser. Nothing is transmitted to us, nothing is stored, and closing the tab discards it. That is the whole reason this tool exists in this form.

More in Reconciliation