A seller sees a payout in the marketplace account and compares it with last week's profit. The figures differ. That does not automatically mean money is missing: payout, revenue and profit answer different questions. Start with the reporting period and source transactions instead of forcing the numbers to match.
Separate the three measures
Revenue belongs to confirmed sales in the selected period. Profit deducts product cost, marketplace fees, fulfillment, advertising and other attributable expenses. Payout is a transfer of cash from the marketplace. It may include prior-period sales, deductions, returns, compensation and adjustments from another settlement cycle.
Consequently, “weekly profit = bank transfer” is not a valid control. A difference is a question to investigate, not proof of an error.
Build a reconciliation bridge
Choose one seller account, currency and marketplace statement date. Preserve the source export and its retrieval time. Then:
- Separate sales, cancellations and returns by transaction date and statement date. An order, a completed sale and a payout are different events.
- Map accruals and deductions to fee, fulfillment, storage, advertising, compensation and other adjustment lines. Keep unknown lines visible.
- Identify transactions belonging to earlier or later periods, particularly late returns and corrections.
- Add costs missing from the marketplace payout: inventory cost, external advertising, packaging, staff work and other expenses under your accounting rule.
- Reconcile the seller account and period first; only then attribute amounts to individual SKUs. If a source line lacks a reliable product identifier, do not invent an allocation to make a dashboard look complete.
Illustrative numbers: the marketplace paid 80,000 rubles for one settlement cycle. It included 6,000 rubles from last week's sales and a 2,000-ruble late deduction. The internal profit view for the current week also includes 35,000 rubles of inventory cost. These are different views; a payout alone cannot establish profit. The figures are invented and are neither a marketplace tariff nor a customer result.
Investigate what remains unexplained
For each unmatched amount, record the source, transaction ID, sale date, charge date, payout date, SKU if available, line type and review status. This becomes a short list of questions for the marketplace or accounting team. When detail is missing or import is incomplete, label the figure provisional and show a range rather than a precise net-profit claim.
This extends our guide to comparing FBS with the Wildberries warehouse for one SKU: compare fulfillment models only after their costs and periods are aligned.
ProfitVena helps combine supported seller-account data and Excel/CSV imports to inspect sales, returns, deductions and product economics with source context. Automatic data coverage varies by marketplace, connection and data quality; a person should make the final reconciliation against the official statement. The technical part is updated in ProfitVena, part of the Виксора ecosystem.
