Compare the figures from the cash book report then to manually reconcile go to the nominal bank account transactions:
Opening Balance:
The total of all periods (inc other) up to the period before the current period (i.e don’t include current period transactions), transactions of the nominal bank account transactions
(The difference between the Debit and Credit is the opening balance)
Receipts:
From the Nominal bank account, it’s the total of the debit transactions from the current period transactions to the foremost future period.
Payments:
From the Nominal bank account, it’s the total of the credit transactions from the current period transactions to the foremost future period.
Closing Balance:
Opening balance + (receipts - payments) = closing balance
The closing balance on the reconciliation report (printed from within the reconciliation window of the cash book) should agree to the cash book balance at the bottom of the same report.
If all of the above figures are correct and there is still a difference between the closing balance and the cash book balance, the reconciled balance can be checked as follows:
On the Financials tab, in the Cash Book section, click Auto Bank Reconciliation.
In the reconciliation window of the cash book account, in the top right, click Print.
From the list of available reports, select Full Reconciled Audit.
Select All Years.
Check Statement Ref field is blank.
Click the Print to screen icon.
At the bottom of the report find the total income and total expenses figures which, when subtracted from one another, should agree to the reconciled balance figure.
Note: If any of the above figures are incorrect they will require amending in the database. This cannot be carried out from within Dimensions. Therefore please raise a new case online and reference the title of this article and please include details of the figures that are incorrect.