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 explicit, 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

📌 MIS & Admin executive (India)
🏢 Einfach Solutions
📍 India