Blog · Finance metrics and formulas
Calculate print-on-demand contribution from order and fulfillment exports. Include discounts, refunds, printing, shipping, marketplace fees and attributable advertising before comparing products.
Print on demand profit margin is most useful as actual order contribution divided by net order revenue. Subtract printing, fulfillment, selling fees, reprints and attributable advertising after recording discounts and refunds. The difference between the selling price and the printer's base charge alone does not show what the order contributed.
Start with a closed period of order lines, provider invoices, marketplace or payment statements, refunds and advertising detail. Retain order ID, product, channel, currency and dates. Match fulfillment and selling costs to their orders, and preserve any unmatched charges for investigation.
A settlement deposit cannot supply the entire calculation. The IRS explanation of Form 1099-K gross payments notes that reported gross amounts are not adjusted for fees, refunds and other listed items. Your management worksheet similarly needs the underlying order and expense records rather than a single payment total.
Use customer discounts and refunds as separate revenue reductions. The IRS gross-profit guidance subtracts returns and allowances when calculating net receipts. Follow the company's accounting policy for the reporting period, and keep later refunds identifiable against the original order.
Use one row per product and channel after matching the transaction detail. If a provider invoice includes printing and outbound shipping together, split those components without counting the invoice total again.
| Column | Field |
|---|---|
| A | Product and channel |
| B | Gross product sales |
| C | Customer shipping charges |
| D | Discounts |
| E | Refunds |
| F | Printing and product fulfillment |
| G | Outbound shipping cost |
| H | Marketplace and payment fees, after fee credits |
| I | Unreimbursed reprints and replacements |
| J | Attributable advertising |
Enter net order revenue in K2:
=B2+C2-D2-E2
Enter included order costs in L2:
=SUM(F2:J2)
Enter contribution in M2:
=K2-L2
Enter contribution margin in N2:
=IF(K2=0,"",M2/K2)
Fill the formulas down and format column N as a percentage. These costs define the management measure; accounting classifications can put some expenses below gross profit. Use the gross profit margin guide when reconciling that separate reporting measure.
An illustrative US seller reviews three product groups for one closed month. All amounts are USD; the inputs are hypothetical business records, not market prices or promised margins. Sales tax collected for authorities is excluded from this example.
| Product | Product sales (USD) | Customer shipping (USD) | Discounts (USD) | Refunds (USD) | Net revenue (USD) |
|---|---|---|---|---|---|
| T-shirt | 32,000 | 4,000 | 2,000 | 1,600 | 32,400 |
| Mug | 18,000 | 3,000 | 600 | 900 | 19,500 |
| Poster | 12,000 | 2,000 | 400 | 300 | 13,300 |
| Total | 62,000 | 9,000 | 3,000 | 2,800 | 65,200 |
The cost records show the following amounts. Printing costs retain the expense of refunded orders unless an actual provider credit reverses it. Reprints are additional, unreimbursed costs beyond those original charges.
| Product | Printing (USD) | Outbound shipping (USD) | Selling fees (USD) | Reprints (USD) | Advertising (USD) | Total cost (USD) |
|---|---|---|---|---|---|---|
| T-shirt | 14,000 | 4,500 | 3,200 | 700 | 4,000 | 26,400 |
| Mug | 7,500 | 3,500 | 1,900 | 500 | 1,800 | 15,200 |
| Poster | 3,600 | 2,200 | 1,200 | 300 | 1,200 | 8,500 |
| Total | 25,100 | 10,200 | 6,300 | 1,500 | 7,000 | 50,100 |
For T-shirts, net revenue is 32,000 + 4,000 - 2,000 - 1,600 = $32,400. Included costs total $26,400. Contribution is $6,000, and 6,000 / 32,400 = 18.52%.
| Product | Net revenue (USD) | Contribution (USD) | Contribution margin |
|---|---|---|---|
| T-shirt | 32,400 | 6,000 | 18.52% |
| Mug | 19,500 | 4,300 | 22.05% |
| Poster | 13,300 | 4,800 | 36.09% |
| Total | 65,200 | 15,100 | 23.16% |
Calculate using unrounded amounts; displayed percentages are rounded to two decimal places. Posters have the highest percentage, but T-shirts supply the largest contribution dollars. Neither result predicts what happens if advertising spending or sales volume changes.
With product rows in 2 through 4, calculate the overall ratio from totals:
=IF(SUM(K2:K4)=0,"",SUM(M2:M4)/SUM(K2:K4))
The proof is $65,200 net revenue = $25,100 printing + $10,200 shipping + $6,300 fees + $1,500 reprints + $7,000 advertising + $15,100 contribution. Each expense total should tie to its source export after explaining credits, timing and any unassigned amounts.
Suppose the ledger contains $6,000 of additional shared operating expenses and no other operating adjustments for this example. Operating profit is 15,100 - 6,000 = $9,100, or 9,100 / 65,200 = 13.96%. That bridge belongs in the company review; operating margin explains its scope. Interest and taxes would require further lines before calculating net profit.
Use the profit margin calculator for the reconciled company figures. A different supplier arrangement needs a different cost map; the dropshipping margin guide addresses that neighboring fulfillment workflow.
Have commercial finance review the revenue and fees, and operations review missing fulfillment charges and replacement reasons. Resolve unmatched records before using the ranking to change product pricing or advertising budgets.
Bring order, fulfillment and selling-cost exports with the references used to match them. Covirage maps the columns, and its tools compute and check contribution; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See the related approach to customer profitability.
Contribution is the amount remaining after the order costs defined in your worksheet. Net profit also includes the company's remaining expenses and other income or costs. Keep shared payroll, software, professional fees and financing separate until you reconcile the full income statement.
In this management worksheet, customer shipping charges are shown as revenue and carrier or fulfillment shipping is a separate cost. That makes shipping subsidies visible. Keep the definition consistent with the company's books when reconciling the worksheet to reported sales.
Use an order or campaign reference where attribution is supported by the export. Retain the attribution basis and avoid counting the same campaign spending against multiple products. Leave spending that cannot be assigned reliably in a separate shared-cost line.