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.
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.
Feature
What it does
Plans
Limits
Bank rules
Categorize lines that match conditions on description, bank text or amount
Every plan Intuit lists, Simple Start to Advanced
Up to 5 conditions a rule and 2,000 rules; one rule per transaction, top of the list wins
Auto-post on a rule
Posts matching lines with no review, when you sign in, upload a file or change the rule
Same as bank rules
Intuit warns to use it with caution; a wrong rule posts wrong lines
Suggested matches
Offers an existing invoice, bill, check or receipt with the same amount
Part of Bank transactions
Only 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 items
Essentials, Plus, Advanced, Intuit Enterprise Suite
Auto-post covers only Intuit payroll paychecks and taxes and Bill Pay matches
AI-powered reconciliation
Reads an uploaded statement, fills in the ending balance and date, marks lines Cleared or For review and suggests fixes
Plus, Advanced, Intuit Enterprise Suite
Verifying 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 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:
A grouped deposit split across two invoices; a 45.00 service charge
Total statement lines
46
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.
Line
Before the fee
After the fee
Beginning balance
24,610.25
24,610.25
Deposits cleared
18,420.00
18,420.00
Payments cleared
−15,600.35
−15,645.35
Cleared balance
27,429.90
27,384.90
Statement ending balance
27,384.90
27,384.90
Difference
−45.00
0.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
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
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
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
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
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
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.
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.
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 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.
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.