Forum Discussion

paddyr's avatar
paddyr
Contributing User
9 months ago
Solved

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
    9 months 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 Partner
9 months 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.