Your Chart Of Accounts - Add/Edit New GL Lines in BankBI - Please note there is a full PDF guide with additional information available for download at the end of this article.
Customers can manage their Chart of Accounts within the BankBI Administration area. There are several changes that can be made to when managing your Chart of Accounts. These include mapping new GL Lines, GL Line description changes, Creating additional GL Lines, Changing GL Groupings and Changing the mappings between GL lines and BankBI Chart of Account Lines.
To make these changes select the menu option from the Administration Area of BankBI. Data Management > Edit Configuration Table > Your Chart of Accounts
This will present Your Chart of Accounts (pictured below). This is divided into sections which can be filtered for example you can view all the Unclassified GL lines by selecting the Unclassified filter. This can be particularly useful when new GL lines have been opened but not yet mapped to a relevant BankBI GL Account number.
Another useful function in Your Chart of Accounts is placed in the first row of the table. This first row permits users to conduct searches by BankBI GL Account, Your GL Account numbers, Your GL Descriptions and by any other Column heading. This can be particularly useful when a description requires an amendment or you wish to view a certain group or area of Your Chart of Accounts.
If you wish to make a large number of changes to Your Chart of Accounts or you wish to view it in full you can do so by clicking the 'Download Your Chart of Accounts as CSV'. Changes can be made and re-uploaded to BankBI. Please see the File Upload article if you are unsure of how to perform this task.
If you wish to edit one or more of Your Chart of Account lines using the on screen editing facility within BankBI you can by following this process. First locate the line you wish to edit.
By double clicking the line you will open the Item screen below; where a number of tasks can be performed.
Changes to which BankBI GL Account line a GL line is mapped to can be made here using the drop down lists in the first row or you can use the Auto Populate feature to copy the mapping and descriptions from a similar chart of account line and then continue to make changes once copied.
You can specify whether the line is a Balance Sheet line or an Income Statement/Profit and Loss line simply by selecting from the drop down list pictured below.
If the line requires its signage changed from positive to negative or negative to positive it can be specified using the COA_Balance_Factor drop down below.
You can also edit or add Your GL Description.
There are also 20 GL line description fields that can be used, maintained and edited if you wish to add you own Chart of Account Structure or multiple structures.
After any changes have been made its very important to 'Save' them or if you wish to start again or cancel changes you have made without saving you can simply click 'Cancel'. If changes are not Saved they will not be retained.
Once a change has been made it will not reflect within the BankBI reports until the next Generate Results has been performed. These generally take place overnight automatically. However they can be run manually by clicking on the Data Management > Generate results menu options in the Administration area of BankBI. This should be followed by clicking the button pictured below. Please note it can take up to 30 minutes for this to run and whilst running BankBI will lose some of its display functionality.