To manually reconcile the cash book, compare the figures from the cash book report against the nominal bank account transactions.
Opening balance
Add up all transactions on the nominal bank account for all periods up to (but not including) the current period. The difference between the debit and credit totals 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) should match the cash book balance shown at the bottom of the same report. If the figures above are correct but a difference still exists, check the reconciled balance 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.
Confirm the 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 must be corrected in the database — this cannot be done from within Dimensions. Contact support and include details of the incorrect figures.