Company
- Everactiv Accounts Receivable & Reconciliation Executive
Location:
Sector 63, Noida, Uttar Pradesh Industry preferred : E-commerce / Healthcare Working Days: 6 Days
Key Responsibilities
1. Channel-Wise Sales Reconciliation Reconcile sales transactions across all online and offline sales channels. Verify sales reported by different platforms against internal systems/ERP. Perform daily, weekly and monthly reconciliation of channel-wise sales. Identify discrepancies in sales, cancellations, returns, discounts, refunds and other adjustments. Coordinate with internal teams and channel partners to resolve discrepancies. 2. Accounts Receivable & Settlement Reconciliation Track receivables from various e-commerce marketplaces and payment channels. Reconcile invoices, sales, collections, settlements and outstanding amounts. Verify settlement statements received from marketplaces/payment gateways. Track pending settlements and follow up for timely realization. Identify short payments, excess payments, deductions and other settlement differences. Maintain proper records of outstanding receivables and settlement status. 3. Sales Verification Verify sales data received from each channel against internal sales/order data. Check order value, taxes, discounts, cancellations, returns and refunds. Ensure that sales recorded in the books are supported by appropriate channel data. Highlight unusual variances or mismatches to the reporting manager. Maintain channel-wise sales and reconciliation trackers. 4. MIS & Reporting Prepare daily, weekly and monthly MIS for management.
Prepare channel-wise sales reports and reconciliation statements. Prepare reports covering: Channel-wise sales Collections Receivables Pending settlements Returns & refunds Deductions Reconciliation differences Outstanding amounts Provide accurate financial and operational data to management for decision-making. Maintain proper documentation and audit trails for all reports. 5. Excel & Data Analysis Maintain large-volume financial and sales data in MS Excel. Use advanced Excel functions for reconciliation and reporting, including: VLOOKUP / XLOOKUP Pivot Tables SUMIF / SUMIFS COUNTIF / COUNTIFS IF formulas Filters & sorting Conditional formatting Data validation Develop and maintain reconciliation templates and MIS dashboards. Analyze variances and identify the reasons for differences. 6. Coordination & Issue Resolution Coordinate with Finance, Sales, Operations, Customer Support and Warehouse teams for reconciliation issues. Coordinate with marketplace/channel teams regarding settlement and payment discrepancies. Follow up on pending receivables and unresolved reconciliation items. Maintain an issue tracker and ensure timely closure of open items. Escalate significant discrepancies to management. 7. Month-End Activities Support monthly closing activities related to sales and receivables. Ensure all channel sales and settlements are properly reconciled. Identify and close pending reconciliation items before month-end closure. Assist in providing supporting data/documents for audits and accounting requirements.
• Interested candidates reach out at (phone hidden) or share cv at
[email protected]
📌 Accounts Receivable Specialist (Noida)
🏢 Everactiv
📍 Noida