# QuickBooks bank rules with AI: build them from last year's GL

> Have Claude or ChatGPT turn last year's QuickBooks GL into reviewable bank rules and an import file, back-test them, then import into a sample company first.

- **URL**: https://www.nocodetalks.co/blog/quickbooks-bank-rules-with-ai
- **Author**: Ankur Khandelwal, Nocodetalks
- **Updated**: Oct 7, 2026
- **Topic**: Bookkeeping
- **Sources checked**: 22

---

_A workflow for US bookkeepers onboarding or cleaning up a client._ Check QuickBooks' own suggestions first. Then let AI read last year's GL, propose payee rules you can review, and write them in the layout of an exported rules file.

## The short answer

Check QuickBooks Online's own suggestions first, since a bank rule always overrides them. Then export last year's GL, have Claude or ChatGPT propose rules only for payees that always hit one account, back-test them against last year, and write them in the layout of a rules file you exported from QBO. Import into a sample company first, and leave auto-post off until a month proves each rule.

## Check QuickBooks' own AI first

QBO already suggests a category for each downloaded transaction on its AI-powered banking page. Suggestions draw on your history, the bank description and your vendor and customer lists, and Review Signals show how strong the evidence is. On Essentials, Plus and Advanced in the US, Ready to post groups high-confidence lines for batch posting. Exact features depend on the plan.

Two facts shape the rest. A rule always supersedes a category suggestion. And Intuit says AI never overrides your rules or makes them auto-post. Rules hold your judgment; suggestions cover the long tail.

A simple test: if the books already live in this file and most suggestions show green, you may only need a few rules. Build the full set from last year's GL when you're onboarding, migrating, copying rules to another client, or the suggestions keep missing.

What people say about QBO's AI
- In a long thread, users said QBO's AI categorization guesses across the whole chart of accounts and that nobody asked for it. (commenters on r/QuickBooks (2026), https://www.reddit.com/r/QuickBooks/comments/1tzs1e5/was_thinking_of_using_quickbooks_but_noticed_they/)
- Accountants described using AI to suggest codes from history and flag what doesn't fit a pattern, with a person approving. (commenters on r/Accounting (2026), https://www.reddit.com/r/Accounting/comments/1wsxh2r/where_do_you_actually_trust_ai_in_the_monthend/)

> QBOs automation is actually pretty good but needs a lot of set up.
> — a commenter on r/Bookkeeping (May 2026) (https://www.reddit.com/r/Bookkeeping/comments/1tjiinm/relying_entirely_on_bank_feeds_matching_in/)

## What you need

As of October 2026, no official connector exposes bank-feed review or bank rules. Intuit's QuickBooks connector in Claude lists 74 tools for reports, invoices, customers and payroll, and none for rules or the feed. Intuit's local MCP server has no bank-rule entity, and Xero's hosted connector is read-only. So this is a files workflow: the GL goes in, a rules file comes out, and you import it.

| Surface | Use it for |
|---|---|
| Claude or ChatGPT, one Project per client | The payee analysis, the rules table and the import file |
| Claude in Excel, ChatGPT for Excel or Copilot in Excel | The same analysis in the workbook, with formulas you can audit |
| Claude Code or Codex | Running the steps across many clients |

- **Last fiscal year's General Ledger or Transaction Detail by Account**, with payee, memo or description, account and amount, exported to Excel.
- **The chart of accounts and vendor list**, so the AI maps to names that exist.
- **An exported rules file.** Create one or two rules by hand, then use New rule, Export rules. Intuit doesn't publish the import layout, so this file is your template.
- **Raw bank text.** Turn on Show full bank description and note a few lines per big vendor. Rules match what the bank sends, which can differ from the GL memo.

## The workflow: last year's GL to bank rules with AI

1. **Strip and upload.** Remove account numbers, keep bank and card activity only, and add the files to the client's Project.
2. **Find the consistent payees.** Ask for payee-by-account counts, money in and out kept separate (prompt 1).
3. **Draft the rules table.** Payees with enough history that always went to one account become rules (prompt 2). The rest stay manual.
4. **Review it yourself.** Cut generic phrases like PAYMENT or ONLINE. Drop transfers, card payments, loans and checks. Put specific rules above general ones.
5. **Back-test, then write the file.** Have the AI run the draft rules against last year's lines, then write the approved ones in your exported layout (prompt 3). GL memos aren't always the raw bank text, so treat this as a screen. A rule that would have miscoded last year will miscode next year.
6. **Test the import.** Import into QBO's sample company first. In QuickBooks Online Accountant, select the Settings gear, then Sample company. Staats' rules import worked there, though bank CSV uploads were blocked. Then import into the client file and pick which rules to bring over.
7. **Leave auto-post off for a month.** Check every RULE badge. Then turn auto-post on for dull, fixed items like rent, which is Intuit's own suggestion.

Prompt for Any AI chat · Find the payees that always hit one account:

```
Attached: [CLIENT CODE]'s [YEAR] transaction detail by account (bank and card lines only) and the chart of accounts.
1. Clean payee names and merge obvious variants. Show the merges.
2. Count transactions per payee per account, money in and money out separate.
3. Sort payees into: one account every time (3+ transactions), split across accounts, too few to judge.
4. For split payees, say whether amount or memo explains the split.
Show the counts. Ask me before treating any transfer, card payment, loan or owner item as an expense.
```

Prompt for Claude · Draft rules as a reviewable table:

```
From the one-account list, draft QuickBooks Online bank rules as a table: rule name, money in or out, bank account, field (Bank text or Description), operator (Contains or Is exactly), phrase, category, payee, auto-post (always No), lines matched last year, confidence, and why.
Take each phrase from the raw bank text, and use one only this vendor uses. Flag phrases under five characters or that look generic.
Order rules specific first.
Where you're unsure, say so instead of guessing.
```

Prompt for Claude · Back-test, then write the import file:

```
1. Apply the approved rules, in order, to last year's lines. For each rule, report lines caught, lines where the rule's category differs from how the line was actually coded, and lines caught by more than one rule.
2. List last year's lines no rule catches, by payee.
3. Then write only the approved rules in exactly the layout of the attached exported rules file: same sheets, columns and value formats. Use account and payee names exactly as they appear in the chart and vendor list.
4. List any column you didn't understand. Don't guess it.
```

## Copy a rule set to another client

Jason Staats, a CPA, demos a practical version. He exported one client's QBO rules, gave Claude that file plus a second client's chart of accounts, and asked for the rules converted to that chart. Claude remapped six categories, and the file went straight through QBO's Import rules wizard ([@8:18](https://youtu.be/fBne9qS08w4?t=498)). He notes QBO publishes no template for rule imports, so he built one into a skill ([@9:24](https://youtu.be/fBne9qS08w4?t=564)).

He also mentions firms that roll one master rule set out to every client. A standard chart of accounts used to be the blocker; Claude can tailor the rules to each chart and call out the ones that don't fit ([@9:03](https://youtu.be/fBne9qS08w4?t=543)). The video carries a sponsor segment for Soraban, a tax workflow product, and his demo used QBO's sample company.

Prompt for Claude · Migrate a rule set to a new chart of accounts:

```
Attached: an exported QBO rules file from [SOURCE CLIENT] and the chart of accounts for [TARGET CLIENT].
1. Map every category in the rules to an account that exists in the target chart. Show the mapping as a table with a reason for each.
2. Where nothing fits, or the rule makes no sense for this business, mark it Drop and say why.
3. Write a new rules file in exactly the original layout, without the Drop rules.
4. List every change. Don't add rules that weren't in the source file.
```

## Check the rules before they touch the books

- Every category and payee in the file exists in the target company, spelled exactly.
- The import shows the same number of rules as your approved table.
- Each phrase appears in the bank text of only one vendor in last year's lines.
- The back-test shows no conflicts, or you decided each one.
- Transfers, card payments, loans and checks have no rules.
- Auto-post is off on every new rule.
- After the first month, you looked at every RULE badge before posting.

> Note: Bank text is exactly what the bank sends. Description is QBO's simplified version. Intuit says mixing them up is one reason rules don't fire, so confirm which field each phrase came from.

## Make it faster next time

- **Save the procedure.** Keep the prompts, the exported layout and your thresholds in a Project or a skill, so the next client starts from one instruction.
- **Keep a master rule set** as a file, and migrate it per client with the prompt above.
- **Review rules at year-end.** Give the AI the rules export and this year's GL, and ask which rules caught lines that were later reclassified. Those rules are stale.
- **Reuse statement work.** The vendor map from [converting statement PDFs with AI](https://www.nocodetalks.co/blog/bank-statements-to-quickbooks-with-ai) is a ready-made rules draft.

## Where AI fails here

- **It can't see your rules or the feed.** No official connector exposes them, so you import and test the file yourself.
- **Browser entry is slow.** Staats' browser test entering transactions in QBO was stopped after about 10 minutes ([@24:04](https://youtu.be/5DevfwAfVpA?t=1444)).
- **Runs differ.** In Staats' invoice test, one Claude chat asked about missing terms and another didn't ([@2:57](https://youtu.be/fBne9qS08w4?t=177)). The back-test catches drift.
- **A clean rec isn't proof.** Rules can code a vendor wrong every month, and the account still reconciles.

What practitioners report
- They suggested feeding Claude the GL from a set of books you trust and letting it draft rules from that detail. (a commenter on Jason Staats' YouTube video on automating QuickBooks (2026), https://www.youtube.com/watch?v=fBne9qS08w4)
- Their firm struggles to import bank rules into Xero, and trying it with Claude in the browser was very slow. (a commenter on the same video (2026), https://www.youtube.com/watch?v=fBne9qS08w4)
- A skeptic argued AI can't get every classification right, especially split transactions. (a commenter on Jason Staats' YouTube video (2026), https://www.youtube.com/watch?v=PwhvAASCJ1I)
- After taking over books where the GL matched the bank for six months, they found offsetting errors that happened to cancel out. (a commenter on r/Bookkeeping (May 2026), https://www.reddit.com/r/Bookkeeping/comments/1tjiinm/relying_entirely_on_bank_feeds_matching_in/)

> I don't trust QBO to auto-add anything.
> — a commenter on r/Bookkeeping (2023) (https://www.reddit.com/r/Bookkeeping/comments/11dg7pz/looking_for_software_to_read_pdf_bank_statements/)

## Data safety

A GL export lists every vendor and amount the client paid last year. Use a firm-managed business plan, remove account numbers, and keep one Project per client. Anthropic's Cowork safety page advises against giving Cowork local files with sensitive information, like financial documents, and since October 6, 2026, new Pro and Max Cowork tasks run in Anthropic's cloud. See [Is it safe to use Claude with client data?](https://www.nocodetalks.co/blog/is-claude-safe-for-client-data) and, for tax clients, [Section 7216 consent and AI](https://www.nocodetalks.co/blog/irs-section-7216-ai-client-consent).

## Common questions

**Can Claude or ChatGPT create bank rules in QuickBooks Online directly?**

Not through an official connector as of October 2026. They can draft the rules and write an import file in the layout of a rules file you exported. You import it with Import rules on the Rules page.

**How many bank rules can you have in QuickBooks Online?**

Up to 2,000, each with up to 5 conditions, per Intuit's help page as of October 2026.

**Can you copy bank rules from one QuickBooks Online company to another?**

Yes. Use Export rules from the New rule dropdown in one company and Import rules in the other. AI helps when the two charts of accounts differ.

**Which wins, a bank rule or QuickBooks' AI suggestion?**

The rule. Intuit says a rule always supersedes a category suggestion, and AI never makes your rules auto-post.

## Sources

- [Set up bank rules to categorize online banking transactions in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/banking/set-bank-rules-categorize-online-banking-online/L0mjJl0nD_US_en_US)
- [Import existing bank rules in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/banking/import-existing-bank-rules-quickbooks-online/L7utKIMHE_US_en_US)
- [How AI suggestions help match and categorize bank transactions](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/ai-suggestions-help-match-categorize-bank/L8FHOh4AD_US_en_US)
- [Use Ready to post in QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/account-management/use-ready-post-quickbooks-online/L9jzjf8Xe_US_en_US)
- [Learn about updates to the new AI-powered banking page](https://quickbooks.intuit.com/learn-support/en-us/help-article/matching-rules/learn-updates-new-ai-powered-banking-page/L0hR7A9Zf_US_en_US)
- [Run a ledger report that shows debits and credits for each transaction](https://quickbooks.intuit.com/learn-support/en-us/help-article/profit-loss-reports/create-report-shows-debits-credits-transaction/L1zvqNX0e_US_en_US)
- [Practice with sample client companies in QuickBooks Online Accountant](https://quickbooks.intuit.com/learn-support/en-global/help-article/accountant-features/practice-sample-client-companies-quickbooks-online/L8dbIHyx0_ROW_en)
- [QuickBooks connector](https://claude.com/connectors/quickbooks)
- [intuit/quickbooks-online-mcp-server README](https://github.com/intuit/quickbooks-online-mcp-server)
- [Xero connector](https://claude.com/connectors/xero)
- [Claude Cowork Can Automate Your QuickBooks! (here's how accounting firms use it)](https://youtu.be/fBne9qS08w4?t=498)
- [Why Claude Cowork Is Already Changing Accounting Firms](https://youtu.be/5DevfwAfVpA?t=1444)
- [Claude Cowork Is REPLACING QuickBooks in Accounting Firms](https://youtu.be/PwhvAASCJ1I)
- [Use Claude Cowork on web, desktop and mobile](https://support.claude.com/en/articles/15520349-use-claude-cowork-on-web-desktop-and-mobile)
- [Use Claude Cowork safely](https://support.claude.com/en/articles/13364135-use-claude-cowork-safely)
- [What are projects?](https://support.claude.com/en/articles/9517075-what-are-projects)
- [Projects in ChatGPT](https://help.openai.com/en/articles/10169521-projects-in-chatgpt)
- [Use Claude for Excel](https://claude.com/docs/office-agents/excel)
- [Relying entirely on bank feeds matching in QuickBooks-big mistake (r/Bookkeeping)](https://www.reddit.com/r/Bookkeeping/comments/1tjiinm/relying_entirely_on_bank_feeds_matching_in/)
- [Looking for software to read PDF bank statements, and auto-categorize transactions (r/Bookkeeping)](https://www.reddit.com/r/Bookkeeping/comments/11dg7pz/looking_for_software_to_read_pdf_bank_statements/)
- [Was thinking of using QuickBooks but noticed they doubled prices (r/QuickBooks)](https://www.reddit.com/r/QuickBooks/comments/1tzs1e5/was_thinking_of_using_quickbooks_but_noticed_they/)
- [Where do you actually trust AI in the month-end close? (r/Accounting)](https://www.reddit.com/r/Accounting/comments/1wsxh2r/where_do_you_actually_trust_ai_in_the_monthend/)