Automated bank reconciliation in QuickBooks Online means software matches each statement line to a transaction in the books, and a person reviews the exceptions and finishes the reconciliation. QuickBooks has its own AI Powered Reconciliation for some plans. DeepLedger adds a second route: an AI app such as Claude or ChatGPT, connected through DeepLedger's MCP server, prepares the reconciliation line by line, a person signs off, and you finish it in the QuickBooks Reconcile screen.
This guide is for bookkeepers and accountants reconciling QuickBooks Online bank and credit card accounts. It covers both routes and the review neither one removes.
What does automated bank reconciliation do, and what stays with a person?
| Task | QuickBooks AI Powered Reconciliation | AI through DeepLedger | A person |
|---|---|---|---|
| Read the statement | Extracts ending balance and date from an upload | Reads a statement saved in the company's Documents | Checks every page is present |
| Match statement lines | Pairs lines in Insights | Matches line by line, one to one or one to several | Reviews matches and exceptions |
| Missing fees and interest | Shows bank-feed items still to review | Flags them; records only after review | Approves the treatment |
| Sign-off | Not applicable | Marks the reconciliation ready | Signs off in DeepLedger |
| Finish | In the Reconcile screen | Lists the exact items to tick | Finishes in QuickBooks |
Neither route decides the right expense category or tax treatment. Those are separate review questions.
Before you start
- The complete statement for the account and period, every page.
- The company, account, statement dates and beginning balance confirmed.
- Earlier reconciliations that still agree. If a reconciled transaction has changed, resolve that first.
A bank feed is useful for recording activity, but it is not a replacement for the statement. A list of transactions returned by an AI tool does not establish that every statement line is present.
If several months are missing or unreliable, use the QuickBooks cleanup and catch-up guide first. It finds the last reliable reconciliation and works forward one statement at a time.
How do I use QuickBooks AI Powered Reconciliation?
Intuit calls the US feature AI Powered Reconciliation; some guides call it the Reconcile Companion. Intuit's US instructions list QuickBooks Online Plus, Advanced and Intuit Enterprise Suite as supported plans, as of November 2026. Availability and labels can differ by region.
- Open All apps → Accounting → Reconcile.
- Use Upload or Statement Auto Import to select the statement.
- Check the ending balance and ending date that QuickBooks extracts.
- Let extraction finish, then select Start reconciling.
- Open Insights to review the comparison.
Check the account and extracted fields against the document itself. If the feature is unavailable, use Intuit's standard reconciliation instructions. Connecting an external AI service does not enable a QuickBooks plan feature.
Read the Insights groups as review queues
Intuit describes three groups: paired transactions, bank-feed transactions still needing review, and extra uncleared QuickBooks transactions absent from the statement. The groups show where to look; they do not decide the accounting treatment.
| Finding | Evidence to check | Possible next step |
|---|---|---|
| Two expenses with the same merchant and amount | Receipts, dates, payment references and transaction IDs | Establish whether they are separate purchases before proposing a correction |
| Payment in QuickBooks absent from the statement | Statement cutoff and the payment's clearing status | Carry a legitimate outstanding item forward with an explanation |
| Statement payment that might settle a bill | Open bill, vendor, amount and payment history | Review the relationship before creating another expense |
| Similar amounts in two bank accounts | Both statements and transfer references | Investigate a transfer before treating either side as income or expense |
An identical amount alone is not a match. Keep each unresolved item and its missing evidence visible to the reviewer. For likely duplicates, use the duplicate bills and invoices guide.
How does AI bank reconciliation work with DeepLedger?
DeepLedger keeps a reconciliation workbook for each statement. The AI fills and matches it when you ask. A person signs off. QuickBooks still holds the official reconciliation, because the QuickBooks API cannot finish one.
-
Connect the company and your AI app. In DeepLedger, open Companies, select the company, open its Connections tab and choose Connect to QuickBooks. Add the address below to your AI app and sign in with DeepLedger.
https://mcp.deepledger.ai/mcp -
Save the statement. Upload the statement to the company's Documents tab, or give it to the AI in the conversation.
-
Ask the AI to prepare the reconciliation. Name the company, account and period:
Read Pinebridge Studio's AI Brain and skills, then prepare the bank reconciliation for Operating Checking for September 2026 from the statement in Documents. Match every statement line. Do not post anything to force a balance.
-
Let the AI match line by line. The AI adds every statement line and every QuickBooks transaction on that account not yet cleared, then matches them one to one or one to several. Equal totals are never treated as a match. Unmatched QuickBooks lines stay outstanding.
-
Review the exceptions. A bank fee or interest charge missing from the books is flagged, not plugged. A wrong entry is flagged as a book error. Uncertain items become tasks in the company's Tasks for a person.
-
Sign off. When both differences are 0.00 and nothing blocks, the AI marks the reconciliation ready. A person reviews it in DeepLedger and selects Sign off. A signed-off reconciliation is locked.
-
Finish in QuickBooks. After sign-off, DeepLedger shows the statement ending date, the ending balance and the exact items to tick. Open the QuickBooks Reconcile screen, tick those items, finish, then mark the reconciliation completed in DeepLedger.
-
Verify. Ask the AI to re-read the period-end balance and the matched lines from QuickBooks.
Re-read Operating Checking in QuickBooks as of September 30, 2026. Does the balance agree with the signed-off reconciliation?
The AI Brain helps with accounts that behave differently. A note such as "Stripe payouts arrive net of fees; match the payout to the gross sale and the fee" tells the AI how to match that account, when you ask it to read the AI Brain first.
Can the AI finish a QuickBooks reconciliation?
No. The AI prepares the reconciliation and matches the items. A person signs off in DeepLedger and finishes the reconciliation in QuickBooks. The AI never says an account is reconciled until it has been finished in QuickBooks, marked completed in DeepLedger and verified by a re-read.
DeepLedger's other safety rules apply to any correction found along the way. Every write must name its company, or DeepLedger refuses it and nothing is written. There is no tool to delete posted transactions. A void needs your confirmation and keeps the record for the audit trail.
Finish in QuickBooks and keep the result
Follow the QuickBooks reconciliation workflow: compare the transactions with the statement, resolve the difference, and finish. Keep the reconciliation report with the statement and any explanations.
Do not change the statement balance to force a zero difference. If the entered balance or date is wrong, correct it to the statement. If the discrepancy comes from a transaction, investigate that record. Changes affecting a closed or filed period need the responsible reviewer's decision.
A zero difference does not establish that categories, business purpose or tax treatment are correct. A completed DeepLedger task or Close Sheet check does not replace the QuickBooks reconciliation report. Reconciliation is one step of the accounting month-end close checklist.
Troubleshooting
| Symptom | Likely cause | Fix |
|---|---|---|
| Beginning balance does not agree | A reconciled transaction was edited, deleted or unreconciled in QuickBooks | Find the changed transaction with the Reconcile Discrepancy Report and Audit log; do not start over |
| Difference will not reach 0.00 | A statement line or QuickBooks line is missing, or a fee is not in the books | Ask the AI to list unmatched lines on both sides |
| The AI cannot see the statement | It is not in the company's Documents, or pages are missing | Upload the full statement and ask again |
| A transaction is flagged as a book error | The entry in QuickBooks does not agree with the statement | Correct it in QuickBooks after review, then ask the AI to re-read |
| The reconciliation cannot be changed | It is signed off and locked | Reopen it in DeepLedger before changing anything |
Frequently asked questions
What is automated bank reconciliation?
Automated bank reconciliation is software matching each bank or card statement line to a transaction in the books and showing what is left over. In QuickBooks Online it can come from QuickBooks' own AI Powered Reconciliation or from an AI connected through DeepLedger. A person still reviews the exceptions and finishes the reconciliation in QuickBooks.
Does QuickBooks Online have AI reconciliation?
Yes. Intuit's US help describes AI Powered Reconciliation for QuickBooks Online Plus, Advanced and Intuit Enterprise Suite. It extracts statement information and compares it with QuickBooks records. Check availability in your plan and region.
Can DeepLedger finish a QuickBooks bank reconciliation?
No. The AI prepares the reconciliation in DeepLedger and matches statement lines to QuickBooks transactions. A person signs off, then finishes the reconciliation in the QuickBooks Reconcile screen, because the QuickBooks API cannot finish a reconciliation. DeepLedger lists the exact items to tick.
Will the AI post an adjustment to make the difference zero?
No. DeepLedger's reconciliation never posts a balancing or plug entry. A bank fee or interest missing from the books is flagged, and it is recorded as a real QuickBooks transaction only after review. A wrong entry is flagged as a book error for a person to correct.
Does a zero reconciliation difference mean every category is correct?
No. Agreement with the statement does not establish the correct expense category, business purpose or tax treatment. Review those separately against the supporting records.
Is a bank feed match the same as a bank reconciliation?
No. A bank feed match links a downloaded transaction to a record in the books. A bank reconciliation proves the books against the statement's ending balance for a period, including outstanding items. You need both, and only the reconciliation produces QuickBooks' reconciliation report.
Related guides
- Accounting month-end close checklist for QuickBooks
- QuickBooks cleanup and catch-up with AI
- Find duplicate bills and invoices in QuickBooks Online
- Fix uncategorized transactions in QuickBooks
- QuickBooks MCP server guide
Connect your AI app on AI Platforms & Integrations, then try one account: ask the AI to prepare last month's reconciliation for your main checking account and review what it matched before you sign off.