QuickBooks HelpQuickBooksHelpIntuit

Customize item reports

by Intuit Updated 5 months ago

To help you keep track of your inventory, QuickBooks Desktop offers a wide variety of ready-made item reports. You can also customize these reports according to your business needs.

The articles in this series help you:

Note that available columns and filters differ for each report/group of reports because each draws information from the company file differently. Understanding the concept of source and targets is particularly important when customizing reports.

P.O. Report that includes items and item descriptions

Note: Item and item description appears in Open Purchase Orders Detail report in QuickBooks Premier/Enterprise version 13 and later.

If you use QuickBooks Pro or QuickBooks for Mac, you can run a Transaction Detail report.

  1. From the Reports menu, select Custom Reports then select Transaction Detail.
  2. Selct Customize Report.
  3. On the Display tab, select Item and Item Description under the Column section.
  4. On the Filters tab, select the following filters:
    1. Transaction Type = Purchase Order
    2. Posting Status = Either
    3. Received = No for open Purchase Orders
    4. Received = Yes for closed Purchase Orders.

In QuickBooks for Mac, select the Filters icon then check or uncheck a filter to add/delete it. Select Apply and close the window to save the changes.

Inventory items used in assemblies to be ordered from Vendors

This report shows inventory items that make up assemblies currently on sales order. It will help you see what inventory items need to be ordered from a vendor (using a purchase order, in most cases).

  1. Create a sales order using the inventory assembly that will be sold to the customer.
  2. Create a pending build for this assembly.
  3. Go to the Inventory Stock Status by Item report (select Reports then Inventory and then Inventory Stock Status by Item).
  4. View the For Assemblies column to see which inventory items are on the pending build.
    Note: Purchase orders can be entered for any inventory part in the For Assemblies column.
  5. Once the items have been received, and the assemblies are ready to build, go to the Pending Builds report (select Reports then Inventory and then Pending Builds).
  6. Double-click a pending assembly that is ready to be built.
  7. Select Remove Pending Status.
  8. Select Build & Close.
  9. An invoice can now be created from the sales order for the assembly that was built.

Items used in Build Assemblies

  1. From the Reports menu, select Custom Reports then select Summary.
  2. On the Display tab, set the date range to the period you need.
  3. Select Customize Report.
  4. On the Display rows by drop-down, select Item detail.
  5. Under Display columns for, select Quantity (select Amount if dollar amount is required).
  6. On the Filters tab:
    1. Remove the Account filter.
    2. Add Transaction Type then select Build Assembly filter.
    3. Add Detail Level then select All except summary filter.
  7. Select Memorize to save the report for future use.

You also have the following options:

  • Set the Posting Status filter to Either to include pending builds.
  • Change Display Columns by to Month to display data by month.
  • Set the Item filter to Multiple items and select desired items.

Item Estimates vs Actuals

This report summarizes how accurately your company estimated costs and revenues for the items you sell. The report compares estimated cost to actual cost and estimated revenue to actual revenue for all items.

  • The Est. Cost and Act. Cost columns compare your estimated cost to your actual cost for each item.
  • The Est. Revenue and Act. Revenue columns compare your estimated revenue to your actual revenue from sales of each item.
  • The () Diff columns show the difference between the estimated and actual amounts. A negative amount in this column means that the estimate was too high; a positive amount means that the estimate was too low.

To see a list of the transactions that make up an amount, double-click the amount.

QuickBooks Desktop for Mac 2020

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this