Enhanced interface

Inventory Valuation report

This report displays a list of your inventory items, quantities available, item cost, and costing method for a specific time period. The total value of all items is the value of your inventory viewed on the balance sheet.

It provides a rich environment for conducting research into the trends of your inventory, so that you can make informed decisions about how best to handle your inventory.

The report is divided into summary and detail sections. In the middle of the report, the details section shows whats the transactions which impact what's on the shelf, the remaining columns provide summary information on the current item quantity and value in a warehouse.

When you generate entity-level valuation reports for companies using more than one currency, the report detail and summary sections only include transactions specific to the selected location.

How to use this report

Select the time period and types of items to include, specify how you want the report to appear, then use the filter criteria to look for exceptions. For example, you can instantly determine which items have not moved in a year so that you can have a deep-discount sale. This report also provides convenient links that let you drill down to the information page for any item in the list and to the transaction document itself.

If you allow negative inventory at the entity or warehouse level, and the quantity on hand is less than zero, the valuation reports the value as 0. To include the value of negative balances in the report, select the option, Show actual cost for negative balances.

Before running this report

Make sure that as quantities are reduced/increased, your transaction definitions accurately update corresponding values. Quanity/Value mismatches can be hard to detect, and it may take time for the value to accurately reflect the quantity.

If you see a discrepancy, generate a Running Average Cost report to identify any transactions without a match.

Subscription	Inventory Control
Regional availability	Australia, Canada, UK, USA, South Africa
User type	Business, Employee, Warehouse
Permissions	Inventory valuation: Run

View a monthly valuation report

Go to Inventory Control > All > Reports > Inventory > Valuation.
Select the As of date for the reporting period. If you don't specify a reporting period, Sage Intacct generates a report for the current month to date.
To view all results for the default reporting period, select View.

You can run this report without entering any filters; however, the report could take a long time to run and may return too many results to be useful.

To include or exclude specific types of data in the report, set filters such as item, UPC, warehouse, product line. As a general rule, to get fewer and more precise results in your report, set more filters.
Format the report. Format options vary from report to report. Generally, you can set the layout of the report and/or arrange how to group and display the data contained in the report.
Add title, subtitle, or footer text to your report.
To view, process, memorize, export, or customize the report or add it to the dashboard, select one of the following options:
- View: View the report now, in your browser.
- Print: Display the report now, in printable PDF format.
- Process & store: Generate the report and store it for later access. Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.
- Add to dashboard: Add the report to your dashboard.
- Memorize: Memorize (that is, save) the report so that later you can refer back to it or modify and re-run it.
  
  You can schedule memorized reports to run on a recurring basis. Intacct can automatically email the reports or deliver them to a cloud storage location.
- Export: Export the report to a separate file that you can then distribute or save to your local drive. File formats to which you can export the report data vary among reports.
- Customize: After you run the report, return to the main report page and refine the report further.
- Email: After you run the report, email to others.
Some options are only available if you access the report from the Reports center.

You can use trial-and-error to get the precise results you want. Just fill in the desired fields, and select View to see the report. If the results aren't what you want, select Customize to return to the report setup page and refine the report further. Repeat this process until you're satisfied.

For complex financial reports that will be run regularly, save the report after you're done setting it up. The next time you're ready to run the report, you only have to change the As of date before running the report.

Report filters

Use filters to focus the results of your report, to isolate and assemble just the data you want. You can set any combination of filters.

Set filters to fine-tune your report results

Select a Report on option to track items by either Item ID or UPC code:
- To track items by Item ID: Select Item ID, and then use either the From item and To item dropdown lists or the Operator and Value fields to specify the items to include in your report.
- To track items by UPC code: Select UPC, and then use either the From UPC and To UPC dropdown lists or the Operator and Value fields to specify the items to include in your report.
The Operator and Value fields help you filter on specific items.

For example, if you want a report on an item with the ID 800HGT453 but you only remember part of the ID, such as the HGT characters, select Contains from the Operator dropdown, enter HGT in the Value field, and select View. Intacct finds and displays all items where the Item ID contains the character string "HGT". If you select Includes or Excludes from the dropdown, the Value field can contain a list of values separated by commas.
How to use From and To fields
All From and To field pairs work the same way. Use them to get search results in as broad or as fine a range as necessary—from everything in the system to a single specific object.

To run this report for a single object:
1. From the From dropdown list, select the object that you want.
2. From the To dropdown list, select the same object.
To run this report for a specific range of objects:
1. From the From dropdown list, select the object that you want to begin the range.
2. From the To dropdown list, select the object that you want to end the range.
To run this report for all objects:
- Leave both From and To fields blank.
If you have a lot of objects or the report takes too long to process, use the From and To dropdown lists to run a series of smaller reports. For example, you can run 5 reports, one each for objects whose names begin with A-E, then F-J, K-O, P-T, and U-Z.

An object is a catch-all term that refers to any specific data item in the system. Customers, suppliers, items, and accounts are all examples of objects.
To show results for a specific product line, select the product line from the Product line dropdown list.
To show results for a specific warehouse or range of warehouses, use the From warehouse and To warehouse dropdown lists.
To get data for items based on a minimum value, a maximum value, or both, use the Minimum value and Maximum value fields. Enter a numeric value and then use the Min and max values apply to dropdown list to specify what the minimum and maximum values represent. In other words, define a range of values, and then specify what those values represent.
- Example 1: "Show me all my items that cost between $100 and $200." Enter $100 in Minimum value and $200 in Maximum value. Then, select Item unit cost from the Min and max values apply to dropdown. When you select View, the report lists those items whose cost is between $100 and $200.
- Example 2: "Show me everything with a value over $100,000, and then sort the resulting list in descending order by the last time one sold." Enter $100,000 in Minimum value. Next, select the Item value from the Min and max values apply to dropdown. Then select Date-of-last-activity descr from the Sort by dropdown.
- Example 3: "I need to liquidate all my inventory of items whose total value is $50 or less. What are they?" Enter $50 in Maximum value, and then select Item value from the Min and max values apply to dropdown. This process produces a list of all items that only total $50 when the same items are grouped together.
To specify what the minimum and maximum values represent, select a value from the Min and max values apply to dropdown list.
- Item value: Defines the minimum and maximum values as being the total for all the items. In other words, "Show me all the items whose total for that item is $100."
- Item unit cost: The unit cost is the item value divided by the quantity. In the case of the standard cost method, the unit cost equals the standard cost. However, with Average, FIFO, and LIFO costing methods, the unit cost is affected by the how much you paid for the item and may reflect a changing average cost.
- Item quantity: Defines the minimum and maximum values as being the quantity on hand. For example, "Show me all the items where there's 10 or less of each item."
- Item last cost: The most recent purchase price for the item.
- DLA days (Date or days since last activity). Defines the minimum and maximum values based on the days since the last activity
To determine how to display the time since the last type of activity, select an option from the Date of last activity is dropdown list. The time can be either in days or from a date, and the activities are Sold, Received, and Sold or receive. For example, "Show me all the items in Warehouse A and organize them by the number of days since I last sold one."
To see items that need to be reordered, select the Show items with zero quantities checkbox.
To see the actual cost of items with a negative valuation and not zero, select Show actual cost for negative balances.
Select Show quantities with a value in the summary to include transactions that affect only the value of the item in the summary, in addition to transactions that affect the quantity. The details section of the report always include transactions that impact the item's quantity and transactions that affect the value. Therefore, you might have a discrepancy between the summary and the details sections if the checkbox is cleared.
In multi-entity environments, you can also filter by location. Select the name of the region, country, state or territory, or city from the Location dropdown list.

For multi-currency entities, enter or select a location if you want to run this report at the top level.

Filter field	Description
Report on	Use to list the items in the report by either Item ID or UPC code. All items have IDs, but not all items have UPC codes.
From item, To item	Use to show results only for a specific item or range of items, such as items from A to F, or item numbers 3100 to 5000. Select items from these dropdown lists or UPC codes from the From UPC and To UPC dropdown lists, but not both.
Operator, Value	Use to filter results by using an operator For alphabetical lists, "greater than" means later in the alphabet, and "less than" means earlier in the alphabet. To search for all items from T through Z, search for "Greater Than" "S." To search for all items beginning with "A," search for "Less Than" "B." Most of the operators are self-explanatory. Others: Contains: You're searching for all items that contain a particular string of letters and/or numbers. Does Not Contain: You're searching for all items except those that contain a particular string of letters and/or numbers. Includes: You're searching for all items that contain two or more particular strings of letters and/or numbers. Does Not Include: You're searching for all items except those that contain two or more particular strings of letters and/or numbers . After selecting an operator, enter a value in the Value fields. Enter data in these fields or use the From item and To item fields, but not both.
From UPC, To UPC	Use to show results only for a specific UPC code or range of UPC codes. Select UPC codes from these dropdown lists or items in the From item and To item dropdown lists, but not both.
Operator, Value	Use to filer results by using an operator For alphabetical lists, "greater than" means later in the alphabet, and "less than" means earlier in the alphabet. To search for all items from T through Z, search for "Greater Than" "S." To search for all items beginning with "A," search for "Less Than" "B." Most of the operators are self-explanatory. Others: Contains: You're searching for all items that contain a particular string of letters and/or numbers. Does Not Contain: You're searching for all items except those that contain a particular string of letters and/or numbers. Includes: You're searching for all items that contain two or more particular strings of letters and/or numbers. Does Not Include: You're searching for all items except those that contain two or more particular strings of letters and/or numbers . After selecting an operator, enter a value in the Value field. Enter data in these fields or use the From UPC and To UPC fields, but not both.
Product line	Use to show results only for a specific product line.
From warehouse, To warehouse	Use to show results only for a specific warehouse or range of warehouses.
Minimum value, Maximum value, and Min and max values apply to	Use to filter data for items based on a minimum value, a maximum value, or both. You specify what those values represent in the Min and max values apply to field: Item value: The total for all of the items. For example, "Show me all the items whose total for that item is between $100 and $200. " Item unit cost: The item value divided by the quantity. For example, "Show me all the items that cost at least $100." For the standard cost method, the unit cost equals the standard cost. However, with Average, FIFO, and LIFO costing methods, the unit cost is affected by how much you paid for the items. Item quantity: The quantity on hand. For example, "Show me all the items where there's 10 or less of each item." Item last cost: The most recent purchase price for the item. DLA days: The number of days since the last activity. DLA is an acronym than means days or date since last activity. Use the Date of last activity field to specify how to display the time and for what. For example, "Show me all the items that have had activity in the last 30 days." You must specify a numeric value for the Minimum value and Maximum value fields. The Min and max values apply to field is only applicable if you specify a minimum value, maximum value, or both.
Date of last activity is	Enables you to specify how to display the time since the last type of activity in the Date of last activity column of the report. The time can be in either days or by date, and the activities are Sold, Received, or any (Sold or Received). For example, "Show me all of the items in Warehouse A and organize them by the number of days since I last sold one."
Show items with zero quantities	Use to include items that have no inventory (no quantity on hand) so that you can identify the items that need to be reordered. Note that your quantity on hand is only updated after the vendor invoice is received.
Exclude inactive items	Use to exclude inactive items from the report results. This option is particularly helpful if items were zeroed out and made inactive, but numbers are still appearing in the reports.
Exclude inactive warehouses	Use to exclude inactive warehouses from the report results. This option is helpful if warehouses were zeroed out and made inactive, but numbers are still appearing in the reports.
Show actual cost for negative balances	Use to see the actual cost instead of zero for items with a negative valuation.
Show quantities with a value in the summary	Use this checkbox to include transactions that affect only the value of the item in the summary in addition to transactions that affect the quantity. For example, you have a receipt for 10 items, which increases quantity, and an invoice for 5 items, which increases value. The transaction information for all 15 items is reflected in the summary. If the checkbox is cleared, only the transaction information for the 10 items that increase quantity is reflected in the summary. The details section of the report always includes transactions that impact the item's quantity and value. Therefore, you might have a discrepancy between the summary section and the details section if the checkbox is cleared.
Show transaction totals	Select this checkbox to include a total line for all transactions in the detail area of the report.
Location	Use to show results of transactions at a specific location. This field appears only in multi-entity companies.
Individual report	Select this checkbox if you want each entity or location to have its own report page. Due to their potentially large size, reports with departments and locations on individual pages can be run offline only. Therefore, if you select the Individual report option, you can select only Process and store. This field appears only in multi-entity companies.
Prompt on run	Select this checkbox to force Intacct to wait for anyone using this report to enter a location or department before it runs the report. This field appears only in multi-entity companies.

Formatting

Use the options in this section to select some of the report details to display and to order the report results.

Set output format options

To sort the data in the report by category, select the sort order that you want from the Sort by dropdown list.
To set the type of results that you want to display in your report, select the level of information that you want from the Summary level dropdown list.

Format field	Description
Sort by	Item is the default sort order. The options are: Item Value Value desc Unit cost Unit cost desc Quantity Quantity desc Last cost Last cost desc Date of last activity Date-of-last-activity desc The abbreviation desc after an option means that the list is displayed in descending order—either reverse alphabetical or numerical order.
Summary level	The level of detail to include in the report. The options are: Detail: This option is the most detailed and common level. The report groups results by customer, then by order, then by warehouse, and finally by the items associated with each customer order. Item summary: Use this level to analyze the activity and other details of your items. With this summary level, the report displays statistics such as: How many of an item are in stock How many of an item are required to fill open orders and how many will remain after filling those orders An item's minimum, maximum, and average price, plus its price range An item's total value as a percentage of all open orders. Warehouse summary: Identical to the Item summary level, except that it correlates items to the warehouses that store them. This level also displays aisle and bin locations.

Format field

Description

Sort by

Item is the default sort order. The options are:

Item
Value
Value desc
Unit cost
Unit cost desc
Quantity
Quantity desc
Last cost
Last cost desc
Date of last activity
Date-of-last-activity desc

The abbreviation desc after an option means that the list is displayed in descending order—either reverse alphabetical or numerical order.

Summary level

The level of detail to include in the report. The options are:

Detail: This option is the most detailed and common level. The report groups results by customer, then by order, then by warehouse, and finally by the items associated with each customer order.
Item summary: Use this level to analyze the activity and other details of your items. With this summary level, the report displays statistics such as:
- How many of an item are in stock
- How many of an item are required to fill open orders and how many will remain after filling those orders
- An item's minimum, maximum, and average price, plus its price range
- An item's total value as a percentage of all open orders.
Warehouse summary: Identical to the Item summary level, except that it correlates items to the warehouses that store them. This level also displays aisle and bin locations.

Titles and footer

Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

What's in this report?

The default Inventory Valuation report with Summary level: Detail, consists of the following columns:

Column heading	Description
Item ID	The ID of the inventory item. An alphanumeric identifier for each inventory item, based on the naming convention used by your company.
Costing method	The accounting method for determining the cost of the item (FIFO, LIFO, Standard, or Average).
Description	Full name of the inventory item.
Product line	The product line to which the item belongs.
UOM	The unit of measure Sage Intacct uses for the item quantity and costing calculations. For example, Each or a Dozen.
Warehouse	The ID of the warehouse for the item.

Details

Column heading	Description
Transaction	For items with a FIFO or LIFO cost method, the description of the transaction for receiving inventory into the warehouse. The transactions show you the cost layering.
Date	The date on which the receipt transaction occurred.
Qty	The remaining quantity from the receipt transaction. Calculated as the quantity of items for the receipt transaction less the quantity for any outgoing transactions dated after the receipt.
Unit cost	In the details section, this column reflects the actual unit cost of the received items.
Value	In the details section, this column reflects the total value of the received items based on the unit cost (received item Qty * UC).
Transaction totals	If Show transaction totals is enabled, displays the total value of ordered quantity for the transaction.

Summary

Column heading	Description
Date of last activity	The date or number of days since the last activity for the item at the warehouse—either receipt or sale of units. This setting is the default. You can use the report filters to change the activity to be just last received or last sold and to display the numbers of days since the last activity instead of the date.
Last unit cost	The last cost at which the item was received into the warehouse.
QOH	The total number of units that are available inventory at the warehouse, the quantity on hand. If a warehouse is configured to allow negative inventory, the value displays 0 (negative quantities are not recognized).
Running avg unit cost	In the summary section, this column reflects the running average cost of the item based on calculated COGS The cost of the products that a retailer, distributor, or manufacturer has sold. over time.
Total value	In the summary section, this column reflects the total value of all item inventory in the warehouse (QOH * running average UC). Note that if you allow negative inventory, the inventory value displays 0. Select Show actual cost for negative balances to reflect the total value of negative balances in the warehouse. See a discrepancy? The details section of the default report lists transaction item values, while the summary shows the current value of the remaining QOH. As a result of running average calculations, the total QOH value may change over time. Learn more about inventory valuation.

You can select any link to drill down to the details.