Recurring report¶
In short: Open Reports, then Recurring in the Donations panel (or go to /reports/recurring). The report lists every recurring donation, whether it runs as a debit order, a card subscription or a manual recurring, with its status, monthly amount, last donation and total received so far. You need the View Reports permission.
Overview¶
The Recurring Report gives you one list of all your monthly givers. Use it to see how many recurring donations are active, how much they bring in each month, and which ones have stopped or failed. The page notes: "This report shows all recurring donations: debit orders (Paysoft), card subscriptions (PayFast) and manual recurrings."
📌 Note: This report is part of ActiveDonor's fundraising features. Setting up and managing recurring donations is covered in Recurring donations and Paysoft debit orders and mandates.
Before you start¶
You'll need:
- The View Reports permission.
- At least one recurring donation captured. If there are none, the table shows "No recurring donations found".
Running the report¶
Step 1: Open the report¶
Open Reports from the main navigation, then click Recurring in the Donations panel. Its description reads "Debit orders, card subscriptions and manual recurrings with last donated and total received." An older address, /reports/debit-orders, redirects here.
Step 2: Filter the list¶
Use the sidebar filters (see Field reference), then click Apply Filters. Click Clear Filters to start again.
The summary cards¶
Two cards appear above the table. Both count only recurring donations with the status Active that match your filters:
- Active Recurring: how many active recurring donations there are.
- Total Monthly Amount: the sum of their monthly amounts.
The results table¶
The heading shows the total count, for example All Recurring Donations (42). The table has these columns:
| Column | What it shows |
|---|---|
| Donor | The donor's name, linked to their profile. N/A if no donor is linked. |
| Project | The project the donation goes to, or N/A. |
| Vendor | How it is collected, for example Paysoft (debit order) or PayFast (card). Recurrings with no payment provider show Manual. |
| Debit Day | The day of the month the debit runs, or N/A. |
| Status | A coloured label: 🟢 Active; 🔴 Declined or Rejected; 🟡 Cancelled; other statuses in blue. |
| Period | Start date to end date (dd/mm/yyyy). N/A when no end date is set. |
| Amount | The monthly amount. |
| Last Donated | The date of the most recent receipt linked to this recurring donation. |
| Total Received | The total of all receipts linked to this recurring donation. |
Use Rows at the bottom to show 10 (default), 25, 50 or 100 rows per page.
Exporting to Excel¶
Click Export to Excel to download every matching recurring donation as a spreadsheet named ActiveDonor Recurring Report - <date and time>.xlsx. The export has the same columns as the table plus Donor No. The button is disabled when no recurring donations match. Each export is recorded in the Activity Log as "Recurring report was exported".
How "Last Donated" and "Total Received" are worked out¶
Both figures come from the receipts linked to each recurring donation. A debit order or card payment only counts once a receipt has been captured for it. If a recurring donation shows R0.00 and N/A, no receipt has been linked to it yet.
Field reference¶
| Filter | Values |
|---|---|
| Vendor | One or more payment providers in use, plus Manual for recurrings with no provider. |
| Project | One or more projects (archived projects included). |
| Status | One or more of the statuses that exist on your recurring donations, for example Active, Cancelled, Declined. |
| Debit Day | One or more debit days in use. |
| Monthly Amount | Any, or a comparison (greater than, equal to, less than) plus an amount. |
Common issues & solutions¶
| What you see | What it means | How to fix it |
|---|---|---|
| "No recurring donations found" | No recurring donation matches your filters, or none has been captured yet. | Click Clear Filters. If the list is still empty, no recurring donations exist yet. |
| Export to Excel is greyed out | The current filters match no recurring donations. | Change or clear the filters. |
| Total Received is R0.00 for a debit order you know has run | No receipt has been captured and linked to that recurring donation yet. | Capture or import the receipt for the debit. |
| The Recurring row is missing from the Reports dashboard | You don't have the View Reports permission, or recurring donations are switched off for your account. | Ask an administrator for View Reports; see Roles and permissions. |
FAQ¶
Where do I see all my debit orders? Open Reports → Recurring. Filter Vendor to Paysoft to see debit orders only.
How much do my monthly donors give in total? The Total Monthly Amount card adds up the monthly amounts of all Active recurring donations that match your filters.
Why does a cancelled debit order still appear? The report lists recurring donations of every status. Filter Status to Active to see only live ones.
Can I export the list? Yes. Click Export to Excel.