Landlord accounting spreadsheet MTD for Income Tax (UK properties)

• Simple accounting spreadsheets for non-VAT registered landlords with up to 10 UK properties
• Full instructions included
• The spreadsheets are set up to record one tax year
• No bookkeeping experience required, simply record rental income, bankings & payments/expenses
• The layout, formulas & also the ‘predictive text’ feature of Excel will help reduce the time you need to spend on your property bookkeeping
• Expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
• Provides you with a detailed trading profit & loss account
• Rental income & expenses can be split depending on percentage ownership of each property
• Automatically calculates quarterly data for submitting to HMRC under the new Making Tax Digital for Income Tax (MTD for ITSA)
• This version only creates the quarterly data submissions for MTD, not the final submissions

• New for 26-27 – spreadsheets now include page to automatically generate quarterly data for submitting to HMRC under the new Making Tax Digital for Income Tax (MTD ITSA). Bridging software will be required to submit the data to HMRC, and we recommend the Excel Add-in Vitaltax (www.vitaltax.uk) , which is very easy to use. We supply 2 versions of the spreadsheet, with one version set up to automatically link data pages to Vitaltax for quick and easy quarterly submission

Pages include :

• Quarterly income sheets
• Bank & cash receipts
• Quarterly payments sheets
• Profit & Loss account per property (automatically generated)
• MTD submission data