For a small team spread across countries, a spending by category report works best when it shows three things: euros by category, each category's share of the total, and the cost per person. A pivot table does it in a few clicks if the source list is tidy, and a conversion column handles receipts in other currencies.
How do I handle receipts in another currency?
Add two columns: Original amount with its currency, and Rate to euro. Then add Amount in € as original times rate. Keep the rate you actually used, from the card statement or the transfer record, so the number does not move later. As a made-up example, PLN 400 at a rate of 0.25 gives 400 x 0.25 = €100. Real rates differ, so take them from your own records.
How do I build the pivot table?
- Make a flat list with columns Date, Category, Member, Original, Currency, Rate and Amount in €.
- Select the whole list and insert a pivot table in Excel or Google Sheets.
- Put Category in rows, and Amount in € in values, summed.
- Add Member in columns if you want the per-person view.
- Add a second value field showing percent of grand total (Excel: Show Values As, then % of Grand Total; Sheets: Show as, then % of grand total).
If the pivot ignores your latest rows, extend the source range or refresh it.
What does the result look like?
Made-up figures for a four-person product team:
| Category | Total | Share | Per head (4 people) |
|---|---|---|---|
| Travel | €2,100 | 50% | €525 |
| Software | €1,260 | 30% | €315 |
| Events | €420 | 10% | €105 |
| Equipment | €420 | 10% | €105 |
| All categories | €4,200 | 100% | €1,050 |
Check: 2,100 + 1,260 + 420 + 420 = 4,200. Per head, 4,200 / 4 = 1,050, and the four category lines 525 + 315 + 105 + 105 add to the same.
Is cost per head always fair?
Not quite. If two people travel for clients and two do not, an even average hides the difference. Use per head to spot oddities, not to judge people. A second view by member shows who spent what, and a note on the biggest items explains why.
What should I do with the report?
- Send it with two lines: the biggest category and the biggest change since last month.
- Flag any category over its usual level for a quick check.
- Keep each month's file, so you can compare quarter by quarter.
When does a sheet stop being enough?
When many people add entries, a pivot you rebuild each month becomes a chore. A tool that records each expense with its own currency and shows totals in one base currency does the conversion step for you. SpendixAI works that way, but it is built around India and INR, so we do not offer it here for euro teams, and Pro covers one personal workspace, not a team.
How do I avoid double counting a foreign card charge?
A card charge and the receipt are the same spend. Enter the expense once, from whichever has the rate you want to use, and keep the other as supporting evidence. If you import card statements and also type receipts, tick off each statement line as it is matched.
Duplicates are the quiet reason a category total looks too high, so sort by amount and date and look for pairs that match. A column called Matched with Yes or No makes the check quick.
Before you share
- Rates recorded for every foreign receipt.
- Category spelling consistent.
- Totals agree across and down.
- Headcount used for per-head figures is correct.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


