Job Title - Asst. Manager – MIS
Department - Finance – Credit Control
Location - Mumbai
Experience - 3–5 Years
Job Purpose
The Assistant Manager / Manager – MIS will be responsible for managing the Management Information System (MIS) for the Credit Control and Collections function. The role focuses on delivering accurate and timely daily, weekly, monthly, quarterly, and annual reports, developing dashboards and analytics, supporting financial reconciliations, automating reports using advanced Excel tools, and enabling management decision-making through insightful business intelligence.
Key Responsibilities
- Prepare daily, weekly, monthly, quarterly, and annual MIS reports for management.
- Develop and automate reports using Advanced Excel, VBA, Macros, Power Query, and Power BI.
- Prepare management presentations and dashboards in PowerPoint.
- Monitor Accounts Receivable (AR), collections, ageing, overdue analysis, and customer trends.
- Perform customer, inter-company, and TDS reconciliations (26AS).
- Coordinate with FP&A;, FCFR, Operations Finance,
and business teams for timely reporting.
- Support month-end closing activities and ensure audit-ready documentation.
- Ensure compliance with reporting timelines and regulatory requirements.
- Analyse business and customer data, identify risks, and recommend corrective actions.
- Prepare fund variance analysis comparing actuals versus budgets/forecasts.
- Continuously improve MIS processes through automation and standardisation.
- Work extensively on Microsoft D365, Power BI, and Microsoft Office applications.
Educational Qualifications
Bachelor's or Master's Degree in Finance, Accounting, Commerce, Business Administration, or a related discipline from a recognized university.
Experience
3–5 years of relevant experience in MIS reporting, Finance, Commercial Operations, Credit Control, or Accounts Receivable within a large corporate or multinational workplace.
Technical Skills
- Advanced Microsoft Excel (
📌 Assistant Manager (Mumbai)
🏢 dentsu
📍 Mumbai