The structured parser ignores rows whose cells are all blank. A line containing a note, subtotal or other text is not blank and can appear as a row requiring validation.
- Compare the source’s actual transaction table with the row count shown after Read rows.
- Remove nontransaction introductory or footer material from a working copy while retaining the original source.
- Check that no real movement was removed with the surrounding blank or informational lines.
The header setting also affects the count. When First line is column names is enabled, the first parsed row is treated as a header rather than a transaction.
Review apparent count differences
A spreadsheet’s last occupied row number can include headers, blank gaps and notes. Compare the number of financial movements, not only the visible sheet row number, with the import summary.
If a row contains an amount but no date or description, investigate it before deleting it. It could be a transaction with incomplete export data. Use the bank statement to establish whether it belongs in the import and retain an explanation for any rows intentionally excluded.
Was this article helpful?
Tell us whether this answered the question you came with.