Employee File IIF - Open in Excel to make pay rate changes - import IIF back to Reckon


I have used the method to export the employee file in IIF, open in Excel & adjust pay rates. Save as IIF then report back into Reckon for many years.
I have just tried this year & it seems that excel is changing the data file on save & reckon is not accepting the updated file. I have had our tech support look into this & we have tried different 'save' options but still no luck.
Has anyone else been successful with this method recently? Or ran into a similar issue & has a suggested work around?
400 employees with 21 different pay rates = 8400 manual entries (no thanks!)
Answers
-
The IIF file is a tab-delimited text format.
Open the exported employee IIF file in Excel as a tab-delimited text file.
Save the file as tab-delimited text.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
0