A missing-closing-quote error identifies where a quoted CSV field began without a matching end. The importer stops parsing so later lines are not silently folded into that field.
- Open the original file in a tool that shows the actual CSV text and locate the reported line.
- Compare the affected field with the bank export or spreadsheet source. Check whether an edit removed its closing quotation mark.
- Export a corrected working copy and read it again. Review the affected row and the rows after it.
Do not add a quote at the end of the whole file without checking which field was incomplete. That can produce a technically closed field containing several unrelated transactions.
Preserve quotation marks inside descriptions
A quote that belongs inside a quoted description uses the file’s proper escaped representation, commonly doubled quotes. A spreadsheet CSV exporter can handle that structure more reliably than manual punctuation edits.
After repair, compare the transaction count and totals with the source. Parsing success only confirms that the file structure can be read. Confirm that no later row was swallowed into a long description and that every amount remains in its intended column.
Was this article helpful?
Tell us whether this answered the question you came with.