{"product_id":"airbnb-host-income-expense-tracker-spreadsheet-short-term-rental-bookkeeping-template-excel-google-sheets","title":"Airbnb Host Income \u0026 Expense Tracker Spreadsheet - Short-Term Rental Bookkeeping Template (Excel \u0026 Google Sheets)","description":"\u003cp\u003eKnow exactly what each of your rentals earns. This auto-calculating Excel \u0026amp; Google Sheets workbook tracks bookings, expenses and mileage for up to 5 short-term rental properties, then builds your monthly summary and annual dashboard for you.\u003c\/p\u003e\u003ch3\u003eWhat's inside\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here\u003c\/strong\u003e - simple setup instructions\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSettings\u003c\/strong\u003e - up to 5 property names, currency symbol, tax year, mileage rate, editable platform and expense category lists\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBookings log\u003c\/strong\u003e - check-in\/out, property and platform dropdowns (Airbnb, VRBO, Booking.com, Direct), guest, nights and net income calculated automatically, platform fee, cleaning fee, taxes\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpenses log\u003c\/strong\u003e - date, property, category dropdown, vendor, amount, notes\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly Summary\u003c\/strong\u003e - 12 months of revenue, expenses, net profit, nights and occupancy for all properties and each property\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAnnual Dashboard\u003c\/strong\u003e - total revenue, expenses, net profit, ADR, occupancy %, revenue per property and 4 native charts\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMileage log\u003c\/strong\u003e - miles and deduction calculated from your rate\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eWhy you'll love it\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eReal formulas, no hardcoded totals - everything updates as you type\u003c\/li\u003e\n\u003cli\u003eWorks in Excel, Google Sheets, Numbers and LibreOffice (no macros, no add-ins)\u003c\/li\u003e\n\u003cli\u003eRoom for 500 bookings, 500 expenses and 300 trips; sample rows included to delete\u003c\/li\u003e\n\u003cli\u003eClean pine-and-sage design with frozen headers and dropdown validation\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eHow it works\u003c\/h3\u003e\u003cp\u003eInstant digital download: a .xlsx file plus a short START-HERE guide. Upload it to Google Drive to use it in Google Sheets, or open it directly in Excel.\u003c\/p\u003e\u003cp\u003eThis is a bookkeeping aid, not tax or legal advice.\u003c\/p\u003e\u003cp\u003e\u003cem\u003eThis is a digital product. Nothing will be shipped.\u003c\/em\u003e\u003c\/p\u003e\u003cp\u003e\u003cem\u003eLicense: for use with your own rental properties. Reselling or sharing the template file is not permitted. Template designed with the help of AI tools.\u003c\/em\u003e\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":67829507784956,"sku":null,"price":4.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/rental-income-expense-tracker__01-hero.jpg?v=1792563468","url":"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-host-income-expense-tracker-spreadsheet-short-term-rental-bookkeeping-template-excel-google-sheets","provider":"Welcome Desk Co.","version":"1.0","type":"link"}