A team spending by category report is a grid: categories down the side, team members across the top, and the dollar total where they meet. You can build one in Excel or Google Sheets from a flat list of expenses with four columns and a single SUMIFS formula. Here is the layout and a worked example.
What columns does the source list need?
- A: Date.
- B: Category (Travel, Software, Meals and so on).
- C: Member (the person who spent it).
- D: Amount in $.
Keep category names to a fixed list, and use a drop-down so "Meals" never becomes "meals" or "Meal". Everything downstream depends on consistent spelling.
What formula builds the grid?
Put categories in A2:A5 of a new sheet and member names in B1:D1. In B2 enter the formula below and fill right and down.
- =SUMIFS(Data!$D$2:$D$500, Data!$B$2:$B$500, $A2, Data!$C$2:$C$500, B$1)
- Row totals: =SUM(B2:D2)
- Column totals: =SUM(B2:B5)
Argument order matters: the range to add first, then pairs of range and criterion. The dollar signs lock the ranges, so they do not slide when you fill.
What does the finished report look like?
A made-up month for a three-person design team:
| Category | Ava | Ben | Cy | Total |
|---|---|---|---|---|
| Travel | $840 | $1,260 | $310 | $2,410 |
| Software | $120 | $95 | $240 | $455 |
| Meals | $210 | $180 | $75 | $465 |
| Total | $1,170 | $1,535 | $625 | $3,330 |
Check both ways: across, 2,410 + 455 + 465 = 3,330; down, 1,170 + 1,535 + 625 = 3,330. If the two do not agree, a row has a typo in the category or member name.
What should the manager look at first?
- Which category is the biggest share? Travel is 2,410 of 3,330, about 72%.
- Is anyone far from the rest? Ben's $1,535 is more than double Cy's $625, so ask why before assuming anything.
- Is the total close to what you planned for the month?
A difference is a question, not a verdict. Ben may simply have had a client trip.
When does a spreadsheet stop being enough?
A sheet works while one person keeps it and the team is small. Problems start when entries arrive late, receipts live elsewhere or two people edit at once. At that point, look for a tool that groups spend by category and member and keeps receipts with entries. SpendixAI does this kind of grouping, but it is built around India and INR, so it is not offered here as a US product, and Pro covers one personal workspace rather than a team.
How do I handle shared costs and refunds?
Give shared costs one member name, such as Team, so they do not inflate one person's column. For refunds, enter a negative amount in the same category, for example -$120 for a returned item, so the category total reflects what was actually spent. Add a Notes column for anything unusual.
Keep the sheet free of merged cells and blank rows, which break pivot tables and filters. Freeze the header row, and keep one tab for raw data and another for the report, so nobody types over a formula by accident.
If someone edits an old row after you have shared the report, the totals change silently. Protect the report tab, or save a dated copy of each month's grid before you send it.
What does a manager do with the report on Monday?
Pick one row and one column to question, not the whole grid. In the example, ask Ben about his $1,260 of travel and ask whether the software spend of $455 includes anything that renews automatically. Write down the answer next to the number. Over a few months the notes become a record of why spending moved, which is more useful than the numbers alone when a budget is being set.
A monthly routine
- Enter or import everything by the 3rd.
- Fix blanks and spelling.
- Refresh the grid and check both totals.
- Share the grid with a two-line comment.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

