MIS Reporter

Full job description

Roles & Responsibilities

• Prepare and maintain daily, weekly, and monthly Sales MIS reports using Microsoft Excel.

• Collect sales data from Sales Executives, Branch Offices, and Distributors, ensuring data accuracy and completeness.

• Generate reports on sales performance, order status, collections, pending orders, customer-wise sales, and product-wise sales.

• Prepare sales analysis reports, trend analysis, management dashboards, and KPI reports using Pivot Tables, Charts, and advanced Excel formulas.

• Monitor sales targets against achievements and submit variance reports to management.

• Maintain and update customer, dealer, distributor, and other master data.

• Prepare and circulate daily sales summaries, periodic performance reports, and ad hoc reports as required by management.

• Coordinate with the Sales, Production, Stores, Dispatch, Accounts, and other departments to collect, verify, and consolidate data for timely reporting.

• Verify sales orders, dispatch details, invoices, delivery status, quotations, purchase orders, and related sales documents before updating MIS reports.

• Prepare ageing reports for pending orders, receivables, and dispatches, and assist management in tracking business performance.

• Develop, maintain, and improve MIS formats, Excel dashboards, and reporting systems to support effective decision-making.

• Ensure the accuracy, confidentiality, integrity, and timely submission of all business reports and data.

• Maintain office records, files, registers, departmental documents, and digital backups in an organized manner.

• Coordinate office stationery requirements, maintain stock records, and manage courier, inward, and outward dispatch records.

• Assist in scheduling meetings, preparing Minutes of Meeting (MOM), drafting official letters, reports, circulars, and other business correspondence.

• Coordinate with vendors and service providers for office maintenance and other administrative requirements.

• Provide administrative support to the Sales team and management and ensure compliance with company procedures.

• Perform any other MIS reporting, sales coordination, or administrative responsibilities assigned by the Reporting Manager or Management.

Job Types: Full-time, Permanent

Pay: ₹18,000.00 - ₹25,000.00 per month

Benefits:

• Health insurance

• Provident Fund

Education:

• Bachelor's (Preferred)

Experience:

• Management reporting: 3 years (Preferred)

• total work: 2 years (Required)

Work Location: In person