Skip to main content

Amend customer references in bulk

Amend customer references in bulk via the File Upload tab.

O
Written by Ollie Denning

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

  1. Open the File Upload tab.

  2. Click on Template Library.

  3. Click on Create New Template.

  4. Add a name for your template on the Template Name field.

  5. On Action type drop-down menu select Update Existing.

  6. On Template type, select Update Customers.

  7. Select Does your file have a header if the first row of your file contains column headers.

  8. Drag and drop Customer Reference and Direct Debit Reference Identifier from Available Columns to Selected Columns.

  9. 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

  1. Click the Upload a file tab.

  2. Select a template from the drop down menu.

  3. Under the Data File tab, click Click to select file.

  4. Click Upload File button.

  5. If validated with errors, you need to correct the errors.

Did this answer your question?