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.

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

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

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

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

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

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

📌 Accounts Receivable Executive (Noida)
🏢 Everactiv
📍 Noida