A shoebox of Z reports
At the end of the day, the shop till prints a Z report. The cafe till prints another. The card terminal has its own end-of-day report. Cash is counted into a bag with a slip. The honesty box at the egg stall is emptied into a jar. The online shop pays out through Stripe or Shopify every few days. On event days there is a separate card reader at the gate.
Once a week, or once a month, someone sits down with a shoebox of reports and a spreadsheet, tries to make it all agree and then types it into the accounts. When a figure is out, it is too late to find out why. Was it a refund done on the card terminal but not the till? A cafe sale rung through the shop till? A float not topped up? Nobody remembers.
Why farm shop takings rarely agree
Each source records money differently and at a different time. Card settlements arrive in the bank days later, with fees deducted. Cash is counted by different staff. The honesty box has no till at all. Online payouts combine several days' orders. And farm shops often share tills between departments or use several card terminals, so the same sale can be recorded in two places or none.
- Shop, cafe, butchery and events may each use a different till or terminal.
- Card terminal totals and till totals differ when refunds or voids are done in only one.
- Card settlements reach the bank days later, minus fees.
- Honesty box and vending machine cash has no till record.
- Online payouts combine many orders across several days.
What unreconciled takings cost
Differences found weeks later cannot be explained, so they are written off. Small repeated differences can hide a problem: a till that is not set up properly, a process staff do not follow, or occasionally something more serious. Your accounts are late because the bookkeeper waits for the reports. And you do not know, day by day, how each part of the business is trading.
Your bookkeeper's time is not free either. Much of the monthly bill may be spent making the takings agree.
Farm shops have a particular version of this problem because so much trade happens outside the main till. The egg stall at the gate, the milk vending machine, the plant table on a spring weekend, the gate reader at the lambing event, the card machine in the cafe that someone uses for shop sales when the queue is long. Each is a small stream of money with its own way of being counted, and each is a place where a difference can hide for months.
The daily takings check we build
- Daily sales read from each till system through its API or export, split by department and payment type.
- Card terminal settlements read from your payment provider's reports, and Stripe or Shopify payouts read from their APIs.
- A simple cash-up form on a tablet for each till and the honesty box: counted cash, float, any notes. Staff fill it in at close.
- A daily comparison: till card totals against terminal settlements, till cash against counted cash, online orders against payouts, with differences above a level you set flagged the same evening.
- A reason field for each flagged difference, filled in by the person who closed, while they still remember.
- A daily summary posted to Xero or QuickBooks, split into the accounts your accountant specifies, with card fees separated and bank deposits ready to match.
| Source | Compared with | Common reason for a difference |
|---|---|---|
| Shop till card total | Terminal settlement | Refund done on terminal only |
| Cafe till cash | Counted cash | Float not recorded |
| Honesty box | Expected from stock sold | Unpaid items, miscounts |
| Online orders | Stripe or Shopify payout | Refunds, timing, fees |
| Event gate reader | Event tickets sold | Walk-up sales not recorded |
The end of the day afterwards
At close, staff count the cash and enter it on the tablet. By the next morning, the owner sees a one-page summary: each source, whether it agreed and any differences with the reason given. Most days everything agrees. When it does not, the reason is usually clear because it was noted the same evening.
Your bookkeeper stops rebuilding takings from paper. The accounts are up to date weekly, and you can see how the shop, cafe, butchery and events trade separately.
Honesty box and vending sales, often guessed, become visible too, which helps decide whether they are worth running.
Do your takings look like this?
- Z reports are kept in a box and reconciled weeks later.
- Card and till totals differ and nobody knows why.
- Honesty box cash is not compared with anything.
- Online payouts are hard to match to orders.
- Your bookkeeper spends most of their time on takings.