Skip to main content

BOL Report Module – User Manual

1. Introduction

The BOL Report module is designed to help users view, verify, and generate reports related to financial and member data required for BOL reporting. This module provides structured access to balances, contracts, deposits, member shares, and final report processing.

This user manual explains each menu item and guides users on how to use the BOL Report module effectively.

2. Accessing the BOL Report Module

  1. Log in to the system using your authorized user credentials.

  2. From the left-side navigation panel, click BOL Report.

  3. The BOL Report submenu will expand and display the available report options.

3. Menu Options Overview

The BOL Report module contains the following options:

  • Trial Balance

  • Contracts List

  • MFI Details

  • Deposits Details

  • Member Shares Details

  • Report Info

  • Process BOL Report

Each option is explained in detail below.

3.1 Trial Balance

The Trial Balance page allows users to upload trial balance data using a predefined Excel template and review the uploaded data before it is used in the BOL reporting process. This ensures consistency, accuracy, and proper validation of financial data.

3.1.1 Download Trial Balance Template

  1. Navigate to BOL Report → Trial Balance.

  2. Locate the Download Template section at the top of the page.

  3. Click on Template.

  4. An Excel (.xlsx) file will be downloaded to your computer.

    Note:     The template contains predefined columns and formatting. Do not modify column names or structure.1.png

3.1.2. Fill in the Template

  1. Open the downloaded Excel template.

  2. Enter the trial balance details according to the given columns (e.g., Account No, Account Title, Debit, Credit, Adjustments).

  3. Ensure all values are entered in the correct format.

  4. Save the file after completing data entry.

3.2.3 Upload Trial Balance File

  1. In the Upload New section, click Choose File.

  2. Select the completed Excel (.xlsx) file from your computer.

  3. Click the Upload button.

  4. Wait for the system to process the file. 

3.2.4. View Uploaded Trial Balance Data

  • After a successful upload, the uploaded data will be displayed in the table below.

  • Review the displayed records carefully.2.png

3.2. Contract List 

The Contracts List page allows you to bulk-upload contract numbers into the system using a standardized Excel template. Follow these steps to ensure your data is processed correctly.

3.2.1. Download the Template

  • Before uploading any data, you must use the official format to prevent errors.
  • Navigate to the BOL Report menu on the left sidebar and select Contracts List.
  • Under the Download Template section, click the blue Template link.
  • An .xlsx file will download to your computer.

3.png

3.2.2. Fill in the Template

  • Open the downloaded Excel template.
  • Enter your contract details into the designated columns (e.g., Contract Number).
  • Note: Do not change the column headers or the file format, as this may cause the upload to fail.
  • Save the file on your local drive.

3.2.3. Upload the Completed File

  • Once your file is ready, you can import it into the system:
  • Go to the Upload New section on the page.
  • Click the Choose file button.
  • Select the saved Excel file from your computer.
  • Click the green Upload button to process the file.

3.2.4. View Uploaded Contract Data

  • After a successful upload, the uploaded data will be displayed in the table below.

  • Review the displayed records carefully.

4.png

 

 

3.3 Deposits Details

The Deposits Details page allows users to upload deposit-related data using a predefined Excel template and review the uploaded records before they are included in the BOL reporting process. This ensures accuracy and standardization of deposit information.

3.3.1. Download Deposits Template

  • Navigate to BOL Report → Deposits Details.

  • Locate the Download Template section at the top of the page.

  • Click Template to download the Excel (.xlsx) file.

5.png

3.3.2. Fill in the Deposits Template

  1. Open the downloaded Excel template.

  2. Enter deposit-related information according to the predefined columns, such as:

    • Account No

    • Depositor Type ID

    • Deposit Type ID

    • Depositor ID

    • Enterprise ID

    • From Date and To Date

    • Interest Rate Date

    • Opening Balance

  3. Ensure date formats and numeric values are entered correctly.

  4. Save the completed file.

3.3.3. Upload Deposits File

  1. In the Upload New section, click Choose File.

  2. Select the completed Excel (.xlsx) file.

  3. Click the Upload button.

  4. Wait for the system to validate and process the file.

3.3.4. View Uploaded Deposits Data

  1. After a successful upload, the uploaded deposit records will be displayed in the table below.

  2. Review each record carefully, including:

    • Account Number

    • Depositor and Deposit Type IDs

    • Date ranges

    • Opening balance amounts

  3. If errors are identified, correct the Excel file and re-upload it.

image.png

3.4 MFI Details

The MFI Details page allows users to upload MFI  data using a predefined Excel template and review the uploaded records before they are included in the BOL reporting process. This ensures accuracy and standardization of MFI information.

This page has five Tabs.

  • MFI Info.
  • MFI Service.
  • MFI Branch.
  • MFI Branch Service Units
  • MFI HQ Service Units

After uploading the sample excel sheets.The data will be displayed.Need to navigate the tabs.

 

image.png

3.4.1. Download MFI Info Templates

 

  • Navigate to BOL Report → MFI details.

  • Locate the Download Template section at the top of the page.

  • Click Mfi Info Template to download the Excel (.xlsx) file.

3.4.2. Upload MFI Info  File

image.png

  1.  In the Upload New section, select Mif Type as MFI Info

  2. click Choose File.

  3. Select the completed Excel (.xlsx) file.

  4. Click the Upload button.

  5. Wait for the system to validate and process the file.

  6. The uploaded data will display under MFI Info Tab.

image.png

3.4.3. Download MFI Service Unit Info Templates

  • Navigate to BOL Report → MFI details.

  • Locate the Download Template section at the top of the page.

  • Click Mfi Service Unit Info Template to download the Excel (.xlsx) file.

3.4.4. Upload MFI Service Unit Info File

  1.  In the Upload New section, select Mif Type as MFI Service .

  2. click Choose File.

  3. Select the completed Excel (.xlsx) file.

  4. Click the Upload button.

  5. Wait for the system to validate and process the file.

  6. The uploaded data will display under MFI Service Tab.

3.4.5. Download MFI Branch Info Templates

  • Navigate to BOL Report → MFI details.

  • Locate the Download Template section at the top of the page.

  • Click Mfi Branch Info Template to download the Excel (.xlsx) file.

3.4.6. Upload MFI Branch Info File

  1.  In the Upload New section, select Mif Type as MFI Branch .

  2. click Choose File.

  3. Select the completed Excel (.xlsx) file.

  4. Click the Upload button.

  5. Wait for the system to validate and process the file.

  6. The uploaded data will display under MFI Branch Tab.

3.4.7. Download MFI Branch Service Units Info Templates

  • Navigate to BOL Report → MFI details.

  • Locate the Download Template section at the top of the page.

  • Click Mfi Branch Service Units Template to download the Excel (.xlsx) file.

3.4.8. Upload MFI Branch Service Units File

  1.  In the Upload New section, select Mif Type as MFI Branch  Service Units.

  2. click Choose File.

  3. Select the completed Excel (.xlsx) file.

  4. Click the Upload button.

  5. Wait for the system to validate and process the file.

  6. The uploaded data will display under MFI Branch  Service Units Tab.

3.4.9. Download MFI HQ Service Units  Templates

  • Navigate to BOL Report → MFI details.

  • Locate the Download Template section at the top of the page.

  • Click Mfi Branch Service Units Template to download the Excel (.xlsx) file.

3.5.0. Upload MFI HQ Service Units File

  1.  In the Upload New section, select Mif Type as MFI HQ  Service Units.

  2. click Choose File.

  3. Select the completed Excel (.xlsx) file.

  4. Click the Upload button.

  5. Wait for the system to validate and process the file.

  6. The uploaded data will display under MFI HQ  Service Units Tab.

3.5.1. Creation between MFI Branch Service Units file

When creating the MFI Branch Service Units file need to fill the mfi_branch_id according to it service_unit_id .

image.png

3.5.2. Creation  MFI HQ Service Units file

When creating the MFI HQ Service Units file need to fill the mfi_hq_id according to it service_unit_id .

image.png

 

Back to top