1.0 Bank Reconciliation

When logging in to the Bank Reconciliation Applet, the first page shown to the user is the Bank Recon Listing page. Then, users can press the ‘+’ button at the top left corner to start creating a bank recon.

Open

3.1 Details

Open

Users could then fill in the necessary information in each column. Please note that if a * sign appears on a column, users must fill in the relevant information in that column, as it cannot be modified later.

The fields that are needed to be filled in are:

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

• Opening Date

• Closing Date

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

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

• Name

• Cash Book Transaction Opening Balance

• Cash Book Transaction Closing Balance

• Cash Statement Opening Balance

• Cash Statement Closing Balance

• Status: Processing

After creating the bank recon, the created bank recon will be listed on 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.

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 them here.

3.3.2 Cashbook Statement Lines

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

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 auto-matching button allows users to match all the transaction lines.

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.