How to Turn Airbnb Transactions Into HMRC-Ready Reports

Last updated: March 2026

Your Airbnb transaction history is a wall of data. Dates, amounts, fees, currencies, refunds — all in a format that doesn’t match what HMRC expects. Turning that raw data into an HMRC-ready report is the gap most hosts struggle with. Here’s exactly how to bridge it.

The Gap Between Airbnb Data and HMRC Requirements

Airbnb gives you transaction data. HMRC wants a structured tax report. These are different things.

What Airbnb Provides

• Transaction date
• Booking amount
• Service fee
• Payout amount
• Guest name
• Listing name
• Currency

What HMRC Needs

• Gross income per property
• Allowable expenses categorised
• Property address and details
• Rental days vs personal use
• UK tax year alignment (6 April – 5 April)
• Figures in GBP

The conversion from one to the other is where mistakes happen.

Step 1: Export Your Airbnb Data

1. Log in to Airbnb
2. Go to Menu → Transactions
3. Set date range to the UK tax year: 6 April [year] to 5 April [year+1]
4. Click Export CSV
5. Save the file with a clear name (e.g. airbnb-2025-26.csv)

Step 2: Calculate Gross Income

Your CSV shows payouts (net of fees). You need gross income.

For each transaction:

Gross income = Payout + Service fee

Aggregate:

Total gross income = Sum of all (Payout + Service fee)

Handling Cleaning Fees

If Airbnb collects cleaning fees on your behalf, they’re included in the gross amount. If you pay cleaners separately, that’s an expense.

Step 3: Separate Platform Fees

Airbnb’s service fees are an allowable expense. Extract them:

Total platform fees = Sum of all service fees

These go in your expenses section, not your income.

Step 4: Organise by Property

If you have multiple properties, split the data:

• Group transactions by listing/property
• Calculate gross income per property
• Calculate platform fees per property

This is essential — HMRC requires property-level reporting.

Step 5: Add Allowable Expenses

Your Airbnb CSV doesn’t include:

• Cleaning costs (what you pay cleaners)
• Maintenance and repairs
• Insurance
• Mortgage interest
• Utilities
• Supplies

Gather these from your own records and add them per property.

Step 6: Handle Currency Conversions

If you received bookings in other currencies:

• Use HMRC’s average exchange rates for the tax year, or
• Use spot rates on the date of each transaction

Convert all figures to GBP before reporting.

Step 7: Account for Personal Use

If you used any property yourself, note those dates. You can only claim expenses for rental periods.

Step 8: Generate Your Report

For Self Assessment

Enter totals per property on the SA105 property income pages:

• Gross income per property
• Total expenses per property
• Net profit or loss

For Digital Platform Reporting

Generate OECD-compliant XML with:

• Property owner identification
• Gross income per property
• Number of transactions
• Property addresses

The Automated Way

Every step above is manual. It works, but it takes hours and is error-prone.

HMRC Reporter automates the entire process:

1. Upload your CSV — the software reads Airbnb’s format automatically
2. Gross income calculated — payout + fee, no manual math
3. Properties matched — links transactions to the right property
4. Fees extracted — platform fees separated as expenses
5. Expenses added — enter your own expenses per property
6. Report generated — SA105 figures or Digital Platform Reporting XML

What takes 2–4 hours manually takes minutes.

Learn more about HMRC Reporter →

Common Conversion Mistakes

Using the Wrong Date Range

Airbnb defaults to calendar year. HMRC uses the UK tax year (6 April – 5 April). Mismatch = incorrect figures.

Forgetting to Add Fees Back

The most common error. Your payout is net. HMRC wants gross.

Not Splitting by Property

Pooling all Airbnb income together makes it impossible to report per property.

Wrong Currency

Reporting in euros or dollars instead of GBP.

Missing Adjustments

Refunds, alterations, and cancellations affect your totals. Check your CSV for these entries.

Frequently Asked Questions

Q: Can I just use the Airbnb CSV as my HMRC report? A: No. The CSV is raw data in Airbnb’s format. HMRC needs structured property income figures in their required format.

Q: How long does manual conversion take? A: 2–4 hours for most hosts, longer for multiple properties or platforms. Software cuts this to minutes.

Q: What if I also use Booking.com? A: You need to combine data from both platforms. HMRC Reporter imports from 27+ platforms and consolidates automatically.

Q: Do I need to convert every transaction individually? A: Not necessarily. You can use total figures per property per tax year. But keep the detailed CSV for your records.

Q: What format does HMRC accept? A: For Self Assessment, you enter figures online. For Digital Platform Reporting, HMRC accepts OECD-compliant XML.

Skip the manual conversion. HMRC Reporter turns your Airbnb transactions into HMRC-ready reports automatically. Get started →