Inventory details report in Reckon One

Learn how to run and customise the Inventory details report in Reckon One, so you can see the details of inventory transactions, showing movement in quantity, cost, value, and average cost of items.

Before using the report

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

About the Inventory details report

The Inventory details report shows the details of transactions involving inventory items. It shows changes in quantity, cost, value, and average cost of items and is useful for:

• tracking inventory levels
• evaluating inventory item profitability and movement
• reviewing the financial value of stock.

Run the report

1. In the Reporting menu, select Reports.
2. Click on the Inventory details report (found in the Inventory category).
3. Select your Reporting period (the date range you wish to see data for).
4. In Items, choose All to show transactions 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

To customise the information shown in your report and sort and filter data:

1. In the Reporting menu, select Reports.
2. Click on the Inventory details 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

To filter by item:

1. In Items, select:
   1. All to show all items
   2. Selected to choose specific items to show.

Filter by Contact

To filter by Contact:

1. In Contacts, select:
   1. All to show all items
   2. Selected to choose specific contacts to show.

Filter by Project

To filter by Project:

1. In Projects, select:
   1. All to show all items
   2. Selected to choose specific projects to show.

Filter by classification

If you have the classifications feature turned on, you can filter by classification:

1. In Classifications, select:
   1. All to show all classifications
   2. Selected to choose specific classifications to show. This will show a list of all classifications, along with the option to select No classification if you wish to show items that don't have a classification assigned.

Filter by transaction type

You can filter by transaction type:

1. In Transaction type, select:
   1. All to show all transaction types
   2. Selected to choose specific transaction types to show.

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.

Group transactions in the report

You can group transactions in the report by item, contact, item classification, or project:

1. In Group by, select one of the options:
   1. Item
   2. Contact
   3. Classification, if using Classifications. This will group transactions by item classification.
   4. Project, if using Projects

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).

Read more

• Learn more about reports in Reckon One