Daily Reporting to Directors & Corporate Clients
The candidate will be responsible for collating data from multiple departments and preparing accurate, well-formatted daily reports. These reports are shared with the Directors and, where applicable, with corporate clients Reports include but are not limited to:
Report
Frequency
Content / Data Points
Sales Update
Daily
SKU-wise dispatches, volume vs target, pending orders, region-wise performance
Outstanding / Debtors Report
Daily
Party-wise outstanding amounts, ageing (0–30, 30–60, 60–90, 90+ days), overdue flags
Production Report
DailyBatch-wise output, downtime, plan vs actuals, SKU production summary
Payment Follow-up
Daily
Client-wise payment status, promise dates, overdue amounts, escalation flags
PO (Purchase Order) Update
Daily / As needed
Open POs, GRN status, pending deliveries from vendors, new PO approvals
Dispatch & Logistics Report
Daily
Truck bookings, vehicles loaded, LR numbers, in-transit consignments, delivery confirmations
Inventory / Stock Report
Daily / Weekly
FG stock levels, RM stock, slow-moving items, reorder triggers
Weekly / Monthly MIS Summary
Weekly / Monthly
Consolidated business performance dashboard for Directors — revenue, sales, production, collections, expenses
MIS — Management Information System
- Design, build, and maintain Excel-based MIS dashboards for the organisation covering sales performance, production efficiency, collections, and vendor management.
- Develop automated Excel templates with formulas, pivot tables, charts, and conditional formatting to minimise manual data entry and reduce errors.
- Consolidate data from multiple departments (sales, production, accounts, logistics) into a unified weekly and monthly MIS pack for the Directors.
- Identify trends, flag exceptions (e.g. overdues crossing 60 days, production targets missed), and present data in a clear, visual format.
- Maintain and update MIS templates as business requirements evolve — adding new metrics, new clients, or new SKUs as directed.
- Gradually develop skills in Power BI or Google Data Studio for advanced dashboards if required.
Coordination — Plant, Sales, Logistics & Vendors
- Act as the central coordination point between the plant, sales team, logistics team, and vendors for day-to-day operational requirements.
- Coordinate with the plant team for daily production updates, planned downtime, and dispatch schedules. Ensure information flows to sales and management on time.
- Truck & logistics booking — liaise with transporters and the logistics team for booking trucks, obtaining LR (Lorry Receipt) numbers, tracking in-transit consignments, and confirming deliveries.
- Coordinate with the sales team on order confirmation, dispatch priorities, client-specific packaging requirements, and delivery timelines.
- Follow up with vendors for pending PO deliveries, GRN processing, and invoice submissions. Flag delays to the Purchase team.
- Coordinate with clients on outstanding payments, invoice disputes, and credit note requests. Maintain a follow-up tracker and escalate overdue accounts.
- Maintain and update contact directories for clients, vendors, transporters, and plant team leads.
Communication & Correspondence
- Draft and send professional emails and WhatsApp messages to Directors, corporate clients, vendors, and internal teams in both Hindi and English.
- Prepare meeting notes, action trackers, and follow-up summaries after internal review meetings with Directors.
- Handle routine business correspondence — sending reports, responding to client queries, sharing invoices or delivery documents.
- Maintain a structured digital filing system for all reports, emails, POs, invoices, and correspondence — easily retrievable by anyone authorised.
General Administration
- Support the Directors' office with any ad-hoc administrative requirements — presentations, data compilation, vendor comparisons, or document preparation.
- Maintain a daily task tracker and ensure all recurring reports and follow-ups are sent on time without reminders.
- Assist in preparation of business review presentations (PowerPoint / Google Slides) for monthly management reviews.
- Maintain confidentiality of all business-sensitive data — financial reports, client information, pricing, and internal communications.
Required Qualifications & Skills:
Education
B.Sc. Computers / BCA / B.Tech (IT or Computer Science) or equivalent. Higher qualification welcome.
Total Experience
Minimum 4 years of experience in an MIS, reporting, administration, or operations coordination role in a manufacturing or trading company.
Microsoft Excel
Advanced proficiency is mandatory. Must be confident with: VLOOKUP / XLOOKUP, SUMIF / SUMIFS / COUNTIFS, Pivot Tables and Pivot Charts, Conditional Formatting, Data Validation, Named Ranges, basic Macro/VBA knowledge is a plus.
MS Office Suite
Proficient in Microsoft Word and PowerPoint. Able to prepare professional reports and presentations independently.
Communication
Excellent written and verbal communication in both Hindi, Tamil and English. Must be able to communicate confidently with Directors, corporate clients, and plant/logistics teams.
Email & WhatsApp
Professional and prompt in email and WhatsApp communication. Must understand the difference in tone between internal team messages and corporate client correspondence.
Analytical Ability
Able to spot discrepancies in data, identify trends, and flag exceptions independently without being asked every time.
Industry Experience
Prior experience in a manufacturing, FMCG, chemical, or trading company is strongly preferred. Exposure to SAP, Tally, or any ERP is an advantage.
Job Type: Full-time
Pay: ₹30,000.00 - ₹45,000.00 per month
Experience:
- MIS & Admin: 3 years (Required)
Work Location: In person
