Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
lmoCDS
Level 4

Report for all line items in bills

I tried to to do this like I do expenses and I am striking out.

Can I run a report that shows all line items for bills and then I can sort by vendor?

3 Comments 3
MariaSoledadG
QuickBooks Team

Report for all line items in bills

I'll guide you on how you can run a report that will show all the line items in bills, Lmoore.

 

QuickBooks Online (QBO) provides dozens of reports that focus on sales and on your spending to cater to your business needs. 

 

You can run the Purchases by Product/Service Detail report. Then customize it to show the line items on the bill. To do so, follow the steps outlined below:

 

  1. Go to the Reports tab, then enter the name of the report.
  2. Choose the correct Report period.
  3. Click Customize.
  4. Then, hit the Change columns hyperlink. Tick the Product/Service box.
  5. Select Filter, then locate Bill under the Transaction Type.

 

Once done, this is how it shows after the customization:

 

 

After that, you can export the report to the Excel file. From there, you'll have the option to sort vendors according to how you want them to show.

 

You may also want to use the Transaction List by Vendor report to show the items on a Bill Payment Stub. Check out this article for full details: Showing All Items In The Bill Payment Voucher.

 

Furthermore, learn from this article what specific reports are available on each QBO subscription: Reports Included In Your QuickBooks Online Subscription.

 

Reach out to us if you have any questions about reports. We're here to get everything covered.

lmoCDS
Level 4

Report for all line items in bills

That only works if everything on bill is a product or service. 

Support needs to rename the "Showing all Items in the Bill Payment Voucher" to something else because everyone that asks gets this same response.

We don't want a list of Bills.

We want a list of line items in the bills for a particular vendor when the items might not all be listed as a Product or Service.

 

Maybelle_S
QuickBooks Team

Report for all line items in bills

Let's ensure you can access a list of bill line items within QuickBooks Online (QBO), lmoorecalvarydevsvcs.

 

Currently, there is no option to generate a report displaying the bill's line items directly. Nonetheless, we can generate a transaction journal report for each bill associated with a specific vendor to reveal the line items.

 

Here's how:

 

  1. Go to the Expenses menu and select Bills.
  2. Choose the transaction you want to run.
  3. In the Bill window, click More at the bottom.
  4. Select Transaction journal.

 

I can see the importance of having this option for your business. With that, I suggest sending feedback to our product developers so they can review it and might consider adding this in our future updates. Please refer to the steps below:

 

  1. Go to the Gear icon.
  2. Under Profile, select Feedback.
  3. Enter your suggestion.
  4. Hit Next.
    1.PNG
     

You can track your feature requests through our QuickBooks Online Feature Requests website.

 

Let me know in the comment below if you have other concerns or follow-up inquiries about managing reports in QBO. I'm just around to help. Take care!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us