Article Objective: To assist users in navigating Active Ledger & Reporting to bring in, edit and roll over opening balances, as well as reconciling opening balances with the practice ledger file.
Context: There are several ways in which opening balances can be brought into or edited in Active Ledger. This allows full flexibility if data manipulation is required, or if you are wanting to roll over opening balances from other files.
Please refer to the Glossary for definitions of key terms used in this article.
TABLE OF CONTENTS
|
Overview
Why do we need opening balances?
Certain reports and calculations require the opening balance of any given account. In Active Ledger, the following reports require opening balances:
Statement of Changes in Equity
Statement of Cashflows
In addition, calculations such as debtors days, creditors days and inventory days also require the use of opening balances.
How are opening balances calculated?
Opening balances in any given dataset are calculated from journals which are specially marked as 'Opening Balance' journals. There are two kinds of opening balance journals:
1. Imported opening balance journals
These represent opening balances that have been imported from another system or dataset. They can be created in the following three ways:
An import from the client file (via API)
An import via Excel
A roll over from a previous dataset
2. Opening balance adjustment journals
Opening balance adjustment journals can be entered directly in Active Ledger in order to create and/or adjust the values of opening balance journals. They work like any other journal except that all entries count towards the opening balance of that particular account.
Directly imported from the client file
The easiest way to bring in opening balances is to simply use the opening balance journal that is imported when you connect directly to the client's file. This method works best if you know that the file is clean and contains the correct data.
Imported from Excel
Generally, when using the Excel add-in to import data, a whole trial balance is imported to create a new dataset. However, it is also possible to use this function to create just an opening balance journal. To do this, first prepare your data using the three to six column method as normal. For more information on how to use the Excel add-in to import data see the knowledge article: Datasets - Excel trial balance import.
When the journal dialogue appears, you will need to change the Journal Type from 'Imported Trial Balance' (the default) to 'Imported Opening Balance' using the dropdown menu. You will get a notification that the import will override any existing import journal for the same period. This ensures that there are no double ups when importing several times or from multiples sources.
Roll over from a previous dataset
If you are aware that the client's prior year closing balances in their file are incorrect, you can choose to use a prior year's dataset when creating the current year dataset. To do this, select the Roll over opening balances checkbox when adding a new dataset. This will bring up an Opening Balance Dataset dropdown to select the relevant dataset to use. From here you are also able to refresh the opening balances if any changes occur in the selected dataset.
In this case, instead of seeing the opening balances as an imported journal, they will appear as a separate journal marked not for export, with the amounts coming from the closing balances of the dataset chosen rather than from the client's file.
Note: You are only able to roll over where you are rolling from a dataset connected to the same source.
Using the prior year's dataset with 'opening balance accounts'
As an added bonus, this method can also be used if you have tagged specific accounts as Opening Balance Accounts in the chart of accounts. This ensures that any account balances sitting under the same header, will be moved to those tagged accounts in subsequent years. This is particularly useful for beneficiary/ partner accounts.
To ensure that the balances are rolled into the correct accounts in subsequent years, make sure that your accounts are set up correctly in the chart of accounts. The example below shows a typical set up for a beneficiary.
Note: All beneficiary accounts associated with Jenny Johnston sit under the header 'UPE - Jenny Johnston'. This is the same for Joe Johnston and would be for any other beneficiaries.
The account 'Opening Balance - Jenny Johnston' is tagged as an opening balance account. This tells Active Ledger to move the balances of the 'Drawings - Jenny Johnston' and 'Share of Profit - Jenny Johnston' accounts to this account when creating next year's dataset.
An example is shown below of the resulting balance sheet after creating the new dataset.
Using an opening balance adjustment journal
A full opening balance journal can be prepared in Active Ledger using the journals screen. However, this method can also be used to make adjustments to already imported opening balances. This is particularly useful if you just need to make a small change to your client's data.
To create an adjustment journal, navigate to the Journals tab in the Datasets screen and create a new journal. In the journal type, dropdown menu select Opening Balance Adjustment Journal. Fill in and save your journal as normal.
Note: Unlike the three methods described above, in this method the 'Opening Balance Adjustment Journal' will be ADDED to any opening balances that already exist in the file. It will NOT replace any opening balances.
How to correct opening balances to reconcile with practice ledger file
To see how to correct opening balances to reconcile with the practice ledger file, refer to the knowledge article: Accounts - reconciling client opening balances with practice ledger file.