COD reconciliation for Pakistani stores
Upload the payment sheet your courier sends. EcoChamp records every payment on the right invoice and shows you exactly what didn’t match.
No credit card required
The problem
Sound familiar?
- Every week the courier sends a COD sheet with hundreds of rows, and someone matches it to orders by hand in Excel.
- A few parcels are always “delivered” but never paid, and nobody notices until much later.
- Courier charges are deducted from the payout, so you never quite know what each order really cost to ship.
How EcoChamp solves it
Step by step.
- 1
Upload the courier’s COD file
Import the .xlsx or .csv payment file your courier sends, for example Rocket’s invoice sheet. You see a full preview first. Nothing is saved until you confirm.
- 2
Payments land on the right invoices
Each row is matched to its order by order number or tracking number, and the amount is recorded as a payment on that order’s invoice. Fully paid invoices close by themselves.
- 3
See what didn’t match, and why
Rows that can’t be recorded (no invoice yet, already paid, order not found) are listed with the reason. Returns and rows with nothing to record are skipped, not guessed.
- 4
Courier charges saved per order
Shipping and fuel charges from the same file are saved on each order, so your profit numbers include what delivery really cost.
- 5
Every import is kept
Each import is stored in Courier settlements with the original file to download. If the courier sent the wrong sheet, an admin can void the import and its payments stop counting.
What you get
- No more matching COD sheets row by row in Excel
- Spot delivered-but-unpaid parcels the day the sheet arrives
- Payments are never recorded twice, even from a re-sent file
- A record of every payout, with the courier’s original file
FAQ
Questions about cod reconciliation
Still unsure? Ask us on WhatsApp. A real person replies.
Which courier files can I import?
Any .xlsx or .csv COD payment sheet with an order number or tracking number column and an amount column. Rocket’s invoice sheet works as it comes, including the extra tables at the bottom. Send us your courier’s file on WhatsApp and we’ll check it with you.
What happens to rows that don’t match an order?
They are not recorded. You get a list of every such row with the reason (for example no invoice for that order yet, or order not found), so you know exactly what to follow up.
What if I import the same file twice?
EcoChamp recognises a file it has already imported and warns you before recording anything. Payments already recorded for a parcel are rejected, so nothing is counted twice.
Can I undo an import?
Yes. An admin can void an import from Courier settlements. Its payments stop counting and the invoices go back to their earlier balance.
Also in EcoChamp
Courier ledger
See per courier the parcels handed over, COD delivered, received and still outstanding. A live courier ledger for Pakistani online stores.
Learn more ›Profit & loss
Profit & loss for your online store: sales, cost of goods, shipping margin and expenses, for one store or all stores combined.
Learn more ›Bulk courier booking
Book Leopards, PostEx, Rocket, M&P or Tranzo straight from your Shopify and WooCommerce orders, in bulk. Print labels and dispatch sheets.
Learn more ›