A COD order can be delivered, collected and still awaiting remittance to the seller. If those states are collapsed into “paid,” the business may overestimate the cash available for suppliers, refunds or new stock.
Reconciliation connects the order, shipment, carrier statement and actual receipt. It is a record-matching process, not simply a check that the dashboard's sales total looks plausible.
Keep four states separate
Record the order amount, delivery outcome, collection status and remittance status. Each describes a different event.
A delivered scan does not necessarily provide the complete collection record. A carrier statement showing a scheduled payout is not the same as a bank receipt.
Use the provider's actual references and terminology, but translate them into a clear internal status staff can understand.
Establish the expected collection
Start from the accepted order total and any agreed advance payment or adjustment. Confirm the amount sent to the carrier for collection.
Do not reconstruct the amount from the current product price if the order was accepted under an earlier offer.
Keep partial cancellations or other changes traceable. A later catalogue edit should not rewrite the original payment agreement.
Match the carrier statement
Use shipment or remittance references to connect collected amounts and deductions. Avoid matching only by date or a rounded total when several orders are involved.
Review the provider's current statement structure and charges. A net payout can combine multiple collections and fees.
Keep the raw statement in the appropriate restricted location and use a working reconciliation record that contains only the details needed for the task.
Verify the money received
Match the payout reference and amount to the business's actual receiving account record through the authorised process.
Do not rely on a screenshot sent by an unknown contact or a message claiming that a settlement has been completed.
Never share authentication codes, banking passwords or UPI PINs to receive or reconcile a remittance. Use the provider's official support route for discrepancies.
Work through a simple example
Suppose two COD shipments collected ₹1,000 and ₹1,500. The gross collection is ₹2,500.
If the statement shows ₹120 in applicable deductions and the bank receipt is ₹2,380, the arithmetic matches: ₹2,500 minus ₹120 equals ₹2,380. You still need to verify that the deductions are valid for those shipments.
This is an illustrative reconciliation, not a statement of any provider's rates or accounting treatment.
Put differences in an exception queue
Record missing collections, unexpected deductions, unmatched payouts and overdue remittances separately. Give each an owner, evidence and next check.
Do not force the spreadsheet to balance by entering an unexplained adjustment. That hides the problem rather than resolving it.
Raise a precise support case with the relevant references and amounts. Avoid sending a full customer database when a small set of shipment details is sufficient.
Reconcile returns and reversals
A returned parcel may involve delivery charges, return charges or collection corrections depending on the service. Follow the provider's actual records.
Keep physical stock recovery separate from the financial entry. The product must be received and inspected before it is available to sell again.
Where customer refunds or other remedies are involved, handle them through the appropriate order and payment process rather than offsetting them informally against unrelated COD receipts.
Review cash availability conservatively
Use settled receipts, known obligations and the business's accounting approach when planning spending. Do not treat every open COD order as money already available.
A healthy order book can still create a short-term cash constraint while remittances are pending.
Review the exception queue regularly and compare actual settlement behaviour with the service's stated process. The objective is not merely a balanced total; it is a traceable explanation of which orders generated money, which charges applied and which amounts remain unresolved.
For pricing decisions, connect this work with the margin guide. Sales, contribution and cash are related, but keeping them distinct makes both operational decisions and financial conversations more reliable.
Examples are illustrative. Confirm current features, charges and suitability before making a business decision.
Explore this topic → · Find an oBizee setup guide · Ask about your store