Property Records & TaxCompletion Statement Reconciliation

Did your completion statement add up, and where does each line go? A property transaction reconciliation template built on double-entry bookkeeping: type the amounts from your solicitor’s statement, the grid proves the deal line by line, and the journal to post comes out the other end — with the capital, finance-cost and revenue split for the CGT base cost and the SA105. Templates for a purchase, further advance, second charge, remortgage (like for like or capital raising) and disposal. Download it as Excel or PDF. Nothing is sent anywhere. Reviewed 11 September 2026.

Back to Free Tools
Enquire now

No obligation. We’re not your tax agent; this starts a conversation, not a commitment.

RECONCILE THE DEAL

Post your property transaction, line by line

Choose the transaction, then type one amount per line from your solicitor’s completion statement. Each line already knows which column it falls in and how it is classified, so the grid fills itself. When the debits equal the credits, the journal on the right is ready to post.

Handy to have: the completion statement from your solicitor and the mortgage offer. About ten minutes.

Please read. This page arranges figures you type in; it does not give tax advice. Whether a cost adds to what a property cost you or comes off this year’s rental profit can turn on the facts, and finance costs on residential lettings have their own restriction. If a line is large or unusual, ask your accountant. Landlord Tax Enquiry is not authorised or regulated by the Financial Conduct Authority; see our Financial Services page.
You have a reconciliation saved on this device.
1
The transactionSecurity property, reference, transaction type, completion date and who prepared it.
Transaction type

2
The gridType each amount once, in the Dr or Cr column where it appears on the completion statement. It is analysed into the Balance Sheet, P&L or Bank column on its own, and classified as capital or revenue where it is expenditure.
Scroll the grid
Nothing entered yet£0.00
Finished, or want to begin again?
Nothing is sent anywhere — it stays on this device.
Every line posted twice, and proved.
Change any amount and the proof updates.
Send us the completion statement and we return the journal.

Landlord Tax Enquiry reconciles completion statements, mortgage offers and rental records for landlords, in the format HMRC and lenders expect. Based in Hounslow, West London, working across England. Records, not advice.

Removed.
HOW IT WORKS

One Double-Entry Grid Proves Every Property Transaction

A property deal always balances. The price plus the costs equals the mortgage plus the money you put in. Post each line twice and the deal proves itself.

Posted once, analysed onceEach line is entered in the primary Dr or Cr column as it appears on the statement, and falls into one analysed column: Balance Sheet, P&L Account or Bank / Cash. The primary total must equal the analysed total, and debits must equal credits. When both hold, the transaction is proved.
Expenditure classificationCapital expenditure — the consideration, stamp duty, legal fees and disbursements on acquisition; agent and legal fees on disposal — forms the base cost under TCGA 1992 s38. Finance costs — every lender, valuation, broker and lender-legal charge, the ERC and any exit or deeds-release fee — are incidental costs of obtaining loan finance: revenue, and excluded from the base cost. Other revenue expenditure — insurance, apportionments — is deductible in full.
Section 24 and the finance costsThe restriction on finance costs for residential lettings held by an individual, partnership or trustee — ITTOIA 2005 s272A, known to every landlord as Section 24 — is why borrowing costs sit in their own column. Relief is a basic-rate tax reduction under s274A, not a deduction; a company is outside the restriction. Our Section 24 calculator shows the effect; our capital gains tax calculator takes the base cost this page produces.
Pre-commencement expenditureOn a purchase before the first letting, finance costs are treated as incurred on the day the property business commences, provided that falls within seven years and the expenditure would then have been allowable (ITTOIA 2005 s57 via s272; PIM2505). The purchase template asks whether the property has been let and carries the costs forward accordingly.
Six templatesPurchase and disposal carry a Capital Expend column; a further advance, a second charge and both re-mortgage templates do not, because nothing on those statements can be capital. The capital-raising template records the application of the funds released, because interest is allowable only to the extent the borrowing does not exceed the capital introduced to the business (PIM2105).
Bridging and retentionsA bridging redemption is split: principal to the loan account, rolled-up interest and exit fee to finance costs. A retention held back by the lender is a debtor until released.
DisposalThe carrying amount — original cost plus every enhancement capitalised since, per the fixed asset register — is transferred out of Property at cost, so the disposal account shows the profit or loss on disposal. For an individual that balance clears to capital, not to the rental profit and loss; the CGT computation is separate. Where CGT is payable on a UK residential disposal, the return and payment on account are due within 60 days of completion.
ChattelsFixtures and fittings apportioned out of the consideration are capital expenditure on a separate asset: outside SDLT and outside the base cost of the land, with their own CGT treatment. They are shown in the Capital Expend column marked † and excluded from the base-cost total.
Exchange before the year-endA deposit paid on exchange is a debtor at any year-end that falls before completion. Give the deposit line its own date and the journal keeps it as a separate dated posting.
VATIrrecoverable VAT follows the cost it relates to. On a commercial purchase where the seller has opted to tax, VAT on the price is capital if irrecoverable; a registered buyer recovering it posts to VAT recoverable instead.
Apportioning a solicitor’s billWhere one invoice covers the conveyancing and the charge, the conveyancing element is capital and the element for acting on the charge is a finance cost. Enter them on separate lines. On a refinance where one solicitor acts on the redemption and the new charge, the whole bill is a finance cost.
Legal costs elsewhereCosts that attach to the property are capital — acquisition, disposal, defending title, granting a long lease. Costs that attach to the loan or to the letting are revenue — any refinance, a rent review, arrears recovery, or eviction to re-let. Eviction to obtain vacant possession for a sale is an incidental cost of disposal, so capital.
Carrying the figures acrossSave the reconciliation and open the file on the portfolio spreadsheet, which adds the property with its base cost, updates the borrowing, or records the disposal; and on the annual property accounts, which posts the finance costs and revenue lines to the tax year and period of completion. The file carries the working with it, so nothing is retyped.
What the journal isThe netted movement on each account, by date, ready to post as one entry with the narrative shown. Proved means the postings balance; the classification of each line remains the preparer’s judgement, evidenced by the prepared-by and checked-by signatures. A record, not tax advice.
WHO IT IS FOR

One Reconciliation, Six Situations

Whatever brought you here — a purchase you never checked, a re-mortgage you are not sure how to treat, or an accountant asking for the completion statement — the same grid handles it.

Is stamp duty capital or revenue?Capital. It is part of what the property cost you, so it reduces the gain when you sell rather than your profit this year. The same goes for the price itself, the legal fees for buying, searches and Land Registry fees. Enter them and the page keeps them in the right pile.
Can I claim a mortgage arrangement fee?It is a cost of borrowing, not of the building. In your rental accounts it belongs with your other finance costs. Held in your own name and let residentially, finance costs do not come off the profit: they give relief at the basic rate instead. Held in a company, they come off in full.
Re-mortgage costs for a landlordThe early repayment charge, the new lender’s fee, the valuation, the legal fees and the broker fee are all costs of borrowing. Nothing on a re-mortgage adds to what the property cost. Choose Re-mortgage and the lines arrive set that way.
Completion statement for a saleEstate agent fees and the legal fees for selling come off the gain, so they belong with the cost. Paying off the mortgage is neither: it is just funding. Choose Selling and the page shows what actually reached your bank.
Buying through a limited companySame reconciliation, different tax. A company pays the higher rates of stamp duty on residential property — as does an individual acquiring an additional dwelling — and gets its finance costs in full, with no restriction. The split this page produces is the same; what your accountant does with it is not.
Done for you, from the statementLandlord Tax Enquiry reconciles completion statements, mortgage offers and rental records for landlords. Based in Hounslow, West London, working across England. We keep the working, so the figures stand up years later when you sell. Bookkeeping services. Records, not advice.
FAQs

Completion Statements: Your Questions

What is a completion statement?

The sheet your solicitor sends showing every penny of a property deal: the price, the tax, their fees, the mortgage money coming in, and the balance you had to send them. It is the single most important document for your records, and the one most landlords file without ever checking.

Why does a completion statement need reconciling?

Because the figures on it end up in three different places: what the property cost you, this year’s rental accounts, and your bank. Get the split wrong and you either pay tax you did not owe, or claim something you cannot. Posting every line twice — once as money out or in, once to where it lands — proves you have missed nothing.

What does “it proves” mean?

That everything going out equals everything coming in. A property deal always balances: the price plus the costs equals the mortgage plus your own money. If the two sides differ, a line is missing, entered twice, or on the wrong side. The page tells you the moment it balances.

Which costs add to what the property cost?

The price itself, stamp duty, the legal fees for buying, searches and Land Registry fees. On a sale, the estate agent and the legal fees for selling. These reduce the gain when you sell, so they save capital gains tax rather than income tax.

Which costs come off this year’s rental profit?

The costs of arranging the borrowing rather than of buying the building: the lender’s arrangement or product fee, the valuation, the broker fee, legal fees on a re-mortgage, and any early repayment charge. They go on the SA105 with your other expenses, subject to the restriction on finance costs for residential lettings.

What about a fee added to the loan?

Enter it twice, which is exactly what happened: once as a cost, and once as part of the advance. That is why the advance on your statement is larger than the money you actually received. The page handles it as two lines and still proves.

Can I use this for a re-mortgage or a sale?

Yes. Choose the kind of transaction at the top and the lines change: buying, a further advance, a re-mortgage, a second charge, or selling. Each starts with the lines that transaction normally has, and you can add or rename any of them.

Is this tax advice?

No. It is a record of what you entered, arranged the way an accountant would arrange it. Whether a particular cost is capital or revenue can turn on the facts, and the treatment of finance costs for residential property has its own rules. If a line is large or unusual, ask your accountant. Landlord Tax Enquiry is not authorised or regulated by the Financial Conduct Authority.

Are the lender’s fees really deductible?

Not in the way most people expect. They are costs of borrowing. If you own the property in your own name and let it residentially, finance costs do not come off your rental profit at all: you get relief at the basic rate instead. If a company owns it, they come off in full. The page keeps them in their own pile for that reason.

What if the lender held some money back?

Enter the whole advance as it appears on the offer, then enter the retention as a separate line. The advance on the offer, less the retention, is what reached your solicitor. Do it that way and the sheet proves, and your record matches the offer.

My statement covers two properties. What now?

Do one reconciliation for each. Split the shared lines — the legal fee, for instance — on a fair basis, usually by price, and say in Notes how you split them. Two proved sheets are worth far more than one muddled one.

Does it matter where my deposit came from?

To a lender, yes, always. Say in Notes whether it was savings, the sale of something, or a gift, and keep the evidence with this sheet. It is the first thing an underwriter asks about a completion statement.

Is a mortgage arrangement fee capital or revenue?

Revenue. It is an incidental cost of obtaining loan finance under ITTOIA 2005 s58, not part of the cost of the property, so it is excluded from the CGT base cost. On a residential letting held personally it falls within the Section 24 restriction and gives a basic-rate tax reduction rather than a deduction. Held in a company, it is deductible in full.

Are legal fees on a remortgage tax deductible?

They are a cost of borrowing, so revenue rather than capital — the same treatment as the arrangement fee. Only legal fees on the acquisition or the disposal of the property itself are capital. On a remortgage, a further advance or a second charge, every legal fee attaches to the loan.

What is the journal entry for buying a property?

Debit Property at cost with the price, stamp duty, legal fees and disbursements; debit Loan and finance costs with the lender and broker fees; credit Mortgage loan with the gross advance; credit Bank with the deposit and completion balance. The debits equal the credits, and the page produces exactly that journal, dated and narrated, from the completion statement.

How do I record a completion statement in my accounts?

Post each line once, as it appears on the statement, and analyse it once to the column it belongs in: what the property cost or what you owe, this year’s accounts, or the bank. When the two sides agree the statement is reconciled, and the netted journal is what you post. That is the whole method of this page.

Is my information saved or sent anywhere?

Nothing is sent to us or to anyone else. Your figures stay on this page unless you switch on Remember on this device, save them as a file, or download them as Excel or PDF.

Ready to talk it through? Send us the details

This is fixable — and you can do a lot of it yourself. For a straightforward case, the free tools take you through it step by step, no accountant needed. For the genuinely complex ones, a professional earns their keep — and we’re here if you want one, or if you’d simply rather not do it alone. The choice is yours.

There’s no charge to make contact and no obligation. Hands-on help starts from a fixed £450 case review, and the full price is always agreed with you before any work begins.

What’s your situation? (tick any that apply)

Share only what you’re comfortable with — we can fill in the rest on a call.

Consent

Marketing (optional)