Skip to main content

Uploading a bulk price change

Upload bulk price changes via the File Upload tab.

B
Written by Beverley McAllister
Updated over 3 weeks ago

Price changes can be added to the system for customers on rolling and fixed contracts through the use of a CSV or XLSX file.

๐Ÿ“ŒNote: These price changes are reflected immediately in the system. To collect these amounts, the necessary lead time needs to be applied.

๐Ÿ“ŒNote: If you require a list of all of your active customers prior to your price change you can create a custom report.

๐Ÿ“ŒNote: We recommend running a future payments due report after making any price changes to ensure the amounts are correct.

To create a bespoke template for price changes, follow the steps below:

  1. Navigate to 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 Contracts.

  7. Tick does your file have a header if you wish the first row of your file to include headers.

  8. Upon selection, please select the Direct Debit Reference Identifier and Amount by dragging and dropping these fields into the selected columns box.

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

  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 and select your file.

  4. Click Upload File button.

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

  6. Ensure the file is submitted.

Did this answer your question?