Free spreadsheet for jointly owned rental property

Record rent and expenses once. The spreadsheet splits every line between two owners by their share and adds up the cumulative figures each of you needs for the four quarterly updates.

What it does

Set each owner's share for up to ten properties. Enter rent on the Income sheet and costs on the Expenses sheet. The Quarterly sheet then shows, for each owner, income and expenses from the start of the tax year to the end of each update period, with the date each update is due.

It works with standard update periods (6 April to 5 April) and calendar update periods (1 April to 31 March). Change one cell to switch.

What it does not do

A spreadsheet cannot send anything to HMRC by itself. If you must use Making Tax Digital, you need HMRC-recognised bridging software that reads your spreadsheet and sends the quarterly update, or full record-keeping software. HMRC keeps a list on GOV.UK: Choose the right software for Making Tax Digital for Income Tax.

Check with your bridging software how it wants the figures laid out before you rely on this layout, and do not retype figures by hand between the spreadsheet and the software.