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
- Log onto the DD portal
- Go to Files then File Export DD
- Select the Client code you want to export
- Select Bulk amendment for the Extract type
- Select the date you want the changes to take effect using the calendar
- Select Export to export the file
- Save to your desired location
Step 2 - Amending the file
- Open the file
- Remove any customer records in the file not required
- Review any highlighted rows via the portal (these could contain future changes and the amount could be overwritten by the changes)
- Amend only the Next collection amount and Subsequent amount
Step 3 - Import the file
- Log onto the DD portal
- Go to Files then File import DD
- Browse for the file you want to import
- Select Import to import the file
- Once the file has successfully imported, it will be ready to view
Step 4 - Submit the file
- Select Files then File Summary
- View the file to be actioned
- 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
- The extract file will display data from the effective date
- 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
- If you import to a DD that has future changes, all the future amounts will be changed to the subsequent amount
- 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 |