Turning messy Airbnb / Vrbo / Booking.com payout CSVs into per-property profit

Lawrence Locke — Sun, 21 Jun 2026 14:36:42 +0000

Hosts rarely have a single clean ledger. Revenue comes from one export, platform fees from another, and operating costs from a bank or card CSV. Each source uses different columns, currencies, fee structures, and date formats. HostPayout turns that pile into one per-property profit view. Here's the shape of the problem.

Four exports, four formats

Airbnb — payout CSVs: gross, host fee, taxes, adjustments, payout date
Vrbo — owner statements with their own column names
Booking.com — finance exports with commission and payout columns
Bank / card — free-form expense rows with no notion of "property"

None of them agree on headers, sign conventions (is a fee a negative number or a separate column?), currency, or how dates are written.

Step 1: normalize into one transaction model

Every row, from every file, maps onto the same record:

date — parsed to a real date regardless of source format
property — which unit it belongs to
type — income, platform fee, tax/adjustment, or expense
amount + currency — kept in the original currency

Getting sign conventions and currency right here is most of the battle: a "fee" is a negative amount in one export and a positive value in a separate column in another.

Step 2: assign to properties — and keep it editable

A bank CSV doesn't know which apartment a cleaning charge belongs to, so import isn't the end — it's a review step. You assign properties, fix anything miscategorized, and delete what doesn't belong before the numbers hit your reports. Rows stay editable afterward, so a mistake is a quick fix, not a locked-in error.

Step 3: roll up to monthly net profit per property

Once everything is normalized and assigned, the report is the easy part:

Income, platform fees, and expenses per property
Net profit per property, per month
A portfolio summary across all units

No workbook, no formulas to maintain — the same three-step loop every month.

Why not just connect the APIs?

Because CSV exports work in any country and currency, need no bank login or Plaid, and don't break when a platform changes its API. You upload a file you already have, review it, and see whether each property actually made money.

Try it with your own export: hostpayout.com.

Try HostPayout: Owner statement CSV tracking · Airbnb profit tracker · Booking.com profit tracker · Upload your CSV free

Why I built a CSV-first rental profit tracker — no Plaid, no bank login

Lawrence Locke — Sun, 21 Jun 2026 14:35:15 +0000

Most short-term-rental finance tools start the same way: connect your bank through Plaid, link your Airbnb account, grant a pile of OAuth scopes. If you're a host outside the US, or you just don't want to hand bank credentials to another SaaS, that's where the tool ends for you.

I wanted to see whether each property I run was actually making money — without any of that. So I built HostPayout to be CSV-first.

Start from the export you already have

Every platform already lets you download your numbers:

Airbnb — payout CSVs with host fees, taxes, and adjustments
Vrbo / Booking.com — owner statements and finance exports
Your bank or card — expense CSVs

You export the file, drag it in, and HostPayout does the rest. No account linking, no Plaid, no bank login.

Why CSV beats integrations (for this problem)

Works in any country and currency — not just US banks
No credentials shared — you only ever upload a file you already have
Nothing is locked — rows stay editable and deletable, so you can fix a miscategorized expense instead of living with it
Resilient — there's no integration to break when a platform changes its API

The workflow

Upload your CSV from a rental platform or your bank
Review transactions — assign properties, clean up expenses, fix anything unclear before saving
See real profit — income, expenses, and net profit by property, updated every month

That's the whole loop, and it's the same on every plan.

Free forever for the first 5 properties

The core import → review → report workflow is free for up to 5 properties, no credit card. If you outgrow that, paid tiers add more property room — and if paid access ever lapses, your existing data and reporting stay available.

Who it's for

Hosts and small operators who get revenue in one export, fees in another, and costs from a bank CSV — and just want one monthly view of whether each property is making money, without rebuilding a spreadsheet every month.

Try it with the export you already have: hostpayout.com.

Try HostPayout: Airbnb profit tracker · Vrbo expense tracking · Booking.com profit tracker · Try the CSV demo (no signup)

DEV Community: HostPayout