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.
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.
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.
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.
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.
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.