Page Comparison

Info
This guide has been reviewed against our global client base and classed as relevant to the following regions: UK, APAC, UAE

The Bank Reconciliation screen displays all items that have been receipted previously, with Statement Items on the left displaying details of the statement and Transactions on the right showing the items to be reconciled.

1. Access option from main menu & select client account

From the main menu:

Click Estate
Select Daily Accounts Processes
Click Bank Reconciliation
Select the appropriate client account from the list and click Accept

2. Bank reconciliation screen

When opening the bank reconciliation screen, you are presented with two lists of transactions, split into different sections of the screen

The right-hand side represents transactions within the system and the left shows your bank account

This process is done to mark payments as cleared and reconciled before funds can be processed out of the system
Selecting an item on one side of the screen will highlight the corresponding item on the other side, making it clear what matches
With receipted payments, it is likely that they will already be ticked
Payments going out, shown as negative amounts on the bank statement items list, will not be ticked by default as you need to check the values are as expected (and match on both sides), before posting

Info
Balance brought forward (Balance B/fwd) and the Reconciled Balance* as well as total debits, credits and the grand totals are shown at the bottom left of the screen*

3. Post entriesImage Removed

To process the selected entries, click Post (bottom right of screen)
Green ticks will be displayed next to the reconciled items

Image Added

Click OK

4. Produce reconciliation report (export to Excel)

A reconciliation report should then be generated and saved for future reference - allowing this allows transactions to be tracked to the last point everything was correctly reconciled

Click Print (bottom right of screen)
Click Yes to include un-reconciled entries
Select Excel Export and click Accept

5. Save report

An example format report is shown below

Info
This report cannot be reproduced Before closing the spreadsheet, it should be saved locally

Close Excel and exit the Bank Reconciliation screen
This completes the process of bank reconciliation

Versions Compared

Old Version 1

New Version 2

Key

Related articles