Apple Numbers Sales Tracker

I need a clean, easy-to-use Apple Numbers spreadsheet built completely from scratch that lets me monitor my business performance month by month. The file should capture Sales, Cost of Goods Sold, Shipping, Profit, and P&L percentages on dedicated columns so I can enter figures quickly after each sales period.

For visibility, I want a chart that automatically plots Total Sales for every month and updates itself as soon as new data is entered, letting me spot trends at a glance. Though Total Sales is the headline metric for the chart, the sheet itself still has to calculate and display Profit and P&L percentages beside each month’s line so I can check margins instantly.

To keep everything organised, please structure the workbook so I can scroll through the year on one sheet yet still have a tidy summary or dashboard at the top (or on a second tab if that’s cleaner). Feel free to add dropdown months, conditional formatting, or other small touches that make entry and review painless—but nothing that complicates future edits. I have no existing template, so the layout, formulas, and formatting are all yours to design.

Deliverable:
• One Apple Numbers file with working formulas, an auto-updating monthly Total Sales chart, and clear instructions for adding new months or categories if needed.