The debtors report allows you to browse and filter a list of schemes in order to provide a summary of the due and overdue rebate, grouped into aged time periods per supplier and per scheme.
This functionality can be accessed by clicking on Cash at the top of your page and then on Debtors report from the drop-down menu.
On this page, a list will display a live view of any due or overdue rebate, where the aged debt for each deal line is based on:
The end date of the deal line.
The rebate payment terms of the scheme.
The debtor balance of the deal line.
The report start date selected in the search criteria.
The current date.
In the panel on the right-hand side of the page, you will be able to filter the search results using the following criteria:
Supplier · Choose one, or more, suppliers from the ‘My suppliers’ list (including suppliers for which you are the lead cash collector) or ‘All suppliers’ list (including all suppliers for which you have read access).
Scheme types · Choose from a list of configured scheme types.
Scheme start date, ‘From’ and ‘To’ · Enter a ‘From’ date to filter by scheme start date. Enter a ‘To’ date to filter by the scheme end date.
Lead cash collector · Choose collectors from a list of lead cash collectors.
Aged debt periods · Choose aged debt periods from a list.
Report start date · Enter a date to prevent any deal lines with an end date before the report start date from contributing any value towards the debtor record for a supplier. Defaults to the first day of the current year.
Only show suppliers with unallocated receipts · A drop-down Yes / No selection to restrict search results to suppliers which have unallocated receipts. ‘No’ is the default.
When you have finished making your selection, click the Search button in the bottom right-hand corner of the panel.
Once a search has been completed, the debtors report will be displayed, providing full visibility of any overdue rebate.
Please note — your search criteria will be persisted for the duration of your session. Click the Reset button to clear the criteria.
The debtors report initially shows you a table of schemes and their aged debt with the ability to drill down to view the debt by deal or deal line while filtering by the aged time period.
This ability to drill down to deal line level allows you to look up a specific payment frequency period for a deal and see how overdue the payment for that rebate is.
You will now have the option to either click on the Download button, which will generate a csv file of the on-screen search results, or select one of the scheme rows in the listing, which will display the deals associated to the selected scheme (see screenshot below as an example).
When viewing the deals for a scheme, you will have the following options:
Click the View scheme button, which navigates you to the selected scheme edit/view page.
Click the View scheme notes button, which will allow you to view the scheme notes for the selected scheme, or create scheme notes if you have edit access to the scheme.
Click on a deal row in the listing, which will display the deal lines associated with the selected deal (as shown below).
Aged debt periods
The different aged debt periods are explained below:
- Not yet due - Deal lines that have not ended;
- <0 days - Deal lines were the end date has passed but due date has not yet been reached;
- 0-30 days - Deal lines that are between 0 and 30 days due;
- 31-60 days - Deal lines that are between 31 and 60 days due;
- 61-90 days - Deal lines are between 61 and 90 days due;
- 91+ days - Deal lines are more than 91 days due.
The total debt column is the sum of all the above age categories.
The total due column is dependent on the configuration of the instance. It is either the sum of
OR the sum of