Back Office MIS Executive

Daily MIS Reporting

• Prepare and maintain daily, weekly, and monthly MIS reports.

• Collect data from different departments and consolidate it accurately.

• Ensure reports are submitted to management within deadlines.

Data Management

• Maintain company data in Excel/Google Sheets and ERP systems.

• Ensure data accuracy, completeness, and proper documentation.

• Update databases and maintain records systematically.

Sales & Dispatch Reports

• Prepare sales, order, dispatch, pending order, and delivery reports.

• Track customer orders and coordinate with Sales, Production, and Dispatch teams.

• Highlight pending and delayed orders to management.

Production MIS

• Prepare production-related reports including daily production, rejection, wastage, and stock data.

• Compare production targets with actual production.

• Identify major variances and report them to the concerned department.

Inventory & Stock Reporting

• Monitor raw material, finished goods, and packing material stock.

• Prepare stock movement and consumption reports.

• Coordinate with stores and production teams for stock updates.

Management Reporting & Analysis

• Prepare dashboards and summaries for management review.

• Analyze trends, variances, and department performance.

• Provide accurate data to management for decision-making.

Excel & Data Analysis

• Use advanced Excel functions such as VLOOKUP/XLOOKUP, Pivot Tables, SUMIFS, COUNTIFS, IF, and charts.

• Create automated reports and dashboards wherever possible.

• Maintain proper formulas and reporting formats.

Coordination

• Coordinate with Accounts, Sales, Production, Dispatch, Purchase, and Stores departments.

• Follow up for pending data and ensure timely reporting.

• Escalate discrepancies or important issues to management.

Documentation

• Maintain proper records of MIS reports and supporting documents.

• Ensure confidentiality and security of company data.

• Maintain organized digital files and reporting records.

Additional Responsibilities