The Future Payments Due report shows all Direct Debit payments that are scheduled for collection within a chosen future date range. It lists each customer, the amount due, and the expected collection date, helping you easily track upcoming payments and ensure everything is scheduled correctly.
A helpful feature of the Future Payments Due report is the ability to view the start date for new ad hoc customers. These customers appear with a value of ‘0.00’, showing the date their Direct Debit instruction was sent to the bank after your standard waiting‑period days. This date reflects when the mandate becomes active rather than the date of an upcoming payment.
Run the Future Payments Due report
Navigate to the REPORTS tab.
Select Future Payments Due.
Input your To and From dates to search a single collection date or a date range.
Enter a bank reference or customer reference to filter for a specific customer.
Choose a Status to refine the search, or leave it as All to view all payments due.
Click SEARCH.
📌Note: If your collection date falls on a weekend or bank holiday, you must take this into account and ensure that you enter the next available collection date as the due date.
View and download the report
View the results on‑screen, or click DOWNLOAD CSV to export the individual payments into an Excel file. You can also choose DOWNLOAD SUMMARY CSV, which provides a summary file containing 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%)
📌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.