A European receipt can carry several tax percentages in one purchase, so the cleanest design is categories for what you bought and separate columns for the tax percentage, the tax amount and a flag to confirm. Mixing the percentage into the category name multiplies your categories and ages badly.
Why not a category per tax percentage?
Imagine categories called Supplies 10 percent and Supplies 20 percent. When a rule changes, or a supplier moves an item between lines, you rename categories and old records no longer match. Keep Supplies as one category and record the percentage per row.
What does a split invoice look like?
The percentages below are invented to show the arithmetic.
| Line | Net | Tax percent | Tax | Total |
|---|---|---|---|---|
| Printing | €100 | 10 | €10 | €110 |
| Courier | €40 | 20 | €8 | €48 |
| Invoice total | €140 | n/a | €18 | €158 |
Check: 100 + 40 = 140 net; 10 + 8 = 18 tax; 140 + 18 = 158 total. One invoice becomes two rows in two categories, Printing and Courier, which is how you keep both the cost and the tax right.
Which flags should a category carry?
- Tax line present: whether receipts for this category normally show a tax amount.
- Confirm recoverability: leave as to confirm until your adviser says otherwise.
- Business share: a percentage where use is mixed.
- Country note: where a supplier is based in another country, a reminder that the treatment may differ.
None of these states what is allowed. Rules differ by country and change, so confirm with your accountant or the official source before treating any flag as settled.
What if the invoice shows only a total?
Record the total, leave the tax and net blank, and set the flag to missing tax detail. Ask the supplier for a proper invoice instead of reverse-calculating from a guessed percentage; a wrong back-calculation is worse than a blank.
How do you total tax by category?
In a spreadsheet with categories in B and tax amounts in E, =SUMIFS($E$2:$E$500;$B$2:$B$500;"Courier") adds the tax for one category. The semicolon is the argument separator in many European regional settings; use a comma if your sheet expects one.
How do you deal with suppliers in other countries?
Keep a country column next to the supplier. When a receipt comes from a supplier abroad, the tax line may be different or absent, and the treatment may differ too. You do not need to know the answer; you need to flag the row so your accountant can see it. Add the currency of the invoice as well if it differs from your own.
- Supplier country.
- Invoice currency and the amount in euros.
- Whether a tax line is shown.
- A confirm flag until you have an answer.
Round-trip checks are valuable with split invoices. After entering both rows, add their totals and compare with the paper total: in the earlier example, 110 plus 48 should equal 158. A difference of a few cents usually means a rounding choice by the supplier; a larger one means a typing error.
Keep the flag list short. Three columns are enough for most households and sole traders: tax percentage, tax amount and a confirm marker. Extra columns tend to be filled in for two weeks and then ignored, and a half-filled column is more misleading than none because it looks complete when it is not.
Where does a tool fit?
SpendixAI lets each category carry a GST rate, an ITC-eligible setting and a tax-deductible setting, with reports that estimate the GST inside spending. It is built around India and INR, so in euros this article's spreadsheet method is the one to follow.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

