Open Reports, tab Stock value on a date, and choose the date. The report lists each product with the quantity it had at the end of that day, its average cost and its value, and gives the total.
- Open Reports and the tab Stock value on a date.
- Choose the date, for example the last day of your financial year. The last day of the period chosen is used.
- Read the list: product, quantity, Avg cost and Value. The total is at the bottom.
- Export it for your accountant.
How it is worked out
- The quantity on that date is today’s quantity with every later movement undone.
- The value uses the weighted average cost: each delivery received changes the average, at its cost including freight and other costs spread over it: see How do I add freight, customs and other costs to the cost of the goods (landed cost)?.
- Products without stock tracking are not in the list.
Good to know
- Today’s value is also in Inventory, button Valuation.
- For a year-end figure the accountant can rely on, do a stock take close to the date, so the quantities are counted and not only calculated.
- Other valuation methods (first in first out, lower of cost or market) are the accountant’s work, starting from this list.
For: Owner Accountant since version 1.0.31
Did this help?
Thank you. Your answer helps us improve the help.