{"product_id":"free-airbnb-extra-guest-fee-calculator","title":"Free Airbnb Extra Guest Fee Calculator – Extra Guest Charge per Night Spreadsheet for Vacation Rentals, Excel \u0026 Sheets, No Canva","description":"\u003cp\u003ePrice extra guests with confidence using this \u003cstrong\u003efree extra guest fee calculator\u003c\/strong\u003e for vacation rentals. Type your base nightly rate, how many guests are included, the fee per extra guest per night and your maximum guests. Then add a booking and the sheet works out the room total, the extra guest fees and the booking total.\u003c\/p\u003e\u003cp\u003eAn extra guest fee protects you from extra wear, more cleaning and bigger utility bills when a larger party stays. It only works if the numbers are clear: how many guests are extra, how many nights, and what the stay costs for four, five or six people. This one-tab sheet shows both views: a booking calculator with ten rows and a price-by-party-size table you can use when a guest asks what a stay would cost. It comes pre-filled with sample rates and eight sample bookings so you can see how every number is worked out before you replace them with your own.\u003c\/p\u003e\u003ch3\u003eWhat you get\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003e1 tab with your fee settings: base nightly rate, guests included, extra guest fee and maximum guests\u003c\/li\u003e\n\u003cli\u003eA 10-row booking calculator: nights and guests in, extra guests, room total, extra guest fees and booking total out\u003c\/li\u003e\n\u003cli\u003eA price-by-party-size table for 1 to 8 guests and any number of nights\u003c\/li\u003e\n\u003cli\u003eTotals and the extra guest fees earned across your bookings, all by formula\u003c\/li\u003e\n\u003cli\u003eBookings above your maximum guests turn red\u003c\/li\u003e\n\u003cli\u003eLight yellow input cells, gray formula cells and print setup for Letter and A4, one page\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFiles in the download\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eFree-Extra-Guest-Fee-Calculator.xlsx (editable, US Letter print setup)\u003c\/li\u003e\n\u003cli\u003eFree-Extra-Guest-Fee-Calculator.pdf (print-ready, Letter)\u003c\/li\u003e\n\u003cli\u003eFree-Extra-Guest-Fee-Calculator-A4.pdf (print-ready, A4)\u003c\/li\u003e\n\u003cli\u003eSTART-HERE-How-to-Edit.pdf\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eHow to edit it (no Canva needed)\u003c\/h3\u003e\u003col\u003e\n\u003cli\u003eDownload the ZIP and unzip it.\u003c\/li\u003e\n\u003cli\u003eOpen the editable file in Excel, Google Sheets (free) or Numbers. No Canva account and no subscription are needed.\u003c\/li\u003e\n\u003cli\u003eType into the light yellow input cells. The gray formula cells update by themselves.\u003c\/li\u003e\n\u003cli\u003eReplace the sample rates with your own, then add each booking or use the party size table to answer price questions.\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003eThe START-HERE guide in the ZIP walks you through each app step by step and explains how to print at the right size.\u003c\/p\u003e\u003cp\u003e\u003cem\u003ePlanning tool only. Check the extra guest fee rules of your booking site or your own direct booking terms.\u003c\/em\u003e\u003c\/p\u003e\u003ch3\u003eWant the full version?\u003c\/h3\u003e\u003cp\u003eThis free template is a sample of the \u003ca href=\"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-fee-schedule-calculator\"\u003eExtra Fees Calculator Spreadsheet\u003c\/a\u003e. The full calculator is a complete fee schedule: pet fee, extra guest fee, early check-in, late checkout and damage waiver, added up into one total per booking. The free sheet covers the extra guest fee only. Running several listings or want everything at once? The \u003ca href=\"https:\/\/hello.welcomedeskco.shop\/products\/airbnb-host-mega-bundle-8-editable-templates-welcome-books-house-signs-guest-messages-income-tracker-cleaning-checklist\"\u003eHost Mega Bundle\u003c\/a\u003e includes every paid Welcome Desk Co. template in one download.\u003c\/p\u003e\u003ch3\u003eFAQ\u003c\/h3\u003e\u003cp\u003e\u003cstrong\u003eIs it really free?\u003c\/strong\u003e Yes. Add it to your cart, complete the free checkout and download the ZIP.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDo I need Canva?\u003c\/strong\u003e No. The file opens in Excel, Google Sheets (free) or Numbers.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCan I change the wording, colors and fonts?\u003c\/strong\u003e Yes. Every word is real, editable text, and you can change colors and fonts like in any other document.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow is the extra guest fee worked out?\u003c\/strong\u003e Extra guests are the guests above the number included in your rate. The fee is extra guests times your fee per guest per night times the number of nights.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it handle pet fees, early check-in or late checkout?\u003c\/strong\u003e No. The free sheet covers the extra guest fee only. The full calculator adds pet fee, early check-in, late checkout and damage waiver in one fee schedule.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eAre the rates real?\u003c\/strong\u003e No. They are sample numbers. Replace them with your own rate and fee.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eIs there an A4 version?\u003c\/strong\u003e Yes. The ZIP has a Letter workbook plus Letter and A4 PDFs. To print the workbook on A4, change Paper size to A4 in your print settings; it is already set to fit one page.\u003c\/p\u003e\u003ch3\u003eLicense\u003c\/h3\u003e\u003cp\u003eFree for personal use on your own rental property. You may edit, print and share the finished pages with your guests. Please do not resell or redistribute the template files. Airbnb, VRBO and Booking.com are trademarks of their respective owners; Welcome Desk Co. is not affiliated with Airbnb, VRBO or Booking.com and this template is not endorsed by them.\u003c\/p\u003e","brand":"Welcome Desk Co.","offers":[{"title":"Default Title","offer_id":68060938535164,"sku":"WDC-F2-031","price":0.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0829\/2358\/5788\/files\/free-extra-guest-fee-calculator__01-hero.jpg?v=1793658668","url":"https:\/\/hello.welcomedeskco.shop\/products\/free-airbnb-extra-guest-fee-calculator","provider":"Welcome Desk Co.","version":"1.0","type":"link"}