Skip to main content

Analyse and Report on Recurring Payments

Donorfy stores detailed information about Recurring Payment Instructions (RPIs), enabling you to analyse income patterns, donor behaviour and the performance of regular giving or membership programmes.

Cristina Gruita avatar
Written by Cristina Gruita
Updated this week

This article outlines how to use RPI Lists to report on recurring income. You will begin by creating a Recurring Payment Instruction List, and for deeper analysis, you may export the results to CSV for use in Excel or another reporting tool.


How do I:

Find everyone who missed a payment this month (or last month etc)?

Create a list with a filter for the LastPaymentMissedYear & LastPaymentMissedMonth you are interested in - the months as stored as numbers 1 for January etc

Find everyone who has missed payment(s)?

Use a list with a filter for Status = Overdue

Find recurring payment instructions that will end on a certain date?

Filter for AllocationEndDate for date you are interested in - if an instruction has several payments running this will be the first one to finish

Send information or a membership pack to all current members whose are due one this month?

Make sure you are only including active instructions by filtering for Status = Activeand then choose the month based on StartMonth = month you are interested in

Send a thank you to my regular donors?

Make sure you are only including active instructions by filtering for Status = Activeand could then restrict things further e.g. by month based on StartMonth, or PaymentFrequency

Thank people who have recently signed up as a regular donor?

Filter for DateAdded to find new recurring payment instructions

Analyse how campaigns, funds, channels, products and so on are performing?

One recurring payment instruction can contain multiple payments and allocation - when you create a list of recurring payment instructions the campaigns, channels etc are stored in a comma separated list - in addition the payment and allocation amounts are stored in a corresponding comma separated lists called PaymentsBreakdown and AllocationsBreakdown

Download the list into Excel and use the tools their to analyse the data further

Work out expected income?

Make sure you are only including active instructions by filtering for Status = Active then the amount will be the amount you can expect - you can use the PaymentFrequency to know whether its every month, or year etc

To perform more complex cash flow analysis you could download the list into Excel - the StartMonth will help determine which months payments can be expected

Find recurring payment instructions that have been cancelled.

You will need to use the filter for Cancel Date
You can then set your preferred date range or use a dynamic date such as isToday or Is in this Month, etc.

Did this answer your question?