Role Objective
The Ecommerce Order Reconciliation Executive will be responsible for daily reconciliation of orders, payments, returns, refunds, and settlements received from various e-commerce platforms such as Amazon, Flipkart, Shopify, and other sales channels.
Key Responsibilities
- Reconcile daily orders received from Amazon, Flipkart, Shopify, and other e-commerce portals.
- Track payments, settlements, commissions, deductions, refunds, and return charges.
- Match orders with payment reports and platform settlement reports.
- Identify payment gaps, short payments, excess deductions, and pending settlements.
- Coordinate with Amazon and Flipkart teams to resolve cases related to short payments or payment discrepancies.
- Maintain daily reconciliation reports in Excel/Google Sheets.
- Coordinate with the accounts team for payment verification and closure.
- Coordinate with the warehouse/e-commerce team for order, return, and cancellation data.
- Track COD, prepaid, cancelled, returned, and delivered orders.
- Prepare weekly and monthly reconciliation summaries.
- Escalate discrepancies to the concerned platform/team for resolution.
Required Skills
- Good knowledge of MS Excel/Google Sheets.
- Good understanding of e-commerce order flow.
- Strong attention to detail.
- Ability to handle large data accurately.
- Basic knowledge of Amazon, Flipkart, and Shopify reports will be preferred.
- Coordination and reporting skills.
