Company- Everactiv

Accounts Receivable & Reconciliation Executive

Location: Sector 63, Noida, Uttar Pradesh

Industry preferred : E-commerce / Healthcare

Working Days: 6 Days

Key Responsibilities

- 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.

- 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.

- 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.

- 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.

- 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.

- 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.

- 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