Skip to content

Importing recurring donations

In short: Open Receipts, click the Recurring tab, then click the upload icon beside Add Recurring. Download the Excel template, fill in one row per recurring donation, choose the file, pick the Project, Receipt Method and Receipt Type that apply to every row, and click Import. Your donors do not need to be in ActiveDonor first. You need the Manage Receipts permission and an .xlsx or .xls file.

Overview

If you already have a list of donors who give regularly, you can import all their recurring donations at once instead of adding each one by hand. Each row in your file becomes one recurring donation. ActiveDonor matches each row to a donor you already have, or creates the donor from the row.

There are two formats:

Import from What you upload Use it for
Excel template One Excel file on the ActiveDonor template. Stop orders, EFTs and any recurring donation you receipt yourself each month.
Paysoft account Two Excel files exported from Paysoft: Agreements and Donors. Debit orders that Paysoft already collects for you. The Import from choice only appears if Paysoft is enabled on your account.

Before you start

You'll need:

  • The Manage Receipts permission.
  • An active Project, a Receipt Method and a Receipt Type to apply to the import. They apply to every row in the file.
  • Your donors do not need to exist in ActiveDonor first. Rows are matched to existing donors, and new donors are created where there is no match.
  • A file in .xlsx or .xls format. CSV files are not accepted here.

💡 Tip: For the ActiveDonor template, click Download Excel template on the import page to download activedonor-recurring-import-template.xlsx. Keep the column headings exactly as they are. Hover over a heading in Excel for a reminder of what goes in it. Headings in red are required.

⚠️ Important: You can only roll an import back while its results page is still open. Check the results before you leave the page or start another import.

Importing from the ActiveDonor template

Step 1: Open the importer

Click Receipts in the top navigation bar, then the Recurring tab. Click the upload icon beside the Add Recurring button. The Import Recurring Commitments page opens.

Step 2: Download and fill in the template

Click Download Excel template. On the recurring-importer sheet, fill in one row per recurring donation, starting in row 2. Several columns have dropdowns (Status, Recurring Period, ID Type, Bank Name). The Instructions sheet explains each column and shows two worked examples.

Step 3: Choose the file and the settings

Under Import:

  • Excel file: choose your filled-in template.
  • Project (required): the project every imported donation is allocated to.
  • Receipt Method (required): for example Stop Order or EFT.
  • Receipt Type (required).

Step 4: Import

Click Import. The results page shows Total Rows, Imported, Needs Review and Issues.

Importing from Paysoft

Step 1: Export the two files from Paysoft

In Paysoft, export your Agreements (one row per debit order) and your Donors. Use the files exactly as Paysoft exports them. There is no ActiveDonor template for Paysoft.

Step 2: Upload both files

On the Import Recurring Commitments page, set Import from to Paysoft account. Choose the Paysoft Agreements file and the Paysoft Donors file.

Step 3: Choose which agreements to import

Set Agreements to import to Active only, Inactive only or All.

Step 4: Choose the settings and import

Choose the Project, Receipt Method and Receipt Type, then click Import.

📌 Note: Each Paysoft agreement needs its Customer Code. A row without one is skipped with "Missing Customer Code", because ActiveDonor uses that code to match Paysoft's debit results to the donor and issue receipts automatically.

How rows are matched to donors

For each row, ActiveDonor looks for a donor you already have, in this order. The first match wins:

  1. Donor ID
  2. ID / Reg No (identity number)
  3. Email and Cellphone together
  4. Email
  5. Cellphone

If a donor is matched, the recurring donation is added to that donor. The donor's existing details are not changed.

If nothing matches and the name is not similar to anyone, a new donor is created from the row, with the email, phone, address and tax details in it.

If nothing matches but the name resembles a donor you already have, the row is held under Needs Review and nothing is imported for it until you decide.

Reviewing rows that need a decision

Click Needs review in the summary. Each row shows the Import Donor Name, the Existing ActiveDonor Match and the Amount.

Step 1: Choose an action for every row

In the Action dropdown, pick the existing donor if it is the same person, or Create new donor if it is someone else.

Step 2: Apply

Click Apply Decisions. Every row needs an action first, or you'll see "Choose an action for every row before applying."

📌 Note: Leaving the page discards the review list. Nothing was imported for those rows, so you can upload the same file again to rebuild the list. Rows already imported are skipped as duplicates.

Rolling back an import

On the results page, click Rollback Import and confirm. This deletes every recurring donation the import created and every donor the import created. Donors that existed before the import are kept.

Rollback is only available while the results page is open. Once you start another import or navigate away, that import can no longer be undone from here.

Field reference

Columns in the ActiveDonor template. Headings must match exactly.

Column Required? Notes
Donor ID No The donor's ActiveDonor number. Fill it in to attach the donation to an existing donor.
Salutation, First Name, Last Name No Used when a new donor is created.
Email, Cellphone No Used to match an existing donor, or saved on a new donor.
ID / Reg No, ID Type, Country of Issue, Tax No No Identity and tax details. ID / Reg No is also used to match an existing donor.
Address 1, Address 2, City, Province, Post Code, Country No Saved on a new donor.
Start Date Yes For example 01/09/2026. Also accepts 2026-09-01.
End Date No Same formats as Start Date. Blank uses one year after the start date.
Amount Yes The amount per period, for example 250.
Status No Active, Inactive or Declined. Anything else is treated as Active.
Debit Day Yes A number from 1 to 31.
Recurring Period No Monthly, Quarterly or Yearly. Anything else is treated as Monthly.
Reference No For example the donor's bank reference.
Account Holder (Optional), Account Type (Optional), Account Number (Optional), Bank Name (Optional), Service Code (Optional) No Bank details, kept on the recurring donation for your records.

Project, Receipt Method and Receipt Type are not columns. You choose them on the import page and they apply to every row.

Common issues & solutions

What you see What it means How to fix it
"The file must be an .xlsx or .xls file." The file is a CSV or another format. Save the file as Excel (.xlsx) and upload it again.
"Row 5: Debit Day must be between 1 and 31" The Debit Day on that row is empty or out of range. Enter a day from 1 to 31 and import the file again.
"Row 5: Start Date is missing or invalid" The Start Date is empty or not a date ActiveDonor can read. Enter it as DD/MM/YYYY, for example 01/09/2026.
"Row 5: Missing Customer Code" A Paysoft agreement has no Customer Code. Export the agreements from Paysoft again, or add the code in Paysoft first.
"Row 5: Commitment already exists for donor #123" That donor already has this recurring donation. Nothing to do. The row is skipped so it isn't added twice.
"Could not process the uploaded file: ..." The file could not be read. Check that it is the template (or the Paysoft export) with its headings unchanged.
"That import is no longer open. Please upload the file again." You tried to apply review decisions after leaving the results page. Upload the file again. Rows already imported are skipped.
"That import no longer exists and cannot be rolled back." You tried to roll back after leaving the results page. Cancel the unwanted recurring donations one by one on the Recurring page.

FAQ

Can I import a CSV file? No. The recurring importer accepts Excel files only (.xlsx or .xls). Save your CSV as Excel first.

Will importing create duplicate donors? It tries not to. Each row is matched to an existing donor by Donor ID, identity number, email or phone. If only the name looks similar, the row waits under Needs Review for you to decide.

Can I import the same file twice? Yes. Recurring donations that already exist are skipped, so only new rows are added.

Does importing a recurring donation create receipts? No. It only sets up the recurring donations. You issue each month's receipts on the Recurring page, and Paysoft debit orders are receipted automatically after each debit.

Can each row have its own project? No. The Project, Receipt Method and Receipt Type you choose apply to the whole file. Split your list into one file per project and import each separately.

Can I import quarterly or yearly donations? Yes. Set Recurring Period to Quarterly or Yearly in the template.

Does importing Paysoft agreements change anything at Paysoft? No. It records the debit orders Paysoft already collects, so ActiveDonor can receipt them. Nothing new is registered with Paysoft.

Need a hand?

If an import doesn't behave as expected, contact support with the file you uploaded and the Issues list from the results page.