Daily cash sheet template
A daily cash sheet for a store or office: opening cash, sales by payment type, payouts and closing count.
- ๐บ๐ธ US format ยท Letter size
- Free
This is a sample form. Check tax amounts against IRS rules and your accountant's advice.
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Cash sheet: opening cash (input), sales by payment type, total sales, cash refunds, payouts, expected cash, cash counted (input), over or short, cash to deposit (formulas), counted by and checked by
- Transactions: description, reference, type (dropdown), payment type (dropdown), amount, notes, total
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
Count with a second person when you can
Most stores have the closing count checked by a manager or a second employee. The sheet has Counted by and Checked by lines at the bottom for that. The file is built in your browser and never goes to a server.
1 / 2
Cash sheet (with the example transactions)
| Line | Amount | Where it comes from |
|---|---|---|
| Opening cash in drawer | 0.00 | Count before the first sale (or yesterday's closing float) |
| Cash sales | 0.00 | Transactions: Sale lines paid in cash |
| Card sales | 0.00 | Transactions: Sale lines paid by card |
| Check sales | 0.00 | Transactions: Sale lines paid by check |
| Other sales | 0.00 | Transactions: Sale lines, other payment |
| Total sales | 0.00 | Cash + card + check + other |
| Cash refunds | 0.00 | Transactions: Refund lines paid out in cash |
| Payouts from drawer | 0.00 | Transactions: Payout lines (supplies, tips, change) |
| Expected cash in drawer | 0.00 | Opening + cash sales - cash refunds - payouts |
| Cash counted at close | Count every bill and coin in the drawer | |
| Over (+) or short (-) | (auto) | Counted - expected |
| Cash to deposit | (auto) | Counted - opening float (what leaves the drawer) |
Transactions
| Description | Reference | Type | Payment type | Amount | Notes |
|---|---|---|---|---|---|
| Register 1, morning batch | Sale | Cash | 412.75 | ||
| Register 1, morning batch | Sale | Card | 1,288.4 | Terminal report attached | |
| Northwind, invoice 2041 | Sale | Check | 350 | Check 1187 | |
| Refund, order 1042 | Refund | Cash | 24.99 | Returned item | |
| Window cleaner | Payout | Cash | 40 | Receipt in drawer | |
| Total | =SUM(โฆ) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Type the date, the register and the cash in the drawer when you open. During the day, log each register batch, check, refund and payout on the Transactions sheet with the payment type. The Cash sheet totals sales by cash, card, check and other, subtracts cash refunds and payouts, and tells you how much cash should be in the drawer.
At close, count the drawer and type the number. The sheet shows whether you are over or short and how much cash goes to the bank after you hold back the float for tomorrow.
Things to watch
Card totals come from the terminal batch report, not from counting receipts, so run the batch before you close the sheet. Every payout needs a receipt in the drawer or the count will come up short with no explanation. If you use more than one register, make one sheet per register or add the register name to each transaction line.
Calculators that go with this
Frequently asked questions
How is this different from the petty cash log?
The petty cash log follows one small box of cash over a month. The daily cash sheet closes out one business day: sales by payment type, payouts, and whether the drawer count matches.
Do I need a new file every day?
No. Copy the two tabs and change the date, or come back here and download again with the new date. If you copy tabs, check that the Cash sheet formulas still point to the same day's Transactions tab.
Does it work in Google Sheets?
Yes. SUMIFS, SUM and IF work the same in Google Sheets. You may need to re-create the dropdowns.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.