Match every cash-on-delivery parcel to the cash the rider collected and deposited, so shortages show up the same day.
Download the template
Free, no sign-up. Opens in Excel, Google Sheets, LibreOffice and Numbers, with the formulas already working.
What’s in the template
11 columns, a row of example entries you can overwrite, and a TOTAL row at the bottom. Columns marked “formula” are calculated for you — don’t type over them.
Column
What to enter
Date
—
Rider
—
Consignment No
The tracking or CN number printed on the parcel.
Customer
—
Area
—
COD Amount
The amount the customer should pay on delivery.
Status
Delivered, returned, rescheduled or lost.
Cash Collected
What the rider says they collected — 0 for returns.
Cash Deposited
What actually reached your office or bank.
Differenceformula
Formula: Cash Collected − Cash Deposited. Anything above 0 is cash still with the rider.
Remarks
Reason for returns or shortages.
How to reconcile cash on delivery each day
At the end of every shift, add one row per COD parcel the rider carried. Enter the COD amount from your booking, the delivery status, the cash the rider reports and the cash they hand over or deposit. The Difference column shows any gap immediately, and the TOTAL row tells you how much COD went out, how much came back as cash and how much is still outstanding.
Filter by Rider to settle each rider separately, and by Status to see returned parcels that must go back to the seller. Settling daily — not weekly — is the simplest way to keep cash shortages small and disputes easy to trace.
Check COD against what you owe sellers
If you deliver for online sellers, the cash you collect belongs to them minus your delivery charge. Keep this sheet as the record behind every seller payment: total the delivered COD for a seller and period, deduct your charges and returns, and pay out the rest. Our COD profit calculator shows whether your delivery charge still makes money once returns are counted.
Signs you have outgrown the sheet
When you have many riders, hundreds of parcels a day, or sellers asking for live status and payment statements, a shared spreadsheet becomes slow and easy to break. Courier management software keeps consignments, riders, bikes and merchants in one system, so you are not rebuilding the day from a spreadsheet every evening.
It is matching the cash-on-delivery amounts of the parcels delivered with the cash actually collected and deposited by each rider, so every rupee or dirham is accounted for and shortages are found the same day.
How do I handle partial deliveries or discounts?+
Enter the cash actually collected and explain the difference in Remarks, for example “customer paid 2,000 of 2,500 — seller approved discount”. Keep the original COD amount so the seller can see the change.
Does it work in Excel and Google Sheets?+
Yes. The file is a standard CSV with formulas, so it opens in Microsoft Excel, Google Sheets, LibreOffice and Numbers. In Google Sheets you can also use “Copy for Google Sheets”, click cell A1 and paste. Save it as .xlsx or keep it in Google Drive so your formatting and new rows are kept.
Is the template free?+
Yes — free to download, change and use in your business, with no sign-up. The file is created in your browser, so nothing you type is sent to us.