Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceE-commerce OperationsShipping Cost Calculator

SpreadsheetE-commerce OperationsFree

Shipping Cost Calculator

Work out dimensional weight, billable weight and zone-based shipping cost per parcel, and see your margin on shipping charged.

Shown with sample data

Colour

Shipping Cost Calculator

Work out dimensional weight, billable weight and zone-based shipping cost per parcel, and see your margin on shipping charged.

Average shipping cost
$30.35
Net margin on shipping
-$145.73
Negative means you subsidise shipping
Parcels billed on dim weight
3
Parcels shipped at a loss
6
Shipping margin by parcel
  • Syrup trio$1.45
  • Espresso blend 1 kg (mailer)-$6.32
  • Tamper (padded mailer)-$8.11
  • Milk jug in gift box-$8.99
  • 2 x espresso blend (small box)-$11.38
  • Starter kit (large box)-$44.02
  • Cups case of 1,000-$68.36

How to use it

  1. 1Enter your carrier’s dimensional divisor, fuel surcharge and packaging cost on the Settings sheet.
  2. 2Replace the example rate card on the Zones sheet with your carrier’s rates (first pound and each additional pound by zone).
  3. 3Add each parcel or product with its packed dimensions, weight and destination zone.
  4. 4Check parcels where Dim weight applies and try a smaller box.
  5. 5Use the average shipping cost to set shipping charges or a free-shipping threshold.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Carriers charge for the space a parcel takes up as well as its weight, and oversized boxes quietly destroy shipping margins. Enter each parcel’s dimensions, actual weight, destination zone and what the customer paid for shipping; the calculator works out dimensional weight (L × W × H ÷ divisor), billable weight (the greater of actual and dimensional, rounded up), the zone rate from your rate card, fuel surcharge and packaging, and the profit or loss on shipping for each parcel.

Who it’s for

  • Setting shipping prices and free-shipping thresholds
  • Choosing box sizes that avoid dimensional weight charges
  • Checking carrier invoices
  • Comparing what customers pay with what shipping really costs

What’s included

  • Parcels sheet: Billable weight, cost and margin per parcel.
  • Zones sheet: Your carrier rate card by zone.
  • Settings sheet: Carrier rules and packaging cost.

How to use it

  1. 1Enter your carrier’s dimensional divisor, fuel surcharge and packaging cost on the Settings sheet.
  2. 2Replace the example rate card on the Zones sheet with your carrier’s rates (first pound and each additional pound by zone).
  3. 3Add each parcel or product with its packed dimensions, weight and destination zone.
  4. 4Check parcels where Dim weight applies and try a smaller box.
  5. 5Use the average shipping cost to set shipping charges or a free-shipping threshold.

Tips

  • Measure the packed box, not the product, and round each dimension up to the nearest inch as carriers do.
  • Common divisors are 139 for US domestic express services in inches and pounds, and 5,000 or 6,000 for centimetres and kilograms. Check your carrier’s current rules and any discounts on your account.
  • Poly mailers and right-sized boxes often cut costs more than negotiating rates.
  • The example rate card is illustrative only; carrier rates change at least yearly.

Questions

What is dimensional weight?

A calculated weight based on a parcel’s size: length × width × height ÷ the carrier’s divisor. Carriers bill whichever is greater, the actual weight or the dimensional weight.

How do I calculate billable weight?

Calculate dimensional weight, compare it with the actual weight and take the greater, rounded up to the next whole pound (or kilogram). The sheet does this for every parcel.

What are shipping zones?

Bands of distance from your shipping origin. Higher zones cost more. Your carrier provides a zone chart based on your origin postcode.

Related searchesshipping cost calculatordimensional weight calculatordim weight shippingbillable weight calculatorshipping rate calculator excelecommerce shipping costs

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetE-commerce OperationsFree

Shipping Cost Calculator

Work out dimensional weight, billable weight and zone-based shipping cost per parcel, and see your margin on shipping charged.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
E-commerce Operations
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More e-commerce operations templates

View all
E-commerce Profit Calculator2 sheets

Listings analysed

8

Average net margin

21%

Losing money

1

Entries by channel
3
2
2
1
Own storeAmazonEtsyeBay
SpreadsheetE-commerce Operations

E-commerce Profit Calculator

True profit per order after product cost, shipping, marketplace and payment fees, ads and returns.

10 min setupPreview

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

Full name *

Email *

Phone *

Place order
FormE-commerce Operations

Customer Order Form

Take product orders online: customer details, items and quantities, delivery or collection, and payment choice.

10 min setupPreview
Product Catalogue with Margins2 sheets

Products

7

Average margin

64%

Low-margin products

1

ABCD
1ProductCategoryVariantSupplier
2Organic cotton teeApparelBlack / MGreenThread
3Heavyweight hoodieApparelGrey / LGreenThread
4Canvas tote bagAccessoriesNaturalBagCo
5Embroidered capAccessoriesNavyCapWorks
Products
SpreadsheetE-commerce Operations

Product Catalogue with Margins

SKUs with cost, price, margin, markup, stock and status for every product.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ