Orders are rising, but the cash reaching the bank account is not rising at the same pace. That does not automatically mean the marketplace made an error. An order, a completed purchase and a payout answer different questions and can fall on different dates.
Define each number
An order is an intention to buy that may still be canceled or returned. A completed purchase is a sale recognized under a marketplace report's rules. A payout is cash transferred to the seller after deductions, adjustments and settlement timing. Definitions and dates vary by source, so compare the underlying rules, not just column names.
Build a reconciliation table
For one SKU and period, record the order date, completed-purchase or return date, sale amount, payout date and payout amount. Keep an operation ID and source for each row. List commissions, logistics, advertising, penalties, compensation and other deductions separately. Label an unexplained line unclassified rather than treating it as zero.
An illustrative example: 20 orders at 1,000 units each do not imply 20,000 units of realized sales, much less a 20,000-unit payout. If 15 orders are completed, two are later returned and some deductions enter the next settlement, the answer depends on your period and status definitions. These are teaching numbers, not customer results.
Separate profit from cash timing
One question is what the sold units earned after costs. Another is when the cash arrives. Positive weekly profit can coexist with a smaller payout because of timing, returns and deductions. Our previous guide checks SKU margin before a promotion; this reconciliation keeps that profit calculation distinct from bank movement.
Where ProfitVena helps
ProfitVena helps bring together available marketplace data, configured costs and supported Excel/CSV imports by SKU and period. Completeness depends on connected sources, product mapping and your cost rules; reconcile discrepancies against source reports. The technical part was updated in ProfitVena. ProfitVena is part of the Wicsora ecosystem.
A good final check: every amount has a status, date, source and explanation for its transition to the next measure. “Where did the money go?” then becomes a list of specific operations to investigate.
