Skip to content Skip to footer

​​5 ways to do accurate marketplace reconciliation

A large share of online revenue for brands comes from marketplace sales. Most brands list their products on multiple marketplaces to maximize reach and address different customer segments.

Each marketplace has multiple fee types and commission structures. Accurate reconciliation of payments due and payments received is a complex and time-consuming process when there are a large number of orders. Failing to do so can result in a loss of revenue of 3-5%.

The most common areas where revenue loss occurs are:

  • Reconciling payments only at an aggregate level and not for each order
  • Poor understanding of marketplace fees and commission structures, and multiple reconciliation file formats
  • Damaged, returned, and written-off inventory reconciliation
  • Poor follow-up on ticket resolution on marketplace seller portals

Most of these issues happen when the process is being run manually and the team is short-staffed. Here are 5 things brands should do to improve revenue reconciliation and add to their topline:

#1 Implement a Payments Reconciliation Tool

A good payment reconciliation tool automates large parts of payment reconciliation. The key features should include out-of-box seller portal integration, configurable fee structures, and reconciliation rules and reporting capabilities.

#2 Document Fees & Commissions Structure for Each Marketplace

Brands should document the different fees and payment structures in detail. They must also create a normalized internal reference format that is visible to the entire team. There should be a defined process to audit and update these regularly as marketplaces update their fees.

#3 Reconciliation Process Design for Tracking and Inventory

Order-level tracking is needed to identify discrepancies and erroneous charges that are missed out in aggregate reconciliation. Unit-level inventory tracking and reconciliation help account for damages, returns and write-offs, and their adjustments in payments.

#4 Focus on Reconciliation Issue Tracking and Resolution

Issue tracking and resolution are critical steps for the success of the reconciliation process. The process should include detailed steps, responsibilities, and a tracking mechanism to track tickets to closure on seller portals. It should also include structured repositories for supporting documents as required.

#5 Managed Services Model for Payment Reconciliation

Payment reconciliation is a resource-intensive process, and brands should get the right partner to run this as a managed service. This helps in scalability, process adherence, and cost optimization.

Brands can see improvement in their reconciliation outcomes by implementing these recommendations. To know more about how to set up a successful payment reconciliation process, please book a meeting with an Iksula reconciliation consultant.

Author



Let's Get Started! Reach Out to Us

    • United States
    • United Kingdom
    • Afghanistan (‫افغانستان‬‎)
    • Åland Islands (Åland)
    • Albania (Shqipëri)
    • Algeria (‫الجزائر‬‎)
    • American Samoa
    • Andorra
    • Angola
    • Anguilla
    • Antigua and Barbuda
    • Argentina
    • Armenia (Հայաստան)
    • Aruba
    • Australia
    • Austria (Österreich)
    • Azerbaijan (Azərbaycan)
    • Bahamas
    • Bahrain (‫البحرين‬‎)
    • Bangladesh (বাংলাদেশ)
    • Barbados
    • Belarus (Беларусь)
    • Belgium (België)
    • Belize
    • Benin (Bénin)
    • Bermuda
    • Bhutan (འབྲུག)
    • Bolivia
    • Bosnia and Herzegovina (Босна и Херцеговина)
    • Botswana
    • Brazil (Brasil)
    • British Indian Ocean Territory
    • British Virgin Islands
    • Brunei
    • Bulgaria (България)
    • Burkina Faso
    • Burundi (Uburundi)
    • Cambodia (កម្ពុជា)
    • Cameroon (Cameroun)
    • Canada
    • Cape Verde (Kabu Verdi)
    • Caribbean Netherlands
    • Cayman Islands
    • Central African Republic (République Centrafricaine)
    • Chad (Tchad)
    • Chile
    • China (中国)
    • Christmas Island
    • Cocos (Keeling) Islands (Kepulauan Cocos (Keeling))
    • Colombia
    • Comoros (‫جزر القمر‬‎)
    • Congo (DRC) (Jamhuri ya Kidemokrasia ya Kongo)
    • Congo (Republic) (Congo-Brazzaville)
    • Cook Islands
    • Costa Rica
    • Côte d’Ivoire
    • Croatia (Hrvatska)
    • Cuba
    • Curaçao
    • Cyprus (Κύπρος)
    • Czech Republic (Česká republika)
    • Denmark (Danmark)
    • Djibouti
    • Dominica
    • Dominican Republic (República Dominicana)
    • Ecuador
    • Egypt (‫مصر‬‎)
    • El Salvador
    • Equatorial Guinea (Guinea Ecuatorial)
    • Eritrea
    • Estonia (Eesti)
    • Ethiopia
    • Falkland Islands (Islas Malvinas)
    • Faroe Islands (Føroyar)
    • Fiji
    • Finland (Suomi)
    • France
    • French Guiana (Guyane française)
    • French Polynesia (Polynésie française)
    • Gabon
    • Gambia
    • Georgia (საქართველო)
    • Germany (Deutschland)
    • Ghana (Gaana)
    • Gibraltar
    • Greece (Ελλάδα)
    • Greenland (Kalaallit Nunaat)
    • Grenada
    • Guadeloupe
    • Guam
    • Guatemala
    • Guernsey
    • Guinea (Guinée)
    • Guinea-Bissau (Guiné Bissau)
    • Guyana
    • Haiti
    • Honduras
    • Hong Kong (香港)
    • Hungary (Magyarország)
    • Iceland (Ísland)
    • India (भारत)
    • Indonesia
    • Iran (‫ایران‬‎)
    • Iraq (‫العراق‬‎)
    • Ireland
    • Isle of Man
    • Israel (‫ישראל‬‎)
    • Italy (Italia)
    • Jamaica
    • Japan (日本)
    • Jersey
    • Jordan (‫الأردن‬‎)
    • Kazakhstan (Казахстан)
    • Kenya
    • Kiribati
    • Kosovo (Kosovë)
    • Kuwait (‫الكويت‬‎)
    • Kyrgyzstan (Кыргызстан)
    • Laos (ລາວ)
    • Latvia (Latvija)
    • Lebanon (‫لبنان‬‎)
    • Lesotho
    • Liberia
    • Libya (‫ليبيا‬‎)
    • Liechtenstein
    • Lithuania (Lietuva)
    • Luxembourg
    • Macau (澳門)
    • Macedonia (FYROM) (Македонија)
    • Madagascar (Madagasikara)
    • Malawi
    • Malaysia
    • Maldives
    • Mali
    • Malta
    • Marshall Islands
    • Martinique
    • Mauritania (‫موريتانيا‬‎)
    • Mauritius (Moris)
    • Mayotte
    • Mexico (México)
    • Micronesia
    • Moldova (Republica Moldova)
    • Monaco
    • Mongolia (Монгол)
    • Montenegro (Crna Gora)
    • Montserrat
    • Morocco (‫المغرب‬‎)
    • Mozambique (Moçambique)
    • Myanmar (Burma) (မြန်မာ)
    • Namibia (Namibië)
    • Nauru
    • Nepal (नेपाल)
    • Netherlands (Nederland)
    • New Caledonia (Nouvelle-Calédonie)
    • New Zealand
    • Nicaragua
    • Niger (Nijar)
    • Nigeria
    • Niue
    • Norfolk Island
    • North Korea (조선 민주주의 인민 공화국)
    • Northern Mariana Islands
    • Norway (Norge)
    • Oman (‫عُمان‬‎)
    • Pakistan (‫پاکستان‬‎)
    • Palau
    • Palestine (‫فلسطين‬‎)
    • Panama (Panamá)
    • Papua New Guinea
    • Paraguay
    • Peru (Perú)
    • Philippines
    • Pitcairn Islands
    • Poland (Polska)
    • Portugal
    • Puerto Rico
    • Qatar (‫قطر‬‎)
    • Réunion (La Réunion)
    • Romania (România)
    • Russia (Россия)
    • Rwanda
    • Saint Barthélemy (Saint-Barthélemy)
    • Saint Helena
    • Saint Kitts and Nevis
    • Saint Lucia
    • Saint Martin (Saint-Martin (partie française))
    • Saint Pierre and Miquelon (Saint-Pierre-et-Miquelon)
    • Saint Vincent and the Grenadines
    • Samoa
    • San Marino
    • São Tomé and Príncipe (São Tomé e Príncipe)
    • Saudi Arabia (‫المملكة العربية السعودية‬‎)
    • Senegal (Sénégal)
    • Serbia (Србија)
    • Seychelles
    • Sierra Leone
    • Singapore
    • Sint Maarten
    • Slovakia (Slovensko)
    • Slovenia (Slovenija)
    • Solomon Islands
    • Somalia (Soomaaliya)
    • South Africa
    • South Georgia & South Sandwich Islands
    • South Korea (대한민국)
    • South Sudan (‫جنوب السودان‬‎)
    • Spain (España)
    • Sri Lanka (ශ්‍රී ලංකාව)
    • Sudan (‫السودان‬‎)
    • Suriname
    • Svalbard and Jan Mayen (Svalbard og Jan Mayen)
    • Swaziland
    • Sweden (Sverige)
    • Switzerland (Schweiz)
    • Syria (‫سوريا‬‎)
    • Taiwan (台灣)
    • Tajikistan
    • Tanzania
    • Thailand (ไทย)
    • Timor-Leste
    • Togo
    • Tokelau
    • Tonga
    • Trinidad and Tobago
    • Tunisia (‫تونس‬‎)
    • Turkey (Türkiye)
    • Turkmenistan
    • Turks and Caicos Islands
    • Tuvalu
    • Uganda
    • Ukraine (Україна)
    • United Arab Emirates (‫الإمارات العربية المتحدة‬‎)
    • United Kingdom
    • United States
    • U.S. Minor Outlying Islands
    • U.S. Virgin Islands
    • Uruguay
    • Uzbekistan (Oʻzbekiston)
    • Vanuatu
    • Vatican City (Città del Vaticano)
    • Venezuela
    • Vietnam (Việt Nam)
    • Wallis and Futuna
    • Western Sahara (‫الصحراء الغربية‬‎)
    • Yemen (‫اليمن‬‎)
    • Zambia
    • Zimbabwe