Daily Sales Reconciliation Template
Two documents and three sheets that check cash by shift and location before anything gets blended, and tie each deposit to the date it actually posts.
Free download · No account needed
Every daily sales reconciliation template runs one comparison: the day's till total against the day's deposit, for the whole location. That comparison is exactly wide enough to hide the case where two real, opposite-sign problems exist on the same till at the same time and happen to be close enough in size to cancel. A blended daily number that clears any reasonable threshold is not evidence nothing is wrong; it can be evidence that two things are wrong in opposite directions.
Overlook Diner Group's Riverside location carried both for three straight weeks. The PM shift ran a consistent 17.69 shortfall a day; the AM shift ran a consistent 13.21 overage. Blended into one daily number, the location reads -4.47 a day, ordinary rounding noise against roughly 1,200.00 in daily sales. Split by shift, both cross a 10.00 threshold in opposite directions, and neither the float count, the void log, nor the schedule explains either one on its own.
Deposit Tie-out catches a second, unrelated failure at the other location: a bagged deposit the bank posted 340.00 short, a real shortage rather than the ordinary one-day lag a night-drop bag carries between bagging and posting. The Variance Escalation Note documents the finding and requests a vault recount before either the register or a shift gets blamed for it. Feed all three sheets from POS exports alongside the close checklist, and route the resulting margin swing to the board slide.
What's in the pack
Daily Sales sheet
Every shift's till count against its own Z-report, logged separately from the other shift that same day, never combined at the point of entry.
Deposit Tie-out sheet
Bagged cash matched to the bank-posted amount by the date it actually lands, not the date it was bagged, so a routine lag never reads as a break.
Variance Log sheet
Every shift and location's trailing average against a fixed threshold, with the blended rows carried on the same sheet so a masked pattern is visible beside the split rows that caught it.
Cash Handling Procedure
The float, the void log, the bagging cadence, and why a same-calendar-day deposit match is the wrong check for cash dropped after hours.
Variance Escalation Note
A completed example: the four checks that run before a flagged pattern gets a cause, and the wage law that governs what happens after.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent read your POS exports, or download the blank Word and CSV files instantly with no account.
- 2
Send the Z-reports and the bank statement
Till counts and Z-reports by shift and location, plus the bank statement or online activity for the same period, in whatever shape they exist today.
- 3
Let each shift and location stand on its own
Cash gets logged and checked by shift and by location first, never blended into one daily or company number before the threshold gets applied.
- 4
Escalate before naming a cause
A flagged pattern gets checked against the float, the void log, and the schedule before it becomes anything more, and pay decisions follow the wage law, not the pattern alone.
Frequently asked questions
Is this template free?
Yes. Download the whole pack as Word documents and CSV sheets, with no signup and no credit card. Edit with AI is a separate, optional path for anyone who wants the agent to log shifts and tie out deposits directly. The template library holds the rest of the packs.
Why would a daily total hide a real problem?
Because a blended number is an average, and an average can sit near zero while what is actually happening is two real patterns of similar size pointing in opposite directions. Riverside's blended day reads -4.47, ordinary noise, while its two shifts read +13.21 and -17.69, both well past the threshold split out.
Why doesn't a deposit post the same day it's bagged?
Because a cash deposit not made in person to a bank employee can lawfully take a bank up to two business days before it has to make those funds available at all. A night-drop bag typically posts the next business day, and a Friday bag posts the following Monday. Matching same-calendar-day totals reads as broken on a normal, lawful lag.
Once a shift is flagged, can I deduct the shortfall from that cashier's pay?
Not on a flagged pattern alone. California permits a cash-shortage deduction only where the employer proves the shortage was caused by the employee's dishonesty, willfulness, or gross negligence, and some states prohibit it outright for a shared till. Isolating which shift carries a variance is not the same finding as isolating who caused it.
What counts as the investigation threshold?
A trailing average beyond plus or minus 10.00 a day, applied to every shift and location on its own, not to a blended total. A single unusual day is normal; a trailing average that stays past the threshold for multiple periods is what opens a Variance Escalation Note.
What does Edit with AI actually do?
It creates a free River account and installs this exact pack as a private workspace. The agent opens ready to read your Z-reports and till counts by shift, log each one separately, and tie deposits out by posting date. Nothing is written until you send something.
Who is this template for?
Owners and controllers at a cash-handling business with more than one shift or location, where a company-wide daily total is not granular enough to catch what is actually happening underneath it. Once cash is reconciled daily, the close checklist is where the monthly roll-up runs.
Split by shift and location before anything gets blended
Download the blank pack as Word and CSV files, or open this exact pack in River and let the agent reconcile your own Z-reports and deposits.
Edit with AI