How to import journal entries | ParagonERP

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.

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.

    • Related Articles

    • How to import, export, or transfer my data

      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, this document ...
    • Automatic journal entries

      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 invoices, ...
    • How to import and export associations

      ParagonERP allows you to import and export associations that are used to link different pieces of information throughout the system. This can be useful when you want to add an association for multiple items at once. If you are unfamiliar with ...
    • How to run and filter the general journal

      The general journal records all the different transactions made in Paragon that effect your books, and creates an audit trail for your business. It can be set up to track either your financials, your inventory, or both. Here we will explain how you ...
    • Paragon Financials - Trial balance report

      The trial balance report allows accountants to confirm that all entries that were posted in the general ledger for a given fiscal period are balanced. In simplest terms, the trial balance confirms that all debits equal all credits. This article will ...