Use QuickBooks Intuit Assist to Auto-Categorize Transactions
What This Does
QuickBooks' built-in AI automatically categorizes your bank feed transactions based on your history, so instead of coding 200 transactions from scratch, you review and approve the AI's suggestions — fixing only the ones it gets wrong.
Before You Start
- You have QuickBooks Online open (any paid subscription)
- Your bank account is connected via bank feed
- You have at least 1–2 months of categorized transaction history (the AI learns from your past work)
- Time needed: 10-15 minutes to enable and review first batch
Steps
1. Connect your bank feed (if not already done)
In the left sidebar, go to Transactions → Bank Transactions. If your bank isn't connected, click Add account and search for your bank. Follow the prompts to connect.
What you should see: A list of bank transactions in a queue with status "For review"
2. Review AI-suggested categories
For each transaction in the "For review" tab, QuickBooks Intuit Assist shows a suggested category in the Category column. Transactions where the AI is confident will show the category pre-filled.
What you should see: Most recurring vendors (utilities, known suppliers, regular vendors) will already have category suggestions. New or unusual vendors will show as uncategorized.
3. Accept or correct suggestions
- Click Add (or the checkmark) to accept a correctly categorized transaction
- For incorrect categories, click the suggested category to open a dropdown and select the right one
- For transactions you're unsure about, leave them in the queue and follow up with your client
Troubleshooting: If the AI is consistently wrong for a specific vendor (e.g., it keeps categorizing your client's payroll software as "Software" instead of "Payroll Expenses"), you can train it. After correcting, QuickBooks will ask if you want to apply this rule to all future transactions from this vendor — click Yes.
4. Bulk accept clearly correct transactions
In the "For review" tab, check the box next to multiple transactions that are all correctly categorized, then click Accept to approve them all at once.
What you should see: Accepted transactions move to the "Categorized" tab and out of your review queue.
5. Set up bank feed rules for recurring vendors
For vendors that appear every month with the same category: click the transaction, then look for Create rule at the bottom. Set the rule: "If vendor name contains [vendor name], categorize as [category]." This runs automatically going forward.
Troubleshooting: If you accidentally accepted a wrong category, go to the Categorized tab, find the transaction, click it, and select Undo to return it to the review queue.
Real Example
Scenario: You're doing monthly bookkeeping for a retail client with 180 bank feed transactions to categorize.
What you do: Open Bank Transactions → For Review. QuickBooks has pre-categorized 142 of the 180 transactions. You scan through them — 135 look correct. You bulk-accept those, then manually review the remaining 45 (38 pre-categorized ones you want to verify + 7 uncategorized).
What you get: What used to be a 90-minute manual coding session takes 25 minutes — with the AI handling the obvious ones and you focusing judgment on the ambiguous ones.
Tips
- The more transactions you categorize correctly, the smarter QuickBooks Intuit Assist gets over time — it's learning your client's patterns
- Use the Exclude option (not Delete) for bank transfers or duplicate transactions; this keeps a record without affecting the P&L
- Check the Suggested matches tab too — QuickBooks will try to match bank transactions to existing bills or invoices you've entered, which saves time on AP reconciliation
Tool interfaces change — if a button has moved, look for similar AI/smart options in the Banking or Transactions menu area.