Reconciliation Specialist

Role & responsibilities

• Manage end-to-end e-commerce reconciliation processes across platforms like marketplaces, aggregators, payment gateways, and online sales channels.
• Perform reconciliation of orders, sales, collections, refunds, cancellations, commissions, discounts, promotions, and settlements.
• Analyze settlement reports from e-commerce platforms and identify discrepancies between sales, payments received, and accounting records.
• Track and resolve issues related to short payments, payment failures, deductions, commission charges, and settlement mismatches.
• Perform reconciliation between OMS, POS, payment gateways, marketplace reports, and ERP/accounting systems.
• Monitor marketplace receivables and ensure timely collection and closure of pending transactions.
• Prepare reconciliation MIS, ageing reports, variance analysis, and dashboards for management review.
• Coordinate with business, operations, customer support, and technology teams to resolve transaction-level issues.
• Ensure accurate accounting entries for sales, refunds, commissions, and other marketplace adjustments.
• Support month-end closing activities related to e-commerce revenue and collections.
• Identify process gaps and implement improvements to enhance reconciliation accuracy and efficiency.
• Maintain proper documentation and support internal/statutory audits related to e-commerce transactions.

Preferred candidate profile

• Bachelors degree in Commerce, Finance, Accounting, or related field.
• 4+ years of experience in Finance Operations / E-commerce Reconciliation / Revenue Reconciliation.
• Strong understanding of e-commerce transaction lifecycle including order processing, payments, settlements, refunds, cancellations, and commissions.
• Hands-on experience working with marketplace settlement reports and payment gateway reconciliations.
• Advanced knowledge of MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, data analysis).
• Experience working with ERP/accounting tools and reconciliation platforms preferred.