Benefits: 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.
File Description: The file contains a
Microsoft Excel (version 4.0 and above) spreadsheet template. Once you've
downloaded the file, you must copy it to your EXCEL\XLSTART directory in order
to use it.
cash sheet template
- 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.
Back to Template Menu