MIS Executive & Stock Auditor

Job Title

MIS Executive & Stock Auditor

Purpose of the Role

The purpose of this role is to manage MIS reporting, maintain accurate operational and inventory data, and conduct physical stock audits. The candidate will be responsible for identifying stock discrepancies, reconciling physical stock with system records, and providing accurate reports to management.

Key Responsibilities

MIS & Reporting

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

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 other discrepancies.
  
• Verify inward and outward stock movements and supporting documents.
  
• Check stock registers, invoices, GRNs, delivery challans, and related documents.
  
• Prepare detailed stock audit and reconciliation reports.
  
• Conduct scheduled and surprise stock audits as required.
  
• Coordinate with warehouse, purchase, sales, and accounts teams for stock reconciliation.
  
• Report significant discrepancies and irregularities to management.
  

Mandatory 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.
  
• Local as well as outstation travel may be required based on audit assignments.
  
• 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 Tally/ERP or inventory management 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 to travel for audit assignments is mandatory.
  

Preferred Skills

• VLOOKUP / HLOOKUP / XLOOKUP
  
• Pivot Tables
  
• SUMIF / SUMIFS
  
• COUNTIF / COUNTIFS
  
• IF / IFERROR
  
• Data Sorting & Filtering
  
• Conditional Formatting
  
• Data Validation
  
• Stock reconciliation
  
• Inventory reporting and analysis
  

Key Performance Areas (KPIs)

• Accuracy and timely submission of MIS reports.
  
• Accuracy of physical stock verification.
  
• Timely completion of assigned stock audits.
  
• Identification and reporting of stock discrepancies.
  
• Accuracy of stock reconciliation.
  
• Proper documentation of audit findings.
  
• Reduction of inventory-related errors and losses.