How to Reconcile Cash-on-Delivery Payouts, Step by Step
By ProfitIQ · Updated · 4 min read
Why cash on delivery needs reconciling
With prepaid orders the money reaches you from one payment processor, in one report. With cash on delivery the courier collects cash from your customer and pays you later, in batches, after taking its own deductions. Three sources have to agree: your orders, the courier’s delivery status, and the courier’s payment report. Any gap between them is money you may be owed.
What you need before you start
- Your orders with each parcel’s tracking number, COD amount and the date it shipped.
- Delivery status for each parcel: delivered, returned, in transit.
- The settlement from the courier: usually a spreadsheet or statement listing tracking numbers, COD collected, deductions and the net transferred.
- Your tariff: what the courier agreed to charge you, so you can tell a correct deduction from a wrong one.
The reconciliation, step by step
- Match by tracking number. It is the only identifier both you and the courier have. Names and amounts are not reliable keys.
- Check status first. Every settled parcel should be delivered in your records. A parcel paid as delivered but marked returned, or the reverse, is a discrepancy before any money is compared.
- Work out the expected net. COD amount, minus the courier’s agreed charge, minus any tax the law requires it to withhold, minus charges for returns or re-attempts.
- Compare with the amount transferred. The difference is the shortfall, or the overpayment.
- Classify each difference using the table below, so you chase the right thing.
- Dispute with evidence. Send the courier the tracking numbers, expected and received amounts, and the delivery proof, in one document.
Classifying what you find
What you see: Settled in full
- What it usually means:
- Correct
- What to do:
- Nothing
What you see: Paid less than expected
- What it usually means:
- A wrong deduction, a weight adjustment, or a charge not in your tariff
- What to do:
- Dispute the difference with the tracking number
What you see: Delivered, not in any settlement
- What it usually means:
- Not yet remitted, or missing
- What to do:
- Wait for the settlement cycle, then chase
What you see: In the settlement, not delivered in your records
- What it usually means:
- Your status is out of date, or the courier paid in error
- What to do:
- Update your status; return any overpayment
What you see: Returned but charged as delivered
- What it usually means:
- A status mismatch
- What to do:
- Ask for a correction before the next settlement
What you see: Deduction you do not recognise
- What it usually means:
- A charge outside your agreement
- What to do:
- Compare with your tariff and dispute it
Separate withheld tax from a real shortfall
In some countries, including Pakistan, couriers are required to withhold income tax and sales tax from what they pay you, and show them as separate columns on the payment invoice. If you treat the whole gap as a shortfall you will dispute money the courier was legally obliged to withhold. If you treat none of it as tax you will miss real errors. Track withholding at the rates that apply to you, and dispute only what is left.
Check the weight, too
Couriers bill on the weight they measure, which can include volumetric weight: the size of the box rather than what is in it. Compare the billed weight with the parcel’s own weight. A consistent gap on one lane or one courier is worth raising, and the tracking numbers are your evidence.
How often to do it
Reconcile every settlement as it arrives, not at month end. Couriers have limits on how long you have to raise a dispute, and old parcels are harder to prove. The longer you wait, the more you are relying on the courier’s goodwill.
Doing it with ProfitIQ
ProfitIQ matches each settlement row to its order by tracking number, separates withholding tax from real shortfalls at your own rates, and turns what is short into a dispute report. Leopards’ payment advice can be fetched directly; other couriers’ settlement sheets are imported as a CSV. See COD and courier reconciliation.
Find out what your couriers owe you
Start on the free plan, import one settlement and see which parcels do not match.
Frequently asked questions
What is COD reconciliation?
It is checking that the cash a courier collected on delivery was paid back to you in full. Each parcel’s COD amount, the courier’s deductions and the amount transferred are compared, and any difference is investigated.
How do I match courier settlements to orders?
By tracking number. It is the one identifier that appears in both your order records and the courier’s settlement, so it is the only reliable key.
How long do couriers take to pay cash on delivery?
It varies by courier, contract and region, and is set out in your agreement. Delay is a timing issue, not a shortfall, so check the cycle in your contract before treating a late payment as an error.
Can I reconcile COD payouts without software?
Yes, with a spreadsheet and the courier’s settlement file, matching on tracking number. It takes time on every settlement and gets harder as parcel volume grows.