How to access it:
Go to www.ebriza.com → Menu → Reports → Analytical Stock Balance.
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.
On the right, from the three dots, you choose whether the report includes movements from inventories ("Show inventory movements") and from resets ("Show reset movements"). Both are ticked by default. From the same place you choose how the "Final balance" column is calculated (see below) and download the report (Excel or CSV).
Why doesn't Initial balance + incoming − outgoing equal Final balance?
For each item, the report shows numbered columns: 4 Initial stock, 5 Incoming, 6 Outgoing, 7 Final stock, 8 Average purchase cost, 9 Initial balance, 10 Incoming value, 11 Outgoing value, 12 Final balance.
The quantities always add up: Final stock (7) = Initial stock (4) + Incoming (5) − Outgoing (6).
By default, the "Final balance" value (12) is calculated as Final stock × Average purchase cost (7 × 8). The formula appears right in the column header: "12=7*8". This is NOT the same as Initial balance + Incoming value − Outgoing value (9 + 10 − 11). The two results differ whenever the average purchase cost changed during the selected period, for example after a goods receipt at a different price.
If you want the final balance to be exactly initial balance + incoming − outgoing, tap the three dots on the right and choose "12 = 9 + 10 - 11".
Before you compare the figures, check two more things:
- The report is for a single warehouse, the one selected at the top, in Administration. If you have several locations, do not add up figures from different reports. Generate the report for each warehouse separately.
- Inventories and stock resets are included by default: surpluses appear under "Incoming", shortages under "Outgoing". If you expect to see only goods receipts and sales, untick "Show inventory movements" and "Show reset movements" in the three-dot menu.
If the figures still do not add up after these checks, write to us. Send the item, the warehouse, the period and the figures in columns 4–12.How much raw material did I consume (quantity and value)?
To see raw materials only, set the “Tip” (Type) filter to “Materie primă” (Raw material) ONLY and untick “Marfă” (Goods). Otherwise raw materials are mixed with goods.
Consumption for the selected interval is the “Ieșită” (Outgoing) column, by quantity and by value. The value is at average acquisition cost. For a single day’s consumption, set the interval to that day.
This is a standard report. You do not need filters or tags in Gestiune → Istoric (Stock history), the Insights app or a custom report. To see the products you sold and what they cost, not the raw materials, use the Profit report (Reports → Sales → Profit).
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.
Why don't the entries in the Balance match the NIR Summary?
The two reports do not measure the same thing. The NIR Summary (Reports → Accounting) contains only receptions, that is the NIRs. The "Entered" column in the Analytical Stock Balance contains everything that increased stock in the chosen period: receptions (NIR), but also transfers received from other warehouses, production, products from cancelled orders that went back into stock, and surpluses from inventories and resets. When you have such movements, it is normal for the Balance to show more than the summary.
To compare the two reports correctly:
• Choose a single month, the same in both reports (for example 1–31 August). The NIR Summary opens on the last 30 days, not on the previous month, so change the "Date" filter.
• Use the same warehouse in both. Both reports show the location selected at the top.
• In the Balance, from the three dots on the right, uncheck "Show inventory movements" and "Show reset movements". This way you see "Entered" without the surpluses from inventories and resets. Compare the figures with the options checked and then unchecked: what disappears is the part that comes from inventories and resets.
• Compare the values without VAT. The Balance is without VAT, and in the summary the matching column is "Total purchased", not "Total purchased with VAT".
• Note whether the difference appears only for some items or for all of them. For an item that had a received transfer, production or a cancelled order during the month, the difference from the NIRs comes from there.
If the difference remains after these checks, write to us and send: the month, the warehouse, the items where you see the difference (or "all") and the figures from both reports.
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, final balance, balance does not add up, initial balance plus incoming minus outgoing, 12=7*8, 12=9+10-11, stock value, stock quantity, stock value, stock at a certain date, stock at selling price, stock value with VAT, selling price in reports, weighted average cost, closing balance, balance does not add up, opening balance plus entries minus exits, 12=7*8, 12=9+10-11, NIR summary, balance does not match NIRs, balance entries vs NIR, balance NIR summary differences]