Free Cashbook as Excel Template

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

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 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

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.

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.

 

8 thoughts on “Free Cashbook as Excel Template”

  1. 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.

    Reply
    • 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

      Reply

Leave a Comment