Margin by order, not by month: what each special order earned

The monthly margin looks close to plan. Inside it sits a discounted sectional with a freight invoice that arrived late and a vendor surcharge that never reached the selling price. The average offers no obvious reason to change the next quote.

Review the order itself. Start with net merchandise sales, subtract the landed acquisition cost, then show delivery and commission separately. That gives the owner a clear account of what the piece earned and which decision needs attention next time.

Define the margin before comparing it

Merchandise gross margin measures net merchandise sales less the cost of the merchandise. A broader order-contribution view can then include the delivery fee, delivery expense, and commission. Label each subtotal so people know what they are comparing.

Do not call the contribution after commission the same thing as gross margin before commission. Both can be useful, but they answer different questions. The first helps assess acquisition and selling price; the second shows more of what remains from the transaction.

The owner’s dashboard guide keeps those measures beside the financial statements. A per-order worksheet supplies the detail the monthly total compresses.

Compare the quote with the arrival costs

For this worked example, a Madison sofa has a $6,000 ticket price and a $600 discount. The agreed net merchandise sale is $5,400. Assume a $2,700 factory cost and a $675 duty amount; the latter is an example cost, not a current tariff rate.

The quote includes a $250 customer delivery fee. The commission assumption is 6% of net merchandise, or $324. Freight was estimated at $250, but the final allocated amount is $375. A $150 vendor surcharge also arrives, while the actual customer-delivery cost is $320.

The order’s contribution fell by $345: $125 of additional inbound freight, the $150 surcharge, and $70 of delivery cost above the fee. The discount was already in the accepted price; it is part of the starting economics rather than a surprise at receiving.

The customer has not changed their order merely because the store’s cost changed. Review the accepted terms and any permitted adjustment through the normal customer-change process before considering an additional charge.

Find the leak before changing the price list

A weak order can come from a selling decision, a purchasing cost, or a service expense. Identify the source before applying the same correction across the catalog.

A discount reduces the money available to cover every later cost. Late freight can turn a plausible estimate into a shortfall. A vendor surcharge can arrive after the quote has been accepted. A delivery fee can cover the ordinary route but fall short for a more demanding handover.

Cancellation and damage need their own treatment. A canceled piece may still leave a vendor commitment or stock to resell. A rejected unit should not quietly remain in the cost of accepted furniture without the receiving and cost records explaining it.

Review partial orders line by line. If the sofa arrived but the ottoman did not, the order’s present cost picture may combine a receipt with an estimate. The landed-cost guide explains how the acquisition costs reach the goods.

Follow the charges into the receipt

OrderPilot records purchasing charges such as freight, duty, brokerage, and tariffs on the purchasing side. Allocate supported charges by value, quantity, or a manual amount, according to what the charge represents. Keep the allocation basis with the record. A shared freight invoice should be distributed across the goods it carried, while a line-specific surcharge belongs with the affected purchase. The method should be explainable to the person reviewing the margin later.

Receiving records the actual quantities and freezes the receipt’s landed-cost record. Later corrections have a reason and a recorded adjustment; the original estimate should not be treated as final simply because the goods have been delivered. The landed-cost margin guide follows the acquisition calculation. The full order review then adds the selling and service decisions around it.

Read Cost of this order with its completeness signals

Where the store enables order-cost display and the viewer has permission, Cost of this order opens the line costs, final or provisional state, total cost, and margin. The order view waits until every line has a cost before showing its margin. A missing cost is not a zero-cost piece. Find the source before interpreting the sale as unusually profitable. The PO list’s Needs cost review tab helps locate the records that still need an invoice, cost, or final amount. Salespeople can still work with the order without seeing cost, provided their role is configured that way. Cost visibility is permission-controlled, and this internal cost view does not appear on the customer’s PDF, email, or portal.

Read Analytics › Profit as its own calculation

Analytics › Profit shows selling, cost, freight, commission, net, and margin for order lines, grouped by product, template, category, vendor, or store. Its period follows orders placed during the selected range; a delivered-order review needs the corresponding underlying records.

The report separates identifiable freight from the rest of landed cost. Its net is selling minus cost, freight, and commission, and its margin is that net divided by selling. Freight is not an extra deduction on top of a cost figure that already includes the same amount. In the example, the merchandise result after commission is $1,176: $5,400 less $3,900 landed cost and $324 commission. That is about 21.8% of net merchandise sales. The worksheet’s $1,106 contribution also includes the $70 shortfall on customer delivery, so the two figures have different scope.

The report identifies estimated or missing costs, and freight can be actual, estimated, or included in an older combined cost. Read those labels before ranking vendors. Missing inputs can make a result look stronger than the completed economics.

Correct late freight even after delivery

A freight invoice arriving after the customer’s delivery belongs in the order’s cost review. Record the actual charge through the supported purchasing correction, reconcile it with any amount already posted, and inspect the resulting order cost.

Do not leave the difference in an unrelated expense solely to preserve the original order margin. That would make the next quote repeat an assumption the store now knows was wrong.

With QuickBooks connected, the purchasing correction follows the supported bill or adjustment route. The bookkeeping review should then establish whether the goods are still held or their cost has already been recognized.

Use the estimated-versus-final cost guide for that sequence. Keep one clear trail from the invoice to the charge, receipt, and affected orders.

Handle mixed stock and special-order lines by their source

A lamp taken from stock and a sofa purchased for the customer can share one sale while drawing cost from different records. Use the cost of the stock units drawn and the linked special-order acquisition cost, with estimates identified until the purchase is settled.

Shopify documents its single static Cost per item field. A current value in that field is not, by itself, the historical cost of every unit sold. Keep the store’s costing method and source allocations in the review.

For split deliveries, distinguish units already handed over from units still waiting. Do not present an incomplete order as a fully settled result merely because its most expensive piece arrived first.

Measure commission after naming the gross-margin subtotal

Show merchandise gross profit before commission, then deduct commission in the next subtotal. That lets the owner see whether a weaker result came from acquisition cost, selling price, or the compensation arrangement.

A store can calculate commission on net merchandise or gross profit according to its configured policy. The report’s commission can be frozen once earned or reflect what would be earned before that event. Read the status with the amount.

The commission-basis guide explains the policy choices without exposing costs to the floor. Keep card fees, rent, payroll, and other business expenses in the broader accounting review, then use the order figures to improve the next sale.

Review the weakest orders with five questions

Choose a manageable set of low-result orders for the monthly review, such as ten in a proposed starting routine. Use completed costs where available and separate unresolved estimates before drawing conclusions.

1. Did the accepted selling price include the actual discount and agreed services?
2. Are all acquisition costs present, final, and allocated once?
3. Did delivery, cancellation, damage, or a return change the economics?
4. Is the commission calculation using the agreed basis and earning event?
5. Which quoting, purchasing, or service decision should change next time?

There is no universal special-order margin that every store should clear. Set a target against the store’s expense structure, service promise, product mix, and required profit. Compare orders using the same definition, then decide what to improve.

A fabric library can accommodate several nearly identical shades of oatmeal. A margin review benefits from fewer meanings for the same label. Bring the agreed definitions into the owner’s dashboard so the next monthly average has useful detail behind it.

Sources

1. Migrating from Stocky to Shopify inventory management: inventory costs — Shopify Help Center.