Importing Timesheets from Nexus

Jenlout

Hi

I have been importing timesheets from nexus for the past 4 years with no issues, I have been slowly trying the online version of myob accountants office instead of the desktop.  I tried to import the timesheets from Nexus as per normal, but i keep getting the following errors

 

The import file is missing a header row. Please ensure the import file is in the correct format and try again. To download a template and learn more about import file formats, click on the Help (?) icon on the top right of the page. An unrecognised error occurred - Timesheets_Invalid_File_Header

 

I have looked at the sample and I believe my timesheet is formatted correctly.

Thanks

 

Princess_R

Hi @Jenlout,

 

Thanks for sharing the error message. Even if the timesheet looks right, the “Timesheets Invalid File Header” error usually means the import file doesn’t quite match MYOB’s required format, often because of things like the wrong delimiter, changes to the header row, or a template mismatch.

 

Please try saving the file as a .txt (tab-delimited) file first. To do that, open it in Excel, go to File > Save As > Browse, then change Save as type to Text (Tab Delimited) (*.txt).

It may also help to export a fresh file and compare it with the import template. If it still won’t import after that, the best next step is to contact our support team through the options on our contact page so they can take a closer look at the file.

 

Cheers,

Princess