AI prompts to categorize business transactions (copy-paste)
You opened ChatGPT, pasted in your bank transactions and typed “categorize these.” What came back looked tidy. But half the categories were made up, and you can’t tell which half.
By: Computatio · Last reviewed 2026-10-26
Your AI invents categories you never use
Ask an AI to “categorize” with no list and it makes one up. You get “Technology,” “Food & Dining” and “Miscellaneous.” None of those match the lines on your tax form.
A category that doesn’t map to your return is just a second sorting job for later.
And you don’t know which answers to trust
Every line comes back with the same calm confidence. The coffee shop, the hardware store, the transfer to savings. Nothing says “I guessed on this one.”
So you either check every line, which defeats the point, or check none, which is worse.
What sloppy categorizing costs you
- Wrong lines on your return. Schedule C has fixed expense lines, from line 8 (Advertising) to line 27b (Other expenses). Your categories should land on them.
- Meals at the wrong amount. Business meals are generally only 50% deductible, so they need their own category, not a spot inside “Supplies.”
- Personal charges posing as business ones. An expense must be ordinary and necessary for your business. If a car or phone is used for both, you split the cost by business use.
- Paying yourself recorded as an expense. Amounts you pay yourself are not wages on Schedule C. They’re owner draws.
- A bank line isn’t proof. The IRS says proof of payment alone doesn’t show you’re entitled to a deduction. You still need the invoice or receipt.
Picture month-end with a 10-line review list
You export the month. You paste one prompt. Back comes every transaction on a real Schedule C line, each with a reason. A short list is marked “check this.” You look at those, pull a few receipts, and reconcile.
You review the 10 lines that need you, not the 200 that don’t.
The copy-and-paste prompt library for categorizing transactions
Run these five prompts in order, in the same chat. They work in ChatGPT, Claude, Gemini or Copilot. Before you start, export the month as a spreadsheet and delete full account and card numbers. Our data safety guide covers the rest.
Prompt 1: set the rules
“You will categorize transactions for my sole proprietorship. Use only these categories: Advertising; Car and truck expenses; Commissions and fees; Contract labor; Insurance (other than health); Interest; Legal and professional services; Office expense; Rent or lease; Repairs and maintenance; Supplies; Taxes and licenses; Travel; Meals; Utilities; Other expenses (name it); Owner draw; Owner contribution; Transfer between my accounts; Income; Needs review. Never invent a new category. If unsure, use Needs review. Reply ‘ready’ and wait.”
Using a business entity, or have your own chart of accounts? Paste that list instead. Our chart of accounts guide shows how to build one.
Prompt 2: teach it your vendors
“Apply these rules before anything else: [vendor = category, for example ‘GUSTO = Contract labor’, ‘transfers to account ending 4471 = Owner draw’]. These are fixed. Mark lines you matched by a rule as ‘rule.’”
Prompt 3: categorize with a confidence level
“Categorize the transactions below. Return a table: date, description, amount, category, confidence (high, medium, low), one-line reason. Mark as low anything that could be personal, any warehouse, grocery or big-box store, any restaurant, any payment to a person, and any transfer. Keep every row, in the same order. Don’t add, merge or total anything. [paste transactions]”
Prompt 4: hunt for problems
“Now list only the rows that may be wrong: possible personal spending, possible duplicates (same amount and vendor within 5 days), refunds coded as expenses, deposits that may not be income (loans, transfers, owner contributions), and anything in Other expenses. Say why for each.”
Prompt 5: build your rules for next month
“From the rows I approved, write a list of vendor rules in the form ‘vendor = category’. Only include vendors that are always the same category. I’ll paste this list into Prompt 2 next month.”
Prompt 5 is what makes this faster every month: your rule list grows, and the review list shrinks.
Oct 2 · GOOGLE *WORKSPACE · $14.00 → Office expense · high · “Monthly business software.”
Oct 8 · HOME DEPOT #6621 · $187.42 → Supplies · low · “Big-box store; could be home repair.”
Oct 14 · BLUE BOTTLE COFFEE · $23.50 → Meals · low · “Restaurant; business purpose unknown.”
Oct 20 · ZELLE TO M RIVERA · $600.00 → Needs review · low · “Payment to a person; could be contract labor.”
How to check it: open the Home Depot receipt, write down who you met and why for the coffee, and confirm the Zelle payment against an invoice. Then count rows: the AI’s table should have exactly as many rows as your export.
How do you check AI’s transaction categories?
- Count the rows. Same number in, same number out. A missing row is a missing expense.
- Review every low and medium line, plus anything over an amount you pick, such as $200.
- Match receipts for the lines you reviewed, and keep them. The IRS generally expects records for 3 years after you file, and longer in some cases.
- Post the categories in your bookkeeping software or spreadsheet, then reconcile to your bank statement. Totals come from your software, never from the chat.
What these prompts can’t do
AI can’t know why you bought something. It can’t tell a client lunch from a personal one, or a work tool from a gift. It can also state a tax rule that is out of date. Treat its reason as a guess, and check tax rules on an IRS or state tax agency page. You’re responsible for your return whoever, or whatever, sorted the numbers.
Not technical? You don’t need to be. If you can copy a spreadsheet and paste text, you can run all five prompts. For the full monthly routine around them, read how to use AI for bookkeeping and our guide to doing your own bookkeeping.
More prompt methods are in our AI for Accounting guides and the bookkeeping hub. Rather hand off the whole monthly job?
Sources
- IRS: 2025 Schedule C (Form 1040)
- IRS: Instructions for Schedule C (Form 1040) (2025)
- IRS: Publication 583, Starting a Business and Keeping Records
- IRS: Publication 463 (2025), Travel, Gift, and Car Expenses
- IRS: How long should I keep records?
This guide is general information, not financial, tax or legal advice for your situation. We work hard to get it right, but we can make mistakes, and rules change. Check the official sources above before you act.