Skip to content

Import journal entries

Instead of typing each line, you can enter journal entry lines in a spreadsheet and import them into a journal entry. This is useful for entries with many lines.

  1. Get the journal entry template spreadsheet.

  2. Open the template. Its columns are JENo, GLDate, TransDes, Reversing, FinCatID, LocCode, Notes and Amount. Follow the format of the two sample lines.

    The journal entry template with two sample lines

  3. Type your journal entry lines in the same format, then delete the two sample lines.

  4. Save the file somewhere you can find it for the import.

  1. Go to Accounting › General Ledger › Journal Entries.

    The General Ledger menu with Journal Entries selected

  2. Select the new button to start a new journal entry.

  3. Type the Journal Entry No, or select # to assign the next number. Use numbers only.

  4. Select the GL Date.

  5. Type a short Description.

  6. Below the grid, select Import Journal Entry.

    The Import Journal Entry button below the grid

  7. Browse to your template file and select Open.

    Choosing the template file in the Open window

    The lines are imported into the grid.

  8. Fix any fields shown in red. You can correct them on the screen, or fix the spreadsheet and import it again.

    An imported line with an invalid location shown in red

    If the debits and credits don’t balance, you see a message such as “Debits (300) must equal Credits(200) for Transactions for Legal Entity”, and the lines are highlighted in yellow.

    The message that debits must equal credits, with the lines highlighted in yellow

  9. When all the errors are corrected and every line is white, select the save button.

    The corrected journal entry with the save button circled