The journal parser rejects misplaced quotes, incomplete quoted cells and rows with the wrong number of columns. These checks prevent a comma in a description from moving an amount into a different field. Correct the CSV structure instead of deleting the error message's accounting content.
Re-export the four columns from the spreadsheet application when possible. It should quote descriptions containing commas or quotes correctly. If editing plain text, make sure every accounting row still has Account, Description, Debit and Credit cells and that a quoted value closes before the next delimiter.
A message about unexpected text after a quoted cell often means a value was manually edited outside its closing quote. Return to the spreadsheet or recopy the four columns, then validate again. Do not replace a description with a different account code merely to shift the columns back.
Inspect the resulting preview for every repaired row. Check the account, description and both amount columns together. Exact balance is still required, but a balanced total alone cannot confirm that a malformed source row was repaired correctly.
Was this article helpful?
Tell us whether this answered the question you came with.