At the end of every shift, someone at a restaurant, bar, café or small hotel has to answer three questions before going home: did the money we took match what the register says we sold, is the cash in the drawer what it should be, and how much goes to the bank? A daily cash report answers all three on one page. The POS prints a Z report, but it can’t count the drawer, record the $42 you paid the ice man out of the till, or tell you whether the card processor’s batch matches.
This page gives you a free daily cash report template in Excel, built for restaurants and small hotels. You copy the Z report into it, count the drawer by denomination, list paid-outs, and it calculates expected cash, the over or short, and the deposit. A monthly cash log adds up the days and flags shortages and deposits that never showed up at the bank. There’s also an online version you can fill in right on this page.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Includes a printable one-page daily report, a denomination count sheet, a 31-day cash log and a month summary with an over/short chart.
Free online daily cash report calculator
Enter your starting bank, the sales and tenders from your POS end-of-day report, card tips and the processor batch total. Then list any paid-outs and count the drawer. You can also click Load example. The report shows expected cash, over/(short), the deposit to make and five automatic checks. You can print it, save it as a PDF, download it as Excel, Word or CSV, or email a link to the owner or your bookkeeper.
4. Daily cash report
Sales and receipts
Tenders
Cash drawer reconciliation
Checks
Cash count
Paid-outs
Expected cash = starting bank + cash sales + other cash in − paid-outs − card tips paid in cash. Over/(short) = counted − expected. Deposit = counted − the bank you leave for tomorrow.
Prepared by: ______________ Signature: __________ Verified by: ______________ Signature: __________ Deposit bag #: ________
Made with the free daily cash report tool at bookkeepingsheets.com
What is a daily cash report?
A daily cash report (also called a daily sales and cash report, cash-out sheet or end-of-day report) is a one-page record that ties three things together:
- What you sold: net sales by category, sales tax, and other money received such as gift cards sold or payments on house accounts.
- How customers paid: cash, credit and debit cards, gift cards redeemed, house accounts or charges to a hotel room, and anything else (checks, mobile wallets, delivery apps).
- What is physically in the drawer: the counted cash compared with what should be there, and the deposit that goes to the bank.
It is different from a revenue report. A hotel daily revenue report shows what the business earned (room nights, ADR, RevPAR). The cash report shows what it collected and whether every dollar is accounted for. A guest who charges dinner to their room adds to restaurant sales today but no cash comes in until checkout, which is why the template has a separate “house accounts / charged to room” tender.
What’s inside the template
- Setup: business name, the month, your standard starting bank (the cash float you leave in the drawer), sales tax rate and an over/short tolerance.
- Daily Cash Report: four sections (sales, tenders, card tips and batch, cash drawer reconciliation), a 13-line denomination count plus rolled coin, an 8-line paid-out list, status messages and signature lines. It prints on one landscape page.
- Cash Log: one line per day for up to 31 days. It works out total receipts, total tenders, expected cash, over/short, the deposit to make and the difference from the deposit on your bank statement, with a Check column.
- Month Summary: sales and tender mix, card tips, paid-outs, total overages and shortages, net over/short as a % of cash sales, days outside tolerance, deposits not yet on the statement, the largest shortage and a daily over/short chart.
How to fill in a daily cash report, step by step
- Run the end-of-day (Z) report in your POS after the last check is closed. Copy food, beverage, alcohol and other sales, discounts and comps, and sales tax.
- Copy the tenders from the same report: cash, cards (sales only, without tips), gift cards redeemed, room or house charges and other. The template checks that total tenders equal total receipts. If they don’t, look for voids, split checks and gift-card lines first.
- Enter card tips and the batch total. Card sales plus card tips should equal what the processor settles. A mismatch usually means an open check, a tip adjusted after the batch closed or a batch that didn’t go through.
- List paid-outs. Every dollar taken out of the drawer for a delivery, a small purchase or postage gets a line and a receipt.
- Count the drawer by denomination. Two people count if you can, and the second person signs. Don’t adjust the count to make it balance.
- Read the result. Over/(short) = counted − expected. Take tomorrow’s starting bank out and bag the rest as the deposit. Write the bag or slip number on the report.
- Copy the day to the Cash Log (the daily sheet has a “Copy to Cash Log” box with every number you need). When the deposit shows up on the bank statement, enter it so the log can match it.
Worked example: Blue Heron Bistro, Friday
Blue Heron Bistro opens Friday, November 6, 2026, with a $300 starting bank. The Z report shows these sales and tenders:
| Sales and receipts | Amount | Tenders | Amount |
|---|---|---|---|
| Food sales | $3,860.00 | Cash | $1,618.40 |
| Beverage sales | $412.50 | Credit and debit cards | $3,902.75 |
| Alcohol sales | $1,286.00 | Gift cards redeemed | $120.00 |
| Less discounts and comps | −$212.40 | Charged to hotel rooms | $246.00 |
| Net sales | $5,346.10 | ||
| Sales tax (8.25%) | $441.05 | ||
| Gift cards sold | $100.00 | ||
| Total receipts | $5,887.15 | Total tenders | $5,887.15 |
Receipts and tenders agree, so the POS side balances. Servers charged $702.50 in tips on cards, and the processor’s batch report shows $4,605.25, which is $3,902.75 + $702.50, so the card side balances too. The manager paid those tips to staff in cash from the drawer, and paid out $139.70 for ice, produce and postage.
| Cash drawer reconciliation | Amount |
|---|---|
| Starting bank | $300.00 |
| + Cash sales | $1,618.40 |
| − Paid-outs | −$139.70 |
| − Card tips paid out in cash | −$702.50 |
| Expected cash in the drawer | $1,076.20 |
| Counted cash (bills $1,066.00 + coins $6.35) | $1,072.35 |
| Over / (short) | −$3.85 |
| Leave as tomorrow’s starting bank | $300.00 |
| Cash deposit | $772.35 |
The drawer is $3.85 short, which is inside the bistro’s $5 tolerance, so the report shows “Short — within tolerance” and the manager notes it. The deposit is $772.35, not the $1,618.40 of cash sales, because tips and paid-outs left the drawer in cash. Over the first six days of November the Cash Log shows a net shortage of $14.75 on $6,475.57 of cash sales (0.23%), one day (Wednesday, −$12.40) outside tolerance, and one deposit that reached the bank $50 short of what was bagged. Those last two are the lines an owner wants to see the next morning.
The formulas
- Net sales = food + beverage + alcohol + other sales − discounts and comps.
- Total receipts = net sales + sales tax + gift cards sold + payments received on house accounts.
- Total tenders = cash + cards + gift cards redeemed + house/room charges + other. Receipts − tenders should be $0.00.
- Expected card batch = card sales + card tips.
- Expected cash = starting bank + cash sales + other cash in − paid-outs − card tips paid out in cash.
- Over/(short) = counted cash − expected cash.
- Deposit = counted cash − the starting bank you leave for tomorrow.
In the Cash Log, the month summary uses SUMIFS to separate overages from shortages, so a $20 over on Monday and a $20 short on Tuesday don’t quietly cancel out to zero. The “days outside tolerance” count uses COUNTIF on both sides of the tolerance.
Common mistakes
- Counting gift cards sold as sales. A gift card is a liability until it’s redeemed. It’s a receipt today, but the sale happens when the card is used.
- Entering card sales with tips included. Then tenders won’t match receipts, and the batch check is meaningless. Keep tips on their own line.
- Depositing “cash sales” instead of counted cash minus the bank. Cash tips and paid-outs have already left the drawer.
- Letting overages offset shortages. Track both. A drawer that is $25 over one day and $25 short the next is not balanced; it’s a control problem.
- Paid-outs without receipts. An unexplained paid-out is just a shortage with a description.
- Not matching deposits to the bank. Enter the deposit from the bank statement in the Cash Log, and reconcile the account monthly with a bank reconciliation template.
Tips, cash and the IRS
Two IRS rules often come up around the cash drawer. Large food or beverage establishments, where tipping is customary and the business normally had more than 10 employees on a typical business day in the prior year, file Form 8027 each year to report receipts and tips. The card tips line in this report gives you the numbers by day. And a business that receives more than $10,000 in cash in one transaction or related transactions generally has to file Form 8300 within 15 days. That’s rare in a restaurant, but it can happen with a large cash-paid event or catering order. Tip income rules for employees also changed for 2025–2028; see our no tax on tips calculator.
Frequently asked questions
How do you calculate cash over and short?
Over/(short) = counted cash − expected cash, where expected cash = starting bank + cash sales + other cash in − paid-outs − cash tips paid out. In the example, $1,072.35 − $1,076.20 = −$3.85 short.
How much over/short is acceptable?
There is no legal standard. Many restaurants set a small fixed tolerance (often a few dollars per drawer) or a percentage of cash sales, and investigate anything outside it, as well as any pattern of repeated small shortages on the same shift or employee.
How do you record cash over and short in bookkeeping?
Most small businesses post the daily difference to a “Cash over and short” account: a shortage is an expense (debit), an overage is other income (credit). The deposit is recorded at the amount actually deposited.
Should the starting bank be the same every day?
Yes, ideally. A fixed float (for example $300) makes the deposit simple: counted cash minus the float. If the drawer ends below the float, there’s no deposit and you refill the change fund.
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas, checks and colors carry over.
Related calculators and templates
- Hotel Daily Revenue Report Template
- Monthly Bank Reconciliation Template
- Small Business Bookkeeping Spreadsheet
- Sales Tax Calculator
- No Tax on Tips and Overtime Calculator
- RevPAR, ADR and Occupancy Calculator
This guide and template are for general record-keeping and information. They aren’t accounting, tax or legal advice. Sales tax, tip reporting and cash reporting rules depend on your state and your business. For questions about your own business, talk to a qualified accountant or tax professional.