Skip to content
Spryhand

Airbnb & Short-Term Rentals

Airbnb Income & Expense Tracker

Log every booking payout and expense as they happen, with automatic monthly income and expense totals.

Delivery
Instant download
Purchase
One-time payment
Format
  • Google Sheets
  • Excel
Updated
August 2026
$5.90Buy on Etsy
Sample preview — illustrative data

Net for the year

$5,741

Deductible expenses

$5,561

MonthNet
  • July$1,810 / $394 / $1,416
  • August$1,645 / $862 / $783
  • October$494 / $809 / -$316
  • December (closed)$0 / $2,248 / -$2,248

Sample data preview of the Airbnb Income & Expense Tracker spreadsheet, shown for illustration only.

What this spreadsheet does

Payout amounts, cleaning fees and maintenance costs land in different places, so actual monthly performance is hard to see without logging it in one place.

What you can do with it

  • Keep a running record of actual bookings and payouts
  • See which months are most profitable
  • Prepare year-end numbers for taxes

What's included

Sheet tabs

  • Instructions
  • Monthly Summary
  • Booking Log
  • Expense Log

Features

  • Booking log recording gross value and platform fee separately, so income counts from the net payout
  • Refunds entered as negative rows, so the year still reconciles against your bank
  • Expense log across eight set categories, each row flagged deductible or not
  • Twelve monthly rows of nights, income, expenses, net and margin, for any year you choose
  • Year-to-date totals with an expense breakdown by category
  • A deductible subtotal kept separate from total spend

How it works

  1. 1Log each booking with its gross value and platform fee — income counts from the net payout
  2. 2Log each cost under a set category, marking whether it's deductible
  3. 3Set the year at the top of Monthly Summary; every month fills itself in

Who it's for

Active hosts who want an ongoing record of income and expenses, not just an estimate.

Frequently asked questions

Is this useful for tax time?

It gives you a year of categorised expenses with a deductible subtotal kept separate from total spend, because the same category holds both — a repair to the rental and the identical repair to the part you live in. It's a bookkeeping aid, not tax advice; confirm the final figures with an accountant.

How do I record a cancellation or refund?

As a negative row, not a deleted one. The month's income drops by the right amount and the year still reconciles against your bank — deleting the booking would leave the two disagreeing.

Can I track more than one property?

Add a property column to the Booking Log and Expense Log tabs to separate totals by property.

Complete the setup

The rest of the tools this one was built to sit beside.

Similar tools

The same kind of tool, for a different job.