Why your dashboard and your bank account disagree
It is the most common question a growing Pakistani store asks, and it usually has four answers at once. They stack, which is why the gap feels inexplicably large.
1. Refused orders are counted as revenue
Shopify books an order when it is placed. Under COD a meaningful share of those orders are refused at the door and come back. Your dashboard has already counted them; your bank never will. This alone is usually the largest single component of the gap.
2. You paid freight on the parcels that came back
Refused parcels are not merely absent revenue — they are a cost. Forward freight, return freight and packaging were all spent. The dashboard shows none of it, and the courier invoice that does show it arrives weeks later with no link back to the orders that caused it.
3. The money exists but the courier still has it
Delivered COD is collected from the customer, then held by the courier until the remittance cycle pays it out. A store growing quickly always has a large balance in this state, and it grows with the store — so the faster you grow, the bigger the apparent hole.
This is not a loss. It is a timing difference, and it is worth measuring as one: how much is delivered but unsettled, and how old is it. A parcel delivered forty days ago that has still not been paid for is not a timing difference any more — it is something to chase.
4. Four per cent was withheld before you saw it
Delivered COD carries 2% income tax and 2% sales tax withholding, deducted by the courier. There is no invoice for it and nothing prompts you to record it. It is simply an amount that did not arrive, which is exactly why it never makes it into the spreadsheet.
How to tell which one is yours
- Compare delivered orders to placed orders for the month. If a large share never delivered, gap 1 and 2 dominate, and the fix is operational — confirmation before dispatch, working the NDR queue.
- Add up delivered-but-unsettled COD. If that number is close to the gap, nothing is wrong: it is timing, and you need a cash-flow view rather than a profit fix.
- Multiply delivered COD by 4%. If your figures never subtracted it, that is a known, quantifiable slice of the difference.
- Check the courier invoice against the parcels. If the invoice is bigger than the parcels justify, you are being billed for things you did not ship — which is a claim, not a mystery.
Whatever is left after those four is usually cash spending nobody recorded, which is the one thing no software can see for you — only a reconciliation against the real balance can price it.
See it on your own orders — install free