1. Home
  2. Getting started
  3. How to import journal entries*
  1. Home
  2. General ledger (GL)
  3. How to import journal entries*
  1. Home
  2. Journal entries
  3. How to import journal entries*

How to import journal entries*

If you have a lot of information for the general ledger, and you don’t want to manually enter each record, you can use our universal translator to load the information quickly. Here, we’ll walk you through how to import journal entries.

If you would like to know how to export journal entries, get yourself oriented here.

Step 1: Create your excel sheet

Each journal entry requires a unique journal ID.journalentries

As you are manually importing journal entries, their entry type is required to be Manual. Verify that under the column entryType, the validation is Manual for every journal entry.

journalentries

You may also only import Pending journal entries. Verify that the column status has only Pending entries.

journalentries

Finally, only open periods are accepted as valid. To find out if the period input is open, hit the settings button in the top left

settingsbuttonfullscreen

Then hit GL Periods under the Financials card.

GLperiod

Once on the GL Periods Configuration screen, you can see which periods have Open status. Only these periods can be associated with a journal entry when importing.

GLperiod

Step 2: Upload your excel file

Once you have created the excel file, hit the settings button again. Then, hit import under the Reports & Data card.

GLperiod

A modal will appear in which you have to select the type of data you would like to import. Select Journal Entries and then hit Select A File.

Untitled

You will then be prompted to select the .xlsx file to import. Select the correct file and then hit upload.

Untitled

Updated on September 20, 2019

Was this article helpful?

Related Articles

Add A Comment