Airbnb Rental Revenue Reconciliation Tracker Excel with payout check, booking log, and monthly P&L by property. Know what you earned, what the platform paid, and what is still missing. Built for Airbnb, Vrbo, and…
About this template
Airbnb Rental Revenue Reconciliation Tracker Excel with payout check, booking log, and monthly P&L by property. Know what you earned, what the platform paid, and what is still missing. Built for Airbnb, Vrbo, and direct-booking hosts who need clean rental books without accounting software. Log a booking, reconcile the payout, and see profit by property.
$24
Excel & Google Sheets template — instant download on Etsy
Booking Log — log every booking: date, property, platform, guest, nights, gross booking, platform fee, cleaning fee, and taxes collected. Payout Expected is calculated for you: gross booking minus platform fee plus cleaning fee.
Payout Reconciliation — one row per booking, in the same order as the Booking Log. Expected payout is pulled in automatically. Enter the amount that actually hit your bank. The difference must be 0.00 — if it is not, a fee was withheld or a payout was short.
Expense Log — log every rental cost by category: cleaning, supplies, maintenance, utilities, insurance, mortgage interest, and more. Mark each one deductible or not, and see totals by category.
Monthly P&L by Property — revenue, expenses, and net profit per property for Jan-Dec, plus totals, nights booked, and occupancy. All formulas, no retyping.
Dashboard — annual gross revenue, platform fees, net revenue, expenses, net profit, occupancy rate, average nightly rate, average payout per booking, payout differences outstanding, and profit by property.
Cover & How to Use — start here. Yellow cells are the only ones you edit.
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Rental & Airbnb Revenue Reconciliation Tracker track?
The Rental & Airbnb Revenue Reconciliation Tracker tracks Booking Log; Payout Reconciliation; Expense Log; Monthly P&L by Property; Dashboard.
What do the example numbers show?
The included example shows: This is a bookkeeping and planning tool only, not tax, legal, or CPA advice. Short-term rental tax rules vary by state and city.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.