Uploading Balance Sheet & Profit & Loss Adjustments

Manual adjustments can be passed into BankBI by uploading a .CSV file within the Web Application.  At the foot of this article there is a template .CSV attached.  You can download this, edit it with the adjustments you wish to pass and upload it to BankBI using the method outlined below.  

Manual adjustments are cumulative for each month and branch. If adjustments already exsist within BankBI for the current month and branch please do not use the example file below.  You must download the existing measures file from BankBI, extract the Adjustments already passed within that month and add any new adjustments to that file.

The file contains one line (record) as an example, please delete this before uploading your adjustment file into the system. 

You may also wish to view data your other tables held within the Web Application to ensure the adjustments you wish to pass are formatted accurately.

Once your .CSV is prepared, login to www.bankbiapp.com and click on 'Upload New File' under the menu option 'Data Management'

Now click the menu option 'Add CSV File(s)'

Select the appropriate .CSV file and 'Open'

You will now see a 'Pending' Status as you will need to select from the drop down list what type of file it is.  A manual Adjustment file is deemed as a 'Measures' file.

Select the 'Measures' file type (as above).  Now you have a series of menu options, you can delete the file by clicking the red trash button below, add more .CSV file(s), cancel or Upload.  If you are happy with your file and wish to pass the adjustment click 'Upload files()

Depending on how large the file is, the upload can take a several minutes to finish uploading.  Once the status has changed from 'Uploading' to 'Uploaded' you can again move about the Web Application freely.

You can check the Upload Status by clicking of the relevant option (as pictured above).

When the file you have uploaded has finished it will have a Job Status of 'Complete' and this means you are ready to 'Generate Results' (pictured on the Data Management menu above).

You will be able to 'Generate Results' in this area.  Once this has finished the 'Job Status' here will also say 'Complete' 

For more information about BankBI please visit our website at bankbi.com