COD SETTLEMENT REVIEW BringPak | https://www.bringpak.com/resources/cod-settlement-example Updated 20 October 2026 Planning worksheet. Not a courier statement, rate card or tax calculation. Use synthetic records when sharing a project brief. Business workflow and reviewer: Statement period and provider: Evidence reference (keep private documents in your own approved storage): RECORD ONE SHIPMENT Order reference: Shipment/tracking reference: Statement/batch reference: Parcel state and delivery/return evidence: Confirmed COD collected (PKR): Agreed deductions, itemised (PKR): Amount allocated from provider remittance (PKR): Bank/wallet receipt reference: Missing or disputed information: For a delivered order with confirmed amounts: Expected remittance = collected COD - agreed deductions. Difference = allocated remittance - expected remittance. Investigate a difference; it does not automatically establish liability. Missing information is not zero. Do not calculate a resolved balance until required amounts and allocations are confirmed. REVIEW EXCEPTIONS Returned parcel: review return charges and returned stock separately. In transit: do not treat the order value as delivered-sale cash received. Duplicate statement: do not allocate the same payment twice. Split shipment: define the parcel-to-order and payment allocation rules. Batch adjustment: reconcile the source statement total and evidence first. Correction, reason and evidence: Responsible staff member: Next action and date: Reviewer approval: SYSTEM SCOPE Supported data source or import format: Staff permissions and correction history: Import frequency and unavailable-provider procedure: Duplicate and batch reconciliation checks: Account ownership, exports and handover: This worksheet does not upload data, book a courier or send an enquiry.