Reconciliation Specialist

Job description

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.