Skip to content

How to categorize bank transactions with AI

Short answer

Start with bank rules for every payee you always code the same way, then use AI for what's left: unrecognized payees, splits and one-offs. Give the assistant your real chart of accounts and ask for a suggested account with a reason and a confidence note. Turn each correction into a new rule, so next month's leftover list is shorter.

How to categorize bank transactions with AI

  1. 1Export last month's categorized transactions and your chart of accounts, so you can see how each payee was coded before.
  2. 2Create bank rules for recurring payees with a fixed account, such as rent, software subscriptions and loan payments.
  3. 3Export the uncategorized transactions that are left as CSV, with date, payee, description and amount.
  4. 4Ask an assistant to suggest an account from your chart of accounts for each line, with a reason and a confidence note, using the prompt below.
  5. 5Accept, change or reject each suggestion, and send the unclear items to the client as a numbered question list.
  6. 6Turn every correction for a repeat payee into a new bank rule.

Copyable prompt: categorize leftover bank transactions

Upload the uncategorized transactions and your chart of accounts as two CSV files, then paste this prompt.

Copyable prompt

I'm categorizing bank transactions for a [type of business] that uses [QuickBooks Online / Xero / other].

I have uploaded:
1. uncategorized.csv: date, payee, description, amount.
2. coa.csv: our chart of accounts (account name and type). Use only these accounts.

For each transaction:
1. Suggest one account from coa.csv.
2. Give a one-line reason based on the payee or description.
3. Rate your confidence as high, medium or low.
4. Flag lines that look like splits, transfers between our own accounts, owner draws, loan payments or possible duplicates.

If you can't tell what a transaction is, mark it "ask client" and write the question I should send. Do not guess and do not decide tax treatment.

Return a table I can download as CSV: date, payee, amount, suggested account, reason, confidence, flag. Then list payees that appear three or more times, so I can turn them into bank rules.

Replace the [bracketed] placeholders. Remove client names, account numbers, and personal data before pasting into any AI tool.

Why use bank rules before AI?

Rules do the same thing every time, and that is what recurring payees need. Brocent's guide argues that QuickBooks and Xero bank rules should handle recurring transactions, with ChatGPT kept for the residue of unrecognized payees, split transactions and anomaly review[1]. It puts that residue at often 10 to 20 percent of lines but a much larger share of the time, and each correction can become a new rule, so the AI pass shrinks month over month[1].

What does the AI in accounting software do with bank transactions?

QuickBooks' Accounting AI groups the transactions it is very confident about, with suggested categories, customers and vendors, into a Ready to post list you can post in one click[2]. Xero's JAX draws on your bank rules, attached documents and past coding, and only reconciles on its own when it is highly confident[3]. Booke AI works inside both bank feeds, categorizing supported transactions and leaving low-confidence ones open[4].

What should you do with transactions nobody can code?

Ask the client, in one email. The Firm calls the email asking a client to explain unknown transactions the place an assistant saves the most time, and recommends grouping similar items, numbering the questions and asking for receipts[5]. Strip names, tax identifiers and account numbers before you paste anything into the assistant[5].

Frequently asked questions

Can ChatGPT categorize bank transactions accurately?
It does best with your real chart of accounts and a confidence note on each line, which tells you where to look first[1]. Without the chart of accounts, it has to guess at your account names.
Should AI decide the tax treatment of a transaction?
No. The Firm says never to let the assistant decide tax treatment[5], and Brocent leaves tax judgments to an accountant[1].
Do I still need bank rules if my software has AI?
Yes. Xero lists your bank rules as one of the things JAX uses when it reconciles[3], and a rule is still the surest way to code a recurring payee the same way every month.

Sources

  1. 1.Brocent: ChatGPT and QuickBooks expense automation
  2. 2.QuickBooks Help: Learn about Accounting AI features
  3. 3.Xero: Reconcile bank transactions
  4. 4.Booke AI Hub: AI bank reconciliation
  5. 5.The Firm: ChatGPT prompts for bookkeepers

Sources were checked when this page was last updated. Archived copies are cited where the original page could not be reached from our checker. Features and settings change, so confirm details with each vendor.

Not professional advice. This is general information, not accounting, tax, legal or financial advice. Check AI output yourself and consult a licensed professional for your situation. See our Terms of Use.

Related workflows

  • Receipts and Expenses

    Categorize Leftover Expenses with AI After Bank Rules

    This Brocent guide argues that QuickBooks and Xero bank rules should handle recurring transactions deterministically, and that ChatGPT is best used for the residue of unrecognised payees, split transactions and anomaly review. It recommends exporting uncategorised transactions to CSV with the real chart of accounts, asking for a suggested category with a confidence note and flags, and reviewing everything before posting. It stresses never auto-posting AI output, keeping an audit trail and leaving tax judgements to an accountant.

    Works in ChatGPT, Claude, Grok, Gemini

    QuickBooks Online, Xero

    Brocent Blog
  • Reconciliations

    Prepare QuickBooks and Xero bank feeds for reconciliation with Booke AI

    Booke AI explains that AI bank reconciliation matches bank feed lines to records, suggests categories and points out what does not add up, but finishing the month still requires the statement ending balance to agree and someone to sign off. Booke works inside existing QuickBooks Online or Xero bank feeds, categorizes supported transactions, matches them to records and documents, and leaves low-confidence, unusual or missing-document cases open for review. In QuickBooks Online it prepares the month and you reconcile; in Xero it can also reconcile the line types you configure.

    Booke AI, QuickBooks Online +1

    Booke AI Hub (vendor blog)
  • Receipts and Expenses

    Chase Clients About Uncoded Transactions with an AI-Drafted Email

    The Firm's guide to ChatGPT prompts for bookkeepers argues that bank feeds and ledger rules already handle matching, so chat assistants are most useful for the writing around the ledger, starting with the email asking a client to explain transactions the bookkeeper cannot code. It recommends grouping similar items, numbering questions, requesting receipts, and following up with a shorter, firmer second chase. The article also says to strip names, tax identifiers and account numbers before pasting, use a firm-approved tier, and never let the assistant decide tax treatment or code from memory.

    Works in ChatGPT, Claude, Grok, Gemini

    The Firm (accounting publication)
  • Reconciliations

    Auto-reconcile bank statement lines in Xero with JAX

    Xero says its automatic bank reconciliation is powered by JAX, which tries to reconcile new statement lines using four methods: Rule (your bank rules), Match (an existing Xero document), Memory (how you reconciled similar items) and Prediction (how other Xero users reconciled similar items). JAX only auto-reconciles when highly confident; otherwise it suggests a match and leaves the final decision to you, and you can challenge or reject its matches.

    Xero, JAX

    Xero US (product page)
  • Practice Operations

    Clean Up a Messy Chart of Accounts with an AI Review Plan

    OCTA's resource page describes AI chart of accounts cleanup that reviews a client's account list against actual posting activity to find duplicates, near-duplicates, unused accounts, wrong account types, misparented sub-accounts and naming inconsistencies. In OCTA Flow the agent connects to QuickBooks, Xero, Sage or Zoho, proposes merges, reclasses, deactivations and renames ranked by severity, and the bookkeeper applies approved changes in the ledger. The page notes that merges can move history and affect prior-period reports, so those are flagged for close review.

    OCTA Flow, QuickBooks Online +3

    OCTA (vendor resource)

If you'd rather track the expenses this workflow leaves for review in a spreadsheet, the Business Expense Tracker is on our sister store.

Last updated:

Vendor sites: QuickBooks, Xero. Pricing and features change; check the vendor's site before you buy.

Some links on this page are affiliate links. If you sign up through one, we may earn a commission at no extra cost to you. It does not change what we recommend. See our affiliate disclosure.