Job Responsibilities:
Prepare daily, weekly and monthly sales MIS reports.
Track model-wise, distributor-wise, dealer-wise and salesperson-wise sales.
Monitor primary and secondary sales, stock movement and inventory.
Prepare target vs. achievement reports for the sales team.
Track billing, collections, outstanding payments and credit limits.
Prepare daily stock ageing and slow-moving stock reports.
Monitor sales team performance and prepare productivity reports.
Maintain and analyse incentive and scheme calculations.
Coordinate with sales, accounts, warehouse and management for accurate data.
Prepare management dashboards and presentations for business review meetings.
Identify discrepancies in sales, stock and billing data and coordinate for correction.
Maintain proper records and ensure MIS reports are submitted within defined timelines.
Develop and improve Excel-based reporting systems to reduce manual work.
Required Skills:
Excellent MS Excel skills – Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, IF formulas, dashboards, etc.
Good understanding of sales and distribution operations.
Strong analytical and numerical skills.
Good communication and coordination skills.
Experience with mobile/electronics distribution will be preferred.
Knowledge of ERP/DMS/CRM software is an advantage.
Key Performance Indicators (KPIs):
Accuracy of MIS reports
Timely submission of daily/weekly/monthly reports
Sales and stock data accuracy
Target vs. achievement tracking
Outstanding and collection reporting
Quality of management dashboards and analysis