Distribution Sales Admin: Tracking & Reporting Pro

Hammerjack Pty Ltd; Philippines; On-site; PHP 240,000 - 360,000; Full time

Job summary

Hammerjack Pty Ltd is seeking a Sales Admin in the Distribution Team to support sales tracking, documentation, reporting, and order monitoring. You will work closely with Sales, Warehouse, Logistics, and Finance to ensure accurate records and timely updates.

The role emphasizes Excel-based monitoring, daily/weekly/monthly reports, and ensuring proper documentation for POs and orders. Experience in distribution or FMCG is a plus.

Qualifications

• Bachelor's degree in Business Administration, Marketing, Management, or a related field.
• At least 1 year of experience in Sales Administration, Sales Operations, Order Management, or a related role is preferred.
• Excellent Microsoft Excel skills, with experience in creating and maintaining trackers, reports, and monitoring files.
• Proficiency in Excel functions such as PivotTables, XLOOKUP/VLOOKUP, SUMIF/SUMIFS, COUNTIF/COUNTIFS, filters, conditional formatting, and basic data analysis.
• Excellent tracking and monitoring skills with the ability to manage multiple orders, accounts, deadlines, and action items.
• Strong documentation and records-management skills, ensuring files and sales records are complete, accurate, organized, and easily traceable.
• Highly detail-oriented and data-driven, with a strong focus on accuracy and completeness.
• Strong follow-through skills and ability to proactively follow up on pending requirements.
• Experience using ERP/order management systems is an advantage.
• Experience in distribution, retail, consumer electronics, or FMCG is an advantage.
• Strong communication and coordination skills when working across Sales, Warehouse, Logistics, Finance, and other departments.

Responsibilities

• Maintain accurate and updated sales trackers covering orders, deliveries, account status, pending requirements, and other sales activities.
• Ensure complete, organized, and accurate documentation of POs, sales orders, quotations, delivery documents, and other sales-related records.
• Develop and maintain Excel-based monitoring and reporting tools for the Distribution Team.
• Prepare and update daily, weekly, and monthly sales reports and trackers for management.
• Receive, validate, encode, and monitor customer Purchase Orders and sales orders.
• Monitor pending, fulfilled, cancelled, and back orders and proactively follow up on outstanding items.
• Coordinate with Warehouse and Logistics regarding inventory availability, order preparation, delivery schedules, and fulfillment.
• Coordinate with Finance/Accounting regarding payment status, credit limits, billing concerns, and order release requirements.
• Maintain accurate records of customer information, pricing, discounts, promotions, and approved commercial arrangements.
• Support the Sales Team in monitoring sales targets, actual sales, account performance, and other KPIs.
• Identify discrepancies or missing information in sales records and coordinate corrective actions with the concerned teams.
• Ensure proper filing, version control, and traceability of sales documents and reports.
• Provide administrative and operational support to Sales Account Managers and the Distribution Head.
• Perform other sales administration and reporting functions as assigned.

Skills

Advanced Excel

Sales tracking

Documentation

Order management

Cross-functional coordination

Education

Bachelor's degree in Business Administration / related field

Tools

ERP / order management systems

Job description

Hammerjack Pty Ltd is seeking a Sales Admin in the Distribution Team to support sales tracking, documentation, reporting, and order monitoring. You will work closely with Sales, Warehouse, Logistics, and Finance to ensure accurate records and timely updates.

The role emphasizes Excel-based monitoring, daily/weekly/monthly reports, and ensuring proper documentation for POs and orders. Experience in distribution or FMCG is a plus.