Complete Settlement & Reconciliation Suite

1
Upload Raw Marketplace Reports
➔
2
Compile Standard Master Payout File
➔
3
Reconcile vs NetSuite Col D (Net Zero)
📦
Step 1 • Ingest & Standardize

Marketplace Data Consolidator

  • ✓ Batch process entire folders of multi-currency files
  • ✓ Auto-detects Order ID, Principal, Refunds & Fees
  • ✓ Custom visual column mapping with editable config.json
  • ✓ Exports clean master file ready for NetSuite reconciliation
⚡
Step 2 • Audit & Reconcile

Settlement Reconciler

  • ✓ Marketplace-Driven baseline: only audits active batch orders
  • ✓ Reads NetSuite Column D: Amount (Foreign Currency)
  • ✓ Multi-refund & partial returns summing (Principal - Refunds = Net)
  • ✓ Interactive Marketplace Pivot & one-click Excel tab exports