How do you reconcile parcel charges without checking every order manually?
What would you sample first if a monthly carrier invoice includes duty, tax and handling for hundreds of small shipments?
All questionsTariffs
10 replies
- Group by destination, basket type and charge pattern. A few useful groups make unusual lines much easier to spot than scanning the invoice from top to bottom.
- Start with the biggest differences from the checkout estimate, then add a random sample of ordinary orders. Only checking exceptions can miss a systematic error. I'd record the sample method too, even if it's simple. Then next month you can tell whether the apparent improvement reflects better billing or merely a different set of orders being inspected.
- Keep government amounts separate from carrier service fees in the reconciliation. Different questions go to different people.
- Match each line to the shipment identifier and the product data version used. Without that link, every discrepancy becomes a fresh investigation.
- Look for duplicate charges and credits before arguing about rates. The simplest mistakes can produce a surprising amount of noise.
- Include returned and refused parcels in the sample. They often follow a different billing path from successful deliveries.
- Agree on a clear tolerance and escalation rule with finance. Tiny rounding differences and a missing category charge shouldn't sit in the same queue.
- Where the carrier offers line-level files, keep the original download. A PDF total is difficult to audit once someone asks about one specific parcel.
- Feed confirmed corrections into the pricing model. Reconciliation shouldn't be a monthly ritual that discovers the same mismatch forever.
- Give the carrier a few complete examples when raising a pattern. A focused set of shipment references is usually easier to resolve than 'your whole invoice looks wrong'.
Write a reply
Loading…