Bankline Payment
Introduction
Please read Bank Payments before you download a test or live file from Aqilla.
Sample File
BanklinePaymentsFormat20190822.csv - this .csv file was produced from an Aqilla instance.
The file looks like this:
Bank Documentation
See: https://www.business.natwest.com/business/bankline/support-guides.html
The most useful documentation WRT importing payment data is the Bankline import file layout guide - CSV (.pdf Dec 2017) - in particular section 4.2 which is summarised on the right.
Refer to section 3 of Bankline import file layout guide - CSV (.pdf Dec 2017) for technical details of each field.
Comments
Free format fields are limited to the following character set -and "space".
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0 1 2 3 4 5 6 7 8 9 . - / &
Refer to section 2.3 of Bankline import file layout guide - CSV (.pdf Dec 2017) for technical details of character sets.
|
Column
|
NatWest Ref |
Use
|
|---|---|---|
|
D |
T001 |
Transaction type: 01 = standard domestic payment |
|
M |
T010 |
Payee sort code & payee account code - concatenated so beware of opening in MS Excel |
|
Q |
T014 |
Payment amount |
|
S |
T016 |
Payment date |
|
Y |
T022 |
Payer sort code |
|
AE |
T028 |
Payer account code |
|
AG |
T030 |
Payee name |
|
AK |
T034 |
Payer reference |