A daily cash sheet sample is a simple table that records all cash received and paid out during a business day, with columns for date, description, cash in, cash out, and balance. Below is a ready-to-use template, a filled-in example, and practical guidance on how to use it accurately.
What Is a Daily Cash Sheet?
A daily cash sheet (also called a daily cash report or cash count sheet) is a bookkeeping form used to track physical cash transactions for a single business day. It helps you see how much cash you started with, how much came in, how much went out, and how much should be left at the end of the day. This is especially important for retail stores, restaurants, food trucks, and any business that handles cash payments.
The sheet is not the same as a cash flow statement, which covers a longer period and includes non-cash items. A daily cash sheet focuses only on actual currency and coins, making it a practical tool for daily reconciliation and fraud prevention.
Why Use a Daily Cash Sheet?
Keeping a daily cash sheet helps you in several concrete ways:
- It verifies that the cash in your register matches your sales records.
- It quickly reveals shortages or overages, so you can investigate the same day.
- It creates a clear audit trail for tax purposes and for your accountant.
- It helps you spot patterns, like which days have higher cash sales.
- It deters employee theft because cash is counted and documented daily.
Without a daily cash sheet, small discrepancies can go unnoticed and accumulate into significant losses over time.
Key Components of a Daily Cash Sheet
Most daily cash sheets include the following sections:
- Date and prepared by: The business day and the person who completed the sheet.
- Opening balance: The cash you had in the register at the start of the day.
- Cash in: All cash received from sales, customer payments, or other sources.
- Cash out: All cash paid out for expenses, refunds, or petty cash.
- Ending balance: The cash that should be left at the close of the day.
- Actual count: The physical count of cash at the end of the day.
- Difference: The variance between expected and actual ending balance.
- Notes: Any explanations for discrepancies, such as a miscount or a customer refund.
Some sheets also include a breakdown by denomination (e.g., $100 bills, $50 bills, quarters) to make the physical count faster and more accurate.
Daily Cash Sheet Sample Template
Below is a generic daily cash sheet template you can copy and adapt. The blank version is followed by a filled-in sample with fictional details.
| Date | Description | Cash In | Cash Out | Balance |
|---|---|---|---|---|
| Opening balance | ||||
| Sales | ||||
| Refund | ||||
| Supplies purchase | ||||
| Ending balance (expected) | ||||
| Actual cash count | ||||
| Difference |
Filled-in sample (fictional):
| Date | Description | Cash In | Cash Out | Balance |
|---|---|---|---|---|
| 2025-03-21 | Opening balance | $100.00 | $100.00 | |
| 2025-03-21 | Sales | $450.50 | $550.50 | |
| 2025-03-21 | Refund to customer | $25.00 | $525.50 | |
| 2025-03-21 | Supplies purchase | $40.00 | $485.50 | |
| 2025-03-21 | Ending balance (expected) | $485.50 | ||
| 2025-03-21 | Actual cash count | $485.00 | ||
| 2025-03-21 | Difference | -$0.50 |
How to Fill Out a Daily Cash Sheet
Follow these steps to complete a daily cash sheet accurately:
- Record the date and your name at the top of the sheet.
- Enter the opening balance – the cash you counted at the start of the day.
- Throughout the day, log each cash transaction in the appropriate column (cash in or cash out) with a brief description.
- At the end of the day, calculate the expected ending balance by adding cash in and subtracting cash out from the opening balance.
- Physically count the cash in the register, including coins and bills.
- Enter the actual count and calculate the difference (actual minus expected).
- If the difference is not zero, investigate immediately. Common causes include miscounts, unrecorded sales, or errors in giving change.
- Sign and date the sheet, and keep it in a safe place for your records.
Common Mistakes and How to Avoid Them
Even with a simple sheet, mistakes happen. Here are the most frequent ones and how to prevent them:
- Forgetting to record a transaction: Make it a habit to log every cash movement immediately, not at the end of the day.
- Mixing cash and card sales: Only record cash on this sheet; card payments go into your sales report separately.
- Not counting coins: Coins add up. Always count them and include them in the actual count.
- Ignoring small differences: Even a $0.50 discrepancy can indicate a systemic problem. Always investigate.
- Not keeping receipts: Attach receipts for cash out transactions to the sheet for verification.
Daily Cash Sheet vs. Cash Register Tape
A cash register tape (or POS report) shows the total sales recorded by the machine, but it does not track physical cash movements like refunds or petty cash payments. The daily cash sheet complements the register tape by reconciling the actual cash in the drawer with the recorded sales. If the tape says you should have $500 but you only count $480, the cash sheet helps you pinpoint where the $20 went – perhaps an unrecorded refund or a miscount.
Frequently Asked Questions
Do I need a daily cash sheet if I use a POS system?
Yes, because a POS system records transactions but does not verify that the physical cash matches those records. A daily cash sheet is a manual check that catches discrepancies the system might miss, like an employee pocketing cash without recording a sale.
What should I do if the cash difference is large?
If the difference is significant (e.g., more than a few dollars), recount the cash and review the day’s transactions. If you still can’t find the error, report it to your manager or business owner immediately. Do not try to hide it, as that can lead to bigger problems.
Can I use a spreadsheet for my daily cash sheet?
Yes, many businesses use Excel or Google Sheets to create a digital daily cash sheet. You can set up formulas to automatically calculate balances and differences. However, you still need to print it out or sign it digitally for audit purposes.
How long should I keep daily cash sheets?
It’s best to keep them for at least three years, as that is the typical period for tax audits. If your business has specific record-keeping requirements, follow those guidelines or ask your accountant.
Is a daily cash sheet the same as a cash book?
No. A cash book is a more detailed ledger that records all cash transactions (including bank deposits and withdrawals) over a longer period. A daily cash sheet is a one-day snapshot used for daily reconciliation.
If your business has complex cash handling or tax reporting needs, consult a qualified accountant or financial professional to ensure you meet all legal requirements.