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.
Create a bespoke template for customer reference changes
Open the 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.
Select Does your file have a header if the first row of your file contains column headers.
Drag and drop Customer Reference and Direct Debit Reference Identifier from Available Columns to Selected Columns.
Save.
Your template then appears in the Template Library, alongside our shared system templates. Click the Download button to obtain a CSV or XLSX file for completion.
Upload the file
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.
