Import journals from a spreadsheet
Many journals, for example from an old system or a working paper, posted in one go.
Before you start
- Access to post journals.
- The account codes from the Chart of Accounts.
- For cash or bank account lines, the account is linked in Cash & Bank and you have Cash & Bank write access.
Steps
Step 1: Open the journal import
In Accounting › Journals, click Action, then Import journals. The Import journal entries window opens.
Screenshot coming soon
The Action menu on the Journals page with the Import journals option.
Step 2: Download and fill in the template
Click Template. One row in the template is one journal line: journal_ref, journal_date, posting_date, memo, account_code, description, debit, credit, and a project, branch or division code if any. Rows with the same journal_ref make one journal.
Screenshot coming soon
The Import journal entries window with the Template button.
Step 3: Upload the file
Click Upload file and choose a CSV, XLS or XLSX file. Finday validates every row.
Screenshot coming soon
The Upload file button in the journal import window.
Step 4: Check the validation result
Check the Rows, Ready journals and Issues cards, then the Rows to post table. Each row is Valid or Invalid.
Screenshot coming soon
The import validation result with rows, ready journals, issues and each row's status.
Step 5: Post the journals
Once the status reads Ready to post, click Post valid journals. The status changes to Import posted, with a link to each journal.
Screenshot coming soon
The Ready to post status with the Post valid journals button.
When you are done
- Each journal in the file is posted as a normal manual journal, with a link to each one.
- Rows with the same journal_ref make one journal.
Common problems
The Post valid journals button can't be clicked
One invalid row holds back the whole file. Fix the rows with problems in the file, then upload it again.
A message says the posting period is closed
A posting date in the file falls in a closed period. Change posting_date or ask for the period to be reopened.
A message asks to match the columns to the template
Use the template from the Template button and keep its column names.
Something still unclear?
Ask us on WhatsApp. The Finday team replies during office hours and can walk you through it in your own account.