Historical stock reporting

Explaining opening and closing stock and where to view them

Jansen avatar
Written by Jansen
Updated over a week ago

If you need to report on your historical stock, there are a number of options that can provide you with the information you need - particularly the Stock History report and the Inventory KPIs report.

The Stock History report displays stock levels and values for the beginning and end of each month. If you need a more granular report, you can use the Inventory KPIs report to filter for particular dates, and use the details popup to obtain even further insights into historical stock value.

Note: Historical stock information is available starting from when your Inventory Planner account was first connected to your platform. You can import stock history to populate metrics prior to the initial connection date.

Stock History report

The Stock History Report shows historical inventory levels. Inventory information including units, cost value, and retail value are shown on a monthly or weekly basis.

To view this report, go to Reports > Stock History. Learn more about the stock history report here.

Inventory KPIs report

Opening and closing stock

The "stock" column in your reports always shows a variant's inventory level as of the prior sync, regardless of the dates of your report.

To show historical stock information on the KPI report, you will need to add the "opening stock" and/or "closing stock" columns to your report. Opening stock reflects the inventory level as of the beginning date of your report, and closing stock displays the inventory as of the ending report date. Both dates can be chosen using the date picker in the top right-hand corner of the page.

Related opening and closing stock metrics also correspond to the start and end dates of your report. These include:

Opening and closing stock cost

Cost value, or price paid to suppliers, for all stock available as of that date.

Note: Opening and closing stock is always based on historical cost prices. Contact support if you want to base the calculation on current cost prices.

Opening and closing stock retail

Retail value of stock, calculated as price × stock on that date.

Note: Opening and closing stock retail is always based on historical retail prices.

Opening and closing stock gross

Gross value of stock for a particular date, calculated as regular price × units on hand. Regular price is the retail price before any discounts are applied.

Note: Opening and closing stock gross is always based on historical regular retail prices.

Generating a stock report using Inventory KPIs

Go to the Inventory KPI report in the menu on the left and configure it as follows:

Warehouse

Choose the warehouse (location) you would like to report on.

Tip: If you need to generate a company-wide report that would aggregate information from multiple warehouses, create a combined warehouse. Learn how to create a combined warehouse.

Dimensions

Choose how detailed you want the report to be (or what dimension you'd like to report on). To see a warehouse-wide report, select "Total".

Check out our Inventory Planner 101 article to find out more about each of these options.

Date range

Use the date picker In the upper right corner to choose the date range for your opening and closing stock.

For example if you are generating a year-end stock valuation report, you should select an ending date of December 31 for the prior year.


Columns

Click on the gear icon to view the column options.

Select Opening Stock and Closing Stock to add them to your report. Opening and Closing Stock will show inventory levels. Opening and Closing Stock Cost, Retail and Gross can be added to show financial information. (See detail above or the Glossary of Terms to learn more about these metrics.)

The Opening Stock and Closing Stock figures are synced separately, which may result in differences between one month's closing stock and the next month's opening stock. For example, the closing stock for May would be captured during the nightly sync on the 31st of May (or during a full sync, if performed later on the same day), while the opening stock for June would be captured during the nightly sync on the 1st of June.

Note: The "Stock" column will always show your current inventory level as of the most recent sync, regardless of the dates of your report.

Viewing the report

Once you've selected your columns, click the gear icon again to collapse the column options. The opening and closing stock figures are now present on your report.

Historic stock levels and cost value as a graph

On the Inventory KPIs report, make sure you're filtering for "Total" variants over your required date range, then click the Details icon.

View the Stock and sales tab to see stock levels and stock cost over the date range of your report.

Hover over the chart to see the value on a particular date.

If you'd like to see the historic cost price per unit, use the Variant view of this report instead of the Total view. When hovering on this chart, you'll also see the cost price on that date.

You can also download these graphs by clicking the hamburger icon on the top right-hand side. This menu will allow you to print the graph, as well as export it in the following formats:

  • PNG

  • JPEG

  • PDF

  • SVG

Additionally you can download the data points as a CSV or XLS spreadsheet, or just view the data within the modal window by clicking "Show data table".

Did this answer your question?