What you see

  • A reconciliation's Difference is red: the closing balance and the book balance differ.
  • Or a reconciliation was completed with a difference, or with no line ticked.
  • Or a completed reconciliation has no delete and cannot be reopened.
  • Or after a draft reconciliation was deleted, lines that were reconciled earlier read Pending again.
  • Or cancelling a voucher says "This voucher has a reconciled bank entry. Undo the reconciliation before cancelling it."
  • Or the Pending and Reconciled cards count reconciliations whose badges read Draft and Completed.

Why it happens

  • The book balance is the bank account's head opening balance plus every approved voucher on the head up to the statement date. Drafts, a wrong opening balance, missing or cancelled bank entries, or a wrong statement date all make a difference.
  • Complete Reconciliation does not check the difference. It completes with whatever is ticked.
  • A completed reconciliation cannot be undone on the screen. Its lines stay reconciled.
  • Deleting a draft sets every reconciled line of that bank account back to Pending, not only the lines of that draft.
  • A reconciled bank line protects its voucher. It cannot be cancelled while the line is reconciled.
  • The cards and badges use different words for the same states: Pending counts Draft, and Reconciled counts Completed.

What to do

  1. Before completing, check the Difference. If it is not zero, look for drafts to approve, bank lines to add, and the head's opening balance. See A bank balance or opening balance looks wrong.
  2. Check the Statement Date and the balances you typed. If they are wrong, delete the draft and create it again. See Reconcile a bank account.
  3. After deleting a draft, tick the earlier lines again in the next reconciliation.
  4. For a completed reconciliation that was wrong, or a voucher you must cancel whose line is reconciled, submit a request with the bank account, the statement date and the voucher number.

If it still happens

If the difference stays after these checks, submit a request with the bank account name and the statement date.