A feature of the Future Payments Due report is that you can view the start date of new ad hoc customers. These show as '0.00' on the report and advise the date from which the Direct Debit has been lodged at the bank following your standard waiting period days (not to be confused with the date of an upcoming payment).
📌Note: Large files may take longer to download. If notified via a pop-up, go to Report History tab to view and download the report and its status.
Run the Future payments due report
Navigate to the REPORTS tab then select Future Payments Due.
Select your To and From dates.
Note: You can cover just one collection date or several.Input a specific Direct Debit or customer reference if you want to view payments relating to only that specific customer.
Refine the search by selecting a specific Status or leave this as All to see all payments due.
Click SEARCH.
View the results on-screen or Click DOWNLOAD CSV to view the individual payments in an Excel file. You can also select DOWNLOAD SUMMARY CSV which downloads a file detailing the following information:
Total cancellations & Rejections found.
Number of cancelled Direct Debit Instructions.
Value of cancelled Direct Debit Instructions.
Number of active Direct Debit Instructions.
Value of Active Direct Debit Instructions.
Total value of all payments due (100%)