Accounts Executive - Receivable

Role Overview

Responsible for managing Accounts Receivable, payment processing, collections, reconciliation, credit notes, ageing, and MIS reporting. The role involves extensive use of MS Excel for bulk data processing, Pivot Tables, complex formulas, reconciliation, and report preparation, with a strong focus on accuracy, AR hygiene, and cash flow improvement.

Key Responsibilities

Payment Processing

·      Monitor and accurately record incoming payments.

·      Reconcile payments with bank deposits and accounting records.

·      Identify and report payment mismatches or errors.

Collections

·      Monitor outstanding and overdue invoices.

·      Prioritize collection activities and follow up on pending payments.

·      Escalate long-pending or disputed receivables.

Account Reconciliation

·      Reconcile courier/delivery partner accounts.

·      Investigate discrepancies, short remittances, and payment mismatches.

·      Coordinate with relevant teams for timely resolution.

·      Ensure accurate processing of invoices and reconciliation items.

Credit Notes - RTO & DTO

·      Ensure timely creation and knocking of credit notes against RTO and DTO orders.

·      Track open credit memos and ensure timely closure.

·      Identify and prevent duplicate or incorrect credit notes.

Ageing & AR Management

·      Prepare and analyze AR Ageing Reports.

·      Track outstanding balances, overdue receivables, and open credit memos.

·      Identify potential bad debts and revenue leakages.

MIS & Reporting

Maintain and prepare:

o  Delivery Partner MIS

o  Hyperlocal Cash MIS

o  O2C Reports

o  AR Ageing Reports

o  Reconciliation Reports

o  Outstanding & Collection Reports

o  Credit Note Reports

·      Present relevant AR reports to management.

Excel & Data Management

·      Work extensively on MS Excel and process large volumes of data.

·      Use Pivot Tables, lookups, logical functions, and complex formulas.

·      Perform data validation, reconciliation, and analysis.

·      Identify errors and discrepancies in large datasets.

Cross-Functional Coordination

·      Coordinate with the Tech team to resolve system-related disputes.

·      Work with Operations, Finance, and other teams on invoice, payment, and credit note issues.

·      Ensure timely closure of open items.

Process Improvement

·      Identify gaps and opportunities to improve AR and reconciliation processes.

·      Reduce manual errors and turnaround time.

·      Implement best practices, process standardization, and automation wherever possible.

Key Performance Indicators (KPIs)

·      Accuracy and timely closure of payment and partner reconciliations.

·      Reduction in short remittances, open reconciliation items, and overdue receivables.

·      Timely collections and reduction in ageing/bad debt exposure.

·      Accurate and timely creation/knocking of RTO/DTO credit notes.

·      Reduction in duplicate or incorrect credit memos.

·      Timely and accurate MIS, AR, and O2C reporting.

·      Timely identification of errors, discrepancies, and revenue leakages.

·      Contribution towards improved cash flow and AR hygiene.

Qualifications & Skills

·      Bachelor's degree in Commerce, Accounting, Finance, or related field.

·      1–5 years of relevant experience in AR, Reconciliation, Collections, or Finance Operations.

·      Strong understanding of AR and reconciliation processes.

Expert-level MS Excel proficiency is mandatory.

·      Strong knowledge of Pivot Tables, lookups, logical functions, and large-volume data handling.

·      E-commerce experience preferred.

·      Strong analytical, numerical, and problem-solving skills.

·      High attention to detail and accuracy.

·      Good communication and coordination skills.

·      Ability to work under deadlines, especially during month-end/year-end closing.