← sources

Which AI would you recommend for categorising 1,500–2,000 bookkeeping transactions accurately?

source: reddit (reddit:AI_Agents)published 2026-10-30 20:20ingested 2026-10-31 02:35

retained text

I'm looking for some advice from people who haveused AI for bookkeeping and transaction categorisation.

I handle the bookkeeping for a business and have records of all the bank statements, credit card statements, income and expenditure. In total, I'm probably looking at around 1,500–2,000 transaction entries.

To save time, I'd like to use AI to go through the transactions and suggest the appropriate bookkeeping categories, such as travel, motor expenses, professional fees, office expenses, subscriptions, repairs and maintenance, etc.

I've experimented with ChatGPT, Gemini and Claude. I've found that ChatGPT and Gemini have occasionally made mistakes or even invented information. Claude seems to have performed noticeably better so far, although I haven't checked every transaction line by line, so I can't say how accurate it actually is.

A few questions:

1. Which AI would you trust most for this sort of task? Has anyone had good experiences with Claude, ChatGPT, Gemini, Copilot or any other specialist software?

2. What sort of prompt would you recommend to minimise hallucinations and ensure the AI only categorises transactions based on the information actually provided?

3. Is there a reliable way to get the AI to flag uncertain transactions rather than guess?

4. Would you recommend using Excel with Copilot, Claude or another tool to handle this?

Ideally, I'd like to upload the transaction data, have AI categorise each entry, retain the original transaction details, and produce an Excel spreadsheet with a suggested bookkeeping category and a confidence level.

I'm not expecting AI to replace checking the figures, but if it can reliably handle 80–90% of the categorisation and flag the rest for manual review, it could save a considerable amount of time.

Would appreciate hearing about people's actual experiences, particularly anyone using AI for bookkeeping or accounting work.

A bloke gets decked out of nowhere in a pub. His mate turns to the attacker and says, "Who the hell are you?"

"Mark."

"Well, you've certainly left one."

document fetched 2026-10-31 00:18 · canonical https://reddit.com/r/AI_Agents/comments/1xjq94a/which_ai_would_you_recommend_for_categorising