Daily cash close worksheet
A fictional cash-drawer example in one currency. Card sales and credit sales are outside this cash count. Record the final 20 only after finding the expense receipt.
A free Zawid worksheet
Worked example
| Movement | In | Out | Balance | Reference |
|---|---|---|---|---|
| Opening cash | 500 | 0 | 500 | Opening count |
| Cash sales | 1800 | 0 | 2300 | Sales records |
| Debt collected | 300 | 0 | 2600 | Receipt |
| Owner funds | 200 | 0 | 2800 | Funding record |
| Cash purchases | 0 | 400 | 2400 | Supplier invoice |
| Expenses | 0 | 180 | 2220 | Receipts |
| Cash refund | 0 | 100 | 2120 | Refund record |
| Owner withdrawal | 0 | 150 | 1970 | Drawings record |
| Bank deposit | 0 | 1000 | 970 | Deposit receipt |
| Documented missing expense | 0 | 20 | 950 | Delivery receipt |
Before finding the missing receipt: expected 970, counted 950, shortage 20. After verifying and recording that expense: expected 950, counted 950, difference zero. Do not invent an entry to hide an unexplained shortage.
Use your own records
Period:Currency:Reference:
| Movement | In | Out | Balance | Reference |
|---|---|---|---|---|
Notes and differences to investigate: