Job Role: MIS Executive /ADMIN & ACCOUNTS COORDINATOR

Experience: 0-2 yrs
Location: Indore (Vijay Nagar)

Job Summary:
We are looking for a detail-oriented MIS Executive who is proficient in Excel and can efficiently manage MIS reporting, stock records, banking coordination, Tally, and administrative activities. The candidate should be highly accurate, organized, and comfortable handling numbers, data, documentation, and day-to-day office coordination.

Key Requirements:

MIS & Excel

• Prepare and maintain regular MIS reports for sales, purchases, stock, payments, expenses, and business operations.
• Maintain Excel sheets and databases accurately.
• Prepare daily, weekly, and monthly reports as required by management.
• Use Excel formulas, Pivot Tables, VLOOKUP/XLOOKUP, filters, sorting, data validation, and other reporting tools.
• Maintain proper records and ensure data accuracy.

Stock Management

• Maintain precise records of Stock In and Stock Out.
• Track material movement and maintain updated inventory records.
• Reconcile physical stock with system/Excel records.
• Coordinate with purchase, sales, warehouse, and production teams for stock updates.
• Prepare stock statements and inventory reports whenever required.

Tally & Accounts Support

• Basic to good working knowledge of Tally.
• Maintain and update relevant entries and records in Tally.
• Assist with purchase, sales, expense, payment, and receipt entries.
• Coordinate with the accountant/management for accounting-related documentation.
• Maintain proper records of invoices, bills, receipts, and payments.

Banking & Payment Coordination

• Maintain records of bank transactions and payments.
• Assist in bank reconciliation and payment tracking.
• Maintain records of customer/vendor payments and outstanding amounts.
• Coordinate for cheque, NEFT/RTGS/online payment documentation wherever required.
• Keep management updated on pending payments and collections.

Administrative Responsibilities

• Maintain office documentation and records.
• Handle routine administrative coordination.
• Maintain vendor and customer records.
• Assist management with reports, documentation, data, and other operational requirements.
• Coordinate with different departments to ensure smooth flow of information.

Skills & Competencies:

• Excellent knowledge of MS Excel is mandatory.
• Knowledge of Tally is required.
• Strong numerical and analytical skills.
• Good knowledge of MIS reporting and data management.
• High level of accuracy and attention to detail.
• Good communication and coordination skills.
• Ability to maintain confidentiality of financial and business information.
• Ability to multitask and meet deadlines.