--- title: OTA Commission & Merchant Payout Settlement Calculations description: How Agoda, Booking.com, Expedia, and other popular OTAs do the calculation for commission and payout settlement? Free Excel file for you to download. image: https://page.mysoftinn.com/hubfs/ota%20commission%20calculator-1.png --- [![Softinn](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/softinn-logo/softinn-logo-main-with-mascot.svg)](https://www.mysoftinn.com) - Products - [Property Management System](https://www.mysoftinn.com/hotel-pms-front-desk-system) - [Booking Engine](https://www.mysoftinn.com/hotel-booking-engine) - [Hotel Website CMS](https://www.mysoftinn.com/hotel-website-cms) - [Hotel Channel Manager](https://www.mysoftinn.com/hotel-channel-manager) - [Hotel Kiosk](https://www.mysoftinn.com/hotel-kiosk) - [AI New](https://www.mysoftinn.com/ai) - Segments - [Independent Boutique Hotel](https://www.mysoftinn.com/boutique-hotel-management-system) - [Hotel Chains](https://www.mysoftinn.com/hotel-chain-management-system) - [Resort & Villa](https://www.mysoftinn.com/resort-management-system) - [Short-Term Vacation Rental](https://www.mysoftinn.com/airbnb-short-term-rental-property-management-software) - [Campsite](https://www.mysoftinn.com/campsite-management-system) - [Airport Hotel](https://www.mysoftinn.com/airport-hotel-management-system) - Roles - [Admin & Owner](https://www.mysoftinn.com/hotel-owner) - [Manager](https://www.mysoftinn.com/hotel-manager) - [Front Desk](https://www.mysoftinn.com/hotel-front-desk-receptionist) - [Housekeeping](https://www.mysoftinn.com/hotel-housekeeper) - [Maintenance](https://www.mysoftinn.com/hotel-maintenance-technician) - [Finance](https://www.mysoftinn.com/hotel-finance-accountant) - [Marketing and Sales](https://www.mysoftinn.com/hotel-marketing-sales) - Resources - [Knowledge Base](https://blog.mysoftinn.com) - [E-books](https://page.mysoftinn.com/guide-and-resources?hsLang=en-my) - [Product Training](https://page.mysoftinn.com/softinn-product-training-session?hsLang=en-my) - [Blog & Articles](https://page.mysoftinn.com/en) - [Product Updates](https://blog.mysoftinn.com/category/product-updates/) - [Partner & Integration](https://www.mysoftinn.com/integrations) - Company - [About Softinn](https://www.mysoftinn.com/about-us) - [Contact Us](https://www.mysoftinn.com/contact-us) - [Careers](https://page.mysoftinn.com/careers?hsLang=en-my) - [Pricing](https://www.mysoftinn.com/pricing) [Free Trial](https://page.mysoftinn.com/softinn-signup-form?hsLang=en-my) [Login](https://www.mysoftinn.com/login) Hotel Channel Manager # OTA Commission & Merchant Payout Settlement Calculations Softinn Author Last updated 25 Jun 2021 ![ota commission calculator](https://page.mysoftinn.com/hubfs/ota%20commission%20calculator-1.png) For hotel or BnB businesses, leveraging on the **[Online Travel Agents (OTAs)](https://page.mysoftinn.com/en/how-to-optimize-ota-to-improve-hotel-direct-booking?hsLang=en-my) such as Agoda, Booking.com, Airbnb, Expedia**, and many more to **drive booking sales** is common, especially in Southeast Asia region. Certainly, this does not come free. Based on the **Agency Model, OTAs** will charge the business a commission, ranging from 3% to 30%, for each confirmed booking. Nevertheless, we have been hearing from hotel owners and BnB owners grumbling about the calculation of the **final settlement they receive from Online Travel Agents (OTAs)** every time when a guest checked-out. The amount that they received from OTAs usually less than what they would have thought they should. If you are having a puzzle like them and wondering how **Online Travel Agencies (OTAs) commissions & merchant settlements are calculated,** here we have come out with an Excel file with the formulas for you to refer to.  We hope the following sharing would be helpful in solving your puzzle. ###### *(**Disclaimer:** The following calculation is only as a reference and it was formed based on the information shared by our helpful hotel & BnB merchants.)* [*![OTA Commission & Merchant Payout Settlement Calculations](https://page.mysoftinn.com/hs-fs/hubfs/frame_generic_light%20(1).png?width=855&name=frame_generic_light%20(1).png)*](https://page.mysoftinn.com/ota-commission-merchant-payout-settlement-calculations?hsLang=en-my) *Download the OTA Commission Calculation excel file [**here**](https://page.mysoftinn.com/ota-commission-merchant-payout-settlement-calculations?hsLang=en-my)* Now, let’s get ready with your calculator or even Abacus, and explore together with us. Feel free to share with us, if your formula is different from ours.  [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on pinterest](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/pinterest-color.png?width=24&name=pinterest-color.png)](http://pinterest.com/pin/create/button/?url=https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Dpinterest&media=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check%20out%20https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Demail%20&body=Check%20out%20https%3A%2F%2Fpage.mysoftinn.com%2Fen%2Fota-commission-merchant-payout-settlement-calculations%3Futm_medium%3Dsocial%26utm_source%3Demail) ##### Tags [Hotel Channel Manager](https://page.mysoftinn.com/en/tag/hotel-channel-manager) ![Softinn Author](https://page.mysoftinn.com/hs-fs/hubfs/Mascot/Mascot-100-01-Face-Greet-Swivel-Right.png?width=80&height=80&name=Mascot-100-01-Face-Greet-Swivel-Right.png) ##### Softinn Author Meet Softinn mascot, the friendly face behind our stories! Always curious and a little mischievous, they love sharing tips, insights, and a sprinkle of fun with every post. When not helping our readers, you’ll find them exploring new ideas, dreaming up adventures, and making sure our brand stays lively and approachable. #### Stay in the Loop! Get the latest hotel management insights, tips, and industry updates delivered to your inbox monthly. No spam, just valuable content. - Monthly expert insights - Industry trends & best practices - Exclusive tips & resources [Subscribe Now](https://page.mysoftinn.com/softinn-blog-subscription?hsLang=en-my) We respect your privacy. Unsubscribe anytime. #### Comments ##### Recent Posts [![Hotel Wi-Fi PMS Integration: Give Every Guest Their Own Password, Automatically](https://page.mysoftinn.com/hubfs/blog-1.png)](https://page.mysoftinn.com/en/hotel-wi-fi-pms-integration-give-every-guest-their-own-password-automatically?hsLang=en-my) ###### [Hotel Wi-Fi PMS Integration: Give Every Guest Their Own Password, Automatically](https://page.mysoftinn.com/en/hotel-wi-fi-pms-integration-give-every-guest-their-own-password-automatically?hsLang=en-my) [![AI Won't Run Your Hotel. But It Can Help You Run It Better.](https://page.mysoftinn.com/hubfs/ai_hotel_blog_header_with_title2.png)](https://page.mysoftinn.com/en/ai-wont-run-your-hotel.-but-it-can-help-you-run-it-better?hsLang=en-my) ###### [AI Won't Run Your Hotel. But It Can Help You Run It Better.](https://page.mysoftinn.com/en/ai-wont-run-your-hotel.-but-it-can-help-you-run-it-better?hsLang=en-my) [![Google AI Mode for Hotels: What Hotel Owners Need to Know](https://page.mysoftinn.com/hubfs/Get%20Your%20Hotel%20Discovered%20in%20Google%20AI%20Mode-%20blog.png)](https://page.mysoftinn.com/en/google-ai-mode-for-hotels-what-hotel-owners-need-to-know?hsLang=en-my) ###### [Google AI Mode for Hotels: What Hotel Owners Need to Know](https://page.mysoftinn.com/en/google-ai-mode-for-hotels-what-hotel-owners-need-to-know?hsLang=en-my) [![When the Minimum Wage Goes Up, What's Your Hotel's Next Move?](https://page.mysoftinn.com/hubfs/Hotel%20Operations_%20Navigating%20Rising%20Wages-%20blog.png)](https://page.mysoftinn.com/en/when-the-minimum-wage-goes-up-whats-your-hotels-next-move?hsLang=en-my) ###### [When the Minimum Wage Goes Up, What's Your Hotel's Next Move?](https://page.mysoftinn.com/en/when-the-minimum-wage-goes-up-whats-your-hotels-next-move?hsLang=en-my) [![Why Hotels Should Offer Reserve Now, Pay Later to Guests](https://page.mysoftinn.com/hubfs/blog%20rnpkl-1.png)](https://page.mysoftinn.com/en/why-hotels-should-offer-reserve-now-pay-later-to-guests?hsLang=en-my) ###### [Why Hotels Should Offer Reserve Now, Pay Later to Guests](https://page.mysoftinn.com/en/why-hotels-should-offer-reserve-now-pay-later-to-guests?hsLang=en-my) # Get Your Free Trial Now! [Start Trial](https://page.mysoftinn.com/softinn-signup-form?hsLang=en-my) No credit card required #### Products [Property Management System](https://www.mysoftinn.com/hotel-pms-front-desk-system) [Hotel Channel Manager](https://www.mysoftinn.com/hotel-channel-manager) [Booking Engine](https://www.mysoftinn.com/hotel-booking-engine) [AI](https://www.mysoftinn.com/ai) [Hotel Website CMS](https://www.mysoftinn.com/hotel-website-cms) [Hotel Kiosk](https://www.mysoftinn.com/hotel-kiosk) [Softinn API](https://api.mysoftinn.com/swagger/ui/index) [Pricing & Plans](https://www.mysoftinn.com/pricing) #### Segments [Independent Boutique Hotel](https://www.mysoftinn.com/boutique-hotel-management-system) [Resort & Villa](https://www.mysoftinn.com/resort-management-system) [Hotel Chains](https://www.mysoftinn.com/hotel-chain-management-system) [Short-Term Vacation Rental](https://www.mysoftinn.com/airbnb-short-term-rental-property-management-software) [Campsite](https://www.mysoftinn.com/campsite-management-system) [Airport Hotel](https://www.mysoftinn.com/airport-hotel-management-system) [Customer Success Stories](https://www.mysoftinn.com/hotel-clients) #### Resources [Knowledge Base](https://blog.mysoftinn.com) [Blog & Articles](https://page.mysoftinn.com/en) [Product Updates](https://blog.mysoftinn.com/category/product-updates/) [Product Training](https://page.mysoftinn.com/softinn-product-training-session?hsLang=en-my) [Partner & Integration](https://www.mysoftinn.com/integrations) #### Company [About Softinn](https://www.mysoftinn.com/about-us) [Contact Us](https://www.mysoftinn.com/contact-us) [Careers](https://page.mysoftinn.com/careers?hsLang=en-my) [Press Kit](https://page.mysoftinn.com/hubfs/Softinn%20Press%20Kit%202025.pdf?hsLang=en-my) [Terms of Service](https://page.mysoftinn.com/terms-of-service?hsLang=en-my)|[Privacy Policy](https://page.mysoftinn.com/privacy-policy?hsLang=en-my) Softinn builds the next-generation hotel management system for hotels in Southeast Asia. [![Facebook Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/facebook-footer.png)](https://www.facebook.com/mySoftinn) [![LinkedIn Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/linkedin-footer.png)](https://www.linkedin.com/company/softinn) [![X Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/twitter-footer.png)](https://x.com/mysoftinn) [![YouTube Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/youtube-2.svg)](https://www.youtube.com/c/Softinn) [![Instagram Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/social-media/instagram-logo.svg)](https://www.instagram.com/mysoftinn/) --- © 2013-2026 Softinn Solutions Sdn. Bhd. 201201044886 (1029363-M). TIN: C-23412633070. SST No: M10-2208-32100003. All rights reserved. Made with ♥ in Malacca, Malaysia. ![Softinn Logo](https://page.mysoftinn.com/hubfs/raw_assets/public/softinn-metronic-theme/images/logo/softinn-logo/softinn-logo-main-with-mascot.svg) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Softinn Author", "url" : "https://page.mysoftinn.com/en/author/softinn" }, "dateModified" : "2021-06-25T02:02:17.851Z", "datePublished" : "2020-09-22T01:10:33.000Z", "headline" : "OTA Commission & Merchant Payout Settlement Calculations", "image" : [ "https://page.mysoftinn.com/hubfs/ota%20commission%20calculator-1.png" ], "mainEntityOfPage" : { "@id" : "https://page.mysoftinn.com/en/ota-commission-merchant-payout-settlement-calculations", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://page.mysoftinn.com/hubfs/230813-softinn-block-green.png" }, "name" : "Softinn Solutions Sdn. Bhd." } } ```