Dropshipping order economics starts with what a fulfilled order leaves after its variable costs. Product markup alone is insufficient. You also need to understand fixed operating costs, owner work, refunds and when money must leave the business relative to customer payouts.
Build the worksheet before buying more traffic. Then replace estimates with actual order records. The examples here are hypothetical arithmetic for a small store, not an income forecast, accounting advice or a recommended product price.
Separate the amounts that answer different questions
Use consistent definitions across your sheet:
| Measure | Question it answers |
|---|---|
| Collected product revenue | What customer revenue belongs to the order under your reporting basis? |
| Product and fulfillment cost | What must be paid to supply and deliver it? |
| Order contribution | What remains after the defined variable costs? |
| Operating result | What remains after the period's fixed and other operating costs? |
| Available cash | What money is actually accessible when obligations fall due? |
Record taxes collected, currencies, refunds and payout deductions consistently with the relevant accounting treatment. If you are unsure what belongs in revenue, obtain appropriate accounting guidance rather than treating every bank deposit as sales.
Shopify's pricing guidance illustrates the need to consider product and business costs. The fuller operating worksheet below makes its own assumptions explicit.
Build one complete order row
Start with an identifiable order rather than a monthly average. Include order date and identifier, product/variant, customer revenue, discounts, supplier cost, shipping, payment charges, variable service labor, exceptions and acquisition source. Keep supporting invoices and reports.
The core planning calculation is:
order contribution = defined order revenue
- supplier product cost
- supplier/fulfillment shipping
- payment and transaction charges
- variable support/handling
- expected exception allowance
An allowance is a planning input. When analyzing completed orders, do not subtract both an allowance and the same actual exception without reconciling them. Explain whether your result uses estimated future exceptions or actual historical costs.
Include ordinary work even if the owner does it unpaid. You can show cash contribution and an economic view with replacement labor separately. Neither should be mislabeled as the other.
Work through a transparent example
Assume the following order:
| Hypothetical input | Amount |
|---|---|
| Product revenue after discount | $50 |
| Supplier product | $20 |
| Supplier shipping | $8 |
| Payment charges | $2 |
| Variable support allocation | $3 |
| Expected exceptions allowance | $4 |
| Contribution before fixed costs | $13 |
The calculation is $50 − $20 − $8 − $2 − $3 − $4 = $13. A supplier-price markup calculation would show a much larger number while omitting costs the business must support.
Now assume $130 of fixed costs for the same planning period and no other costs. Ten identical orders would contribute $130 before those fixed costs, leaving zero under this simplified model. Eleven would leave $13. This is arithmetic, not a claim that ten orders is an appropriate target or that real orders are identical.
If you must pay for production of content, professional services, insurance or other operating needs, include them in the appropriate period and category. The example deliberately does not imply those costs are absent.
Stress the inputs before scaling
Test the assumptions that could change the decision. If shipping rises from $8 to $12, the example contribution falls to $9. If price is discounted from $50 to $45 with other inputs unchanged, it falls to $8. If both changes occur, it becomes $4.
These sensitivities show why a sale can be real while the business is weak. They also identify questions to investigate: can shipping be confirmed, does the discount attract the right buyers, and what do actual exceptions cost?
Avoid optimistic lifetime value as a rescue assumption. If repeat purchases have not been observed, show the current order economics without inventing later purchases. When repeat behavior exists, analyze its source, time period and associated fulfillment costs separately.
Add the acquisition method honestly
Organic acquisition can avoid a media invoice while still requiring time, product samples, creative work and ongoing content maintenance. Record cash expense and operator effort; explain how you allocate them rather than claiming customer acquisition is free.
For a bounded content experiment, keep its costs together: sample, filming, editing, writing and distribution effort. Attribute resulting orders as carefully as the available data allows. If a customer saw several channels, a last-click label is not proof that the final channel caused the whole sale.
Do not combine a paid advertising loss with a profitable organic cohort and present the result as evidence every channel works. Use the traffic-without-sales diagnostic when acquisition activity fails to produce appropriate purchases.
Build a separate cash calendar
A margin calculation cannot tell you whether funds arrive in time. List the dates supplier payments, app subscriptions, customer refunds and other commitments fall due, then record when customer payouts are actually available.
In a hypothetical stress case, ten orders each require $28 in immediate supplier/fulfillment charges before customer payouts become accessible. That creates a $280 funding requirement before other costs or refunds. Your actual timing depends on processor terms, reserves, order mix and supplier arrangements; do not copy a universal payout delay from this illustration.
Model at least the ordinary case and a delay/exception case. A refund can be due while the supplier credit is unresolved. Identify which obligations you control and what evidence supports expected recoveries.
Reconcile a period from source records
At period close, connect order records to supplier invoices, refunds, payment reports and bank movement. Explain timing differences instead of forcing the totals to agree by deleting an inconvenient expense.
Separate categories that are often confused: product refunds versus chargebacks, supplier credits versus recovered cash, one-time setup versus ongoing tools, and seller discretionary costs versus required replacement work. Keep an adjustment schedule alongside the original figures.
The earnings-verification guide provides a broader method for buyers and sellers. Your working sheet should let another operator trace a claim from the summary to its source.
Close an exception without counting it twice
In a hypothetical completed order, $50 revenue is refunded in full. The $20 product cost, $8 shipping, $2 fee and $3 support remain unrecovered; assume no other charges or credits. Show $0 net revenue and $33 actual variable costs, for a $33 loss. Replace the planned $4 exception allowance with the actual outcome for this historical row; do not also deduct that allowance. If a supplier later credits $20, the loss becomes $13 under these assumptions. Record a credit separately from the date cash is recovered.
For cash planning, add a running balance column: opening accessible cash plus cleared inflows minus payments due. With $300 opening cash and the earlier $280 supplier commitment, only $20 remains before other obligations. A further $50 refund would create a $30 shortfall unless another cleared inflow arrives. Reduce the supported order capacity or fund the gap before accepting that exposure. Neither hypothetical balance is a recommended reserve.
Use the result to choose the next action
If contribution is negative under supported inputs, more orders can deepen the loss. Investigate price, product value, supplier costs and exception burden before acquisition grows. If contribution is positive but operating costs exceed it, decide which costs deliver necessary value and which experiments should stop.
If the operating result looks viable but cash is fragile, adjust commitments, reserve funding or order capacity before promising more deliveries. A positive forecast is not permission to accept orders you cannot fund or fulfill.
For a potential sale, retain actual history, assumptions, source definitions and owner workload. Marketplace acceptance and buyer interest are separate decisions. A credible asset is supported by reconciled records and an explainable operation, not a percentage margin on a screenshot.

