Direct Debit Annual Amendments Quick Start Guide

File Export - Important points to remember

  • This file format does not support the rent free week(s) calculations
  • Anyone with the ‘File Import/Extract’ role will be able to export the file
  • One extract per client code at any one time
  • The ‘Effective date’ refers to the date the increases/decreases will take effect and cannot be amended within the file once exported
  • DDIs with no scheduled collections (dormant) will not be included in the extract
  • DDIs with future changes scheduled will be highlighted in yellow, and any changes made may affect the future amendments

Step 1 - Export the file

  1. Log onto the DD portal
  2. Go to Files then File Export DD
  3. Select the Client code you want to export
  4. Select Bulk amendment for the Extract type
  5. Select the date you want the changes to take effect using the calendar
  6. Select Export to export the file
  7. Save to your desired location

Step 2 - Amending the file

  1. Open the file
  2. Remove any customer records in the file not required
  3. Review any highlighted rows via the portal (these could contain future changes and the amount could be overwritten by the changes)
  4. Amend only the Next collection amount and Subsequent amount

Step 3 - Import the file

  1. Log onto the DD portal
  2. Go to Files then File import DD
  3. Browse for the file you want to import
  4. Select Import to import the file
  5. Once the file has successfully imported, it will be ready to view

Step 4 - Submit the file

  1. Select Files then File Summary
  2. View the file to be actioned
  3. Submit all ready to submit

Download your own files

Now you are able to:

  • Specify the Client Code that you would like to extract
  • Select the file type that you want to download as Bulk amendment
  • Select the effective date that you would like the amendments to take effect from. The effective date cannot be changed withinthe file once exported.

File rules

  1. The extract file will display data from the effective date
  2. Highlighted rows, mean that there is data within the portal that we cannot display on the extract ie future changes. We advise that you review these manually via the portal
  3. If you import to a DD that has future changes, all the future amounts will be changed to the subsequent amount
  4. Only one file extract can happen at any one time per client code5. Anyone with file import role will be able to extract a file.

Exclusions

  • File does not include Direct Debits with no collections (Dormant)
  • File does not support rent free weeks (payment holidays)

If you require this, please request an extract from enquiries@allpay.net


Amending the file

The file that you download has changed, we have only populated it with data that is related to bulk amendments. It contains:

Field Description
Client Code

DO NOT AMEND, INFORMATION ONLY

This is the client code that you selected previously

Client Reference

DO NOT AMEND, INFORMATION ONLY

Match the client details within your systems

Surname

DO NOT AMEND, INFORMATION ONLY

Identify the customer

Address line 1

DO NOT AMEND, INFORMATION ONLY

Identify the location of the property

Postcode

DO NOT AMEND, INFORMATION ONLY

Identify the location of the property

Frequency

DO NOT AMEND, INFORMATION ONLY

Help calculate the new payment cycle

Next collection amount

PLEASE UPDATE

This is the amount that will be collected on the next payment after the effective date

Subsequent amount

PLEASE UPDATE

This is the amount that will be collected for the rest of the payment cycle

Remaining payments

DO NOT AMEND, INFORMATION ONLY

This is the total count of how many payments will be collected. 0 = ongoing collection

Next collection day

DO NOT AMEND, INFORMATION ONLY

The first collection that will be affected