3.0 Bank Recon Listing

When logging in into the Bank Reconciliation Applet, this is the first page that will be shown to the user, which is the Bank Recon Listing page. Then, users could proceed to press the ‘+’ button placed at the top left corner to start creating a bank recon.

Bank Recon Listing

3.1 Details

Users then could fill in the necessary information on each column. Please be noted that if there is a * sign on the column, users must fill in relevant information in that column as it could not be modified later.

Bank Recon

The fields that are needed to be filled in are:

  1. Cashbook: Users can choose the cashbook they have created in Cashbook Applet

  2. Opening Date

  3. Closing Date

  4. Company: Users can choose the company they have created in Organisation Applet

  5. Branch: Users can choose the branch they have created in Organisation Applet

  6. Name

  7. Cash Book Transaction Opening Balance

  8. Cash Book Transaction Closing Balance

  9. Cash Statement Opening Balance

  10. Cash Statement Closing Balance

  11. Status: Processing

Bank Recon

After creating the bank recon, the created bank recon will be listed in the main page. Users could click on the name of the company to make further changes.

3.2 Upload Statement

In the Upload Statement tab, users can upload the bank statements that they wish to do bank recon for. Users just need to go to the “+” button, to start uploading the bank statement. Before uploading, users have to choose the type of bank from the drop down list, and enter the Bank Statement Name. Please be reminded that the file has to be in csv.format. After uploading the statements, users can click the “upload” button to save the details.

Upload File

3.3 Manual Matching

3.3.1 Cashbook Transaction Lines

If the users use our ERP system, the system will automatically help the users to sync all the casebook transaction lines and users will be able to view here.

Transaction

3.3.2 Cashbook Statement Lines

At this tab, users are able to see the list of statement lines they have uploaded here.

Transaction

3.4 Auto Matching

Users can choose to go into “Cashbook Transaction Lines” or “Cash Statement Lines”. In both tabs, users can click to view “Match Txn Lines” or “Unmatched Txn Lines”. The automatching button allows users to match all the transaction lines.

Auto Matching

3.5 Report

The users are able to generate reports for the bank statement uploaded by clicking on the button “generate report”. Users are able to see a summary of the bank recon.

images::report.png[Report, align = "center"]