This cash book has similar functions to the already published household book, but it is developed for entrepreneurs and/or companies in which cash book management is a necessary procedure.
This is the point why I have created this Excel template. The cash book is free and can be downloaded in the section “Download”.
It sums expenditures and income, determines current cash balance and even takes into account opening cash balance.
Inspired by a comment, I have created the second cash book template. This takes into account VAT rates (of 7%, 19% or 0% – these can be changed to any other value). You can find it at the end of the article.
Screenshot of the Cash Book Template
Cashbook Excel template
How does the Template work?
It’s simple:
- Download the Excel file and open it with MS Excel
- Change the month and the year
- Fill out the cell with the value of your opening balance
- List all expenses and income in the rows below
- The rest calculates automatically
Hint: Copy the worksheet for the upcoming month and name it accordingly.
And the Cash Book with VAT?
If you choose the cash book with VAT, you have to fill out the cells for the VAT on your sold and bought items. You can change the columns-value to any other one. But keep in mind, the values don’t calculate automatically.
VAT Cash Book for June
Download the Cash Book Template for free
Here you find the template with or without VAT in Excel file format (.xlsx).
Keep in Mind: Tax Law
In accordance with the legislation, cash book management in Excel is not authorized or is not recognized as such. The cash book does not meet the “principles of proper accounting” and the company cannot be estimated on that account. The following also concerns associations, small businesses and freelancers.
Those who manage this book in Excel should print it and enter all the numbers by hand. Since then, there should be nothing to complain about.
Revision security: Whether digital or analog – your cash book must be kept in a way that it cannot be changed afterward. For this reason, Excel cash books are hardly within the range of what is allowed. Books in paper form must be free of blank lines, while entries may not be entered with a pencil or similar writing instruments.
Source: https://service.consultinghouse.eu/en/knowledge/company-cash-book
I want to download this cashbooks as excel templates files
use this
Thanks for sharing, Cashbook with VAT Excel Template I gonna use it. Dear Philipp, can you please make some tutorial or guides for this ms excel tool. I have been searching for a while but couldn’t find one. To Download https://www.excel-accounting-budget-analysis.com . In general It is budget analysis tool. Thanks in advance.
Thank you <3
I’m waiting for the free download.
Hi Luke,
you have to click on one of the links in the list.
Here is a screenshot of it:
You find the links under the download-headline in the article.
Cheers Philipp
interesting
waiting