How I Use AI to Finish Expense Reports in 15 Minutes
Expense reporting used to be my least favourite recurring task. A month's worth of receipts — taxi apps, software subscriptions, ad platform invoices, the odd office supply run — each one needing a category, a clean description, a date, and an amount in the right currency, all formatted consistently so finance does not send it back.
It is not hard work. It is worse than hard work: it is easy work that punishes small mistakes. One inconsistent category name and the monthly summary pivot table splits into two rows. One "Meta ads" where every other line says "Meta Ads — Campaign" and someone has to clean it later. Usually me.
Here is the workflow that got a half-day task down to about fifteen minutes. None of it requires special software — just an AI assistant that can read text or images, and a spreadsheet.
Step 1: Collect everything into one dump (3 minutes)
Once a month, I gather every receipt into one place: forwarded email receipts, screenshots from payment apps, PDF invoices. I do not sort them. Sorting is the machine's job now. The only discipline I keep during the month is a folder called "Expenses — [Month]" that everything gets thrown into the moment it arrives. Thirty seconds per receipt at the time saves the archaeology session later.
Step 2: Teach the AI your format once (one-time setup)
The magic is not in asking AI to "categorise my expenses." It is in giving it your exact rules, once, and reusing them forever. Mine look like this:
Write the rules to match whatever your finance team already expects. The first time takes twenty minutes of thinking about what your rules actually are — which, honestly, is a useful exercise on its own.
Step 3: Feed receipts, get the table (5 minutes)
Paste the receipt text or attach the images, batch by batch, with the rules above. Out comes a formatted table. Paste it into the spreadsheet. The consistency is the point: the AI writes "Meta — Ad campaign (Jul)" the same way every single time, which means the pivot tables and monthly summaries just work.
Step 4: Review like an auditor, not a typist (5 minutes)
This step is not optional, and I want to be honest about it because "AI does my expenses" without review is how errors get into financial records. My checks:
- Totals first. Does the table total match what the card statement says went out? If yes, nothing was missed or duplicated. This one check catches most problems.
- The REVIEW list. Anything the AI flagged as unclear, I categorise myself. Usually two or three items a month.
- Spot-check amounts. I verify a handful of amounts against the original receipts, especially anything unusual. AI reading numbers from images is good but not perfect, and finance data has to be perfect.
Step 5: Save the rules, improve them monthly (2 minutes)
Every time the AI gets something wrong — a category I had to correct, a description format that drifted — I add one line to the rules. "Etisalat is Utilities, not Software." Next month it does not make that mistake. After a few months the REVIEW list gets very short, and the whole thing genuinely takes fifteen minutes end to end.
The honest summary
AI did not remove the expense report from my life. It removed the typing, the formatting, and the category decisions I had already made a hundred times — and left me the five minutes of actual judgement. That is the pattern with almost every admin task worth automating: the machine does the repetition, you keep the responsibility.
The same rules-first approach works brilliantly for spreadsheet formulas too — I wrote about that in AI + Excel: generate formulas instead of memorising them.