The journal importer accepts actual accounting rows with four columns. Completely blank rows are ignored, but a totals row, section label or comment with visible text is treated as data and must meet the same account and amount rules.
Before exporting, select only the four journal columns and the rows that should become accounting lines. Keep explanatory working-paper notes outside that import range. A spreadsheet total should not become another debit or credit line, because it would count the amounts twice.
If the validator points to a row containing 'Total' or a section name, remove that non-accounting row from the import file and validate again. Preserve the original working paper separately so the calculation and supporting notes remain available for review.
Check the number of previewed lines against your intended journal lines, then compare the debit and credit totals. Blank separator rows can make spreadsheet row numbers differ from the visible preview, so use the account, description and amount to identify each line rather than relying solely on position.
Was this article helpful?
Tell us whether this answered the question you came with.