Mis Executive

Job Purpose -

To independently manage MIS reporting and reconciliation activities, ensuring accurate data compilation, financial and operational transaction matching, timely reporting, identification of discrepancies, and resolution of outstanding items. The role requires strong analytical skills, attention to detail, and effective coordination with internal and external stakeholders.

Role & responsibilities -

1. Prepare, consolidate, analyse, and maintain daily, weekly, and monthly MIS reports covering financial and operational performance.
2. Perform daily reconciliation of transactions between internal records, bank statements, payment gateways, sales reports, and third-party platforms.
3. Develop and maintain MIS dashboards, reconciliation statements, transaction trackers, and management reports.
4. Identify and investigate discrepancies, mismatches, duplicate entries, short payments, excess payments, and pending transactions.
5. Coordinate with Finance, Accounts, Operations, Sales, and other departments to resolve reconciliation differences within defined timelines.
6. Monitor outstanding transactions and prepare ageing reports to ensure timely follow-up and closure.
7. Analyse business data, identify trends, highlight exceptions, and provide meaningful insights to management for decision-making.
8. Ensure accuracy and consistency of data across various reporting systems and maintain proper supporting documentation.
9. Prepare daily transaction summaries, collection reports, payment reports, and reconciliation status reports.
10. Maintain and update MIS databases, trackers, and reporting formats to ensure data integrity.
11. Improve reporting and reconciliation processes through automation and standardisation using advanced Excel and other available tools.
12. Ensure timely submission of MIS and reconciliation reports as per defined timelines.
13. Support internal and external audits by providing reconciliation statements, transaction details, and supporting documents.
14. Maintain confidentiality of financial and business information and ensure compliance with company policies and procedures.

Preferred candidate profile

• Advanced MS Excel (VLOOKUP, XLOOKUP, Pivot Tables, SUMIFS, COUNTIFS, IF formulas).
• Strong knowledge of MIS reporting, data management, and reconciliation.
• Understanding of bank reconciliation and payment reconciliation.
• Good analytical, numerical, and problem-solving skills.
• Experience in preparing dashboards and management reports.
• Knowledge of ERP, accounting software, or financial management systems.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to manage multiple reports and deadlines independently.