← All articles

Blog

Marketplace Fees, Payouts and Reconciliation: Why Numbers Never Match

Why your Shopee, Tokopedia and TikTok Shop payouts never equal your sales, where the gaps come from, and how to reconcile them without a monthly spreadsheet marathon.

6 min read
  • bottom
  • marketplace

If you sell on Indonesian marketplaces, you have probably seen it: sales for the month say one number, the money that landed in your bank says another, and your accounting records say a third. Nobody is stealing from you. The numbers differ because a marketplace payout is the result of many small deductions, adjustments and timing differences, not a simple sum of orders.

The short answer: the gap is normal, mostly explainable, and only becomes a problem when nobody owns the job of explaining it. The fix is rarely a clever tool. It is a consistent routine that matches each order to its fee lines and to the payout that settled it.

Fee details below reflect public reports as of late 2026. Marketplaces change fees often, so verify current rates in your own seller center.

Where the gap comes from

A single order passes through several hands before money reaches you. Each step can change the amount.

Source of differenceWhat happens
Commission / admin feePercentage of the item price, usually set by product category
Per-order processing feeA flat Rp1,250 per order on Shopee, Tokopedia and TikTok Shop since mid-2025
Programme feesFree-shipping and promo programmes, instalment (paylater) options
Shipping differencesCourier weight corrections, return shipping, shipping subsidies
Discounts and vouchersSeller-funded versus platform-funded discounts are treated differently
Returns and refundsMoney reversed after you thought the sale was final
TimingOrders count when placed or shipped, but money is released after delivery is confirmed
AdjustmentsPenalties, compensation, lost-parcel claims

Two of these deserve a closer look because they change often.

Fees are not static

Public reporting shows how quickly the rules move:

  • Shopee raised seller admin fees from 2026. A Metro TV report from January 2026 describes rates set by product category (A to E) and store status, for example 10% for Category A and lower rates for categories such as high-end electronics. It also notes the Rp1,250 per-order processing fee remains, and that pre-order items carry a separate 3% service fee from January 2026, with some categories exempt.
  • TikTok Shop Tokopedia charges a “dynamic commission” by category. Katadata reported that from 16 September 2026 the per-item cap fell to Rp60,000 (it had been raised to Rp650,000 in May). The fee is calculated on the price after seller discounts, excludes shipping and platform-funded discounts, and is deducted when the order completes. Per that report, it is not refunded if a delivered order is later returned.
  • The per-order processing fee on Tokopedia and TikTok Shop started on 11 August 2025, according to Bisnis.com, following the policy Shopee already had.

The practical lesson: a margin calculation built on last quarter’s fee table can be wrong this quarter. Fee changes should be logged with their effective dates, so you can explain old orders using the rules that applied then.

Why spreadsheets break down

Most sellers start by downloading each marketplace’s income or settlement report and pasting it into a spreadsheet. That works at low volume. It starts failing when:

  • You sell on three or more marketplaces, each with a different report layout and different names for similar fees.
  • One bank deposit covers dozens or hundreds of orders, and you cannot tell which ones.
  • Returns and refunds arrive in a later period than the original sale.
  • Fee rules change mid-month.
  • The person who understands the spreadsheet is on leave.

The usual result is that finance closes the month late, or books a single “marketplace revenue” figure net of fees and never sees the real cost of each channel. That hides your true margin, which matters when you decide where to spend on ads and discounts.

What a workable reconciliation looks like

Whatever tool you use, the logic has three layers:

  1. Order level. For each order: gross price, each fee line, shipping adjustments, refunds, and the net amount the marketplace says it owes you.
  2. Payout level. Which orders were included in each payout, and whether the total matches what the marketplace statement says.
  3. Bank level. Whether the payout actually arrived in your bank account, for the right amount, on a sensible date.

Differences at each layer should fall into a short list of named reasons (fee, refund, timing, penalty, unexplained). The “unexplained” bucket is the one to watch. If it grows, something is wrong, whether a rule change, a missing report or an error.

How an ERP helps, and where it does not

Systems such as Odoo can hold marketplace orders alongside accounting entries, and Odoo’s bank reconciliation feature is built to match bank transactions with invoices and payments. Items with no counterpart, such as fees, can be handled with reconciliation models. Odoo’s documentation gives bank fees as the example, and the same idea can be applied to repeating marketplace deductions.

Be realistic about the limits:

  • Odoo does not know a marketplace’s fee rules by itself. Someone must define how each fee line is booked, and update it when rules change.
  • Order and fee data has to get into the system first, through a connector, a report import or manual upload. What each option can pull depends on the marketplace and on the connector, so check this before committing.
  • Marketplace statements are not always granular enough to tie every deduction to a single order. Expect some manual review.
  • A bank deposit that bundles many orders still needs a clear rule for matching.

An ERP reduces the manual work and makes the process repeatable. It does not remove the need for someone to review exceptions.

Practical steps you can take this month

  • Pick one source of truth per marketplace for settlement data, and download it on a fixed schedule rather than ad hoc.
  • Create a fee chart. List each fee type, how it is calculated, and the date it last changed. Keep it updated.
  • Separate gross sales, fees, refunds and net in your reporting. Do not book only the net amount.
  • Reconcile weekly, not monthly. Small gaps are easier to trace while the orders are fresh.
  • Track the unexplained balance as its own number and ask why whenever it rises.
  • Check seller-funded versus platform-funded discounts before judging whether a payout is wrong.

When to get help

Consider outside help if finance regularly closes more than a week late, if you cannot say which channel is actually profitable, or if you are adding a marketplace and the spreadsheet is already straining. The right answer may be a better routine, an off-the-shelf tool, or an ERP setup. It depends on your volume, your accounting team and your existing software.

A no-charge conversation

If you want a second opinion on how your marketplace money flows into your books, Teknologia Solutions is happy to talk it through with no charge and no obligation. We will tell you honestly whether you need an ERP at all or just a tighter process.


Sources: Metro TV, Shopee admin fees 2026; Katadata, TikTok Shop Tokopedia commission cap; Bisnis.com, Rp1,250 per-order fee; Odoo documentation, bank reconciliation. Fees and policies change often and reports may be out of date; verify against each marketplace’s official seller center before relying on any figure.