Forum Discussion

paddyr's avatar
paddyr
Contributing User
2 years ago

AccountRight Import General Journal Error

Hi there i have a similar issue where i have downloaded an existing  General Journal in the required template , maintained the format, upaded the data for a new Jnl and I get the attached ( Snip of E...
  • Mike_James's avatar
    Mike_James
    2 years ago

    Hi paddyr , Excel puts quotes around amounts with commas when it saves as text, so I suggest you format the amount column as general (or as number with 2 decimal places but NO commas) before you save it as a txt file. 

Mike_James's avatar
Mike_James
Ultimate Cover User
2 years ago

Hi paddyr , Excel puts quotes around amounts with commas when it saves as text, so I suggest you format the amount column as general (or as number with 2 decimal places but NO commas) before you save it as a txt file. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.