Syntha Lab RU

Platform report reconciliation: deductions by item, payout and the difference from the records

Compares the platform report for the period with your records: checks the arithmetic of the report (revenue minus deductions equals the payout), reconciles revenue, commission by rate, logistics by the number of orders and returns, storage, fines, advertising and other with the expected, shows the items outside the tolerance, the difference between the report payout and the receipt on the account and the sum worth claiming.

Platforms and marketplaces For whom: Finance people and platform managers who close the period by the platform report and want to recover money deducted above the expected.

Calculate on your data →

At a glance

What question does it answer?
Whether the platform report matches your records, which items went outside the tolerance and what sum is worth claiming.
What data is needed?
The report items for the period: revenue, commission, logistics, storage and acceptance, fines, advertising, other, payout.
How to read the result?
Example on the default values (100 orders): deductions RUB 86,875, 29% of revenue; the report arithmetic is off by −RUB 500, 4 checks are outside the tolerance, the sum for a claim RUB 2,400. Example on the default values: Deductions by the report, total: RUB 86,875; Deductions share of revenue: 29%; Payout recalculated: RUB 213,125; Report arithmetic discrepancy: −RUB 500. The figures are illustrative: enter your own to see your result.

Why and how to reason

The platform pays the seller by its own report, and the seller has a habit of accepting the total as given. But the total in the report is the result of a long chain: revenue for bought-out goods from which commission, logistics, storage and acceptance, fines, advertising and other are deducted. Any of these items may contain an error: a wrong category, an extra order in logistics, a fine without grounds. If you look only at “payout”, errors in different directions cancel each other out and go unnoticed. So the calculation does three things. First it checks the arithmetic of the report itself: revenue minus deductions must give the payout. Then it compares every item with what you expect by your records. Finally it cuts off small stuff with a tolerance and collects what is worth claiming. At the default values the deductions are RUB 86,875 (29% of revenue), by its items the payout is RUB 213,125, while the report shows RUB 212,625: the arithmetic is off by RUB 500, and the total sum for a claim is RUB 2,400.

When to use it

Apply it after every platform report for a week or a month and always before closing the period: the claim term is limited by the offer. The calculation works well when you have your own records of shipments, returns and advertising and you know the rates from the offer. It does not replace reconciliation by item: if the difference is large, find the cause in the report lines. Assumptions: one commission rate for the whole report, average logistics rates, one period and one currency. If you have several categories with different commissions, reconcile each separately.

How to read the result

Start with the “Report arithmetic discrepancy”: zero or within the tolerance means the report is built correctly. Minus means the platform paid less than follows from its own items, the most direct claim. Then “Items outside the tolerance” shows how many checks went over the threshold and the reconciliation table shows which ones. A positive difference on a deduction means the platform deducted more than expected; a negative difference on revenue means less was counted than by your records. “Received against the report” catches a payment failure or a reserve. The “Sum for a claim” adds only what is outside the tolerance and it does not prove a platform error: every part needs a supporting document.

Common mistakes

The first mistake is to enter the showcase price instead of the price on which the platform counts accruals into “revenue by records”: platform discounts will give a false shortfall. The second is to set the tolerance to zero or very large: in the first case you drown in pennies, in the second you miss real sums. The third is to count expected logistics at one rate for all sizes and regions. The fourth is to file a claim without a supporting document and after the offer term.

What data is needed?

  • The report items for the period: revenue, commission, logistics, storage and acceptance, fines, advertising, other, payout.
  • Your records: kept units at price, orders and returns, the ad account spend, justified fines.
  • The rates from the offer on the date of the calculation and the tolerance.
  • The receipt by the bank statement.

Inputs

FieldUnitValue in the exampleMeaning
Revenue (sales) by the report₽300,000The sum for bought-out goods at the price on which the platform counts your accruals; the “sales” or “accrued for goods” line. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Commission by the report₽44,775The sales commission for the period; if the report has several commission lines, add them up. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Logistics by the report₽11,600Forward and reverse delivery, size and regional surcharges for the period, all logistics lines together. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Storage and acceptance by the report₽4,300The fee for days of storage in the platform warehouse and for accepting a delivery; usually zero in own-warehouse schemes. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Fines by the report₽2,200All fines and sanctions for the period shown in the report (defects, terms, packing, marking, description). The example value is illustrative: substitute your own from the offer on the date of the calculation.
Advertising by the report₽24,000The promotion spend written off by the platform for the period; if you pay advertising separately, enter its sum and choose “separately”. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Other deductions by the report₽0Deductions not included in the items above: paid services, subscriptions, adjustments; add them up. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Advertising in the payoutdeducted from the payoutIf the platform deducts advertising from the money to be paid, choose the first; if advertising is paid separately, choose the second: then it is not part of the payout arithmetic.
Payout by the report₽212,625The final line of the report “to be paid”. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Received on the account₽212,625The actual payment by the bank statement for this report; the difference from the report payout shows a reserve, a bank fee or a failure. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Revenue by your records₽301,500Kept units × the price on which the platform should count accruals; from your shipments and returns. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Commission rate from the offer%15The commission rate for your card category on the date of the calculation; take it from the offer and the account and not from an article. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Orders for the periodpcs100The number of delivered orders for the period by your records; forward logistics is paid on each. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Forward logistics rate₽90The average forward delivery rate per order allowing for size and region; from the offer or past reports. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Returns for the periodpcs25The number of returned and unclaimed units for the period; reverse logistics is paid on each. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Reverse logistics rate₽80The average return rate per unit; from the offer or past reports. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Expected storage and acceptance₽4,000Your calculation by the stock in the platform warehouse, days and rates; for own-warehouse schemes put zero. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Justified fines₽1,200Fines for which you have a supporting document and with which you agree; everything above goes into the discrepancy. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Spend by the ad account₽24,000The sum of spend for the period by your ad account; compared with the advertising line in the report. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Expected other deductions₽0Paid services and subscriptions you know about; the rest in other by the report will be a discrepancy. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Tolerance by item%2The percent of the expected item sum within which a discrepancy counts as rounding and is not claimed. The example value is illustrative: substitute your own from the offer on the date of the calculation.
Minimum claim sum₽100A discrepancy smaller than this sum is not worth the time of a claim; the tolerance is the larger of the two values. The example value is illustrative: substitute your own from the offer on the date of the calculation.

How it is calculated

StepFormula
Report arithmeticpayout = revenue − (commission + logistics + storage and acceptance + fines + advertising + other); advertising is excluded if paid separately
Expected commissionrate from the offer × the report revenue
Expected logisticsorders × forward rate + returns × reverse rate
Tolerance by itemthe larger of the percent tolerance of the expected and the minimum sum
Sum for a claimexcess deductions outside the tolerance + revenue shortfall + arithmetic underpayment + receipt shortfall

Worked numbers

Default values from the app; in the interactive version you enter your own.

Deductions by the report, total
86,875 ₽The sum of all deduction items, including advertising.
Deductions share of revenue
29 %What part of revenue the platform and advertising take together before your cost and tax.
Payout recalculated
213,125 ₽Revenue minus deductions by the report arithmetic (advertising counted by the chosen mode).
Report arithmetic discrepancy
−500 ₽The report payout minus the recalculated payout: minus means the report pays less than follows from its own items.
Received against the report
0 ₽Receipt on the account minus the report payout: minus means a shortfall (reserve, bank, failure).
Revenue: report minus records
−1,500 ₽Minus means the platform counted less revenue than by your records: check price and quantity by item.
Items outside the tolerance
4Revenue, deduction items, the report arithmetic and the receipt: how many checks went outside the tolerance.
Sum for a claim
2,400 ₽Excess deductions, revenue shortfall, underpayment by arithmetic and receipt shortfall; each part needs a supporting document.
Difference by item: report minus expected
Bar chart: Revenue −1,500, Commission −225, Logistics 600, Storage and acceptance 300, Fines 1,000, Advertising 0−1,500−1,000−50005001,000RevenueRevenueDifference: −1,500−1,500CommissionCommissionDifference: −225−225LogisticsLogisticsDifference: 600600Storage and acceptanceStorage andacceptanceDifference: 300300FinesFinesDifference: 1,0001,000AdvertisingAdvertisingDifference: 00Other deductionsOther deductionsDifference: 00₽
Data as a table
MeasureDifference
Revenue−1,500
Commission−225
Logistics600
Storage and acceptance300
Fines1,000
Advertising0
Other deductions0

Reconciliation by item

ItemBy the reportExpectedDifferenceDifference, %Verdict
Revenue300,000 ₽301,500 ₽−1,500 ₽−0.5within tolerance
Commission44,775 ₽45,000 ₽−225 ₽−0.5within tolerance
Logistics11,600 ₽11,000 ₽600 ₽5.5deducted more
Storage and acceptance4,300 ₽4,000 ₽300 ₽7.5deducted more
Fines2,200 ₽1,200 ₽1,000 ₽83.3deducted more
Advertising24,000 ₽24,000 ₽0 ₽0within tolerance
Other deductions0 ₽0 ₽0 ₽—within tolerance

4 checks are outside the tolerance; the sum for a claim is 2,400 ₽: deducted above expected 1,900 ₽, revenue understated by 0 ₽, underpayment by arithmetic 500 ₽, receipt shortfall 0 ₽. File the claim within the offer term with documents for each item.

The calculation reconciles sums and not causes: a discrepancy points to where to look but does not prove a platform error. For fines and logistics supporting documents are needed (acts, photos, size, warehouse). Count expected logistics by average rates: the exact rate depends on size and region. The claim term and procedure are defined by the offer.

Nuances and limits

  • Comparing only the “payout” total: errors in items cancel each other out.
  • Comparing the showcase price with the report price: platform discounts give false discrepancies.
  • Filing a claim without a supporting document: a fine and logistics need an act or a photo.
  • Missing the claim term: the money can no longer be recovered.

Terms used

Calculate on your data →