Skip to main content

COD Reconciliation in Pakistan: Shopify and WooCommerce

  • November 11, 2026
  • 9 min read
  • By CYPHEX
COD Reconciliation in Pakistan: Shopify and WooCommerce
Illustrative animation with example data

Cash on delivery reconciliation means proving that every rupee a customer handed to a rider ends up in your bank account, or has a clear reason why not. This guide is for Pakistani store owners on Shopify or WooCommerce, and for whoever keeps their books. It covers how to match courier remittance (the payout a courier makes after delivery, minus fees and returns) to store orders, how to spot missing payments, what to do with returned and failed parcels, and where automation actually helps.

It goes deeper than the reconciliation section in our COD order confirmation guide, which only sets out the three questions to agree with your courier. Here we build the routine.

Why COD needs its own reconciliation

With card payments, the gateway tells you what was paid and what was fee. With COD, cash passes through a rider, a branch and a courier finance team before you see it, and your store already shows the order as shipped. Payouts also arrive in batches, so you cannot match by amount alone.

What we verified, and what we did not

Checked on 11 November 2026.

Verified. Shopify’s manual payments page says COD orders stay unpaid until you receive payment, and that you then mark the order as paid on the order details page. WooCommerce’s cash on delivery documentation says a COD order defaults to Processing, and that you should confirm the payment was collected before changing it to Complete.

Not verified. I could not find a published payout schedule, fee structure or statement format on the pages I could read for PostEx, TCS, Leopards, Trax or M&P. The PostEx home page I fetched promotes upfront payments but does not explain when or how they are made. Wherever this guide mentions payout timing, fees or statement layout for a courier, the honest answer is: check with your courier account manager, and get it in writing. Third-party blogs quote general ranges, but I would not budget around a number that your own courier has not confirmed.

The numbers you are reconciling

For every parcel, three amounts should line up:

  1. Order total in your store (what the customer owed).
  2. COD amount you sent to the courier when booking (what the rider was told to collect).
  3. Remitted amount in the courier statement (what the courier says it collected, less its deductions).

A gap between 1 and 2 means a data entry or integration problem on your side, such as a discount or shipping change made after booking. A gap between 2 and 3 is either an agreed deduction (courier fee, return charge) or a problem to raise with the courier.

Example (made-up numbers). Order #1001 is Rs. 3,000, booked with COD Rs. 3,000. The statement shows Rs. 3,000 collected, Rs. 250 fee, Rs. 2,750 payable. That matches. Had it shown Rs. 2,500 collected, you would raise it.

Spreadsheet columns to keep

You do not need special software to start. One sheet, one row per parcel, with these columns:

ColumnSourceWhy you need it
Order numberStorePrimary key
Order dateStoreAgeing
Customer phone (last 4 digits)StoreQuick disputes without exposing full data
Order totalStoreExpected amount
COD amount bookedCourier bookingCatches amount mismatches
Courier nameStore or bookingDifferent couriers, different cycles
Tracking / CN numberCourierMatching key to statements
Booking dateCourierAgeing
Courier statusCourierDelivered, returned, failed, in transit
Delivery dateCourierStarts the payout clock
Amount collectedCourier statementWhat the rider took
Fees and deductionsCourier statementDelivery, return, other
Net payableCourier statementWhat you expect in the bank
Statement or batch referenceCourier statementLinks rows to one payout
Bank credit date and amountBankCloses the loop
Store payment statusStorePaid or pending
Notes / dispute statusYouHistory

If your courier statement uses different headings, map them once and keep the mapping written down.

Order states and what to do for each

StateWhat it meansWhat to do
Delivered, paid outCourier shows delivered and the amount appears in a statement and your bankMark paid in the store, close the row
Delivered, not yet paid outCourier shows delivered, no statement line yetCheck against the payout timing your courier gave you; chase only after that date has passed
ReturnedParcel came back to youRestock after inspection, tag the order, confirm no cash was expected, record the return charge
FailedDelivery attempt failed (no answer, wrong address, refused)Check whether it is still in the courier network or already marked for return; decide reattempt or return
In transitBooked and movingDo nothing, but flag anything older than your normal delivery window
DisputedAmount or status differs between store and courierGather proof, raise with the courier in writing, set a follow-up date

The labels your courier uses will differ from these. Map each courier status to one of these six states so your sheet stays consistent.

A weekly reconciliation routine

Pick one weekday and keep to it. Thirty focused minutes weekly is easier than a month-end panic.

  1. Export your orders. From Shopify, export recent orders from the Orders page. From WooCommerce, export orders from the orders screen or use your reporting plugin. Filter to COD.
  2. Pull the courier data. Download each courier’s latest delivery report and payment statement from its merchant portal. If a portal has no export, ask your account manager what they can send.
  3. Match by tracking number. Not by amount, and not by customer name. Tracking number or order reference is the only reliable key.
  4. Assign each row one of the six states from the table above.
  5. Check amounts. For each delivered row, compare order total, COD amount booked and amount collected. Highlight differences.
  6. Compare statements to the bank. Add up the net payable on each statement and confirm one bank credit for that total. If the sums differ, list which rows are missing.
  7. Mark paid in the store. Only after the money reaches you, or after you have decided to book by statement, per your own accounting rule. Shopify and WooCommerce behave differently here, covered below.
  8. List the exceptions. Missing payments, amount differences, returns without a status change, and parcels stuck in transit. Send one written query per courier, with tracking numbers.
  9. Record follow-ups with a date so nothing disappears.

Shopify versus WooCommerce: where the order status lives

On Shopify, a COD order is unpaid until you mark it paid, per the manual payments page, so the unpaid filter on the Orders list is already a rough receivables list. The risk is marking orders paid at delivery instead of at cash receipt, which hides missing payouts. Decide your rule and stick to it. For scripts, the orderMarkAsPaid mutation records a payment on an order with an outstanding balance.

On WooCommerce, the COD documentation says orders default to Processing and should become Complete only once payment is collected. Many stores mark Complete at delivery, which loses the receivables view. Consider a note or custom field for “delivered, awaiting remittance”. I could not confirm WooCommerce’s full status definitions, so check your own version.

Spotting missing payments

Missing money rarely looks like missing money. Watch for:

  • Delivered long ago, never in a statement. Compare the delivery date with the payout timing your courier confirmed.
  • A statement line short of the COD amount, with no explanation.
  • Fees higher than agreed. Check each line against your agreement.
  • Duplicate or reversed lines after a return.
  • A bank credit that differs from the statement total.

Keep an ageing view, grouped by days since delivery, and start with the oldest group.

Returned and failed parcels

Returns hurt twice: you lose the sale and pay for the round trip. Reconciliation should make that visible.

  • Record a return as an event, not a deletion. Mark it Returned, add the return charge, note whether stock was restocked.
  • Check the parcel is physically back. A Returned status is not the same as stock on your shelf.
  • Match return charges to the statement, since some couriers may deduct them from other payouts. Check with your courier account manager.
  • Agree in advance how many reattempts you accept, and how a failed parcel is logged, because that decides whether you can restock it.
  • Tag repeat refusers factually, as covered in the COD confirmation guide.

Where automation helps, and where it does not

Reconciliation is repetitive and rule-based, which suits automation: syncing courier statuses to orders, auto-tagging (delivered-awaiting-remittance, returned, disputed), matching statement files by tracking number and flagging mismatches, marking orders paid once your rule is met, and alerting when a delivered parcel passes its expected payout date.

It does not fix a courier with no statement export, inconsistent tracking numbers, or a team that disagrees on what “paid” means. Settle the rules first. Our Shopify courier tracking automation service and WooCommerce Pakistan courier integration pages describe what we build.

Frequently Asked Questions

How long does courier COD remittance take in Pakistan?

It depends on the courier and your agreement, and I could not confirm a published schedule for PostEx, TCS, Leopards, Trax or M&P. Check with your courier account manager and write the answer into your routine.

How do I reconcile COD on Shopify?

Filter unpaid COD orders, match them to courier statements by tracking number, and mark orders paid on the order details page once the money reaches you. Details are on Shopify’s manual payments page.

How do I reconcile COD on WooCommerce?

COD orders start as Processing, and WooCommerce’s guidance is to confirm payment was collected before marking Complete. Keep a separate note or status for delivered orders still waiting for remittance.

What should I do when a courier payment is missing?

Check the delivery date against the agreed payout timing, then send one written query per courier listing tracking numbers, order totals and delivery dates. Keep the reply on the row.

Conclusion

COD reconciliation comes down to one key (the tracking number), one sheet, six order states and a weekly habit. Agree with each courier when and how they pay, and get statement exports; then compare order total, COD amount booked and amount collected, and chase exceptions in writing. Once the manual routine works, automate status sync, tagging and matching. If you want help building that, see our Shopify courier tracking automation and WooCommerce Pakistan courier integration services, and read the earlier guide on COD order confirmation on Shopify to cut refusals before they reach this stage.

Stock photography provided by Pexels under the Pexels License.

Want your online store to sell more?

We can review your store and show you what to fix first to turn more visitors into buyers.

Comments

  1. Loading comments...

Leave a comment

Selling online?

Turn more visitors into orders

A faster, clearer store with better product pages and checkout. We handle Shopify and WooCommerce from setup to growth.

Step 1 of 3

Tell us what you need

Three quick steps. We reply within one business day.

What do you need help with? Pick all that apply