Your bank provides Standing Order payments in BACS Standard 18 format (sometimes called a “reconciliation report” or similar), you can upload that file into Donorfy and automatically match the payments to existing Recurring Payment Instructions (RPIs) that use the Standing Order collection method.
⚠️Important: This is a Professional only feature. Essential subscribers, please contact us to find out more about upgrading.
1. Before You Start
To use a Standing Order file for reconciliation, each constituent who donates by Standing Order must already have a Recurring Payment Instruction set up.
For each relevant RPI:
The Collection Method must be set to Standing Order.
The Reference on the RPI must match the payment reference your bank includes with each Standing Order payment.
You can optionally store partially masked sort code and bank account numbers on the RPI if required.
A collection method of Standing Order should be treated as a Recurring Gift. See the related article on Flag donations as Recurring Gifts for more details.
2. Import the Standing Order File
Go to Data Management, click File Upload.
Upload the Standing Order file provided by your bank in BACS Standard 18 format.
Your bank may label this file as a reconciliation report or similar in their online banking system.
Donorfy will read the file and use the reference in each payment line to find the matching Recurring Payment Instruction.
3. Review Matches and Unmatched Payments
After the file is checked:
If all references in the file match existing RPIs:
You can apply the file, and the Standing Order payments will be added to the timelines of the relevant constituents.
If one or more references cannot be found:
A warning message will be displayed indicating that some payments could not be matched.
If you choose to apply the file anyway:
Any matched payments will be added to the relevant constituents’ timelines.
Any unmatched payments will be ignored (not imported).
You can download the checked file from the upload screen to see exactly which payments could not be matched, then:
Correct the references in Donorfy or in your bank file (if appropriate), and
Re-upload the corrected file if needed.