Till Reconciliation Calculator

Work out till reconciliation instantly with clear inputs, formula shown and shareable results.

About Till Reconciliation Calculator

Till reconciliation compares counted cash with expected cash: opening float plus recorded cash sales less refunds and payouts. Expressing the variance as a percentage of cash sales is what distinguishes a routine rounding difference from a genuine control failure.

Formulas

Expected cash

Expected = Opening float + Cash sales recorded - Refunds and payouts

Variance

Variance = Cash counted - Expected cash

Worked example

With the default values below, Till Reconciliation Calculator returns Till variance of $0.00. Change any input above and every figure here is recalculated in your browser.

Inputs used

Opening float: 5,000
Cash counted at close: 68,400
Cash sales recorded in the point of sale: 64,200
Cash refunds and payouts: 800

Results

Till variance: $0.00
Expected cash at close: $68,400.00
Variance as % of cash sales: 0.0000%
Status: Balanced

Step by step

1Values used
2Expected cash
3Variance
4Till variance= 0.00
5Expected cash at close= 68,400.00
6Variance as % of cash sales= 0.0000
7Status= Balanced

Assumptions and limits

The result is derived only from the 4 inputs listed above. Anything not among them is not part of the calculation.
In particular, this calculator does not take inflation, tax, fees or charges or compounding frequency into account.
Figures are rounded for display to 4 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.

How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.

Frequently Asked Questions

What variance tolerance is reasonable?

Typically within 0.05% of cash sales or a small absolute amount, whichever is greater. Persistent one-directional variance is the real warning sign.

Why do overages also matter?

Because they indicate the same loss of control as shortages — usually miskeyed transactions or change errors — and can mask offsetting shortages.