AI and MCP

Budget versus actual in a chat: asking Claude as an accountant

How accountants can ask Claude how you are doing on your budget: budget versus actual by category, variance signs, and checks before you quote the numbers.

Editorial illustration for Budget versus actual in a chat: asking Claude as an accountant

An accountant's version of 'how am I doing on my budget' is budget versus actual with a clear variance for each line and a sentence on why. Claude can produce that table quickly from records it can read; your job is to fix the sign convention, check the totals and decide which variances deserve an explanation. The numbers are a draft until you have tied them to the ledger.

Agree the conventions before you ask

  • Variance = actual minus budget. Positive means overspend for an expense line.
  • Period: write the dates, for example 1 July 2026 to 30 September 2026.
  • Basis: the app records cash movement from statements and entries; if your books are on accrual, expect differences.
  • Scope: which workspace and which accounts.

SpendixAI has budgets on Pro, along with bills and savings goals, and Claude or ChatGPT can connect through MCP with a scope you choose, read-only if you wish. Pro covers one personal workspace, so use it for your own practice or your own affairs, not as a multi-client system.

The request

Something like: for 1 July to 30 September 2026, show each budgeted category with budget, actual, variance and variance as a percentage of budget. Then list the three largest variances and the transactions behind each. Ask for a total line, and for any spending with no category.

A worked example: a practice's own quarter

LineBudgetActualVariance
Rent₹60,000₹60,000₹0
Software₹18,000₹23,400+₹5,400
Travel₹25,000₹19,200-₹5,800
Printing and courier₹6,000₹8,150+₹2,150
Total₹1,09,000₹1,10,750+₹1,750

Check the footings. Budget: ₹60,000 plus ₹18,000 plus ₹25,000 plus ₹6,000 is ₹1,09,000. Actual: ₹60,000 plus ₹23,400 plus ₹19,200 plus ₹8,150 is ₹1,10,750. Variance: 0 plus 5,400 minus 5,800 plus 2,150 is ₹1,750, which is 1.6 percent of budget (1,750 divided by 1,09,000). The total looks calm, but the software line is 30 percent over (5,400 divided by 18,000), and it is hidden by an underspend on travel. A reader who sees only the total would miss it.

Which variances are worth a sentence?

  1. Large in rupees, even if small in percentage.
  2. Large in percentage on a small line, if it keeps happening.
  3. Offsetting lines that hide each other, like software and travel above.
  4. Anything uncategorised.

What to treat as a draft

Category assignments can be wrong, because categorisation uses rules, history and, if AI is on, an AI model for what is left. GST figures in reports are estimates to confirm with invoices. And a budget in the app is a management tool, not a statutory record. Rules and limits change, so confirm any tax treatment against the current official position.

If you advise clients on their budgets

Ask the client to share the question and the answer with you, or sit with them while they ask. Do not take their logins. Their data stays in their workspace, and the connection can be disconnected at any time.

Presenting it to a client or partner

Keep the page short: one table, three sentences of commentary and one question for the reader. Lead with the line that matters, here software at plus ₹5,400, rather than the total. Say what you have done or intend to do about it. If the figures came from an assistant, say what they were checked against. People trust a number more when they can see how it was tied out, and you protect yourself if the budget is questioned later.

Before you quote the figures

  1. Dates, accounts and sign convention stated.
  2. Totals footed.
  3. Largest variance traced to source.
  4. Uncategorised items cleared.
  5. A one-line reason for each material variance.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports