Run a financial report

This guide shows you how to open a pre-built financial report, set filters, run it, and read the results — covering the Revenue summary, Aging receivables, and Cash Flow reports.

Who can do this: Admins with the reports:run and reports:view permissions. The Aging receivables report additionally requires reports:view-finance to view per-member rows.

Before you start

You have payment or membership data in MapleGather for the period you want to report on.

Steps

Each financial report has the same basic shape: pick a report, set filters, and select Run report. The sections below walk through each report type.

Run a revenue summary report

In the admin sidebar, select Reports. The reports list shows: Revenue summary, Aging receivables, Cash Flow, Refunds, and Tax by jurisdiction.
Select Revenue summary.
Set your date range using the From and To date pickers. The end date must be after the start date.
Choose your revenue basis:
- Accrual (default) — revenue counted when you billed it (the invoice date).
- Cash — revenue counted when the money arrived (the payment date).
- Select the ? next to the basis toggle to see a plain-language explanation. Most bank reconciliation uses Cash basis.
By default, test-mode payments are excluded. Turn on Show test-mode to include sandbox data — a blue banner will appear so the figures are clearly marked as including test payments.
Select Run report. While the report runs, you’ll see a loading indicator in the result area.
When the report finishes, a revenue-by-period table appears. The footer notes which basis is shown.

If you change filters after the report has run, the prior result dims and a warning appears: “Filters changed — these numbers are from your last run. Run report to refresh.” Select Run report again to update.

Run an aging receivables report

In the reports list, select Aging receivables.
Set the As of date (defaults to today).
Optionally filter by member or membership level.
Select Run report.
The results table shows per-member rows sorted by balance, with columns for 0–30, 31–60, 61–90, and 90+ days past due, plus per-bucket subtotals.
Rows where the member’s status is lapsed show a “Member lapsed” label — useful for prioritizing collections.
Select a row to go to that member’s record (requires the reports:view-finance permission for per-member drill). If your role doesn’t include that permission, selecting a row shows an aggregate count for that bucket rather than the member’s record.

Run a cash flow report

In the reports list, select Cash Flow.
Choose a period (Monthly is the default; you can also select Quarterly or Annual) and a date range.
Select Run report.
The results show inflows, outflows, and net cash flow per period. A 12-month range shows one column per month with rolling totals.

Verify

You’ll know the report ran successfully when the results table populates and the footer shows the applicable revenue basis and date range. An empty table with the message “No revenue in this period” (or equivalent) means your filters returned no records — this is expected when no transactions occurred in the selected period.

If something goes wrong

“End date must be after start” — check your date range and correct the end date.
Report shows unexpected totals — check whether you’re on Accrual or Cash basis. The footer always states which basis is active. See Revenue: accrual vs. cash basis reference.
Report results are dimmed with a warning — your filters changed after the last run. Select Run report to refresh.
Report failed to run — select Retry in the result area.
For more, see Report shows no results or wrong totals.