Importing journal entries

Introduction

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.

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 that you are importing.

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

Open GL Periods

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.

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.

What's next?

Here some other articles related to journal entries that may be of interest:

Manual journal entries

Automatic journal entries