5 Bookkeeping Mistakes in DIY Property Xero Setups

The five most common mistakes in a DIY property Xero file are: no tracking per property, capital costs coded as repairs, agent statements booked as one net line, an unreconciled director’s loan account, and bank feeds that pull in but never get reconciled. Each one is cheap to fix early and expensive to leave. We review property Xero files every week, and these five show up again and again.

A quick note first. We take on clients who already had Xero, with receipts uploaded and the bank feed connected, but nothing else happening. That is a Xero subscription used as an expensive document folder. The software was fine. Nobody was managing the day to day. Here is where it goes wrong.

1. No tracking categories per property

Without a tracking category per property, everything lands in one lump and you cannot see which property makes money and which quietly loses it. Profit per property, not per portfolio, is the whole point of proper property bookkeeping. Xero does this well once it is set up. Most DIY files never turn it on.

2. Capital costs coded to repairs

A £15,000 refit coded to repairs goes straight to your profit and loss instead of the balance sheet. A new laptop and phone expensed in one go instead of being treated as an asset. This gets your tax wrong in more than one direction: it can overstate this year’s costs and understate the base cost that reduces your capital gains tax when you sell. The repairs-versus-capital line is where property bookkeeping earns its keep.

3. Agent statements booked as one net rent line

When you book a letting agent’s statement as a single net figure, the gross rent disappears, the agent’s fee disappears, and any maintenance the agent paid on your behalf disappears with it. You lose the detail HMRC expects and the deductions you are entitled to. Each statement should be split out.

4. Director’s loan account never reconciled

If you move money in and out of your company personally without recording what is a director’s loan, what is salary and what is dividend, year-end becomes a mess. Worse, an overdrawn director’s loan account can trigger a real tax charge (a section 455 charge) that catches people out. Reconcile it monthly and it is a non-issue.

5. Bank feeds connected but nothing reconciled monthly

The feed pulls transactions in, nobody codes them, and by year-end you have nine months of uncoded entries and no memory of what half of them were. Reconciling monthly, while you still remember, is the single habit that keeps a property file clean.

The common thread

Every one of these is fixable if you catch it early, and expensive if you do not. The tool is not the problem. Someone actually managing the file month to month is what turns Xero from expensive storage into real insight. We set every property client up on our own custom chart of accounts, built for landlords, investors and developers, so the numbers are structured the way property actually works. That clarity is where the savings come from. By spotting missing expenses and mis-coded transactions we have saved clients thousands of pounds in tax. Two records people always forget: your final mortgage offer (the product and arrangement fees on it can save a lot of tax) and your annual mortgage statement (on a repayment mortgage we need it to split the interest from the capital).

Thinking of moving on from a hands-off accountant? Here’s how to switch property accountants without the headache.

Frequently asked questions