Reconciling a bank account
Matching a month's bank statement to your books, dealing with the lines that don't match, and completing the reconciliation.
Watch it done: Close the month with confidence
A bank reconciliation proves that what your books say is in a cash account agrees with what the bank says. Do one for each bank account, every month, before you close the month.
Starting a reconciliation
Open Financials – G/L › Bank Reconciliation and click New reconciliation. Choose the cash account, type the ending balance from the bank statement, and enter the statement's start and end dates.
On an account's first reconciliation, check the beginning balance too; BeanDish fills it in from the books. After that, each reconciliation starts from the last completed one.
Click Start reconciliation. The top of the screen shows the beginning balance, what has cleared, the statement's ending balance and the Difference still to explain.
Bringing the statement in
If your bank is connected under Bank connections, its transactions come in as statement lines. Otherwise click Import statement and choose the file your bank gives you: CSV, OFX or QFX. Lines already imported are skipped, so importing the same file twice does no harm.
Matching
- Suggestions. Where a line in your books has the same amount within five days, BeanDish suggests the match and says why. Click Accept.
- By hand. For anything else, click Match… on the statement line, then Select beside the book line it belongs to.
- A small difference. If a matched pair differs by a little, Write off posts the difference to the write-off account set under Settings › G/L, within its limit. Correct posts it against the account the entry was coded to.
- Something the books don't have yet. A bank charge, say: post it as a journal entry, then accept the suggestion back in the reconciliation.
- Not cleared yet. Leave an outstanding check alone. It stays with the uncleared book lines for next month.
Completing
When the Difference reads 0.00, click Complete. The matched lines are locked, and the account's next reconciliation starts from this one's ending balance.
See every step
The video above shows a reconciliation finished as part of closing the month. The tutorial below goes slower: a statement imported, suggestions accepted, a late check matched by hand, a fee written off and an outstanding check carried over. The same tutorial is in BeanDish under Learn › Tutorials.
Reconcile a bank account, step by step
A month’s bank statement imported and reconciled against the books: suggested matches accepted, a late check matched by hand, a wire fee written off, a bank fee posted and matched, an outstanding check carried over, and the reconciliation completed. (4:20)