How Do I Do A Bank Reconciliation

Introduction

Bank reconciliation is the process of matching the cash balance on a company’s books with the balance shown on its bank statement. Now, by performing a bank reconciliation, you can spot errors, detect fraud, and make sure every transaction—deposits, withdrawals, fees, and interest—is accurately recorded. This routine yet critical task protects the integrity of your financial statements and gives you confidence that the money you think you have truly exists. Below is a step‑by‑step guide that walks you through the entire reconciliation cycle, explains the underlying accounting principles, and answers the most common questions newcomers often ask.

Why Bank Reconciliation Matters

Error detection – Mistakes such as double‑posting, omitted entries, or transposition errors become visible when the two balances differ.
Fraud prevention – Unauthorized withdrawals or forged checks are easier to spot when the bank’s records are compared to yours.
Accurate cash flow forecasting – Knowing the real cash position helps you plan payments, investments, and short‑term financing.
Compliance – Many regulatory frameworks (e.g., GAAP, IFRS) require periodic reconciliations as part of internal controls.

Prerequisites: What You Need Before Starting

Bank statement for the period you are reconciling (usually monthly).
Cash ledger or general ledger cash account showing all recorded transactions.
Outstanding checks list (checks issued but not yet cleared).
Deposit slip copies or electronic deposit records.
Access to accounting software (e.g., QuickBooks, Xero) or a manual ledger if you work on paper.

Having these documents at hand prevents interruptions and keeps the workflow smooth.

Step‑by‑Step Bank Reconciliation Process

1. Gather the Documents

Open the latest bank statement and pull the cash‑account ledger for the same period. Ensure both cover the exact same dates (e.That's why g. , 1 May – 31 May).

2. Compare Opening Balances

Bank opening balance (the balance at the start of the statement period).
Book opening balance (the cash‑account balance at the start of the same period).

If they differ, investigate prior‑period reconciliations first; an unresolved discrepancy will cascade forward.

3. Tick Off Cleared Transactions

Go through each line on the bank statement:

Deposits – Locate the corresponding entry in your ledger. Mark it as “cleared” once matched.
Withdrawals/Checks – Find the matching check number or electronic payment in the ledger.

Use a checkmark or a tick column in a spreadsheet to keep a visual record.

4. Identify Outstanding Items

After the tick‑off, you will have two groups of items that remain unmatched:

Outstanding checks – Checks you have recorded but the bank has not yet cleared.
Deposits in transit – Money you have deposited (or received electronically) that the bank has not posted.

List each outstanding item with its amount and date.

5. Adjust for Bank‑Only Transactions

Banks sometimes apply fees, service charges, or interest that your books do not yet reflect. Add these to your ledger:

Bank service fees – Record as an expense (e.g., “Bank Fees”).
Interest earned – Record as income (e.g., “Interest Revenue”).

Conversely, if the bank corrects an error (e.g., a mistaken debit), make the opposite entry in your books.

6. Compute the Adjusted Balances

Adjusted book balance = Book balance + Deposits in transit – Outstanding checks ± Bank adjustments (fees, interest).

Adjusted bank balance = Bank statement balance + Deposits in transit – Outstanding checks ± Bank adjustments.

Both adjusted balances should now be equal. If they are not, re‑examine each step for missed items or arithmetic errors.

7. Document the Reconciliation

Create a reconciliation worksheet that includes:

Opening balances (book & bank).
List of cleared items.
List of outstanding checks and deposits in transit.
Bank fees and interest adjustments.
Final adjusted balances.

Sign and date the worksheet, and retain a copy with the bank statement for audit purposes.

8. Post Adjusting Journal Entries

Enter any necessary adjusting entries into your accounting system:

Want to learn more? We recommend why might you need to know about nail resins and words that starts with av for further reading.

Date	Account	Debit	Credit	Explanation
05/31	Bank Fees Expense	$15		Service fee from bank
05/31	Cash (Bank)	$15		To reflect fee
05/31	Cash (Bank)	$8		Interest earned
05/31	Interest Revenue		$8	To record earned interest

These entries ensure the ledger reflects the true cash position after reconciliation.

9. Review and Approve

If you work in a team, have a supervisor or a second set of eyes review the worksheet and journal entries. An independent review strengthens internal controls and satisfies audit requirements.

10. File and Schedule the Next Reconciliation

Store the completed worksheet, supporting documents, and the bank statement in a dedicated folder (physical or digital). Set a recurring reminder—most businesses reconcile monthly, but high‑transaction accounts may require weekly or even daily reconciliations.

Scientific Explanation: The Accounting Logic Behind Reconciliation

At its core, bank reconciliation rests on the double‑entry accounting principle: every transaction affects at least two accounts, keeping the accounting equation (Assets = Liabilities + Equity) in balance. The cash account is an asset; the bank statement is an external representation of the same asset. Discrepancies arise because of timing differences (e.g., a check written on May 30 may clear on June 2) and non‑cash adjustments (fees, interest).

Debit entries (e.g., cash deposits) are matched with credit entries (e.g., revenue or receivable reductions).
Credit entries (e.g., checks written) are matched with debit entries (e.g., expense or payable reductions).

When the adjusted balances match, the cash asset on the books truly reflects the economic reality reported by the bank, satisfying both accuracy and completeness—two pillars of reliable financial reporting.

Common Pitfalls and How to Avoid Them

Pitfall	Why It Happens	Prevention Tip
Missing deposits in transit	Forgetting to record a cash receipt that hasn't cleared yet.
Manual arithmetic errors	Simple addition/subtraction mistakes. This leads to
Relying on outdated statements	Using a statement that ends before the last transaction date.	Treat the bank statement as a source document; every fee line must be posted.
Duplicate entries	Entering the same check twice in the ledger.	Verify the statement’s closing date matches the reconciliation period.
Overlooking bank fees	Assuming fees are negligible.	Use spreadsheets with built‑in formulas or accounting software that auto‑calculates adjustments.

Frequently Asked Questions (FAQ)

Q1: How often should I perform a bank reconciliation?
A: At a minimum, monthly—the same frequency most banks issue statements. High‑volume accounts may require weekly or daily reconciliations to catch errors early.

Q2: What if the adjusted balances still don’t match after following all steps?
A: Re‑examine every transaction for transposition errors, missed deposits, or unrecorded fees. Consider contacting the bank for clarification on any ambiguous entries.

Q3: Can I reconcile multiple bank accounts together?
A: Yes, but each account should have its own reconciliation worksheet. Consolidating them later is possible for cash‑flow analysis, but individual reconciliations maintain audit integrity.

Q4: Is bank reconciliation required for cash‑on‑hand (petty cash)?
A: Not in the same way. Petty cash is usually reconciled by counting physical cash against a petty‑cash log, while bank reconciliation applies to bank‑deposited cash.

Q5: How does electronic banking affect the process?
A: Online banking provides real‑time transaction data, reducing the lag between recording and clearing. Still, you still need to reconcile because fees, ACH reversals, and timing differences still occur.

Tools and Templates

Spreadsheets: Excel or Google Sheets with pre‑built formulas for totals, differences, and running balances.
Accounting software: Most platforms (QuickBooks, Xero, Sage) have a built‑in reconciliation module that automatically flags unmatched items.
Mobile apps: Some banks offer transaction export features (CSV) that can be imported directly into your ledger.

Choose the tool that matches your business size and complexity. For small businesses, a well‑structured spreadsheet is often sufficient; larger enterprises benefit from integrated software that reduces manual effort.

Conclusion

A bank reconciliation is more than a bookkeeping chore; it is a vital control that safeguards your organization’s cash integrity, uncovers errors, and deters fraud. By systematically gathering documents, ticking off cleared items, identifying outstanding transactions, adjusting for bank‑only entries, and documenting every step, you create a transparent audit trail that stands up to scrutiny.

Implement the step‑by‑step workflow outlined above, put to work appropriate tools, and schedule regular reconciliations to keep your cash records crystal clear. Over time, this disciplined habit will not only keep your books accurate but also empower you with reliable financial insight—essential for sound decision‑making and long‑term business success.