On a narrow screen, scroll the table horizontally. The product summaries above retain the key differences.
| Fictional report PAY-DEMO-42 | USD | Treatment |
|---|---|---|
| Orders | 1,000 | Gross sales report |
| Refunds | 50 | Reduction in sales collected |
| Platform fee | 100 | Expense, separate from refunds |
| Reserve held | 25 | Held funds, not a fee |
| Scheduled payout | 825 | 1,000 minus 50 minus 100 minus 25 |
| Receiving fee | 2 | Separate receipt expense |
| Bank receipt | 823 | 825 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.