Blog · Territory, capacity and quota planning · Finance and FP&A teams
Build a marketplace financial model from transaction volume, earned fees and variable costs. Work through a US marketplace example, test a lower take rate and reconcile the result before comparing scenarios.
A marketplace financial model separates transaction value from the revenue the business earns, then connects that revenue to transaction costs and fixed spending. Start with completed orders, their value and the fee policy; do not treat all customer payments as spendable income.
Use the transaction register, fee ledger, payment-cost report and operating expense export for the same month. Keep transaction identifiers, completion dates, category, transaction value, earned fees, refunds and settlement status. The identifiers let finance distinguish a duplicate row from a genuine additional purchase.
Define GMV before calculating it. State whether it includes taxes, shipping, cancellations and refunds, then use that policy consistently. This example uses completed, nonrefunded transactions, excluding taxes and shipping. It assumes a fee-only marketplace whose finance team has approved net fee revenue accounting; it does not establish the accounting treatment for another business.
Use actual exports to establish the starting point and separate assumption cells for planned changes. Record who owns each input: operations for completed orders, commercial finance for fee schedules, and accounting for earned fees and expense classification. Keep advertising or subscription revenue outside transaction take rate unless your definition explicitly includes it.
For the workbook layout, use the separate marketplace financial model in Excel. The method here focuses on the operating relationships and the checks.
An illustrative US business has these October 2026 assumptions. All dollar amounts are USD; the rates are assumptions, not industry benchmarks. The processing charge applies to GMV, and support varies with completed orders.
| Category | Completed orders | Average transaction (USD) | Take rate | Processing rate on GMV | Support per order (USD) |
|---|---|---|---|---|---|
| Standard | 8,000 | 75 | 12% | 2.5% | 0.75 |
| Specialty | 2,000 | 150 | 15% | 2.5% | 0.75 |
GMV = Completed orders × Average transaction value
Fee revenue = GMV × Take rate
Transaction contribution = Fee revenue − Payment costs − Transaction support
Put the six input columns above in A:F, with headings in row 1. In G:K, calculate GMV, fees, payment costs, support and contribution. Enter these formulas in row 2 and fill down:
G2 = B2*C2
H2 = G2*D2
I2 = G2*E2
J2 = B2*F2
K2 = H2-I2-J2
The resulting schedule is:
| Category | GMV (USD) | Fee revenue (USD) | Payment costs (USD) | Support (USD) | Contribution (USD) |
|---|---|---|---|---|---|
| Standard | 600,000 | 72,000 | 15,000 | 6,000 | 51,000 |
| Specialty | 300,000 | 45,000 | 7,500 | 1,500 | 36,000 |
| Total | 900,000 | 117,000 | 22,500 | 7,500 | 87,000 |
Standard revenue is 8,000 × 75 × 12% = $72,000. Its contribution is 72,000 − 15,000 − 6,000 = $51,000. Total variable costs are 22,500 + 7,500 = $30,000, leaving $87,000 before fixed expenses.
Calculate the overall take rate from the totals:
=SUM(H2:H3)/SUM(G2:G3)
That is 117,000 / 900,000 = 13.0%. Contribution as a share of fee revenue is 87,000 / 117,000 = 74.4%, rounded to one decimal place. The denominators answer different questions; label them explicitly. For the distinction between contribution and other profit measures, see gross margin vs contribution margin vs net margin.
Suppose the commercial team proposes reducing both take rates by one percentage point, with order counts, baskets and costs unchanged. Change the Standard assumption to 11% and Specialty to 14%. Monthly fixed operating expenses remain $70,000 in both cases.
| Measure | Starting case (USD) | Lower take rates (USD) | Calculation for lower case |
|---|---|---|---|
| Standard fees | 72,000 | 66,000 | 600,000 × 11% |
| Specialty fees | 45,000 | 42,000 | 300,000 × 14% |
| Total fees | 117,000 | 108,000 | 66,000 + 42,000 |
| Variable costs | 30,000 | 30,000 | 22,500 + 7,500 |
| Contribution | 87,000 | 78,000 | 108,000 − 30,000 |
| Fixed expenses | 70,000 | 70,000 | Supplied assumption |
| Operating contribution | 17,000 | 8,000 | 78,000 − 70,000 |
The proposed reduction costs 117,000 − 108,000 = $9,000 of monthly operating contribution. Any expected increase in order volume belongs in a separate scenario with an identified owner and evidence. Combining an unproven volume lift with a certain fee reduction hides the commercial tradeoff.
This is an operating contribution schedule before depreciation, financing costs and taxes. It is not a valuation or a complete income statement. A broader startup financial model can connect the operating schedule to other funding and expense assumptions.
First, sum the transaction register's eligible value and compare it with GMV. Then sum actual earned fees for those same transactions and compare them with the fee ledger. A contractual rate times GMV is a planning calculation; actual refunds, caps and negotiated rates can change realized fees.
If a fee export has period in A, category in B and earned fee amount in C, put the selected period in N1. Use this formula against the category name in A2 of the summary:
=SUMIFS(Fees!$C$2:$C$10000,Fees!$A$2:$A$10000,$N$1,Fees!$B$2:$B$10000,A2)
Microsoft documents that SUMIFS adds values meeting multiple criteria. Expand the bounded ranges when needed, and use consistent period labels. Covirage is not affiliated with Microsoft.
For the starting case, seller proceeds are 900,000 − 117,000 = $783,000. The transaction identity is therefore 900,000 = 783,000 + 117,000. Reconcile those proceeds to the seller settlement report, including unpaid balances rather than assuming every payout has cleared.
Finally, check 117,000 − 22,500 − 7,500 − 70,000 = $17,000. That reconciles the operating schedule, but it does not prove bank cash. The SEC's financial statements guide distinguishes income statements from cash flow statements; settlement timing and unpaid expenses require their own cash bridge.
Bring your transaction export and prepared scenario workbook to Covirage; the FP&A overview explains the wider planning context. Covirage maps the columns, and its tools compute and check revenue, costs and contribution from the supplied rows; the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the supporting industry context.
No. GMV measures the transaction value included under your chosen business definition. Revenue follows the company's accounting policy. In a fee-only marketplace example, revenue is the fee retained for arranging transactions; the amount owed to sellers is separate. Confirm the accounting treatment with your finance team.
Divide the fee revenue associated with eligible transactions by their GMV. Use the same period, transaction population and refund policy for both figures. For several categories, calculate the total from summed revenue and summed GMV rather than averaging category percentages.
Include the costs that your operating definition treats as variable with transactions, such as payment processing and transaction support. Keep the definition consistent across scenarios. Show fixed operating expenses separately, and reconcile this management contribution measure to the expense classifications used in your financial statements.
In the fee-only example below, seller proceeds are excluded from marketplace revenue, so subtracting them again would double count them. A business acting as principal may have different accounting. Follow the approved revenue policy and show seller settlement balances separately in the cash schedule.