Import a journal

The Import Wizard enables you to import debit and credit values (such as a trial balance) from multiple entities across multiple financial periods into the system.
The Import Wizard has 3 main steps:
  1. Access the Reporting Entity you want to create a journal for and open a financial period.
  2. Go to
    Journals
    ,
    Import
    .
  3. Drag or browse for a file and then select
    Next
    . Valid file types include .xlsx, .cvs, and .txt.
  4. Choose your options in
    Select Import Settings
    and then
    Next
    .
  5. Map your source data on each tab.
  6. In the
    Header
    column, place a checkmark in the row containing the header information.
  7. Select a field type in each column that can be mapped to the columns from your spreadsheet.
    1. Ignore - You can specify which columns to ignore. For example, if the trial balance file has blank rows, subtotals, or sub-headers, you can exclude these columns from the data upload by selecting
      Ignore
      . Make all header selections.
    2. Account Code -
      Exclude accounts
      disregards blank rows and subtotals in the trial balance, and other information you choose to exclude from the upload.
      Import account codes if zero
      value specifies whether accounts with zero balances are imported (when selected) or disregarded (when not selected).
    3. Account Description - This can be the first or last one in the source file; used when duplicate account codes exist in the source file.
    4. Amount - Enter field information and select
      Save
      .
  8. Select
    Next
    .
  9. Make your selections on the
    Clean data
    screen.
  10. Select a line item and then
    Add
    to ignore the account. The accounts are moved to the ignored column. Accounts in the ignore column won't be imported.
  11. Select
    Import
    .
  12. If errors appear on the
    Complete
    screen, you can make corrections or just make note of the errors. Select
    Continue
    .
  13. Review the attached journal.

Related Content