Membership Paid Up To Date

Follow

A membership recurring payment instruction (RPI) has a Paid Up to Date this is calculated based on payments received and can be used to find memberships that have missed payments - e.g. to contact the member or to lapse or expire memberships.

Membership payments are considered to be in advance - i.e. a monthly payment made in May is paying for June.  

When the member joins their paid up to date will be empty until they have made their first payment, if the member is paying by

  • Stripe we will collect their first payment immediately and set the paid up to date as follows e.g. if someone joins in September 2021 this how the first and second payments are handled
Paying every First Payment Collected Paid Up to Date after first payment Second Payment collection Paid Up to Date after second payment
Month September 2021 30th September 2021 October 2021 31st October 2021
Year September 2021 30th September 2022 September 2022 30th September 2023
Quarter September 2021 30th November 2021 November 2021 28th February 2022
Half Year September 2021 28th February 2022 February 2022 31st August 2022

 

  • GoCardless then we need to have time to set up a direct debit and process a payment - therefore if the member joins before the 22nd of the month we have time to set up a direct debit and collected the first payment in the month they join - this how the first and second payments are handled
Paying every First Payment Collected Paid Up to Date after first payment Second Payment collection Paid Up to Date after second payment
Month September 2021 30th September 2021

October 2021

31st October 2021

Year September 2021 30th September 2022 September 2022 30th September 2023
Quarter September 2021 30th November 2021 November 2021 28th February 2022
Half Year September 2021 28th February 2022 February 2022 31st August 2022

 

  • If a member paying by GoCardless joins on or after the 22nd of the month we do not have time to set up a direct debit and process a payment in the month they join, therefore we set the payments to start in the next month - this how the first and second payments are handled
Paying every First Payment Collected Paid Up to Date after first payment Second Payment collection Paid Up to Date after second payment
Month October 2021 31st October 2021 November 2021 30th November 2021
Year October 2021 31st October 2022 October 2022 1st October 2023
Quarter October 2021 31st December 2021 December 2021 31st March 2022
Half Year October 2021 31st March 2022 March 2022 30th September 2022

 

  • If payments are being collected via a different method (e.g. standing orders) then the payments should be reconciled using an EFT Batch - see this for more information. When the batch is posted the paid up to dates will be updated.

How is the Paid Up to Date Calculated?

We take the month and year the payment belongs to - e.g. if payment is received for September 2021 and the paid up to date was 30/9/2021 - we then add a number of months based on the payment frequency of the RPI - e.g.

Payment Frequency Months Added to Paid Up to Date Paid Up to Date set to
Month 1 31/10/2021
Year 12 30/9/2022
Quarter 3 30/12/2021
Half Year 6 31/3/2022

Late or Missed Payments

If payments have been missed then these will be ignored when setting the Paid Up to Date, for example for a monthly paid membership which missed payments in January and February the paid up date  would be updated as follows

 

Month / Year payment is due Payment Received? Current Paid Up to Date New Paid Up to Date
December 2020 Yes 31st December 2020 31st January 2021
January 2021 No 31st January 2021 Not Changed
February 2021 No 31st January 2021 Not Changed
March 2021 Yes 31st January 2021 30th April 2021
April 2021 Yes 30th April 2021 31st May 2021

Note that if the paid up to date is currently a date after the date it would be set to when the payment is processed then the paid up to date will not be changed. For example, if a backlog of standing orders are being processed.

 

Donorfy_Professional_Image_for_Support_Guides.jpg

Memberships is a Professional-only feature. Essential subscribers, please contact us to find out more about upgrading.

 

Donorfy_Academy_logo.png
The Donorfy Academy features a learning course for Memberships - enrol here

Comments

0 comments
Please sign in to leave a comment.
Powered by Zendesk