The Complete Guide to COD Settlement Reconciliation in Pakistan

In the Pakistani ecommerce market, where Cash on Delivery (COD) accounts for the overwhelming majority of online transactions, reconciliation is not a minor accounting chore—it is the lifeline of your business. When you dispatch 2,000 orders a month, your working capital is constantly floating between customer doorsteps, courier transit hubs, and bank transfer queues.

Most merchants mistakenly treat their courier settlement advice as ground truth. However, logistical errors, missing tracking events, and delayed remittances mean that tens of thousands of rupees are quietly lost every billing cycle unless your finance team actively cross-examines every single parcel.

The Three Fatal Flaws in Manual Spreadsheet Reconciliation

Most store owners or their accountants attempt to reconcile by downloading weekly settlement Excel files and attempting VLOOKUPs against Shopify order exports. Here is why this breaks down:

Core Reconciliation Data Fields

To audit your weekly payout accurately, your reconciliation sheet must capture and compare these key variables:

Payout Variance Formula

For every delivered shipment, verify the payout using this formula:

If Net Variance is negative, the courier has either deducted unauthorized charges or under-remitted collected cash.

Dispute Protocol & Template

When discrepancies are discovered, compile an itemized dispute list and submit it to your courier representative within 7 to 10 days of settlement advice receipt:

Subject: Discrepancy Claim — Merchant [Your Store Name] — Advice #[Settlement ID]

Body Template:

'Dear Accounts Team, Please find attached our reconciliation audit for settlement statement #[Number] dated [Date]. We have identified [Number] CNs with total unresolved variance of PKR [Amount], including [X] delivered parcels omitted from remittance and [Y] parcels billed above catalog weight slab. Kindly review and issue a credit memo in the upcoming settlement.'