Bankline Payment
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 |