Expondo Financial Settlement By Shirish

📦

Sheet 1: Compiled Marketplace Data (Upload 1st - Master)

Drop settlement file here (.csv or .xlsx) • Cols: Marketplace, Order_ID (E), Amount (G)

No file selected

📑

Sheet 2: NetSuite Data (Col D Foreign Currency)

Drop NetSuite export here (.csv or .xlsx) • External Ref (Q) & Amount FC (D)

No file selected

Marketplace Orders (Baseline)

Uploaded settlement orders

1. Reconciled (Net Zero)

Matched perfectly to NetSuite

Partial Returns Reconciled

Net balanced after refunds

2. Amount Mismatches

Variance != 0.00 in NetSuite

3. Not in NetSuite

Pending NetSuite sync

📊 Marketplace Pivot Summary (Portals Ranked by Discrepancy Risk)

Portals with the largest gap appear at the top

Rank	Marketplace	Total Orders	Mapped in NetSuite	Reconciled (Net Zero)	Full Orders	Partial Returns	Auto-Cancelled	Mismatches	Mismatch Variance	Not in NetSuite	Not in NetSuite Amt	Total Gap Risk

Showing all transactions

Order ID	Marketplace	Sub-Marketplace	NetSuite Channel	Order Principal (+)	Total Refunds (-)	Refund Count	Net Marketplace Balance	NetSuite Amount FC (Col D)	Net Variance	Reconciliation Status

Order ID	Marketplace	Sub-Marketplace	NetSuite Channel	Order Principal (+)	Total Refunds (-)	Refund Count	Net Marketplace Balance	NetSuite Amount FC (Col D)	Net Balance	Reconciliation Status

Order ID	Marketplace	Sub-Marketplace	NetSuite Channel	Order Principal (+)	Total Refunds (-)	Refund Count	Net Marketplace Balance	NetSuite Amount FC (Col D)	Net Variance (Discrepancy)	Status

Order ID	Marketplace	Sub-Marketplace	Order Principal (+)	Total Refunds (-)	Net Marketplace Amount	Rows	Sync Status

⚡ Settlement Reconciler By Shirish