Accounts Receivable Executive

Accounts Receivable & Reconciliation Executive

Location

Sector 63, Noida, Uttar Pradesh

Department

Finance & Accounts

Industry

E-commerce / Healthcare

Working Days

6 Days a Week

About the Role

We are looking for a detail-oriented and analytical Accounts Receivable & Reconciliation Executive to manage sales reconciliation and receivables across multiple e-commerce and sales channels.

The candidate will be responsible for reconciling sales across all channels, verifying channel-wise sales, preparing company MIS, tracking receivables and settlements, identifying discrepancies, and maintaining accurate financial records.

The role requires strong MS Excel skills, numerical accuracy, analytical ability, and ownership of reconciliation activities.

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

Required Skills

Strong knowledge of Accounts Receivable and reconciliation.

Strong understanding of sales reconciliation and settlement processes.

Excellent MS Excel skills.

Strong numerical and analytical ability.

High attention to detail and accuracy.

Good understanding of accounting principles.

Ability to work with large volumes of data.

Strong follow-up and coordination skills.

Good communication and problem-solving skills.

Strong ownership and ability to work independently.

Preferred Experience

Min 6months of experience in Accounts Receivable, Reconciliation, Finance & Accounts or MIS.

Experience in e-commerce, D2C, healthcare, FMCG or retail will be preferred.

Experience working with multiple marketplaces/payment gateways will be an advantage.

Knowledge of ERP/accounting software such as Tally, Zoho Books, SAP, Oracle or similar systems will be an added advantage.

Candidate Profile

We are looking for a candidate who is

Very strong in Excel and numbers

Highly detail-oriented

Comfortable working with large datasets

Strong in reconciliation and identifying discrepancies

Proactive in following up on pending payments

Accountable for assigned MIS and reconciliation activities

Able to meet daily/monthly reporting deadlines

Comfortable working in a fast-paced e-commerce environment

Key Performance Indicators (KPIs)

Accuracy of channel-wise sales reconciliation

Timely completion of daily/monthly reconciliation

Accuracy of company MIS

Timely identification and resolution of discrepancies

Timely collection/settlement follow-ups

Reduction in unreconciled transactions

Accuracy and completeness of financial reporting

Pay

₹15,000.00 - ₹35,000.00 per month

Work Location

In person