Keep your rent and expenses in a spreadsheet you already understand, get your quarterly Making Tax Digital figures ready automatically, and pay once, not every month.
- Microsoft Excel MVP
- AAT qualified
- part CIMA qualified
- Excel Ace since 2008
- one off price
Making Tax Digital is coming for landlords
From 6 April 2027, Making Tax Digital for Income Tax applies to landlords whose qualifying income is over £30,000, and from April 2028 that drops to £20,000. Qualifying income is your rent before expenses, plus any self employed income, so plenty of landlords with just one or two properties are in.
That means keeping digital records and sending HMRC a quarterly update four times a year. The good news? You don’t need to move your property finances into expensive monthly software to do it.
How the bookkeeping models work for landlords
1. Record as you go. Enter rent received and expenses (letting agent fees, repairs, insurance and more) into your bookkeeping spreadsheet.
2. Let the bookkeeping model do the maths. Your monthly profit and loss, estimated tax and quarterly totals build themselves. The formulas are locked and hidden, so nothing gets overwritten.
3. Submit through bridging software. When each quarterly deadline comes round, compatible bridging software reads your bookkeeping figures and sends them to HMRC.
Which bookkeeping model is right for your properties?
ACE Essentials, £249 + VAT. Perfect for most landlords with one or two properties and straightforward records: income and expenses, monthly profit and loss, estimated tax and your quarterly MTD figures.
ACE Professional, £449 + VAT. Everything in Essentials plus bank reconciliation for up to three accounts, a stronger audit trail and greater visibility of cash movements. Ideal for landlords with several properties or more than one account.
ACE Complete, £699 + VAT. Everything in Professional plus VAT return preparation, an interactive dashboard and management reporting. For larger portfolios, or landlords who are VAT registered.
£249.00
ACE Essentials provides everything you need to manage your bookkeeping in Excel whilst helping you prepare for Making Tax Digital (MTD).
£449.00
ACE Professional builds on the functionality of ACE Essentials by introducing powerful bank reconciliation features to help improve the accuracy of your bookkeeping.
£699.00
ACE Complete is our most comprehensive bookkeeping solution, providing everything included in ACE Professional together with advanced reporting, business dashboards and VAT functionality.
A real example
Sarah owns three rental properties and has always kept her figures in a spreadsheet. With ACE Professional she records rent and expenses as they happen, reconciles her accounts, and each quarter simply reviews her figures before sending them through her bridging software. (Sarah is an illustrative example, not a real client.) Read the full ACE Professional landlord walkthrough.
Why landlords choose a spreadsheet over a subscription
Pay once. One off price, with an optional annual compliance and update plan if you want each year’s rule changes built in. No tie in.
Own your records. Your file is yours. Stop paying a subscription elsewhere and you can lose access; with the bookkeeping models you keep everything.
No new system to learn. If you can type a figure into a cell, you can use the bookkeeping models.
About Traci
Built by an Excel expert. I’ve worked in accountancy since I was 17, I’m AAT qualified, part CIMA qualified and a Microsoft Excel MVP.
What my customers say
What my customers say
I did the mini Excel course with Traci - 20 mins a day for 5 days. Traci can squeeze so much into 20 mins, it helps that she talks fast! I was familiar with most of the areas that we covered but there were still lots of little tips that I picked up. Traci has a genuine excitement about all things Excel and her enthusiasm is infectious. I'd recommend her courses to anyone looking to upskill.
Traci is amazing!!
She helped me to add formulas to a huge spreadsheet I’ve designed to use in my NHS job.
In 30 minutes the spreadsheet was transformed into a useable, time saving and accurate piece of work.
I’m very grateful for her help.
Traci is approachable, kind and knows her stuff.
I recommend her to anyone struggling with anything in Excel. She is patient - she needed to be with me, taking her time to explain and ensure I understood.
Thanks again Traci 🥰
The 5-day 20 minute sessions were very informative and easy to follow.
I have recently been on Traci's Beginner, Intermediate and Advanced Excel Workshops. I didn't know spreadsheets could be so much fun and you could do so much with them, once you have got your head around one. Tracie makes working with a spreadsheet a joy instead of a task. Her cheerful approach and easy-going manner are both professional and a breath of fresh air.
I had several absolutely excellent Excel intermediate and advanced sessions with Traci. She is extremely knowledgeable and makes the sessions fun and interactive ~ both face to face and virtual. I would definitely recommend Traci if you need some Excel training ~ she's excellent!
Traci was excellent in her Basic Excel workshops - she was really patient and made a scary subject feel really easy! This was such a valuable course which I would recommend anyone to try.
Traci at Excel Ace really knows her stuff, I've been using an amazing spreadsheet daily that she designed many many years ago to keep track of the workshops we are delivering and all the finances and forecasting. I couldn't recommend her services highly enough, she is just fantastic and so helpful also.
Traci has been training a number of our staff via zoom over the past few weeks, and everyone has greatly benefited from her encyclopaedic knowledge of all things excel. Very approachable and bubbly, she makes what could be a very dry subject, easy and fun.
Traci has done several sessions of training for me and my staff at Bevie. Whilst remaining absolutely professional has brought a fresh lease of life to excel and the great training has allowed the team to big great things and make better use of their days. Thanks Traci!
I took part in Traci's advanced Excel workship and found her insights into spreadsheets very accessible and time saving. Would definitely recommend!
Tracie Williams is a master in her field. definitely recommend if you are looking to upskill your Excel Knowledge.
I loved the training, super engaging and fun! Traci is a lovely person to host the sessions.
Tracy’s courses are A ‘must do’ for all Excel users of all standards. First class!
Really enjoyed Traci’s teaching style, relaxed and informal, yet very knowledgeable. Would definitely recommend.
Traci is enthusiastic and always willing to help. Just don't get her on the subject of 'Index and Match'
Couldn't recommend highly enough, very helpful and showed great understanding of our processes to create a dynamic solution. Thank you
Very informative ,professional brilliantly set out I am looking forward to next sessions.
Brilliant service, would highly recommend to anyone
Frequently asked questions
Yes, once Making Tax Digital for Income Tax applies to you. From April 2027 that’s landlords with qualifying income over £30,000, and from April 2028 over £20,000. You’ll need to keep digital records and send quarterly updates through HMRC compatible software, which can be a spreadsheet linked to bridging software.
Yes. HMRC allows spreadsheets for record keeping, as long as they’re linked to compatible bridging software to send your quarterly updates. My Excel bookkeeping models prepare those figures for you.
Before. It’s your gross rent plus any self employed income, before any expenses or allowances are taken off.
You only count your share of the rent towards the threshold. So a property bringing in £24,000 a year, owned 50/50, counts as £12,000 each. Your file can be tailored to split the figures between owners.
Yes. You list each property in the set up sheet and allocate every rent payment to the right one. For costs and profit by property, I can tailor the file to suit you.
ACE Essentials is £249 + VAT, ACE Professional is £449 + VAT and ACE Complete is £699 + VAT, all one off. There’s an optional annual compliance and update plan from £79 + VAT a year.
Yes. The bookkeeping models prepare your figures in Excel, and HMRC compatible bridging software sends them to HMRC. I recommend My Tax Digital, which is free.
Your accountant can submit for you, but under MTD your records still need to be kept digitally and up to date through the year. The bookkeeping models give you, and your accountant, clean figures every quarter.
Not at all. The bookkeeping models are built so the formulas do the work. You just enter your rent and expenses, and everything else calculates for you.
Ready to get started?
Not sure which bookkeeping model fits your portfolio? Book a FREE Bookkeeping Demo and I’ll show you around and help you choose. And if Essentials is all you need, that’s exactly what I’ll tell you.