How to Reconcile Bank Statements: A Step-by-Step Guide

Quick Answer {#quick-answer}

To reconcile a bank statement: compare every transaction in your records against the official bank statement, mark off matching items, identify the remaining differences (outstanding checks, deposits in transit, errors, bank fees, or fraud), and resolve each until both sides balance. Use QuickBankConvert to convert PDF statements to spreadsheets for easier side-by-side comparison.

What Bank Reconciliation Actually Means {#what-is-reconciliation}

Bank reconciliation is the process of comparing two sets of financial records to ensure they agree:

1. Your records: A spreadsheet, check register, personal finance app, or accounting software showing what you believe happened in your account
2. The bank's records: The official statement from your bank showing every transaction that actually cleared

If both sides agree, you are reconciled. If they do not agree, the difference reveals an error, an omission, or potentially fraud that needs investigation.

The concept is simple. The practice requires discipline—and the right tools to make the comparison efficient.

Callout: Many small business owners skip monthly bank reconciliation until they discover a problem. By then, months of discrepancies have accumulated. A one-hour monthly reconciliation prevents multi-day reconstructions and protects against undetected fraud.

Why You Should Reconcile Every Month {#why-reconcile}

For individuals:

• Catch bank errors before the correction window closes (banks typically require disputes within 60 days)
• Detect unauthorized charges early—before they recur
• Identify forgotten subscriptions still being charged
• Keep your personal financial records accurate for budgeting and tax purposes

For small businesses:

• Required by accounting best practices (and often by your accountant)
• Ensures your P&L and balance sheet are accurate
• Detects employee fraud or unauthorized transactions
• Produces reliable financial data for business decisions, loan applications, and tax filings

For both:

• Provides peace of mind that your financial records are trustworthy
• Reduces stress during tax season because records are already clean

Step-by-Step Bank Reconciliation Process {#step-by-step}

Step 1 – Gather Your Materials

You need:

• Your official bank statement for the period (PDF or printed)
• Your internal records (spreadsheet, accounting software, check register, or personal finance app)
• A way to mark items as matched (highlighting, checkmarks, or a "matched" column in your spreadsheet)

If your bank statement is in PDF format, use QuickBankConvert to convert it to a spreadsheet. This makes matching significantly faster—you can use VLOOKUP, conditional formatting, or just sort both lists by amount to spot matches quickly.

Step 2 – Start with the Closing Balance

Write down two balances:

• Bank statement closing balance
• Your records closing balance

If these match exactly, you are likely already reconciled (though you should still verify transactions). If they differ, that difference is your reconciling amount—the total of all discrepancies you need to find and explain.

Step 3 – Match Transactions

Go through each transaction on the bank statement and find the corresponding entry in your records. When they match:

• Mark both as "cleared" or "matched"
• In a spreadsheet, add a checkmark column or change the row color

Work systematically: start with the largest transactions (less likely to be duplicated by coincidence) then move to smaller ones.

Step 4 – Identify Outstanding Items

After matching, any unmatched items fall into categories:

Unmatched items in your records (not on bank statement):

• Outstanding checks: Written but not yet cashed by the recipient
• Deposits in transit: You deposited funds that had not cleared by the statement date
• Recently recorded transactions: Entered in your records after the statement closing date

Unmatched items on bank statement (not in your records):

• Bank fees: Service charges, wire fees, NSF fees you had not recorded
• Interest: Savings account interest you had not entered
• Automatic payments: Subscriptions or direct debits you had not noted
• Errors: Bank errors or your own recording errors
• Unauthorized transactions: Potential fraud

Step 5 – Complete the Reconciliation Formula

Adjusted Bank Balance:

Bank Statement Balance + Deposits in Transit - Outstanding Checks = Adjusted Bank Balance

Adjusted Book Balance:

Your Records Balance + Interest/Credits Not Yet Recorded - Bank Fees Not Yet Recorded ± Corrections = Adjusted Book Balance

If Adjusted Bank Balance = Adjusted Book Balance → Reconciled ✓

Step 6 – Update Your Records

For every item found on the bank statement that was not in your records (bank fees, interest, automatic payments), add those entries to your records so they match going forward.

Step 7 – Investigate Differences

If you cannot reconcile, systematically narrow down the discrepancy:

• Sort transactions by the discrepancy amount—a single missing or doubled transaction often explains the whole difference
• Check for transposition errors (e.g., recording $134 instead of $143)
• Look for a voided check that cleared anyway
• Check if a deposit was posted to the wrong date

Common Reconciliation Discrepancies and How to Fix Them {#common-discrepancies}

Callout: If your reconciliation consistently shows the same unexplained difference, that is usually a single missed transaction from a previous period. Go back one period and check if the discrepancy was already present—you may have missed one entry that has carried forward.

Bank Reconciliation for Small Businesses {#reconciliation-for-business}

For businesses, the statement reconciliation spreadsheet is a formal accounting document, not just a personal check. Here is how the business reconciliation differs:

Use Accounting Software or a Formal Worksheet

Business reconciliations are typically performed in QuickBooks, Xero, Wave, or a formal Excel template. The reconciliation report becomes part of your accounting records and may be reviewed by auditors or lenders.

Reconcile Every Account, Every Month

Businesses should reconcile:

• Operating checking account(s)
• Payroll account
• Petty cash account
• Credit card accounts
• Any account with significant transaction volume

Separate Duties When Possible

In businesses with more than one financial employee, the person who records transactions should not be the same person who reconciles. This separation prevents both fraud and unchecked errors.

Document Outstanding Items

Keep a formal list of outstanding checks, noting the check number, date, payee, and amount. Checks outstanding for more than 6 months should be investigated and possibly voided.

Use QuickBankConvert for Statement Import

When your accounting software struggles to import a particular bank's format, QuickBankConvert can normalize the statement into a clean CSV that imports reliably into any accounting package.

Reconciliation Tools and Methods Compared {#tools-comparison}

The combination of QuickBankConvert for statement normalization plus a well-structured spreadsheet is the most accessible high-accuracy option for individuals and small businesses that are not yet using full accounting software.

Start your first bank statement reconciliation by converting your statement to a clean spreadsheet at QuickBankConvert today.