Extend File Format (Lite Version)
A practical guide for converting from old SPS to the new extended file format.
Last updated
A practical guide for converting from old SPS to the new extended file format.
Last updated
This guide outlines the process of transitioning from the old SPS to the new extended file format with the minimal mandatory adjustments (there is also a fuller extended file option which we recommend to assist smoother reconciliation with your trade partners). Please refer to the example files at the end of this page for further clarity.
File name must start with 'TRA' e.g. 'TRA Supplier Name 11 Aug 2023'
File suffix must be either '.CSV', '.TXT' or '.DAT'
The first row must only contain the column names.
There is no trailer record (with total values etc)
Fields can be delimited with either a comma, semicolon or tab character
All columns present must be named according to the specification (see example file below)
All mandatory columns must be present and contain data or the file will error.
Any/all/none of the optional columns may be present (see fuller extended file for optional columns)
To avoid complications with comma characters being present in text fields, use of the semicolon or tab delimiter is recommended
Amounts must be loaded as whole currency values e.g. 1234.55. Can also be loaded without decimal place e.g. 1234 = £1,234.00
If amount fields use a comma as a decimal place they need to be encapsulated with double speech marks e.g. "1234,55".
Use of ‘Special’ characters within char fields, including Carriage Returns [CR] and Line feeds [LF], is not permitted
