How to Reconcile Courier COD Settlements (And Catch Discrepancies)

Why settlements are often wrong

Courier COD remittances are frequently inaccurate. In the Pakistani ecommerce market, discrepancies are common — and most stores only catch a fraction of them because they lack a systematic reconciliation process.

Common reasons for settlement errors include: miscounted deliveries (the courier's record differs from yours), incorrect COD amounts (the actual collected amount differs from the invoice), return parcels included in delivery counts, Finance Act 2025 WHT deductions not properly documented, and service charges applied at wrong rates.

Merchants who implement systematic settlement reconciliation typically recover 1–3% of their gross COD volume in previously undetected discrepancies.

At PKR 2,000,000 in monthly COD volume, 1% recovery is PKR 20,000/month that was silently being lost.

The manual reconciliation process

Without a tool like Courierify, manual reconciliation works like this:

1. Download your courier's settlement report (typically an Excel file)
2. Export your Shopify/OMS delivered orders for the same period
3. Match each delivered order's COD value against what the courier reports collecting
4. Identify orders in your list not in the courier's settlement
5. Identify COD amounts that differ between your records and the courier's
6. Calculate expected total vs. received total
7. Raise a dispute with the courier for identified shortfalls

For a store with 1,000 weekly deliveries across 3 couriers, this process takes 4–6 hours per week. Most stores skip it entirely.

Common discrepancy types

Delivered but not settled: The courier confirms delivery but doesn't include the COD amount in the remittance. Common causes: system errors, COD not collected but delivery marked as success, remittance period cutoff timing.

Wrong COD amount: The courier remits a different amount than the invoice COD value. Usually small differences — PKR 50–200 per order — but they accumulate.

Return charged incorrectly: A return is charged the full return fee, but the parcel was actually delivered and the status was mis-updated. Requires cross-referencing your tracking data.

WHT deduction not documented: Under Finance Act 2025, 2% WHT should be deducted and a certificate provided. If the deduction is taken without documentation, you can't claim it as a tax credit.

Building a reconciliation habit

Even without automation tools, you can build a basic reconciliation process:

• Schedule a fixed time weekly to reconcile each courier's settlement
• Maintain a running discrepancy log with courier, amount, and reference number
• Set a minimum discrepancy threshold for raising formal disputes (e.g. PKR 500+)
• Track cumulative unresolved discrepancies per courier as a performance KPI

How Courierify automates this

Courierify's COD Settlement Reconciliation (Pro plan) automates the entire process:

• Expected settlement is automatically calculated from your booked and delivered orders
• Upload the courier's settlement file — Courierify matches it order by order
• Discrepancies are flagged automatically with the specific order reference
• WHT deductions are tracked and broken out separately from courier fees
• Settlement reports generated in the format needed for accounting and FBR filing

What takes 4–6 hours manually takes under 10 minutes with Courierify.

What to do when you find a discrepancy

When Courierify flags a discrepancy:

1. Download the per-order discrepancy report from Courierify
2. Contact your courier account manager with the report as supporting documentation
3. Reference specific order/tracking numbers and amounts
4. Set a follow-up reminder — couriers typically resolve disputes within 5–10 business days
5. Mark the dispute as resolved in Courierify when confirmed

Couriers are generally responsive to well-documented disputes. The key is having the evidence — which Courierify's reconciliation report provides automatically.