Export subscriptions

Pour :Administrateur

Preview: Export subscriptions

The Excel export lets you step back on all your subscriptions: data crossing, trend analysis, sharing with a treasurer or chartered accountant, periodic archiving.

Run an export

1. 1

   Open the Recurring payments screen

   Finance menu → Recurring payments (/app/paiements/recurrent).

2. 2

   Choose the status tab

   Select the tab that interests you: In progress, Paused, Expired card, Interrupted or Completed.

3. 3

   Apply the desired filters

   The export contains only the subscriptions currently displayed. See Filter subscriptions to target precisely.

4. 4

   Click on “Export”

   Button at the top right of the list.

5. 5

   Download the file

   The file export_abonnements_DD_MM_YYYY_HH_mm.xlsx downloads automatically.

Columns of the exported file

The Excel file contains the following columns, in this order:

Column	Content
Identifier	Unique identifier of the subscription
Creation date	Day of subscription
Cancellation date	If canceled, otherwise empty
Donor's last name	Contact last name
Donor's first name	Contact first name
Donor's email	Registered email
Donor's phone	If filled in
Billing type	Personal / Professional
Company name	If professional
Company ID	If professional
Billing address	Full address
Monthly amount	Sum charged each month
Planned number of direct debits	Planned duration (0 = unlimited)
Method	Bank card / Direct debit
Platform	Stripe, GoCardless, PayGreen…
Status	In progress, Paused, Expired card, Interrupted, Completed
Reason	Subscription type (Cash account, Pledge, Campaign…)
Tax receipt	Yes / No

Typical use cases

Quarterly review of new subscriptions

Ideal for tracking the growth of your recurring base.

1. 1

   Tab “In progress” (default)
2. 2

   Filter by creation date over the quarter

   From the 1st day to the last day of the quarter.

3. 3

   Export and analyze

   Count the number of new subscriptions, the total monthly amount added, the distribution by platform.

Identify top recurring donors

1. 1

   Tab “In progress”
2. 2

   Filter by minimum amount

   For example 100 €.

3. 3

   Export

   You get the list of regular high-contribution donors — precious for targeted thank-you actions.

Annual review for the board or treasurer

1. 1

   Export each tab separately

   One export per status, to measure where the base stands: how many in progress, how many interrupted, how many completed this year.

2. 2

   Cross-check with the payment export

   See Export for the accountant — the Payments export shows the direct debits actually made, the Subscriptions export shows the commitments in progress.

Reliability audit of the base

1. 1

   Export “Interrupted” and “Expired card” subscriptions
2. 2

   Analyze the reasons

   Which donors have been blocked for a long time? How much do they represent in lost monthly amount? This helps calibrate the reminder effort.

Best practices

• Filter before exporting: without a filter, the file contains the entire base, which can be heavy and not very useful
• Archive the exports: save monthly or quarterly exports in a dated folder to track evolution over time
• Anonymize if needed: for sharing with third parties, remove the Email, Phone, Address columns before sending
• Check consistency: before sending, open the file and verify that the totals match the indicators shown at the top of the list

Format limits

• The file is a snapshot at the time of export. If a subscription changes status afterwards, the export is not updated — you have to run another export
• The file does not contain the history of direct debits (only the characteristics of the parent subscriptions). For this history, see Export for the accountant on the Payments module side

Going further

• Filter subscriptions
• Export for the accountant — to export the direct debits actually made
• Dashboard — for overall statistics