Sales Executive

Bulan Bintang Clothing Sdn Bhd; Bandar Baru Bangi; On-site; MYR 45,000 - 78,000; Full time

Job summary

Bulan Bintang Clothing Sdn Bhd seeks a Sales Reporting Executive to collect, consolidate, analyse, and report sales data for all retail outlets. You will support management with timely daily, weekly and monthly reports to monitor performance and inform decisions.

The role requires strong analytical skills, attention to detail, and the ability to coordinate with outlet teams to ensure accurate reporting.

Qualifications

• Diploma or Bachelor's Degree in Business Administration, Accounting, Finance, Statistics, Data Analytics, or related field.
• Fresh graduates may apply; experience in sales reporting, retail operations, or data administration is an advantage.
• Proficient in Microsoft Excel or Google Sheets.
• Good knowledge of Excel formulas, PivotTables, VLOOKUP/XLOOKUP, and data consolidation.
• Experience with POS systems, retail sales reports, or business intelligence tools is an advantage.
• Strong numerical, analytical, and problem-solving skills.
• High attention to detail and accuracy when handling sales data.
• Able to manage multiple reporting deadlines and large volumes of information.
• Good communication skills and ability to coordinate with multiple outlets.
• Responsible, organised, systematic, and able to work independently.

Responsibilities

• Collect and consolidate daily sales data from all retail outlets.
• Ensure sales figures, transaction records, and outlet submissions are accurate and complete.
• Verify sales data against POS systems, outlet reports, and other relevant records.
• Identify discrepancies, missing information, or unusual sales figures and follow up with outlet teams.
• Maintain and update sales databases, tracking sheets, and reporting files.
• Prepare and distribute daily sales reports for all outlets.
• Consolidate weekly and monthly sales performance reports for management review.
• Monitor actual sales against targets for each outlet and highlight achievement percentages.
• Prepare outlet-by-outlet sales comparisons and identify high-performing and underperforming outlets.
• Ensure all reports are accurate, properly formatted, and submitted within the required deadlines.
• Prepare ad hoc sales reports as requested by management.
• Analyse sales trends, outlet performance, and sales growth over different reporting periods.
• Compare current sales performance against previous days, weeks, months, and corresponding periods where relevant.
• Track key sales indicators, including total revenue, transaction volume, average transaction value, and sales target achievement.
• Identify significant changes in sales performance and highlight potential contributing factors.
• Provide insights and recommendations to support management's sales planning and decision-making.

Skills

Sales data analysis

Microsoft Excel

Data interpretation

Attention to detail

Time management

Cross-departmental communication

Data confidentiality

Education

Diploma/Bachelor's in Business/Analytics/Finance

Tools

Excel/Google Sheets

POS systems

BI tools

Job description

Department: Sales

Reports To: Sales Manager / Retail Manager

Employment Type: Full-Time

1. Job Summary

The Sales Reporting Executive is responsible for collecting, consolidating, analysing, and reporting sales data across all retail outlets. This role ensures the accuracy and timely preparation of daily, weekly, and monthly sales reports to support management in monitoring sales performance, identifying trends, and making informed business decisions.

The position requires strong analytical skills, attention to detail, and the ability to manage large volumes of sales data while coordinating with outlet teams to ensure accurate and consistent reporting.

2. Key Responsibilities

A. Sales Data Management

• Collect and consolidate daily sales data from all retail outlets.
• Ensure sales figures, transaction records, and outlet submissions are accurate and complete.
• Verify sales data against POS systems, outlet reports, and other relevant records.
• Identify discrepancies, missing information, or unusual sales figures and follow up with the relevant outlet teams.
• Maintain and update sales databases, tracking sheets, and reporting files.

B. Daily, Weekly & Monthly Sales Reporting

• Prepare and distribute daily sales reports for all outlets.
• Consolidate weekly and monthly sales performance reports for management review.
• Monitor actual sales against targets for each outlet and highlight achievement percentages.
• Prepare outlet-by-outlet sales comparisons and identify high-performing and underperforming outlets.
• Ensure all reports are accurate, properly formatted, and submitted within the required deadlines.
• Prepare ad hoc sales reports as requested by management.

C. Sales Performance Analysis

• Analyse sales trends, outlet performance, and sales growth over different reporting periods.
• Compare current sales performance against previous days, weeks, months, and corresponding periods where relevant.
• Track key sales indicators, including total revenue, transaction volume, average transaction value, and sales target achievement.
• Identify significant changes in sales performance and highlight potential contributing factors.
• Provide insights and recommendations to support management's sales planning and decision-making.

D. Sales Target Monitoring

• Track daily, weekly, and monthly sales targets for each outlet.
• Monitor each outlet's progress towards achieving its assigned sales targets.
• Calculate sales achievement percentages and sales gaps against targets.
• Highlight outlets that require attention based on their sales performance.
• Prepare sales performance summaries for management meetings.

E. Outlet Coordination & Follow-up

• Liaise with outlet managers and relevant teams to obtain timely sales data and resolve reporting discrepancies.
• Follow up on late submissions, incomplete reports, and unusual transactions.
• Communicate reporting requirements and deadlines to outlet teams.
• Coordinate with the finance, retail operations, and sales teams when sales figures require verification.

F. Dashboard & Reporting Improvement

• Develop and maintain sales tracking spreadsheets, dashboards, and reporting templates.
• Use Microsoft Excel or Google Sheets to consolidate and analyse sales data.
• Use formulas, pivot tables, charts, and other reporting tools to improve efficiency and accuracy.
• Identify opportunities to automate repetitive reporting tasks and improve data management processes.
• Ensure sales reports are organised, updated, and accessible to authorised personnel.

G. Administrative & Other Responsibilities

• Maintain proper documentation and records of sales reports.
• Ensure the confidentiality and integrity of company sales data.
• Support management with sales data analysis for promotions, campaigns, and outlet performance reviews.
• Perform other sales reporting and data-related duties assigned by management.

3. Job Requirements

• Diploma or Bachelor's Degree in Business Administration, Accounting, Finance, Statistics, Data Analytics, or a related field.
• Fresh graduates may apply; experience in sales reporting, retail operations, or data administration is an advantage.
• Proficient in Microsoft Excel or Google Sheets.
• Good knowledge of Excel formulas, PivotTables, VLOOKUP/XLOOKUP, and data consolidation.
• Experience with POS systems, retail sales reports, or business intelligence tools is an advantage.
• Strong numerical, analytical, and problem-solving skills.
• High attention to detail and accuracy when handling sales data.
• Able to manage multiple reporting deadlines and large volumes of information.
• Good communication skills and ability to coordinate with multiple outlets.
• Responsible, organised, systematic, and able to work independently.

4. Key Performance Indicators (KPIs)

• Reporting Timeliness: Daily, weekly, and monthly reports submitted within the agreed deadlines.
• Data Accuracy: Accuracy and consistency of consolidated sales figures.
• Report Completeness: All outlet sales data collected and included in the reports.
• Discrepancy Resolution: Timely follow-up and resolution of missing or inconsistent sales data.
• Reporting Efficiency: Effective preparation and maintenance of sales reports and dashboards.
• Data Analysis Quality: Ability to identify sales trends, performance gaps, and significant changes.
• Outlet Coverage: Complete and consistent sales reporting for all assigned outlets.

5. Skills & Competencies

• Sales data consolidation and analysis.
• Microsoft Excel and spreadsheet management.
• Sales reporting and dashboard preparation.
• Numerical accuracy and attention to detail.
• Data interpretation and problem-solving.
• Time management and deadline management.
• Cross-departmental communication.
• Confidentiality and data integrity.

6. Working Conditions

• Full-time position.
• Primarily office-based.
• Regular coordination with retail outlets and internal departments.
• Requires adherence to daily, weekly, and monthly reporting deadlines.

7. Schedule:

• Monday to Friday, 10am - 6pm
• Saturday (based on company need)