Neuton Auto - Sales Dashboard

Monthly Sales Trend

Sales Forecast (Next 6 Months)

Method: Show:

Month	Forecast (RM)	Method	Confidence

Invoice vs Cash Sale Split

Sales by Day of Week

Month: Year:

Daily Sales Chart

Date	Day	Invoice (RM)	Inv #	Cash Sale (RM)	Cash #	Combined (RM)	vs BE/day	vs Personal/day	vs Stretch/day

Year:

Weekly Sales Trend

Week	Period	Invoice (RM)	Inv #	Cash Sale (RM)	Cash #	Combined (RM)	Active Days	vs BE/wk	vs Personal/wk	vs Stretch/wk

Monthly Comparison

Year-over-Year Comparison (Same Month vs Different Year)

View:

Month	2024 (RM)	2025 (RM)	2026 (RM)	2025 vs 2024	2026 vs 2025

Month	Invoice (RM)	Inv #	Cash Sale (RM)	Cash #	Combined (RM)	Avg/Day	Target Status	% of BE	% of Personal	% of Stretch

Filter: Year:

Date	Day	Type	Notes

Vehicle Number Plate Search

Type: Salesperson:

Date	Vehicle / Plate	Customer	Type	Salesperson	Doc No	Item	Qty	Amount (RM)

Salesperson Performance — 2026 YTD

Sales attributed by Agent on each invoice / cash sale. Jan–Jun 2026.

Monthly Combined Sales by Salesperson

Salesperson × Month — Combined (RM)

Product Sales Breakdown

Year: Category: Brand:

Products grouped by description / model (item codes are unreliable, so they're ignored).

Revenue by Category

Category Revenue Share

Month:

Top 15 Brands by Revenue

Brand → Model Breakdown click a brand row to expand its models

Brand / Model	Category	Units	Revenue (RM)	% share

Top Products

Model / Description	Brand	Category	Units	Revenue (RM)	Avg/mo

📈 Product Order Forecast

Group by: Category:

Forecast next-month units = weighted run-rate of recent complete months (May×0.5 + Apr×0.3 + Mar×0.2). Suggested order = forecast + 20% safety stock. Units from 2026 data; June is partial (to 23rd) so shown but not used in the run-rate.

Order Forecast

⬆ Upload & Update Sales Data

Upload your Invoice and/or Cash Sale Excel files (.xlsx/.xls) to automatically update the dashboard data. The system will process the files, detect the month, replace existing entries for that month, and rebuild all summaries.

📄 Invoice File

Excel file with columns: Doc No, Date, Customer, Total (inc), Cancelled, Qty, Remark 4

No file selected

📄 Cash Sale File

Excel file with columns: Doc No, Date, Customer, Total, Cancelled, Remark 4