Importing GL opening balances into Paragon | ParagonERP

Importing GL opening balances into Paragon


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 from your previous accounting system (or from a previous year) so that you start on the right foot with the proper financial figures.

In this article, we'll show you how to import your general ledger opening balances for the beginning of your fiscal year.

If you are importing your GL accounts - please make a copy of your existing GL accounts and setup before importing. The import will replace your existing GL data.

Before importing your opening balances, make sure you have your GL periods setup in Paragon.

Fill in your template

The first thing you're going to want to do is fill in the GL chart of accounts excel template that you've exported from ParagonERP.

ParagonERP comes with a standard chart of accounts, but you can override the default accounts by importing your own.

After exporting your GL Chart of accounts from Paragon, you'll see a template similar to the following:

You can fill in this template by replacing the default accounts with your own. To do so, keep the column headers, and remove the values in the columns. We recommend doing this column by column.


You can start by removing the values in the first column. In this column, you'll enter the title of your account.


The second column tells the system what parent account the specific sub accounts belong to. In our export above for example, the asset account is the parent account of cash. Likewise, cash is the parent account of bank, and so on.


The category column tells the system what main type of account (assets, liabilities, or equity) the specific account belongs to. For example, although bank might be a sub account to cash, and cash might be a sub account of assets, all of these accounts; bank, cash, and assets, belong to the asset category.


This column is where you enter your account number. If you do not have any, you can create some, or use Paragon's standard numbering.

You can tell which sub accounts belong to which parent accounts by looking at the account numbers.
For example, here we know that account bank belongs to parent account cash not only by looking at the parentID column, but also by looking at the account number.

Cash 1-0
Bank 1-0-1-0

The sub account will have the same first digits as the parent account.

summary account

The only thing that needs to be in this column is the retained earnings, and net income accounts.

accountingMethod & name

For the purpose of importing your opening balances, you don't need to add anything in these columns.


Make sure that all of the accounts you are importing with a balance are Active status. Make sure the first letter is capitalized, as the template is case sensitive. If you wish to import accounts, but you do not want them activated, type Inactive in the appropriate cells.


Each GL account  has an “accessible as a non-trade item” attribute that determines whether the account will show up in the list of non-trade items

Note that if the parent ID value is null, the value for the "accessible as non trade item" attribute cannot be 1.


You need to fill this column in with the appropriate debit or credit amounts in the appropriate accounts.
To do so, enter the debit amounts as positive numbers, and the credit amounts as negative numbers.


This will be listed as the GL period you're importing for. 

Of course, before importing your opening balances, make sure you have your GL periods setup in Paragon.

Import your opening balances

Once you've entered in your accounts, filled in your GL balances, and verified that all information in the sheet is correct, go ahead and import your opening balances.

For simplicity, we've added $2,000 as a debit to accounts receivables, and $2,000 as a credit to accounts payable. 

To import the balances, make your way to the settings screen. Select import  from the reports & data card, and select GL chart of accounts as what you want to import. Select your file, and click upload.

You'll notice a message in red upon importing your opening balances. This states that whatever accounts are currently in Paragon will be overridden by the accounts you are now importing.

If you've already posted your chart of accounts to the journal, or if you already have any system generated journal entry postings, you cannot override the chart of accounts. You can manually add accounts, but you cannot override accounts that have already been posted to the journal.

Post your opening balances

Once you've successfully imported your opening balances, make your way to the journal entry module to review them.

You can see that the opening balances will be listed as journal entry #000001, and it will be in pending status. 

Pending status implies that you can still import a new GL chart of accounts. Think of it as a safety feature in case there are errors. As long as no journal entries are posted, you can import a new GL chart of accounts.

Once you've made sure all the information in the opening journal entry is correct, you can go ahead and post the journal entry.

What's next?

Now that you've posted your opening balance, check out your financials reports:

    • Related Articles

    • Print the GL Balances Report

      Introduction Standardized financial reports may give you a snapshot of your business’ financial health, but aren’t as useful for analyzing and investigating the activity within each GL account down to the journal level. Paragon’s GL balances WIGO ...
    • Setting up GL accounts

      Introduction Upon installation, there are default GL accounts set up in Paragon. If there are accounts missing that you require for your financials, this article will explain how to create them. Once they are created, they must be linked to different ...
    • Importing Shopify orders into Paragon

      Introduction Paragon offers the ability to connect your organization to your e-Commerce site hosted on Shopify. This document will explain how Paragon and Shopify sync the data once an order is created in Shopify.  Importing orders into Paragon From ...
    • How to import products, vendors, and customers from QuickBooks to Paragon

      So you've purchased Paragon for all your ERP needs (good for you!) and you've activated your QuickBooks integration.  Fantastic.  Time to get down to business.  First things first - you need to have all the relevant data from QuickBooks Online to be ...
    • How to view the general ledger (GL) report

      Ever have issues capturing the exact balance of your general ledger accounts in your business?  You won't anymore! ParagonERP includes the general ledger report to show you any changes that occur in any of your chart of accounts in the system. This ...