Property Accounting & Landlord Bookkeeping: A Reconciliation Guide
Practical guidance for UK landlords and property managers on reconciling rental income, mortgage payments, and property expenses -- with worked examples and automation strategies.
Property landlords face a bookkeeping challenge quite unlike any other small business. Rental income arrives on fixed dates but through unpredictable channels -- direct from tenants, net of agent fees, or as housing benefit payments with their own timelines. Meanwhile, mortgage payments blend deductible interest with non-deductible capital repayment in a single direct debit. Throw in Section 24 restrictions, deposit accounting, and a mix of allowable and capital expenses, and you have a reconciliation problem that trips up even experienced bookkeepers. This guide breaks down exactly how to handle it.
Why Property Accounting Is Different
A landlord's bank account looks nothing like a typical sole trader's. There is no simple "revenue in, costs out" pattern. Instead, the same account might receive rent from three tenants, pay two different mortgage lenders, reimburse a plumber, and hold a tenant deposit that is not income at all. Each transaction type has its own tax treatment, and getting any of them wrong can mean an incorrect Self Assessment return.
Mixed Transaction Types
A single month's bank statement for a property landlord typically contains rent receipts, buy-to-let mortgage payments, buildings and contents insurance premiums, letting agent management fees, maintenance invoices, ground rent, service charges, and possibly a tenant deposit. Each must be categorised differently for tax purposes, and some -- like deposits -- are not income or expenditure at all.
Multiple Properties, Multiple Income Streams
Landlords with more than one property often run everything through a single bank account. That means distinguishing which rent payment belongs to which property, tracking expenses per property for the SA105 supplementary pages, and ensuring mortgage payments are allocated to the correct loan. Without clear labelling, the reconciliation becomes a forensic exercise every January.
Mortgage Interest vs Capital Repayment
Every repayment mortgage direct debit contains two components: interest and capital. Only the interest portion is relevant to your property income calculation (and even then, under Section 24 restrictions). Your lender's annual statement breaks this down, but your bank statement shows a single payment. You need to split it -- either monthly from your lender's schedule or annually from their tax certificate.
Section 24: The Mortgage Interest Restriction
Since April 2020, individual landlords (not limited companies) can no longer deduct mortgage interest as an expense. Instead, you receive a basic rate (20%) tax credit on your finance costs. This means if you are a higher-rate taxpayer, your effective tax relief on mortgage interest has been halved. The practical bookkeeping impact: you still need to track mortgage interest accurately, but it goes in a different box on your tax return (Box 44 of SA105 rather than the expenses section).
Tenant Deposits Are Not Income
When a tenant pays a deposit, it appears as income in your bank account. It is not. Under the Tenant Fees Act 2019, assured shorthold tenancy deposits must be protected in a government-backed scheme within 30 days. Deposits should be recorded as a liability, not revenue. When returned to the tenant, the outgoing payment is not an expense. If you retain part of a deposit for damages, only then does that retained portion become income. Getting this wrong inflates your reported rental income and your tax bill.
Worked Example: Monthly Reconciliation for a 3-Property Portfolio
Let us walk through a realistic January bank statement for a landlord with three buy-to-let properties. Two are managed by a letting agent (who deducts their 10% fee before paying over); one is managed directly.
January Bank Statement
| Date | Description | Amount | Category | Notes |
|---|---|---|---|---|
| 03 Jan | TENANT A - Standing Order | +£950.00 | Rental Income | Property 1 (self-managed) |
| 05 Jan | ABC Lettings - Rent | +£1,080.00 | Rental Income | Property 2 (£1,200 gross minus 10% agent fee) |
| 05 Jan | ABC Lettings - Rent | +£855.00 | Rental Income | Property 3 (£950 gross minus 10% agent fee) |
| 08 Jan | NATIONWIDE BS - Mortgage | -£487.32 | Finance Cost / Capital | Property 1 (£312.18 interest + £175.14 capital) |
| 08 Jan | HALIFAX - Mortgage DD | -£623.45 | Finance Cost / Capital | Properties 2 & 3 joint loan (£441.20 interest + £182.25 capital) |
| 12 Jan | ABC Lettings - Mgmt Fee | -£0.00 | Letting Agent Fee | Already deducted from rent (see lines 2-3) |
| 15 Jan | AVIVA - Insurance DD | -£47.50 | Insurance | Landlord insurance, Property 1 |
| 18 Jan | J SMITH PLUMBING | -£180.00 | Repairs & Maintenance | Boiler repair, Property 3 (revenue expenditure) |
| 25 Jan | GROUND RENT - PROPERTY 2 | -£125.00 | Ground Rent | Quarterly charge (leasehold flat) |
Monthly Summary
Gross rental income: £3,100.00 (£950 + £1,200 + £950)
Letting agent fees: £215.00 (deducted at source: £120 + £95)
Net rent received: £2,885.00
Mortgage interest (finance cost): £753.38
Mortgage capital repayment: £357.39 (not deductible)
Allowable expenses: £352.50 (insurance + repairs + ground rent)
Total allowable deductions: £567.50 (agent fees + expenses; interest reported separately under Section 24)
Notice how the bank statement alone does not tell the full story. The agent fee is invisible -- embedded in the net rent figure. The mortgage payments need splitting using your lender's schedule. And the gross rental income (which HMRC wants to see) is higher than what actually landed in the bank. This is precisely why property reconciliation demands more attention than a standard business.
Key Property Expense Categories
For Self Assessment purposes, HMRC distinguishes between allowable revenue expenses, finance costs, and capital expenditure. Getting transactions into the right category during reconciliation saves painful corrections at tax time.
Allowable Revenue Expenses
These are deducted directly from your rental income on the SA105:
- Repairs and maintenance -- fixing a broken boiler, repainting between tenancies, replacing a cracked window pane (like-for-like)
- Insurance -- landlord buildings, contents, and rent guarantee policies
- Letting agent fees -- management fees, tenant-finding fees, inventory costs
- Accountancy fees -- the cost of preparing your property accounts and tax return
- Ground rent and service charges -- for leasehold properties
- Utility bills -- only if you pay them (common in HMOs)
- Council tax -- only during void periods between tenancies
- Legal fees -- for renewing tenancies or eviction proceedings (not for property purchase)
- Travel costs -- mileage to inspect properties or meet tradespeople (45p per mile)
Capital vs Revenue: The Critical Distinction
HMRC draws a firm line between repairing something (revenue, deductible now) and improving it (capital, only relevant when you sell). Replacing a broken kitchen tap is a repair. Replacing the entire kitchen with a higher-spec one is an improvement. Repainting walls is a repair. Converting a loft into a bedroom is an improvement.
The test is whether you are restoring the property to its previous condition or making it substantially better. When reconciling, flag any large tradesperson invoices for this distinction -- it directly affects your current-year tax liability.
Finance Costs Under Section 24
For individual landlords (not companies), finance costs include mortgage interest, arrangement fees spread over the loan term, and interest on loans used to furnish the property. These are no longer deducted from rental income. Instead, they go in Box 44 of the SA105 and generate a 20% tax credit. You must still track them accurately -- they just appear in a different section of your return.
If you operate through a limited company, Section 24 does not apply and mortgage interest remains a fully deductible expense against rental profits. This is one reason many portfolio landlords have incorporated.
Reconciling Property Finances: A Step-by-Step Approach
1. Match Rent Received to Tenancy Agreements
Start each month by listing every expected rent payment -- the tenant name, expected amount, and expected date. Then work through your bank statement matching each deposit. Where rent is collected by an agent, match the net amount received to the gross rent minus the agreed commission percentage. Any shortfall could indicate a late payment, a partial payment, or an agent error.
For Housing Benefit or Universal Credit payments, allow extra matching tolerance. Local authority payments often arrive mid-month and may cover a different period than your tenancy calendar month. Label these clearly so they reconcile to the correct property and period.
2. Split Mortgage Payments
Obtain your lender's annual mortgage statement or monthly schedule. For each payment, record the interest component and the capital component separately. If you have a repayment mortgage, the split changes every month as the outstanding balance reduces. Interest-only mortgages are simpler -- the entire payment is interest (finance cost).
If you have a joint loan covering multiple properties (as in our worked example), you will also need to apportion the interest across the properties. HMRC accepts a reasonable apportionment -- typically based on the original purchase prices or outstanding balances.
3. Reconcile Agent Statements to Your Bank
Letting agents typically provide a monthly landlord statement showing gross rent collected, their management fee deduction, any maintenance costs they paid on your behalf, and the net amount transferred to you. This statement is your source document -- not the bank entry alone.
Cross-check three things: that the gross rent matches the tenancy agreement, that the agent's fee percentage is correct, and that the net bank deposit matches the statement total. Agents occasionally deduct costs you have not authorised, or apply the wrong fee rate. A monthly reconciliation catches these quickly rather than discovering them at year end.
4. Categorise and Allocate Every Expense
For each outgoing payment, determine: which property does it relate to? Is it an allowable expense, a finance cost, or capital expenditure? Is VAT applicable (most residential property expenses are not VAT-registered, but some contractor invoices include VAT that you cannot reclaim)?
Consistent categorisation month by month means your year-end totals for the SA105 are already prepared. The alternative -- dumping twelve months of bank statements into a pile every January -- is where most landlord bookkeeping goes wrong.
Common Property Reconciliation Pitfalls
Agent fee invisibility: When agents deduct fees before paying you, the fee never appears as a separate bank transaction. You must reconstruct the gross rent and the fee from the agent's statement, or your reported income will be understated.
Deposit confusion: Tenant deposits flowing into your account look like income. If you do not tag them as liabilities immediately, they inflate your rental income figure and your tax calculation.
Mixed personal and property use: Using the same bank account for personal spending and property income makes reconciliation significantly harder. A dedicated property bank account -- even a simple business current account -- eliminates this entirely.
Automating Property Bookkeeping
Property accounting is repetitive by nature. The same tenants pay the same rent on the same dates. The same mortgages, insurance premiums, and ground rents repeat every month or quarter. This predictability makes it an ideal candidate for automation.
CodeIQ: Automated Transaction Categorisation
Our intelligent AI bookkeeper, CodeIQ, learns from your general ledger history. After seeing one or two months of correctly categorised property transactions, it recognises patterns: "NATIONWIDE BS" is always a mortgage payment for Property 1, "ABC Lettings" is always net rent, "AVIVA" is always landlord insurance. From month three onward, it auto-categorises each transaction with the correct account code and VAT treatment -- completing a full month's bookkeeping in roughly two minutes.
For property landlords, this is particularly powerful because the transaction descriptions are so consistent. Rent receipts, mortgage payments, and insurance premiums repeat identically. CodeIQ picks up on these patterns faster than almost any other business type.
ReconcileIQ: Matching Bank to Books
Once transactions are categorised, ReconcileIQ handles the matching step -- comparing your accounting software records against your bank statement to flag anything that does not align. It catches the common property pitfalls: a rent payment that arrived late and fell into the next month, an agent statement that does not match the bank deposit, or a mortgage payment that differs from the expected amount because the lender changed the rate.
For landlords managing multiple properties through one bank account, the ability to upload both datasets and get an instant reconciliation report -- with unmatched items clearly highlighted -- saves hours of manual cross-checking.
Frequently Asked Questions
How do I reconcile rental income with my bank statements?
List each expected rent payment from your tenancy agreements, then match each one to a corresponding bank deposit. Account for any letting agent deductions -- if rent is collected by an agent, the bank deposit will be the gross rent minus the agent's percentage fee. Flag any missing or partial payments for follow-up with tenants or the agency.
What bookkeeping software is best for landlords in the UK?
Most UK landlords use general accounting software like Xero, QuickBooks, FreeAgent, or Sage. The best choice depends on portfolio size and whether you use a letting agent. For reconciliation specifically, tools like ReconcileIQ can match bank transactions to expected rents and expenses without requiring a full accounting platform.
How do I account for property expenses and mortgage payments?
Separate each mortgage payment into its interest and capital repayment components -- only the interest portion is a deductible finance cost (subject to Section 24 restrictions). Record property expenses like repairs, insurance, and letting agent fees as allowable deductions against rental income. Keep capital expenditure like extensions or improvements separate, as these are not deductible but affect Capital Gains Tax on disposal.
Can AI automate landlord bookkeeping and reconciliation?
Yes. AI-powered tools like CodeIQ can learn from your general ledger history to automatically categorise recurring property transactions -- rent received, mortgage payments, insurance, repairs -- and apply the correct tax codes. ReconcileIQ can then match your bank statement against your accounting records to flag discrepancies. Together they reduce a monthly property reconciliation from hours to minutes.
Simplify Your Property Bookkeeping
Whether you manage one buy-to-let or a portfolio of twenty, our tools handle the repetitive reconciliation so you can focus on your properties.
Try It Free