---
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.
---

[Softinn Blog](https://page.mysoftinn.com/en)

# [OTA Commission & Merchant Payout Settlement Calculations](https://page.mysoftinn.com/en/ota-commission-merchant-payout-settlement-calculations)

 Written by [Softinn Author](https://page.mysoftinn.com/en/author/softinn) | Sep 22, 2020 1:10:33 AM

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) 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.)*

<https://page.mysoftinn.com/ota-commission-merchant-payout-settlement-calculations>

*Download the OTA Commission Calculation excel file [**here**](https://page.mysoftinn.com/ota-commission-merchant-payout-settlement-calculations)*

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. <https://page.mysoftinn.com/softinn-signup-form?utm_source=blog&utm_medium=refferal-banner&utm_campaign=blog-hotel-to-softinn>

[View full post](https://page.mysoftinn.com/en/ota-commission-merchant-payout-settlement-calculations)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Softinn Author"
  },
  "dateModified" : "2021-06-25T02:02:17.855Z",
  "datePublished" : "2020-09-22T01:10:33Z",
  "headline" : "OTA Commission & Merchant Payout Settlement Calculations",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1080,
    "url" : "https://page.mysoftinn.com/hubfs/ota%20commission%20calculator-1.png",
    "width" : 1920
  },
  "mainEntityOfPage" : "https://page.mysoftinn.com/en/ota-commission-merchant-payout-settlement-calculations",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Softinn blog"
  }
}
```