Choose what your profit measure includes
This guide calls its result modeled item contribution: revenue less the specific item and selling costs entered in the example. It does not include the seller’s time, store subscriptions, general overhead or taxes. Label that boundary so a positive item result is not mistaken for the business’s final net profit.
Use actual charged amounts where available instead of assuming one fee percentage fits every order. For example, eBay’s fee documentation describes different fee components and conditions. The numbers below are fictional dollar amounts, not eBay’s current rates or a forecast for another marketplace.
Worked sale: $85 received does not mean $85 earned
A fictional reseller sells an item for $80 and charges the buyer $5 for shipping. The recorded order revenue is $85. The item cost $22; the seller also records actual postage, packaging, marketplace fees and an advertising fee.
| Entry | Effect on contribution |
|---|---|
| Item revenue | +$80.00 |
| Shipping charged to buyer | +$5.00 |
| Item purchase cost | −$22.00 |
| Outbound postage | −$6.40 |
| Packaging used | −$1.10 |
| Marketplace fees charged | −$10.55 |
| Advertising fee charged | −$2.40 |
| Modeled item contribution | $42.55 |
The calculation is $85 − $22 − $6.40 − $1.10 − $10.55 − $2.40 = $42.55. Shipping revenue and the postage purchase are separate numbers: in this example, postage costs $1.40 more than the buyer’s shipping charge.
Follow a return without erasing the sale
Now suppose the buyer receives an $85 refund, the seller buys a $6.40 return label, and the platform actually posts a $10.15 fee credit and a $2.40 advertising credit. The item returns in saleable condition. For this planning example, its $22 cost is moved back to the inventory record instead of remaining assigned to the reversed sale.
| Return event | Change |
|---|---|
| Refund to buyer | −$85.00 |
| Return postage | −$6.40 |
| Actual marketplace fee credit | +$10.15 |
| Actual advertising credit | +$2.40 |
| Item cost returned to saleable inventory | +$22.00 |
| Net return adjustment | −$56.85 |
| Sale and return contribution | −$14.30 |
The $22 inventory movement is not a cash receipt. The $14.30 loss consists of $6.40 outbound postage, $6.40 return postage, $1.10 packaging and $0.40 of fees not credited in this example. If the item is damaged or cannot return to saleable inventory, the item-cost treatment needs to reflect that different fact.
Reconcile fee credits and payouts separately
Do not enter a fee credit simply because you issued a refund. Record the credit when it appears in the transaction record. eBay’s fee-credit documentation explains that eligibility and credited components depend on the circumstances; it does not promise every fee will be returned.
Match the order events to the marketplace statement and the payout to the bank separately. A payout may combine several sales, refunds and fees. eBay explains how selling costs are deducted. Recording that payout as additional sales revenue would count the same underlying money twice.
Keep an order ID, inventory ID, event date and source reference on each row. A return should link to its original sale even when it occurs in a later reporting period.
Use a contribution formula with explicit adjustments
In the downloadable example, columns B and C hold item and shipping revenue; D holds buyer refunds; E and F hold item cost applied and item cost returned to inventory; G and H hold fees and fee credits; I, J and K hold outbound postage, return postage and packaging; L and M hold advertising fees and credits.
The contribution formula for row 2 is =B2+C2-D2-E2+F2-G2+H2-I2-J2-K2-L2+M2. Adding the sale and return rows gives −$14.30. Keep adjustment columns separate rather than overwriting the original fees or sale amount; the result then remains explainable.
Download the fictional sale-and-return CSV
The CSV contains values rather than active formulas. Compare the SheetChief Reseller Inventory and Profit Tracker with the business finance collection for ongoing records. SheetChief sells these products. This worked example explains a method; check the listing for the paid spreadsheet’s actual fields and features.
Put this into practice
Small Business Finance Templates: Bookkeeping, Cash Flow & Invoices
Compare the actual product previews and included files before choosing a paid template.
Sources and further reading
The explanations and worked examples are prepared for SheetChief. These sources support the referenced methods or platform instructions.
Questions, answered
Is the marketplace payout the profit on my resale?
No. A payout can combine several transactions and may already have fees or refunds deducted. Calculate the item result from its revenue, cost and recorded selling events, then reconcile the payout separately.
Should shipping charged to the buyer cancel out postage?
Only if the recorded amounts are equal. Keep shipping revenue and actual postage as separate entries so a difference remains visible.
Can I assume all fees will be credited after a return?
No. Use the fee credits actually posted to the order or statement. The platform’s current rules and the return circumstances determine which credits are available.
Why is the returned item’s cost separate from the refund?
The refund is a payment to the buyer. A saleable item returning to inventory is a different event. The example reverses its item-cost assignment for planning purposes without treating that inventory movement as cash received.
Related SheetChief tools
These are our own products. The examples above explain the task; check each Etsy listing to confirm which features and formats are included.
