When you upload a new file using the “System Update Payments” template, the following rules apply:
If a payment with an amount is uploaded via File Upload and there is an existing payment for the contract on the same day, the existing payment is overwritten.
If a £0.00 payment is uploaded via File Upload and there is an existing payment for the contract on the same day, the existing payment is deleted (not collected).
📌Note: If more than one payment or no payment is present for the contract on the same day, a validation error is raised.
📌Note: When uploading a file containing more than 100k rows of payments, please allow an hour from upload to submission for this file to be completed.
📌Note: Please use the Date Calculator to ensure that you do this prior to the payments being sent to the bank.
When logged into DDCMS, click the FILE UPLOAD tab.
From the Template Library, select the System Update Payments template.
Click the Download Icon then complete the four following fields:
DirectDebitRef - The Direct Debit reference of the contract you use to collect the payment. (This may differ if using a Custom template).
Amount - The amount of the payment required (e.g. 4.99).
DueDate - The date of the payment that is being amended in DD/MM/YYYY format (e.g. 01/03/2023).
Comment - A comment about the payment you would like to store in the database.
Save the spreadsheet in CSV or XLSX format.
Under the Upload a File tab, select a template from the drop-down menu.
Under the Data File tab, click click to select a file.
Click on the Upload File button.
If errors occur after uploading, you need to correct the errors.
We then advise downloading a Future Payments Due report to double-check that the submission is correct.