Provisional vs settled fees: why this week's profit moves
What provisional fees are, why the latest week's profit changes after marketplace settlement, a worked one-week example, and how to read unsettled profit.
By The DataxLand team· · 6 min read
On Monday you open the report: last week's profit before ads was 8.2 million ₫. Three weeks later, once the accountant finishes reconciling, the number is 7 million ₫. Nobody made a mistake. It's just that on that Monday most of last week's fees were not yet settled: orders were still in transit, buyers could still return them, and the marketplace hadn't paid out.
Every profit number for the most recent days stands on provisional fees. This post explains what provisional fees are, why they differ from settled fees, by how much in a concrete example, and how to read this week's profit without a surprise three weeks later.
The milestones an order passes through
Marketplace fees are not deducted when the buyer clicks "order". Each milestone below makes the number a little more certain.
| Milestone | What you know | What you don't know yet |
|---|---|---|
| Order placed | Price, quantity, vouchers | Whether it will be cancelled or delivered |
| Delivered | The buyer has the goods | Whether the buyer will request a return |
| Return window closes | Revenue is almost certain | Program fees, marketplace adjustments |
| Order completed, marketplace settles | Fees are final, money lands in the shop's balance | Only rare adjustments (disputes, offsets) |
| Withdrawal to the bank | Real cash | — |
How long it takes from order to settlement depends on the marketplace, the shipping method and the return policy of the day. Don't rely on a fixed number you heard somewhere; measure it on your own shop: take 100 recent orders, note the order date and the settlement date in Seller Centre's settlement report, and take the median.
Some fees are deducted directly per order before money reaches your balance. For example, Shopee describes its 3,000 ₫ per-order infrastructure fee (for orders created from 1 Jul 2025) as being "deducted directly on each order before the sales proceeds are transferred to the Shopee account balance", according to Tuoi Tre (12 Jun 2025) (read on 16 Nov 2026). In other words, before settlement you don't see this fee in your payouts yet.
What provisional fees are
Provisional fees are fees you estimate from the fee schedule for orders not yet settled. Settled fees are the fees shown in the marketplace's settlement report once the order completes. Provisional fees differ from settled fees for four common reasons:
- Full or partial returns. Revenue drops, return shipping may be charged, and depending on the marketplace some fees are still charged even though the order was returned.
- Program fees. Voucher Extra, Freeship Extra and visibility packages apply only to enrolled products or orders, often with a per-product cap; a general fee schedule doesn't tell you which orders are affected.
- Fee changes mid-period. In 2026 all three major marketplaces changed their fees (see Marketplace fees in 2026); orders placed before and after the effective date pay different rates.
- Marketplace adjustments: offsets, disputes, penalties, fee refunds.
Example: one week of sales before and after settlement
An illustration with these assumptions: 100 orders in the week, net revenue 25,000,000 ₫, cost of goods 12,500,000 ₫. Fee schedule used for the estimate: 10% category fee and 6% transaction fee on net revenue, plus a 3,000 ₫ fixed fee per order. Three weeks later, the settlement shows: 2 orders returned (900,000 ₫ refunded, 25,000 ₫ return shipping each), the marketplace still charged the fixed fee on all 100 orders, and 30 orders were in a voucher program with a 4% fee on 8,750,000 ₫ of value.
| Line | Estimate (Monday after the week) | Settled (after reconciliation) |
|---|---|---|
| Net revenue | 25,000,000 ₫ | 24,100,000 ₫ |
| − Cost of goods | 12,500,000 ₫ | 12,500,000 ₫ |
| − Category + transaction fees (16%) | 4,000,000 ₫ | 3,856,000 ₫ |
| − Fixed fee per order | 300,000 ₫ | 300,000 ₫ |
| − Voucher program fee | 0 ₫ | 350,000 ₫ |
| − Return fees | 0 ₫ | 50,000 ₫ |
| = Contribution margin | 8,200,000 ₫ (32.8%) | 7,044,000 ₫ (29.2%) |
The settled number is 1,156,000 ₫, about 14%, below the estimate. The two biggest causes are refunds (which you can't know in advance) and program fees (which you can know if you estimate fees per SKU enrolled in each program, rather than with one flat rate).
(One more assumption in this example: returned goods have not yet been restocked, so cost of goods is unchanged. If returned goods can be resold, cost of goods drops accordingly.)
Three ways to handle unsettled fees
| Approach | Latest week's profit | Risk |
|---|---|---|
| Ignore fees until they settle | Clearly inflated | Ad and purchasing decisions based on phantom profit |
| Report only after settlement | Correct but weeks late | Problems found too late |
| Estimate from the fee schedule and flag as provisional | Roughly right immediately | You need to know which part is still provisional so you don't conclude too early |
The third approach is the sensible one for a shop owner: you get numbers right away, plus a metric that tells you how firm they are.
Provisional fee rate: the metric that goes with profit
Provisional fee rate = Fees still provisional ÷ (Marketplace fees + Payment fees + Shipping fees)In DataxLand's sample data (a simulated scented-candle and essential-oil shop, 1 Aug – 29 Oct 2026), this rate is 12.36% on the last data date: of 135,474,800 ₫ in marketplace, payment and shipping fees, about 16.7 million ₫ is still an estimate. Almost all of the provisional part falls in the last few weeks — exactly the orders that haven't reached settlement yet.
How to read it in practice:
- The provisional fee rate for the whole quarter is low: conclusions about the quarter's profit by channel and SKU are reliable.
- The rate for the latest week is high: use that week's profit to spot trends, not to settle bonuses or cut a channel.
- The provisional rate of older weeks does not shrink over time: you may not have loaded the latest settlement reports, or the settlement data is broken.
A 15-minute weekly reconciliation
- Export the settlement (escrow) report for the completed week from each marketplace's Seller Centre.
- Join it to your order list by order number; mark orders that now have settled fees.
- Compare settled fees with the fees you estimated for the same orders. Record the gap by group: returns, program fees, fee schedule changes, other adjustments.
- If one group is off every week (for example program fees), fix the estimate: add the program fee rate for enrolled SKUs.
- Restate profit for older weeks with settled fees, not just the new week.
How DataxLand does this
DataxLand reads fees from the marketplace's own settlement data: with the Shopee connector, the settlement table holds marketplace fees, payment fees, vouchers and payouts (see the Shopee source); you can also upload files exported from Seller Centre. Every fee is stored with a provisional or settled flag. When a new settlement arrives on the next refresh, that order's provisional fees are replaced with settled fees, and older weeks' profit updates by itself.
The provisional fee rate metric sits next to profit after fees on the dashboard, alongside other data checks (see Verified numbers). You can set an Above threshold alert on this metric to find out when settlement data stops arriving regularly. When you ask Si about the latest week's profit, the Sources section shows the "data as of" date so you know how fresh the number is.
FAQ
Do provisional fees make the monthly report wrong?
Only for the last days of the month that haven't settled. When closing the month, wait until that month's provisional fee rate is close to 0, or state clearly in the report which part is still provisional.
Are marketplace fees refunded on returned orders?
It depends on the marketplace and the fee. Some refund the percentage-based part; some fixed per-order fees are still charged even when the order is returned. Read the current policy in Seller Centre and check the settlement lines of a few real returns.
Why is my payout smaller than the revenue on the marketplace dashboard?
Because the dashboard usually shows gross revenue, while the payout comes after shop vouchers, refunds and all settled fees. The post on profit after marketplace fees walks through each gap.
Should I estimate fees with one flat rate for the whole shop?
Only to get started. Estimating by category and by the programs each SKU is enrolled in is much closer, especially when program fees are capped per product.
Read next: Marketplace fees in 2026 · Order-level vouchers: how to allocate them · Return rate and its real cost