📊 Build Automated Profit & Return Reconciliation Dashboard for Myntra

We run an online women’s garment business, selling primarily on Myntra, integrated via Unicommerce. We receive daily sales and return settlements from Myntra in CSV/Excel formats — including “Payment Forward Settled” and “Payment Reverse Settled” reports. Due to high return ratios, it becomes difficult to track the actual profit/loss per order — especially when products are returned multiple times before being sold successfully. We need an automated Excel/Power Query dashboard (or Google Sheets equivalent) that can consolidate all settlement data and calculate the real-time profitability per order, SKU, and style code. ⸻ Core Requirements: 1. Master Reconciliation Dashboard • Consolidate data from: • Payment Forward Settled reports (sales) • Payment Reverse Settled reports (returns/reversals) • Listing Report (mapping Myntra SKU → our internal SKU) • SKU Master (SKU → cost price) • Automatically match and merge data on Order ID / SKU level. • Calculate final net settlement, total fees, and actual profit or loss per order. 2. Data Handling • Handle 100+ orders and 50+ returns daily (~3000+ monthly). • Must support ongoing updates (returns often happen weeks after sale). • Design should allow easy addition of new monthly reports — system should automatically refresh and consolidate new data. 3. Power Query / Automation • Preferably built in Excel using Power Query (so new reports auto-append from a folder). • Alternatively, Google Sheets + App Script / Coupler.io / Sheetgo setup is acceptable. • Clean, well-structured data flow (Forward + Reverse + Listing + Cost Price). 4. SKU Mapping • In Myntra reports, products are listed under Myntra SKU codes. • There’s a Listing Report that maps Myntra SKU → Our SKU. • The freelancer must ensure the dashboard displays our SKU and product name, not Myntra’s code. 5. Profit Calculation Logic • Sale Price – Cost Price – Marketplace Fees – Return Charges = Net Profit. • Automatically identify and flag loss-making orders. • Handle multiple sale-return cycles of the same order correctly. 6. Dashboard / Reports • Interactive summary showing: • Profit/Loss per SKU, per month • Total returns and return % per style • Top-performing products • Orders with negative profit • Optional: Filter by date range, SKU, or category. ⸻ Add-ons (Optional, if freelancer can handle): • Link the system directly with Unicommerce via API or data exports. • Add auto-email alerts for negative profit SKUs. • Create a Power BI or Google Data Studio dashboard for visual reporting. • Add a “Pending Return / Open Order” tracker for orders still within return window. • Automate upload of new reports via Google Drive folder or OneDrive sync. • Include monthly summary report generation (auto PDF or Excel export). ⸻ ⸻ Skills Required: • Advanced Excel & Power Query • Data modeling / ETL automation • Experience with e-commerce reconciliation (Myntra, Flipkart, Amazon, etc.) • Strong understanding of returns and settlement logic • Optional: Google Sheets automation or Power BI dashboarding About Us: We are a women’s garment manufacturing and e-commerce company selling across Myntra and other platforms. We’re looking for someone who understands marketplace operations, settlement reports, and can build a smart, scalable reporting system to save us manual effort and ensure accurate profitability tracking. ⸻ What to Include in Your Proposal: 1. Brief on similar reconciliation dashboards you’ve built before. 2. Your preferred platform (Excel Power Query / Google Sheets / Power BI). 3. Estimated timeline and cost. 4. Any suggestions for improving our tracking process.