MIS Executive & Stock Auditor

Job Description MIS Executive Cum Stock Auditor

Job Title

MIS Executive Cum Stock Auditor

Job Summary

We are looking for a detail-oriented and analytical MIS Executive Cum Stock Auditor responsible for preparing MIS reports, maintaining accurate data, monitoring inventory records, and conducting regular stock audits. The candidate will ensure accuracy between physical stock and system records and provide timely reports to management.

Key Responsibilities

MIS & Reporting

• Prepare daily, weekly, and monthly MIS reports.
• Maintain and update Excel-based databases and records.
• Collect, verify, and analyze data from different departments.
• Prepare reports related to sales, inventory, purchases, stock movement, and operational performance.
• Use Excel functions such as VLOOKUP, HLOOKUP, XLOOKUP, SUMIF, COUNTIF, Pivot Tables, etc.
• Identify data discrepancies and report them to the concerned department.
• Maintain proper documentation and records.

Stock Audit & Inventory

• Conduct physical stock verification at warehouses, stores, branches, and other locations.
• Compare physical stock with system/ERP records.
• Identify shortages, excess stock, damaged goods, and stock discrepancies.
• Check inward and outward stock movements and supporting documents.
• Verify stock registers, invoices, GRNs, delivery challans, and other relevant documents.
• Prepare stock audit reports and highlight discrepancies to management.
• Monitor inventory accuracy and help reduce stock losses.
• Conduct surprise and scheduled stock audits as required.
• Coordinate with warehouse, purchase, sales, and accounts teams for stock reconciliation.

Travel Requirement

• Travelling for stock audits is mandatory for this position.
• The candidate must be willing to travel regularly to warehouses, stores, branches, and other locations for audit assignments.
• Local as well as outstation travel may be required depending on business requirements.
• Candidates should be comfortable with frequent travel and working at different locations.

Required Qualifications

• Graduate in Commerce, Business Administration, Finance, or a related field.
• 1–3 years of experience in MIS, inventory, stock audit, or a similar role.
• Strong knowledge of MS Excel.
• Knowledge of accounting/ERP software is preferred.
• Good analytical and numerical skills.
• Strong attention to detail.
• Good communication and coordination skills.
• Ability to work independently and as part of a team.
• Willingness and ability to travel for audit assignments is mandatory.

Preferred Excel Skills

• VLOOKUP / HLOOKUP / XLOOKUP
• Pivot Tables
• SUMIF / SUMIFS
• COUNTIF / COUNTIFS
• IF / IFERROR
• Data Sorting & Filtering
• Conditional Formatting
• Data Validation
• Basic Excel dashboards and reporting

Key Performance Areas (KPIs)

• Accuracy of MIS reports.
• Timely submission of reports.
• Accuracy of stock reconciliation.
• Identification and reporting of stock discrepancies.
• Completion of scheduled stock audits.
• Reduction of inventory-related errors and losses.

Experience: 1–3 years
Employment Type: Full-time
Location: As per company requirement
Travel: Mandatory for stock audit assignments