A liquor shop's daily sales register has one job: for every SKU, prove that opening stock − sales = closing stock, every single day. Done right, it is simultaneously your sales record, your stock control and your compliance document. Done wrong, it's a notebook of numbers nobody can defend.

What every register entry must capture

Brand and exact size — "8PM 180ml", never just "8PM".
Opening stock for the day (chained from yesterday's closing — not re-typed).
Quantity sold, ideally with payment mode split (cash/UPI/card).
Closing stock, which the system should compute and a human should spot-check.
Who recorded it and when — the audit dimension paper can't provide.

The chaining problem

The classic paper failure: yesterday's closing for a SKU was 47, but today's page says opening 74 — a transposition. Every number downstream is now wrong, and the error surfaces weeks later as an unexplained "shortage" of 27 bottles. A digital register chains automatically: today's opening is yesterday's approved closing, and can't be re-typed wrong.

Back-dated entries: the silent register killer

Real shops sometimes enter sales a day or two late. On paper this means rewriting pages. In naive software it's worse — a back-dated entry captures today's stock as its "opening", producing registers where the numbers don't chain at all. A correct system rebuilds the chain: when a back-dated day is inserted, every subsequent day's opening/closing is recomputed from the ledger. (This is exactly how Liquor Pro's register behaves — the register is a projection of the stock ledger, so it self-heals.)

Paper vs spreadsheet vs app

	Paper register	Spreadsheet	Purpose-built app
Chaining opening/closing	Manual, error-prone	Formula breaks silently	Automatic from ledger
Back-dated entries	Rewrite pages	Manual re-fix everywhere	Chain rebuilds itself
Per-size summaries	Re-add by hand	Pivot tables, if you know how	One tap, by category & size
Audit trail	None	None	Who, what, when — always
Owner approval flow	Trust	Trust	Staff submit, owner approves

Summaries owners actually use

Beyond the per-SKU rows, a good register produces the day's category totals (whisky vs beer vs wine), size totals (how much of the day was 180ml trade), and bottles-sold counts — the numbers an owner uses to spot trends, plan purchases and brief the distributor. If producing these takes more than a tap, they won't be produced daily.

Practical tip: close the register the same evening, every evening — and have a different person spot-check three fast movers physically. Same-day discrepancies take minutes to resolve; week-old ones take hours.

The Daily Sales Register, Done Right