The most useful team spending by category report puts three numbers beside each category: what you planned, what was spent and the difference. You can build it in Google Sheets from a flat list of expenses using a QUERY formula, then add a budget column by hand. Below is the layout, with pounds throughout.
Why compare against a budget at all?
A total on its own tells a manager nothing. £3,263 might be fine or alarming. Beside a plan of £2,950, it is £313 over, and the question becomes where. A budget column turns a list into a conversation.
How do I build it in Google Sheets?
- In a sheet called Data, set columns A Date, B Category, C Member, D Amount in £.
- In a sheet called Report, enter =QUERY(Data!A2:D500, "select B, sum(D) where A >= date '2026-04-01' group by B label sum(D) 'Actual'", 0) in cell A2 to list each category with its total from April onward. Change the date as needed.
- Type your planned amounts in a column beside it.
- Variance in a third column: actual minus budget, for example =B2-C2.
- Share of total in a fourth: =B2/SUM($B$2:$B$20).
A date inside a QUERY must be written as date followed by the year-month-day in single quotes, as above. If your sheet stores dates as text, convert them first.
What does a finished report look like?
A made-up month for a five-person installation crew:
| Category | Budget | Actual | Variance |
|---|---|---|---|
| Fuel | £900 | £1,045 | +£145 |
| Tools | £400 | £310 | -£90 |
| Parts | £1,500 | £1,720 | +£220 |
| Parking | £150 | £188 | +£38 |
| Total | £2,950 | £3,263 | +£313 |
Check: budgets 900 + 400 + 1,500 + 150 = 2,950; actuals 1,045 + 310 + 1,720 + 188 = 3,263; variances 145 - 90 + 220 + 38 = 313, which equals 3,263 - 2,950.
How do I read a variance sensibly?
- Look at the size in pounds and the share of its own budget. Parking is only £38 over but that is about 25% of its £150 plan.
- Parts is £220 over; check whether one big job drove it.
- Tools being £90 under may only mean a purchase slipped into next month.
Under budget is not automatically good, and over budget is not automatically bad. Ask what happened.
When should I stop using a sheet?
When receipts, entries and approvals are scattered, a sheet creates more work than it saves. A tool that groups spend by category and by member and keeps receipts with each entry saves that effort. SpendixAI reports on spend this way, but it is built around India and INR, so we do not present it as a UK option.
How do I show the trend over several months?
Copy the Report tab each month and name it by month, such as Apr and May. In a Summary tab, pull the Actual total of each category from each month side by side. Three months in a row over budget on Parts is a pattern worth a conversation; one month is noise.
Add a line under the table saying which categories moved by more than a tenth of their budget, so the reader knows where to look first. Keep the same category list from month to month, or the comparison will not line up.
A column for the previous month's actual, next to this month's, is often all the trend a small team needs.
Month-end checklist
- Every row has a category and a member.
- Budget column unchanged since the start of the period.
- Variance totals equal actual minus budget.
- One sentence on the biggest overrun.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

