SAFF file format is broken

  • 1
  • Question
  • Updated 8 months ago
  • Answered
I am trying to export my monthly super contributions to a clearing
house, but the SAFF file produced by Payroll Premier 2017/18 has a bug in it.
I am exporting to AAS Super Clearing House, the clearing house used by the majority of the Industry Super funds.
The main issue is the first line of the records it writes.
The default .csv file has 133 columns of data. Payroll Premier, however, writes the first line with only 5 columns, then 133 columns from the second line till EoF.
This means that when the AAS Clearing House reads the file, it picks up 5 fields in the first line and then throws an error.
If I edit the file in Notepad and add the other 128 commas into the first line, then the file uploads successfully.
I have asked Payroll Premier to fix this, but so far they have refused, saying that their version is the standard default format.
How can a .CSV file with varying numbers of columns ever be considered the correct format? This is ludicrous.
Photo of Greg Tenni

Greg Tenni

  • 254 Points 250 badge 2x thumb
  • Cranky

Posted 9 months ago

  • 1
Photo of Shane

Shane, Employee

  • 7,388 Points 5k badge 2x thumb
Hi Greg,

I've done some investigating and found that the SAFF format is an ATO standard format - meaning that the ATO, not Reckon have set out the format.  If Reckon was to change it, it would no longer meet the ATO guidlines on the SAFF format.  The following links I found on google are ATO links with the specifications for the SAFF format.  I've checked and Reckon SAFF files meet these guidlines/format.

https://softwaredevelopers.ato.gov.au/sites/default/files/resource-attachments/SuperStream_alternati...

https://softwaredevelopers.ato.gov.au/sites/default/files/resource-attachments/SuperStream_alternati...

It sounds like the clearing house is not able to read the correct SAFF format.  This is something they would need change to be in accordance with the ATO SAFF format.  You can provide them with the above links for their reference.

Regards,
Shane