Airbnb bookkeeping: track income and expenses for free
How to keep simple books for a short-term rental: income from each booking site, expense categories, receipts, profit per property and an export for your accountant.
Operations · · 6 min read · By StayPerk Team · Updated
See it live
Open a sample year of Books for three made-up places: income and expenses by month, a profit and loss, and each place on its own. You can export the CSV or print the summary. No account needed.
Quick answer
Simple rental books in four habits
Record each booking's gross earnings and the platform fee, not just the payout. Put every expense in a rental category against the property it belongs to. Keep the receipt and note where it is. Once a year, export the rows and a profit and loss summary per property for your accountant.
This page is general information for hosts, not tax or legal advice. What counts as income, which costs you can deduct and how long to keep records depend on your country, your region and how you use the property. Check with an accountant or your tax authority before you file.
Record income from every platform
A payout to your bank often covers several reservations, and the booking site has already taken its fee. If you record only the payout, your income looks smaller and the fee disappears from your expenses. Record each reservation instead: the gross earnings (nightly rate plus cleaning fee), the host fee the site kept, and the net that reached your bank.
- Airbnb: export your transaction history from Earnings as a CSV for the year. It lists each reservation with its confirmation code, listing, amount and fees.
- Vrbo and Booking.com: download the payout or reservation report for the year. Column names differ, but each has a reservation number, dates, the amount and the commission.
- Direct bookings: record the amount the guest paid, the card processing fee and any booking page fee (StayPerk's is 1% when guests pay online).
- Other income: damage reimbursements, add-ons you sell to guests, and resolution payments.
Use the confirmation code as the key. If a reservation is already in your books, a second import of the same file should skip it rather than count it twice. Payout rows (the transfer to your bank) should be skipped too, because their reservations are already counted.
Expense categories for short-term rentals
| Category | Examples |
|---|---|
| Cleaning | Cleaners, laundry, linen service |
| Supplies | Toiletries, coffee, paper goods, cleaning products |
| Repairs and maintenance | Handyman, plumber, pest control, replacing a broken lock |
| Utilities | Electricity, water, gas, waste collection |
| Internet and TV | Broadband, streaming services for guests |
| Insurance | Short-term rental or landlord insurance |
| Mortgage interest or rent | Interest on the loan for the property, or rent if you sublet |
| Property tax | Property tax, council tax, rates, HOA or service charges |
| Platform and card fees | Airbnb, Vrbo and Booking.com host fees, card processing |
| Software and subscriptions | Channel managers, pricing tools, smart lock apps |
| Furnishings and equipment | Beds, sofas, appliances, kitchenware |
| Travel | Trips to the property for turnovers or repairs |
Common short-term rental expense categories
Cleaning
- Examples
- Cleaners, laundry, linen service
Supplies
- Examples
- Toiletries, coffee, paper goods, cleaning products
Repairs and maintenance
- Examples
- Handyman, plumber, pest control, replacing a broken lock
Utilities
- Examples
- Electricity, water, gas, waste collection
Internet and TV
- Examples
- Broadband, streaming services for guests
Insurance
- Examples
- Short-term rental or landlord insurance
Mortgage interest or rent
- Examples
- Interest on the loan for the property, or rent if you sublet
Property tax
- Examples
- Property tax, council tax, rates, HOA or service charges
Platform and card fees
- Examples
- Airbnb, Vrbo and Booking.com host fees, card processing
Software and subscriptions
- Examples
- Channel managers, pricing tools, smart lock apps
Furnishings and equipment
- Examples
- Beds, sofas, appliances, kitchenware
Travel
- Examples
- Trips to the property for turnovers or repairs
Whether a cost is deductible, and whether a large purchase is spread over several years, depends on your tax rules. Repairs and improvements are usually treated differently.
In the US, IRS Publication 527 covers residential rental property, including vacation homes, and explains that repairs and improvements are treated differently. IRS Topic 415 explains how personal use of the home changes what you report. In the UK, HMRC's guide to working out your rental income lists allowable expenses, and GOV.UK explains the £1,000 property allowance. In Canada, see the CRA's T4036 Rental Income guide.
Split shared costs by property. If you run two listings, put each cleaning, repair and bill against the property it belongs to, so you can see which one makes money. A cost that covers both, such as a software subscription, can go on the property you use most, or be split by a rule you apply every year.
Keep receipts you can find again
- Save every receipt and invoice: a photo, the email or the PDF.
- Write a short note with each expense saying where the receipt is, such as "Email from the hardware store, 14 March".
- Keep one folder per year, with the booking site reports in it.
- Set up repeating costs once (internet, insurance, mortgage) so each month is recorded without retyping.
How long to keep records depends on where you file. The IRS says three years in the usual case and longer in some situations (How long should I keep records?). HMRC asks landlords to keep records for at least five years after the 31 January deadline for the tax year (working out your rental income).
What to send your accountant
- A profit and loss summary per property: income by type, expenses by category, net profit.
- A CSV of every row for the year: date, property, category, amount, fees and the booking reference.
- The original booking site reports and your receipts folder.
- Notes on anything unusual: days you used the property yourself, large purchases, a property bought or sold during the year.
How StayPerk Finances does it
StayPerk is free for hosts. The Books tab in Finances keeps income and expenses for each property, one year at a time, and shows a profit and loss summary with a month-by-month chart.
- Import your Airbnb, Vrbo or Booking.com CSV. Columns are matched for you and can be changed, listings are matched to your properties, and a preview shows each row before anything is saved. Rows already imported are skipped by confirmation code.
- Add an expense in a few taps: amount, category, save. Tick Repeat every month for bills like internet or a mortgage, and add a receipt note.
- Income from StayPerk add-ons and services that guests buy through your manual appears automatically.
- Export every row for the year as a CSV, or print an annual summary per property for your accountant.
StayPerk keeps cash-basis records from what you enter and import. It does not file returns or tell you what to deduct.
Contents
Frequently asked questions
Should I record the Airbnb payout or the gross earnings?
Record the gross earnings as income and the host fee as an expense. The difference is the payout. That way your income matches the booking site's yearly summary and the fee is counted as a cost.
Is a spreadsheet enough for Airbnb bookkeeping?
For one or two properties, a well kept spreadsheet works. The hard parts are importing each site's report without double counting, splitting costs by property and finding receipts later. A tool that does those for you saves time at year end.
Which expenses can I deduct?
That depends on your tax rules and how you use the property. IRS Publication 527 (US), HMRC's rental income guidance (UK) and the CRA's T4036 guide (Canada) explain the rules. An accountant can tell you what applies to you.
Is StayPerk Finances free?
Yes. Hosts use StayPerk, including Finances, the bookings calendar and the guest manual, at no cost.
Still have a question?
Write to us and a person will reply, or look it up in the Help Center.
Useful StayPerk pages
- Free host finances
Track income and expenses in a free StayPerk account.
- Break-even calculator
The occupancy your costs need.
- Airbnb host fee calculator
Your payout on one Airbnb booking.
Sources for this page
- Publication 527, Residential Rental Property - IRS
- Topic no. 415, Renting residential and vacation property - IRS
- How long should I keep records? - IRS
- Work out your rental income when you let property - HMRC (GOV.UK)
- Renting out your property: paying tax - GOV.UK
- T4036 Rental Income - Canada Revenue Agency