Before you start

  • You need Accounts Management and Edit on Accounts vouchers. To delete a draft, Delete on Accounts vouchers. Your company's plan is active and within its Accounts limit.
  • The bank account exists and is active. See Add, edit or delete a bank account.
  • You have the bank statement with its date, opening balance and closing balance.

Steps

Create the reconciliation

  1. In the sidebar, select Accounts › Reconciliation. The page is titled "Bank Reconciliation".

  2. Select New Reconciliation. "New Reconciliation" opens: "Create a new bank reconciliation".

  3. Fill in the statement:

    FieldRequiredWhat to enter
    Bank AccountYesThe bank account, shown as name - number. Lists active bank accounts.
    Statement DateYesThe date of the bank statement.
    Opening BalanceYesThe opening balance on the statement.
    Closing BalanceYesThe closing balance on the statement. Cannot be negative.
  4. Select Create Reconciliation. The card shows Draft, Opening, Closing and Difference.

Tick the lines and complete

  1. On the reconciliation's card, select View. "Reconciliation Details" opens with Opening Balance, Closing Balance, Book Balance and Difference.

    Step 1. Reconciliation Details with the balances and the Unreconciled Transactions table.
    Step 1. Reconciliation Details with the balances and the Unreconciled Transactions table.
  2. In Unreconciled Transactions, tick each line that is on the bank statement. Amounts show with + for money in and - for money out.

  3. Check the Difference. It is green at zero and red otherwise.

  4. Select Complete Reconciliation. To leave without completing, select Cancel.

Delete a draft reconciliation

  1. On the draft's card, select delete (bin). "Delete Reconciliation" asks: "Are you sure you want to delete this reconciliation? It will be removed from the list; the record is kept."
  2. Select Delete. To keep it, select Cancel.

Result

  • Create: the message "Reconciliation created successfully" shows. The Pending card counts drafts.
  • Complete: "Reconciliation completed successfully". The card reads Completed, the ticked lines become Reconciled, and the Reconciled card counts it. A reconciled line's voucher can no longer be cancelled.
  • Delete: "Reconciliation deleted successfully".

If something is different