This template records every sale in one log. The Sales tab holds one row per sale, with its date, month, product, region, customer, units and amount. The Targets tab holds the sales target for each month.

The Dashboard totals sales, units and progress against target, then shows sales by region and each month's target against actual sales, with charts. It suits a small sales team that reports monthly.

It comes with sample data. Make a copy, then replace the sample rows with your own sales and targets. Formulas, dropdowns and charts update on their own.