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

Bank statement.png

2.2 Upload Bank Statement

Bank statement 1.png

Once a bank statement is uploaded, the system automatically performs a series of checks to identify and link transactions to existing collection receipts. The following criteria are used to match transactions:

If a transaction meets all three criteria, it is successfully linked to the matching collection receipt.

3. Bank Statement Page(Credit/ Debit)

The Bank Statement page provides a comprehensive overview of all bank statements uploaded or manually entered into the system. It offers several search filters to help users locate specific statements efficiently:

Search Filters:

bank statement 2.png

Total Amounts

The page displays the total amount of all filtered statements in the following currencies:

statement 3.png

Bank Statement Table

The main table on the page lists all bank statements, providing detailed information about each transaction. Users can perform various actions on these statements:

statement 4.png

  1. Assign: Redirects to the Collection Receipt page to assign the statement to a specific collection receipt.
  2. Assign Collection: Opens a popup window to assign the statement to a bank collection.

statement 5.png

  1. Assign Account: Opens a popup window to assign the statement to a specific account.

statement 6.png

  1. Delete: Removes the statement from the database.

Exporting Bank Statements

The "Export" button allows users to export the filtered bank statement data into a downloadable format for further analysis or reporting.

By utilizing these features and filters, users can effectively manage and analyze bank statements, ensuring accurate financial records and efficient processing.


Revision #5
Created 11 November 2024 08:26:17 by Odeesha Gamage
Updated 11 November 2024 10:46:11 by Odeesha Gamage