You import a bank statement with 200 transactions. Now you need to categorize every single one. Rent, software, meals, insurance, payroll, transfers — each row needs a label before you can generate a report, file taxes, or send it to your accounting software.

Doing this by hand takes hours. Here’s how AI does it in seconds.

How Manual Categorization Usually Works

Most people build a lookup table. Map “AMAZON” to Shopping, “SHELL” to Gas, “STARBUCKS” to Dining. Then use VLOOKUP or IFS formulas to match vendor names.

This breaks down fast:

“AMZN MKTP US*2K9X1” doesn’t match your “Amazon” rule
A restaurant charge could be a business meal, a client dinner, or a personal expense — one vendor, multiple categories
New vendors keep appearing — every month you’re updating the lookup table
You can only assign one category — but you also need to track who made the purchase and whether you have the receipt

Formulas can’t read context. AI can.

How Talio’s AI Categorization Works

Talio is a Google Sheets add-on with a built-in AI agent. After importing a bank statement, ask the AI to categorize your transactions. Here’s what happens:

1. The AI Reads Each Transaction

Not just pattern matching on vendor names. The AI looks at the full transaction description, the amount, and the context of surrounding transactions to determine what each charge actually is.

“AMZN MKTP US*2K9X1 — $47.99” gets tagged #office-supplies because the amount and description pattern suggest a business purchase, not a personal one.

2. Multi-Dimensional Tags, Not Just Categories

Traditional categorization gives you one column. Talio uses multi-dimensional tagging — each transaction can carry multiple tags across different dimensions:

#category — what it is: #rent, #software, #meals, #insurance
@person — who it involves: @sarah, @client-acme
!status — what needs attention: !needs-receipt, !needs-review, !reimbursable

A single transaction can be #travel @client-acme !reimbursable. No compromises, no losing information.

3. You Review and Correct — The AI Learns

The AI doesn’t just fire and forget. After suggesting tags:

Review the suggestions in your spreadsheet
Fix any that are wrong
The AI remembers your corrections and applies them to future transactions

Over time, the AI learns how you categorize. If you always tag Uber rides as #travel instead of #transportation, it picks that up.

What This Looks Like in Practice

Here’s a real example. A restaurant client’s bank statement with 3 months of transactions:

Description	Amount	AI Tags
SYSCO FOOD SERVICES	-$2,847.00	#food-supplies
TOAST PAYROLL	-$4,200.00	#payroll
UBER EATS PAYOUT	$1,523.00	#revenue-delivery
GORDON FOOD SERVICE	-$1,105.50	#food-supplies
COMCAST BUSINESS	-$189.00	#utilities
SQUARE INC DEPOSIT	$3,891.00	#revenue-pos
MYSTERY CHARGE LLC	-$299.00	#unknown !needs-review

The AI categorized 95% of transactions correctly on the first pass. The ones it wasn’t sure about got flagged with !needs-review — so you know exactly which rows need your attention instead of scanning all 200.

From Tags to Reports in One Step

Once transactions are tagged, ask the AI to generate a report. Talio builds a P&L or spending breakdown directly in your spreadsheet — no export to another tool.

Filter by any dimension:

“Show me all #food-supplies spending” — see total supplier costs
“Show me everything tagged !needs-review” — focus on what needs attention
“Show me @sarah’s expenses” — pull up one person’s charges

The data and the reports live in the same Google Sheet. Share it with your client or your team — they already know how to use spreadsheets.

Why This Matters for Accountants

If you’re doing cleanup or catch-up bookkeeping, AI categorization changes the math on how long a job takes:

200 transactions categorized in seconds, not hours
Only review the exceptions — the !needs-review items — instead of every row
Consistent categorization across months of data — the AI doesn’t get tired or inconsistent halfway through
Reusable learning — corrections you make on one client’s data improve suggestions for similar transactions across all clients

The time savings compound. The first statement takes a few minutes of review. By the fourth month’s statement, the AI knows your patterns and almost everything is correct on the first pass.

Get Started

Talio is a free Google Sheets add-on. Install it from the Google Workspace Marketplace, import a bank statement, and let the AI categorize it.