NatWest BankLine
Access Accounts can output payment data to NatWest BankLine; you should select NatWest BankLine when creating the BACS export file.
BankLine requires a payment date (Debit date). When BankLine format is selected for the BACS Export, an entry window will be offered enabling the entry of the date on which the payments will be credited.
File Format Specifications
The table below specifies the fields required for an BankLine BACS export file to be successfully imported. The description column gives information about the header, the notes column contains details of the data which should appear in the relevant field.
Files must be formatted in a specific way to be imported correctly. DBF column width gives the column width that must be entered; DBF cell format gives the cell formats that must be used.
Header | Description | Notes | DBF Column Width | DBF Cell Format |
DebitDate | Debit date | Date format = dd/mm/yy | 8 | date |
BankRef | Bank reference number |
4 digit number - shown
on mandate
| 4 | text |
DBAcNo | Debit account number | 8 digit account number | 8 | text |
DBAcType | Debit account type |
Current = 00
Deposit = 01
| 2 | text |
DBSC | Debit account sortcode | 6 digit sortcode | 6 | text |
BenName | Beneficiary name | Must match the name that appears on the mandate | 20 | text |
BenAcNo | Beneficiary account number | 8 digit account number | 8 | text |
BenAcType | Beneficiary account type |
Current = 00
Deposit = 01
| 2 | text |
BenSC | Beneficiary sortcode | 6 digit sortcode | 6 | text |
BenRef | Beneficiary reference | Must be left blank or match the reference on the mandate | 18 | text |
Amount | Amount | £100 would be entered as 100.00 | 17 | text |
RemAdvReq | Remittance advice required |
Y or 1 = yes
N or 0 = no
| 1 | text |