Short Description

This report shows you the gross profit per sold item within a definable time period.

Go to Controlling > Reporting and create a profile (the report Gross Profit is located in the Sales report group). Then generate the report (Procedure: Report_GrossProfit).

Available Parameters

The following parameters are available in this report:

From - To: Define the time period for the report.
- The To date must not be the current day; otherwise, only the following individual item entries will be listed:
  - ZZZ Vouchers
  - ZZZ Shipping Costs
  - ZZZ Manual Invoice without Items
Shop: Select the shop to be evaluated. If no shop is selected, all shops will be included.
Category: You can select a specific category for the report. If no category is selected, all categories will be shown.
Supplier: You can select a specific Supplier for the report. If no supplier is selected, all suppliers will be included.
Tag1/2/3: Enter up to three Tags to filter the report for specific item tags.

Columns

Sales (Avg.)
- Sales: Shows the sold item quantity in the selected time frame.
- Selling Price: Shows the average selling price of all sales in the selected time frame.
- VAT: Shows the average VAT amount of all sales in the selected time frame.
- Supp. Price: Shows the average supplier price of all sales in the selected time frame.
Returns (Avg.)
- Returns: Shows the returned item quantity in the selected time frame.
- Selling Price: Shows the average selling price of all returns in the selected time frame.
- VAT: Shows the average VAT amount of all returns in the selected time frame.
- Supp. Price: Shows the average supplier price of all returns in the selected time frame.
Single Gross Profit: Shows the single gross profit of the item. It's calculated as follows:
Selling Price (Sales) - VAT (Sales) - Supp. Price (Sales)
Total Gross Profit: Shows the total gross profit of the item. It's calculated as follows:
Single Gross Profit * Sales - ( Selling Price (Returns) - VAT (Returns) - Supp. Price (Returns) ) * Returns
Curr.: Shows the used currency code.

Additional Information

Sales prices include VAT, purchase prices exclude VAT.
The totals of the columns Sales Price (VK), VAT, and Supplier Price (EK) under Sales & Returns (Average) are already multiplied by the item quantities for sales or returns.
The values in the Supplier Price (EK) column reflect the Historic EK.
If multiple Suppliers are assigned to an item, the supplier is displayed based on the Historic EK principle. Deactivated suppliers may also appear in the report.
Since shipping costs, manual invoices/credits, and discounts/vouchers cannot be assigned on an item level, they are listed at the end of the report as separate item entries:
ZZZ Vouchers
ZZZ Shipping Costs
ZZZ Manual Invoice without Items
An exchange is treated as a return and is listed in the Returns column.