The one field every carrier invoice shares with your records
Carrier invoices differ in almost every respect. Column names, ordering, date formats, whether a surcharge is its own row or a suffix on the carriage row — all of it varies by carrier and changes over time. One field is reliably present on both sides: the tracking reference. It is the only join key worth building a process on.
That makes the reconciliation itself simple in principle. For each invoice line, find the shipment with that tracking reference, then compare what you were charged against the service you booked. The difficulty is never the comparison; it is having the shipment record and the invoice line in the same place.
Why the spreadsheet approach fails at scale
Almost every UK seller starts in Excel, and for a few hundred parcels a month it works. Two things break it.
- The lookup is against a system the spreadsheet cannot see. Somebody exports dispatch data each month and pastes it alongside the invoice. Two exports taken at different moments disagree, and the disagreement is invisible.
- Layout changes break templates silently. When a carrier moves a column, a formula keeps returning numbers. They are just the wrong numbers, and nobody finds out until a quarter later.
Reconciling inside the system that booked the shipment removes both problems, because the order, parcel, service and tracking number are already on one record.
A method that survives a layout change
- Get the invoice into the system as a file, not as retyped data. XLSX and CSV both work; encrypted workbooks need the password once.
- Map the columns you need to shipment fields: tracking reference, charge type, amount, weight, service, date. Expect to redo this when a carrier changes format, and treat it as a mapping exercise rather than a template rebuild.
- Match lines to shipments on the tracking reference. Everything that matches is now comparable against the service you booked.
- Work the unmatched queue by value, not by count. Chase the high-value adjustments; keep the long tail visible rather than absorbed.
- Allocate the surcharges to the orders that caused them, so the cost reaches the margin figure you actually use for decisions.
What to expect on the invoice
The gap between quoted and invoiced cost usually comes from a small set of charges. Knowing which you are exposed to tells you where to look first.
| Charge | What drives it | Visible at booking? |
|---|---|---|
| Fuel surcharge | A percentage of base carriage, revised periodically | No |
| Re-weigh / dimensional | Carrier-measured weight or volumetric weight, whichever is greater | No |
| Remote area / zone | Destination postcode falling outside standard zones | Sometimes |
| Oversize / non-conveyable | Parcel dimensions exceeding automated handling limits | Sometimes |
| Account and collection fees | Period-based, with no single causing shipment | No |
What reconciliation does and does not do
It produces evidence: the invoice line, the shipment it matched, the service booked, the weight declared and the difference. That is what a carrier account manager needs to look at a billing query. It does not raise the claim, and it does not recover money on its own — your carrier contract will normally specify a window for raising a query, so the value of reconciliation depends on doing it inside that window rather than at year end.
No saving figure is claimed here. What the reconciled cost changes is the quality of the margin number you make decisions with, which is covered in marketplace true-cost profit.