...
(305) 515-3559 info@jcbsolutionsinc.net

How to Reconcile Bank Accounts in QuickBooks Each Month

6 min readJCB Solutions MiamiDoral, FL

Quick answer: To reconcile bank accounts in QuickBooks Online, go to All apps, then Accounting, then Reconcile, pick the account, and enter the ending balance and ending date from your bank statement. Check off each transaction that appears on the statement until the Difference shows $0.00, then select Finish now. Do it every month, as soon as each statement arrives.

Your bank balance and your books should tell the same story. When you reconcile bank accounts in QuickBooks, you confirm that every deposit, payment and fee in your records matches what the bank actually processed. It is one of the simplest habits that keeps a small business’s numbers trustworthy.

Skipping it for a few months is common, and that is when problems pile up: duplicate entries, missing deposits, forgotten bank fees and a profit figure nobody believes. This guide explains how to reconcile bank accounts in QuickBooks every month, the exact steps in QuickBooks Online, and what to do when the numbers will not match.

Small business owner comparing a bank statement with a laptop screen to reconcile bank accounts in QuickBooks
A monthly reconciliation compares your bank statement line by line with what is recorded in QuickBooks.

Why you should reconcile bank accounts in QuickBooks monthly

Reconciliation is your early warning system. Catching an error a few weeks after it happens is far easier than unwinding it at tax time. Regular reconciliations help you:

  • Spot duplicate or missing transactions before they distort your reports.
  • Catch bank fees, interest and automatic payments you did not record.
  • Notice unauthorized or unusual charges quickly.
  • Produce a profit and loss statement and balance sheet you can rely on for decisions, loans and tax returns.

Intuit itself recommends that you reconcile bank accounts in QuickBooks each month, after you receive each statement. Treat it as a fixed date on your calendar, just like payroll.

Before you start: get your books ready

It is much faster to reconcile bank accounts in QuickBooks when the groundwork is done. Before you open the reconcile screen, take care of these items:

  1. Have the statement in hand. Download the bank or credit card statement for the period you are reconciling.
  2. Enter and categorize every transaction for that period, including checks, deposits, transfers and card charges.
  3. Clear your bank feed. If your account is connected, review the downloaded transactions and match or add them first. Matched transactions already show as cleared.
  4. Work in date order. Your statement should begin the day after the last statement ending date shown in QuickBooks. If you are catching up, reconcile one statement at a time, starting with the oldest.
Organized folders holding monthly bank statements, ready to reconcile bank accounts in QuickBooks
Keeping each month’s statement in its own folder makes it easy to reconcile in date order.

How to reconcile bank accounts in QuickBooks Online, step by step

These steps follow Intuit’s current instructions for QuickBooks Online in the United States. Menu names can change as Intuit updates the software, so check Intuit’s reconciliation help article if your screen looks different.

  1. Go to All apps, then Accounting, then Reconcile. If this is your first reconciliation, select Get started.
  2. Choose the bank or card account from the Account dropdown.
  3. Confirm the Last statement ending date so you know which statement comes next.
  4. Enter the Ending balance and Ending date exactly as they appear on your statement.
  5. Select Start reconciling.
  6. Compare the list with your statement and check the box next to each transaction that appears on it. Leave anything that has not cleared the bank unchecked.
  7. Keep going until the Difference reads $0.00. If you typed the balance or date incorrectly, select Edit info to fix it.
  8. When the Difference is $0.00, select Finish now, then Done.

QuickBooks saves a reconciliation report each time you reconcile bank accounts in QuickBooks Online. You can review past reports from the Reconcile page under History by account, which is useful when your accountant or lender asks for proof that the books were reconciled.

When the difference will not reach zero

Almost everyone who tries to reconcile bank accounts in QuickBooks runs into a stubborn difference at some point. Work through these common causes in order:

Possible cause What to check
Typo in ending balance or date Use Edit info and compare with the statement.
Missing transaction Look for statement items with no match in QuickBooks, such as bank fees or interest, and add them.
Duplicate entry A transaction entered by hand and also added from the bank feed often appears twice.
Transposed amount If the difference divides evenly by 9, two digits may be swapped (for example, 54 entered as 45).
Changed beginning balance If a previously reconciled transaction was edited or deleted, QuickBooks may alert you to a discrepancy. Its Reconcile Discrepancy Report helps you find what changed.

Resist the urge to force the balance with an adjustment just to finish. The goal when you reconcile bank accounts in QuickBooks is to find the real cause, not to make the screen say zero. An unexplained adjustment hides the real problem and usually resurfaces later.

Make reconciliation part of a monthly routine

Open ledger book with a calculator and a laptop on a desk during a month-end close
Reconciliation is one part of a short month-end close that keeps reports reliable.

Reconciling is most effective as part of a short month-end close. A simple routine might look like this:

  • Reconcile bank accounts in QuickBooks, plus every credit card and loan account.
  • Review uncategorized transactions and correct miscoded expenses.
  • Run the profit and loss statement and balance sheet and look for anything unusual.
  • Save statements and reconciliation reports in an organized folder.

Good records also matter for taxes, and the reports you save when you reconcile bank accounts in QuickBooks are part of them. The IRS generally tells businesses to keep records for 3 years, with longer periods in certain situations, and to keep employment tax records for at least 4 years after the tax is due or paid, whichever is later. See the IRS page on how long to keep records for the full rules. For a broader view of what to review every few months, see our quarterly bookkeeping checklist for Miami small businesses.

Need help with QuickBooks?

If you are months behind, or you tried to reconcile bank accounts in QuickBooks and the opening balances never matched, it may be time for a cleanup. Our QuickBooks services, which include remote access to QuickBooks, help you get your file in order, and our bookkeeping work includes general ledger cleanup. For ongoing support, our accounting services cover monthly financial statements and account reconciliations for small businesses in Miami-Dade.

Frequently Asked Questions

How often should I reconcile bank accounts in QuickBooks?

Monthly is the standard. Intuit recommends reconciling after you receive each statement, which keeps errors small and easy to find.

Where is the reconcile option in QuickBooks Online?

In the current US version of QuickBooks Online, go to All apps, then Accounting, then Reconcile. Intuit updates the interface from time to time, so the path may vary slightly.

What does it mean when the difference is not $0.00?

It means the transactions you checked do not add up to the statement balance. Common causes are a typo in the ending balance, a missing bank fee, a duplicate entry or a transaction edited after an earlier reconciliation.

Can I reconcile several months at once?

Reconcile one statement at a time, in date order, starting with the oldest. Each new statement should begin the day after the last statement ending date in QuickBooks.

Can JCB Solutions reconcile my accounts for me?

Yes. JCB Solutions offers monthly or quarterly bookkeeping and QuickBooks services, including bank reconciliations and cleanup of past months, in English and Spanish.

Behind on your QuickBooks reconciliations? Our team in Doral can help you catch up and keep your books accurate every month.

Call 1 (866) 296-1833, email info@jcbsolutionsinc.net or contact us.

Small business in Miami?

Keep your books and taxes in order

Bookkeeping, payroll, QuickBooks and tax preparation from our office in Doral.

Contact us 1 (866) 296-1833
Opening a company in the U.S.?

Start with the right structure

Business incorporation in Florida for residents and foreign entrepreneurs, in English and Spanish.

Incorporate now

← See all guides

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.