Skip to content

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.