Is much of your business transacted in cash? If so, precise control over your daily cash receipts is critical to the financial health of your business. To help you keep track of how much cash you take in and where it went — each day and right down to the penny — we have designed a simple reconciliation form, the Daily Cash Sheet, contained in the attached file. Just plug in your amounts for the day, and you will be alerted to any cash discrepancies, which may be the result of theft, an accounting error, a mistake when charging a customer, or an overlooked transaction.
You will also be alerted to any special transactions that occurred during the day, such as cash received from non-sales sources or cash paid out. All of this should result in better financial records and possibly even lower accounting fees if an accountant does your books.
After you download the form, you can customize it to fit the particular needs of your business.
The file contains a Microsoft Excel (version 4.0 and above) spreadsheet template.
Download:Daily-Cash-Sheet-1.xlsx (542 downloads)
- Download this spreadsheet template just once, and be able to use it to prepare a cash reconciliation every day.
- Items that usually need to be considered when reconciling your cash receipts are already listed — just take a couple of minutes at the end of each day to plug in your amounts.
- The template can be quickly customized to fit the special needs of your business.