EXCEPTIONS HANDLED · #8 · Shipping Fees
The Shipping Fee Surprise
When Carrier Rates Don’t Match What Got Posted
|
THE PROBLEM IN PLAIN ENGLISH
You charged the customer $8.99 for shipping. The carrier billed you $12.47. That $3.48 gap multiplied by a few thousand orders is eating your margin — and your books don’t even show it because the posted shipping amount doesn’t match the actual cost. |
Shipping costs are one of the most misunderstood line items in ecommerce accounting. What you charge the customer for shipping, what the carrier actually bills you, and what gets posted to QuickBooks are often three different numbers. The gap comes from dimensional weight adjustments, zone changes, surcharges that weren’t in the rate at checkout, and carrier rate updates that happen mid-quarter without warning. Most sellers only discover the variance when their shipping expense account is way over budget — or when gross margin erodes and nobody can explain why.
Detection Signals
Shipping fee mismatches hide in your P&L as inflated COGS or unexplained margin erosion.
Shipping expense consistently over budget Your shipping line item is 15-20% higher than what you’re collecting from customers. The gap is carrier billing adjustments that aren’t reflected in your posted amounts. |
Carrier invoices that don’t match posted shipping costs Pull your UPS, FedEx, or USPS invoice and compare against what QB shows for shipping. The delta is real money. |
Dimensional weight surcharges you didn’t expect The package was light but bulky. The carrier billed dimensional weight. Your checkout rate was based on actual weight. That’s a per-package surprise. |
Gross margin erosion with steady revenue Revenue is flat or growing but margin is shrinking. Shipping cost variance is one of the most common hidden culprits. |
Why This Keeps Happening
Shipping pricing is dynamic and unpredictable by design.
- Carriers update rates annually (and sometimes mid-year) but your checkout shipping calculator uses static rates that you set months ago.
- Dimensional weight calculations differ by carrier. What UPS charges for a 12×12×12 box is different from FedEx’s calculation for the same box.
- Surcharges (fuel, residential delivery, remote area) are applied after the label is created. They don’t appear in your quoted rate.
- Multi-carrier strategies mean each order might ship via a different carrier, making cost tracking inherently messy.
How to solve it yourself (hard but possible)
You’ll need to reconcile carrier invoices against posted shipping costs and adjust your checkout rates.
Pull carrier invoices for the last 90 days Get detailed invoices from every carrier you use. You need per-shipment detail, not just the monthly total. |
Compare against posted shipping in QB Match each shipment’s actual cost against the shipping amount posted for that order. Calculate the per-order variance. |
Update your checkout shipping rates Adjust the rates you charge customers to reflect actual carrier costs, including average surcharges. Build in a buffer. |
Create a shipping variance account Post the difference between collected and actual shipping to a dedicated account. Track it monthly. |
How to solve this through automation (easy peasy)
Webgility can post actual carrier costs alongside collected shipping amounts, so the variance is always visible.
Actual cost posting When carrier billing data is available, Webgility posts the actual shipping cost alongside the amount collected from the customer. |
Variance tracking built in The difference between collected and actual shipping is automatically posted to a variance account for easy monitoring. |
Rate analysis reports See which carriers, zones, and service levels have the highest variance. Data-driven decisions about your shipping strategy. |
Month-End Checklist
- ☐ Compare carrier invoices against posted shipping amounts for the last quarter
- ☐ Check dimensional weight settings in your carrier accounts
- ☐ Review checkout shipping rates against current carrier rate cards
- ☐ Create a shipping variance account if you don’t have one
- ☐ Verify surcharges (fuel, residential, remote) are factored into your pricing
- ☐ Audit multi-carrier shipping rules for cost optimization
Glossary
Dimensional weight A pricing technique where the carrier charges based on package volume (dimensions) rather than actual weight, whichever is greater |
Shipping variance The difference between what you charged the customer for shipping and what the carrier actually billed you |
Surcharge An additional fee applied by the carrier beyond the base shipping rate (fuel, residential, oversize, etc.) |
Common Questions
Should I charge customers exact shipping cost or a flat rate? Flat rates are simpler but create variance. If your average actual cost is $10 and you charge $8.99, you’re losing $1.01 per order. Consider tiered rates based on order weight/value. |
How do I account for free shipping promotions? The carrier still charges you. Post the full carrier cost as a shipping expense and the ‘free shipping’ discount as a contra-revenue or promotional expense line item. |
Why do carrier invoices come weeks after the shipment? Carriers apply billing adjustments (dimensional weight, address corrections, surcharges) retroactively. This is why the invoice total is almost never what you expected. |