Closing the books on China marketplace revenue is where most global brands lose their grip on the numbers. By the time settlement files from Tmall, JD, Douyin and Pinduoduo land in a shared drive, the finance team is already days into the close, wrestling with platform fees they can’t map, refunds that post in the wrong period, and a gross-to-net gap no one can explain. The result is a China P&L that arrives late, gets a manual override, and never fully ties to the ERP.
This is the operating checklist we use to run a clean, repeatable China marketplace month-end close — the sequence of reconciliations, cut-off rules, and controls that turn a pile of settlement statements into audit-ready numbers your controller can sign.
A China marketplace month-end close is the structured process of reconciling each marketplace’s settlement data to your ERP general ledger for the period — matching gross sales, platform deductions, refunds, ad spend, and cash to arrive at a net revenue and receivable figure that is complete, accurate, and supportable. Done well, it produces a China P&L that reconciles to both the platform statements and the bank in one pass, with a documented evidence trail for audit.
The short answer: what a clean China close requires
If you only remember five things about closing China marketplace revenue, make it these:
- Close per platform, then consolidate. Tmall, JD, Douyin, PDD and Xiaohongshu each settle differently — reconcile each to its own settlement file before rolling up.
- Reconcile gross-to-net, not just cash. The gap between order value and cash received is real revenue detail (commissions, subsidies, penalties) that belongs in the P&L by line, not netted into one number.
- Enforce a cut-off rule. Marketplace settlement lags the sale — decide whether you recognize on order, ship, or settlement, and apply it consistently every period.
- Tie three data sets, not two. Platform statement, ERP GL, and bank must all reconcile. Two-way ties hide breaks.
- Keep the evidence trail. Every adjusting entry should link back to a settlement line or fapiao so year-end and SOX testing don’t reopen the close.
Why China marketplace closes break where Western ones don’t
A domestic Amazon or Shopify close is largely a solved problem. China is not, because the settlement mechanics, currency, and tax layer are fundamentally different — and because most integrations were never built to survive them. If your close is chronically late, the root cause is usually one of the reasons we cover in why China marketplace-to-ERP integrations break.
1. Every platform settles on its own logic
Tmall settles T+7 to T+15 after confirmed receipt; JD splits 1P (self-operated) and 3P (POP) into two entirely different accounting models; Douyin blends influencer commissions and Qianchuan ad spend into the same statement. You cannot run one reconciliation template across all of them. Each needs its own mapping — see our deep dives on Tmall settlement reconciliation, JD 1P vs 3P accounting, and Douyin (Doudian) reconciliation.
2. Deductions are the P&L, not a rounding error
Platform commissions, quality deductions (扣款), fines (罚款), and chargebacks can swing gross-to-net by 15–30%. Netting them into a single “marketplace revenue” line destroys margin visibility. Booking them correctly is a core close step — our guide to China marketplace deductions and penalties reconciliation breaks down each category.
3. Tax and invoicing run on a separate clock
Fapiao (发票) issuance under the Golden Tax System doesn’t align neatly with settlement or shipment, so revenue, VAT, and the tax invoice can land in three different periods. Reconciling them is its own workstream — see fapiao reconciliation.
The China marketplace month-end close sequence
Run the close in this order. Each step depends on the one before it, and skipping ahead is why numbers don’t tie.
- Cut-off lock. Freeze the period and pull every platform settlement file, order export, refund report, and ad-spend statement for the month. Confirm each platform’s statement covers the full period with no gaps.
- Gross sales reconciliation. Match platform order value to your order-management or ERP sales sub-ledger, per platform. Investigate any variance above your materiality threshold before moving on.
- Deductions and fees. Map every commission, service fee, subsidy (e.g. PDD’s 百亿补贴 subsidy), penalty and chargeback to its GL account. This is where gross becomes net.
- Refunds and returns. Recognize returns in the correct period and true-up any refund reserve. Refunds that settle next month against this month’s sales are the #1 cut-off break.
- Inventory and COGS. Reconcile units sold, returned, and in bonded/consignment warehouses back to stock on hand — the step covered in China marketplace inventory reconciliation.
- Cash application. Match platform payouts to bank deposits and clear the marketplace receivable. Any unsettled balance at period end is your China AR — it must be explainable line by line.
- FX translation. Convert RMB settlement balances to your reporting currency at the correct rate, and revalue the open receivable. Follow SAFE (State Administration of Foreign Exchange) rules for cross-border settlement.
- Journal entry and GL posting. Post the consolidated entries per your China chart-of-accounts mapping and confirm the ERP GL ties to the platform statements and the bank.
- Evidence trail and sign-off. Link every adjusting entry to source, per our audit evidence trail guide, and get controller sign-off.
The three-way tie: the control that makes a close audit-ready
A China close is only trustworthy when three independent data sets agree for the period:
- Platform settlement statement — the marketplace’s record of what you earned and what it deducted.
- ERP general ledger — your recognized revenue, receivable, and cost.
- Bank — the cash that actually arrived, net of FX and cross-border fees.
Most brands only tie two of the three — usually GL to bank — which hides the deductions and timing differences buried in the platform statement. The three-way tie is what turns a plausible number into a defensible one, and it’s the reconciliation standard auditors expect under revenue-recognition frameworks like IFRS 15 and ASC 606.
Common close failure modes (and the fix)
Netting deductions into one line
Booking only net cash destroys margin analysis and makes penalty trends invisible. Fix: book gross revenue and each deduction category to its own GL account every period.
Inconsistent revenue recognition timing
Switching between order-date and settlement-date recognition between periods breaks comparability. Fix: document one policy, apply it consistently, and handle the lag with an accrual, not a timing change.
Manual spreadsheet consolidation
A month-end that lives in fifteen hand-built workbooks doesn’t scale, doesn’t audit, and breaks the moment a platform changes its statement format. Fix: automate the settlement-to-GL mapping so the close is repeatable and the evidence trail is captured by default.
The month-end close checklist
Use this as your period-end control sheet. Every box should be tied to evidence before sign-off:
- All platform settlement, order, refund, and ad-spend files pulled for the full period
- Gross sales reconciled to sales sub-ledger, per platform, within materiality
- Every deduction, fee, subsidy, and penalty mapped to a GL account
- Returns and refunds recognized in the correct period; refund reserve trued-up
- Units and COGS reconciled to inventory, including bonded and consignment stock
- Platform payouts matched to bank; marketplace receivable explained line by line
- RMB balances translated and open receivable revalued at period-end FX
- Consolidated journals posted; ERP GL ties to platform statements and bank (three-way tie)
- Every adjusting entry linked to a settlement line or fapiao for audit
- Controller sign-off recorded with a dated close package
How Digate fits
Digate connects Chinese marketplaces — Tmall, JD, Douyin and Pinduoduo — directly to Western ERPs like NetSuite, SAP S/4HANA and Dynamics 365, so the settlement-to-GL mapping that usually eats the first week of your close runs automatically. Gross sales, every deduction category, refunds, FX, and cash are reconciled to source and posted with a linked evidence trail — giving finance a China P&L that ties on the first pass and closes on schedule. It’s unified P&L visibility across your China marketplace operations, without the spreadsheet marathon.
Frequently asked questions
How long should a China marketplace month-end close take?
With settlement-to-GL mapping automated, the marketplace portion of the close should take one to two days — the delay in most brands comes from manual reconciliation and chasing deductions, not the accounting itself.
Should we recognize revenue on order, shipment, or settlement?
Under IFRS 15 / ASC 606, recognize when control transfers — typically at shipment or delivery, not when the platform settles cash. Settlement lag is handled with a receivable and accrual, and the policy must be applied consistently every period.
How do we handle refunds that settle in the next period?
Recognize returns against the original sale’s period and carry a refund reserve for expected returns. Refunds that settle later reduce the receivable, not next month’s revenue — this is the most common cut-off error in China marketplace closes.
Can one reconciliation template cover all Chinese marketplaces?
No. Tmall, JD 1P vs 3P, Douyin, Pinduoduo and Xiaohongshu each settle on different logic. Each needs its own mapping, then a consolidated roll-up into a single China P&L.