If your D2C brand ships COD orders through Delhivery, you've probably wondered at some point whether you're actually getting paid everything you're owed. The answer, for most brands, is no. Not all of it.
Short remittances, missing payments, and RTO anomalies are common. Delhivery handles millions of COD shipments a month, and billing errors happen. The problem is they go undetected unless you're actively reconciling your remittance data against your Shopify orders.
This guide walks you through exactly how to do that: manually, and then automatically.
- How Delhivery COD remittance works
- How to download your Delhivery remittance report
- How to export your Shopify COD orders
- Manual reconciliation: step by step
- What to look for: short payments, missing remittances, RTO fraud
- How to raise a dispute with Delhivery
- How to automate this in 30 seconds
- Frequently asked questions
How Delhivery COD remittance works
When a customer pays cash on delivery, Delhivery collects the money from them and holds it. They then remit it back to your registered bank account after a processing cycle.
On Delhivery's standard plan, this happens within 48 hours of delivery confirmation, assuming your wallet balance is positive. If your wallet is negative (because of outstanding shipping charges), Delhivery offsets the COD amount against your dues first and sends you the net amount, or nothing if dues exceed the remittance.
Common reasons remittances come in lower than expected:
- COD handling fees deducted at source (typically 1–1.5% of order value)
- Reverse logistics charges for returned orders deducted from COD pool
- Wallet dues offset against remittance
- Billing errors: orders marked delivered but remittance not processed
- RTO fraud: order returned but COD collected and not remitted
How to download your Delhivery remittance report
Log into the Delhivery merchant portal
Go to business.delhivery.com and sign in with your merchant credentials.
Navigate to Billing → Remittances
In the left sidebar, click Billing, then select the Remittances tab. You'll see a list of remittance transactions by date.
Select your date range and export
Set the date range to match your reconciliation period (typically the last 7 or 14 days). Click Export → Download CSV. The file will contain columns for AWB number, order ID, COD amount collected, amount remitted, and delivery status.
How to export your Shopify COD orders
You need your Shopify order data for the same period as your Delhivery remittance report.
Go to Orders in your Shopify admin
Filter by payment method, select "Cash on Delivery", and set the date range to match your Delhivery report.
Export to CSV
Click Export → Export orders. Choose "Current page" or "All matching orders." The export includes order number, total, fulfilment status, and tracking number.
Match tracking numbers to AWBs
Shopify stores the Delhivery AWB as the tracking number on the fulfilment. This is the key field you'll use to join the two datasets.
Manual reconciliation: step by step
Once you have both CSVs, open them in Google Sheets or Excel.
- Standardise the AWB column in both files: strip any leading/trailing spaces, make sure both are formatted as text (not number, which strips leading zeros).
- Use VLOOKUP or INDEX-MATCH to pull Delhivery's "amount remitted" against each AWB in your Shopify export.
- Add a "shortfall" column using
Shopify order value - Delhivery remitted amount. Any positive value is money you're owed. - Flag unmatched rows: AWBs in the Delhivery report that don't appear in Shopify (possible duplicate or test orders) and AWBs in Shopify marked "delivered" but absent from the remittance report entirely (missing remittances).
- Separate RTO rows: filter Delhivery's status column for "RTO" and check if any of those rows show a COD amount collected. COD collected + RTO status = dispute immediately.
What to look for: short payments, missing remittances, RTO fraud
Here's what each issue looks like in your data and what it means:
| Issue | What you see in the data | Severity |
|---|---|---|
| Short payment | Remitted amount is less than order COD value, after deducting valid fees | Medium |
| Missing remittance | Order marked "Delivered" in Delhivery portal, no entry in remittance report | High |
| RTO fraud | Status = RTO, but COD amount collected shows non-zero | Critical |
| Overdue remittance | Delivered 5+ days ago, no remittance received, wallet is positive | Medium |
| Reconciled | Remitted amount matches order value minus valid fee deductions | Clear |
D2C brands doing this analysis for the first time typically find that 2–8% of their monthly COD revenue is either missing or short-paid. On ₹20L/month in COD orders, that's ₹40,000–₹1,60,000 quietly leaving every month.
How to raise a dispute with Delhivery
Once you've identified discrepancies, you need to raise a formal dispute. Delhivery has a structured dispute process:
- Log into the merchant portal and go to Support → Raise Ticket.
- Select "COD Remittance Issue" as the ticket type.
- Attach your reconciliation sheet showing the AWB numbers, expected amounts, and actual remittances. The more specific your data, the faster Delhivery resolves it.
- Delhivery typically resolves remittance disputes within 5–7 business days. If your ticket is closed without resolution, escalate via your dedicated account manager or the Delhivery grievance email.
How to automate this in 30 seconds
The manual process above works, but it's slow, error-prone, and most teams don't do it often enough. PayTrace automates the entire reconciliation: upload your Delhivery remittance CSV and your Shopify export, and get a full audit report in under 30 seconds.
The report flags every short payment, missing remittance, overdue order, and RTO anomaly automatically. No spreadsheets, no VLOOKUP, no missed rows.
Run a free COD audit right now
Upload your Delhivery + Shopify files. Results in 30 seconds.