Two invoices arrive in the same week for the same rental property.
The first is £1,840 to replace a failed boiler with an equivalent modern unit. The second is £2,100 to replace a working but dated kitchen with a better one.
Both are property costs. Both are entirely legitimate. In most tax systems they are treated completely differently — one is generally a deductible repair in the year it occurs, the other is generally a capital improvement that affects your position when you eventually sell. Which is which depends on your jurisdiction and the specific facts, and getting it wrong in either direction has consequences.
A property expense log that records only date, vendor, and amount cannot tell you which is which. That is the design flaw in most of them.
The template
| Column | Example | Why it exists |
|---|---|---|
| Date | 2026-08-14 | Work date, not invoice date, where they differ |
| Property ID | FLAT-12-RIVERSIDE | Short, stable, never the full address |
| Vendor | Harrow Heating Ltd | As it appears on the invoice |
| Description | Replace failed combi boiler, like-for-like | Must describe the work, not the category |
| Amount | 1840.00 | Excluding tax if you reclaim it separately |
| Tax component | 368.00 | Separate column, because it is often reclaimed separately |
| Treatment | Repair | Repair / Improvement / Unsure |
| Treatment basis | Restored existing function, no upgrade | One line of reasoning, written now |
| Tenancy state | Tenanted | Occupied, void, or between tenancies |
| Invoice reference | HH-2026-4417 | For matching against the vendor's records |
| Receipt URL | link to image | The evidence itself |
Eleven columns. Four of them — description, treatment, treatment basis, and tenancy state — are the ones most logs omit, and they are the ones that carry all the information a tax position depends on.
Why "description" has to describe the work
"Boiler" is not a description. "Plumbing" is a category pretending to be a description.
The distinction that matters is usually captured in a handful of words: did the work restore something to its previous condition, or did it improve the property beyond that condition? Compare these pairs:
- "Replace failed combi boiler, like-for-like" versus "Replace working boiler, upgraded to higher output system"
- "Repaint hallway, same specification" versus "Repaint hallway after removing wall to enlarge room"
- "Replace three broken roof tiles" versus "Replace entire roof covering with upgraded material"
In each pair the first phrasing points towards a repair and the second towards an improvement. Neither is a conclusion — your jurisdiction's rules and your accountant decide that — but the words make the decision possible a year later. "Roof £4,200" does not.
Write the description from the invoice while the invoice is in front of you. Contractors' invoices are usually specific; the information loss happens when someone summarises it into a spreadsheet.
The "unsure" value is the point
Most logs force a binary at entry time, which produces a confident-looking column full of guesses.
Allow a third value. "Unsure" is honest, it is filterable, and it means your accountant can pull every ambiguous item in one view rather than reading the whole year. Practically, a log with thirty repairs, four improvements, and three unsures is far more useful than one with thirty-four repairs and three improvements where three of those classifications are coin flips.
The mixed invoice is the common hard case. A contractor replaces a rotten window frame (restoration) and, while scaffolding is up, adds a rooflight that was not there before (improvement), on one invoice for £5,600. The right move is to split the row using the invoice's own breakdown. If the invoice gives no breakdown, ask the contractor for one before you pay it. They will provide it, and after the fact they often will not.
Why tenancy state earns a column
Work done while a property is void, between tenancies, or before it was ever let can be treated differently from work done during a tenancy — particularly costs incurred to get a property into a lettable state for the first time, which in several jurisdictions are capital rather than deductible.
Recording occupied, void, or pre-first-let takes one dropdown selection and resolves an entire class of question that is otherwise answered by cross-referencing tenancy agreements against invoice dates.
A worked year on one property
Here is what the log for FLAT-12-RIVERSIDE looks like after a year, summarised:
| Treatment | Rows | Total |
|---|---|---|
| Repair | 14 | 3,260.00 |
| Improvement | 2 | 7,400.00 |
| Unsure | 3 | 1,115.00 |
Two things are immediately visible. First, the improvement total is more than double the repairs, which means the capital position on this property has moved materially and should be carried forward rather than forgotten — the figure you need when the property is eventually sold is being built here, one row at a time.
Second, three unsures totalling £1,115 is a ten-minute conversation with an accountant, not an afternoon. That is the whole return on the extra columns.
Running it across a portfolio
The property ID column is what makes multi-property reporting work, and the rule is to keep it short and stable. Full addresses break the moment somebody types "Flat 12, Riverside" instead of "Flat 12 Riverside", and sorting goes strange when properties share a street.
With a stable ID, a pivot table across property against treatment gives per-property repair and improvement totals in a few clicks, which is also the view that answers the portfolio question worth asking each year: which property is consuming maintenance out of proportion to its rent?
A property needing £3,200 of repairs against £11,000 of rent is behaving differently from one needing £400. The log is the only place that comparison exists.
Keeping it current
The log only works if rows appear within days of the work, because the description and treatment basis depend on information that decays. A fortnight after a job, most landlords can still recall whether the boiler was broken or merely old. Three months later, they cannot.
Scanning the invoice as it arrives — Scan2Sheet extracts the vendor, date, amount, and tax component into the row and links the image — removes the part of the job that gets deferred, leaving the description, treatment, and basis fields, which are the ones that need your judgement and take about twenty seconds.
Set the log up with the four extra columns before the next invoice arrives. Retrofitting a treatment basis onto a year of existing rows is the job this template is designed to prevent.