sawwiapp
Start free

Cash on delivery (COD) reconciliation

Make sure every COD order the courier delivered was remitted to you, in full and on time, and that their freight invoice only charges for shipments you sent, at your rates.

Start free

Upload the courier's reports

You need your orders (from Shopify, Magento, WooCommerce or your ERP), the courier's shipment status report and its COD remittance statement, for example from Aramex, SMSA or iMile. For freight, add the courier's invoice detail and your contract rate sheet.

Shopify and Magento 2 orders, and Magento 2 shipments, can come from their connectors. Sawwi reads CSV, Excel and PDF files. It maps the columns for you, asks a one-click question when something is ambiguous, and remembers the layout, so next month's export asks nothing.

3 Cash on delivery reconciliations

Matching is done by Sawwi's own rules engine on keys, amounts and dates, never by AI, so the same files always give the same report.

COD delivered vs. courier remittance

Make sure every cash-on-delivery order the courier delivered was remitted to you, in full and on time.

Files you need

  • Webstore order export: Orders exported from your store admin for the period.For example: Shopify orders CSV, Magento 1 order grid export, Magento 2 / Adobe Commerce order export, WooCommerce orders.
  • Courier delivery status report: Shipment-level delivery status from your courier.For example: Aramex shipment report, SMSA delivery report, iMile status export.
  • COD remittance statement: What the courier paid you, with deductions.For example: Aramex COD remittance, SMSA COD statement.

The Shopify connector can fill: Webstore order export. The Magento 2 / Adobe Commerce connector can fill: Webstore order export.

What Sawwi checks

  • Delivered, not remitted: Courier shows delivered but no remittance after the agreed cycle.
  • Collected short: Courier collected less than the COD amount.
  • Status conflict: Order is RTO or cancelled in your store, but the courier marked it delivered.

Listed for you to review (not calculated automatically yet): cod fee above contract.

Courier freight invoice vs. shipments

Check courier invoices against your shipments and contracted rates: weight disputes, zone errors, duplicate AWBs.

Files you need

  • Shipment manifest: Shipments you booked, with declared weights and destinations.For example: Courier booking export, Shipping app (e.g. ShipStation) export.
  • Courier freight invoice: Line-level invoice from the courier.For example: Aramex invoice detail, SMSA billing detail, DHL invoice CSV.
  • Courier rate card: Contracted rate by zone and weight slab.For example: Courier contract rate sheet.

The Magento 2 / Adobe Commerce connector can fill: Shipment manifest.

What Sawwi checks

  • Charged weight above declared: Billed at a higher weight slab than you declared.
  • Duplicate AWB billed: The same AWB is billed more than once.
  • Billed AWB not in manifest: Invoice line for a shipment you didn't book.

Listed for you to review (not calculated automatically yet): rate above contract.

Bank statement vs. expected payouts

Match every payout you expect from marketplaces, gateways, BNPL providers and couriers to actual bank credits, including FX differences.

Files you need

  • Expected payouts: Payout batches from one or more providers (marketplace, gateway, BNPL, courier).For example: Marketplace disbursement summary, Gateway payouts list, Courier remittance summary.
  • Bank statement: Bank statement for the account that receives payouts.For example: Emirates NBD / ADCB / Al Rajhi / SNB statement (CSV or Excel), MT940 converted to CSV.

What Sawwi checks

  • Payout not credited: Provider says paid, but the bank shows no credit.
  • Unidentified bank credit: Bank credit not linked to any payout.
  • FX / bank charge difference: The amount differs because of currency conversion or bank charges.

How it works

  1. 1

    Pick the reconciliation

    Each one knows which files it needs and what to check.

  2. 2

    Add the files

    Upload exports as they are, or pull them from a connection. Columns are mapped for you and remembered.

  3. 3

    Work the exceptions

    Every exception with its value, ranked by what it costs you, and every table downloads to Excel.

Questions

What does the COD reconciliation catch?
Orders the courier delivered but hasn't remitted after the agreed cycle, cash collected short of the COD amount, and orders returned or cancelled in your store that the courier marked as delivered. COD fees above your contract are listed for review.
Which couriers?
Any courier whose reports you can download. Sawwi maps the columns, so Aramex, SMSA, iMile and local couriers all work the same way.
Can it check courier invoices?
Yes. The freight reconciliation checks the courier's invoice against your shipments: charges for unknown or duplicate airway bills and weight differences. Comparing each charge to your contracted rate is listed for review, not calculated yet.

Related reconciliations

Bring last month's exports and see what's missing.

Setup takes two minutes. Or try the demo store with invented data first, no sign-up.

Create your workspace