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, mfi 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.The trail balance sheet final calculated amount is automatically calculated in the BOL report uploading system. Upload the correct data carefully.If any mistake the xml report can not be uploaded to the report submitting system. 

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.
  • The system rejects pending and close contracts. Only active contracts are eligible for upload.

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 (need to 1 or 2 )

      Depositor Type
      		id value


      		1 ລູກຄ້າບຸກຄົນ


      		2 ລູກຄ້ານິຕິບຸກຄົນ

    • Deposit Type ID

    • deposit_types
      		id value


      		1 ເງິນຝາກກະແສລາຍວັນ


      		2 ເງິນຝາກປະຢັດ


      		3 ເງິນຝາກປະຈໍາ


      		4 ອື່ນໆ

    • 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. The Depositor ID  need to contain the company system.
  5. The Enterprise ID should be company enterprise ID(4015)

  6. 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.4.10. 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.4.11. Creation between MFI Branch Service Units file

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

image.png

3.4.12. Creation  MFI HQ Service Units file

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

image.png

3.5 Member Share Details 
Currently this section is not required for BOL report.User can Skip this section 

The Member Details page allows users to upload member-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 member share information.

3.5 Loan Details 

The Loan Details page allows users to upload Loan-related ECL balance 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 loan details information.

image.png

3.5.1. Download Loan details Template

  • Navigate to BOL Report → Loan details.

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

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

3.5.2. Upload Loan Details File

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

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

  3. The uploaded file need to contain the active contract number with ECL balances.

  4. Click the Upload button.

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

  6. The uploaded data will display below of the page.
3.6 Report Info 

The report info section is a Form.That need to complete with correct details.

Navigate to BOL Report → Report Info.

image.png

3.7 Process BOL report.

After successfully uploading the relevant document sheets , user need to click the Process button to process the report.

Navigate to BOL Report → Process BOL report

image.pngAfter completing the report processing, user can download using the Download Report button.
Relevant XML file will be downloaded.

3.7 Important Points.
  • The Trial balance sheet final amount need to equal to the Sum of the Remaining Balance of the Loan section in XML file
3.8 Report verification.
  • After successfully downloading the XML report, user need to upload the XML report to below test report  site.
  • This site -> http://139.5.159.175:8556/report/report-xml-import/0
  • Username - user24
  • Password - ddtpo5568866
  • This site displays multiple validation messages if the report contains errors. If any errors are found, they should be reviewed, corrected, and the report should be resubmitted.
No Comments
Back to top