Avoid duplicate revenue and advertising costs across ecommerce stores
Connect orders, settlements, cash receipts and shared advertising expenses without double counting or deleting unmatched records.
One ecommerce transaction can appear in an order export, a platform settlement and a bank statement. One advertising expense may also appear in an ad account and a platform deduction. Those records may be different evidence of the same activity: do not add them blindly, but do not delete a row solely because its amount matches another. Establish the legal entity, business relationship and question first; then reconcile the sources.
This guide is for mainland China businesses operating multiple ecommerce stores and their finance teams. Order amounts, cash receipts, accounting revenue and tax filings use different definitions. Cross-border platforms, currencies and overseas entities require separate checks of the applicable rules, exchange rates and business times.
Decide what each record answers
| Record | Typical question | Common mistake when combining |
|---|---|---|
| Orders and after-sales | What was sold, to whom and which amounts were refunded? | Add an order summary again after counting its item rows |
| Platform settlements | When did the platform settle, deduct or hold amounts? | Add settled sales again to the order total |
| Bank or payment transactions | How much cash arrived and when? | Treat a net withdrawal as another sale or ignore timing differences |
| Advertising accounts | Which account, campaign and period incurred spend? | Count ad spend and the platform charge for the same service twice |
| Contracts, invoices and books | Who supplied and bears a service, and how was it recorded? | Treat each payment, invoice and accounting entry as another expense |
Each source has a purpose; their amounts cannot all be summed as total revenue or cost. The State Taxation Administration's platform information-reporting announcement defines reported gross revenue, refunds and net revenue for that reporting regime; its gross figure does not deduct platform commissions or service fees. That reporting definition is not automatically the company's accounting revenue or bank receipt. Reconcile each figure under its own definition rather than replacing all revenue with net withdrawals or treating a platform report as tax payable.
Identify relationships, not just matching amounts
- Identify the entities and stores. List the actual operating entity, platform, shop, ad account and settlement account. For managed operations, authorized collection or multiple entities, establish the arrangement from contracts and facts, not an account name alone.
- Align periods and granularity. Identify the observation window and distinguish transaction, settlement and refund dates. Keep orders, order lines, after-sales events, settlement batches and bank receipts distinct. One order may have several partial refunds or payments.
- Use traceable links. Prefer the platform, shop and order, refund or statement identifiers and the business relationship, supported when needed by amounts, dates, contracts and settlement explanations. Identifiers may repeat across platforms; identical dates and amounts can still represent separate genuine transactions.
- Distinguish repeated exports from later events. After verification, repeated downloads and overlapping exports can be marked as duplicate sources. Partial refunds, changed dates and subsequent updates may be separate events or versions and should not all be removed.
- Retain unmatched items. Holds, cross-period refunds, split payments, platform adjustments and missing material can explain differences. Record the uncertainty and owner for follow-up; do not rewrite original data merely to force agreement.
Platform reporting has its own scope and timing. For example, the tax authority's explanation of platform reporting describes how a multi-store purchase can be counted according to orders generated by shop. That explanation concerns platform reporting and does not itself determine the business's internal revenue recognition.
A simplified example: orders, settlement and ad spend
Assume one mainland China business has two stores, with order amounts of RMB 12,000 and RMB 8,000 in the same period and confirmed refunds totaling RMB 2,000. The platform deducts RMB 1,800 in service fees; both refunds and fees are already deducted from this period's settlement. With no other adjustments or cross-period amounts, the combined net order amount is 12,000 + 8,000 − 2,000 = RMB 18,000, and the corresponding net settlement is 18,000 − 1,800 = RMB 16,200.
Adding the RMB 18,000 net orders to the corresponding RMB 16,200 settlement as RMB 34,200 would mix the same sales with their settlement. Receipt of that RMB 16,200 by the bank is not a further sale. These numbers only illustrate reconciliation; they do not separate VAT or include product costs and are not accounting profit or taxable sales.
A shared ad account has actual spend of RMB 1,500. Assume payment evidence shows it was paid separately by bank and is not included in the RMB 1,800 platform fees above. Under these example assumptions, comparing only those cash movements gives 16,200 − 1,500 = RMB 14,700; this is not the final cash balance or profit. If the ad spend is already inside the RMB 1,800, it must not be deducted again; inspect the statement item and payment evidence first. To compare stores, assume a supported allocation assigns RMB 1,000 and RMB 500 to the two stores. Their total remains RMB 1,500, not a new third expense. An assumed allocation is not an established business fact.
Use the reconciled records
Retain original files and versions, separating matched items, open questions and confirmed unmatched items. Choose order, settlement or cash basis to fit the question, and state the period and missing information. Keep traceability for material differences so owners can understand the result and finance staff can check the source records.
Start with the CaiGeek operating-profit example and the guide to platform fees and supporting evidence. Examples illustrate an approach; they do not mean your data is already connected or reconciled. To discuss an appropriate product or service arrangement, use the contact page and share business records only through an authorized channel.
Written with AI assistance. Examples illustrate analysis methods; apply them using business records and relevant conditions.
Move the work forward with CaiGeek.
Start with your question, supported by business context, data and memory.