Everything about the Direct Debit Dashboard🔍

The Direct Debit Financial Monitoring Dashboard is located in the Management menu, just above the general dashboard. It gives you a general overview, by month, of your direct debits, rejects, amounts collected and other useful information.

KEY INDICATORS FOR DIRECT DEBITS

First, it gives an overview of key indicators regarding Direct Debits :

• Total direct debits since starting to use Xplor Resamania (cumulative)
• The total amounts recovered since you started using Xplor Gym (cumulative), i.e. the total of direct debits rejected and then regularised.
• The total number of transactions since you started using Xplor Gym (cumulative), i.e. the total number of direct debit lines sent to the bank.
• The success rate in %, i.e. the total number of completed direct debits out of the total number of planned direct debits (including resubmissions) since the start of use of Xplor Gym (cumulative).

GRAPH 'LAST FILES'

This graph shows the total of the Direct Debits file (regular direct debits AND resubmissions) of each day for which a file has been generated. For example, 01/07 is the next scheduled debit day. If the file is generated on 30/06, the graph will show the amount of the file with a date of 30/06.

The content of the Direct Debit file can be downloaded when you select the Direct Debit day you wish and  pass the mouse over the circle : 

ACTIVE MEMBERS WITHOUT MANDATES

This box shows you the number of active members who do not have any mandate and also the amount that you have lost on the last file due to missing mandates.

By clicking on ‘Improve my conversion rate’, you can access the list of missing mandates and easily identify the members concerned and add or edit their direct debit mandate.

DIRECT DEBITS EVOLUTION

The graph 'Direct Debits Evolution' gives an overview on the following elements ...

1) 1st direct debits : direct debits which occurred over each month (out of resubmissions).

2) Direct debit resubmissions: the direct debit has failed and the file containing the resubmission has been finalised.

3) Rejected direct debits: the direct debit has failed, the file containing its resubmission has not yet been finalised, if there is one.

4) Missing mandates: the amount that could have been obtained if the mandates had been present is indicated.

Concerning missing mandates...

The orange part corresponding to the missing mandate is incremented each time a file is redone if the member has still not returned their mandate.

Passing the mouse on the graph will enable you to see the amounts corresponding to each item of the caption.

Example - Functioning with a Direct Debit, a rejection then a resubmission

1) A £5 Direct Debit is made on 05/08.

2) It is rejected on 15/08.

3) It is resubmitted on 20/08.

Which impacts on the graph above ?

1) On 05/08, on the graph, the Direct Debit will appear.

2) When the Direct Debit is rejected, on 15/08, the rejection can be seen on the graph, the direct debit is not visible in dark blue anylonger.

3) Once the resubmission done (the lot of which should be finalised), it can be seen on the graph. The rejection can still be seen on the graph.

DETAILED GRAPHS ON RECOVERIES, DIRECT DEBIT REJECTIONS AND REASONS FOR REJECTIONS.

• 'Recoveries' graph

The recoveries graph shows the amounts recovered each month from the amounts initially rejected. Move your mouse over the graph to see the amount recovered for each month.

• 'Direct Debit Rejections' graph

The direct debit rejects graph shows the amounts corresponding to direct debit rejects that have not yet been credited to your account. Move your mouse over the graph to see the amount of direct debits reported for each month. Example: the month of May shows the direct debits reported in May.

• 'Reasons for rejections' graph 

The graph of reasons for rejection shows the distribution of rejections according to their reasons.

DIRECT DEBITS ESTIMATION

It is possible to know the forthcoming Direct Debits amount for each future month.

The amounts in blue are the amounts which will normally be debited for memberships and bolt-ons. The total of both is indicated in black.

When there are suspensions or goodwill gestures, an amount is indicated in red and corresponds to what could have been debited but wasn't.

To activate the widget on the dashboard ...

Go to 'Configure' :

Next add the widget clicking on '+',  then close the window.