Customer reference amendments can be added to the system through the use of a CSV or XLSX file.
📌Note: We recommend running a future payments due report after making any changes.
To create a bespoke template for customer reference changes, follow the steps below:
Navigate to File Upload tab.
Click on Template Library.
Click on Create New Template.
Add a name for your template on the Template Name field.
On Action type drop-down menu select Update Existing.
On Template type, select Update Customers.
Tick does your file have a header if you wish the first row of your file to include headers.
By dragging and dropping move Customer Reference and Direct Debit Reference Identifier across from the Available Columns to Selected Columns.
Save.
Your template then appears in the Template Library, alongside our shared system templates. Press the Download button to obtain a CSV or XLSX file for completion.
To upload the file, follow the steps below:
Click the Upload a file tab.
Select a template from the drop down menu.
Under the Data File tab, click Click to select file.
Click Upload File button.
If validated with errors, you need to correct the errors.