Matching Bank Reconciliation Report to a Trial Balance

To ensure that you are comparing the Bank Reconciliation to the Trial Balance correctly, it is important to understand the criteria that both run with.

In the following example we will use the scenario where a user may wish to compare the Actual Balance in Books on the Bank Reconciliation Report with that of the Trial Balance at the end of April 2017.

The Bank Reconciliation Report uses an as at Date, but does not give you the option to select a period as shown below.

1.png

The Trial Balance only allows you to select a period as shown below, for example, Period 08 is April 2017.

2.png

In our example, the report shows an Actual Balance in Books value of £4,755.01.

3.png

But the Trial balance shows a balance of £3,947.01

4.png

The reason that these are different is because the two are not running with a like for like criteria. To rectify this:

  1. Right-click in the grey box on the cashbook nominal, then select Details.

  2. Select Criteria from the top of the screen. The Selection Criteria window displays. Select the Criteria tab.

  3. Select the As at Enquiry box, then select Less than or equal to from the Dates drop down and enter the same date you are running the Bank Reconciliation Report.

  4. Select All from the Periods list as the Bank Reconciliation report does not use this and select OK.

    The total at the bottom of the screen will now match that of the Bank Reconciliation Report.