Online Tool Store
Till Reconciliation Sheet
Till Reconciliation Sheet keeps cash and card separate, because a combined variance never tells you where to look. Runs entirely in your browser with no upload.
🔒 This tool runs entirely in your browser. Your files are never uploaded to a server.
Finance
Till Reconciliation Sheet
Frontend preview — no upload or external service.
Reconciliation
Counted cash 758.00 less a 150.00 float gives 608.00 against 612.40 expected — a 4.40 shortfall, small enough to be change error rather than anything else.
How the Till Reconciliation Sheet works
- Count by denomination rather than totalling notes and coins loosely; the denomination breakdown is what makes a recount fast.
- Deduct the opening float before comparing against expected takings.
- Record the variance every day, even when it is zero. A pattern in the variances is far more informative than any single day.
The method
Cash variance is counted cash less the float, compared against expected cash takings.
variance = (counted cash - float) - expected cash takings
Card and voucher totals should be reconciled separately, since mixing them hides which channel a discrepancy came from.
FAQ
What variance is acceptable?
Small and random, in both directions. A business should set its own threshold, and what matters more is the pattern — consistent shortfalls in one direction are a process problem, not rounding.
Why count by denomination?
Because it makes recounting fast and errors visible. A single total gives you nothing to check against when the figure is wrong, and recounting from scratch takes far longer.
Should card takings be in the same reconciliation?
Recorded, but separately. Mixing them hides which channel a discrepancy came from, and card totals reconcile against the terminal's own report rather than a physical count.
How we compare
| Feature | Online Tool Store | A spreadsheet | An advisor consultation |
|---|---|---|---|
| Denomination breakdown | ✓ | Total only | ✓ |
| Separates cash and card | ✓ | ✓ | Sometimes |
| No sign-up | ✓ | ✗ | ✗ |
| Nothing uploaded | ✓ | ✗ | ✗ |
Till Reconciliation Sheet keeps cash and card separate, because a combined variance never tells you where to look.