Last Updated on
This cashbook has similar functions to the already published household account book, but it is developed for entrepreneurs and/or companies in which cashbook management is a necessary procedure. This is the point why I have created this Excel template. The cashbook 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 cashbook template. This takes into account VAT rates of 7%, 19% or 0%. You can find it at the end of the article.
Have a look at the screenshot of the cashbook excel template
Cashbook Excel template
Download the cashbook template for free
Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.
- Cashbook excel file download in format .xls
- Cashbook excel file download in format .xlsx
- Cashbook excel template download in format .xltx
- all files in a zip
Cashbook with VAT Excel Template
As it is mentioned above, here is an Excel template of a cashbook with VAT. As I needed more columns in this template, I have created it in a landscape mode.
VAT-cashbook Excel template
Download the cashbook with VAT template for free
Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.
- Cashbook with VAT excel file download in format .xls
- Cashbook with VAT excel file download in format .xlsx
- Cashbook with VAT excel template download in format .xltx
- all files in a zip
Update: Tax Law
In accordance with the new legislation, cashbook management in Excel is not authorized or is not recognized as such. The cashbook 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.
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