Marketplace Payout Reconciliation: Why the Money Received Never Equals Your Sales, and How to Record It

A seller of phone accessories sells 92 million in a month across two marketplaces, by the figures on the seller dashboards. The bank account receives 71 million. She assumes the gap is "admin fees" and moves on. A patient afternoon with the reports shows the truth: commission and service fees took about 11 million, campaign and free-shipping programmes about 4 million, shipping weight corrections 1.2 million, refunds 3.5 million, and 1.3 million belongs to orders marked completed for which no funds were released. That last part was recoverable, and only because she looked. This is what marketplace payout reconciliation is for.

What stands between a sale and your bank

For each order, the platform starts with what the buyer paid and adjusts.

• Commission, a percentage by category.
• Service or transaction fees.
• Programme fees for campaigns you opted into, such as free shipping or cashback programmes.
• Vouchers and discounts funded by you. Those funded by the platform do not reduce your payout.
• Shipping: the difference between shipping charged to the buyer and the courier's actual charge, including weight corrections.
• Refunds and returns, full or partial.
• Penalties or compensation, occasionally.
• Advertising, usually charged separately from a balance, but sometimes netted.

Then timing: funds are released after the order is completed, the balance accumulates, and a withdrawal moves it to your bank, automatically or when you request it. One bank credit may cover hundreds of orders across several days.

Fee names, rates and release rules differ by platform and change often. Always work from the platform's current reports and seller terms.

The three records

• Orders: what was sold, to whom, for how much.
• Payout or income report: per order, the amount released and every deduction.
• Bank statement: the withdrawals received.

Reconciliation ties orders to the payout report, and the payout report to the bank.

A weekly method in five steps

1. Download

For the week: the order report, the income or settlement report, and the balance or withdrawal history. Keep the files in a folder by platform and week.

2. Match orders to income

By order number.

• Completed orders with income released: fine.
• Completed orders with no income: list them. After the platform's normal release period, raise each with seller support.
• Income for orders not in your list: usually an older order released late. Trace it.

3. Check the deductions

You cannot verify every rupiah on every order, so test.

• Commission rate: does the percentage match the category you expected? A product placed in the wrong category may be charged a higher rate.
• Programmes: are you paying for a programme you thought you left?
• Shipping corrections: which products are repeatedly reweighed? Fix the weight and dimensions in the listing.
• Vouchers: are stacked discounts making some orders unprofitable?

4. Match withdrawals to the bank

Each withdrawal in the balance history should appear as one credit in the bank statement, same amount. Note any still in transit.

5. Record

One summary entry per platform per week is enough for a small seller.

How to record it

Suppose a week on one marketplace shows:

• Gross sales of completed orders: 20,000,000
• Commission and service fees: 2,400,000
• Programme fees: 800,000
• Shipping corrections: 250,000
• Refunds: 600,000
• Net released to balance: 15,950,000
• Withdrawn to bank: 15,000,000

Record:

• Sales: 20,000,000.
• Sales returns: 600,000, reducing sales.
• Marketplace fees (expense): 2,400,000.
• Promotion or programme costs (expense): 800,000.
• Shipping cost (expense): 250,000.
• Marketplace balance (an asset, like a bank account): increases by 15,950,000.
• Transfer from marketplace balance to bank: 15,000,000.

The marketplace balance account then shows 950,000 still held by the platform, which should match the balance on the seller dashboard. If it matches, the week is reconciled.

Treating the marketplace balance as its own account is the single change that makes this easy. The money exists. It is just not in the bank yet.

What reconciliation usually uncovers

• Orders never paid out. Rare per order, real over a year.
• A product in the wrong category at a higher commission.
• Programmes that cost more than they bring.
• Listings with wrong weight, paying shipping corrections on every order.
• Products that lose money after all deductions, often the bestsellers on discount.
• Refunds where the item never came back, or came back damaged, and could have been disputed.
• Advertising spend that nobody was watching.

Margin per channel

Once fees are recorded by platform, a figure appears that most sellers have never seen: what each channel really keeps.

For each platform, per month:

• Gross sales, minus returns.
• Minus cost of goods.
• Minus platform fees, programmes, shipping costs, advertising.
• Equals contribution, in money and as a percentage.

Compare with your own website or chat sales. Prices and promotions can then be set per channel with open eyes.

Disputes

• Know the time limit. Platforms accept claims about payouts or returns only within a set period.
• Keep evidence: packing photos or video for valuable items, shipping receipts, chat history.
• Raise claims by order number with the relevant report attached.
• Log each claim and its outcome.

Stock and returns

Reconcile goods as well as money.

• A returned order should bring an item back. Check it in, decide whether it is sellable.
• A cancelled order after packing needs the stock restored.
• Lost in delivery: claim according to the platform's and courier's rules.

Common mistakes

• Recording the bank credit as sales.
• Assuming the gap is "just fees".
• Reconciling once a year, at tax time.
• Not downloading reports before the platform's history window closes.
• Ignoring programme fees and voucher costs when pricing.
• Wrong weights in listings.
• No follow-up on completed orders with no payout.
• Mixing marketplace balance with bank balance.
• Forgetting advertising when judging a channel.

Keeping the books

A spreadsheet per platform works to start: orders, income, deductions, balance. Bookkeeping that lets you keep the marketplace balance as an account, record gross sales and categorise fees makes the weekly entry quick. Polynusa's bookkeeping records sales, expenses and payments in one workspace. See the pricing page.

Summary

A marketplace payout is gross sales minus commission, fees, programmes, shipping adjustments and refunds, released later and withdrawn in batches. Each week, match orders to the income report and withdrawals to the bank, test the deductions, and record gross sales, returns and each fee type separately, with the marketplace balance as its own account. The exercise pays for itself in unpaid orders recovered, wrong categories and weights corrected, and a true margin per channel.

FAQ

Why is my marketplace payout lower than my sales?

Because the platform deducts its charges before paying you: commission, service or payment fees, programme fees for campaigns you joined, shipping differences, vouchers you funded, and refunds or returns. Timing also matters, since funds are released only after an order is completed. The payout report lists these items per order.

Should I record the payout amount or the sale amount as revenue?

Record the gross sale as revenue and the platform's deductions as expenses, in separate categories. Recording only the net payout hides how much the channel costs you and understates your sales. Check with your tax adviser how gross sales and platform fees should be treated for tax in your country.

How often should marketplace payouts be reconciled?

Weekly is a good rhythm for a small seller, and daily once order volume is high. Waiting until month-end leaves too many orders to trace and may pass the period in which the platform accepts a dispute about a missing or wrong payment.