What was my stock worth on a past date, such as the end of the year?

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.

  1. Open Reports and the tab Stock value on a date.
  2. Choose the date, for example the last day of your financial year. The last day of the period chosen is used.
  3. Read the list: product, quantity, Avg cost and Value. The total is at the bottom.
  4. Export it for your accountant.

How it is worked out

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?

Print this article · Contact support