Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Industry guides

Subscription box margins: count packing, replacements, and skipped shipments

Measure subscription-box contribution by shipment cohort while tracking prepaid deliveries, skipped boxes, replacements, packing costs, and remaining fulfillment work.

By Institution4 minute readPublished View sources
In this guide

Choose a shipment cohort that can be reconciled

A subscription business collects money on one schedule and sends boxes on another. Annual prepayments, skipped deliveries, free replacements, and add-ons can make a monthly sales total a poor denominator for fulfillment cost. Build the margin review around a defined group of shipments, then show how those shipments connect to the customers' payments and remaining entitlements.

A useful cohort might be all ordinary boxes due for a particular delivery month. Keep replacement boxes and one-time add-ons identifiable within the same review. Record the original subscription, scheduled shipment, actual dispatch, and any change. A box that moved to next month should not vanish from the obligation record when it leaves this month's packing list.

Shopify describes subscriptions as recurring purchase arrangements and allows subscription data to be distinguished in sales reporting. Whatever platform the business uses, retain that purchase-type distinction before combining subscription orders with one-time sales.

References: Shopify: Subscription purchase arrangements and reporting

Define what one delivered box costs

List the product contents, packaging, packing labor, outbound shipping, and other costs that vary with the shipment. State which items are excluded from the contribution measure. A box-level contribution that excludes acquisition costs and central staff should not be labeled company profit.

Use the actual product mix where possible. A substitute item can change the cost of one month's box without changing the price charged to subscribers. Keep packing-material usage and freight adjustments tied to the same shipment population. Comparing a carrier bill for six weeks with boxes dispatched in four weeks creates a timing difference that looks like a margin change.

Shared packing labor needs an understandable allocation. If the team handles both subscriptions and one-time orders, use supported activity or time records. Preserve the method across periods, and explain changes when the process or product mix changes enough to require a different basis.

Include replacements in the economics of the original delivery

A free replacement consumes goods, packing, and freight even though it creates no new customer charge. Link it to the original shipment and reason: damage, missing contents, delivery failure, or another approved issue. Count the physical replacement for inventory and shipping purposes while keeping it out of the count of newly purchased subscription entitlements.

Microsoft's returns documentation separates replacement activity from the original return or credit process. Use a similar connection in the operating records. A replacement order with no link to the original issue is difficult to include in cohort margin or investigate by product and carrier.

References: Microsoft Learn: Return inspection and disposition

Work through a cohort with prepaid boxes

Assume, for illustration, that customers paid for 500 identical boxes at $40 each. During the reviewed delivery period, 400 ordinary boxes are fulfilled and 100 are deferred under the agreed subscription terms. An additional 20 replacement boxes are sent without charge. Assume the reviewed revenue policy assigns $40 to each ordinary box when its delivery obligation is satisfied.

Each shipped box costs $26 in this example: $17 of contents, $2 of packaging, $2 of packing labor, and $5 of freight. Contribution for the 400 satisfied ordinary boxes is $16,000 less $10,400 of ordinary fulfillment cost and $520 of replacement cost, or $5,080. The $20,000 originally collected is a separate cash figure.

Work through a cohort with prepaid boxes
Illustrative measureAmountBoundary
Cash collected for 500 boxes$20,000Includes deliveries still owed
Revenue assigned to 400 satisfied boxes$16,000Assumes the stated reviewed policy
Ordinary fulfillment cost$10,400400 × $26
Replacement fulfillment cost$52020 × $26
Cohort contribution$5,080Before acquisition and fixed costs
Boxes still owed100Keep in the fulfillment record

Reconcile remaining entitlements separately

Maintain a rollforward of boxes owed: opening entitlements plus purchases, less fulfilled boxes, refunds, and other approved changes. Track skips, freezes, transfers, and cancellations according to the contract. A skipped box may move its delivery date without reducing the total number owed.

IFRS 15 ties revenue to satisfaction of the relevant promises, rather than the payment schedule alone. Apply the business's reporting framework and reviewed contract assessment to the subscription. Different products, optional add-ons, or bundled benefits may require a more detailed allocation than the identical-box illustration above.

The obligation rollforward should connect to the relevant accounting balance, with differences explained. Investigate old entitlements and failed collections using the actual terms. An unused subscription should not be removed merely because the customer has not contacted support recently.

References: IFRS Foundation: Revenue from contracts with customers

Choose the operational change from the evidence

Compare cohorts using consistent cost and fulfillment boundaries. If contents became more expensive, review sourcing and product design. If replacements increased, inspect the reasons and whether the same problem repeats. If freight rose, separate carrier adjustments, destination mix, and extra shipments before renegotiating a rate.

Keep acquisition economics beside the shipment review when management is deciding how quickly to grow. A positive delivered-box contribution can coexist with a large amount of prepaid fulfillment still owed. Preserve both the contribution result and the remaining shipment commitment in the operating report.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.