Automated Courier Reconciliation

Rule-based fuzzy matcher comparing Shopify/WooCommerce orders against courier remittance sheets.

Expected Store Remittance

PKR 1,284,920

Across 1,284 orders

Actual Bank Deposits

PKR 1,237,100

96.3% realized

Unsettled Discrepancy

-PKR 47,820

12 orders disputed

Filter:

Order	Tracking / Courier	Expected	Settled	Difference	Status
MNF-10492	PEX-84920194 PostEx	PKR 3,850	PKR 3,850	PKR 0	Matched
MNF-10491	TRX-77492014 Trax	PKR 2,450	PKR 2,150	-PKR 300	Needs review
MNF-10490	TCS-90184209 TCS	PKR 4,200	PKR 4,200	PKR 0	Matched
MNF-10489	LEO-40192841 Leopards	PKR 5,100	PKR 0	-PKR 5,100	Not found
MNF-10488	PEX-84920193 PostEx	PKR 1,800	PKR 1,800	PKR 0	Matched
MNF-10487	CAL-55019241 Call Courier	PKR 2,950	PKR 2,950	PKR 0	Matched
MNF-10486	TRX-77492013 Trax	PKR 3,200	PKR 3,200	PKR 0	Duplicate
MNF-10485	PEX-84920192 PostEx	PKR 6,400	PKR 5,800	-PKR 600	Needs review

MNF-10492Matched

PostExPEX-84920194

ExpectedPKR 3,850

SettledPKR 3,850

DiffPKR 0

MNF-10491Needs review

TraxTRX-77492014

ExpectedPKR 2,450

SettledPKR 2,150

Diff-PKR 300

Courier adjusted volumetric weight from 0.5kg to 1.5kg without notification.

MNF-10490Matched

TCSTCS-90184209

ExpectedPKR 4,200

SettledPKR 4,200

DiffPKR 0

MNF-10489Not found

LeopardsLEO-40192841

ExpectedPKR 5,100

SettledPKR 0

Diff-PKR 5,100

Marked delivered in store portal but missing from courier remittance sheet.

MNF-10488Matched

PostExPEX-84920193

ExpectedPKR 1,800

SettledPKR 1,800

DiffPKR 0

MNF-10487Matched

Call CourierCAL-55019241

ExpectedPKR 2,950

SettledPKR 2,950

DiffPKR 0

MNF-10486Duplicate

TraxTRX-77492013

ExpectedPKR 3,200

SettledPKR 3,200

DiffPKR 0

Settled twice under different consignment notes; reconciliation deduplicated.

MNF-10485Needs review

PostExPEX-84920192

ExpectedPKR 6,400

SettledPKR 5,800

Diff-PKR 600

Discrepancy in COD service tax and fuel surcharge calculation.

Showing 8 of 8 recordsActive Reconciled Ledger