Skip to content

About this spreadsheet

One row per booking becomes one statement per owner, on any fee arrangement: percent of gross or net, cleaning fee in or out, flat per booking, or both. It handles Airbnb co-host payouts, Vrbo and direct bookings, rates that change mid-month, taxes kept out of income, and a year-end tie to the 1099-K.

Built for people who manage other owners' listings and owe them a monthly number, including the months that do not add up on a napkin: a platform changes its fee on the 29th, one owner's payouts go to their own account, a guest gets a refund. Each owner has their own fee terms and their own arrangement on each channel, and a cash check tells you when a month does not close. An owner who collects their own payouts can end up owing you, so the statement handles invoices as well as distributions.

The first thing the pack asks is whether you need a license. Managing a rental for someone else, for pay, can count as real estate brokerage, depending on your state and on what exactly you do. The first rows of the register ask that question, and whether your fee model is allowed, for you to answer with your regulator or an attorney. This is not a way to start a co-host business, and it does not contain a contract.

Highlights

  • One statement per owner: rent, platform fees, commission, expenses and what is due
  • Fee terms per owner, and platform rates dated so a change mid-month is handled
  • Airbnb co-host payouts, and payouts that go straight to the owner
  • A year-end tie to the 1099-K, using the method Airbnb publishes

Questions

Pairs well with

Related products