Skip to content
The Seller’s Ledger

Marketplace payout reconciliation example and template

Match orders, refunds, fees, reserves and the final receipt without calling every deduction a fee.

Download the editable worksheet

On a narrow screen, scroll the table horizontally. The product summaries above retain the key differences.

Fictional statement annotation, not an anonymized customer record.
Fictional report PAY-DEMO-42USDTreatment
Orders1,000Gross sales report
Refunds50Reduction in sales collected
Platform fee100Expense, separate from refunds
Reserve held25Held funds, not a fee
Scheduled payout8251,000 minus 50 minus 100 minus 25
Receiving fee2Separate receipt expense
Bank receipt823825 minus 2

Match the references as well as the amount

The order report, payout schedule and receiving statement should each have an identifier. In this example, orders ORDER-DEMO-A and ORDER-DEMO-B belong to payout PAY-DEMO-42, which matches receipt REC-DEMO-42. The purpose is to trace a grouped payout back to its source, not to invent a provider-specific statement format.

If a reserve is released later, record the release as movement of previously held funds rather than new sales. If a customer refund arrives in a later period, link it to the original sale and the current payout deduction. Timing differences are often the reason a payout does not equal this month’s order total.

Add conversion only when it happens

The blank CSV records source and destination currency, rate direction and fees separately. A USD payout converted into a local-currency receipt needs both units. A USD-to-USD receipt does not need a fabricated FX rate. Record a missing fee as unknown and obtain the statement or quote before drawing a cost conclusion.

Keep customer names, bank details and real account identifiers out of this public worksheet. Use internal references, then store the supporting statements in the business’s secure bookkeeping process.