Skip to content
MyToolers

Courier COD Reconciliation Sheet Template

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.

ColumnWhat to enter
Date—
Rider—
Consignment NoThe tracking or CN number printed on the parcel.
Customer—
Area—
COD AmountThe amount the customer should pay on delivery.
StatusDelivered, returned, rescheduled or lost.
Cash CollectedWhat the rider says they collected — 0 for returns.
Cash DepositedWhat actually reached your office or bank.
DifferenceformulaFormula: Cash Collected − Cash Deposited. Anything above 0 is cash still with the rider.
RemarksReason 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.

Related guides

Ready to replace the spreadsheet?

OneFlow courier software keeps riders, bikes, consignments, a dispatch board, zones and merchants in one system, with staff and invoices alongside.

Frequently asked questions

What is COD reconciliation?

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.