How to Do Reconciliation in QuickBooks (Step by Step)

It is the third of the month. Your bank statement is open in one tab, QuickBooks in another, and the Difference field is stuck at $214.60 instead of $0.00. You scroll the register looking for the phantom transaction, find a deposit from six weeks ago that someone edited after it was already reconciled, and now the whole period is off. An hour disappears before you have even started on the credit card account.

Reconciliation in QuickBooks is not hard. It is matching what your bank says happened against what your books say happened, one transaction at a time, until the two agree. The pain is almost never the button-clicking. It is the messy data underneath: duplicate entries, missing deposits, a transaction changed after the fact. Clear that up and the monthly match closes in a few minutes instead of eating an hour.

What reconciliation actually checks

Reconciliation confirms that every transaction in your QuickBooks register matches a real line on your bank or credit card statement, and that nothing is missing or invented on either side. When the two agree to the penny, your books reflect reality and you can trust every report built on top of them.

The math QuickBooks runs is simple. It takes your beginning balance, adds the transactions you check off, and compares the result to the ending balance you typed in from your statement. When those match, the Difference reads $0.00 and you can finish. When they do not, something is wrong: a transaction is entered twice, a payment never got recorded, or an amount was fudged.

Every QuickBooks Online plan includes reconciliation, from Simple Start at $38 per month up through Advanced at $275 per month, per Intuit's pricing page. You do not need a premium tier to reconcile. You need clean data going in, which is where most teams lose the hour.

Line up three things before you open Reconcile

Do not start a reconciliation without these ready. Starting blind is how you get halfway through, realize the beginning balance is wrong, and back out.

• Your bank statement for the period. You need the ending balance and the statement ending date. QuickBooks matches against those two numbers, so the statement is the source of truth, not your online banking balance today.
• A confirmed beginning balance. The beginning balance in QuickBooks should equal last period's ending balance. If it does not, a prior reconciliation was changed, and you fix that before this one.
• Your bank feed already imported and categorized. If transactions are still sitting in the For Review tab of the banking screen, add them first. Reconciling against a half-imported month guarantees a nonzero difference.

Once those three are set, the reconciliation itself takes a few minutes on a clean month.

Where the Reconcile tool lives in QuickBooks Online

Open Reconcile from the Accounting section. Intuit's support article on reconciling an account puts it under All apps, then Accounting, then Reconcile. Some layouts still reach it through the gear icon under Tools, then Reconcile. Either path lands you in the same place.

If this is your first reconciliation in the account, QuickBooks shows a Get started prompt. Click through it once and you will not see it again.

Reconcile a bank account, step by step

Here is the full flow, following Intuit's documented steps.

1. Go to Accounting, then Reconcile. Select Get started if it is your first time.
2. Choose the account from the Account dropdown: a checking, savings, or credit card account.
3. Check the Last statement ending date QuickBooks shows. Your new statement should start the day after that date. A gap or overlap means a period was skipped or duplicated.
4. Enter the Ending balance and Ending date exactly as they appear on your bank statement.
5. Select Start reconciling.
6. In the reconciliation window, compare each transaction in QuickBooks against your statement. Check the box next to every transaction that matches a line on the statement.
7. Watch the Difference field at the top as you go. Every box you check moves it. Your goal is $0.00.
8. When the Difference reads $0.00, select Finish now, then Done.

Once you finish, QuickBooks marks each reconciled transaction with an R in the cleared column of the register, per Intuit's reconcile workflow guide. That R is your record that the transaction was matched and locked. Do not touch reconciled transactions afterward, because editing one is the single most common way to break next month's beginning balance.

A note on the AI-assisted upload

On some plans QuickBooks now lets you upload the bank statement PDF and it pre-matches transactions for you before you start. It speeds up a clean month. It does not fix bad data, and you still review every match. Treat it as a head start, not a substitute for looking.

When the difference won't go to zero

This is where the hour goes. A nonzero Difference means QuickBooks and your statement disagree, the same hunt behind a bank statement that will not match QuickBooks, and the cause is almost always one of a short list.

• A duplicate transaction. The bank feed imported a charge and someone also entered it manually. You have two, the statement has one.
• A missing transaction. A deposit, fee, or transfer on the statement was never recorded in QuickBooks. Add it.
• A wrong amount. A transaction was entered as $145 when the statement says $154. Transposed digits are common.
• A transaction dated in the wrong period. It belongs to this statement but was entered with next month's date, or the reverse.
• An edited past transaction. Something already reconciled got changed, which throws off the beginning balance before you even start.

For that last one, QuickBooks has a specific tool. The Reconciliation Discrepancy Report shows every transaction that was changed after it had already been reconciled, along with the Change Type and the transaction history, per Intuit's support article on fixing past reconciliations. If your beginning balance is wrong, open that report first. It points straight at what moved.

A practical rule: if the Difference is a round-ish number, look for a single missing or duplicate transaction of that amount. If it is an odd number, suspect a wrong amount or a transposition. Do not force a reconciliation to close with a fake adjustment entry. That hides the error and it compounds.

How to fix a reconciliation you already closed

Sometimes you finish, then discover a transaction was wrong. What you can undo depends on your access level.

You cannot edit a completed reconciliation in place. Intuit's guidance is to either correct the underlying transactions or undo the reconciliation and run it again. A full undo of an entire reconciliation period is available only in QuickBooks Online Accountant, through Accounting, then Reconcile, then History by account, then Undo, per Intuit's article on undoing reconciliations.

Regular QuickBooks Online users have a narrower option. You can unreconcile an individual transaction from the account register by clearing its R status, which removes just that one from the reconciliation. It does not roll back the whole period. If you need a full undo and do not have accountant access, that is what your bookkeeper or accountant does from their QuickBooks Online Accountant login, following the step-by-step undo in QuickBooks Online.

The real problem reconciliation exposes

If reconciliation takes you an hour every month, the reconciliation is not the problem. The data feeding it is. Duplicates, missing deposits, and mis-dated transactions do not appear by magic. They come from the seams between your tools: a payment processor that does not sync cleanly, a Shopify or Stripe payout that lands as one lump sum against a dozen orders, a manual export someone re-keys and fat-fingers. When the truth is spread across a processor, a store, and your books, closing the month is really multi-system reconciliation.

QuickBooks reconciles what is in the register. It has no opinion about whether the register got populated correctly. So the same team reconciles the same messy account every month, and the discrepancy report keeps surfacing the same class of error, because nobody fixed the pipe that fills the register. This is the difference between account reconciliation software that matches records for you and the underlying integrations that keep those records clean in the first place.

Two examples that show up constantly:

• Payout aggregation. Stripe or Shopify deposits a single payout covering many orders, minus fees. QuickBooks sees one deposit, your sales records show many. Reconciliation turns into manual math every month. The fix is a clean feed that splits the payout into its parts automatically, which is exactly what a proper Shopify and QuickBooks integration that reconciles is supposed to do.
• Duplicate entry from two sources. The bank feed and a manual import both create the same transaction. The fix is deciding on one source of truth per account and shutting off the other, then de-duplicating what is already there.

When to build the fix vs keep reconciling by hand

If you reconcile two or three low-volume accounts and the difference lands at $0.00 most months, keep doing it by hand. It is 20 minutes and it does not justify a build. Reconciliation is a control, and a human eyeing the statement monthly is a good control.

The math changes when the same discrepancy returns every month, when payout aggregation forces manual splitting, or when volume climbs past the point where a person can eyeball it. That is when bottta is worth a call. We are an automation studio, and this is squarely our Integrations work: building the clean data feed between your payment processors, your sales tools, and QuickBooks so the register fills correctly and the monthly match actually closes to zero. Where matching logic gets genuinely fuzzy, our AI Automation work handles the extraction and reconciliation rules a plain Zap cannot.

Two ways to work with us. The $4K project is a fixed-scope build: we map the feed, wire the integration, split the payouts, de-duplicate the account, and hand it back with 30 days of post-launch support. The $3K per month retainer fits teams who want us to own the feeds across up to three active workflows, monitor them, and fix them when a vendor changes an API or a new edge case appears. Neither is a self-serve button. We design and build the thing, then it runs. The test is simple: if the same discrepancy shows up month after month, the register is being filled wrong, and that is a pipe worth fixing once. Book a call with bottta when you are ready to stop hunting it.

DIY tools have a place here. Zapier or Make can move a transaction from one app to another, and for a simple one-to-one sync they are fine. They struggle with the messy parts of reconciliation: splitting an aggregated payout, matching many-to-one, handling the exceptions that actually cause discrepancies. If you have tried to build that in Zapier and hit a wall, you already know where it ends. For the deeper picture on what to automate and what to leave alone, see our guide on accounting automation software and the broader case for automating financial reporting without breaking it.

Frequently asked questions

How long should reconciliation take in QuickBooks?

On a clean account with an accurate bank feed and no discrepancies, a single account reconciles in a few minutes. If it routinely takes an hour, the time is going into hunting discrepancies, not the reconciliation itself, and that points at a data-feed problem worth fixing at the source.

What if my beginning balance is wrong before I even start?

A wrong beginning balance means a previously reconciled transaction was changed or deleted. Open the Reconciliation Discrepancy Report, which lists exactly what changed after it was reconciled, fix or restore those transactions, and your beginning balance falls back into place.

Can I undo a reconciliation in QuickBooks Online?

A full undo of an entire period is available only in QuickBooks Online Accountant, under Accounting, Reconcile, History by account, Undo. Regular QuickBooks Online users can unreconcile individual transactions from the register but cannot roll back a whole period, so a full undo usually runs through your accountant's login.

Is reconciliation different in QuickBooks Desktop?

The purpose is identical: match your register to your statement until the difference is zero. The workflow lives in the desktop app's own reconcile window rather than the browser, and Desktop offers an Undo Last Reconciliation option that QuickBooks Online restricts to accountant access. If you are choosing between them, the reconciliation experience alone is not a strong reason to pick one over the other.

Should I automate reconciliation entirely?

Automate the data feed, not the human judgment. Building integrations that fill the register correctly removes most discrepancies before they happen. Keeping a person to review the monthly match stays a healthy control. The goal is a reconciliation that closes to $0.00 on the first pass because the underlying data is clean, not a black box that hides errors. That split is the core of how we think about reconciliation as a data problem.