Daily Takings & Till Reconciliation

What this tool does

CM8-113 is a daily takings and till reconciliation sheet for a shop, cafe, bar, salon or any other counter where cash still crosses it. You enter what the till says you sold, what you counted in the drawer and what went out of it; the tool works out how much cash should have been there and shows which days are far enough out to be worth explaining. It runs inside this one file, with no account and no network request of any kind, so takings, operators' names and banking references stay on your computer.

One record is one till, for one shift, on one day. Three tills counted at close is three records for that date. If a drawer is counted twice a day at changeover, record each count separately with its own float.

What to record each day

• Opening float — the cash put in the drawer before trading started.
• Cash counted at close — everything in the drawer when you finished, including the float. The figure people most often get wrong: enter it net of the float and every day looks short by exactly the float.
• Card takings — the terminal's own total for the same period, not the card figure the till reports. Where the two disagree, that gap is worth a separate look.
• Other tender takings — vouchers, gift cards, account sales, mobile and app payments. Anything neither cash nor card belongs here, or the cash figure will be wrong.
• Till reading — the Z-read or system total for all tenders together, not the cash element. Every derived figure hangs off it.
• Cash paid out, and the banked amount and reference — what left the drawer during trading, and what went to the bank with the slip or bag number that proves it.

How the reconciliation works

Three steps, all of them arithmetic you could do on paper. The tool shows each so anybody can check it.

The till reading is everything you sold. Take off the tenders that were not cash and what is left should have come across the counter as cash.

Add back the float you started with, take off anything paid out of the drawer, and that is what should be sitting there when you count.

A positive variance is an over: more cash than the till accounts for. A negative variance is a short. Both are errors. An over is not good news — it usually means a sale was never rung up, the same control failure as a short pointing the other way.

The percentage puts a variance in proportion. The same short means something very different on a quiet Tuesday than on your busiest day of the year.

Refunds, pay-outs and floats

Refunds are recorded for context and are not in the formula above. The tool assumes your till reading is already net of refunds, which is how most systems report. If yours reports gross sales with refunds shown separately, subtract them yourself before entering the till reading — otherwise every day with a cash refund will show as short by the amount refunded.

Pay-outs are the other frequent cause of a false short. Money taken from the drawer for a delivery, a taxi or a window cleaner has to be recorded here, with the receipt kept in the drawer until the count. A pay-out nobody wrote down is indistinguishable from missing cash.

Float top-ups are the mirror image and produce false overs: change added from the safe mid-shift without a record makes the drawer count high by exactly that amount. Record the top-up as part of the opening float and note it, or run a float sheet the count is checked against.

Setting a sensible tolerance

No till balances to zero every day, and chasing a small variance costs more than it recovers. The tool therefore flags a count only when it fails both tests you set:

The cash tolerance stops trivial amounts being escalated whatever the day's size. The percentage lifts the bar on a busy day, where a slightly larger variance is proportionately smaller and much more likely to be ordinary handling error. Set either to zero to rely on the other alone; set both to zero and every non-zero variance is flagged.

Reasonable starting points are a cash tolerance of about a fifth of your average transaction value and a half to one per cent of takings. Watch what actually gets flagged for a fortnight, then adjust. A tolerance that flags every day teaches people to ignore the flag; one that flags nothing is not a control at all.

Why the net figure lies

The net variance is the sum of every over and every short, so they cancel. Ten shorts of 20 and ten overs of 20 net to zero and look perfect, while 400 has moved in and out of your drawers unexplained. That is why the Net variance tile always shows the total absolute variance underneath it, and why the operator summary carries both columns.

Read them together. A net near zero with a small absolute total means your counting is genuinely tight. A net near zero with a large absolute total means it is loose in both directions — the condition in which a real loss hides unnoticed.

Reading a pattern — and what it never proves

A single variance is almost always a counting or keying error: two digits transposed, the wrong change given once, a card sale rung as cash, a bag of coin miscounted. Investigating one day in isolation usually wastes an hour and finds nothing.

What is worth attention is a pattern: the same till short most days, the same operator short across several tills, or shorts clustering on one shift. The per-till chart and the operator summary exist for exactly that, and the note field is there to record what you found.

The second-person check field records whether somebody other than the operator counted or verified the drawer. That, not this tool, is the control. A variance found by the person who created it is much weaker than one found by somebody else, and separating the two roles removes most of the awkward conversations before they start.

The usual causes of a variance

Before escalating anything, work down this list. It resolves most of them:

• The float was counted out of the closing cash, or topped up without a record.
• A pay-out was made and the receipt was lost or never entered.
• A card sale was keyed as cash, or the reverse — a large variance with a perfectly correct total, so check the tender split before you check the count.
• The card terminal total covers a different cut-off time from the till reading.
• A voucher or gift card was rung through as cash, or not recorded at all.
• Change was given from the wrong denomination, most often one note mistaken for another.
• A refund was given in cash but processed as a card refund, or never put through the till.
• Two tills share a drawer, or trade was moved between tills mid-shift.
• The count was rushed: bagged coin taken at its printed value without checking.

Banking and the paper trail

Record what actually went to the bank and the slip or bag number that proves it. Banking is a separate question from reconciliation — you may bank two days together, or hold cash back for change — so the tool does not force the banked amount to agree with the cash counted. What it can do is insist you never bank without a reference: turn the requirement on in Settings and a record with an amount banked and no reference is refused. If one deposit covers several days or tills, put the whole amount against one record and say so in the note, so the reference can be traced from either end.

Reading the charts and tables

The tender donut shows how customers paid, using the till's own figures — the cash slice is cash sales, not the cash you counted. The takings bars switch automatically: sixteen trading days or fewer are drawn day by day, beyond that by month.

The variance trend adds every till on a date together, so a day with an over on one till and a short on another can appear flat. The dashed line is your cash tolerance; the same distance below zero is the other side of it. The per-till bars show the size of the net variance, so a short and an over of equal size draw the same length — the sign and the absolute total are in the text alongside. The two tables list every flagged count in full, and put net against absolute variance per operator.

Printing and sharing

Print Report produces a report from whatever the current filter shows: header, headline figures, all four charts, both summary tables, the full register and your closing notes. The scope line states the filter in force and the currency, so clear the filters before issuing anything described as a full period. The report names operators against variances — think about who receives it, and consider filtering to a single till or using initials.

Saving your work

Counts, settings and the report header are written to this browser's local storage as you type, and the toolbar shows the time of the last save. That storage belongs to one browser on one computer: a private window, a second machine or a clean-up tool that clears site data will not have it.

Treat Export .json as the real save — one file containing everything, which Import .json restores anywhere. Export CSV gives you the register for bookkeeping work, including the columns hidden from the on-screen table, and covers every filtered record rather than only those drawn. Reset asks twice, then erases everything. There is no undo. How long records of daily takings must be kept, and in what form, differs by country and by trade — establish what applies to you and archive the exports accordingly.

Accuracy & disclaimer

This tool calculates from what you enter and nothing else. It cannot tell whether the till reading is right, whether the drawer was counted properly, whether the card terminal covers the same period, or whether a pay-out was recorded. Every variance it shows depends on all four.

It is an internal record-keeping and calculation aid. It is not an accounting system, not a margin or stock calculation, not a tax record in itself, and not evidence of anything about any person. Variances are differences between figures; establishing why one exists is a matter for your own investigation, carried out fairly and under whatever rules apply where you are.