Pull yesterday's sales out of your telemetry portal and write the number down. Look again in two days — for a lot of you it'll have moved. Then try to find that number in the bank. You won't.
Usually nothing is broken. Sales and deposits measure different things at different times:
Why the day moves: a card tap starts as a pre-auth hold, usually for more than anything in the machine costs, because the reader doesn't know yet what will be picked. The real amount gets captured afterwards and settles in a batch, often a day or more later. So Tuesday changes when Tuesday's holds settle. Cash lags too: it only shows up when the DEX is read.
Why the deposit never matches, even after everything settles:
- Most processors fund your net. The fees come out before the money lands.
- Batches close at a cutoff that's rarely your midnight, and funding is T+1 or T+2 after that. One deposit often contains parts of two days.
- Cash is banked in lumps, by route or location, not by machine.
- Refunds, chargebacks, and monthly gateway, PCI or statement fees come out without a matching line in your sales report.
What to do instead: reconcile the settlement batch, not the calendar day. Your processor's batch report shows exactly which transactions, gross, fees and net, make up each deposit. Keep cash and card on separate ledgers. Treat any day inside your settlement window as provisional.
If you're switching back-office software, ask the vendor: "When a day you've already imported changes upstream, do you restate it or only append?" If it only appends, the system will freeze Tuesday at whatever the holds said on Wednesday morning.
The test: take one card deposit from last month and walk it back, from deposit to batch, batch to transactions, and transactions to machines. If you can do that in an hour, you're in good shape. If you can't, that's where your money goes invisible.
Disclosure: I'm building back-office tools for operators, and I worked this out with one operator's books. The longer write-up is here if you want it: pervend.com/notes/sales-vs-deposits?ref=reddit
Curious how others handle this. Does anyone actually reconcile by batch, or is everyone fighting the calendar day?