Gross Margin by Product Line (12 Months) – Excel Template

Enter monthly sales and cost of sales for each product line and see gross profit and margin per month and for the year, with lines below target highlighted.

• Automatic summary: Total sales, Total gross profit, Overall gross margin, Months below target
• Calculated for you: Gross profit, Gross margin, Status
• Drop-down menus for quick, consistent entry
• Colour-coded status and progress highlights
• Built-in chart that updates as you type
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.