Skip to main content

Guide · 8 min read · November 21, 2026

How to do a bank reconciliation, step by step

A bank reconciliation is the check that tells you your books match reality. If it isn't done every month, every report built on top of it, from the P&L to cash runway, rests on numbers nobody has proven. This guide walks small business owners and finance leads through how to do a bank reconciliation step by step, with a worked example and a checklist for when the numbers won't tie.

What's inside

  • · What a bank reconciliation proves and the items that cause differences
  • · What to gather before you start
  • · The step-by-step procedure
  • · A worked example with real numbers
  • · Reconciling in QuickBooks Online and fixing a difference that won't clear

What a bank reconciliation proves

A bank reconciliation compares two records of the same cash: the balance on your bank statement and the balance of that bank account in your general ledger. They rarely match on their own, because the bank and your books record transactions at different times. The goal is to explain every dollar of the gap, so that both sides arrive at the same adjusted balance.

When they agree, you know three things: every transaction in the bank is in your books, nothing in your books is missing from or contradicted by the bank, and the cash figure on your balance sheet is real. Almost every difference falls into one of four groups.

Deposits in transit

Money you recorded and deposited near month end that the bank hadn't posted by the statement date. It adds to the bank side.

Outstanding checks and payments

Checks and payments you recorded that haven't cleared the bank yet. They reduce the bank side.

Bank-only activity

Service fees, interest, returned deposits and automatic debits that appear on the statement but not yet in your books. These need entries in your books.

Errors

Amounts keyed wrong, transactions recorded twice or posted to the wrong account. Most are yours, but banks make mistakes too, so check both sides.

What to gather before you start

A reconciliation goes quickly when the inputs are ready. Before you open the reconcile screen, pull together:

  • The bank statement for the period, with its beginning balance, ending balance and statement end date
  • Last month's completed reconciliation, including its list of outstanding checks and deposits in transit
  • A ledger that is up to date for the period: every bank-feed transaction reviewed and categorized, and every check, deposit and transfer you know about entered
  • Deposit details and check registers for anything you can't identify from the statement description alone
  • Statements for any account that sends or receives transfers from this one, such as savings, a credit card or a payment processor

Reconcile accounts in order, one month at a time. Starting with October when September was never finished means carrying September's unexplained differences forward, where they get harder to trace.

How to do a bank reconciliation, step by step

  1. 01

    Confirm the beginning balance

    The statement's beginning balance should equal the ending balance of last month's reconciliation. If it doesn't, stop and find out why. Someone may have edited or deleted a transaction in a period that was already reconciled.

  2. 02

    Tick off deposits

    Match each deposit on the statement to a deposit in your books, by amount and date. Mark each one as cleared.

  3. 03

    Tick off checks and withdrawals

    Do the same for every check, card charge, ACH payment, wire and transfer out. Match check numbers, not just amounts, since two checks can share a total.

  4. 04

    List what's left on the bank side

    Anything in your books that isn't on the statement is a deposit in transit or an outstanding payment. Add deposits in transit to the statement balance and subtract outstanding payments.

  5. 05

    List what's left on the book side

    Anything on the statement that isn't in your books, such as fees, interest or a returned deposit, needs a journal entry or a transaction in your accounting system. Errors you found get corrected the same way.

  6. 06

    Compare the adjusted balances

    The adjusted bank balance and the adjusted book balance must be equal to the cent. If they are, the account is reconciled.

  7. 07

    Save the report and review it

    Keep the reconciliation report with the statement. A second person should glance at it each month, paying attention to any item that is outstanding for longer than usual.

A worked example with numbers

Say a small agency is reconciling its operating account for October. The bank statement shows an ending balance of $48,250.00. The general ledger shows $49,239.00. After ticking off every matched item, this is what remains.

ItemBank sideBook side
Starting balance$48,250.00 (statement)$49,239.00 (ledger)
Client deposit made October 31, not yet posted+ $3,400.00None
Outstanding checks #1042 ($1,850) and #1045 ($620)− $2,470.00None
Monthly service fee not yet recordedNone− $35.00
Interest earned not yet recordedNone+ $12.00
Check #1039 entered as $415, cleared at $451None− $36.00
Adjusted balance$49,180.00$49,180.00

Both sides land on $49,180.00, so the account is reconciled. Only the book-side items need entries: record the $35 fee as bank charges, the $12 as interest income and a $36 correction to check #1039. The bank-side items need nothing. They will clear on November's statement, and if they don't, they become questions.

Reconciling in QuickBooks Online

QuickBooks Online follows the same logic and does the arithmetic for you. According to Intuit's guide to reconciling an account in QuickBooks Online, the flow is:

  1. 01

    Open Reconcile

    Open the Reconcile page (from Settings, or from All apps, then Accounting, depending on your layout) and choose the bank account from the Account dropdown.

  2. 02

    Enter the statement details

    Check the last statement ending date, then enter the ending balance and ending date from the new statement and select Start reconciling.

  3. 03

    Check off cleared transactions

    Tick each transaction that appears on the statement. Leave anything that isn't on it unchecked. Those are your outstanding items.

  4. 04

    Finish at a $0.00 difference

    When the Difference reads $0.00, select Finish now. QuickBooks saves a reconciliation report, which you can find later under History by account on the Reconcile page.

Matching transactions in the bank feed is not the same as reconciling. Bank-feed matching gets transactions into your books. Reconciling proves the account balance against the statement and locks in what has cleared.

When it won't balance: a troubleshooting checklist

  • Check the statement ending balance and date you entered. A mistyped figure is the most common cause.
  • Compare the beginning balance with last month's reconciled ending balance. A mismatch points to a change in an earlier period.
  • Look for a single transaction equal to the difference, or to half of it. Half the difference often means a deposit was entered as a payment, or the reverse.
  • If the difference divides evenly by 9, look for transposed digits.
  • Search for duplicates, especially transactions entered by hand and then imported from the bank feed.
  • Make sure no transfer was recorded in only one of the two accounts it moved between.
  • Review checks outstanding for more than a few months. Under section 4-404 of the Uniform Commercial Code, a bank isn't obligated to pay an uncertified check presented more than six months after its date, though it may still pay one in good faith. Contact the payee before deciding how to handle it.

Make it a monthly habit

Reconcile every bank and credit card account within the first few business days after each statement closes. It's the first task in a good month-end close, because accruals, reports and variance reviews all assume cash is right. Keep each statement and its reconciliation report together. The IRS guidance on how long to keep records says to keep records supporting a return for at least three years in most cases, and longer in some situations, such as four years for employment tax records.

If reconciliations keep slipping, hand them off. Finendra's reconciliation service covers every bank and credit card account on a fixed monthly cadence with documented variances, and monthly bank and card reconciliations are part of every bookkeeping plan.

Frequently asked questions

How often should I do a bank reconciliation?
At least monthly, as soon as each statement is available. Businesses with heavy transaction volume or tight cash can reconcile weekly so problems surface sooner.
What's the difference between a deposit in transit and an outstanding check?
A deposit in transit is money you've recorded that the bank hasn't posted yet, so it increases the bank-side balance. An outstanding check is a payment you've recorded that hasn't cleared, so it reduces the bank-side balance.
Do I need to reconcile credit card accounts too?
Yes. A credit card account is reconciled the same way, against the card statement's ending balance. Unreconciled cards are a common source of missing expenses and duplicate entries.
Can I just rely on my bank feed instead of reconciling?
No. A bank feed imports transactions, but it can miss, duplicate or misdate them, and it can't catch an edit made to a past period. Reconciling against the statement is what proves the balance.

Are your bank accounts reconciled through last month?

Book a short call and we'll look at where your reconciliations stand and what it would take to keep them current every month.