The Easiest Way to Organise Property Income for HMRC

Last updated: March 2026

Organising property income for HMRC doesn’t need to be complicated. Most property managers overcomplicate it — spreadsheets with dozens of tabs, folders full of CSVs, receipts in shoeboxes. There’s a simpler way. Here’s the easiest system for staying organised and compliant.

The Simple System

You need to track three things:

1. Income — what came in, from which platform, for which property
2. Expenses — what you spent, on which property, for what purpose
3. Property details — address, ownership, personal use days

That’s it. Everything else is a derived calculation.

Step 1: One Place for Everything

Stop scattering data across:

• Desktop spreadsheets
• Email attachments
• Phone photos of receipts
• Platform dashboards
• Bank statements

Pick one system and use it for everything.

Option A: Software (Recommended)

HMRC Reporter — one platform for income import, expense tracking, and report generation.

Option B: Structured Spreadsheet

If you prefer a spreadsheet, at least structure it properly:

• Tab 1: Properties (name, address, ownership)
• Tab 2: Income (date, platform, property, gross amount, fees)
• Tab 3: Expenses (date, property, category, amount, receipt reference)
• Tab 4: Personal use (property, dates)

Step 2: Import, Don’t Enter

Manual data entry is where things go wrong. Instead:

Import Platform Data

Download CSVs from Airbnb, Booking.com, VRBO — and upload them to your system.

With software: Upload and it handles everything automatically.

With spreadsheet: Copy-paste into your income tab, then calculate gross income.

Import Bank Data

Download bank statements and match against expenses. Most banks let you export CSVs.

Step 3: Categorise Consistently

Use the same expense categories every time:

• Cleaning
• Maintenance and repairs
• Insurance
• Mortgage interest
• Utilities
• Council tax
• Platform fees
• Management fees
• Supplies
• Professional fees

Don’t create new categories on the fly. Consistency makes year-end reporting simple.

Step 4: Record as You Go

Don’t batch everything at year-end. Record:

• Income: Monthly, when you import platform data
• Expenses: As they happen (photograph receipts immediately)
• Personal use: When you use the property

The Monthly Routine (15–30 minutes)

1. Import this month’s platform data
2. Add any new expenses
3. Reconcile with bank statement
4. Check for missing entries

Total: 15–30 minutes per month. No year-end panic.

Step 5: Generate, Don’t Calculate

When it’s time to file (Self Assessment or MTD quarterly submission):

With Software

• Click “Generate Report”
• Review the output
• Submit to HMRC

With Spreadsheet

• Sum income per property
• Sum expenses per property
• Calculate net profit
• Enter into Self Assessment

The difference: minutes vs hours.

The Easiest Option: Full Automation

HMRC Reporter automates the entire process:

1. Import: Upload platform CSVs — gross income calculated automatically
2. Track: Add expenses per property with categories
3. Generate: One-click HMRC reports (SA105 figures or Digital Platform Reporting XML)
4. Submit: Direct to HMRC or export for your accountant

No spreadsheets. No manual calculations. No year-end scramble.

Learn more about HMRC Reporter →

Organisation Tips

For Receipts

• Photograph immediately
• Store in a dedicated folder (phone or cloud)
• Name files clearly: 2025-06-15-cleaning-123-main-street.jpg

For Platform Data

• Download CSVs monthly
• Store in folders by tax year
• Keep original files as backup

For Property Details

• Record once and update only when things change
• Include: address, ownership split, listing URLs, letting type

For Personal Use

• Note dates as they happen
• Update at the end of each month
• Don’t try to remember at year-end

Common Organisation Mistakes

1. “I’ll Sort It at Year-End”

This leads to missing receipts, forgotten expenses, and errors. Record monthly.

2. Mixing Personal and Business

Keep property income and expenses separate from personal finances. Use a dedicated bank account if possible.

3. Inconsistent Naming

One month you call it “cleaning,” next month “housekeeping.” Pick a name and stick with it.

4. No Backup

If your spreadsheet dies or your laptop is stolen, you lose everything. Use cloud storage or software with automatic backup.

5. Ignoring Small Expenses

That £15 for welcome pack supplies adds up. Record everything.

Frequently Asked Questions

Q: What’s the minimum I need to track? A: Gross income per platform per property, expenses per property, and property details. That’s the minimum for HMRC compliance.

Q: Do I need a separate bank account? A: Not legally, but it makes tracking much easier. Property income and expenses in one account, personal in another.

Q: How long does monthly organisation take? A: 15–30 minutes with software. 1–2 hours with a spreadsheet.

Q: What if I’ve been disorganised until now? A: Start now. Download platform CSVs for the current tax year, enter expenses you can find, and build the habit going forward.

Q: What’s the easiest system overall? A: HMRC Reporter — import, track, generate, submit. Everything in one place.

Simplify your property income tracking. HMRC Reporter keeps everything organised and generates HMRC-ready reports. Get started →