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.
Head to Money > Bank accounts.
Click on the balance of the account that needs reconciling.
Use the Choose a month drop-down menu to select the most recent month.
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.
Unreconcile all transactions in the month by selecting the check box at the top of the column and hitting the Unreconcile button.
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.
For additional help, click here to view all our training options.
Technical support is available on Monday to Friday from 9 - 5. You can call us on 0203 475 4744 or email us at firstname.lastname@example.org.
Alternatively, visit our Community to view our latest news & updates, raise new ideas, find answers to common problems, ask new queries and speak to other Clear Books users and employees.