How to Perform a Bank Reconciliation

Bank Reconciliation is the essential process of comparing your company's internal cash records (your cash book) against the statements provided by your bank. This ensures that your accounting records accurately reflect your actual bank balance, helping identify any discrepancies, missing entries, or bounced checks.

**[Image: Bank Reconciliation dashboard overview showing the filtering options and data table]**

1. Accessing Bank Reconciliation

To begin reconciling your accounts, follow these steps to access the correct module:

1. Look at the main left-hand navigation menu.
2. Click on the Accounts module to expand it.
3. Select Bank Reconciliation from the dropdown list.

2. Setting Your Filter Criteria

At the top of the Bank Reconciliation screen, you will find several filters to help you locate the specific transactions you wish to reconcile. Fill these out according to the statement you are reviewing:

• Voucher: Select the relevant voucher number from the dropdown list.
• Bank: Choose the bank account you are currently reconciling (e.g., ADCB Bank, CAREEM).
• Party Account: Select the specific party account associated with the reconciliation, if applicable.
• Branch: Choose the specific company branch (e.g., Abu Dhabi, Sharjah) or select "All" to view all branches.

**[Image: Top filter section highlighting Bank, Party Account, and Branch selections]**

3. Refining the Transaction Data

Below the primary account settings, use the radio buttons and date filters to narrow down the specific checks or transactions:

• Select Date Type: Choose whether to filter the records by the Transaction Date or the actual Cheque Date.
• Select Status: Filter the transactions by their current clearing status. Options include All, Cleared, or Not Cleared.
• Select Transaction: Choose the type of transaction you want to view. Options include All, Receipt, or Payment.
• Date Range: Use the calendar dropdown to set a specific start and end date for the transactions you want to retrieve.

4. Loading Transactions and Viewing Balances

1. Once your filters are set, enter the Balance as per Bank Statement in the designated text field on the right side of the screen.
2. Click the dark Show button to load the data based on your selected criteria.
3. The system will automatically calculate and display the Opening Balance as of the selected date directly below the date filters.

**[Image: Opening balance and "Show" button being clicked]**

5. Reviewing the Transaction Table

After clicking "Show", the data table will populate with relevant check and transaction entries. The table provides a comprehensive view of every record, including:

• Document Number
• Transaction Date & Cheque Date
• Party Name & Cheque Amount
• Cheque Number
• Cleared or Not Status & Clearing Date
• Voucher Type (VType)
• Bounced or Not (If a check has bounced, this column will indicate it, and the specific bounce date will be displayed in the Bounced Date column).

6. Saving and Printing the Reconciliation

Once you have reviewed the entries and made your reconciliations in the table:

1. Print Option: If you need a physical or PDF copy of the reconciliation right away, check the Print While saving box located at the bottom left of the screen.
2. Save: Click the green Save button at the bottom right.
   Note: You must have valid entries loaded in the table to save. If the table is empty and you click Save, the system will show an error message reading: "Check entry is empty failed."
3. Clear: If you need to reset the form and start over, click the blue Clear button next to Save. This instantly empties all fields and table data so you can begin a new reconciliation search.

**[Image: Bottom action bar showing Print While saving checkbox, Save button, and Clear button]**