Admin Sales MT

FACETOLOGY; Jakarta Selatan; On-site; IDR 72,000,000 - 100,000,000; Full time

Job summary

FACETOLOGY in Jakarta Selatan seeks a Sales Administration professional to monitor daily MT sales performance, consolidate data from distributors and B2B systems, and maintain accurate dashboards and reports. You will filter and validate data, support pricing revisions and invoice/document claim processes, and collaborate with cross-functional teams to ensure timely daily reporting and clean records.

A Diploma or Bachelor’s degree with at least 1 year of relevant experience and strong Excel

Qualifications

• Proficiency in Excel, Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, IF functions.

Responsibilities

• Monitor and prepare daily MT sales reports and ensure accurate tracking of performance.
• Filter, process, and consolidate sales data from B2B systems and distributor reports.
• Maintain dashboards and pivot reports on sales by account, PO, daily store sell-out, and product.
• Support PPL requirements and promotional program evaluations with data.
• Assist in Modern Trade claim documentation and ensure complete supporting records.
• Update daily price revision records to keep pricing data current.
• Consolidate and verify invoices and tax invoices before submission to Finance.
• Provide clean, structured raw sales data for analysis across teams.
• Validate data, maintain documentation, and coordinate with cross-functional teams.

Skills

Excel advanced

Data analysis

Cross-functional coordination

Attention to detail

Education

Diploma (D3) or Bachelor's degree

Business/Management/Accounting focus

Tools

MS Excel

Job description

Monitor and prepare daily Modern Trade (MT) sales reports to ensure sales performance is tracked accurately and consistently.

Filter, process, and consolidate sales data from various sources, including B2B systems and daily sales reports from distributors.

Maintain sales dashboards and pivot reports covering sales performance by account, Purchase Order (PO), daily store sell-out, and product to support effective sales monitoring.

Provide sales data and analysis to support PPL requirements and promotional program evaluations.

Support the preparation and administration of Modern Trade claim documents, ensuring all supporting documents are complete and accurate.

Compile and update daily price revision records to ensure pricing data remains accurate and up to date.

Consolidate invoices and tax invoices, ensuring all supporting documents are complete before submission to the Finance team.

Provide accurate and well-structured raw sales data to support analysis and reporting needs across relevant teams.

Perform data validation, maintain organized documentation, and coordinate with cross-functional teams to ensure smooth sales administration processes.

Minimum Diploma (D3) or Bachelor's degree (S1) in any field, preferably in Business Administration, Management, Accounting, or a related discipline.

Minimum 1 year of experience in Sales Administration, Sales Reporting, Data Administration, or a similar role. Experience in the Modern Trade channel is an advantage.

Proficient in Microsoft Excel, particularly Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, IF functions, and large-scale data processing.

Able to filter, consolidate, validate, and analyze sales data from multiple sources.

Experienced in creating structured, accurate, and easy-to-understand sales dashboards and reports.

Familiarity with invoice administration, tax invoices, price revisions, and claim documentation is an advantage.

Detail-oriented, analytical, well-organized, and able to coordinate effectively across teams.

Able to work independently, manage multiple tasks, and meet daily reporting deadlines.