
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:
- Order total in your store (what the customer owed).
- COD amount you sent to the courier when booking (what the rider was told to collect).
- 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:
| Column | Source | Why you need it |
|---|---|---|
| Order number | Store | Primary key |
| Order date | Store | Ageing |
| Customer phone (last 4 digits) | Store | Quick disputes without exposing full data |
| Order total | Store | Expected amount |
| COD amount booked | Courier booking | Catches amount mismatches |
| Courier name | Store or booking | Different couriers, different cycles |
| Tracking / CN number | Courier | Matching key to statements |
| Booking date | Courier | Ageing |
| Courier status | Courier | Delivered, returned, failed, in transit |
| Delivery date | Courier | Starts the payout clock |
| Amount collected | Courier statement | What the rider took |
| Fees and deductions | Courier statement | Delivery, return, other |
| Net payable | Courier statement | What you expect in the bank |
| Statement or batch reference | Courier statement | Links rows to one payout |
| Bank credit date and amount | Bank | Closes the loop |
| Store payment status | Store | Paid or pending |
| Notes / dispute status | You | History |
If your courier statement uses different headings, map them once and keep the mapping written down.
Order states and what to do for each
| State | What it means | What to do |
|---|---|---|
| Delivered, paid out | Courier shows delivered and the amount appears in a statement and your bank | Mark paid in the store, close the row |
| Delivered, not yet paid out | Courier shows delivered, no statement line yet | Check against the payout timing your courier gave you; chase only after that date has passed |
| Returned | Parcel came back to you | Restock after inspection, tag the order, confirm no cash was expected, record the return charge |
| Failed | Delivery 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 transit | Booked and moving | Do nothing, but flag anything older than your normal delivery window |
| Disputed | Amount or status differs between store and courier | Gather 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.
- 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.
- 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.
- Match by tracking number. Not by amount, and not by customer name. Tracking number or order reference is the only reliable key.
- Assign each row one of the six states from the table above.
- Check amounts. For each delivered row, compare order total, COD amount booked and amount collected. Highlight differences.
- 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.
- 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.
- 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.
- 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.
