Daily Cash Book
Keeps a day-by-day record of cash going into and out of the cash box; automatically finds the difference between the end-of-day count and the book.
Cash Count Report Example (Excel Template)
A cash count report is a document that records that the cash in a drawer was physically counted at a specific date and time, how much the count came to and whether it matches the cash balance in the records, and that is closed with the signatures of those present at the count. It should not be confused with the cash book: the book keeps a running record of money going into and out of the drawer throughout the day — for that there is the daily cash book Excel template. The count report, on the other hand, freezes the drawer at a specific moment, counts it and puts the result under signature: at the end of the day, at a cashier changeover, at month or year end, or in a surprise audit. The first tab of this file is the printable report itself: a breakdown of money from the 200-lira note down to the 5-kuruş coin, the slips and receipts in the drawer, the recorded balance, the cash difference and three signature blocks are all ready. You only enter the quantities and the balance; the totals and the difference are calculated by formula.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 30 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Report No / Count Date / Time | The report's serial number and the moment the count was made. If the drawer is also used during the day, the time shows after which transaction the count was taken. |
| Count Reason | Drop-down list: end-of-day close, shift / cashier handover, month end, year end, surprise count. The same report is also used as a cash handover record. |
| Business / Branch / Cash Officer | Which business's drawer was counted, and who was responsible for the drawer at the time of the count. |
| Cash Breakdown | For each banknote and coin value you enter only the quantity; the amount and the total counted cash are calculated automatically. If a denomination is not in the list, just change the value on that row. |
| Documents in the Drawer | Payments that have left the drawer but haven't been entered in the book yet, such as expense slips or employee advance receipts. Because they sit in the drawer in place of cash, they are added to the count; write the document number in the description. |
| Recorded Cash Balance | The amount that should be in the drawer at that moment according to the cash book or the software you use. It is the other half of the comparison and is typed in by hand. |
| Cash Difference and Status | Automatic: (counted cash + documents) − recorded balance. A negative result reads CASH SHORTAGE, a positive result CASH OVERAGE, and zero "No difference". |
| Remarks and Signature Blocks | The known cause of the difference, or an objection by one of the parties, is written in the remarks field. Signature blocks: the person handing over the drawer, the person who did the count, the person taking over / authorized person. |
| Count Records (Data tab) | A single-row record of each report with its date, drawer, responsible person, recorded balance and counted amount. The difference and status are calculated by formula; the Summary tab shows in how many counts there was a shortage and the total shortage. |
How to use it
- Download the file and on the "Cash Count Report" tab fill in the report number, date, time and count reason; write the name of the person responsible for the drawer.
- Stop all transactions from the drawer during the count. Sort the money by denomination and fill in only the "Quantity" cell for each value; the total counted cash comes out on its own.
- Write the slips and receipts that sit in the drawer in place of cash in the "Documents in the Drawer" section, with their document numbers.
- Enter the current cash balance from your cash book or software in the "Cash balance that should be in the drawer according to the records" cell; the cash difference and the status (shortage / overage / no difference) are calculated.
- If there is a difference, have a second person recount the money, write the known cause of any remaining difference in the remarks, print the report and have it signed, then add the result as a single row on the "Data" tab.
Who is it for?
- Supermarkets, grocers, pharmacies and kiosks that want to close the drawer at the end of the day and put the result on paper
- Cafés, restaurants and gas stations that hand the drawer over from one cashier to the next at a shift change by counting it
- Business owners who leave the drawer with an employee and want to do surprise counts
- Businesses with several branches or drawers that want to follow the count results in one place
- Those who want to give their accountant the month-end or year-end cash balance in a signed document
Frequently asked questions
What is a cash count report?
A cash count report is a document, signed by those present at the count, that records that the cash in the drawer was physically counted at a specific date and time, the amount counted and the difference between that amount and the cash balance in the records. Its purpose is to put the fact that "at this hour this drawer held this much money" on record in a way that can't be disputed later; when a cash shortage or overage turns up, this document also shows the moment at which it appeared.
Is a cash count report the same thing as a cash book?
No. The cash book writes down, in order, every amount that goes into and out of the drawer during the day and tells you how much money should be in it. The report, on the other hand, counts the actual money in the drawer at a specific moment and compares it with the balance in the book. You take the "recorded balance" figure in the report from the book; for the book you can use the daily cash book template.
How do you count a cash drawer?
No transactions are made from the drawer during the count. The money is first sorted by denomination — banknotes by value, coins separately — and the quantity of each denomination is written down. Documents that sit in the drawer in place of cash, such as slips and receipts, are listed separately. The total of the counted cash and the documents is compared with the balance that should be in the drawer according to the records. If there is a difference, someone other than the first counter repeats the count; the remaining difference is written on the report and the report is signed.
Can it also be used as a cash handover record?
Yes. Choose "Shift / cashier handover" from the Count Reason list; in the signature blocks, "Handed over by" is the person leaving the drawer and "Received by / authorized person" is the person taking it over. That way, there is no dispute about which shift a shortage found after the handover belongs to. For the same job on products when stock changes hands, the stock count report template does the work.
What should be done if there is a cash shortage or overage?
First the money is recounted by a second person, then that day's records are checked: an expense that wasn't recorded, a change-giving mistake, or a sale or collection whose entry was skipped are the most common causes. If the cause is found, the correction is entered in the book; if it can't be found, the difference is written on the report and in the remarks as it is. In Turkish accounting, the Uniform Chart of Accounts (Tekdüzen Hesap Planı) has account 197 Count and Receipt Shortages and account 397 Count and Receipt Overages for unexplained cash count shortages and overages; decide with your accountant how the entry should be closed.
Is a year-end cash count report mandatory?
How the cash on hand is shown in the year-end inventory depends on tax legislation and the business's type of books, so we don't state a definite rule here; consult your accountant for the legal requirements. This template is an example for recording the cash count in an orderly document, not an official form; you can change the text and fields to the layout your accountant wants.
Is there a cash count report example in Word?
The file is in Excel (.xlsx) format because the money breakdown amounts and the cash difference are calculated by formula, and Word can't do that calculation. You can open it in Excel, Google Sheets or LibreOffice and print it directly or save it as a PDF. If you need to keep the document in Word, fill in the report tab, then copy it and paste it into Word; the numbers are fixed at their current values.
Is the template free, and is membership required?
Yes, it is free. The file doesn't ask for email, sign-up or payment, and it has no watermark or cell protection. You can change the business name, the count reasons and the report text to suit yourself.
Related templates
Stock Count Report
A printable report, signed by the counting team, that records when, where, and by whom the count was done and its result; the result figures come automatically from the product list.
Collection Receipt
A printable two-copy receipt that documents a payment received from a customer with the date, serial no., amount (in figures and words), payment method, and remaining balance owed; the list of issued receipts is on a separate tab.
Income and Expense Table Excel
Totals income and expenses by category; calculates VAT, the grand total and net profit/loss automatically.
Last updated: September 25, 2026
Search terms: cash count reportcash count report example excelcash handover reportcash handover report exampleyear-end cash count reporthow to count a cash drawer