A quoted CSV field can contain a line break. The parser reads complete logical rows, so a properly quoted multiline description stays attached to its transaction rather than creating an extra movement.
- Check whether the original export encloses the multiline description in quotes.
- Keep the quoting intact when editing or transferring the file.
- After Read rows, compare the transaction count and the description beside its amount in Preview.
A physical text line is not always a complete transaction row. This can explain why an error’s text-line number differs from the transaction position you expected in a spreadsheet.
If the description splits into extra rows
Inspect the quotes and the selected separator. A damaged quote can cause part of the description to be interpreted as a new row with a missing date or amount.
Do not delete the extra-looking text before confirming its role in the original description. Reexporting from the bank or a spreadsheet application can preserve the structure correctly. After repair, verify the full affected transaction and compare totals so the multiline text has not hidden, duplicated or displaced another record.
Was this article helpful?
Tell us whether this answered the question you came with.