Roles & Responsibilities
- Prepare and maintain daily, weekly, and monthly Sales MIS reports using Microsoft Excel.
- Collect sales data from Sales Executives, Branch Offices, and Distributors, ensuring data accuracy and completeness.
- Generate reports on sales performance, order status, collections, pending orders, customer-wise sales, and product-wise sales.
- Prepare sales analysis reports, trend analysis, management dashboards, and KPI reports using Pivot Tables, Charts, and advanced Excel formulas.
- Monitor sales targets against achievements and submit variance reports to management.
- Maintain and update customer, dealer, distributor, and other master data.
- Prepare and circulate daily sales summaries, periodic performance reports, and ad hoc reports as required by management.
- Coordinate with the Sales, Production, Stores, Dispatch, Accounts, and other departments to collect, verify, and consolidate data for timely reporting.
- Verify sales orders, dispatch details, invoices, delivery status, quotations, purchase orders, and related sales documents before updating MIS reports.
- Prepare ageing reports for pending orders, receivables, and dispatches, and assist management in tracking business performance.
- Develop, maintain, and improve MIS formats, Excel dashboards, and reporting systems to support effective decision-making.
- Ensure the accuracy, confidentiality, integrity, and timely submission of all business reports and data.
- Maintain office records, files, registers, departmental documents, and digital backups in an organized manner.
- Coordinate office stationery requirements, maintain stock records, and manage courier, inward, and outward dispatch records.
- Assist in scheduling meetings, preparing Minutes of Meeting (MOM), drafting official letters, reports, circulars, and other business correspondence.
- Coordinate with vendors and service providers for office maintenance and other administrative requirements.
- Provide administrative support to the Sales team and management and ensure compliance with company procedures.
- Perform any other MIS reporting, sales coordination, or administrative responsibilities assigned by the Reporting Manager or Management.
Job Types: Full-time, Permanent
Pay: ₹18,000.00 - ₹25,000.00 per month
Benefits:
- Health insurance
- Provident Fund
Education:
Experience:
- Management reporting: 3 years (Preferred)
- total work: 2 years (Required)
Work Location: In person
