Daily sales reconciliation compares one day's sales on the point-of-sale report with what was actually collected for each tender: cash counted, card batches settled, gift cards redeemed and delivery-app orders. Each tender then gets an expected bank date. When the deposits arrive, you tick them off, so a short day is found within a week.
What does a daily sales reconciliation compare?
A daily sales reconciliation compares three things for one business day: the sales the point-of-sale system recorded, the money collected by each payment method, and the bank deposits that should follow. The POS report is the claim. The drawer count and card batch are the proof. The bank is the final check.
The POS end-of-day report, sometimes called a Z report, is the starting point. It shows net sales, tax collected, discounts, voids and refunds, and a breakdown by tender. That breakdown matters most, because each tender reaches the bank by a different route and on a different day.
- Cash is counted at close and deposited by a person, usually the next business day.
- Card sales settle in a batch through the card processor and arrive as one net deposit a day or two later.
- Gift card redemptions bring in no money at all on the day. The cash came in when the card was sold.
- Delivery-app orders are paid by the app, often weekly, net of commission.
A day is reconciled when every tender on the POS report has a matching count, batch or statement, and every expected deposit has either arrived or is listed as pending. The reconciliation does not end at close; it ends when the last deposit for that day lands.
Daily sales reconciliation template, line by line
A daily sales reconciliation template is one row per tender with the POS figure, the actual figure, the difference and the expected bank date. Add a block for tax and tips, and a sign-off line. Keep one sheet per day and never overwrite a past day.
Here is a filled example for a café on a Tuesday. Every figure is illustrative.
| Tender | POS report | Actual | Difference | Source of actual | Expected in bank |
|---|---|---|---|---|---|
| Cash | 612.40 | 607.40 | -5.00 | Drawer count, two counters | Wednesday deposit |
| Cards | 2,184.75 | 2,184.75 | 0.00 | Processor batch total | Thursday, net of fees |
| Gift card redemptions | 86.00 | 86.00 | 0.00 | Gift card system report | None (liability reduced) |
| Delivery app A | 318.20 | 318.20 | 0.00 | App order report | Next weekly payout |
| House accounts | 120.00 | 120.00 | 0.00 | Signed charge slips | When the customer pays |
| Total tenders | 3,321.35 | 3,316.35 | -5.00 |
Below the tenders, a short block ties the total back to sales:
| Line | Amount |
|---|---|
| Net sales per POS | 3,028.60 |
| Sales tax collected | 247.75 |
| Card tips added | 45.00 |
| Total tenders expected | 3,321.35 |
The 5.00 cash short is recorded as a cash over-and-short expense, with a note from the manager. The rest of the day is proven at the tender level, and the sheet now lists four future events to check: the Wednesday cash deposit, the Thursday card deposit, the delivery payout and the house account payment.
Add two signature lines: the person who closed the drawer and the person who reviewed the sheet. If those are the same person every day, at least have a second person spot-check one day a week.
Card batches and next-day deposits on the daily sales sheet
A card batch is the group of card sales the processor settles together, usually when the terminal closes for the day. The batch total on the daily sales sheet should match the processor's settlement report. The bank deposit that follows is that batch less fees, unless the processor bills fees monthly.
Match the batch to the bank by amount and date window. If the processor deducts fees daily, the bank credit will be lower than the batch total by exactly the day's fees, and the fee figure comes from the processor's report. If fees are taken once a month, the daily deposit should equal the batch total, and a single fee debit appears near the start of the next month.
Three things cause a batch and a deposit to disagree:
- Two batches in one deposit. A terminal closed twice, or a weekend's batches were paid together.
- Refunds in the batch. A refund at the counter reduces the batch, so the deposit is lower than gross card sales.
- A batch that never closed. The terminal was not settled, so Tuesday's sales move into Wednesday's batch.
Card tips belong in this section too. Tips added on card slips are in the batch but are not sales. They are owed to staff and usually paid through payroll, which is why the payroll account also needs its own check; the steps are in reconciling the payroll bank account.
Gift cards and delivery apps on the daily sales sheet
Gift card redemptions and delivery-app orders appear as sales on the POS report but bring no money to the bank that day. A redemption uses cash collected when the card was sold. A delivery order is paid later by the app, net of its commission. Both need their own row and a different follow-up.
Gift cards. When a gift card is sold, the cash is not revenue yet. It is a liability, because the business owes the holder goods. When the card is redeemed, the liability goes down and sales go up. On the daily sheet, the redemption row has no expected bank date. The check is that the gift card system's redemption total for the day matches the POS gift card tender.
Delivery apps. Each app sends its own payout, usually covering a week of orders, after deducting commission, marketing charges and any refunds it gave customers. The daily sheet records the gross order value per app. The weekly payout then gets matched against the sum of the daily rows, with the app's fees booked as expense. If the app's order total for the week is lower than your POS total, look for orders the app cancelled or refunded without telling the store.
Write the expected payout date on each delivery row. A payout that is a week late is often the first sign that bank details changed or an account was paused.
Counting and depositing the cash from daily sales
Daily sales cash is counted at close, compared with the POS cash figure, and taken to the bank as a single deposit. The deposit slip should equal the counted cash less the starting float that stays in the drawer. The bank credit should match the slip to the cent.
A clean cash routine looks like this:
- Count the drawer with two people, by denomination, before looking at the POS cash total.
- Remove the float, the fixed amount that stays for the next morning.
- Compare what remains with POS cash sales. Record any difference with a reason.
- Prepare the deposit slip, seal the bag and log the bag number on the daily sheet.
- When the bank credit appears, tick it against the slip and the bag number.
If the business records deposits through an undeposited funds account in its ledger, the daily cash and card amounts sit there until the bank deposit is matched. Anything left in that account after a few days is a deposit that never happened or was never matched. The guide to clearing undeposited funds covers how to find and resolve those leftovers.
Businesses that deposit checks with a scanner instead of a teller have a different set of risks, such as a check scanned twice. The controls are covered in remote deposit capture controls.
How do you chase a short day in daily sales reconciliation?
To chase a short day, work from the tender with the difference, not from the total. Confirm the POS figure first, then the count or batch, then the bank. Most shortages turn out to be a timing or recording issue, such as a refund keyed to the wrong tender, before anyone needs to suspect theft.
A practical order of checks:
- Which tender is short? A cash shortage and a card shortage have different causes. If the total is short but every tender agrees, the error is in the tax or tips block.
- Was something keyed to the wrong tender? A card sale rung up as cash makes cash look short and cards look over by the same amount. Look for equal and opposite differences.
- Were there voids or refunds after the report was printed? A refund processed after the end-of-day report changes the batch but not the report.
- Did the batch close? Check the processor report for the day. An unsettled batch moves sales to the next day.
- Is the deposit simply late? Weekends and holidays shift bank credits by a day or more.
- Is the shortage recurring? Repeated small cash shortages on the same shift or till are worth reviewing with a manager, along with void and no-sale activity on the POS.
Write the outcome on the sheet. A difference with a written cause is a resolved item. A difference left blank becomes an argument a month later.
When daily sales reconciliation is more than the business needs
Daily sales reconciliation is more than some businesses need. A shop with few cash sales, one card processor that pays daily and no gift cards or delivery apps can often reconcile weekly. The test is whether a problem found a week late would cost more than the time spent checking every day.
Daily checks earn their time when:
- Cash is a large share of takings, or several people use the same drawer.
- More than one tender pays out on a delayed schedule.
- Gift cards or house accounts are sold.
- The owner is not on site every day.
A weekly approach still needs the daily POS reports kept and filed. When a weekly check finds a gap, you go back to the day it began. Without daily reports you cannot.
At month-end, the daily sheets roll up into the bank reconciliation: every expected deposit from the month either appears on the statement or is listed as in transit. PreciseBankFlow checks that each bank statement foots and matches its lines against your records, which makes a missing card deposit or a cash deposit recorded twice stand out without a manual tick-through.