JOB DESCRIPTION – DISPATCH COORDINATOR
GENDER - FEMALE
Office / Documentation / Excel Work
Job Title: Dispatch Coordinator Department: Logistics / Dispatch / Operations Job Location: Office Job Type: Full-Time
Job Summary
The Dispatch Coordinator is responsible for managing daily dispatch operations, maintaining dispatch records, preparing documentation, updating Excel reports, and coordinating with the warehouse, transporters, drivers, and customers to ensure timely delivery of goods.
Key Responsibilities
Prepare daily dispatch plans and schedules.
Maintain dispatch records and documentation.
Prepare delivery challans, invoices, e-way bills, and dispatch slips.
Update daily dispatch details in MS Excel.
Maintain Excel reports for:
Daily dispatch reports
Vehicle details
Material dispatch records
Pending deliveries
Stock and delivery status
Coordinate with warehouse and transport departments.
Follow up with transporters and drivers regarding vehicle availability and delivery status.
Track dispatched materials and maintain delivery records.
Maintain proper filing of dispatch documents.
Prepare daily, weekly, and monthly dispatch reports.
Verify quantities, material codes, and customer details before dispatch.
Ensure all dispatch-related documents are accurate and updated.
Required Skills
Basic to good knowledge of MS Excel.
Knowledge of MS Word and email communication.
Data entry and documentation skills.
Good communication and coordination skills.
Knowledge of dispatch and logistics processes.
Ability to maintain records and reports.
Accuracy in handling data and documents.
Excel Knowledge Required
Data Entry and Formatting
SUM and SUMIF formulas
VLOOKUP / XLOOKUP
Filter and Sorting
Pivot Tables (basic)
Conditional Formatting
Daily MIS Report Preparation
Educational Qualification
Graduate or 12th Pass (as per company requirements).
Basic computer knowledge.
Previous experience in dispatch, logistics, or office documentation will be preferred.
Key Performance Indicators (KPI)
Accurate dispatch documentation.
Timely updating of Excel records.
Proper coordination with warehouse and transporters.
Timely dispatch reporting.
Minimum documentation errors.
Proper tracking of pending deliveries.
Suggested Daily Office Work
Task
Responsibility
Dispatch Entry
Update Excel sheet
Documentation
Prepare challan and invoices
Vehicle Entry
Maintain vehicle details
Delivery Tracking
Update delivery status
MIS Report
Prepare daily dispatch report
Record Keeping
Maintain dispatch files