Skip to main content
R
ravindu93
September 26, 2019
Question

How can i get vendor balance detail with job name?

  • September 26, 2019
  • 1 reply
  • 0 views

I need to view the vendor balance report with a column for 'job name'.

or if i can view job profitability detail report with vendor name and invoice number, its great. Please tell me a way to do it. I have attached a screenshot too.

1 reply

I
IntuitMaggie
September 26, 2019

Dear r.c.abeygunaseka,

Good day! I am here to assist!

Understand that you wish to track profit and loss by each job. I would recommend if you can use "Class tracking" function to track the profit and loss by class.

Kindly refer to the attachment below to guide you how to use "Class tracking" function.

To get the detail transaction report, you may need to click on each balance of the account in "Profit and loss by class" report. This will give you the detail breakdown eg, invoice and bill no. (Refer to the attachment to show you how to run the Profit and loss by class report)

I hope you find this useful and have great day ahead!

M
masterrenovationsinc
November 10, 2023

The OP asked about tracking the activities of a specific vendor for a given job, not overall job P&L. 

Thinking to have a different class for each vendor might be a workaround, but if you're already using classes to track something else, that's not going to work.

 

QBO should have some way to show a statement of open / partially paid invoices, what's owed on each, and a total open balance for vendor, and be able to have that for specific projects, as well as in general.

 

This has been lacking for year. When I used QBD, our former accountant had a report I could run for that, but I can't upload that to QBO.


J
JamesAndrewM
November 10, 2023

I appreciate all the effort you've put into sharing these details.

 

I can also see how convenient it is for you and your business. Currently, this is still a limitation. As we value your suggestions, I recommend sending your feedback to our Product Development Team. Here's how to send feedback: 

 

  1. Click the Gear icon in the upper-right corner.
  2. Select Feedback under Profile.
  3. Share your feedback.
  4.  Click Next to submit.

 

Our product engineers will consider your suggestions, and you can always check the status of your request through this link: QuickBooks Online Customer Feedback. 

 

On the other hand, I agree with you about using invoices for all transactions with multiple payment methods. 

 

You can utilize these articles to guide you in the future:

 

 

Feel free to post here again if you have further QuickBooks-related concerns. We are available 24/7 to lend a hand with each of your queries. Stay safe!

Terms & ConditionsAccessibility statement