Bank Statement

1. Introduction

This document outlines the process of uploading and processing bank statements within our system. The primary goal is to automate the linking of bank statements to existing collections and create new auto-collections as needed.

2. Adding Bank Statements

There are two methods to Add bank statements:

2.1 Manual Add

• Step 1: Navigate to the "Bank Statements" section of the system.
• Step 2: Click the "Add New" button.
• Step 3: Manually enter the details for each statement(Bank Name, Bank Account No, Reference No, Currency, Amount, Description, Transfer Date & Transfer Time.)
• Step 4: Click "Save" to add the statement.

2.2 Upload Bank Statement

• Step 1: Navigate to the "Bank Statements" section of the system.
• Step 2: Click the "Upload Statement" button.
• Step 3: Select the bank from the dropdown list (BCEL, JDB, Maruhan, LDB, BFL, RHB).
• Step 4: Upload the bank statement file in the supported format.
• Step 5: Click "Upload" to initiate the file processing.

Once a bank statement is uploaded, the system will automatically perform the following checks:

• Contract Number: The transaction must match an existing contract number.
• Date: The transaction date must match the date on the contract or collection receipt.
• Currency: The transaction currency must match the contract or collection receipt currency.

• No Matching Collection:
  • If no matching collection is found, an auto-collection will be created for the statement.
  • The auto-collection will be automatically approved.

3. Viewing Bank Statements

Bank statements are categorized and displayed separately for credit and debit transactions. This allows for easy filtering and analysis.