Stock valuation — Stock value as of any date, ready for year-end

Why stock value matters

Stock is an asset on the balance sheet, and at year-end it has to be valued as of the balance sheet date. For a retailer with thousands of items it is often one of the largest items, and the auditor wants to see both the figure and how it was calculated.

Ecombooster already has everything needed to calculate it: stock levels, stock transactions and purchase costs from suppliers and purchase orders. Stock valuation puts that together into a basis you can hand to your accountant.

Stock as it was, on any date

Choose a date and stock is calculated from the stock transactions, with quantity and value per product as they were then. The year-end value can therefore be produced in January or February, when the closing is actually done, instead of someone having to remember to take the figure on New Year's Eve.

The date refers to when transactions were registered in the system, not when goods physically moved. The page states this clearly, so nobody draws the wrong conclusion about a delivery registered a day late.

A cost basis you can explain

You choose what stock is valued at, and the choice is always printed on the report:

• Today's purchase cost, that is, what it would cost to buy the goods today.
• The cost at stock-in, the price on the purchase order line when the goods were received.
• Every row shows when its cost was recorded. Rows where the cost cannot be reliably determined, or where a recorded price is implausible, are flagged and counted in the report header, so a valuation figure never hides how it came about.
• Products bought in packs but sold individually are valued per unit, and fractional quantities are shown as they are.

A basis for your accountant

The export reproduces exactly what is on screen, with the same date, cost basis, filters and sort order.

• PDF — the document to hand over, with date, cost basis, totals and exceptions in the header and column headings on every page.
• Excel — quantity and unit cost are editable and totals are live formulas, so a corrected count or a negotiated price recalculates the grand total at once. The system's own total and the difference sit alongside, so the size of every adjustment is visible.
• CSV — for further processing in other tools.

Part of inventory management

Stock valuation builds on the same data as the rest of inventory management: stock locations, goods receipts, stock adjustments and stocktaking. Purchase cost is kept up to date as a weighted average as new deliveries arrive, so margins and stock value reflect what the stock actually cost. For the full picture of purchasing, stock and orders, see ERP features for ecommerce.

Who is it for?

Stock valuation is made for finance managers, CEOs and owners of ecommerce businesses who need a reliable stock value for year-end and audits, and for anyone who wants to answer what the stock was worth on a given date without counting by hand.

Ecombooster is not an accounting system. The stock value is produced here and handed to your accountant, where it is booked.

Frequently asked questions