What are outstanding cheques in a bank reconciliation?

Outstanding cheques are cheques or payments that have already been recorded in your books but have not yet cleared the bank statement by the reconciliation date. They reduce the adjusted bank balance during reconciliation.

What are deposits in transit or uncleared deposits?

Deposits in transit are receipts or deposits that you have recorded and paid into the bank, but which do not yet appear on the bank statement by the reconciliation date. They are added to the bank balance when preparing a bank reconciliation statement.

Why does my bank statement balance not match my cash book balance?

Differences usually happen because of timing items such as outstanding cheques or deposits in transit, or because bank charges, interest, direct debits, bounced items, or bookkeeping errors have not yet been recorded in one place or the other.

How often should bank reconciliation be done?

Monthly bank reconciliation is the minimum for most businesses. High-volume businesses, cash-intensive businesses, or companies with tighter internal controls may reconcile weekly or even daily.

Bookkeeping

Bank Reconciliation Tool

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.

Read the full guide

No data stored - 100% browser-based Free forever - no account required PDF & Excel export

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.

Quick Start:

Your Business Name

As At Date

Currency

Bank Statement Balance

Book (Cash) Balance

Outstanding Cheques

Issued but not yet cleared by the bank - deduct from bank balance

$0.00

Deposits in Transit

Recorded but not yet processed by the bank - add to bank balance

$0.00

Bank Charges & Interest

Bank fees/interest not yet recorded in your books - deduct from book balance

$0.00

Other Adjustments

Errors, NSF cheques, or any other reconciling items

$0.00

No items - add one below if applicable.

Reconciliation

Bank Balance$0.00

+ Deposits in Transit$0.00

− Outstanding Cheques$0.00

Adjusted Bank$0.00

Book Balance$0.00

− Bank Charges$0.00

+/− Other$0.00

Adjusted Book$0.00

✓ Reconciled

Common reconciling items in a bank reconciliation

Outstanding cheques or payments recorded in the books but not yet cleared by the bank
Deposits in transit recorded by the business but not yet shown on the bank statement
Bank charges, fees, or interest debited by the bank but not yet entered in the books
Direct debits, standing orders, loan instalments, or merchant charges appearing only on the bank statement
Bookkeeping errors, duplicate entries, or missed cash book postings that need correction

Bank reconciliation checklist

Use the same reconciliation date for the bank statement balance and cash book balance
Tick off matched transactions first before listing reconciling items
Investigate any old outstanding cheques or deposits that remain unresolved
Record missing bank charges, interest, or direct debits in the books before finalising the reconciliation
Do not close the month until the adjusted bank balance matches the adjusted book balance

Tip: if a bank reconciliation does not balance, do not force it to zero. Review old reconciling items, missing bank charges, duplicate entries, and cut-off timing issues until the difference is explained.

Common Mistakes to Avoid

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

Why use this tool?

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.

Frequently Asked Questions

Bank reconciliation is the process of matching the balance in your cash book or accounting records with the balance shown on your bank statement. Any difference is explained through reconciling items such as outstanding cheques, deposits in transit, bank charges, direct debits, interest, or bookkeeping errors.

Related Tools

View all tools

General LedgerMaster record of all accounting transactions Cash FlowTrack every dollar in and out Journal Entry100+ accounting journal entry scenarios, explained and ready to use Trial BalanceVerify your accounting records are balanced Customer StatementAccount summary for your customers AP Aging ReportSee what you owe, how late it is, and what to pay first

Disclaimer: Accountdesq provides this Bank Reconciliation Tool for informational and convenience purposes only. Output is not a substitute for professional accounting, legal, or tax advice. No data entered is transmitted to or stored on our servers - all calculations happen locally in your browser. Accountdesq accepts no liability for errors in generated documents. Always consult a qualified accountant or tax professional for compliance matters.