Courier Invoice Reconciliation: Stop Paying for Shipments You Didn't Send

Published on 10/18/2026 • Updated on 10/22/2026

A courier invoice arrives on the fifth of the month. It lists 214 shipments and a total of Rs 41,860. Accounts approves it, because the courier is a regular vendor and the amount looks normal. Nobody checks whether the company really sent 214 shipments. Nobody checks the weights, the rates or the duplicates.

This is how companies end up paying for shipments they never sent. This guide shows how to reconcile a courier invoice with your own outward register in an hour a month: what to match, the errors that turn up most often, a simple routine and a worked example. The figures are assumed, to show the method.

Why reconcile

The courier's invoice is the courier's record. Your outward register is your record. When they agree, you pay with confidence. When they differ, one of them is wrong, and it is usually worth finding out which.

What to match

Our guide to the outward courier register gives a format that has each of these fields ready for matching.

Errors that turn up often

• Shipments on the bill that are not in your register: sent by someone without logging, or not sent by you at all.
• Duplicate tracking numbers billed twice.
• Weight higher than the real weight, especially rounded up.
• Wrong zone, so a higher rate than the one agreed.
• Surcharges not in the rate agreement.
• Returned or undelivered items charged as delivered.
• Pick-up dates outside the billing period.

Not every difference is the courier's fault. Some are your own unlogged shipments, which is a process problem to fix.

A monthly routine

In Excel, a lookup formula such as =COUNTIF(Register!G:G,A2) next to each tracking number on the bill returns 0 for a line not in your register and 2 or more for a duplicate.

A worked example

The figures are illustrative. At Rs 2,450 a month, the saving over a year is Rs 29,400. A bigger shipper has a bigger number.

Understanding weight charges

Couriers bill on the higher of actual weight and volumetric weight. Volumetric weight is worked out from the box size, usually length times width times height divided by a factor the courier states in its terms. A light but bulky box can therefore be billed at a higher weight than it shows on a scale.

Check the factor in your agreement. If the register records box size as well as weight, you can test the billed weight yourself. Smaller boxes, or tighter packing, cut cost directly.

Surcharges to watch

• Fuel surcharge: usually a percentage that changes. Check it against the agreement each month.
• Remote area or out-of-delivery-area charges: check the pin code against the courier list.
• Handling or oversize charges: ask for the rule and the measurement.
• Cash on delivery fees and insurance: check they were requested.
• Address correction and re-delivery fees: ask what caused them.

A surcharge that appears in one month and not in the last is worth a question. Ask for the clause in the agreement that supports it.

Who should own the check

Give the job to one person in accounts, with a back-up, and let the admin head or mailroom lead supply the register. Keep the roles separate: the person who books couriers should not be the one who approves the bill. Agree a calendar, for example statement by the fifth, matching by the tenth, disputes sent by the twelfth and payment by the twentieth.

Report the savings to management every quarter. A visible number keeps support for the effort and helps justify a better system for the mailroom.

When a line is not in your register

Do not simply reject it. First ask your own people. A department may have booked a pick-up directly. The line may be a return of your item, or a shipment sent from another office on your account. Find out, then either add it to the register with a note or dispute it with the courier. Either way, the habit of asking improves the register.

Use the contract and the rate card

Keep the signed rate agreement next to the register. It sets the rates by zone and weight, fuel surcharge rules, the rounding of weight and the time for raising billing disputes. Read the dispute window and set a calendar reminder, so that you raise queries inside it and not after.

Common mistakes

Another mistake is checking only the total. Two errors in opposite directions can cancel out and hide.

A third is letting one person book, receive the bill and approve it. Split the roles between at least two people.

A fourth is ignoring small amounts. A few rupees on each of hundreds of lines is the pattern that adds up over a year, and it is usually the easiest to recover because the courier can see the error immediately.

A first-month plan

Run your first reconciliation.

Repeat monthly and report the amount recovered. After three months, look at the pattern of disputes. If most come from one courier, raise it at a review meeting with the account manager and ask for a corrective plan. If most are unlogged shipments, the fix is inside your own office: remind staff that every pick-up goes through the register, and stop the courier from collecting parcels directly from desks.

Five-minute self-check

Check your courier billing against these points.

Two or more no answers mean this is worth fixing before anything else on your list.

Reader Q&A

Bottom line

A courier invoice is a claim, and the outward register is your evidence. Match by tracking number, check weights and rates, dispute what does not fit and pay the rest.

Start with one month, and keep a record of what you recovered. Share the first result with your accounts head and the mailroom lead together, so that both sides see how the register and the bill fit, and agree who will own each step from the next month onwards.

Author of the Blog Post

Aadeshwar Modi

Technical Content Writer at VisitorFlow

Aadeshwar Modi is a marketing technical content writer who loves writing on technology and AI topics.