MTD Software Spreadsheet

[Wings]

I have spent most of the past week viewing MTD software, and/or on software webinars.

As a landlord I/we record our rental income and expenses on an excel spreadsheets, then at the end of the tax year complete and file our tax assessments, which I have just completed for tax year 2025/26.

I am not looking for MTD software that bridges between a bank account or an excel spreadsheet, but software has its own type excel spreadsheet. That also allows just the listing of rental income and outgoing expenses, and at the end of the tax year divides joint income and outgoings, that then separate net rental income for both myself and my wife, and files the same to HMR&C.

[Ham_and_Jam]

Normal practice if you don t want to buy accounting software is to build yourself a simple spreadsheet and then use bridging software to export that to HMRC.

It sounds like you already have the spreadsheet, so why not use that? Unless I’ve misread your OP.

[Mr Pointy]

OP, you aren't going to find want you want - it's way too custom a requirement. Even HMRC can't work out how to to run MTD for more than one person per filing which is why Partnerships are excluded from MTD. The best you can do is run two spreadsheets & MTD bridging software per return.

Note the quarterly filings are cumulative & there is no longer an annual SA return where you account of all of your other income & allowances - you'll have to do that on the fifth MTD return.

[Wings]

Thanks for the advice, following the same and looking at https://mytaxdigital.co.uk/

[Big_Dog]

I am doing something similar using Freeagent. Seems to be working well.
I think HMRCs plan is that we don't what you (and I) want to do.
I have linked Freeagent with my business account for the quarterlies and am going to use my spreadsheet for the accountant for the yearlies.

[Mr Pointy]

Big_Dog said:

I am doing something similar using Freeagent. Seems to be working well.
I think HMRCs plan is that we don't what you (and I) want to do.
I have linked Freeagent with my business account for the quarterlies and am going to use my spreadsheet for the accountant for the yearlies.

I thought that the final submission was based on the quarterly returns plus adjustments so is your accountant using Freeagent as well? I didn't think the usual Self Assessment return was availble if you are subject to MTD.