Exporting Reports Your Accountant Wants

The single biggest time saver at tax return time is handing your accountant a clean, property-level export instead of a shoebox of receipts and a bank statement they have to categorise themselves. What "clean" actually means is specific: income and expenses split by property, matched to the right expense category, covering the full tax year, with supporting documents attached rather than promised separately by email.

This guide sets out exactly what most UK landlord accountants want to see, how to structure an export that avoids back-and-forth queries, common mistakes that slow the process down, and how to prepare if you are moving from a shoebox-and-spreadsheet approach to something more structured.

What accountants actually want

Ask most UK landlord accountants what makes a client's year-end handoff easy, and the answer is rarely about the software you use, it is about whether the underlying data is already organised in a way that maps onto a tax return. In practice, that means:

• Income and expenses split by property, not one combined total for the whole portfolio. Self Assessment property pages ask for portfolio-level totals, but your accountant still needs the property-level detail to sanity-check the figures and to advise you on anything unusual, such as a property that ran at a loss for the year.
• Expenses categorised against the right allowable categories, roughly matching how HMRC's property pages are structured: repairs and maintenance, mortgage interest (subject to the finance cost restriction), letting agent and management fees, insurance, ground rent and service charges, and other allowable running costs. Our landlord allowable expenses guide covers what falls into each category and what does not.
• A full tax year of data, 6 April to 5 April, not a calendar year or a partial period with gaps where a bank feed was disconnected or a receipt was never logged.
• Supporting documents for larger or unusual items, particularly capital expenditure, major repairs, or anything that might need judgement about whether it is a revenue expense or a capital one.
• A note on anything that changed during the year, a property bought or sold, a period it stood empty, or a change in mortgage. Numbers alone do not always tell that story, and a short note saves your accountant a query email.

Structuring the export

A useful way to think about it is: if you handed this export to an accountant who had never spoken to you before, could they prepare an accurate return from it without asking a single follow-up question? That is a high bar, but it is the right one to aim for.

A well-structured export typically includes:

1. A property-by-property summary, total rental income and total allowable expenses for each property for the tax year.
2. A transaction-level detail sheet or export, every individual income and expense item, dated, categorised, and tagged to the correct property.
3. Capital expenditure listed separately from revenue expenses, since the tax treatment differs and mixing the two is one of the most common sources of an incorrect return. Our guide to common landlord tax mistakes covers this distinction in more detail.
4. Mortgage interest figures isolated from mortgage capital repayments, since only the interest element is relevant for the finance cost calculation, and capital repayment amounts are not an allowable expense at all.
5. Supporting documents attached or referenced, ideally with a consistent naming or filing structure so a specific receipt or invoice can be found quickly if your accountant asks about it.

Common mistakes

• Exporting a bank statement instead of categorised transactions. A raw statement tells your accountant what moved through the account, not what it was for, which means they end up doing the categorisation work you could have done yourself as it happened, usually at a higher hourly cost.
• Mixing personal and rental transactions in the same account. This is the single most common source of a messy handoff, since it forces your accountant to manually separate personal spending from business expenses line by line.
• Leaving capital items uncategorised. A new boiler, a loft conversion, or a full rewire needs different tax treatment from a routine repair, and getting this wrong is a common trigger for HMRC queries later.
• Sending data in several different formats or from several different sources. A spreadsheet for one property, a different app's export for another, and a folder of loose receipts for a third all add reconciliation time your accountant will likely charge for.
• Waiting until January to compile the year. Reconstructing twelve months of transactions from memory and old statements takes far longer than exporting figures that were categorised as they happened throughout the year, and increases the risk of missing something entirely.

Preparing for a cleaner handoff

If your current process is closer to a shoebox than a structured export, the fix is not a single big effort in January, it is a habit change earlier in the year:

• Separate rental banking from personal banking if you have not already, since this alone removes most of the manual sorting work later.
• Categorise transactions as they clear rather than in a batch at year end, using bank feeds where possible so the categorisation happens close to real time.
• File supporting documents against the transaction they relate to as you go, rather than in a general folder you have to search later.
• Ask your accountant directly what export format or structure they prefer, since some have a template or a preferred software connection that saves you guessing.

Making Tax Digital for Income Tax is accelerating this shift for landlords above the relevant income thresholds, since quarterly submissions require the same categorised, up-to-date records this guide describes, just on a more frequent cycle. Our Making Tax Digital software checklist covers what to check if you are moving toward quarterly reporting specifically.

Timing the handoff

Even with clean, categorised records throughout the year, it helps to agree a rough timeline with your accountant rather than sending everything the week before the Self Assessment deadline. Many accountants prefer to receive a full export by early autumn, well before the January rush, since it gives them time to raise a query about an unusual transaction while you can still remember the context, rather than trying to reconstruct it months later under deadline pressure. Ask your accountant directly when they would like to receive your export, and whether they prefer one full-year submission or interim exports partway through the year, since preferences vary between firms and it is a five-minute conversation that can save both of you time later.

A final practical point: keep a copy of whatever you send, in the same categorised, property-level format, even after your accountant has filed the return. If HMRC opens a query on a later return, or you need to check a previous year's figures for a mortgage application or a sale, having your own copy of a clean export saves you asking your accountant to dig it out of their own records.

How Property HQ helps

Property HQ categorises income and expenses by property as transactions clear through Open Banking, keeps capital items separate from revenue expenses, and produces a property-level export structured toward exactly what most UK landlord accountants ask for, so year end is a review and send step rather than a reconstruction project.

Disclaimer

This guide is general information for UK landlords, not tax advice. Every accountant's preferred format differs slightly - confirm what yours needs, and check current allowable expense rules on GOV.UK or with a qualified adviser.