Sales Report with Visual Charts

I need a concise yet insightful sales report that zeroes in on performance by each salesperson. You’ll receive raw daily transaction files (CSV) from our point-of-sale system; your task is to clean that data, aggregate totals for the period I specify, and present the results in a reader-friendly format alongside clear charts or graphs.

Please build everything in Excel, Google Sheets, or another widely accessible tool so we can refresh the numbers later. Include the formulas, pivots, or lightweight dashboard needed for automatic updates when new data is pasted in.

Deliverables
• One editable file containing the cleaned dataset, calculations, and visualisations
• A PDF export ready to share with store management
• Brief hand-off notes on how to refresh the report

The figures for a sample period I provide must match to the cent, and the visuals must reflect those totals accurately.