Stock Audit & MIS Executive

Nextgen Business Support Services; Kolkata District; On-site; INR 350,000 - 520,000; Full time

Job summary

Nextgen Business Support Services seeks a detail-oriented MIS Executive Cum Stock Auditor to prepare MIS reports, maintain data accuracy, and conduct regular stock audits across warehouses and stores. You will reconcile physical stock with ERP records and provide timely insights to management.

The role requires 1–3 years in MIS or inventory, strong MS Excel skills, and willingness to travel frequently to audit locations. Full-time position based on company requirements in Kolkata.

Qualifications

• Graduate in Commerce, Business Administration, Finance or related field.
• 1–3 years of experience in MIS, inventory, stock audit, or similar role.
• Strong MS Excel skills and data analysis ability.
• Good communication and coordination skills.

Responsibilities

• Prepare MIS reports on daily, weekly, and monthly basis.
• Maintain Excel databases and records with accuracy.
• Collect, verify, and analyze data from multiple departments.
• Perform stock audits and verify stock against ERP records.
• Highlight discrepancies and report to management.
• Coordinate with warehouse, purchases, sales, and accounts teams for reconciliation.
• Travel to warehouses, stores, branches as required.

Skills

MS Excel

Data analysis

Stock auditing

Education

Graduate in Commerce, Business Administration, Finance

Tools

ERP software

Job description

Job Description MIS Executive Cum Stock Auditor

Job Title

MIS Executive Cum Stock Auditor

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