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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| Revenue (sales) by the report | ₽ | 300,000 | The 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,775 | The 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,600 | Forward 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,300 | The 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,200 | All 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,000 | The 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 | ₽ | 0 | Deductions 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 payout | deducted from the payout | If 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,625 | The 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,625 | The 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,500 | Kept 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 | % | 15 | The 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 period | pcs | 100 | The 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 | ₽ | 90 | The 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 period | pcs | 25 | The 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 | ₽ | 80 | The 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,000 | Your 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,200 | Fines 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,000 | The 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 | ₽ | 0 | Paid 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 | % | 2 | The 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 | ₽ | 100 | A 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
| Step | Formula |
|---|---|
| Report arithmetic | payout = revenue − (commission + logistics + storage and acceptance + fines + advertising + other); advertising is excluded if paid separately |
| Expected commission | rate from the offer × the report revenue |
| Expected logistics | orders × forward rate + returns × reverse rate |
| Tolerance by item | the larger of the percent tolerance of the expected and the minimum sum |
| Sum for a claim | excess 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.
Data as a table
| Measure | Difference |
|---|---|
| Revenue | −1,500 |
| Commission | −225 |
| Logistics | 600 |
| Storage and acceptance | 300 |
| Fines | 1,000 |
| Advertising | 0 |
| Other deductions | 0 |
Reconciliation by item
| Item | By the report | Expected | Difference | Difference, % | Verdict |
|---|---|---|---|---|---|
| Revenue | 300,000 ₽ | 301,500 ₽ | −1,500 ₽ | −0.5 | within tolerance |
| Commission | 44,775 ₽ | 45,000 ₽ | −225 ₽ | −0.5 | within tolerance |
| Logistics | 11,600 ₽ | 11,000 ₽ | 600 ₽ | 5.5 | deducted more |
| Storage and acceptance | 4,300 ₽ | 4,000 ₽ | 300 ₽ | 7.5 | deducted more |
| Fines | 2,200 ₽ | 1,200 ₽ | 1,000 ₽ | 83.3 | deducted more |
| Advertising | 24,000 ₽ | 24,000 ₽ | 0 ₽ | 0 | within tolerance |
| Other deductions | 0 ₽ | 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.