AI in Excel: build formulas, pivot tables and charts by asking in plain words.
Accountant
ChangingCategorizing transactions, reconciliations and draft explanations are increasingly handled by accounting software with AI. The accountant becomes an advisor: explains the numbers and stands behind the reporting.
Where this job sits on the map
In the same group: 78 of 100 professions.
What changes
Document recognition and bank-feed categorization are moving into accounting software with AI
More time goes to analysis and to conversations with the business owner about the numbers
There's a new duty: checking how AI categorized the transactions
AI drafts, the person decides
How the work splits here: AI prepares a draft, the person checks it and makes the call.
What AI does
- Go through a transaction export and suggest expense categories
- Find discrepancies between the bank and the books
- Write a clear explanation of a report for the business owner
- Draft a reply to an IRS notice, based on facts the accountant provides
- Build a formula or a pivot table from a plain-language description
What stays with the person
- Signing off on reports and filings, and accountability to the IRS and other tax authorities
- Applying tax rules to one company's specific situation
- Checking everything AI categorized automatically
- The owner's trust and the conversation about the company's money
What to learn first
6 lessons from the course, in order. Start with the first one.
- Your first 30 minutes with AI: where to startStarting from zeroYour first 30 minutes with AI: sign up, ask three questions, try seven everyday tasks, learn what never to share and which plan to pick.Start here
- How to write a good promptUserHow to give AI a task: the five parts of a good prompt, Plan Mode, and how to refine an answer instead of starting over.
- AI ethics and safety: hallucinations, attacks, biasUserHallucinations, prompt injection, bias, privacy and copyright: how not to trust AI blindly.
- Unit economics made simple: what a customer is worthUserHow to work out what you earn from one client and what it costs to bring that client in.
- Break-even and cash flow: when your business pays youUserHow many customers you need to break even, and how to avoid running out of cash while showing a profit on paper.
- Microsoft 365 + Claude: the full integrationBuilderClaude in the Microsoft world: Teams webhooks and bots, Word, Excel, PowerPoint, Graph API, Power Automate and Foundry.
Which tools to use
- Paid
Gemini in Google Sheets: tables, formulas and data analysis from a description.
PaidSmall business accounting with Intuit's AI agents: expense categories, bank reconciliation, invoices.
FreemiumCloud accounting with the JAX assistant: ask about your money and create invoices in plain words.
PaidTurns a photo of a receipt into an expense entry, and it's free for personal use.
FreemiumAn AI assistant for long documents, analysis and code, with Claude Code and Cowork on paid plans.
Freemium
Ready-to-use materials
What each column means, where the data has errors, the main points in 5 bullets and questions for the author of the table.
Free- Numbers and finance project instructionsInstructions
Your own metric definitions and a routine for any export, so calculations come out the same every time.
Free A one-month sheet: income, expenses, the balance after every transaction and totals. Pastes into Google Sheets.
Free- What never to send to AIChecklist
A 30-second check before you hit send: what to remove, how to anonymize and what to do if it's already gone out.
Free
How to earn with AI
We don't promise income: results depend on your niche, your market and your work.
- Job
Move the routine work into accounting software with AI features, such as QuickBooks, and take on the analysis: a monthly review of the numbers for the owner.
- Service
A monthly management report for a small business in plain language: how much you earned, where the money went, what to watch.
- Product
An income and expense tracking template with instructions, for freelancers and small businesses.
Similar professions
Health, law and finance: AI helps a licensed professional and does not replace one. Nothing here is personal medical, legal or financial advice.
Checked: October 2026