Marketplace Data Consolidator
Ingest and consolidate raw settlement files and folders from Amazon, Flipkart, Myntra, Ebay, Allegro, Galaxus, etc. Automatically map dynamic column aliases into a single uniform master dataset.
- ✓ 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
Settlement Reconciler
Reconcile compiled marketplace payout batches against your NetSuite general ledger. Accurately verifies that balances sum to 0.00 Net, accounts for multi-refund orders, and flags portal gap priorities.
- ✓ 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