Forum Discussion

FFOX's avatar
FFOX
Contributing User
3 years ago
Solved

Import Journal template

Hi, I'm importing a payroll journal from Employment Hero which is compatible with MYOB AccountRight but I cannot find a field to match with "is credit"?  I can see on MYOB Help that this is an optio...
  • Mike_James's avatar
    Mike_James
    3 years ago

    Hi FFOX, looking at the screenshot of your import/matching process, it looks like the fields in the import file are designed for the old version 19 format, for example fields such as Credit Ex-Tax Amount are unique to that format. 

     

    If you open the actual import (text) file, you may see {} on the first line. If you delete that line, then re-import, AccountRight will recognise the older style import and match accordingly. 

     

    However, you don't want to be doing that every time, so it should be possible to change the settings in Employment Hero so that the correct file format is exported. (Although your selection for the file-based export of "MYOB AccountRight Live" appears to be correct). It may also be worth disabling the file export and investigating the journal services option for a seamless solution.

     

     

Mike_James's avatar
Mike_James
Ultimate Partner

Hi FFOX, looking at the screenshot of your import/matching process, it looks like the fields in the import file are designed for the old version 19 format, for example fields such as Credit Ex-Tax Amount are unique to that format. 

 

If you open the actual import (text) file, you may see {} on the first line. If you delete that line, then re-import, AccountRight will recognise the older style import and match accordingly. 

 

However, you don't want to be doing that every time, so it should be possible to change the settings in Employment Hero so that the correct file format is exported. (Although your selection for the file-based export of "MYOB AccountRight Live" appears to be correct). It may also be worth disabling the file export and investigating the journal services option for a seamless solution.

 

 

FFOX's avatar
FFOX
Contributing User
3 years ago

thank you