Xiaohongshu store settlement: reconcile orders, withdrawals and bank receipts

Trace the order through the payment chain

One merchandise order can move through customer payment → delivery → customer or system receipt confirmation → applicable settlement conditions → credit to the merchant account → withdrawal request → bank receipt. Refunds, after-sales cases, fees and restrictions can appear at different stages.

Xiaohongshu's financial settlement FAQ explains that a sales export based on payment time can differ from a statement based on receipt confirmation and other settlement events. Delivery by the carrier alone does not establish that the platform order is complete. The platform's settlement-rule notice also describes after-sales matters, account balances and frozen funds. These public materials may have been updated: verify the relevant period, agreement, notices and store records before relying on a particular deadline or interface.

Work through one batch

The following RMB figures are hypothetical. They illustrate reconciliation, not a customer case, platform fee rate or promised settlement period. Customers paid RMB 10,000 for a batch of orders. At the check date, RMB 7,500 has entered this settlement and RMB 2,500 has not; the latter includes orders with after-sales cases still being processed. Within the settled portion, a RMB 300 refund and RMB 350 in platform fees appear on this settlement. Assume no other subsidies, adjustments or currency conversion.

The RMB 3,150 difference between customer payments and this credit consists of RMB 2,500 not yet in this settlement, the RMB 300 refund and RMB 350 in fees. If an open after-sales order is already within the RMB 2,500, do not deduct it again. Determine the period in which any eventual refund actually appears from the statement.

Now assume the merchant account opened with RMB 1,000, received the RMB 6,850 credit, incurred a separate RMB 100 account charge and completed a RMB 6,000 withdrawal. With no other movements, the account balance is RMB 1,750. If RMB 600 of that balance remains frozen, the available balance is RMB 1,150. The frozen amount is still part of the account balance; it is not automatically an expense. If money is later deducted, review the actual reason and supporting entry. Check the bank statement to establish whether the RMB 6,000 has arrived: a request or successful platform processing is not itself a bank credit.

Give every difference a destination

Preserve the original platform exports and choose the same store, order batch and cut-off time for each step:

1. Define the scope. Record the seller, store, currency, customer-payment period and cut-off. Separate cancelled, paid-but-unsettled and settled orders. Do not compare one month's payments directly with a different month's bank receipts.
2. Connect orders and after-sales records. Match order and item references to receipt confirmation, case status and actual refunds. Track multiple partial refunds separately. Leave an unresolved case open until evidence explains it.
3. Match settlement to the account. Identify each statement containing the batch, then separate refunds, platform charges, logistics or other fees and later manual adjustments. A charge taken directly from the account may be absent from the settlement statement; record it once in the appropriate account movement.
4. Match withdrawals to the bank. Use withdrawal batch, date, amount and receiving account. One withdrawal can include several settlements. Record amounts in transit and cross-period receipts instead of forcing each bank line to equal one day's sales.
5. Retain exceptions. Record the difference, possible explanation, responsible reviewer, missing evidence and next check date. For a dispute, preserve the order, after-sales, statement and support-case evidence, then follow the applicable procedure and deadline.

For an English-language handover, explain the original platform fields alongside their Chinese names. Include currency and legal entity so that a translated “settlement” or “balance” is not mistaken for accounting revenue or cash in the bank. An overseas receipt also requires the actual payment provider, exchange rate and bank charges to be checked. An owner's nationality does not identify the seller or receiving entity.

Settlement is not the same as revenue or profit

A platform statement is important evidence for funds and fees, but it is not a complete profit statement. Product cost, warehousing, advertising and outsourced store-operation costs may appear elsewhere. A frozen balance is not necessarily a loss. Accounting revenue and tax treatment depend on the actual seller, delivery, contracts and applicable rules; neither the bank-receipt date nor the platform settlement date automatically establishes the accounting recognition date.

CaiGeek is an AI financial assistant for small and medium-sized businesses. Start with one order batch and the associated after-sales and settlement records, with finance professionals reviewing the treatment for the actual circumstances. Explore the reconciliation example, read about available marketplace cash, or contact CaiGeek about the part that does not reconcile.

Public sources were checked on 6 November 2026. Verify the store's applicable terms, fees, withdrawal rules and dispute process for the relevant period. The example explains a cash reconciliation and is not an accounting or tax determination.