Job Description
Job Title: - MIS Executive
Location:- Ahmedabad
Workdays:- 6 Days
Experience:- 3+ years
Primary Purpose:
We are looking for the MIS Executive To ensure accurate, timely, and insightful reporting across all sales channels and trade operations, supporting decision-making, forecasting, compliance, and performance monitoring in the dairy business.
KRAs, Brief Descriptions, and Responsibilities:
1: Sales Reporting & Analysis
- Brief: Generate and analyze sales reports by product, geography, team, and customer segment to support daily decision-making and performance tracking.
- Roles & Responsibilities:
- Extract and compile daily, weekly, and monthly sales data from the sales app or CRM tools.
- Generate reports by SKU, zone, ASM, SO, SS, distributor, retailer, etc.
- Analyze achievement vs. target across segments.
- Identify sales trends, gaps, and provide actionable summaries.
- Support senior management in sales review dashboards.
2: Modern Trade, HoReCa, B2B, ECom Sales MIS
- Brief: Maintain accurate and periodic sales reports for alternate channels like Modern Trade, HoReCa, B2B, and E-commerce.
- Roles & Responsibilities:
- Track primary and secondary sales by format/channel.
- Consolidate outlet-wise performance data for modern trade chains.
- Maintain HoReCa, B2B key customer performance summary.
- Coordinate with the respective teams for data accuracy.
- Present weekly summaries for each vertical to management.
3: Outstanding & Receivables Reporting
- Brief: Provide daily updates on distributor and customer outstanding to aid credit management and sales collections.
- Roles & Responsibilities:
- Generate and share daily outstanding and receivables reports.
- Match sales ledger with finance records to ensure accuracy.
- Highlight overdue accounts and alert the sales team.
- Coordinate with accounts/finance for reconciliation queries.
- Maintain region- and partner-wise AR aging summary.
4: Sales Promotion, POS & Social Media Reports
- Brief: Track deployment and effectiveness of sales promotions, POS materials, and digital campaigns.
- Roles & Responsibilities:
- Maintain POS material inventory and usage report.
- Track scheme-wise sales impact and consumption.
- Prepare zone-wise promotion activity summaries.
- Coordinate with marketing for digital/social post data.
- Maintain campaign-wise lead or sales conversion reports.
5: Stock Reporting (SS, Distributors, Retailers)
- Brief: Maintain weekly inventory levels at trade partner locations to aid demand planning and replenishment.
- Roles & Responsibilities:
- Collect and compile stock data from SS, Distributors, and key retailers.
- Validate inventory levels against secondary sales.
- Identify slow-moving or overstocked SKUs.
- Prepare channel-wise inventory heatmaps.
- Share reports with supply chain and sales managers.
6: Credit Note & Scheme Management
- Brief: Ensure accurate credit note reporting and timely circulation of trade schemes.
- Roles & Responsibilities:
- Track issued credit notes and maintain summary reports.
- Validate scheme-wise distributor eligibility and claims.
- Prepare monthly credit note usage dashboards.
- Circulate scheme circulars to all stakeholders.
- Archive scheme approvals, claim records, and usage audit data.
7: Demand Forecasting Support
- Brief: Provide accurate and forward-looking sales data to support plant-level production and dispatch planning.
- Roles & Responsibilities:
- Collect market forecast from sales team by 5th of each month.
- Prepare consolidated demand sheet SKU-wise and zone-wise.
- Share the sheet with the plant 10 days before month end.
- Analyze past sales and trends to guide demand planning.
- Coordinate with plant if revisions are required.
8: Order & Rate List Management
- Brief: Ensure accuracy in sales order entries, product rates, and timely circulation of rate changes.
- Roles & Responsibilities:
- Enter orders into ERP with 100% SKU accuracy.
- Maintain latest rate cards and update in system and circulation.
- Communicate pricing changes to sales, accounts, and plant.
- Assist in margin structure preparation.
- Verify invoice values against order and rate list.
9: TA/DA & Expense Reports
- Brief: Maintain accurate travel/expense records of sales team and flag discrepancies.
- Roles & Responsibilities:
- Collect TA/DA claims of sales team.
- Prepare summary and validate entries as per policies.
- Highlight anomalies to HR/accounts.
- Maintain monthly expense trend summaries.
- Ensure timely reporting for reimbursement processing.
10: Trade Partner Documentation (KYC/Legal)
- Brief: Maintain legal and KYC documentation for all SS and Distributors as per compliance norms.
- Roles & Responsibilities:
- Maintain KYC records (GST, PAN, bank, Aadhar) for all partners.
Job Classification
Industry: Food Processing (Dairy)
Functional Area / Department: Sales & Business Development
Role Category: Sales Support & Operations
Role: Sales Operations / Enablement
Employement Type: Full time
Contact Details:
Company: Bankai Agrifood
Location(s): Ahmedabad
Keyskills:
Advanced Excel
Pivot Table
Excel
VLOOKUP
MIS Operations
Formulas
Conditional Formatting
Pivot
HLOOKUP
MIS Reporting