How to track Airbnb income and expenses without accounting software
Most hosts do not need QuickBooks. A short-term rental with one to five listings produces a few hundred transactions a year, and a well-structured spreadsheet handles that comfortably. What sinks hosts is structure: money gets recorded in the wrong shape, and by tax season nobody can reconstruct what happened. This guide gives you the shape.
Record three numbers per booking, never one
The single most common bookkeeping mistake hosts make is recording the bank deposit as income. The deposit is your subtotal minus the platform's host fee, which means your books quietly understate both your gross income and your deductible fees. Record each reservation as three numbers instead:
- The booking subtotal. Nightly rate times nights, plus cleaning and other guest fees. This is your gross income.
- The platform host fee. What Airbnb or Vrbo kept. This is a deductible commission expense.
- The payout. What actually landed in your bank. This is a check number, no more. When it differs from subtotal minus fee, something needs a second look.
Held this way, your books match how the IRS wants to see the money and every deposit becomes verifiable. Our host fee calculator shows the same math on a single booking.
Use expense categories that match Schedule E
Schedule E, the form most hosts file with, already defines the expense buckets. Using those exact buckets all year means your year-end summary is done before you start it:
| Category | Typical host examples |
|---|---|
| Cleaning and maintenance | Turnover cleans, deep cleans, hot tub service |
| Commissions and platform fees | Airbnb or Vrbo host fees, booking commissions |
| Supplies | Linens, coffee, soap, paper goods |
| Repairs | The plumber, the new door lock |
| Insurance | STR liability policy, umbrella policy |
| Utilities | Electric, water, internet, streaming |
| Property taxes and mortgage interest | From your county bill and lender statement |
Two habits make categories stick. First, categorize when you log the receipt, never in a year-end batch. Second, give shared costs their own label when you run several properties, so a bulk linen order is not silently attributed to one listing.
The weekly ten-minute rhythm
Bookkeeping fails as a project and succeeds as a habit. The workable rhythm for most hosts:
- Weekly, five minutes: log new bookings from your platform dashboard.
- Monthly, ten minutes: log receipts, then compare expected payouts against your bank. Investigate gaps while the booking is fresh enough to remember.
- Each January: update your mileage rate, roll the tax year forward, and hand your preparer one summary sheet.
What to do about mileage and lodging taxes
Trips to your rental for turnovers, repairs, and supply runs are deductible at the IRS standard mileage rate, but only if you keep a log with dates and purposes. Keep it in the same file as everything else. Lodging and occupancy taxes deserve their own checklist rather than a formula, because they stack differently in every state, county, and city. Confirm what your platform remits for your address and what remains yours, especially on direct bookings.
Where a spreadsheet beats an app, and where it does not
A purpose-built spreadsheet wins on cost, ownership, and transparency: you can see every formula, nothing expires, and your data never lives in someone else's subscription. Dedicated software starts to earn its monthly fee around six or more properties, once bank feeds and automation outweigh the simplicity of a file you control. Up to that point, structure matters more than software.