Location; India - MumbaiSalary - INR 1000000 - 1200000Experience - 5 - 8 YearsRole Overview:The Assistant Manager – Accounts Receivable (AM AR) will manage end-to-end AR operations including invoicing, collections, reconciliation, and reporting. The role requires strong analytical ability, advanced Excel skills, and logical thinking to drive data-backed decisions, improve processes, and ensure healthy cash flow.Roles and Responsibilities:Accounts Receivable ManagementOversee invoicing, billing, and collections processesEnsure timely and accurate invoice generationMonitor aging reports and take proactive actionsCollections & Cash FlowFollow up on outstanding receivables and ensure timely collectionsWork towards reducing DSO and improving cash flowAnalyze payment patterns and identify collection risksMIS & Reporting (Key Focus Area)Prepare and maintain detailed MIS reports for managementGenerate daily/weekly/monthly AR dashboardsAnalyze trends in receivables, aging, and collectionsProvide actionable insights based on data analysisReconciliation & Problem SolvingPerform customer account reconciliationsIdentify discrepancies and resolve them using logical analysisInvestigate complex billing/payment issuesExcel & Data Handling (Critical Requirement)Use advanced Excel functions (Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, etc.)Handle large datasets efficientlyBuild automated reports and trackersTeam ManagementSupervise AR team membersAllocate work and monitor performanceTrain team on reporting and process improvementsClient CoordinationCommunicate with clients for collections and issue resolutionHandle escalations professionallyCoordinate with internal teams (Sales, Operations)Compliance & ControlsEnsure adherence to internal policies and audit requirementsMaintain proper documentation for auditsQualifications and Skills:5–8 years of AR / O2C experienceStrong MIS reporting and data analysis experienceAdvanced Excel skills (mandatory)Strong logical thinking and problem-solving abilityGood communication and stakeholder management skillsExperience with ERP systems (SAP/Oracle/NetSuite, etc.) will be added advantagePreferred Skills:Experience in handling international clientsKnowledge of GST / taxationProcess improvement and automation exposureKPIs / Performance Metrics:DSO reductionCollection efficiencyAccuracy and timeliness of MIS reportsQuality of data analysis and insightsAging control and dispute resolution timeMust have -Strong experience in end-to-end Accounts Receivable (AR) / O2C cycleExpertise in invoicing, collections, and aging analysisAdvanced Excel skills (Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS)Strong MIS reporting & data analysis capabilityExperience with ERP systems (SAP / Oracle / NetSuite or similar)Proven ability in reconciliation & discrepancy resolutionStrong analytical thinking & problem-solving skillsExperience in client coordination and collections follow-upsAbility to manage/mentor a teamGood understanding of cash flow management & DSO improvement
