UK Landlord Rental Income Spreadsheet 2026/27 | Finance-Cost Tax Reducer
NowPrice:$20.77
Original Price: $25.97
20% off
Sale ends on December 20
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
Keep a 2026/27 record as an individual UK landlord — rents, allowable expenses and finance costs — with a transparent Income Tax estimate and the basic-rate (20%) finance-cost tax reducer.
What you get
• SAMPLE and BLANK Excel workbooks
• Instructions, Dashboard, Settings, Properties, Rent received, Expenses, Finance costs, Tax estimate, Rates and dropdown lists
• Residential mortgage interest is not deducted from profit. The file may apply a 20% tax reducer in 2026/27, capped in line with the published rules. Commercial finance costs can still be deducted. You cannot use the £1,000 property allowance and the reducer in the same year.
• Class 4 National Insurance is not charged on property income and is shown as zero
• Official 2026/27 figures from GOV.UK, including the Personal Allowance of £12,570, Income Tax bands, the £1,000 property allowance, and the Rent a Room Scheme limits (£7,500 / £3,750 joint) noted on the Rates sheet
How to use it
1. Enter each property and choose Residential or Commercial.
2. On Settings, choose whether you will deduct expenses or use the property allowance.
3. Log rent, allowable expenses and finance costs. Do not put mortgage interest in Expenses.
4. Read the Dashboard. From April 2027, separate property tax rates are planned — check GOV.UK. Confirm current rules before you file.
Google Sheets: use File → Import → Upload. Core formulas use SUM, SUMIFS, IF, MIN, MAX, ROUND and SEARCH. Excel sheet protection often does not transfer — re-protect the Rates and workings sheets in Sheets if you want to. After importing, change one figure and confirm the Dashboard updates.
What this is not
It is not a filing tool, not company accounts, not a letting-agent statement, and not tax advice. It does not work out corporation tax, capital gains, stamp duty or the High Income Child Benefit Charge. Furnished holiday lettings relief has been abolished. If your affairs are complex, speak to a qualified accountant.
Disclaimer: This is a record-keeping and planning tool. Figures are estimates based on the amounts you enter and on HMRC rates published on GOV.UK as at 17 November 2026. It is not official HMRC or GOV.UK software, not tax, legal or financial advice, and not a substitute for a qualified accountant or for filing your Self Assessment return (or a VAT return) with HMRC. You are responsible for checking that rates, thresholds, dates and your own figures are current and correct. April Sixth is a trading name, not a government body.
Sources (checked 17 November 2026): https://www.gov.uk/guidance/income-tax-when-you-rent-out-a-property-working-out-your-rental-income · https://www.gov.uk/guidance/changes-to-tax-relief-for-residential-landlords-how-its-worked-out-including-case-studies · https://www.gov.uk/renting-out-a-property/paying-tax · https://www.gov.uk/rent-room-in-your-home · https://www.gov.uk/income-tax-rates · https://www.gov.uk/guidance/tax-free-allowances-on-property-and-trading-income
AI-assistance disclosure: This listing text and the spreadsheet were produced with assistance from AI tools, then reviewed, edited and tested by a person. Official rates and dates were checked against GOV.UK (17 November 2026) and the formulas were recalculated independently. This is not official HMRC software and is not tax advice.
File format: Microsoft Excel .xlsx (SAMPLE and BLANK). Instant digital download. No physical item will be sent.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
UK Employed Plus Side Hustle Tax Tracker Spreadsheet 2026/27 | Self Assessment
Sale Price $16.40
Original Price $20.50
-
Digital download
UK CIS Tax Spreadsheet for Subcontractors 2026/27 | Trades CIS Deduction & Tax Estimator
Sale Price $20.77
Original Price $25.97
-
Digital download
UK Tradesperson Job and Tax Bundle 2026/27 | CIS, Mileage and Invoice Log
Sale Price $27.34
Original Price $34.17
-
Digital download
UK Sole Trader Starter Bundle 2026/27 | Self Assessment Spreadsheet and Mileage Log
Sale Price $32.81
Original Price $41.01