Importing Alternative Payees

Importing alternative payees allows you to import alternative payees into Arbor Finance from an external CSV file. 

File format for importing

The CSV file should be structured as follows:

1. First row is headers.
2. Column 1 is the Alternative Payee Short Code (mandatory).
3. Column 2 is the Alternative Payee full name (mandatory).
4. Column 3 is the Sort Key.
5. Column 4 is the Alternative Payee contact e.g. Fred Bloggs.
6. Columns 5-9 are the Alternative Payee Address fields, note columns 8 and 9 will be combined onto one live separated by a comma.
7. Column 10 is the Alternative Payee postcode.
8. Columns 11 is the Alternative Payee phone number.
9. Column 12 is the Alternative Payee fax number.
10. Column 13 is the Alternative Payee VAT registration number (check the format for this).
11. Column 14 is for you to type a Reference.
12. Column 15 is for an Email address, note this is mandatory if using BACs and very useful when emailing documents.
13. Columns 16-19 detail the preferred payment method, type 'Y' for Cheque (printed cheque), BACs, Direct Debit or Centrally Invoiced under the appropriate column(s). If you choose BACS then the BACs fields become mandatory. If BACS is not selected, leave these columns blank.
14. Column 20 is for the Remittance method.
15. Column 21 is for the Remittance email address.
16. Columns 22-25 are for the BACs details. The following items are mandatory if using BACS.
    • BACs Bank Name
    • BACs Sort Code
    • BACs Account code
    • BACs Reference (non mandatory)
17. Column 26 is for the Creditor reference.

Please check the structure before importing.

Importing Alternative Payee records

1. From the Records menu choose Contacts then the Alternative Payee tab.
2. Click the Import button on the right-hand side.
   
   
   
   
3. To select your file to import, click Choose File, navigate to the file and click Open.
4. The Header line defines which line in your CSV file the headers are on.
5. If you are uploading the file for a second or third time and have a mapping stored then select it from the menu.
6. Click Start import to continue.
   
   
   
   
7. Map the headers in your CSV document to the analysis fields and type the mapping name for future use of this mapping.
   Note:- only map the fields you want to import you do not have to do them all!
8. Click Save to continue.
   
   
   
   
9. The Validation summary will detail if any lines have errors in. The summary report will detail the errors (blue link on page to access this).
10. If you need to change anything click Cancel, or click Complete import to proceed.
11. For those lines that are valid they will be imported and you will see the message below.