This template keeps a log of customer orders. The Orders tab holds one row per order, with the customer, product, quantity, price, total, dates and status. The total works out from quantity and price, and rows that are running late are highlighted.

The Products tab lists what you sell, with the number of orders, units and value for each product. The Dashboard shows the number of orders, the value still to deliver and how orders split by status and by product.

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