Skip to main content

The Analytical Stock Balance

The Analytical Stock Balance report shows your stock both quantitatively and by value (in RON) at a specific date.

Written by Ionut

How to access it:

  1. Go to www.ebriza.comMenu → Reports → Analytical Stock Balance.

  2. Choose the desired date — the system displays the quantitative stock and the total value for that date.

Filtering and options:

  • You can filter by goods, raw materials, or by the tags added to stocks.

  • From the three dots on the right, you can include resets and inventories in the report; you also download the report (Excel or CSV) from there.

Important: this report differs from the Stock Management Report, which shows stock movements (initial balances, entries, exits) over an interval. For stock value at a date, use the Analytical Stock Balance.

Which price the stock is valued at: purchase cost, not sale price

The value shown in the Analytical Stock Balance is calculated at the purchase price, using the weighted average cost method (CMP) - that is, what the goods cost you, not what you sell them for.

There is no stock report in Ebriza that values stock at the sale price. Not the Analytical Stock Balance, not the Stock Management Report, not the Consumption report, not the Inventory, not the stock history and not the stock exports. There is no column, filter or setting that switches any of them to sale price.

The only document in Ebriza that shows the sale price of a stock item is the NIR (Goods Receipt Note), where you get both the sale price without VAT and the retail sale price, VAT included.

Even on the NIR, the sale price appears only for goods linked to a single sale product in the Product Catalog, where the goods are the only ingredient in that product's recipe (goods you sell exactly as you buy them). If the same goods are used in several recipes, or belong to a recipe with several ingredients, Ebriza cannot determine a single sale price for them and the columns stay empty. For raw materials it never appears.

If your accountant needs the stock value at sale price, the only option today is to download the NIRs for the goods concerned: Inventory - Receptions, the three dots next to the document, Print NIR. The Receptions list always opens filtered to the last 3 months, so for older documents widen the „Entry date" range manually.

For details about these columns, see the article „How is the NIR surcharge calculated?".

Alternatively, the total cost of a stock at the current moment is also visible from Management Premium → Stocks.

[value-based inventory, quantity-based inventory, stock value, inventory at a specific date, stock at sale price, stock value with VAT, sale price in reports, weighted average cost]

Did this answer your question?