Skip to main content

Change the payment date of contracts in bulk

Upload payment date changes in bulk via the File Upload tab.

B
Written by Beverley McAllister
Updated over 3 weeks ago

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

๐Ÿ“ŒNote: These date changes take affect immediately.

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

To create a bespoke template for date 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 in Template Name field.

  5. In Action Type select Update Existing.

  6. In Template Type select Update Contracts.

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

  8. The Optional Fields table appears with the fields available for updating information.

  9. You must then move Direct Debit Reference Identifier and Payment day in month for monthly or Payment month in year for annual over to the Chosen Fields by dragging and dropping.

  10. Click Save.

  11. Your template then appears in the Template Library, press the Download button to obtain a XLSX or CSV file for completion.

Once you have created your new template, please follow the steps below to upload the file:

  1. Click the Upload a file tab.

  2. Select the template from the drop-down menu.

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

  4. Click UPLOAD FILE, then click OK.

  5. Click the Upload File button.

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

Once your file has successfully submitted please check your payer's contract has updated by searching the payers within the contracts tab. Click into the payer and onto the contracts page, the new payment date shows. You can also use the calendar view to check the payment date is showing correctly.

Did this answer your question?