Profit report

This article helps you understand and use the Profit Report to get a complete overview of the profitability of your sold goods.

What is the Profit Report?

The report provides insight into the financial performance of your products over a selected period. It calculates the difference between your purchase price and your selling price.

How the figures are calculated

The report uses a standard formula to ensure accurate results:

Profit = (Selling Price exc Vat - Cost price) x Amount of sold units

Prerequisites for Accurate Data

Purchase Price Requirements

For the report to be meaningful, all products must have a registered purchase price greater than Zero. If this is missing, the calculation will be incorrect.

Historical Price vs. Current Price

By default, the report uses the purchase price currently listed on the product card.

If you want a more accurate historical overview, select the option Cost Price from order lines. The system will then retrieve the price registered on the product at the exact time the sale was made, regardless of any subsequent price changes.

Customization and Filtering

To make the report relevant to your needs, you can filter the data based on several criteria:

1. Grouping and Categories

You can narrow down the view by selecting specific:

Customer groups
Manufacturers
Categories
Order statuses

2. Date Selection

Choose to view figures based on specific order dates or invoice dates within a custom time interval.

3. Advanced Display Options

You have the option to show or hide fields such as:

Value Added Tax (VAT)
Debt
Sub-stores
Product bundles
Hiding line items with values below a custom threshold

Report Content

For each product in the list, you will see a detailed overview of:

Quantity: Total units sold during the period.
Purchase Price: The cost price of the item.
Selling Price: The price the item was sold for (excluding VAT).
Profit: The actual amount earned per product.
Profit Margin: The percentage of the selling price that is profit.

At the bottom of the overview, you will find a summary showing the total profit for all products in the selection.

Exporting Data

If you need to process the figures further in other tools, you can easily export the overview. Click the Export button in the top right corner to download an Excel file ready for use.