Sage payroll import file format problem

Sage payroll import file format problem

Didn't find your answer?

Trying to import employee details into a new Sage payroll company.  Template is a csv file. The data has been exported from an existing sage payroll company into a csv file.  Some employee bank sort codes are defaulting to date format and not the sort code format required ie sort code 09-01-28 (format required), insists on saving as 09/01/2028, whereas sort code 01-67-14 is saving in the correct format because it doesn't look anything like a date.  Tried converting 09-01-28 to a text field by putting a ' infront of it, but each time I save the data as a csv file it loses the new formatting and reverts to the date format.  The data won't import into Sage payroll because of the dates.  Does anyone know a way round this?

Many thanks

Replies (1)

Please login or register to join the discussion.

avatar
By hje
06th Apr 2016 22:57

This

link has some tips for importing sort codes which may be of help: https://my.sage.co.uk/public/help/askarticle.aspx?articleid=30184

Thanks (0)