A Future Payments Due report shows all Direct Debit payments scheduled for collection within a selected future date range. It lists each customer, the amount due, and the expected collection date, helping you track upcoming payments and ensure everything is scheduled correctly.
The report also shows the start date for new ad hoc customers. These appear with a value of 0.00, indicating the date their Direct Debit instruction was sent to the bank after the standard waiting period. This reflects when the mandate becomes active rather than an upcoming payment.
📌Note: By default, the report displays payments due over the next 12 months. If your collection date falls on a weekend or bank holiday, ensure you select the next available working day as the due date.
Available columns
Bank Reference
Customer Reference
Additional Reference
Title
Name
Company Name
Amount Due
Date Due
Contract Status
Ad-hoc Payment
Create a Future Payments Due report
Click the Reports & Analytics tab on the left hand side.
Within the Standard Reports section, select View Reports.
Under the Create Report panel, locate Future Payments Due.
Click Configure Report.
Under the Filters section, click the dropdown to select the relevant filters.
Click Apply Filters.
Click the format dropdown in the Live Preview panel to select CSV or XLSX.
Click Download Detail.
📌Note: Under the Filters section, click Clear to start your search again.