From Marketplace Report to Real Profit: A Step-by-Step ProfitVena Workflow

A marketplace payout is a movement of cash. Revenue is the value of sales recognized under a defined rule. Profit is what remains after every cost attributable to those sales. The three figures can be very different.

That is why “How much did the marketplace transfer?” cannot replace “What did we earn on each product during this period?” A useful management calculation must be repeatable, use consistent rules and let the team trace every result back to its source.

This guide presents a practical Wildberries workflow: what data to prepare, how to organize it in ProfitVena and how to move from the account-level result to an SKU decision.

This is a management accounting workflow. It does not replace statutory accounting, a tax return or professional accounting advice. Tax treatment and revenue recognition must follow the applicable rules and primary records.

Define the layers of profit

Use several explicit layers instead of one ambiguous “net profit” figure:

Recognized revenue
= sales − returns − revenue adjustments

Contribution profit
= recognized revenue − marketplace fees − logistics − storage − advertising − cost of goods sold − other variable costs

Result before tax
= contribution profit − allocated operating expenses

Keep tax on a separate line using data from the approved accounting process. This prevents an assumption in a management model from appearing to be an accounting fact.

Step 1: Define the calculation framework

Before importing a file, record:

1. Period and time zone.
2. Seller account, legal entity and region.
3. Sales recognition rule, such as the realization date in the financial report.
4. Cost method and allocation basis for shared expenses.

This prevents a common failure: sales are selected by order date, services by report date and payouts by bank date. The numbers belong to different time slices but are presented as one month.

You also need a cut-off rule for late operations. State whether a later adjustment reopens the previous period or enters the next calculation.

Step 2: Preserve the source data

A minimum dataset includes:

• sales, returns and adjustments;
• commissions and payment processing;
• outbound and return logistics;
• storage, receiving and other services;
• advertising;
• cost of goods sold;
• packaging, labeling and external delivery;
• operating expenses;
• bank payouts for a separate reconciliation.

Keep the original CSV or Excel file as an evidence layer. Do not repair it manually. If transformation is necessary, create a working copy and a change log describing which field changed, why, when and by whom.

ProfitVena currently provides a live Wildberries workflow. Calculation coverage depends on connected sources, data freshness, completed cost data and workspace settings. Other marketplaces remain on the roadmap until a live connection is confirmed for a specific workflow.

Step 3: Check period and data coverage

Before reading a profit figure, confirm:

• the period covered by the data;
• the source's last update time;
• which costs are absent from the marketplace account.

The marketplace may provide commissions and logistics but cannot know the supplier cost, team payroll or advertising paid elsewhere. A technically successful import is still incomplete if those inputs are missing.

A practical rule is: no source means no confirmed number. Do not insert an average percentage merely because a field is empty. Mark the gap, obtain the actual data or record the assumption explicitly.

Step 4: Break the payout into operations

A payout is not a ready-made profit figure. It can combine current sales, earlier adjustments, fees, compensation and services.

Start at the financial level in ProfitVena and review operation groups in Profit Engine. Compare them with recognized revenue, then reconcile the actual transfer separately against the bank. The purpose is to explain each difference:

• an operation from an adjacent period;
• a return or cancellation;
• a late adjustment;
• a fee or compensation;
• a missing source;
• a duplicate row;
• a technical error.

The result becomes an auditable chain instead of an opaque total.

Step 5: Add product cost and expenses outside the marketplace

Do not expense the entire purchased batch against one period. Include the cost of the units sold according to the chosen method.

Add packaging, labeling, delivery to the warehouse, contractors and advertising paid outside marketplace deductions. Check for duplicates: the same advertising or service cost may appear in the advertising report, financial detail and an imported worksheet.

Allocate payroll, software, rent and other operating expenses using a stable basis. The method may be approximate, but it must be understandable and consistent across periods.

Step 6: Move from account profit to the SKU

A profitable account can hide products that destroy margin. Once the totals reconcile, use Product 360 to review products using the same cost structure.

Look beyond negative profit. Four early signals are especially useful:

1. Margin falls faster than revenue.
2. Logistics or returns rise per completed sale.
3. Advertising increases turnover without increasing the SKU's profit contribution.
4. Product cost is missing or outdated.

Every signal should lead back to a source and period. Without that path, a team discusses a chart. With it, the team can decide what to do about a price, campaign, shipment or listing.

Worked example

Assume recognized monthly revenue is RUB 900,000 after returns and revenue adjustments.

Contribution profit is:

900,000 − 135,000 − 90,000 − 72,000 − 360,000 − 27,000 = RUB 216,000, or 24% of recognized revenue.

With RUB 60,000 in allocated operating expenses, the management result before tax becomes RUB 156,000, or approximately 17.3%.

These are illustrative figures, not benchmarks for a healthy margin or marketplace tariff. Their purpose is to show the calculation layers. In a real workspace, every amount should have a source, period and inclusion rule.

Review before making a decision

Before changing price, advertising or purchasing, verify that:

• sales and costs use the same period;
• returns and return logistics are separate;
• product cost applies to units sold;
• advertising and services are not duplicated;
• unusual charges are explained;
• missing sources are visible;
• account profit can be traced down to SKU;
• tax comes from the approved accounting process;
• the decision and owner are recorded.

Forecast Center is preparing for integration and can be discussed as a preview. This article does not claim that forecasting, automated purchasing or guaranteed replenishment is already available as a live feature.

Where ProfitVena helps

ProfitVena brings live Wildberries analytics, Product 360 and Profit Engine into one seller workflow. The value is not a single “correct” number. It is the ability to understand how the result was formed, check its sources and reach the product that requires a decision.

Technical part updated in ProfitVena.

ProfitVena is developed by Wicsora LLC and is part of the Wicsora ecosystem.

The underlying methodology and free browser calculator are available in the Seller Analytics educational library: How to calculate real marketplace profit.

Next in the series: how to diagnose a business where revenue is growing but profit is not.