Match Bank Reconciliation Report to a Trial Balance

To compare the Actual balance in books on the Bank Reconciliation Report with the balance of the Bank Current Account nominal on a Trial Balance, do the following:

1. Run a Trial Balance for the required periods.
2. Right-click on the Bank - Bank Current Account (9940) nominal line, then select Details.
3. Select CRITERIA.
4. In General, do the following: 
   1. Document Date — Change All to Less Than Or Equal To
   2. Value 1 — Enter the as at date used when running the Bank Reconciliation Report.
5. In Periods, select Period Range and leave as All.
6. To update the Detail Enquiry, select OK.
7. To group the results by period, select the Period column, then drag and drop it on Drag a column here to group by that column.

The total should match the total displayed on Actual balance in books on the Bank Reconciliation Report.