Why a marketplace payout is not the same as sales
A bank deposit from a marketplace is a settlement amount, not a complete measure of revenue or profit. Marketplaces may combine orders from different dates, subtract refunds and fees, hold reserves, release earlier balances or adjust previous transactions. A payout can therefore be lower or higher than the sales recorded during the same calendar period.
To understand the difference, reconcile three separate records: order-level sales, marketplace transaction activity and the settlement or payout statement. Then match the final net payout to the amount received in your bank account.
The basic payout bridge
Expected payout = gross order proceeds − refunds and chargebacks − marketplace fees − payment processing fees − shipping labels or fulfilment charges deducted by the marketplace ± reserves, adjustments and prior-period balance movements.
The exact statement labels and treatment differ by marketplace. Use the platform's own transaction report and settlement statement rather than assuming every platform uses the same categories. Sales tax collected and remitted by a marketplace should be tracked separately from seller revenue where applicable.
Worked example: orders do not equal the deposit
Suppose a settlement period contains $2,000 in item and shipping proceeds, $100 in discounts and refunds, $240 in marketplace and payment fees, and $80 in shipping labels deducted from the account. The platform also releases a $50 reserve held from an earlier period. The expected deposit is $1,630: $2,000 − $100 − $240 − $80 + $50.
If the bank deposit is $1,610, do not change the order revenue to force the numbers to match. Investigate the $20 difference. It may be a separate adjustment, a fee, a timing difference, a currency conversion amount or a report filter issue. Record the reason and supporting transaction reference once identified.
A practical monthly reconciliation workflow
- Set the period and currency. Use the settlement period shown by the marketplace, not an arbitrary month-end date if the platform reports by payout cycle. Keep each currency separate until you reconcile conversion.
- Export order details. Capture order ID, order date, gross item amount, shipping collected, discounts, refunds and sales tax information.
- Export transaction activity. Capture commissions, payment fees, label charges, fulfilment charges, advertising deductions, chargebacks, reserves and manual adjustments.
- Group transactions by settlement ID. Match each order or adjustment to the settlement in which it was paid or deducted. Do not assume order date and payout date fall in the same period.
- Calculate the expected settlement. Build a bridge from the opening balance and period activity to the net amount payable.
- Match the bank deposit. Compare the expected settlement with the bank credit, accounting for bank fees, currency conversion and payment-provider deductions if applicable.
- Investigate and document differences. Keep the transaction ID, amount, date, explanation and follow-up status for every unresolved difference.
Common reasons for differences
- Timing: an order is recorded in one period but paid in a later settlement.
- Refund timing: a refund is deducted after the original order was paid.
- Reserves and holds: the platform withholds or later releases part of the seller balance.
- Fees: subscription charges, listing fees, advertising charges, fulfilment fees or payment fees appear outside the order report.
- Chargebacks and claims: disputed transactions may be debited separately from ordinary refunds.
- Currency conversion: the settlement currency and bank account currency differ, creating exchange-rate and conversion-fee differences.
- Report filters: exports may use different date ranges, transaction types, statuses or time zones.
Keep profit tracking and payout reconciliation connected—but separate
Use order-level records to measure contribution profit. Use settlement reports to explain when and how money moves to your bank. A profitable order can remain unpaid for days, and a payout can include sales from several earlier days. Neither report replaces the other.
Our free order profit tracker helps organize order-level revenue and variable costs. The profit versus cash flow guide explains why accounting profit and available cash can move differently. Use the profit calculator to estimate order economics before comparing them with actual settlement results.
Reconciliation checklist
- Every settlement has a matching platform statement or report.
- Opening balance, transactions, reserves and adjustments explain the expected payout.
- Refunds and fees are assigned to the period in which the platform deducted them.
- Sales tax is not mistakenly counted as seller revenue.
- Currency conversion and bank fees are recorded separately.
- Every unexplained difference has an owner, reference and follow-up note.
This guide is for operational bookkeeping and management analysis, not tax or accounting advice. Follow the reporting definitions for your marketplace and consult a qualified accountant about recognition, tax and financial-statement treatment.