💰 Free Daily Cash Report Template
Below is a template for tracking daily cash movement — the opening balance, money in, money out, and the closing count.
A daily cash report reconciles the physical cash in your till or safe at the end of each day. It is essential for retail, hospitality, and any business that handles cash. Without it, shortages go unnoticed until they become significant.
Daily Summary
| Fields | Description |
|---|---|
| Date* | Business day. |
| Opening Cash* | Physical cash counted at start of day. |
| Cash Sales* | Revenue received in cash. |
| Cash Received (Other) | Refunds, loans, owner contributions. |
Cash Out
| Fields | Description |
|---|---|
| Petty Cash Expenses* | Small purchases paid from the till. |
| Cash Paid Out | Supplier payments, owner draws. |
| Refunds Paid | Cash refunds to customers. |
Closing
| Fields | Description |
|---|---|
| Expected Cash* | Opening + cash in − cash out. |
| Counted Cash* | Physical cash counted at close. |
| Variance* | Expected − counted. Positive = over, negative = short. |
| Cash to Bank | Amount deposited at end of day. |
Sign-off
| Fields | Description |
|---|---|
| Prepared By* | Person who counted. |
| Verified By | Manager or supervisor. |
How to use
- 1Count cash at the start and end of every business day.
- 2Record every cash transaction — even small ones.
- 3Investigate any variance over €5 immediately.
- 4Deposit excess cash to the bank regularly to limit risk.
Or automate this
Counting cash by hand is slow and error-prone. Nika reconciles digital payments, tracks cash from POS data, and flags variances automatically — from {price} per day.
Questions
What is an acceptable cash variance?
Ideally zero. In practice, small variances (under €2–3 per day from rounding) are common. Anything larger indicates a process problem — miscounting, wrong change given, or theft.
Should I keep cash in the till overnight?
No. Deposit excess cash to the bank or move it to a safe. Leaving cash in the till is the most common cause of small-business theft.
Other templates
- 🧾 Free Invoice Template for Small Business
- 📊 Free Expense Report Template
- 📒 Free Bookkeeping Spreadsheet Template
- 🗂️ Free Chart of Accounts Template
- 📦 Free Purchase Order Template
- ↩️ Free Credit Note Template
- 📋 Free Vendor Payment Tracker Template
- ✅ Free VAT Return Checklist Template
- 🧾 Free Receipt Tracking Template
- 🏦 Free Bank Reconciliation Template
- 💸 Free Accounts Payable Template
- 📥 Free Accounts Receivable Template
- 🚗 Free Mileage Log Template
- 📈 Free Profit and Loss Statement Template
- ⚖️ Free Balance Sheet Template
- 💧 Free Cash Flow Statement Template
- 📋 Free Proforma Invoice Template for Small Business
- 💬 Free Quote Template for Small Business
- 📊 Free Small Business Budget Template
- ⏱️ Free Employee Timesheet Template
- 📦 Free Packing Slip Template
- 💵 Free Petty Cash Log Template
- 🚚 Free Delivery Note Template