To build a monthly budget with Copilot in Excel, put your expenses in a clean table, then ask for specific changes one at a time: a budget sheet by category, Budget, Actual and Variance columns, and a short summary. Read every formula it writes before trusting it. Below are prompts to try and a checklist for checking the result.
What should the data look like before I ask?
Copilot generally works best on tidy data, usually a table with one header row, no merged cells and no blank rows. Press Ctrl+T to format your expense range as a table, and use plain headings such as Date, Description, Amount, Category. Availability and requirements depend on your Microsoft plan and Excel version, so check Microsoft's current help for what yours supports.
Clean the data first: one row per expense, dates stored as real dates, amounts as numbers without the rupee symbol typed in, and consistent category names. A messy input table produces a confidently wrong budget, so ten minutes of tidying saves far more time than it costs.
Which prompts should I try?
- "Using the Expenses table, create a new sheet that lists each Category with the total Amount for November 2026."
- "Add a Budget column next to it and leave the cells empty for me to fill in."
- "Add an Actual column that sums Amount from the Expenses table for each category for the same month, and a Variance column equal to Budget minus Actual."
- "Add a Variance percent column as Variance divided by Budget, showing blank when Budget is zero."
- "Highlight rows where Actual is above Budget in red, and add a total row at the bottom."
- "Add a short summary above the table: total budget, total actual, total variance, and the three categories with the biggest overspend."
Ask for one step at a time. A single long request tends to produce a sheet that is harder to inspect.
What does a correct result look like?
| Category | Budget (₹) | Actual (₹) | Variance (₹) |
|---|---|---|---|
| Rent | 18,000 | 18,000 | 0 |
| Groceries | 12,000 | 13,400 | -1,400 |
| Fuel | 4,000 | 3,200 | 800 |
| Eating out | 3,000 | 4,100 | -1,100 |
| Total | 37,000 | 38,700 | -1,700 |
The figures are invented. Notice the sign: with Budget minus Actual, a negative variance means overspent. If Copilot has used Actual minus Budget, the signs flip, so read the label and the formula together. Variance percent for Groceries would be -1,400 divided by 12,000, about -11.7 percent.
What do I check in the sheet it produces?
- Click a few cells and read the formula. It should be something like =SUMIFS(Expenses[Amount], Expenses[Category], A2, Expenses[Date], ">="&$F$1, Expenses[Date], "<"&EDATE($F$1,1)), not a typed number.
- Look for hard-coded values where a formula should be, such as an Actual figure typed in.
- Check that every category in your data appears, and that none is split by a spelling difference.
- Confirm that the grand total of Actual equals the total of your Amount column for the month.
- Make sure refunds and credits are treated as you intend.
What if Copilot gets it wrong?
Say exactly what is wrong in the next prompt: "Variance should be Budget minus Actual, and the Rent row is missing". If it still fails, build that one column by hand using the formulas above. Undo is always available, so keep a copy of the original file before you experiment.
Also ask it to explain what a formula does in plain words. If its explanation does not match what you want the cell to do, do not keep the formula.
Before you rely on it
Treat Copilot as a fast first draft. If you would rather not paste statements into a sheet at all, SpendixAI can import them and offers budgets on Pro, and its CSV download opens in Excel when you still want to work with a sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


