Domestic format
Payment upload file type.
- The file can have any name.
- Each field present within a record must be separated by a comma.
- The file must contain one record per transaction. Each transaction record must be separated by a < CRLF > (Carriage Return Line Feed character).
- Character fields can contain alphanumeric characters (A-Z), numbers (0-9), spaces and most other keyboard characters. Commas and symbols [ ] { } \ | ` ~ ^ are not accepted.
Example:
123.45,06050100059000000,Expense Act,N1002,T0015,ABC Ltd,Expenses,A12223,Smith
678.90,06050100091633000,Travel Act,B7825,T0015,XYZ Ltd,Travel Exp,B11224,Brown
123.45,06050100059000000,Expense Act,N1002,T0015,ACME Ltd,Expenses,N11445,Graham
Field description | Characters | Type | Comments | |
|---|---|---|---|---|
Field 1 | Transaction Amount | Up to 10 digits | Numbers and full stops only | Transaction amount expressed either in whole dollars or in cents, e.g. The minimum acceptable value is 0.01. |
Field 2 | Account Number | 17 digits | Numbers | BBBBBBAAAAAAASS or BBBBBBAAAAAAASSS |
Field 3 | Other Party Name | Up to 20 characters | Characters or numbers | The name of the other party. |
Field 4 | Originator Reference | Up to 12 characters | Characters or numbers | The Reference that will appear on your bank statement. |
Field 5 | Originator Analysis Code | 12 characters | Characters or numbers | The Analysis Code that will appear on your bank statement. |
Field 6 | Originator Particulars | Up to 12 characters | Characters or numbers | The Particulars that will appear on your bank statement. |
Field 7 | Other Party Reference | Up to 12 characters | Characters or numbers | The Reference that will appear on the other party's bank statement. |
Field 8 | Other Party Analysis Code | Up to 12 characters | Characters or numbers | The Analysis Code that will appear on the other party's bank statement. |
Field 9 | Other Party Particulars | Up to 12 characters | Characters or numbers | The Particulars that will appear on the other party's bank statement. |
Notes:
- Only the first three fields (transaction amount, account number, other party name) are mandatory. Any or all of the remaining reference fields can be omitted, although they must still be correctly separated by commas.
- Lowercase characters will be transformed to their uppercase equivalents. Leading and trailing space characters will be removed from fields.