You can add payments to the system through the use of CSV spreadsheet files. The process below covers how to get the import template, upload the data, and submit payments.
As there are no checks in place when using the customer reference, we recommend running an active Customer list report prior to uploading the payments. This ensures that there are no duplicated payers or missing references.
Please ensure you only upload a payment file once, and if there are invalid records always delete or correct these rather than attempting to upload the same file again.
📌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.
You will be required to fill out the following table in step 3:
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 that you would like to collect the payment in DD/MM/YYYY format (e.g. 01/03/2023) |
Comment | A comment about the payment you would like to store in the database. |
When logged into DDCMS, click the FILE UPLOAD tab.
From the template library, select the System New Debit Payments template or a custom one.
Click the download icon then complete the four following fields from the table above.
Save the spreadsheet in .csv format.
Under the Upload a file tab, select a template from the drop-down menu.
Under the Data File tab, click Click to select 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.