You can paste spreadsheet rows directly into Import journal lines. Copy the Account, Description, Debit and Credit columns together so each row remains a complete accounting line. Tabs from a spreadsheet are supported, as are comma-separated rows.
Paste the cells into Or paste spreadsheet lines and select Validate lines. A header is optional when the columns are already in the expected order. When you use a header, use the supported column names so the validator can identify the account, description and both amount columns.
Inspect the preview instead of relying on how the pasted text looks in the input. It should show the intended account for every row and equal debit and credit totals. Use validated lines applies the preview to the journal form; confirm replacement when existing draft lines would be overwritten.
Pasting carries line data only. Review the journal currency, accounting date and overall reason in the draft before saving. If the spreadsheet contains formulas, verify the displayed numeric values and retain the original calculation as supporting evidence for the adjustment.
Was this article helpful?
Tell us whether this answered the question you came with.