Invoice Report Profit/Loss
This new Profit/Loss view provides a clear snapshot of your invoicing performance across different sales channels (referred to as "origins"). It helps you quickly assess revenue, costs, and profitability for a selected time period, making it easier to spot trends, high performers, and areas for improvement.
Report Overview
The Profit/Loss report displays data for completed and shipped sales that have been invoiced, excluding any voided, credited, or unallocated transactions. It focuses on non-shipping line items and uses your actual or moving average costs to calculate profitability.
"Non-Shipping Line Items"
In the context of the Profit/Loss report, "non-shipping line items" refers to the individual product or service entries on an invoice that represent actual goods sold (like items from your inventory), rather than any charges related to delivery or postage.
What's Included: The report calculates revenue, costs, and profits based solely on these product lines. For example, if an invoice has:
- £10 for a vape device (non-shipping line item → included).
- £5 for shipping (shipping line item → excluded).
Key Metrics Covered:
- Total invoiced amounts (revenue from sales).
- Discounts applied.
- Cost of Goods Sold (COGS).
- Gross Profit (invoiced revenue minus discounts and COGS).
- Profit Margin (gross profit as a percentage of invoiced revenue).
The report is grouped by origin, allowing you to compare performance across platforms like e-commerce sites, marketplaces, or direct retail.
Detailed Breakdown: The Data Table
| Column | Description | How It's Calculated |
|---|---|---|
| Origin | The sales channel or platform (e.g., marketplace or website). | Pulled from your origin setup in the system. |
| Invoices | Total invoiced revenue from non-discount line items. | Sum of (cost per unit × quantity) for standard sales lines. |
| Discounts | Total value of discounts applied. | Sum of absolute (cost per unit × quantity) for discount-only lines. |
| Cost of Goods | Total cost of items sold (COGS). | Sum of (actual cost or moving average cost × quantity), based on inventory records at the time of sale. If no moving average is available, it defaults to actual cost (AC). |
| Gross Profit | Net earnings after discounts and costs. | Invoices - Discounts - Cost of Goods. |
| Margin | Profitability as a percentage. | (Gross Profit / Invoices) × 100. If invoices are zero, margin shows as 0%. |