Which categories are included?

The 57 most-used income and expense categories for associations, foundations, mosques and weekend schools — identical to the categories in the Aqlemy online cashbook, so a later migration needs no re-categorising.

How does the annual overview work?

Each monthly tab totals automatically; the overview sheet shows income, expenses and result per month, the balance development and annual totals per category — the direct input for your income statement.

All free templates

Free cashbook Excel template for associations & foundations

100% freeNo email requiredUpdated for 2026

Last updated: 28 July 2026 · Version 2026.1

In short

Is an Excel cashbook enough for our organisation?

For a small organisation with a few dozen entries per year: yes, provided you book consistently. As transactions grow, an online cashbook with bank import and receipt attachments quickly becomes more reliable.

This free cashbook was built for treasurers of associations and foundations — not a freelancer template you have to rebuild first. Twelve monthly tabs, dropdown lists with 57 recognisable categories and an annual overview that keeps itself up to date.

The categories are identical to those of the Aqlemy online cashbook: start in Excel today and migrate later without re-categorising.

Downloads

The files are in Dutch — they follow the Dutch rules for associations and foundations.

What's inside?

12 monthly tabs with automatic monthly totals
57 income and expense categories in a dropdown — from contributions and donations to rent and bank fees
Annual overview: result per month, yearly totals per category and the balance development
Settings tab for organisation name and opening balances of cash and bank
Payment method column (cash/bank/POS) for a smooth audit

ShareWhatsApp LinkedIn X

Not sure where to start?

Take the governance scan: ten questions, two minutes. You will see straight away which points weigh most for you — each with the template that solves it.

Start the governance scan

Stay current when regulations change

Leave your email address and receive the updated version whenever the rules change (such as WBTR or ANBI amendments). A few emails per year at most, no newsletter.

More templates in this category

Use & attribution

This template is free. You may use, adapt and pass it on — including outside your own organisation. Publishing it on your website or in a newsletter for your members? Link to this page instead of copying the file; that way everyone automatically gets the latest version.

Ready-made link

<a href="https://aqlemy.com/en/templates/kasboek-excel">Free cashbook Excel template for associations & foundations — Aqlemy</a>