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.
- 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
| Item | What it is | How it should appear |
|---|---|---|
| Sale | Gross order value, as the customer paid | Revenue, per order |
| Marketplace charges | Commission, service fees, voucher costs | Expense lines (or contra-revenue), per type |
| Refunds and returns | Money and stock moving backward | Credit note linked to the original sale, plus stock return |
| Payout | Cash received | Bank 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.