cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
barbara33
Level 2

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

 
7 REPLIES 7
jamespaul
QuickBooks Team

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

Hello, Barbara. 

 

I can help you pull up the report you need for the supplier purchase invoices. 

 

I take it that you've migrated to QuickBooks Online (QBO). It has the Customer Balance Detail report, too. This report will show all of the customer's unpaid balances. This won't display the supplier bills (or supplier invoice) or purchase orders however. 

 

What you're looking for in QBO is the Purchases by Product/Service Detail report. You can customise this to include the Customer column. This will let you see the supplier transactions and which customer the item was ordered for. 

 

Here's how to pull it up and customise it: 

 

  1. Go to Reports
  2. Type Purchases by Product/Service Detail in the search box.
  3. Click the small gear icon, then check Customers.

 

CustomerVNDBill1.PNG

 

You can click the Customise button to add filters, adjust the general settings, etc. You can also tweak the sorting options by playing around with the Group by drop-down menu. 

 

This is what it looks like:

 

CustomerVNDBill2.PNG

 

If you'd like to see a report with purchase orders instead, you can run Transaction List with Splits. Here's how: 

 

  1. Go to Reports again, then type Transaction List with Splits in the search box.
  2. Click the Customise button.
  3. Under Rows/Columns, click Change columns.
  4. Tick the Customer and Supplier boxes.
  5. Check Transaction Type, then choose Purchase Order in the drop-down menu. 
  6. Hit Run report

 

CustomerVNDBill3.PNG CustomerVNDBill4.PNG

 

You can also see the bills here. If you want to include them, tick the Bills box for Transaction Type. This is what the report would look like:

 

CustomerVNDBill5.PNG

 

If you want to save the report for future viewing, just click on the Save customisation button. Enter a custom name for it then hit Save

 

You can access the saved report by going to Reports then selecting the Custom reports tab. 

 

These articles are helpful if you want to pull up or customise other reports: Reports and Accounting for QuickBooks Online

 

I'm always here to help if you have other future questions about QuickBooks Online. You can also leave a reply if you have follow-up concerns about the reporting feature. 

barbara33
Level 2

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

Hi
I followed your instructions but it doesn’t work on my QBO ?
I cant seem to paste an example. 

On QBD you could select to look at 'Materials & Consumables', Plant Hire', Subcontractors' etc by hitting customise report , then filters tab and selecting account and changing it to the above. Having already selected name as the customer you where looking for costs for. That way you could get list of subbies that had worked for that customers job OR ‘Plant Hire’ to see what invoices were charged against hire of plant
I need to be able to produce a report to show manager the costs for certain customers utilising the materials & consumables, Subcontractors and Plant hire ??
Can you think of another way or what I’m doing wrong ?
Thanks for helping me 😊

 

JonpriL
Moderator

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

Hello there, @ammuraj!

 

Let's pull up and customise your Sales by Customer Detail report to see the cost of the items used by your customers.

  1. Go to Reports.
  2. Under Sales and Customers, select Sales by Customer Detail.
  3. Click Customise.
  4. On the Report Period menu. select the appropriate dates.
  5. Below the Filter section, select Distribution Account.
  6. Select the accounts you wish to show up on your report..
  7. Click Run report.

In addition, here's an article you can read to learn more about how you can customise a report: Customise Reports in QuickBooks Online.

 

Lastly, I've got you this helpful article for ideas about saving your report after customising it: Memorise reports in QuickBooks Online.

 

Keep me posted in the comments down below if you have any other questions. I'll be happy to help.

barbara33
Level 2

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

Sorry that doesn't appear to work either  ……. 

I'm trying to copy the report from QBD to show you but can not copy and paste here

I followed your instructions and selected all dates as I want to know how much in total has been spent on a particular customer of 'materials & consumables' 

MaryLandT
Moderator

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

Hello there, barbara33,

 

You can run the Sales by Product/Service Detail report. It will show your sales, grouped by product or service that includes the date, transaction type, quantity, rate, amount, and total. Then, click the Customize button and go to the Filter section to personalize the customer and account. 

filteraccountandcustomer.PNG

 

Doing those steps above will help you see the total spent for each customer on a particular account.

 

On the other hand, you can attach a screenshot of the sample data you're referring to in this thread. This will help us get the exact information you need.

 

I've also added this article: Reports included in your QuickBooks Online subscription to learn which reports are available for your plan.

 

Stay in touch for your screenshot, and we'll get back to you. Thank you and stay safe!

barbara33
Level 2

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

Hi , I followed your instructions and I am getting nothing on the report.

My data has come from QB desktop not sure why its not working.

this is the report from qbd 

qbd report

barbara33
Level 2

I need to run a report showing supplier purchase invoices with which customer the item was ordered for. on desktop it was customer balance detail report ?

I've found a way round it ! 

 

Select 'income by customer summary' - customise,  change dates to all dates, then select the customer I'm looking for. Run report , get line for the customer I want, click on expenses column, view changes it to profit and loss - then clicked on materials & consumables to get the list I want ! 

If anyone can think of an easier way, please let me know - thanks 

Need to get in touch?

Contact us