Step by step
- Open Accounting > Bank Reconciliation and press New Reconciliation.
- Choose the Bank Account, enter the Statement Date and the Closing Balance printed on the statement (an overdrawn balance as minus), and a Note if you like.
- Press Load Entries. The entries up to the statement date that are not cleared yet are listed with their Deposit (Dr) and Withdrawal (Cr).
- Tick each entry that is on the statement. Cleared Date is set to the statement date; change it to the date the bank shows if you want. Tick All and Untick All work on the whole list, and the search box finds a voucher, a text or an amount.
- Watch the tiles: Statement Balance, Cleared Balance, Difference, Book Balance, Deposits Not Cleared and Withdrawals Not Cleared.
- Import Statement reads a CSV file of the bank statement: choose the file, press Find Matches, check the matches and press Tick Selected Matches.
- Press Save Draft to go on later, or Complete when the Difference is 0.
Good to know
- Complete works only when the Difference is 0. If it is not, look for entries you have not ticked, or for bank charges and interest that are not yet in your books.
- On Complete the ticked entries are locked as cleared. A completed reconciliation cannot be changed; only the latest one can be undone from the list.
- The Statement Date must be after the last completed reconciliation of the account.
- In the CSV the columns are found by their titles: Date, Description and Deposit / Withdrawal (or Credit / Debit, or one Amount column with minus for money out). An entry of the same amount within 3 days is a match. Importing saves nothing by itself.
- Tick Entries cleared earlier in this period to also see what was cleared before.