AccountdesqFinancial intelligence
Bookkeeping

Bank Reconciliation Tool: The Complete Guide

Reconcile your bank statement with your cash book. Everything you need to know - plus a free tool to do it instantly.

Open the Bank Recon tool

30-second summary

  • Reconcile every active bank account monthly and high-volume accounts weekly if needed
  • Review every old reconciling item and clear or investigate it promptly
  • Keep the person approving payments separate from the person performing the reconciliation where possible
  • Use the same month-end or statement-end cut-off date for both bank and book balances
On this page
  1. What is bank recon?
  2. How it works
  3. Why it matters
  4. Common mistakes
  5. Best practices
  6. Related guides

What is bank recon?

Bank reconciliation is the process of matching your bank statement balance with your internal cash book or ledger balance and explaining any differences through reconciling items such as outstanding cheques, deposits in transit, bank charges, interest, or bookkeeping errors. AccountDesq’s Bank Reconciliation Tool helps accountants, bookkeepers, finance teams, and small businesses prepare a clear reconciliation statement online and export it to PDF or Excel.

How it works

Enter your company name, reconciliation date, currency, bank statement balance, and book or cash book balance. Add outstanding cheques, deposits in transit, bank charges, and other reconciling adjustments. The tool calculates adjusted bank and adjusted book balances in real time, highlights unreconciled differences, and lets you export a professional bank reconciliation statement.

Why it matters

Bank reconciliation is one of the most important cash-control procedures in any business. It helps you detect missing transactions, timing differences, bank charges not yet recorded, bookkeeping errors, and potential fraud before they affect reporting or cash decisions.

Common mistakes

  • Reconciling too infrequently instead of performing bank reconciliation every month or more often
  • Leaving old outstanding cheques or deposits unresolved for long periods without investigation
  • Ignoring bank charges, interest, bounced items, or direct debits that appear on the bank statement but are missing from the books
  • Treating unreconciled differences as normal instead of investigating and resolving every unexplained variance

Best practices

  • Reconcile every active bank account monthly and high-volume accounts weekly if needed
  • Review every old reconciling item and clear or investigate it promptly
  • Keep the person approving payments separate from the person performing the reconciliation where possible
  • Use the same month-end or statement-end cut-off date for both bank and book balances

Ready to put this into practice?

Use the free Bank Reconciliation Tool to create a real bank recon in under a minute - no signup, exports to PDF and Excel.

Open Bank Recon tool