A journal import can include a header row containing Account, Description, Debit and Credit. The validator recognizes those four names and maps the columns accordingly. Without a recognized header, it expects the values in that exact order.
Use the downloaded template if you are unsure about the structure. Remove unrelated spreadsheet columns such as row numbers, totals or formulas used only for your working paper. Each imported accounting row must contain exactly four cells, including an empty Description cell when no line description is needed.
A renamed heading such as 'GL reference' will not necessarily be recognized as Account. The first row may then be treated as accounting data and fail account validation. Restore the supported names and validate again instead of changing a real account code to match an incorrect heading.
Inspect the preview after any column rearrangement. The intended debit should appear in Debit and the intended credit in Credit. A successful parser result still needs an accounting review of the accounts, dates and source calculation before the draft is posted.
Was this article helpful?
Tell us whether this answered the question you came with.