Skip to main content

Format S (RBS/Natwest BankLine)

  • Standard CSV format.

  • 1st Field: sort code

  • 2nd Field: Account Number

  • 3rd-4th Fields: Ignored fields

  • 5th Field: Currency

  • 6th-9th Fields: Ignored fields

  • 10th Field: Transaction Date (DD/MM/YY)

  • 11th Field: Description (If the transaction type = 'CHQ' then the Description contains the cheque number.)

  • 12th-15th Fields: Ignored fields

  • 16th Field: Transaction type

  • 17th Field: Debit amount

  • 18th Field: Credit amount

Related Topics Link Icon

Parameters

  • CB/LINESKIP - Lines to skip at top of statement load

Did this answer your question?