"Purchases by Item Summary" Report vs "Sales by Item Summary" Report

Hi farmer_z,

Pulling up Purchases by Item Summary with the average price of item purchases and total by classes is not available in QuickBooks. You’ll want manually total the average price item in Excel.

Here’s how:

1. Go to the Reports menu.
2. Choose Purchases then select Purchases by Item Summary.
3. Click on the Excel drop down arrow and then Create New Worksheet.
4. Choose Create new worksheet and in new workbook.
5. Then click Export.

I suggest sending us your feedback about this feature. Just click on the Help menu and choose Send Feedback Online, then select Product Suggestion.

Let me know if you have further questions.

The Custom Summary Report (Reports > Custom > Summary) will get you close...

Customize the report:

   Display columns by:  Class

   Display rows by:   Item detail

   Include columns for:   Both (Amount and Quantity)

Filter the report by Account:  "Expense and other expense accounts".  (Or, you can filter by TransactionType, multiple transaction types, and select Checks, Bills, Credit Cards, etc.)

Unfortunately, you'll have to export the report to Excel (or another spreadsheet via exporting to a *.csv file) and add formulas to calculate the average prices, but that's easy because the formulas will all be the same.

I should have dealt with this in Vol II of the QuickBooks Farm Accounting Cookbook (I'm the author), but it was a reporting topic that didn't make it in--always more ideas than time to flesh them out. Oh well, maybe in the next edition.

Is there any report that will provide the total quantity purchased for an item or all items with vendor and unit price information? I'd like the report to be sorted by item number, with totals for each item.

Thanks in advance for the help

Hello, @jpp84z4.

If you have a certain vendor for certain items in your QuickBooks Online, I can show you how you can set up a Preferred Vendor in the Products and Services in your QuickBooks Online. If you do this, you can further Customize your reports to fit your needs. Here's how you set up your Preferred Vendor:

1. Go to Settings ⚙ at the top-right of the page, then Products and Services.
2. On the Products and Services screen, press on the item to edit.
3. Scroll down to the Preferred Vendor drop-down then choose the name of the vendor you usually purchase items from.
4. Hit Save and Close.

Now you have Preferred Vendors set up in your account. Let's run a Product/Service List in your Reports tab. This report will give you the item, item type, description, price, cost, quantity on hand, and the preferred vendor. I've provided the steps below on how you get this report:

1. Go to Reports on the left-hand menu, then type in the Search bar "Product/Service List."
2. At the top of the report, on the right-hand side, click on the small Gear ⚙ icon. Under the Change columns, press on Show more and mark Preferred Vendor.
3. Click anywhere to hide the box and view your report.

Let me know if this helps you! If you have further questions about reports in QuickBooks Online, I'm just a click away. Have a fantastic weekend.

Hello, @jpp84z4.

I'm here to help you get you a report to fit your needs. Here's how:

1. Go to Reports at the top-menu, then Inventory.
2. You should see several different reports. I recommend running Physical Inventory Worksheet.
3. Now we can Customize the report by pressing Customize Report at the top-left of the report.
4. Mark all of the filters, then hit OK.

This will get you the item, description, price, cost, quantity on hand, preferred vendor, and much more.

Let me know if this works for you! If you have further questions about reports in QuickBooks, I'm just a click away. Have a fantastic weekend.

Hi Ashley,

All purchases are Non-inventory items. So I don't think the report will give me what I need.

You'll want to run the Purchases by Item Detail report instead, jpp84z4.

Let me show you the steps on how you can open and customize the report:

1. Go to the Reports menu, look for Purchases, and then click Purchases by item.
2. Click the Customize Report in the upper part of the report.
3. Go to the Columns section and put a check before Item.

The vendor's name is listed under the Source Name column. However, this report can only sorted by Type, Date, Num, Memo, Source Name (vendor), Item, Qty, Cost Price, and Amount.

You'll also want to memorize this report just in case you might need to use the same filters in the future. Check out this article for full details: Create, access and modify memorized reports.

Let me know if you need other types of report. I'll jump right back to offer my help again. 

Good discussion. Three questions -

1. I know this discussion is about the "Purchases by Item Summary" report in QBD, but can you please provide the most similar report in QBO?
2. What is the QBO equivalent for the QBD "Purchases by Item Detail" report?
3. What is the QBO equivalent of the QBD field "source name"?

We just moved to QBO and I'm struggling to recreate reports as similarly as possible for our board of directors' monthly package. Appreciate your help!

Thanks for joining us here, @Amber Robinson.

I'll share some insight about reports in QuickBooks Online (QBO). You can use the Purchase by Product/Service Detail report similar to Purchases by Item Detail in QuickBooks Desktop (QBDT). It'll show your purchases, grouped by product or services. Then, use the Purchases by Vendor Detail for Purchases by Item Summary in QBDT.

To view these reports:

1. Go to Reports.
2. Scroll towards the Expenses and Vendors section. 
3. Click on the your preferred purchase report.

With the above mentioned reports, you can filter and see details of your purchases. Here's an article to guide you in customizing reports in QuickBooks Online.

About "Source Name", there isn't an equivalent field type in QBO. QBDT and QBO are two different platforms. Thus, features and coding are different.

Additionally, feel free to browse the links below to help you manage reports in QBO. Just choose a topic that fits your concern.

• Create and manage reports.
• Reports included in your QBO subscription.

Reach out to me again if you have follow-up questions or concerns with reports in QBO. I'm more than happy to answer them for you. Take care and stay safe.