Analyses and reports

What is this?

In the Reports area you evaluate your cashbook from various perspectives. Whether for board meetings, general meetings, grant applications or simply your own overview: here you get all important figures cleanly prepared as PDF or Excel.

Standard reports:

• Income/expense overview — comparison of all income and expenses per period
• Category report — breakdown by entry category (e.g. how much for sheet music)
• Account movements — all entries per account with opening and closing balance
• Donation list — all donations of the period with donors and amounts
• Membership fee report — overview of open and settled fees
• Balance list — all accounts with current state on the cutoff date
• Comparison report — running year vs. previous year

How to create a report

1. Open Administration > Cashbook > Reports.
2. Choose the desired report from the list.
3. Set the period — running year, previous year, quarter, custom period.
4. Optional: filter by account, category or tag.
5. Click Show preview to see the report in the web view.
6. Click Download PDF or Export Excel for further use.

Reports for typical occasions

• General meeting → income/expense overview entire fiscal year + category report
• Board meeting → income/expense overview running quarter + balance list
• Grant application at foundation/municipality → income/expense of previous year + donation list
• Tax advisor appointment → balance list plus compliance export (see Export area)
• Cash audit → all reports of the fiscal year + receipts

Permission

To view and export you need cashbook.view. Some reports (e.g. with donor names) may additionally be restricted to board or treasurer — that depends on the permission group settings.

Tips

• Before every general meeting create at least the income/expense overview and the category report — both are the standards for treasurer reports.
• Compare regularly with the previous year to spot trends — e.g. strongly rising hall rents or declining membership fees.
• Save important reports as PDF in the club archive — even though they can be regenerated at any time, an archived version with date is useful for later research.
• Use Excel export for grant applications — many foundations want to process the data further.