Courier paid less than you sold? Reconcile COD parcel by parcel.

Where COD money goes missing

Your courier collects cash at the door, takes its charges and tax, and sends one payment for hundreds of parcels. Unless someone checks each parcel on that report, these four leaks go unnoticed:

• Short payment. The parcel was delivered, but less than the COD amount reached you.
• Wrong fee. A charge that doesn't match your rate card: the wrong weight slab, a city charged as out-of-zone, or a fee applied twice.
• RTO on a delivered parcel. The customer has the goods, the report says returned. You lose the cash and pay a return fee.
• Never paid. Tracking says delivered, but the parcel isn't on any payment, well past your agreed settlement cycle.

There's also tax. Since the Finance Act 2025, couriers collecting COD for online sellers withhold tax for the FBR before paying you. KPMG reported the 2025 rate as 2% on cash-on-delivery orders, and couriers told sellers they would deduct sales tax as well. It isn't a leak, but it must sit in its own column. Check it against the current FBR rate and keep the certificate, or it hides the real errors.

Why Shopify can't catch it

Shopify knows what you sold. It has never seen what the courier paid. Four gaps stop it from reconciling:

1. No remittance import. There's nowhere to upload a courier's payment report and match it to orders.
2. COD stays pending. Shopify's help centre says manual payment orders, COD included, are marked as unpaid, and you mark each one paid after you receive the money.
3. Returns don't settle COD orders. A merchant in the Shopify Community reports that closing a return on a COD order doesn't update it, because the order is still payment pending. There was never a payment to refund.
4. Fulfilled orders can't simply be cancelled. Shopify says a partially fulfilled order can't be cancelled until you cancel the fulfillment. So RTOs pile up as open, unpaid orders that look the same as parcels still on the road.

“

Shopify tells you what you sold. Only your courier's report tells you what you were paid. Reconciliation is matching the two.

Is your courier paying you right?

Two steps: work out what your courier should have paid for last month, then compare it with what actually reached your bank.

Reconcile it in a spreadsheet

You can start today with what you have. Do this every time a payment lands:

1. Export both sides. The courier's payment or settlement report for that payment (from its merchant portal or the email it sends), and your Shopify orders for the same period, with the tracking number on each order.
2. Match on tracking number. Use the tracking (AWB or consignment) number, not the order number. It's the only ID both sides carry exactly. In Google Sheets or Excel, pull each courier line onto its order with XLOOKUP.
3. Add a difference column. COD amount − courier charges − tax − amount paid. Anything not zero needs a reason.
4. Check every RTO against tracking. If the tracking history shows a delivery, or the customer confirms they have it, it's a wrong RTO.
5. List the delivered parcels that aren't paid. Filter delivered orders with no payment line and note how many days since delivery.
6. Send one claim sheet. Tracking number, issue, amount, and proof, all in one file to your courier's account manager. Then mark only the fully matched orders as paid in Shopify.

The lasting fix: a reconciliation ledger

A ledger is the spreadsheet above, made permanent and automatic. It does six jobs:

• Import each courier's payment report as it is, PostEx, TCS, Leopards or Trax, without retyping.
• Match every line to its Shopify order by tracking number, saved when the parcel is booked.
• Flag short payments, overcharges against your rate card, RTOs on delivered parcels, and parcels unpaid past your settlement cycle.
• Build the claim sheet for you, and track each claim until it's paid or rejected.
• Mark matched orders paid in Shopify, so "payment pending" means money you're still owed.
• Restock RTOs when they arrive, not when the courier marks them returned, and feed real cash, fees, tax and returns into your P&L.

Does your store need one yet? Tick what's true.

Why I build it this way

I ran e-commerce operations at a Pakistani fashion brand. I put in an OMS and warehouse system for 5,000+ SKUs and 1,000+ daily orders, set up the courier integrations, including TCS and DHL, and did COD reconciliation myself. The money we found was almost never fraud. It was parcels nobody matched.

Today I run the Shopify stack for a store in Pakistan and in three other countries: webhooks, Shopify apps, and Supabase dashboards, including an inventory ledger and a P&L. A COD ledger is the same pattern: every movement recorded once, matched to an order, and checked.

Want to know what your last payment was missing? Send me the courier report on WhatsApp and I'll match it against your orders.

Questions