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.
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.
You may also only import Pending journal entries. Verify that the column status has only Pending entries.
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
Then hit GL Periods under the Financials card.
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.
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.
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.
You will then be prompted to select the .xlsx file to import. Select the correct file and then hit upload.