Chart of Account Mapping

The Chart of Accounts Mapping feature enables you to map unclassified chart of accounts codes by dragging and dropping them from unclassified to the correct chart of account code.

Unclassified chart of accounts codes are likely to be new balance sheet or profit and loss codes that have been added to your general ledger system that, when loaded to BankBI, generates what is known as an unclassified codes record in the BankBI system.

When the page loads select a Balance Date to load balance figures into the BankBI Chart of Accounts table on the left hand side. 

To map an unclassified code click on the "Unclassified" line at the top of the BankBI Chart of Accounts table on the left hand side. This will filter the data on the Your Chart of Accounts mapped to table on right hand side to display the code from your chart of accounts that has been auto-generated in BankBI and mapped to #99999999 Unclassified.

There are two options for mapping unclassified GL lines from here:

1. Drag and drop mapping
2. Auto-populate mapping.

Both are described below.

Drag and Drop GL Mapping

If this code should belong in ATM within Cash and Assets, you can drill down the BankBI chart of accounts structure on the left hand side by clicking the plus symbol to find ATM which already has 9 lines mapped to it:

You can now drag the auto-generated unclassified code from the right hand table to the left hand table to map it to ATM:

There are now 10 records in ATM and the balance figure will be updated:

When you double-click on a line you can update "Your GL Description" from the auto-generated unclassified description assigned to the code by BankBI to the correct description - "Cash in ATM" in this example. 

Examples of fields to be reviewed: Is the GL number is a Balance Sheet line or an Income Statement/Profit and Loss line? If this needs to be changed simply by selecting from the dropdown 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 dropdown below.

Once you’ve made your changes you need to scroll down to Save them:

Auto Populate GL Mapping

Locate the GL line you wish to map.

By double-clicking the line you will open the Item screen below:

Changes can be made using the Auto Populate feature which will copy the mapping and descriptions from a similar GL Account number by entering the GL code.

Select the closest GL match and select ‘Auto Populate’

A message will appear asking if you would like to overwrite the information in the existing GL mapping, select ‘Overwrite’.

The data has been replaced with the selection. Now you review all the fields that have been populated.

After any changes have been made it's essential to 'Save' them. If you wish to start again or cancel changes you have made without saving you can click 'Cancel'.  If changes are not saved they will not be retained.

You will now notice that the GL code has moved out of the ‘Unclassified’ section.

Once a change has been made it will not reflect within the BankBI reports until the next Financial Performance 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.