EXCEPTIONS HANDLED · #8 · Shipping Fees
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.
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. |
Shipping pricing is dynamic and unpredictable by design.
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. |
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. |
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.) |
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. |