How to access it:
Go to www.ebriza.com and log in.
Navigate to Menu → Reports → Profit (in the Sales Reports category).
Select the desired period.
How to sort by net profit:
Click the NET PROFIT column name — products are ordered descending, with the most profitable at the top. You can sort any column with measurable data ascending or descending by clicking its name.
For profit to be calculated correctly:
Products must be created correctly in the Nomenclature, with their selling price.
Entries (purchases) must exist for these products in the system.
Difference from the „Product Sales" report: the Product Sales report shows only sales per product for the selected period, without purchase cost or profit. For purchase cost and profit, use the Profit report.
Commercial markup: you can also see the markup per product directly from Nomenclature → Export products detailed, where the last column is the markup per product.
How many units of a product did I sell, and what did they cost me?
For each product sold in the selected period, the Profit report shows the quantity sold and the acquisition cost of that quantity. The columns are: Quantity sold, Total collected, Total discount given, Total collected without VAT, Acquisition cost without VAT and Net Profit (Net Profit = Total collected without VAT minus Acquisition cost without VAT).
For a product with a recipe (for example a cappuccino), the acquisition cost comes from the raw materials in its recipe, at their average acquisition cost. So “how many cappuccinos did I sell today, and at what cost?” is answered by that product’s row in the Profit report.
To see a single day, set the “Data” (Date) filter to that day. The report opens on “Today”. To look at one product only, use the “Produs” (Product) filter.
The Profit report is a standard report. You do not need the Insights app or a custom report. It only needs the Gestiune (Stock Management) or Gestiune Premium app, because without stock management there is no acquisition cost.
The acquisition cost is abnormally high for a period: how to find the cause
The acquisition cost in the Profit report comes from the quantity sold. For products with a recipe, it comes from the raw materials in the recipe, each at its average acquisition cost (CMP). A raw material's CMP is set by its receptions (Invoice entries from an NIR), by transfers and by production. A single wrong reception can raise a raw material's CMP many times over. Every product that uses it in a recipe then shows a high cost in the report, even if the price on the invoice was correct.
Start from the period where the cost looks abnormal, not from the price history:
In Reports - Sales - Profit, select exactly the days where the cost looks abnormal and click the Acquisition cost without VAT column to sort it in descending order. The products at the top of the list are the ones that pushed the cost up.
Open that product's recipe in Nomenclature. Each raw material shows its average acquisition cost. Look for the raw material whose cost per unit (pcs, kg, L, g) is unrealistic, for example an egg that costs tens of lei or a gram of an ingredient that costs several lei. Click the cost to see how that stock's CMP has changed over time.
Go to Stock Management - History and search for that raw material by name, without narrowing the date range. Filter on Input movements (Stock move: Input, Transfer entry, Production entry). The reception that raised the cost is the one with the unit price that stands out. A wrong reception can also be an old one: the CMP is reset only when the stock reaches 0, so it keeps affecting the cost until you correct it.
Open that reception's NIR (from Costs, the 3 dots on the invoice row, then Edit NIR) and look at the invoice line. The two most common causes are these. First: the wrong goods or raw material was chosen on the line, so a different product from the invoice was received on this stock item. Second: the quantity was entered in a different unit from the one the stock is kept in (for example pieces recorded as grams), so the price per unit comes out far too high.
Correct the line on the NIR and save. The exact steps are in the article "The goods entered stock at a different price than the invoice: why it happens and how to check?".
Do not look for the cause by comparing each item's lowest and highest purchase price over time. A price that changed a few months ago, or an item that was barely used in the period, does not explain a high cost on the days you are checking.
Can I see the profit made on an order?
The Profit report shows the profit for each product sold, not for each order. There is no report that shows the profit of a single order or a single receipt.
If you want to see the profit for a specific day, go to Reports → Sales category → Profit and set the "Date" filter to that day. For each product sold that day, the report shows the total amount collected, the purchase cost and the net profit. These are the day's totals per product, added up across all orders, not taken from one specific order.
[tags: How to find out my profit, profit of products, profit, abnormal cost, acquisition cost too high, high cost for a period, high food cost, wrong reception]
