Restaurant cash-out sheet
A restaurant cash-out sheet is the end of day report for one cash drawer: it takes the cash sales from your POS's Z report, adds the starting bank, takes off what was paid out, and compares that with the cash drawer count to show whether the drawer is over or short. Print one for each drawer at close, or type tonight's numbers into the calculator below and download the result as a spreadsheet.
By Felix S. Pavel · Updated · How it's worked out
Download the free template
The PDF is for printing and filling in by hand. The .xlsx opens in Excel or Google Sheets. No email asked.
Free calculator
Your end-of-day cash-out
One drawer, one day or shift. Works in any currency. Nothing you type is sent to us.
Example numbers. Replace them with yours.
The cash in the drawer at open.
From the POS end-of-day (Z) report.
Card tips paid to staff in cash from this drawer.
Cash taken out for supplies and the like, with the receipts.
The cash drawer count, starting bank included.
Cards, comps, voids and discounts (optional)
From the same Z report.
What the card processor settled for the same day.
From the Z report: before tax and tips.
The day's comps total.
The day's voids total.
The day's discounts total.
With the example numbers
Expected cash 1,891.50, counted 1,885.50. Short by 6.00.
- Expected cash
- 1,891.50
- Over (+) or short (−)
- −6.00
- Deposit
- 1,685.50
- The card batch is 12.50 lower than the POS's card sales.
- Comps 1.5%, voids 0.6%, discounts 2.5% of net sales.
- RestaurantDoctorAI sets no normal for over or short. Set your own tolerance, and decide what happens when a count is outside it.
How we worked it out
- Expected cash: 200.00 starting bank + 1,846.50 cash sales − 120.00 cash tips paid out − 35.00 paid outs
- 1,891.50
- Over or short: 1,885.50 counted − 1,891.50 expected (over is above 0, short is below)
- −6.00
- Deposit: 1,885.50 counted − 200.00 starting bank, which stays in the drawer
- 1,685.50
- Card difference: 4,199.90 processor batch − 4,212.40 POS card sales
- −12.50
- Comps: 90.00 ÷ 6,058.90 net sales
- 1.5%
- Voids: 36.00 ÷ 6,058.90 net sales
- 0.6%
- Discounts: 150.00 ÷ 6,058.90 net sales
- 2.5%
nightly-cash-out.csv: each line of the close, with how it's worked out. It opens in Google Sheets, Excel or Numbers, and it's made on this device.
How the cash out sheet is worked out
The sheet works out the cash the drawer should hold, then compares it with what you counted. Every figure is for one drawer and one day or shift.
Above 0 the drawer is over: more cash than expected. Below 0 it is short.
The starting bank stays in the drawer for the next shift.
Two optional lines turn the sheet into a simple daily sales report. The card difference is the card processor's settled batch minus the POS's card sales for the same day. Comps, voids and discounts are each shown as a share of net sales: the total ÷ net sales × 100. A figure you leave blank is never counted as 0: the sheet leaves it out and says so.
- Starting bank
- 200.00
- + Cash sales (Z report)
- 1,846.50
- − Cash tips paid out
- 120.00
- − Paid outs
- 35.00
- = Expected cash
- 1,891.50
- Cash counted
- 1,885.50
- Deposit
- 1,685.50
Short by 6.00.
RestaurantDoctorAI sets no normal for over or short. Set your own tolerance, and decide what happens when a count is outside it.
How to use the cash-out sheet each night
- Start each drawer with the same starting bank, and write it at the top of the sheet.
- At close, run the POS end-of-day (Z) report. Copy its cash sales, and if you use the optional lines, its card sales, net sales, comps, voids and discounts.
- Write down the card tips paid out in cash from the drawer and any paid outs, and keep their receipts with the sheet.
- Count the cash drawer, starting bank included, and write the total. Many owners have a second person count it too.
- Work out expected cash and over/short. Set the starting bank aside for tomorrow: the rest is the deposit.
- Once the card processor settles, check its batch against the POS's card sales for the same day.
- Keep each night's sheet with its Z report, so you can see a drawer's over/short night by night and trace a gap back to its shift.
Common questions
What is a Z report?
It's the end-of-day report a POS prints when you close out the day: the day's sales by payment type, with comps, voids and discounts. Many systems also have an X report, which shows the same figures during the day without closing it. The names vary by POS.
How much over or short is normal?
RestaurantDoctorAI sets no normal for over or short. Set your own tolerance, and decide what happens when a count is outside it. Writing it down every night shows you whether a short drawer is a one-off or a pattern.
Does the starting bank go in the deposit?
No. The starting bank stays in the drawer for the next shift, so the deposit is the cash counted minus the starting bank.
Why doesn't the card batch match the POS's card sales?
Often it's timing or an edit in one system and not the other: a tip adjusted after the batch closed, a payment voided on the POS but not the terminal, or a batch that settled on another day. The sheet shows the size of the gap; the processor's batch report and the POS's payment report show which payments make it up.
Is anything I type sent anywhere?
No. The calculator works in your browser, and the spreadsheet download is made on your device.