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

📌 Accounts Executive - Receivable (Mumbai)
🏢 Truemeds
📍 Mumbai