If you have no idea of your total business spend at year end, the quickest way back is to rebuild it from bank statements, not from memory. Pull twelve months of statements, mark each line as business, private or shared, attach an invoice to each business line, and add by type. Expect an afternoon the first time, and about ten minutes a month once the habit exists.
Rebuild from the statements, not from memory
- Download every statement for the period from each account and card you used for work.
- Paste them into one sheet and sort by date.
- Delete transfers between your own accounts and any private spending that is clearly private.
- For each remaining line, add a type and a business share.
- Mark the lines where you do not yet have an invoice and chase them.
Which costs are accepted, how shared costs are treated, and which tax year applies depend on your country and on current rules. This article does not state any. Your accountant will.
Three columns of evidence
- Invoice found: yes or no.
- Reason: one sentence on why the cost was for the business.
- Share: the business part of a mixed cost, as a decimal.
A line with all three is a line you can defend. A line missing the reason or the invoice goes to a short list for follow up. By the time the list is empty, your total is reliable.
Worked example: a freelance translator's year
Say these are the totals after applying shares, in euros: software and dictionaries €780, coworking €1,140, train and flights €920, phone €288, training €450. Add them: 780 plus 1,140 is 1,920, plus 920 is 2,840, plus 288 is 3,128, plus 450 is 3,578.
| Type | Business amount | Running total |
|---|---|---|
| Software and dictionaries | €780 | €780 |
| Coworking | €1,140 | €1,920 |
| Travel | €920 | €2,840 |
| Phone, work share | €288 | €3,128 |
| Training | €450 | €3,578 |
The phone line is a made-up example: a bill of €720 for the year at a 40 percent work share gives 720 times 0.4, which is €288. The share needs a reason you can state in a sentence.
What does the summary formula look like?
With types in column C, business amounts in column F and dates in column A, one type for the calendar year is =SUMIFS($F$2:$F$700,$C$2:$C$700,"Coworking",$A$2:$A$700,">="&DATE(2026,1,1),$A$2:$A$700,"<="&DATE(2026,12,31)). If your tax year differs from the calendar year, change the two dates. Keep the type names identical everywhere, because SUMIFS treats Travel and Travels as different.
How do I prove the total?
Add the business amounts and the private amounts you deleted or marked as private, and compare to the sum of all debits. A gap points to a missing line. Refunds should be netted against the cost they refer to.
What if the invoices are in another language?
Add a short description in your own words in the Reason column, with the date and amount copied from the invoice. Do not rely on a translation tool to produce legal wording; use it only to understand what you bought. If your accountant needs official translations, they will say so. Meanwhile, keep the original file unchanged and put your own notes in the sheet, so nothing in the original is altered.
How do I keep the total stable as new invoices arrive?
Late invoices are common: a supplier may send December's bill in January. Decide with your accountant which date governs, the invoice date or the payment date, and use it consistently for every line. Write that choice at the top of the sheet. When a late invoice arrives, insert it with its true date, and check that the formulas still cover the row, which is why ranges that reach row 700 are safer than ranges that stop at your last entry.
Next steps
- Set a calendar reminder for the first of each month
- Create a folder per month for invoices
- Start the share notes now, not in December
Useful ideas start with a clearer picture of your own spending.
Explore your reports

