SANOCEA™
INSIGHTSREQUEST A MEETING
SNC-WF-100 · Free Tier · Finance & COD

Reconcile Cash on Delivery (COD) Courier Remittances and Hidden Fee Deductions

SNC-WF-100 · Courier COD Remittance & Fee Deduction Reconciler (Free Tier)

A free, local Python reconciliation tool that stops courier revenue leaks on Cash on Delivery orders. It compares your courier remittance payout files against delivered store orders, identifying unpaid orders, volumetric weight disputes, and unauthorized return fees so you can claim missing cash from shipping partners.

PRODUCT SUMMARY AT A GLANCESNC-WF-100
Primary OutcomeCompares courier COD remittance spreadsheets against your store orders, exposing unpaid parcels, weight overcharges, and unexpected fee deductions.
How It RunsSelf-Hosted Python 3.8+ (Runs on your own computer or server)
Setup ExpectationsFree to self-host on your own hardware. Free workflows never run on Sanocea infrastructure. Optional assisted setup: ₹500 one-time.
Verification StatusCode & Logic Tested: Tested against synthetic courier COD manifests and bank statement fixtures
The 3-Step Process in Simple English
1. Input

store_orders_delivered.csv (order ID, AWB, collectable COD amount) and courier_remittance.csv (AWB, amount paid, fee deductions).

2. Transformation

Local Python script reconciles AWBs, checks remittance amounts against store totals, and isolates fee variances.

3. Output

reconciliation_discrepancies.csv, settlement_summary.csv, and claim_dispute_sheet.csv.

Free to self-host. Want Sanocea to set it up? ₹500 one-time.

Setup scope covers installation on customer-controlled infrastructure, configuration of authorised integrations, functional testing and handover.

Hosting, third-party charges and ongoing support are excluded unless separately agreed. Free workflows must never run on Sanocea-hosted infrastructure.

Direct Download or Assisted Setup: Download the free toolkit below, or contact engineering on WhatsApp for ₹500 assisted setup on your machine.
01 · The Everyday Problem

What Goes Wrong in an Ordinary Working Day

Couriers remit Cash on Delivery collections in lump sums weeks after delivery, often deducting unauthorized weight penalties, RTO charges, or simply missing orders entirely without clear explanation.

02 · Why It Matters

The Impact on Your Business & Customers

Without automated reconciliation, up to 2-5% of your COD revenue can silently leak through courier deductions and unremitted shipments.

03 · The Solution

What This Tool Does & What Changes for You

Matches every delivered COD order against courier remittance sheets by tracking number (AWB), identifies amount variances, and outputs an itemized dispute list.

What Changes in Practice:

You hand an exact, evidenced claim spreadsheet to your courier representative, recovering unpaid COD funds and overcharged fees.

Real-World Transformation

Concrete Before & After Example (Actual Code Output)

Shows how an unremitted COD order and an excess freight fee deduction are caught.

INPUT: Store Delivered Orders vs Courier RemittanceInput File
Store:   Order #101, AWB 9012, COD Expected = ₹1,200.00
Courier: AWB 9012, Amount Remitted = ₹950.00, Deductions = ₹250.00 (Weight dispute)
OUTPUT: reconciliation_discrepancies.csvnormalized_inventory.csv
awb,order_id,expected_cod,remitted_cod,deductions,variance,dispute_reason
9012,101,1200.00,950.00,250.00,-250.00,UNAUTHORIZED_WEIGHT_SURCHARGE

Provides exact evidence to dispute the ₹250 deduction with your logistics account representative.

What Changed vs. What Remained Unchanged

✓ What Changed (Normalized):
  • Flagged ₹250 remittance variance with exact courier tracking reference
  • Generated ready-to-submit dispute claims sheet for logistics accounts
  • Reconciled total remitted cash against bank deposits
ℹ What Remained Unchanged:
  • Accurately matched clean orders archived in settlement_summary.csv
  • Zero cloud storage—runs entirely on your local computer
04 · Prerequisites

What You Need Before Getting Started

  • Courier COD remittance statement (CSV).
  • Bank account statement (CSV).
  • Python 3.8+ on your computer or server.

Technical Setup Guidance: Runs 100% locally on your machine. Financial records and banking details never leave your computer.

05 · Setup Effort

Setup Difficulty & Expected Time

Takes 5 minutes. Download the free script, place your CSV statements in the folder, and run reconciliation.

Step-by-Step Run Instructions (Zero-Code Terminal Run)

  1. Download and unzip snc-wf-100-cod-reconciler.zip.
  2. Place your store delivered orders export and courier remittance file in data/.
  3. Run: python3 cod_reconciler.py --orders data/delivered_orders.csv --remittance data/courier_remittance.csv
  4. Open claim_dispute_sheet.csv to view all unremitted amounts and overcharges.
  5. Submit the dispute sheet to your courier partner to claim missing funds.
06 · Package Contents

What You Receive in the Download Archive

Every deliverable is clean, self-contained, and ready for immediate deployment. You receive the complete files, configuration templates, setup guides, and automated tests.

File NameDeliverable Description
reconcile.pyStandalone Python 3.8+ COD remittance reconciliation script
fixtures/sample_courier_remittance.csvSample courier COD payout fixture
fixtures/sample_bank_statement.csvSample bank statement credit fixture
README.mdStep-by-step reconciliation guide and CSV format documentation
SETUP.mdQuickstart setup and command-line instructions
COSTS.mdOperating cost disclosure (₹0 ongoing fees)
LICENSING.mdSanocea Open Workflow License (MIT Compatible, free commercial self-hosting)
tests/test_cod_reconciler.pyAutomated test suite verifying deduction math and discrepancy detection
07 · Technical Details & Verification

Architecture Diagram & Tested Capabilities

For technical teams or developers assisting your business, below is the visual execution architecture and automated verification breakdown:

Reconcile Cash on Delivery (COD) Courier Remittances and Hidden Fee Deductions Architecture Pipeline Diagram
⚡Deterministic execution flow: runs on your own compute without telemetry tracking.

Verification Disclosure

Pure Python standard library script. Computes gross remittance, logistics fee deductions, and net payouts with exact decimal arithmetic and SHA-256 audit logging.

AWB & UTR Cross-Matching

Matches courier shipping manifests against bank deposits using transaction references.

Fully Tested

Deduction Arithmetic Audit

Verifies Gross COD - (Freight + COD Fee + GST) = Net Settlement Credit.

Fully Tested

Zero Cloud Data Leakage

Operates 100% offline on your local computer.

Fully Tested
08 · Operational Disclosures

Documented Limitations & Third-Party Costs

We believe in complete transparency. Review the documented technical boundaries and external service fee breakdown below prior to obtaining the package:

⚠️Documented Boundaries & Considerations

  • Offline Reconciliation Engine: Reconciles local CSV files; does not automatically file claims through courier API portals.
  • AWB Matching: Requires shipping tracking numbers (AWB) present in both files.
ComponentEstimated CostDetails & Free Tier Allowances
COD Reconciler Tool₹0 (Free to self-host)Download full source code and run locally
Optional Assisted Setup₹500 one-timeAssisted installation, CSV header alignment, and operational handover
Hosting & API Fees₹0 ForeverRuns locally with zero recurring software fees
System Compatibility

Platform Compatibility & Technical Specifications

Operating System
Linux, macOS, Windows
Runtime / Python
Python 3.8+
Supported Platforms
Shiprocket, Delhivery, NimbusPost, Custom Logistics
Required Inputs
  • Delivered store orders export (with collected amounts)
  • Courier remittance payout bank statement CSV
Generated Outputs
  • Matched orders ledger with net received cash
  • Missing remittance report for orders marked delivered but unremitted
  • Deducted shipping fee audit report
Free Self-Hosted SoftwareInstant Download · Optional ₹500 Setup

Download or Set Up SNC-WF-100

Receive the complete distributable archive containing reconcile.py, step-by-step setup guides, mock fixtures, and automated test suites.

Free to self-host. Want Sanocea to set it up? ₹500 one-time.

Setup scope covers installation on customer-controlled infrastructure, configuration of authorised integrations, functional testing and handover.

Hosting, third-party charges and ongoing support are excluded unless separately agreed. Free workflows must never run on Sanocea-hosted infrastructure.

Download Free Package (.zip)Chat on WhatsAppWe reply within 2 business days (Monday to Saturday, 9:00 AM to 9:00 PM IST)
Questions & Answers

Frequently Asked Questions

How does COD remittance mismatch occur?

Logistics providers frequently batch COD remittances across weekly payment cycles, but orders marked 'Delivered' occasionally slip through uncredited or suffer arbitrary penalty deductions.

Can I use this with any Indian courier aggregator?

Yes. It accepts any standard CSV export mapping AWB numbers, collection amounts, and payout transaction IDs.

Does it require internet connectivity to reconcile?

No. The entire reconciliation logic executes on your local machine with full data privacy.

Operational Field Guide & Research

COD Courier Remittance Reconciliation: AWB Cross-Matching, Freight Audits, and UTR Bank Ledgers

How D2C merchants track delayed Cash on Delivery payouts, why couriers deduct unauthorized freight surcharges, and how automated reconciliation isolates cash leakage.

Read Field Guide on Sanocea Insights →
Related Automations

Explore Related Self-Hosted Tools

C02Managed Service

See Where Every Order's Money Went & Recover Lost Marketplace Revenue

E-Commerce Settlement & Fee Matcher

An enterprise marketplace reconciliation engine that automatically audits bank payout sheets from Amazon, Flipkart, and Myntra against your original order records. It isolates commission overcharges, unexpected weight penalties, uncredited customer returns, and missing remittances—generating ready-to-file dispute spreadsheets that recover thousands of rupees in lost margin every month.

See Details →
SNC-WF-093Self-Hosted Python 3.8+

Catch Domestic Parcels Stuck in Transit Before RTOs and Customer Escalations

Domestic Courier Tracking Poller & Transit Delay Alerter (Free Tier)

A free, local Python logistics tracker that protects your delivery success rate. It reads your active courier tracking numbers (e.g. Delhivery, Bluedart, Shiprocket), checks latest tracking milestones, flags shipments with no status movement for over 72 hours or failed delivery attempts, and generates an intervention report so customer support can prevent return-to-origin (RTO) losses.

See Details →
SNC-WF-061Self-Hosted Python 3.8+

Get a Daily Executive Sales & Gross Margin Digest on Telegram

Daily Executive Sales & Gross Margin Digest to Telegram (Free Tier)

A free, local Python financial digest tool. It reads your previous day's store order export, calculates total revenue, prepaid vs. COD share, average order value (AOV), returns, and gross product margins, formatting the results into a crisp morning briefing sent directly to your phone via Telegram.

See Details →