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.com → Menu → 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 stock type — Good, Raw material, Consumable or Package — by the tags added to stocks, or by a filter you saved. You can select several types at the same time: the report shows every stock item that belongs to any of the selected types. If you select no type, the report shows all stock items.

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".

Note: if you show a month with "12 = 9 + 10 - 11", that month's final balance may no longer equal the next month's initial balance. Initial balance (9) is always calculated as stock × average purchase cost on the start date, the same logic as "12 = 7 × 8", whichever formula you choose. See the section "Why doesn't a month's Final balance equal the next month's Initial balance (in value)?".

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.

Why doesn't a month's Final stock equal the next month's Initial stock?

The two columns do not come from the same place:

- Final stock (7) of a month is calculated from that month's movements: Initial stock + Incoming − Outgoing.

- Initial stock (4) of the next month is the item's saved stock: the quantity remaining after its last movement before the start date. It is the same quantity you see in the "Remaining qty" (Cant. rămasă) column in Stock Management → History, on the item's last movement of the previous month. Initial balance (9) is that quantity multiplied by the average purchase cost at that date.

Normally the two quantities are equal. They can differ in two situations (for a difference in value, between Final balance and Initial balance, see the next section):

- You unticked "Show inventory movements" or "Show reset movements" in the three-dot menu. The month's final stock then leaves out inventories and resets, but the next month's initial stock still includes them. Tick both options again and compare.

- The item's saved stock no longer matches its movements. This can happen, for example, when several goods receipts (NIRs) dated in the past are entered in a different order than their dates: the NIR with the later date is saved before the one with the earlier date. From that document onwards, the saved stock may not contain the quantity of the earlier NIR.

How to recognise the second situation: the difference is in quantity (column 7 of the month versus column 4 of the next month), usually on one or a few items, and it remains after you tick both options. It is not an average-cost difference, so switching the final balance formula to "12 = 9 + 10 - 11" does not fix it: that option only changes column 12 of the month shown, and the next month's initial stock stays the saved one. Do not run an inventory or a stock reset just to make the figures match either.

What to do: note the item, the month's final stock, the next month's initial stock and the warehouse, and write to us. The Ebriza team corrects the item's saved stock.

Why doesn't a month's Final balance equal the next month's Initial balance (in value)?

Initial balance (9) is ALWAYS calculated as the stock on the start date × the average purchase cost on that date. This is the same logic as "12 = 7 × 8", and it does not depend on the formula you chose for column 12 (Final balance).

So the next month's Initial balance equals the previous month's Final balance only when the previous month is shown with "12 = 7 × 8".

If you show the previous month with "12 = 9 + 10 - 11", its final balance can differ from the next month's initial balance whenever the average purchase cost changed during that month. The reason: the outgoing value (11) is calculated at the average cost at the moment of each exit, not at the end-of-month cost.

What to do:

  • Open the balance for the month being closed and check which formula is selected for Final balance, in the three-dot menu on the right.

  • Show that month again with "12 = 7 × 8". Its Final balance total must equal the next month's Initial balance total (same warehouse, same type filters and same inventory and reset options).

  • If the figures still do not match, check the quantities first, as in the section above (Final stock 7 versus the next month's Initial stock 4). If you still cannot find the cause, write to us and send: the warehouse, the two months, the category (goods / raw materials) and the Final balance and Initial balance totals you see.

Which figures you use in your accounts, and with which formula, is for your accountant to decide.

Why does the Balance for a month that is already closed now show different values from the ones I gave my accountant?

The Balance is not saved when you print it. It is recalculated every time you open it, from the stock movements that exist at that moment. So the same month can show different values if, in the meantime, a movement in that month or before it has changed.

How the values are calculated:

  • Initial balance (9) = the quantity on the start date × the average purchase cost on that date. Today's average cost is not used.

  • Final balance (12) = by default Final stock × Average purchase cost (12=7*8), or Initial balance + Incoming value − Outgoing value if you chose "12 = 9 + 10 - 11" in the three-dot menu.

What can change the values of a closed month: a stock movement dated in the past that was added, corrected or deleted later, for example a corrected NIR. Such a movement recalculates the item's average purchase cost from its date onward, for every later movement in the same warehouse. As a result, the outgoing value, that month's final balance and the initial balance of the following months change as well.

Example: you print the Balance for September and hand it to your accountant. Then, in October, you correct the price on a September NIR. If you print the September Balance again, you will see new values. October's initial balance will no longer match the one you handed over. If it does not match the new September final balance either, see the section "Why doesn't a month's Final stock equal the next month's Initial stock?".

What you can do:

  • Check in Stock Management → History the movements of the items that show a difference, over that period. The average purchase cost shown on each movement is the one at the date of that movement. See also the article "How do I check the CMP of a stock over time?".

  • If you know a correction was made BEFORE you printed the Balance you handed over, that correction is already included in the figures you handed over and does not explain today's difference. In that case, or if you cannot find the movement that changed, write to us and send: the warehouse, the period, the category (goods / raw materials), the figure you handed over, the figure you see now and, if you know them, the items where the difference appears.

  • Which figures you use in your accounts for a month that is already closed is for your accountant to decide, once you know which movement changed.

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 did the balance of a month I already handed to my accountant change?

The Analytical Stock Balance does not keep a "snapshot" of past months. Every time you open it, the report is recalculated from the documents that exist in the warehouse at that moment. Each document counts in the month of its DATE, not in the month it was entered.

So the balance of a closed month changes if, after you handed over the report, someone enters a document dated in that month, for example:

  • a goods receipt (NIR) whose reception date is in the handed-over month, entered only the following month;

  • an inventory whose book (scriptic) date is in the handed-over month;

  • a stock reset dated in the handed-over month (for example on the first day of the month).

A document like that changes the closing balance of the handed-over month and, with it, the opening balance of the next month. That is why the next month's opening balance can match neither the figure you gave your accountant nor what you saw before.

What to check:

  • In Stock Management Premium → Receptions, set the "Entry date" filter to that month and compare the list of receptions with the one you sent to your accountant. Receptions that were not on the list you sent were added after the hand-over.

  • Check the inventories and stock resets dated in that month and ask yourself whether they already existed when you handed over the report.

  • To see how much of the difference comes from inventories and resets, open the balance for that month with "Show inventory movements" and "Show reset movements" ticked, then unticked (from the three dots on the right).

What to do next:

  • If the documents really belong to the handed-over month, send your accountant the report regenerated now for that month. The report always shows the current situation.

  • If a document was given a date in the handed-over month by mistake and actually belongs to the next month, correct its date: for a NIR, the "Reception date" field on the reception. Do not delete documents just to get the old figure back.

If you find no document added after the hand-over and the difference remains, write to us. Send the warehouse, the month, the category (goods or raw materials), the figure you gave your accountant and the date you handed it over.

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, balance changed after hand-over, month balance changed, balance sent to accountant, back-dated NIR, documents entered after month close, reset dated last month, opening balance does not match what I handed over, balance changed, last month's balance is different, final balance changed after closing, opening balance does not match previous closing balance, corrected NIR with past date, average cost recalculation, balance handed to accountant, final stock different from next month's initial stock, September final stock does not match October initial stock, last month's closing balance differs from this month's opening balance, quantity difference between months, NIRs entered out of order, saved stock, final balance differs from next month's initial balance, opening balance does not match closing balance in value, formula 12=9+10-11 initial balance, does the initial balance depend on the formula, initial balance at average cost]

Did this answer your question?