MIS Executive And Stock Auditor

Nextgen Business Support Services Private Limited; Kolkata District; On-site; INR 250,000 - 360,000; Full time

Job summary

Nextgen Business Support Services Private Limited seeks an MIS Executive & Stock Auditor to manage MIS reporting, maintain inventory data, and conduct physical stock audits. You will reconcile stock with ERP records, identify discrepancies, and provide accurate reports to management.

Regular travel to warehouses, stores, and branches is required. The role demands 1–3 years in MIS/inventory, strong Excel skills, and the ability to work independently and as part of a team.

Qualifications

• Graduate in Commerce, Business Administration, Finance, or related field.
• 1–3 years experience in MIS, inventory, stock audit, or 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.
• Willingness to travel for audit assignments is mandatory.

Responsibilities

• 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.
• 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.

Skills

MS Excel

Data analysis

Attention to detail

Communication

Team coordination

Education

Bachelor's degree in Commerce/Business Admin/Finance

Tools

Tally/ERP

Inventory management software

Job description

Job Description:

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.