Order Profit Detail Report

The Order Profit Detail Report shows a line-item level profit breakdown per invoice - one row per product line within each order.

⚙️ How It Works

This report goes one level deeper than the Sales Report. Instead of one row per invoice, it shows one row per product line within each invoice.

This makes it easy to identify exactly which products are dragging down GP on a given order. If the Sales Report flags a low-margin invoice, this report tells you which line items caused it.

🔍 Filters

• Date range - defaults to the current month

📋 What You'll See

Each row represents a single product line on an invoice:

• Invoice Number

• Project

• Client

• Product Code

• Description

• Units

• Unit Cost

• Unit Selling

• Total Cost

• Total Selling

• Total GP

• GP%

💡 When to Use This Report

This report is useful for:

• Drilling into GP problems flagged by the Sales Report

• Auditing product-level margins on specific orders

• Reviewing pricing accuracy across product lines

• Identifying products that are consistently sold at low margins

✅ Summary

• Shows one row per product line per invoice for granular profit visibility

• Use this alongside the Sales Report to move from high-level GP concerns to specific line items

• Helps identify exactly which products are affecting profitability