P2C File - Error on Import (Incorrect Year)

When downloading the P2C from ROS, depending on the browser used, the file may simply save retaining it's original format, however, some browsers automatically open the file.


Once opened, the file can then be closed, however, in saving the file the file format can be changed slightly which means it no longer conforms to it's original csv format (as issued by Revenue via ROS).


To reset the file format, open the P2C file with Excel. Without making any changes to the file content choose 'Save As' from the File menu in Excel.


Change the file type to CSV (Comma delimited) (*.csv) and Save (as shown below).





In CollSoft Payroll, if you now try to import the P2C file, ensure that you choose the newly saved csv formatted file, it should complete successfully.


Creation date: 05/01/2018 13:23     Updated: 05/01/2018 13:23
ROS P2C export and import into CollSoft Payroll
Files
P2C File saving in csv.png