Monthly Flipkart Payment Reconciliation
Budget: ₹600 – ₹1,500 INR
Every month I download Flipkart’s settlement and payment reports for my domestic storefront and need them turned into a clean, decision-ready reconciliation file. Your job is to match every order ID to the amounts actually credited by Flipkart and then roll those figures up, SKU by SKU, so I can see gross payments, platform fees, returns, and the final gross profit (GP) per item.
I already have full access to the detailed transaction CSVs, so you will receive raw data straight from the Flipkart dashboard along with my current product master sheet. From there, I expect:
• A consolidated workbook (Excel or Google Sheets) that cross-checks each order ID against the settlement lines and flags any short-pays or missing entries.
• A pivot or summary sheet that aggregates by SKU ID and clearly shows GP value after all Flipkart charges.
• Brief monthly commentary highlighting discrepancies and suggested follow-ups with the marketplace team.
Accuracy, tidy formulas (VLOOKUP/XLOOKUP, PivotTables, Power Query—use what suits you best), and consistent formatting matter more to me than flashy dashboards. If the figures balance and any variances are clearly explained, the file is accepted and the next cycle begins.
Let me know your typical turnaround time once the source files are shared, and any questions you have about the Flipkart report structure.
I already have full access to the detailed transaction CSVs, so you will receive raw data straight from the Flipkart dashboard along with my current product master sheet. From there, I expect:
• A consolidated workbook (Excel or Google Sheets) that cross-checks each order ID against the settlement lines and flags any short-pays or missing entries.
• A pivot or summary sheet that aggregates by SKU ID and clearly shows GP value after all Flipkart charges.
• Brief monthly commentary highlighting discrepancies and suggested follow-ups with the marketplace team.
Accuracy, tidy formulas (VLOOKUP/XLOOKUP, PivotTables, Power Query—use what suits you best), and consistent formatting matter more to me than flashy dashboards. If the figures balance and any variances are clearly explained, the file is accepted and the next cycle begins.
Let me know your typical turnaround time once the source files are shared, and any questions you have about the Flipkart report structure.