Excel · SheetsBillable weight per box and product, packaging cost per order, carrier comparison and shipping charged vs paid.
What's included:
- Boxes: volume and dimensional weight with your divisor
- Products: billable weight and a dim-weight flag
- Packaging cost per order including labour
- Rates: cheapest carrier per product
- Orders: shipping profit or loss and free-shipping threshold test
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Dimensional-weight divisor (in³ per lb) | 139 |
| Tape & label cost per order | 0.15 |
| Packing minutes per order | 4 |
| Packing labour per hour | 18.00 |
| Free-shipping threshold to test | 50.00 |
Summary Summary
- Orders logged
- Shipping charged to customers
- Label costs paid
- Packaging costs
- Shipping profit / loss overall
- Average shipping loss per order
- Products billed on dimensional weight
- Orders over the free-shipping threshold
Sheet Boxes — Every box or mailer you stock.
| Box | Length in | Width in | Height in | Cost each | Volume in³ | Dim weight lb |
|---|---|---|---|---|---|---|
| Mailer 10×13 | 13 | 10 | 1 | 0.35 | auto | auto |
| Small box | 8 | 6 | 4 | 0.62 | auto | auto |
| Medium box | 12 | 10 | 6 | 0.85 | auto | auto |
Sheet Products — How each product ships.
| Product | Packed weight lb | Box | Fill / wrap cost | Insert / thank-you | Dim weight lb | Billable lb | Dim weight applies? | Packaging per order |
|---|---|---|---|---|---|---|---|---|
| Ceramic mug (boxed) | 1.4 | Small box | 0.30 | 0.10 | auto | auto | auto | auto |
| Throw pillow | 2.0 | Large box | 0.10 | 0.10 | auto | auto | auto | auto |
| Print 11×14 | 0.6 | Mailer 10×13 | 0.40 | 0.10 | auto | auto | auto | auto |
Sheet Rates — Label cost per carrier for each product (from the carriers' calculators).
| Product | Zone / region | Carrier A | Carrier B | Carrier C | Cheapest | Cheapest carrier |
|---|---|---|---|---|---|---|
| Ceramic mug (boxed) | Zone 5 | 9.40 | 10.15 | 11.80 | auto | auto |
| Throw pillow | Zone 5 | 14.20 | 12.90 | 15.60 | auto | auto |
Sheet Orders — Shipping charged vs paid, per order.
| Date | Order # | Product | Order value | Shipping charged | Label cost | Carrier | Packaging | Shipping profit / loss | Over threshold? |
|---|---|---|---|---|---|---|---|---|---|
| 2026-11-02 | 1041 | Ceramic mug (boxed) | 28.00 | 6.95 | 9.40 | Carrier A | auto | auto | auto |
| 2026-11-03 | 1042 | Throw pillow | 64.00 | 0.00 | 12.90 | Carrier B | auto | auto | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com