How to import journal entries | ParagonERP

Importing 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.

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.

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.

    • Related Articles

    • Automatic journal entries

      Introduction Every company has its own workflows and methods for creating accounting journal entries during their daily processes.  Paragon gives you the option to automatically create journal entries when financial transactions are issued (such as ...
    • Manual journal entries

      Introduction In Paragon, if you've configured automatic financials, all transactions that affect a company's general ledger accounts are entered automatically in the journal entries module. The system instantly notifies you of an automatic journal ...
    • Importing, exporting, or transferring my data

      Introduction The universal translator is a powerful tool that can be used to import or export large amounts of data to and from Paragon. You can mass update your reference modules and you can also export and import transaction data. As an example, ...
    • Importing GL opening balances into Paragon

      Introduction Importing the opening balances in ParagonERP refers to importing the monetary amounts that are being rolled over into a new accounting period for any one of your GL chart of accounts.  You would want to import any outstanding balances ...
    • Adjusting stock by importing inventory

      In Paragon, you can import and export files containing reference items or transactions. Here, we will show you how to make this task that much easier by exporting, editing, and re-importing inventory, thereby allowing you to complete mass ...