A daily cash book is a record that lists the cash coming into and going out of a business's till in date order and shows the remaining cash balance on every row. In this template you enter the opening balance once and it carries over to the following days automatically; at the end of the day, when you count the till and enter the amount you counted, the difference between it and the book — a cash shortage or a cash surplus — is calculated automatically and color-coded.
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
| Column | What it does |
|---|---|
| Date / Slip No. | The day of the movement and the number of the slip, receipt or bank statement entry it is based on. Writing the slip number makes it easier to match an amount with its document at month end. |
| Transaction Type | Opening balance, cash sale, collection, payment, expense, deposit to bank, withdrawal from bank, staff advance. Chosen from a drop-down list. Track an advance's remaining balance per person and its deduction from salary in the staff advance tracking template. |
| Description | Where the money came from or where it went. This is the first column you will look at when searching for a cash difference. |
| In (₺) | Cash coming into the till: cash sales takings, collections on credit sales, money withdrawn from the bank. |
| Out (₺) | Cash leaving the till: supplier payment, expense, staff advance, amount deposited to the bank. For outgoing payments with no receipt or invoice (daily wages, advances, cash refunds), use the cash payment voucher template for the document the recipient will sign, and write the voucher number in the Slip No. column. |
| Cash Balance | Automatic: all inflows up to that row minus all outflows. The next day's opening balance is not entered separately; the balance carries forward by itself. |
| End-of-Day Count (₺) | The amount you get when you physically count the cash drawer. Enter it only on the last row of the day; rows left blank are ignored. |
| Count Difference | Automatic: counted amount minus the ledger balance. A negative value is a cash shortage, a positive value is a cash overage. |
| Status | Automatic: if the difference is zero it shows BALANCED (green), if negative CASH SHORTAGE (red), if positive CASH OVERAGE (yellow). |
No. The books that must be kept under tax law are your accountant's responsibility, and this file does not replace them. Its purpose is your own daily cash control: comparing what should be in the drawer with what is actually there.
The income and expense tracking template measures profit and loss: it totals amounts by category and VAT, and records the payment method even when it isn't cash. The cash book tracks only cash and answers a single question: how much money should be in the drawer right now? Using the two together works best.
No. Amounts that go through the POS don't enter the drawer as cash; they go to the bank. Record only the money that physically goes into and out of the drawer in the cash book, and track card sales in the income and expense template with the "Credit Card" payment method.
First compare that day's rows against your documents: an expense that wasn't recorded, a change-giving mistake or an uncollected payment that wasn't logged are the most common causes. Don't delete the difference — once you find the cause, enter it as a correction row, and if you can't find it, leave the difference as it is. Seeing the days when a shortage repeats tells you more than the difference on any single day. If you want to close the count with a signed document at a cashier changeover or at month end, use the cash count report example Excel template, which comes with a banknote breakdown and the cash difference ready.
No, only once — on the day you start the ledger. Because the Cash Balance column calculates a running balance, the next day's opening balance carries forward automatically. If you add a separate opening balance row each day, the balance will be counted twice.
When a customer pays an old debt in cash, enter the amount in the Cash In column with Transaction Type "Payment Received" — it is not a new sale made that day, it is a previously recorded receivable returning to the drawer. That is why you also need to close the same amount in your customer credit (veresiye) records; if one of the two sides is missed, the cash will balance but the customer will still appear to owe money. To track customer credit separately, use the customer credit ledger (veresiye) template; for a step-by-step way to ask for an overdue debt, see the guide how to collect customer credit (veresiye). One of the most common causes of a cash shortage is a customer credit payment that was collected but never written in the ledger; issuing a numbered payment receipt when you take the payment lets you compare the cash book with the receipt stubs at the end of the day.
Counts the money in the drawer by banknote and coin denomination, compares it with the recorded balance and works out the cash shortage or overage; a printable document for the person handing over and the person taking over to sign.
Totals income and expenses by category; calculates VAT, the grand total and net profit/loss automatically.
A statement table that tracks the debit–credit balance per customer or supplier account across all transactions and gives due-date warnings.
A digital ledger that automatically calculates, per customer, the credit extended, the amount paid, the remaining balance and the number of days overdue.
Last updated: October 3, 2026
Search terms: daily cash book exampledaily cash book excelcash book excel templatecash book with opening balance excelcash tracking sheet exceldaily cash report excel