Unexpected text after a closing quote means the parser found characters where a separator or row ending was expected. Check both the file’s delimiter and the quoted field on the reported line.
- Confirm the Separator setting matches the export. A wrong separator can make otherwise valid fields appear malformed.
- Inspect the reported source line and compare it with the original export. Look for pasted notes or punctuation outside the quoted field.
- Correct the file structure through the source application, then read and preview the file again.
Spaces after a closing quote are different from extra text that changes the field structure. Avoid removing meaningful description text merely to clear the error.
Check the neighboring columns
Once the row parses, verify the date, description and amount against the bank record. A repair that shifts an amount into a reference column can leave readable but incorrect data.
Retain the original export and a record of any working-copy changes. If the bank-generated file itself remains malformed, request another supported format such as a clean CSV or OFX export rather than reconstructing transactions from uncertain fragments.
Was this article helpful?
Tell us whether this answered the question you came with.