BACS Payment Editor CSV Format

Appendix ›› File Formats ››
Parent Previous Next

This is the specification for the format used by the Payment Editor to save and load BACS (Bacstel-IP) payment submission data.



File Specification


CSV, comma separated

Use CRLF characters as line terminator.

No Header

No Trailer



Field specification


Column

Name


Format

Example

Notes

1

Destination Sort Code

M

6n

111111


2

Destination Account Number

M

8n

22222222


3

Destination Name

M

18a

DESTINATION NAME


4

Amount

M

9/2 Decimal

123.45

In UK Pounds, 2 places of decimal

5

Transaction Code

M

2a

99


6

Originating Sort Code

M

6n

111111


7

Originating Account Number

M

8n

22222222


8

Originator's Name

M

18a

QWERTY123456


9

Service User Reference

M

18a

QWERTY123456


10

Date

O

dd/mm/yyyy

09/08/2014





Key


M - Mandatory Field

O - Optional Field

n - numeric character

a - Alphanumeric character