Syntha Lab RU

The platform sales report and reconciliation of deductions: how to read the report, reconcile with brand records and file claims

The procedure of working with the platform report: what items the sales report (the report on sales, accruals) consists of, how to reconcile them with the brand records by the “expected versus actual” formula, how to find a discrepancy in revenue, commission, logistics, storage and fines and how to file a claim on time. With it the finance person closes the period and recovers the money the platform deducted in excess.

Finance Brand and retail Verified: 2026-11-14

Open interactively →

Why this document

The platform pays money under its own report, and the seller tends to accept the total as given. But the report is built from thousands of lines, and errors occur in price, quantity, logistics rate, fines and returns. If not reconciled, excess deductions accumulate and the claim term passes. The CFO, the accountant and the marketplace manager read this document. It gives one logic for any platform: whatever the item names, the payout equals revenue minus a group of deductions. The reconciliation runs by the same groups with a tolerance, and the claim is built on the difference and not on a feeling.

At a glance

What is this document and why is it needed?
The procedure of working with the platform report: what items the sales report (the report on sales, accruals) consists of, how to reconcile them with the brand records by the “expected versus actual” formula, how to find a discrepancy in revenue, commission, logistics, storage and fines and how to file a claim on time. With it the finance person closes the period and recovers the money the platform deducted in excess.
Who owns the document and how often is it rebuilt?
The CFO or chief accountant with the marketplace manager; a weekly pre-check and a monthly reconciliation for closing; claims are filed by the marketplace manager.
What mistakes are the most common?
Only the “payout” total is reconciled → errors in items cancel out → reconcile by groups of items with a tolerance. The claim term is missed → the money cannot be recovered → a reconciliation calendar and a claims register. The showcase price is compared with the report price → false discrepancies because of platform discounts → compare the price on which revenue is counted.

For whom

Brand
The brand reconciles the report with its own orders, shipments and prices: what was sold and at what price, what was returned, how many units were written off as defects; the discrepancy is most often in price and fines.
Retail
The retailer reconciles the report by the multi-brand range and store stock: many items, price changes and repeat sales require reconciliation by item and not only by the sum.

What it consists of

What the platform report consists of

  • Revenue (sales): the sum for bought-out goods at the price on which the platform counts your accruals; it may differ from the showcase price because of platform discounts
  • Commission: a share of the price or a sum by category; reconciled by the formula “rate × revenue” and by the card category
  • Logistics: forward delivery, reverse delivery, size surcharges and regional coefficients; reconciled by the number of orders and returns
  • Storage and acceptance: a fee for days of storage and acceptance; reconciled by warehouse stock and dates
  • Fines and deductions: for defects, term, packing, marking, description violations; reconciled with a supporting document for each
  • Advertising and other services: written off separately; reconciled with the ad account by the sum
  • Payout and received: the report total and the actual payment to the account; the difference shows a reserve held back or a payout failure

How to reconcile

  • Report arithmetic: revenue minus the sum of deductions must give the “payout”; a difference means a report error or a lost line
  • Revenue: kept units × price by your records is compared with the report revenue; a difference in price and quantity is sorted by item
  • Commission rate: actual commission ÷ revenue is compared with the category rate from the offer; a deviation points to a wrong category or another rate
  • Logistics: number of orders and returns × the rate from the offer; the size and warehouse must be known because the rate depends on them
  • Tolerance: small differences (rounding, exchange rate) are accepted within the tolerance; large ones are filed as a claim
  • Claim: report number, line, difference amount, supporting document (photo, acceptance act, account screenshot), filing term under the offer

Differences for the brand and the retailer

  • Brand: Records: the brand reconciles with its own production and shipments, sees lots and quality because defect fines concern its product.
  • Brand: VAT and tax: the brand chooses the tax regime and the platform report goes into income; reconcile the price with and without VAT.
  • Brand: Returns: the brand sees returns by lot and size; return causes go to production and the grid.
  • Brand: Documents: the brand reconciles the services act and closing documents with its contract and EDI.
  • Retailer: Items: a multi-brand retailer has thousands of items, so reconciliation goes by item and brand and not only by the total.
  • Retailer: Store stock: a platform sale is reconciled with the store stock; overlapping data gives overselling and fines.
  • Retailer: Own records: the retailer reconciles with the cash register and the warehouse and shows commission as a channel cost.
  • Retailer: Many platforms: reports of different formats must be brought to common groups, otherwise totals are not comparable.
  • Brand: Lots: the brand reconciles defects and returns with lot numbers to recover money from the factory.
  • Retailer: Claims register: the retailer keeps a common register of claims by platforms and brands and controls the terms.

Where the data comes from

Data sourceFields
Platform reports: sales, accruals, services actrevenue, commission, logistics, storage, acceptance, fines, advertising, payout
Brand records: orders, shipments, returns, priceskept units, price, number of orders and returns, defects
Bank statement and the ad accountreceipt, date, advertising amount

How to build it step by step

  1. Step 1: Export the report for the period and bring its items to common groups: revenue, commission, logistics, storage and acceptance, fines, advertising, other, payout.
  2. Step 2: Check the report arithmetic: revenue minus deductions equals “payout”; mark any difference.
  3. Brand: Step 3: Reconcile revenue with your shipments and prices by item; sort differences in price and quantity by lot.
  4. Retailer: Step 3: Reconcile revenue with store and warehouse stock by item and brand; check there are no double sales.
  5. Step 4: Recalculate commission by the category rate and logistics by the number of orders and returns; compare with the report and record the difference by every item.
  6. Brand: Step 5: For fines request the supporting document; contest fines without grounds, analyze the justified ones in the process (packing, term, marking).
  7. Retailer: Step 5: Group fines by brand and cause; repeating causes mean a process failure and not chance.
  8. Step 6: Reconcile the actual receipt with the bank statement and explain the difference from “payout” (reserve, bank fee, rate).
  9. Step 7: File a claim for differences above the tolerance with evidence within the offer term; mark the result in the claims register and check it in the next report.

Formulas

MeasureFormulasNote
Report arithmeticPayout = Revenue − Commission − Logistics − Storage − Acceptance − Fines − Other deductionsAdvertising and tax may go separately; reconcile them in a separate column of your own.
Discrepancy by itemΔ = Actual_by_report − Expected_by_records; goes to a claim if |Δ| > tolerance × ExpectedThe sign shows in whose favor the error is: positive for a deduction means more was deducted than expected.

Formulas in notation

Discrepancy
Δ_i = F_i − E_i, flag if |Δ_i| > τ·E_i
F_i the item sum by the report, E_i the expected sum by records, τ the tolerance (2% in the example).

Worked example

An illustrative reconciliation of a report for 100 orders: expected by records versus actual by the report (tolerance 2%; discrepancies are set illustratively)

ItemExpected, RUBBy the report, RUBDifference, RUBOutside tolerance
Revenue300,000298,500−1,500no
Commission45,00044,775−225no
Logistics11,00011,600600yes
Storage3,0003,0000no
Acceptance1,0001,300300yes
Fines1,2002,2001,000yes

Read it this way: revenue in the report is lower than expected by RUB 1,500 (within tolerance, sort it by item); logistics, acceptance and fines are above expected and outside the tolerance, they are filed as a claim. Advertising and tax are not shown. Figures are illustrative.

Figures

The report bridge: from revenue to payout
Waterfall: Revenue 299k, Commission −44.8k, Logistics −11.6k, Storage −3,000, Acceptance −1,300, Fines −2,200, Payout 236k0100k200k300kRevenueRevenueRevenue: 299k299kCommissionCommissionCommission: −44.8k−44.8kLogisticsLogisticsLogistics: −11.6k−11.6kStorageStorageStorage: −3,000−3,000AcceptanceAcceptanceAcceptance: −1,300−1,300FinesFinesFines: −2,200−2,200PayoutPayoutPayout: 236k236kRUB for the period
  • positive
  • negative
  • total
Data as a table
StepChangeLevel
Revenue—299k
Commission−44.8k254k
Logistics−11.6k242k
Storage−3,000239k
Acceptance−1,300238k
Fines−2,200236k
Payout—236k

The report bridge: from revenue to payout. Every item of deductions reduces revenue, the total matches the payout.

Differences by item: report minus expected
Bar chart: Revenue −1,500, Commission −225, Logistics 600, Storage 0, Acceptance 300, Fines 1,000−1,500−1,000−50005001,000RevenueRevenueDifference, RUB: −1,500−1,500CommissionCommissionDifference, RUB: −225−225LogisticsLogisticsDifference, RUB: 600600StorageStorageDifference, RUB: 00AcceptanceAcceptanceDifference, RUB: 300300FinesFinesDifference, RUB: 1,0001,000RUB
Data as a table
MeasureDifference, RUB
Revenue−1,500
Commission−225
Logistics600
Storage0
Acceptance300
Fines1,000

Differences by item: report minus expected. A positive difference on a deduction means the platform deducted more than expected; revenue is the other way round.

Specifics by category

Apparel
Apparel: many size returns, so reconciliation of return logistics and revenue deductions yields the largest part of discrepancies; reconcile by item and size.
Footwear
Footwear: dimensions depend on packing; check by which dimension logistics was counted; returns with wear are filed separately.
Accessories
Accessories: low price, so fixed services are more noticeable; an error of RUB 20 on hundreds of orders turns into a significant sum.
Kids
Kids: returns relate to size and quality; fines for marking and conformity documents are frequent, check the grounds.
Men
Men: fewer returns, the report is simpler; discrepancies are more often in price because of promotions.
Women
Women: more returns and partial buyouts; reconciliation by item and return dates finds the most money.

Common mistakes

  • Only the “payout” total is reconciled → errors in items cancel out → reconcile by groups of items with a tolerance.
  • The claim term is missed → the money cannot be recovered → a reconciliation calendar and a claims register.
  • The showcase price is compared with the report price → false discrepancies because of platform discounts → compare the price on which revenue is counted.
  • The basis of a fine is not requested → unjustified fines are accepted → a supporting document for every fine.
  • Reports of different platforms are confused → totals are not comparable → common item groups for all platforms.

Russian specifics

  • The period, the form of the report (sales, accruals, report on sales), the claim term and the dispute procedure are defined by each platform offer; check before building the regulation.
  • Income accounting under FSBU 9/2025 “Income”: revenue is recognized by contract terms; the platform commission is shown as an expense or a reduction of revenue depending on your model (agency, sale); agree with the accountant. Rule: Order 56n of 16.05.2025: FSBU 9/2025 Income (Ministry of Finance order of 16.05.2025 No. 56n).
  • Brand: The brand tax regime determines which amount goes into income: report revenue or payout; check with the accountant.
  • Retailer: Under the general tax system input VAT on platform services is taken by invoice or UPD; check the correctness of the documents.

Open interactively →