← All articles

Blog

Odoo Marketplace Orders to Accounting: Fees, Refunds, Payouts and Tax

How marketplace sales, fees, refunds, payouts and PPh 22 withholding should flow into Odoo Accounting for Indonesian sellers, and where books usually go wrong.

5 min read
  • mid
  • odoo
  • marketplace

If you sell on Tokopedia, Shopee, Lazada, TikTok Shop, Blibli, Bukalapak or Zalora, the number a marketplace pays into your bank is almost never the number on the customer’s order. Getting Odoo Accounting to tell the truth means recording the gross sale, every deduction, and the cash that finally arrives as three separate things, then matching them.

Short answer: do not book the payout as your revenue. Book the order as the sale, book fees, shipping subsidies, vouchers and refunds as their own lines, and use the payout only to reconcile against the bank. Done this way, Odoo can show real margin per marketplace. Done any other way, you get a clean bank balance and meaningless profit figures.

Why the payout never equals the order

For one order, the marketplace typically nets off some mix of commission, payment or transaction fees, shipping differences, seller-funded vouchers and campaign charges, then pays you later. Exact fee types, rates and release timing differ by marketplace, change often, and depend on your seller category. Check the fee and income pages in your own seller center rather than relying on any article, including this one.

Two more facts complicate matching:

  • One payout usually covers many orders, and some orders are partly paid or held.
  • Refunds, returns and cancellations can land in a later period than the original sale.

The four things to keep separate

ItemWhat it isHow it should appear
SaleGross order value, as the customer paidRevenue, per order
Marketplace chargesCommission, service fees, voucher costsExpense lines (or contra-revenue), per type
Refunds and returnsMoney and stock moving backwardCredit note linked to the original sale, plus stock return
PayoutCash receivedBank entry, reconciled against receivable from the marketplace

A practical pattern is to treat each marketplace as a customer-like account: the sale creates a receivable from that marketplace, charges reduce it, and the payout clears it. Whatever is left on that account is money the marketplace owes you, or a mismatch to investigate. That balance is the most useful single check you have.

How Odoo handles the matching

Odoo’s bank reconciliation matches bank transactions to invoices, bills and payments, and lets you write off small differences. Until a transaction is matched, it sits in a suspense account. That works well when one payment matches one invoice. A marketplace payout is one deposit against dozens of orders, so you need either a settlement document that groups the orders and charges, or a consistent journal entry per payout. Some third-party Odoo apps offer settlement import for Southeast Asian marketplaces; treat their descriptions as vendor claims and test on your own settlement reports first.

Also note that some reconciliation conveniences depend on your Odoo edition and version. Confirm what your plan includes before designing around it.

Refunds and returns

Refunds are where books drift. Common failure points:

  • The refund is recorded as a negative bank line instead of a credit note, so revenue stays overstated.
  • A return is accepted in the marketplace but never received into Odoo stock, so inventory and cost of goods are both wrong.
  • A fee is not returned on a refunded order, or is returned in a different period, and nobody notices.

Decide a rule up front: every marketplace refund creates a credit note against the original order, and every physical return goes through a stock receipt. Then review the exceptions weekly, not at year-end.

Tax: what to check in 2026

Indonesian marketplace tax has been in motion. Under PMK 37/2025, marketplaces are to collect 0.5% PPh Pasal 22 on domestic merchants’ transactions, with rollout described by the tax office as gradual, depending on each marketplace’s system readiness. Reporting from DDTC in late June 2026 adds that the tax is final, is calculated on gross turnover shown in the merchant’s billing documents (excluding VAT and PPnBM), and is not collected from merchants whose turnover in the tax year does not exceed Rp500 million, provided they file a statement with the marketplace. Neither source states an effective date, and we could not confirm one from the regulation text. Verify the current start date, your status and the marketplace’s declaration procedure with the marketplace and your tax adviser.

What this means for your books, if and when collection applies to you:

  • Withheld PPh 22 is a deduction from your payout. It needs its own account (a prepaid or final tax account, as your accountant decides) so it is not lost inside “fees”.
  • You will want the marketplace’s tax documents matched to the sales they relate to.
  • Corrections and cancellations may need to go through the marketplace’s own system, so your credit notes and the marketplace’s documents must stay aligned.

VAT (PPN) treatment depends on whether you are a PKP and on how each marketplace invoices its own fees. That is an accountant’s call, not something to guess from a connector’s defaults.

What it costs and what to expect

We will not quote prices here because they depend on how many marketplaces, how many orders a month and whether you use an off-the-shelf connector or a custom build. The real effort is usually in the accounting design (accounts, tax treatment, refund rules) rather than the data transfer. Budget for a few cycles of reconciling against real payouts before you trust the numbers.

When to get help

  • Payouts and sales stopped reconciling and nobody can say why.
  • You sell on three or more marketplaces with different fee and payout rules.
  • The PPh 22 or PPN treatment is unclear to you or your accountant.
  • You are migrating from spreadsheets or other accounting software and need opening balances right.

If any of that sounds familiar, we are happy to talk it through with you at no charge, with no obligation to buy anything. Tell us which marketplaces you use and how you close your books today, and we will say honestly whether Odoo fits and what a sensible setup would look like.


Sources: Odoo bank reconciliation documentation; IKPI on PMK 37/2025; DDTC News. Marketplace fees, payout timing and tax rules change often; verify against your seller center, the official regulation and your tax adviser before acting.