These columns come from the spreadsheet template that can be downloaded from the Natwest website. On that page you can submit fake details to be able to download the zip file. Opening the xlt file in LibreOffice might make some weird macro stuff happen - so better to look at the column titles below!
The table columns are as follows:
- Your Reference
- *Debit Account Sort Code
- *Debit Account Number
- *Payment Amount
- *Credit Date
- *Beneficiary Account Sort Code
- *Beneficiary Account Number
- *Beneficiary Name
- Beneficiary Reference
- Remittance Advice Indicator Description
- Remittance Advice Beneficiary Address #1
- Remittance Advice Beneficiary Address #2
- Remittance Advice Beneficiary Address #3
- Remittance Advice Beneficiary Address #4
- Remittance Advice Beneficiary FAX Number
- Remittance Advice Beneficiary E-mail Address
The other file in this gist contains a csv template you can use to generate the files from your own application.