How to reconcile cash on delivery
COD looks simple and reconciles badly. The order, the delivery, the collection and the remittance are four separate events, and only the last one touches your bank.
Why it drifts
When a customer pays cash at the door, the courier holds your money. It reaches you on the courier's remittance cycle, net of the shipping charge and usually a handling fee, aggregated across many deliveries.
Meanwhile the order sits in your store marked as placed, and the invoice sits in your books marked as unpaid. Neither knows whether the parcel was delivered, refused, or is still in a warehouse.
Refused and returned orders are the real leak. They never become cash, but unless somebody reconciles deliveries against remittances, they stay on the books as receivable revenue that will never be collected.
A monthly process that works
- 1
Get the delivery report, not just the remittance
The remittance says what you were paid. Only the delivery report says what was collected, and the difference between them is what you are looking for.
- 2
Match remittances to delivery dates, not order dates
An order placed in March and delivered in April is April's cash. Matching on order date guarantees a permanent mismatch.
- 3
Book shipping and COD fees separately
They are different expenses and may be taxed differently. One combined deduction cannot be verified later.
- 4
Write off what was never delivered
Returned and refused orders should leave receivables in the month you find out, not at year end.
Questions
- How often should COD be reconciled?
- Monthly. Quarterly is survivable. Annually means finding a year of uncollected orders at once, with no way to chase any of them.
- What if the courier's report and ours disagree?
- Reconcile at the order level and the disagreement resolves to specific parcels you can query. Reconciling on totals only tells you that you disagree.
See it against your own month
Send one month of payout files and a bank statement. We reconcile it and show you what did not tie out, before you decide anything.
Related
Last reviewed 2026-09-19