A shipping worksheet should answer a practical question: after the parcel arrived, how much did this order contribute, and what should change next time? A spreadsheet that records only label prices cannot answer it. Neither can a complicated model that takes longer to maintain than the shipments themselves.
Build one row per order with package facts, buyer payment, final fulfillment cost, exception cost, and a clear contribution calculation. Use a second small table for reusable package profiles and a third for claims or adjustments if volume justifies it. Start with a few recent orders, check the arithmetic, and expand only when the sheet helps you make a decision.
This is the final part of the Shipping Profit Guide. The previous articles explain true shipping cost, packaging, carrier and service selection, measurement and address accuracy, and damage, claims, and returns. The worksheet joins them into one repeatable order record.
Decide what the sheet measures
Use two related outputs. Shipping contribution tells you whether the buyer’s explicit delivery payment covers fulfillment. Order contribution tells you whether the whole sale covers product, fees, and fulfillment. A seller can intentionally offer free shipping or charge less than the full cost if the item price covers the difference. That policy should be visible in the numbers.
Use these definitions consistently:
Shipping contribution = buyer shipping charge − final fulfillment cost.
Order contribution = total buyer payment − product cost − selling fees − final fulfillment cost − other order-specific costs.
Final fulfillment cost includes the purchased label, later carrier corrections, packaging materials, packing labor if you include it in your planning model, trip or pickup allocation, service extras, and net shipping exception cost. If you use an expected loss reserve for pricing, keep it separate from realized claims and returns so an actual incident is not counted twice.
Order contribution is not a complete tax or accounting statement. It is a consistent management view that helps compare orders. Choose a convention for discounts, sales tax collected on behalf of a marketplace, and fee refunds, then apply it the same way every month. If you need formal financial reporting, reconcile the worksheet to your accounting records.
Create the minimum useful columns
Start with columns that drive a decision. A row can represent one order even if that order has two parcels; use a separate parcel table when multi-parcel orders become common. The order ID connects the worksheet to receipts, tracking, and claim evidence.
| Group | Suggested columns |
|---|---|
| Identity | Order ID, sale date, product category, marketplace, package profile |
| Promise | Handling deadline, selected service, planned and actual acceptance dates |
| Parcel | Parcel count, finished dimensions, actual weight, destination zone or region |
| Buyer payment | Item price, shipping charge, discount, total buyer payment |
| Product and fees | Acquisition or production cost, selling fees, payment fees |
| Fulfillment | Quoted label, purchased label, adjustment, materials, labor, trip, extras |
| Exception | Return label, reshipment, refund treatment, claim recovery, salvage value |
| Result | Final fulfillment cost, shipping contribution, order contribution, notes |
Keep the raw amounts distinct from calculated totals. If one column mixes “label plus supplies” on some rows with “label only” on others, trends become meaningless. Add a data dictionary in the sheet’s first tab explaining what every cost field includes. This is especially important when more than one person packs or reconciles orders.
Do not force sensitive customer details into a shared sheet. An order ID and broad destination region are often enough for analysis; the transaction platform can hold the full address. The goal is financial and operational comparison, not a second customer database.
Write formulas that can be audited
For a basic one-parcel order, use plain formulas with named columns or clearly labeled cell references:
Final label cost = purchased label + later carrier adjustments − label refunds.
Final fulfillment cost = final label cost + packaging + packing labor + handoff + service extras + net exception cost.
Shipping contribution = buyer shipping charge − final fulfillment cost.
Order contribution = total buyer payment − product cost − selling fees − final fulfillment cost − other direct costs.
If a replacement shipment is needed, put its label, supplies, and labor in the exception cost. If a claim reimbursement arrives, subtract it from net exception cost when received, or track it as a separate recovery column with a formula that subtracts it once. If you refund the original item payment, be careful: either reduce total buyer payment to the retained amount or include the refund as a direct cost, but not both.
Protect formula columns from accidental edits if the sheet is shared. Put a small test row with known numbers near the top. For example, if buyer shipping is $8, label is $7, packaging is $2, and labor is $3, shipping contribution is −$4. If the item payment is $30, product cost $9, and selling fees $5, total buyer payment is $38 and order contribution is $12. This is illustrative arithmetic, not a claim about typical prices or margins. If your formula returns a different result, fix it before importing hundreds of orders.
Compare quote with final outcome
The quote is useful for setting a listing or selecting a service; the final charge tells you whether the process worked. Record both. Calculate a simple variance:
Label variance = final label cost − quoted label cost.
A positive variance may come from a weight or dimension correction, a service change, an address issue, an added option, or a quote made with old information. A negative variance may reflect a better available rate or refunded label. Add a reason code for large variances. The measurement and address guide explains how to investigate repeat corrections.
Avoid treating a single distant shipment as proof that your standard shipping charge is wrong. Group by package profile, service, and destination. A flat delivery price may work for a compact product but fail for bulky parcels sent across the country. Measure the distribution, including costly outliers, before changing every listing.
Add a package-profile table
A profile is a starting estimate for a common packed configuration. Give each profile a name, item types, box or mailer, material cost, expected finished dimensions and weight, typical packing minutes, and date last verified. Include notes on fragile-item protection and whether an original product box must be preserved. Link each order row to the profile actually used.
For example, a small rigid jewelry box and a padded shoe overbox need different materials and dimension assumptions. The costume jewelry guide and footwear resale guide illustrate why item-specific condition and presentation affect packing. If a real order departs from the profile, record its actual dimensions and explain why. Profiles should speed quoting without replacing the final measurement.
Review profiles when rates, supplies, product mix, or damage outcomes change. A new cheaper box is not an improvement if it raises damage. A smaller box is useful only if it still protects the item. Track the real cost of each profile: label, materials, labor, and incidents per order.
Handle multi-item and multi-parcel orders
One buyer payment can produce several parcels. In that case, sum all parcel-level labels, packaging, and labor under the order ID. If you need to compare products, allocate shared shipping cost using a consistent method, such as packed weight, value, or an equal split. No allocation is perfect; document the rule and do not count the full label cost for each item.
Combined orders can also create savings. Two small items in one protective package may cost less to fulfill than two separate orders. Keep the actual order economics and, if useful, record estimated separate-shipment cost as a comparison. Do not treat the hypothetical savings as cash revenue. The buyer paid once and the carrier billed for the parcels actually sent.
For split shipments, record which item went in each parcel and each tracking number. That helps resolve a missing-item report and calculate a partial return. If a buyer returns one item from a combined order, attribute return and refund costs to the order, then analyze the product-level effect separately.
Review exceptions and claims honestly
Create reason codes for damage, loss, failed delivery, return for fit, return for description, wrong item, address correction, and other. Record the gross cost of the event and any later recovery. A claim payment should not make the original damage disappear from operational analysis; keep both the incident and the recovery visible.
Use an exception rate such as incidents divided by fulfilled orders for each package profile. Pair it with average net cost per incident. A low-cost profile with twice the damage rate may be more expensive overall than a stronger box. Small samples can swing widely, so investigate the cases before declaring a trend.
Set a monthly review rhythm: reconcile label adjustments; identify orders with negative contribution; review missed promises, damage, and returns; update package profiles; and decide one or two process changes. Write down the change and compare future orders. Without that loop, the worksheet becomes a historical ledger rather than a decision tool.
Turn the numbers into a pricing decision
Before listing a product, estimate the packed profile, destination exposure, current service quote, materials, labor, selling fees, and expected exception allowance. Decide whether shipping is charged separately, included in the item price, or calculated at checkout. Test the worst plausible destination for a flat rate and the likely cost of an oversized or fragile version of the item.
After sales, compare the estimate with realized contribution. If most orders fall short, adjust the listing price, shipping charge, packaging, service, or product mix. If only a few unusual orders lose money, add a quoting rule for those exceptions. Keep buyer-facing prices clear and comply with the marketplace’s current rules for shipping charges and fee calculation.
The worksheet is successful when it changes a decision: a box size, service default, processing promise, listing price, or return process. Start with the minimum columns, verify the formulas on real orders, and use the final cost rather than the label quote to judge whether shipping is profitable.