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

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.

Key thing to know: Delhivery issues remittances in batches, not per-order. Your remittance report will show a single transfer that covers dozens of orders delivered in a window. The line-item detail is inside the CSV export, not the bank transfer.

Common reasons remittances come in lower than expected:

How to download your Delhivery remittance report

1

Log into the Delhivery merchant portal

Go to business.delhivery.com and sign in with your merchant credentials.

2

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.

3

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.

Watch out: The "amount remitted" column in Delhivery's report shows what they claim to have sent, not what you received. You should cross-check it against your bank statement for the same period to catch any discrepancy at the transfer level too.

How to export your Shopify COD orders

You need your Shopify order data for the same period as your Delhivery remittance report.

1

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.

2

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.

3

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.

  1. 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).
  2. Use VLOOKUP or INDEX-MATCH to pull Delhivery's "amount remitted" against each AWB in your Shopify export.
  3. Add a "shortfall" column using Shopify order value - Delhivery remitted amount. Any positive value is money you're owed.
  4. 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).
  5. 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.
Realistic time estimate: For a brand processing 200–500 COD orders per week, this manual process takes 3–5 hours per reconciliation cycle, and errors are easy to miss at volume. Most finance teams do it fortnightly at best, which means weeks of leakage go undetected.

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:

  1. Log into the merchant portal and go to Support → Raise Ticket.
  2. Select "COD Remittance Issue" as the ticket type.
  3. Attach your reconciliation sheet showing the AWB numbers, expected amounts, and actual remittances. The more specific your data, the faster Delhivery resolves it.
  4. 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.
Tip: Disputes filed with a clean, well-labelled spreadsheet get resolved faster than vague complaints. Include columns: AWB, order ID, expected COD, remitted COD, shortfall, delivery date, and your dispute reason in one line.

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.

Try it free →

Frequently asked questions

How long does Delhivery take to remit COD payments?
Delhivery remits COD within 48 hours of delivery confirmation on their standard plan, assuming your wallet balance is positive and your bank details are verified. Delays happen when your wallet goes negative, as Delhivery deducts outstanding dues before transferring funds.
Why is my Delhivery remittance less than expected?
Delhivery deducts COD handling fees, reverse logistics charges, and any negative wallet balance before remitting. If the shortfall is larger than these deductions, it may be a billing error or an order that was marked delivered but never remitted. Both are disputable.
How do I match Delhivery remittances to Shopify orders?
Export your Shopify orders filtered by COD and the same date range as your Delhivery remittance report. Match rows by AWB number: the tracking number on the Delhivery report should correspond to a fulfilled order in Shopify. Any AWB in Delhivery's delivered list with no matching remittance is a missing payment.
What is RTO fraud and how do I detect it in Delhivery reports?
RTO fraud happens when Delhivery marks an order as returned without attempting delivery, collects the COD amount, and does not remit it. You can detect it by filtering for orders with RTO status and cross-referencing whether a COD amount was collected. Orders where Delhivery collected cash but shows RTO are strong fraud indicators.
Does PayTrace work with couriers other than Delhivery?
Yes. PayTrace reconciles COD remittances from Delhivery, Shiprocket, XpressBees, Ecom Express, and other major Indian courier partners. You can run multi-courier reconciliation in a single audit.