End‑of‑day reconciliation is the process of comparing what your POS says happened (sales, refunds, payouts, payments) with what actually happened in your till, EFTPOS batches and bank deposits. It must be a daily habit in business, and it is critical, as you're dealing with high transaction volumes, mixed payment types, and a wide product range. Implementing a disciplined end‑of‑day POS routine is essential for a retailer to tighten cash control, catch errors early, and turn daily sales data into better decisions.
The goal of end‑of‑day
The objective is not just "balancing the cash drawer"; it's to confirm that:
- POS totals by payment type equal your physical cash and EFTPOS/card batches for the trading day.
- Non‑sales movements (refunds, payouts, debt collection, supplier cash payments) are properly recorded and explained.
- Key sales, stock and customer patterns are captured so you can refine rostering, stock and merchandising.
When this is done well, your accounts, tax records and management reports all line up, and discrepancies are small, documented and understandable.
Daily end‑of‑day checklist
Run your close in the same order every time. A typical 10–15 minute routine looks like this:
- Close the trading period in the POS
- Confirm today's date, store and registers.
- Ensure there are no open sales, parked transactions or draft invoices that belong to today.
- Generate and print key reports
- End‑of‑day summary (Z‑report/closing report) with totals by payment type.
- Customer, product, hourly, payment type and register breakups (see next section).
- Refunds, voids and discount/price‑change reports.
Print and file these; keep paper copies, as they are the best proof for ATO audits.
- Count and reconcile each cash drawer
- Take each drawer to a quiet area, count by denomination, and record the total on a cash count sheet.
- Separate the opening float from the day's takings.
- Reconcile EFTPOS and card payments
- Close the batch on each EFTPOS/card terminal and print the batch totals.
- Match these against POS card totals for the same period.
- Review non‑sales money movements
- Confirm payouts, cash supplier payments, refunds and other withdrawals are recorded and supported by receipts.
- Investigate and document variances
- Record any differences between POS and physical/batch totals, note the date, the reason if known, and have a supervisor/owner sign off. In many cases, this evidence has proven invaluable.
- Secure cash, back up and lock up
- Prepare the bank deposit, reset floats for tomorrow, secure cash in the safe, and ensure the POS has synced/backed up the day's data.
The essential reports to run
Your POS can provide much more than a single closing total. At end‑of‑day, focus on these views:
Customer breakdown
Analyse customer transactions to understand basket size, repeat visits and key segments. For a Dingley Village newsagency, this helps you see how family shoppers, commuters and "quick lotto and milk" customers behave across the week.
Product/dissection breakup
Review sales by product category to spot top‑performing items and slow movers: magazines, books, cards, gift lines, stationery, lotteries and add‑on items. While it's fresh in your mind, a spike of anything can be very enlightening.
Hourly breakup
Hourly sales let you see trading peaks and quiet periods across the day.
Payment type breakup
Tracking sales by cash, EFTPOS, credit card, gift voucher and other tenders makes reconciliation faster and highlights shifts in customer behaviour. For example, sustained growth in card/contactless usage may justify changing your EFTPOS plan, while cash‑heavy periods might call for more frequent cash drops to the safe.
Register breakup
If you run more than one till, check which register or cashier has problems. Many people do it several times a day. Separate closes per register reduce cash mixing and make it easier to identify where variances are coming from.
Optional graphs
Graph views are useful while you're still learning patterns, but experienced retailers often revert to tabular reports for speed and clarity. Use graphs when explaining trends to staff or in management meetings.
Cash reconciliation: the simple formula
For each drawer, use this formula:
- Opening float
- Plus: cash sales
- Minus: cash refunds
- Minus: cash payouts/withdrawals
Equals: expected drawer total.
Compare this expected total to your counted cash. Record the difference (over or short) every day, even if it's small. Consistent small variances often reveal training issues or chronic process errors.
EFTPOS and card reconciliation
Card payments don't live in the till; they live in terminals, processor batches and bank deposits. At end‑of‑day:
- Run the batch/settlement report on each terminal and note the total card sales and refunds.
- Match this against the POS card total for the same period; they should agree.
- If integrated EFTPOS is used, confirm the POS shows the batch as settled and note any failures before you leave.
Later (often the next day), match processor net deposits to your bank statement, taking fees into account. Doing a clean daily match POS → batch totals makes weekly and monthly reconciliation much easier.
Handling discrepancies and variances
Your article already emphasised "Investigate discrepancies immediately"; turn that into a small policy:
- Set a threshold: e.g. variances under a few dollars are logged and monitored; above that, they trigger recounts and manager review. In my experience, any variance is worth chasing.
- Document every variance: amount, drawer/register, cashier, probable cause (incorrect change, missed payout entry, EFTPOS error, etc.). Staple these notes to the printed closing report or attach them to the digital record.
- Escalate material differences ASAP, not weeks later when memories have faded.
This habit protects you if there's ever an ATO enquiry, insurance claim or internal investigation.
Inventory and exception review
End‑of‑day is also the right moment to review "exceptions" – things that distort margin and stock numbers:
- Refunds and returns, especially for higher‑value books and gift lines.
- Voided sales or deleted transactions, checking for patterns around particular staff or categories.
- Manual discounts and price overrides, which can signal pricing errors or misuse.
For magazines, books and cards, spot‑checking top sellers and frequently refunded items helps you catch mis‑priced lines, missing barcodes or shrink quickly, rather than discovering them at stocktake time.
Roles, sign‑off and multiple registers
To avoid "everyone thought someone else did it", always define roles clearly:
- Cashiers count and record their own drawers using a standard cash count sheet.
- A supervisor/owner reviews the reconciliation, variances and reports, then signs off.
- Each register is closed separately, with its own report and cash count; cash is not mixed between tills before counting.
This creates a clear chain of custody for cash and closing reports, which is useful for both trust and external audits.
Security, cash handling and backups
A good close ends with clean numbers and secure assets:
- Separate tomorrow's float from today's takings.
- Prepare the bank deposit (cash and coins).
- Please never leave significant cash in the tills overnight.
- Confirm that your POS has synced with the cloud, or that backups/exported reports have finished successfully, before shutting down systems.
Using your end‑of‑day data strategically
Once the mechanics are solid, use your daily reports to drive decisions:
- Hourly and customer breakdowns inform rostering and staffing
- Product/category breakups show which magazine ranges, kids' books, cards and gift lines deserve more space, better placement, or promotional focus – and which lines should be marked down or retired.
- Payment type trends help you negotiate EFTPOS fees, plan cash handling procedures and decide whether to introduce new payment options.
This is where end‑of‑day stops being "admin" and becomes a daily management tool.
Updated FAQ
How long should end‑of‑day take?
With a well‑set‑up POS and a disciplined routine, most small retailers can complete end‑of‑day in 10–15 minutes. It can blow out if variances are large, reports aren't configured, or staff skip steps during the day.
Can I automate end‑of‑day?
You can automate parts of the process – exporting sales data, emailing reports, even pre‑filling reconciliation sheets – and this often saves time. However, a daily human review of cash, card batches, refunds, and exceptions is essential; the closer you are to the event, the easier it is to investigate and resolve issues properly.
How often should I perform these procedures?
At least once every trading day. Delaying end‑of‑day reconciliation makes discrepancies harder to trace and increases the risk of compounding errors in your accounts and tax records.
What if my cash drawer doesn't balance?
Treat every variance as a signal:
- Recount the drawer, verify the float, and check that all payouts/refunds are recorded.
- Review the POS cash report and receipts for any obvious mistyped amounts or missed entries.
- Document the variance and reason; investigate recurring patterns across days or staff.
