Western brands selling on Chinese marketplaces spend a staggering share of gross revenue on platform advertising — Alimama on Tmall, Qianchuan on Douyin, and JD’s ad suite on JD.com. Yet when finance closes the books, that ad spend almost never lines up cleanly with the marketplace payouts it was supposed to drive. The result is a net margin number nobody trusts.
China marketplace ad spend reconciliation is the process of matching advertising costs from Alimama, Qianchuan, and JD Ads against the marketplace orders, settlements, and payouts they generated — then posting that reconciled cost of sale into your Western ERP so true net margin is visible at the channel and SKU level. This guide explains why it breaks, what a correct reconciliation looks like, and how to automate it in 2026.
The short answer
If you only read one section, read this:
- Chinese marketplace ad platforms report spend in their own dashboards, own currency (RMB), and own attribution windows — none of which match how your ERP records revenue or cost.
- Ad spend is deducted in multiple places: prepaid ad wallets, in-settlement deductions, and separate invoices — so the same yuan can be double-counted or missed entirely.
- Without reconciliation, brands overstate net margin on advertised SKUs and understate it on organic ones, distorting which products and channels are actually profitable.
- A defensible reconciliation ties every ad cost to a marketplace, campaign, date, and ideally SKU, converts RMB to your reporting currency at a consistent rate, and posts it as cost of sale in the same period as the revenue it drove.
The three ad ecosystems you have to reconcile
Each major Chinese marketplace runs its own advertising stack with distinct products, billing models, and data exports. You cannot treat them as one line item.
Alimama (Tmall & Taobao)
Alimama is Alibaba’s marketing platform covering Tmall and Taobao. Brands buy through products such as Zhitongche (pay-per-click keyword ads), Pinxiaobao / Wanxiangtai (integrated bidding), and brand zone placements. Spend is typically drawn from a prepaid balance, which means the cash outflow (topping up the wallet) and the accounting cost (ads actually served) happen on different dates.
Qianchuan (Douyin ecommerce)
Qianchuan is Douyin’s ecommerce ad platform, powering both content-driven and livestream commerce. Because Douyin blends organic short-video reach, paid boosts, and livestream ad spend, isolating the paid cost attributable to a specific order is harder here than on any other channel. See our deeper look at China social commerce analytics for how Douyin data flows.
JD Ads (Jingzhun Tong & JD Zhitou)
JD.com offers its own search and display ad products. JD’s advantage is that ad costs and marketplace settlement both flow through the JD merchant back office — but the reporting formats still differ from Tmall and Douyin, so a unified view requires normalization.
| Platform | Marketplace | Billing model | Reconciliation challenge |
|---|---|---|---|
| Alimama (Zhitongche, Wanxiangtai) | Tmall / Taobao | Prepaid wallet | Cash top-up date ≠ cost-incurred date |
| Qianchuan | Douyin | Prepaid + in-account | Paid vs. organic vs. livestream attribution |
| JD Ads (Jingzhun Tong) | JD.com | Prepaid + deducted | Format normalization vs. other channels |
Why China ad spend never reconciles to your ERP
Four structural mismatches turn a simple “how much did we spend on ads?” question into a month-long finance headache.
1. Prepaid wallets break period matching
You wire, say, ¥500,000 into an Alimama wallet in March. Ads draw down that balance through April and May. If finance books the ¥500,000 as March ad expense, margin is wrong in all three months. Correct accounting treats the top-up as a prepaid asset and expenses only the ads actually served each period — which requires the platform’s consumption report, not the payment receipt.
2. Spend lives outside the settlement file
Marketplace settlement files reconcile order revenue, commissions, and payouts. But a large portion of ad spend is deducted from a separate prepaid wallet that never appears in the settlement statement. Brands that reconcile only settlement data systematically miss the biggest variable cost on the channel.
3. Currency and timing drift
Ad platforms report in RMB. Your ERP reports in USD, EUR, or GBP. If you convert ad spend at a different rate (or on a different date) than you convert the revenue it drove, the ad-cost ratio distorts even when both numbers are individually correct. Consistent FX handling is a recurring theme in why your China P&L is always two weeks late.
4. Attribution windows don’t match your revenue recognition
Ad dashboards attribute a sale to a click that may have happened 7, 15, or 30 days earlier, depending on the platform’s window. Your ERP recognizes revenue when the order ships or the settlement clears. Forcing platform ROAS numbers directly into finance without re-anchoring them to your recognition rules produces contradictory margin figures between marketing and finance.
What a correct ad spend reconciliation looks like
A defensible monthly reconciliation answers four questions for every marketplace, and ideally every campaign and SKU:
- How much did we actually consume? Pull the platform consumption/expense report (ads served), not the wallet top-up receipt.
- What revenue did it drive, in our terms? Re-anchor platform-attributed sales to your own revenue-recognition period and marketplace order IDs.
- What is the true cost of sale? Combine ad spend with marketplace commissions and fees and returns/refund erosion to get net contribution, not gross ROAS.
- Where does it post? Convert RMB to reporting currency at your standard rate and post to the correct GL account, cost center, and period in the ERP.
Gross ROAS from an ad dashboard is a marketing metric. Net margin after ad spend, commissions, and returns is a finance metric. Reconciliation is what turns the first into the second.
A worked example
Consider one Tmall SKU in a month:
| Line | Value (RMB) | Notes |
|---|---|---|
| Gross marketplace sales | ¥1,000,000 | Before any deductions |
| Alimama ad spend (consumed) | −¥180,000 | From consumption report, not wallet top-up |
| Marketplace commission & fees | −¥50,000 | From settlement file |
| Returns & refunds | −¥120,000 | Reconciled to actual refunds |
| True net revenue | ¥650,000 | What actually reaches the P&L |
The platform dashboard would have reported a healthy 5.5x ROAS on that ¥180,000. But after fees and returns, the ad-driven net contribution is far lower — and that is the number your board should see. Getting there is impossible without joining ad, settlement, and returns data into one reconciled record.
How to automate it in 2026
Manual reconciliation in spreadsheets collapses the moment you add a second marketplace or a third currency. A durable approach has four layers:
- Ingestion: Pull ad consumption reports, settlement files, and order data from each platform on a scheduled cadence — not by hand-exporting CSVs at month-end.
- Normalization: Map every platform’s columns, currencies, and attribution fields into a single schema. This is where most in-house projects stall — see why dirty China marketplace data breaks your ERP.
- Reconciliation logic: Match ad spend to campaigns, orders, and SKUs; apply consistent FX; and net out fees and returns to produce true cost of sale.
- ERP posting: Push reconciled journal entries into NetSuite, SAP, or your ERP of record so finance works from one source of truth.
This is precisely the pipeline Digate’s China marketplace–ERP integration automates: connecting Tmall, JD, Douyin, and Pinduoduo — including their advertising platforms — to your Western ERP so unified P&L reporting reflects real net margin, not dashboard ROAS.
Frequently asked questions
What is China marketplace ad spend reconciliation?
It is the process of matching advertising costs from Chinese marketplace ad platforms — Alimama on Tmall, Qianchuan on Douyin, and JD Ads — against the orders and payouts they generated, then posting that reconciled cost into your ERP so net margin is accurate at the channel and SKU level.
Why doesn’t Alimama ad spend appear in my Tmall settlement file?
Because most Alimama spend is drawn from a separate prepaid advertising wallet, not deducted inside the order settlement statement. Reconciling settlement data alone will miss it, so you must pull the Alimama consumption report separately and combine the two.
How should prepaid ad wallets be accounted for?
Treat a wallet top-up as a prepaid asset, then expense only the ads actually consumed in each accounting period based on the platform’s consumption report. Booking the full top-up as expense on the payment date misstates margin across every period the balance is spent.
Is platform ROAS the same as net margin?
No. ROAS from an ad dashboard is gross revenue divided by ad spend. Net margin subtracts ad spend and marketplace commissions, fees, and returns. A SKU with strong ROAS can still be unprofitable once fees and refunds are reconciled in.
See your true net margin across China marketplaces
Digate connects Tmall, JD, Douyin, and Pinduoduo — orders, settlements, fees, returns, and advertising — to NetSuite, SAP, and other Western ERPs, so finance sees reconciled net margin instead of disconnected dashboards. Learn how Digate unifies your China P&L →