Bookkeeping
Accounting software for an association or foundation: comparing membership fees, members and finances
Choosing accounting software for an association or foundation? Compare membership fees, SEPA direct debit, member management and cash audits with a worked example.
A treasurer needs an overview of membership fees, donations, budgets and outstanding items. See when general accounting software is enough and when membership management is needed too. With a worked membership fee round and tasks for a software demonstration.
The administrative tasks of an association or foundation
Managing the administration of an association or foundation requires specific functions that are not standard in regular SME software. A treasurer generally deals with the following operational processes:
- Member management and fee groups: Keeping current member data with different rate categories (such as seniors, juniors and inactive members).
- Fee collection and SEPA direct debit: Creating batch files (in the SEPA PAIN.008 format) to collect membership fees periodically by direct debit at the bank.
- Tax processing: agree with your adviser which data your association has to record. Check whether the package can distinguish between different activities and money flows.
- Project budgets and committees: Monitoring income and expenditure per working group, event or committee against the approved association budget.
- Accountability to the AGM and funders: Preparing a clear balance sheet and a statement of income and expenditure for the General Members' Meeting (ALV), funds or grant providers.
For more background on general financial software, also see our overview of comparing accounting software.
General accounting package or specialised association software?
Boards often hesitate between two types of software: a standard financial package or industry-specific software for associations and foundations.
A standard accounting package offers a solid basis for the general ledger, bank integrations and VAT overviews. However, membership administration is usually missing from it. This means the treasurer often keeps member files in a spreadsheet and has to generate direct debit files manually via external tools. This increases the risk of inconsistencies between the member list and bank receipts.
Providers with an association proposition bring these components together. For example, the documentation on associations from e-Boekhouden.nl (checked on 10 September 2026) describes a special module for foundations and associations in which bookkeeping is linked to membership administration and fee collection. This makes e-Boekhouden.nl a relevant candidate to investigate when you want to bring membership management and bookkeeping together in one environment. See our profile of e-Boekhouden.nl for more details.
You can also use a separate membership package alongside the accounting. That is worth investigating if the membership administration works well and only the financial processing needs to improve. Then check how fees, payments and changes are exchanged, and who fixes errors in the integration. If your foundation has no members, compare Moneybird, for example, as a general administrative candidate. That is not a recommendation for a built-in association module.
Worked example: membership fee round of a sports club (fictional)
To illustrate how a membership fee round works administratively, we use a transparent worked example of a fictional tennis club with 240 members.
Composition of the member base and the fee
The fictional association has three membership types with set annual rates:
- 150 senior members at € 180,00 per year = € 27.000,00
- 60 junior members at € 110,00 per year = € 6.600,00
- 30 inactive members at € 45,00 per year = € 1.350,00
The total annual membership fee budget is: € 27.000,00 + € 6.600,00 + € 1.350,00 = € 34.950,00.
Breakdown by payment method
Not all members pay in the same way. The board has two groups:
- Direct debit (SEPA PAIN.008): 220 members have issued a mandate. This concerns 140 senior members (€ 25.200,00), 55 junior members (€ 6.050,00) and 25 inactive members (€ 1.125,00). The total collection amount in the SEPA batch file is exactly € 32.375,00.
- Manual bank transfer: 20 members receive an invoice with a payment request. This concerns 10 senior members (€ 1.800,00), 5 junior members (€ 550,00) and 5 inactive members (€ 225,00). The total value of these manual items is exactly € 2.575,00.
The sum of both flows matches the budget exactly: € 32.375,00 + € 2.575,00 = € 34.950,00 across 240 members.
Processing reversals
After the collection batch is submitted to the bank, 7 items are fictitiously reversed due to insufficient funds or a changed bank account: 5 senior members (5 x € 180,00 = € 900,00) and 2 junior members (2 x € 110,00 = € 220,00). The total reversal amount is € 1.120,00.
Use these seven reversals as a demonstration task: can the package feed the payments back to the right members and outstanding items? Also show an unrecognisable bank description. Check whether an employee can repair the link and whether no duplicate reminder is sent afterwards.
Have one membership fee round demonstrated
When selecting software for an association or foundation, you can use the criteria below as a guide during a demonstration or trial period:
| Task | Demonstration | Desired outcome |
|---|---|---|
| Member change | A member changes fee group halfway through the year | You can see which invoice follows and which change was recorded |
| Reversal | A collected payment is reversed | The correct item is open again without a duplicate invoice |
| Committee budget | A committee has a budget of €2.000 and has spent €1.450 | The remaining budget of €550 can be found |
| Cash audit | An auditor opens an entry and the attachment | The source is visible; editing is not possible for this role |
| Handover | The treasurer leaves | The board can give a successor access and revoke the old access |
Access rights and the audit committee
A healthy governance structure calls for segregation of duties. The treasurer enters bookings and prepares payments. Members of the audit committee, on the other hand, must be able to check the books without the risk of data being changed by accident. When selecting software, make sure the program supports accounts with read-only rights. This gives the audit committee digital access to invoices, bank transactions and general ledger cards, which makes time-consuming printing or exporting separate files unnecessary.
Preparing the board handover carefully
Board members change regularly. A good administrative handover prevents a successor from having to reinvent the wheel. Pay particular attention here to the separation between the Chamber of Commerce (KvK) and the bank:
Board handover plan (fictional example):
1. Make sure all bank and savings accounts are fully reconciled up to the handover date.
2. Draw up an overview of all outstanding membership fee items with the associated member numbers.
3. Register the new board with the Chamber of Commerce (KvK); then immediately arrange the change of bank mandates, login cards and digital tokens directly with the bank concerned.
4. Create your own main user profile in the accounting software for the new treasurer and revoke the access rights of the outgoing board member.
Which set-up suits your board?
The choice of accounting software depends on the operational complexity of your organisation. A small foundation with few transactions and donors can often manage perfectly well with a simple accounting package. However, if your association deals with varying membership rates, periodic direct debits and multiple committees, a package with a membership module is worth investigating. Assess the fit with the membership fee round above before you switch.
