How to audit courier invoices against your own shipments

Import the invoice and map its columns once — tracking number, service, date, weight, zone, base charge, each surcharge, total. Save the mapping against the carrier so next month is an upload rather than a project.

• Carrier column names change without notice; a saved mapping that fails loudly is better than one that guesses.
• Keep the original file. A dispute is much easier to argue from the carrier's own bytes.
• If the carrier emails invoices, collect them to a dedicated mailbox so the audit does not depend on someone forwarding one.

Match each invoice line to a shipment on the tracking number. Where that fails, fall back to your consignment reference, then to a narrow date-plus-postcode window — and label which method matched each line, because a weak match deserves less trust.

• Expect a high match rate on tracking. A low rate usually means a format difference, not thousands of mystery parcels.
• Never auto-accept a date-and-postcode match on a high-value line; review those individually.

Was this parcel ours at all? Was it the service we selected? Is the billed weight consistent with what we recorded? Is each surcharge one the account's schedule permits?

• Service upgrades applied by the carrier are common and often legitimate — but they should be visible, not silent.
• Compare billed weight against your recorded weight and flag differences beyond a tolerance you set, rather than every gram.
• Check surcharge codes against the schedule; an unrecognised code is a question, not a cost.

Unmatched lines almost always cluster: one depot, one date, one service, one collection. Sort by those dimensions and the cause usually names itself — a missing manifest, a returns label billed to you, a duplicate scan.

• Returns labels you issued are a legitimate charge and a common surprise; recognise them rather than disputing them.
• Duplicate tracking numbers across two invoice periods are worth checking specifically.

Raise disputes as one batch per carrier per invoice, with the tracking number, the charge, the reason and your own record attached. Note the carrier's dispute deadline, because a valid dispute raised late is simply a cost.

• Track each dispute to a resolution rather than a submission — unresolved disputes quietly become accepted charges.
• Record the outcome by reason code so you learn which disputes are worth raising.
• Where a re-weigh is upheld, fix the recorded dimensions for that product rather than disputing it again next month.

Once a line is agreed, push the actual charge — base plus surcharges — onto the order that caused it. This is the step that turns an audit into better decisions, because it is what makes channel and product profit true.

• Allocate to the parcel, then to the order; a multi-parcel order needs the parcels summed.
• Keep the invoiced charge separate from the quoted charge so you can see the gap by channel.
• Surcharges belong on the order that triggered them, not spread across the month.

Review the month's surcharge reasons and act on the top two. Remote-area charges may be a pricing question; re-weighs are a data question; address corrections are a checkout question. The audit's value compounds only if something changes.

• Feed corrected weights and dimensions back into the product records.
• If one channel generates most of the surcharges, that belongs in its margin, not in a shared carriage account.