General Ledger + Converter in one subscription.

See pricing
Skip to content
  1. Home
  2. AI bookkeeping
  3. QuickBooks bank reconciliation automation

GUIDE · QUICKBOOKS RECONCILIATION

Automating bank reconciliation in QuickBooks Online:
what it does for you, and what you still check.

QuickBooks Online automates the work before a reconciliation: bank rules can post lines, it suggests matches, and on Plus and Advanced its AI reads an uploaded statement and flags problems. You still enter or confirm the ending balance, tick off items and decide on differences. With AI bookkeeping in ZeraBooks, reconciliation checks each month against the statement on upload.

7-day trial · card required, nothing charged for 7 days · then $79/month billed annually or $149 monthly

Tied, signed off and closed.

WHAT IT AUTOMATES

What does QuickBooks Online automate in bank reconciliation?

Five features, each from Intuit’s own help pages, checked October 22, 2026. Most act on transactions before you open Reconcile; one works inside it.

FeatureWhat it doesPlansLimits
Bank rulesCategorize lines that match conditions on description, bank text or amountEvery plan Intuit lists, Simple Start to AdvancedUp to 5 conditions a rule and 2,000 rules; one rule per transaction, top of the list wins
Auto-post on a rulePosts matching lines with no review, when you sign in, upload a file or change the ruleSame as bank rulesIntuit warns to use it with caution; a wrong rule posts wrong lines
Suggested matchesOffers an existing invoice, bill, check or receipt with the same amountPart of Bank transactionsOnly 90 days before to 20 days after; none when a fee changes the amount or deposits were grouped
Ready to post and Auto-post (Accounting AI)Groups lines the AI is confident about for one-click posting; auto-posts some Intuit payroll and Bill Pay itemsEssentials, Plus, Advanced, Intuit Enterprise SuiteAuto-post covers only Intuit payroll paychecks and taxes and Bill Pay matches
AI-powered reconciliationReads an uploaded statement, fills in the ending balance and date, marks lines Cleared or For review and suggests fixesPlus, Advanced, Intuit Enterprise SuiteVerifying a statement can take up to an hour

None of these finishes the reconciliation for you. Rules and matches decide what is in the register; reconciling still means agreeing the register to the bank’s printed ending balance and selecting Finish now.

We set you up and catch up your past months for free. Then ZeraBooks keeps your books done.

WHAT STAYS MANUAL

What do you still do by hand in a QuickBooks reconciliation?

The judgment calls. Each one is a place where automation can’t know the answer from the bank line alone.

  • The ending balance

    You type the statement’s ending balance and date, or check the ones AI-powered reconciliation filled in from your upload. A wrong figure here makes every later step wrong.

  • Grouped deposits and fees

    A deposit of three customer payments, or a card payout with fees taken off, has no single matching record, so no match is suggested. You split it or record the fee.

  • Transfers and card payments

    Intuit’s matching article says these aren’t suggested the same way; you choose the account in the Category dropdown.

  • Checking the rules

    An auto-posted line never passes through For review. Someone has to look at the Posted tab now and then, especially after adding a rule.

  • Differences

    When Difference isn’t $0.00 you find the cause. QuickBooks can post an adjustment for the remaining amount, but Intuit suggests talking to your accountant first.

  • Outstanding items

    Checks not yet cleared and deposits in transit stay unticked and carry into next month. Old ones need following up, not ignoring.

WORKED EXAMPLE

How much of a month does QuickBooks automation handle?

Ridgeback Landscaping is a fictional landscaping company on QuickBooks Online Plus with a bank feed. Its June 2026 checking statement (ending 3307) has 46 lines. How they got into the register:

How the line was handledLinesExamples
Posted by bank rules (auto-post on)31Fuel cards, equipment lease, phone, software, loan payment
Suggested match accepted9Customer invoice payments, two supplier bills
Auto-matched by Intuit payroll4Two payroll runs and their tax payments
Handled by hand2A grouped deposit split across two invoices; a 45.00 service charge
Total statement lines46

31 + 9 + 4 + 2 = 46. Automation placed 44 of the 46 lines, but the two left over are the ones that decide whether the month ties, which is the pattern most months follow.

THE RECONCILIATION

What does a QuickBooks reconciliation that ties look like?

Ridgeback’s June reconciliation, as the Reconcile screen builds it. The beginning balance is May’s statement ending balance.

LineBefore the feeAfter the fee
Beginning balance24,610.2524,610.25
Deposits cleared18,420.0018,420.00
Payments cleared−15,600.35−15,645.35
Cleared balance27,429.9027,384.90
Statement ending balance27,384.9027,384.90
Difference−45.000.00

The −45.00 difference was exactly the service charge on the statement that no rule covered. Entering it brought payments cleared to 15,645.35 and the difference to 0.00. Check 2207 for 1,320.00 and a 2,150.00 deposit on June 30 aren’t on the statement, so they stay unticked: the register shows 27,384.90 − 1,320.00 + 2,150.00 = 28,214.90. Every reconciling item is explained in how to do a bank reconciliation.

STEP BY STEP

How do you reconcile in QuickBooks Online with the automation on?

Menu names from Intuit’s reconcile article, updated August 5, 2026.

  1. 1

    Clear For review first

    In Bank transactions, post Ready to post items, accept or correct suggested matches, and glance at what rules auto-posted on the Posted tab.

  2. 2

    Open Reconcile

    Go to All apps, then Accounting, then Reconcile, and choose the account. Check the Last statement ending date; the new statement should start the next day.

  3. 3

    Enter or upload the statement

    Type the Ending balance and Ending date. On Plus or Advanced you can upload the statement instead and let AI-powered reconciliation fill them in once its status reads Extraction completed.

  4. 4

    Start reconciling

    Select Start reconciling and tick each item that appears on the statement. With a statement uploaded, lines show as Cleared or For review, and the sparkle icon explains a For review line.

  5. 5

    Work the difference to zero

    If Difference isn’t $0.00, look for a missing fee or interest line, a doubled transaction or a wrong ending balance. Use Edit info to fix the balance or date.

  6. 6

    Finish and keep the report

    Select Finish now, then Done. The reconciliation report is saved under History by account on the Reconcile page.

IN ZERABOOKS

How ZeraBooks reconciles without the tick-off.

ZeraBooks is a different ledger, not a QuickBooks add-on. It has no bank feed and no QuickBooks connection, so it reconciles from the statements you upload.

ON UPLOAD

Each month checked against the printed balances.

When a statement lands, ZeraBooks checks three things: the statement adds up from its opening to its closing balance, its opening balance meets the last statement’s closing, and the ledger agrees with the closing balance. A month that passes ties; one that doesn’t is flagged with the reason. The concepts are in the general ledger guide.

How reconciliation works
The Reconciliations timeline: one row per account and one dot per month, showing months that tie, months that need a look, coverage gaps and finalized months.

WHEN IT DOESN’T TIE

AI re-reads the statement and proposes the fix.

Verify against the document reads the original statement line by line and proposes only fixes that make it tie, each quoting the line it relies on, such as a missed line or a flipped sign. You apply them, then sign off and close the month. The AI never does the arithmetic; the ledger does.

Verify a statement with AI
AI verification re-reads the statement and proposes only the fixes that make it tie, each quoting the line from the document.

QUESTIONS

QuickBooks bank reconciliation automation: common questions

Ask Damin directly
Can QuickBooks Online reconcile automatically?

Not end to end. It can post lines with rules, suggest matches and, on Plus and Advanced, read an uploaded statement and mark lines Cleared or For review. You still confirm the ending balance, settle anything For review and select Finish now. The manual steps are in how to reconcile a bank account in QuickBooks Online.

Which QuickBooks Online plan has AI-powered reconciliation?

Intuit lists it for QuickBooks Online Plus, Advanced and Intuit Enterprise Suite, as of its help page updated October 9, 2026. Essentials gets other Accounting AI features, such as Ready to post, but not this one.

Are auto-posted bank rules safe to use?

For lines that never vary, like a fixed lease payment to one payee, they save time. Because auto-posted lines skip For review, a rule with loose conditions can post the wrong category for months. Check the Posted tab after adding one. Setting rules up is covered in QuickBooks bank categorization rules.

Why doesn’t QuickBooks suggest a match for a deposit?

Intuit lists the reasons: the amount differs because of fees or discounts, several payments went in as one deposit, the record is outside 90 days before to 20 days after, or it is already reconciled.

What if my QuickBooks reconciliation is off by a small amount?

Look for that exact amount on the statement first; a missing fee or interest line is the usual cause. A difference divisible by 9 often means two digits were swapped. To reverse a finished reconciliation, see how to undo a bank reconciliation.

Does ZeraBooks work with QuickBooks?

ZeraBooks doesn’t connect to or sync with QuickBooks. The Converter turns a PDF statement into a QuickBooks-ready CSV you upload yourself (PDF to QuickBooks), and the ZeraBooks ledger is its own set of books that reconciles from uploaded statements, $79 a month billed annually or $149 monthly after a 7-day trial; see ZeraBooks pricing.

Damin Mutti, founder of ZeraBooks

About the author

Damin Mutti

Founder of ZeraBooks, Vancouver

Damin founded ZeraBooks in 2025 and still talks to the bookkeepers, firms and owners who use it every week. He writes about what he sees in their statements and ledgers, and every page here is checked against the live product before it goes up.

FREE SETUP + CATCH-UP

Upload one statement and watch the month tie.
No ticking off.

ZeraBooks checks each month against the bank’s printed balances as statements land. Free for 7 days, then $79 a month billed annually. Or have our bookkeeping services team do every reconciliation for you.

Book a call with Damin

Our founder. 30 minutes on Google Meet. Pick a time on the next screen.

About: Have us do your books