Bookkeeping for landlords: from bank statements to tax return

Landlord bookkeeping has a dirty secret: for most small portfolios, the bank statement already is the books. Rent arrives in the account; the mortgage, insurance, repairs and agent fees leave it. The system that works isn't a complicated app — it's getting those statements into a spreadsheet accurately, categorising once a quarter, and arriving at January with totals instead of dread.

The setup that saves everything downstream

One bank account per portfolio (or per property, if you like clean lines), used only for the rental business. Mixed personal-and-rental accounts are where landlord bookkeeping goes to die — every statement line needs an "is this rental?" decision before you even start categorising. If your account is currently mixed, the first improvement isn't software; it's opening a separate account and moving the standing orders.

From statements to data

Once a quarter, download the statement PDFs and convert them to a spreadsheet with NoRekey — or photograph the paper ones (that works too). Each conversion is checked against the statement's own opening and closing balances, so the rows you categorise are provably complete: no missing rent, no vanished repair bill. Drop the rows into our free reconciliation template if you want the month-by-month verdict, or straight into your working sheet.

Categorise for the tax return you'll actually file

UK landlords report income and expenses in familiar buckets — categorise statement lines directly into them and January becomes copying totals:

• Rental income — rent received (match against the tenancy schedule; note gaps).
• Agent fees and management costs
• Repairs and maintenance — the like-for-like fixes; improvements are capital and belong on their own list.
• Insurance — landlord, buildings, rent-guarantee.
• Mortgage interest — interest, not the full payment; your annual mortgage statement splits it. (Relief works via the 20% tax credit for individual landlords.)
• Rates, ground rent, service charges, utilities you pay directly.

Two flags while you categorise: deposits aren't income (they're the tenant's money held in a scheme), and transfers to your personal account aren't expenses — they're just you, paying you.

The January that takes an afternoon

With statements converted and categorised quarterly, year-end is: sum each category, check the year's statement balances reconcile end to end, and give the totals to whoever files the return — or type them into the property pages yourself. The record backing every number is the bank's own statement, which is exactly what an HMRC enquiry would ask for. Keep the PDFs; banks archive them for years, but your own copy is faster.

Portfolio growing past a spreadsheet? The same statement-first habit feeds property software or an accountant just as well — the format changes (CSV, OFX or Excel), the discipline doesn't.