Inventory valuation summary report in Reckon One

Learn how to run and customise the Inventory valuation summary report in Reckon One, so you can see the value of stock on hand.

Before using the report

This report is only available if you have turned on inventory in your book.

About the Inventory valuation summary report

The Inventory valuation summary report shows the total value of stock on hand, broken down by item. It helps you to:

• see the total value of inventory at a specific point in time, assisting in the calculation of Cost of goods sold and ending inventory for financial statements
• analyse inventory trends to make decisions.

You can drill down on any item in the Inventory valuation summary report to see an Inventory details report filtered for that item.

Run the report

1. In the Reporting menu, select Reports.
2. Click on the Inventory valuation summary report (found in the Inventory category).
3. Select your Reporting period (the time range you wish to see data for).
4. In Items, choose All to show data for all items and Selected to choose specific items.
5. (Optional) To customise the report further (including sorting, filtering and choosing data to show), click Show more options.
6. Click Refresh to update the report with your selections.

Customise your report

You can customise the information shown in your report, and sort and filter data:

1. In the Reporting menu, select Reports.
2. Click on the Inventory valuation summary report (found in the Inventory category).
3. Click Show more options.
4. Once you've made your customisations, click Refresh to update the report.

Filter by item status

You can filter by item status:

1. In Status, select:
   1. Active to include active items
   2. Inactive to include inactive items.
   Select both if you wish to show active and inactive items.

Show or hide columns

To show or hide columns in the report:

1. In Columns, select checkboxes against the columns you want to show.

Choose report orientation

1. In Orientation, choose whether you wish the report to show in portrait or landscape (your selection will also apply when exporting the report).

Drill down to the Inventory details report for a specific item

To drill down from the Inventory valuation summary report to the Inventory details report for an item, click on the Quantity on hand or the Asset value of the item.

Read more

• Learn more about reports in Reckon One