If your current bank balance does not match your actual bank balance then you can perform a manual bank account reconciliation to highlight missing/duplicate transactions.


To do so you will need to compare your actual bank statement to the Clear Books statement month by month. It is always best to begin from the first month where the opening balance in Clear Books matches the balance on your actual bank statement and the closing balance does not. This guide explains how to make that comparison.

Step 1.


Head to Money > Bank accounts.

Step 2.


Click on the balance of the account that needs reconciling.


Step 3.


Use the Choose a month drop-down menu to select the most recent month.


Step 4.


Compare the opening balance of this month against the opening balance on your actual bank statement.


If the opening balance is correct move to Step 5. If the opening balance is incorrect, select the previous month in Clear Books and perform the same check. Repeat this process until you get back to a month where the opening balances match.


Step 5.


Unreconcile all transactions in the month by selecting the check box at the top of the column and hitting the Unreconcile button.


Step 6.


Now that all the transactions within the month are unreconciled, try to match each transaction one by one with the transactions on your actual statement.


Tick the check box beside the appropriate transactions that do and hit the Reconcile button.



Each reconciled transaction will show a blue tick in the Reconciled column. This process should highlight any missing or duplicate transactions.


To delete duplicate transactions, click on the amount in the Withdrawals or Deposits column. You will be redirected to the details of that payment. Click on the Delete button at the top of the menu.



As soon as the month has been fully reconciled select the next month - the opening balance should agree to your actual statement, however, if the closing balance does not, repeat steps 5 & 6.