cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
JR_Admin
Level 1

Report showing unpaid vendor bills where related client invoice was paid

Hello, I'm trying to find a report that would show me all unpaid vendor bills where the related client invoice was paid. Typically, we pay vendor bills related to a client's job as soon as the client invoice is paid. At the moment, that is a manual process and when a client payment is being processed, the person processing it needs to remember to also pay the vendor bills related to that job. It happened a few times, that some vendor bills were missed. We select the customer job in both the client invoice and vendor bill so the vendor bill then shows as an "Unbilled expense" for that invoice.

Is there a report I could run to see any vendor bills that aren't paid where the related client invoice was paid?
Thank you for any tips.

4 Comments 4
Amanda-B
QuickBooks Team

Report showing unpaid vendor bills where related client invoice was paid

Good morning, JR_Admin.

 

Thanks for taking the time to join us here in the Community! QuickBooks has various reports that can help you understand your finances. In your case, I feel you'd benefit from taking a look at the Sales by Customer Detail report. If you're not seeing the information you need, feel free to leave feedback for our developers. Comments are viewed and considered as they create new features and updates for QuickBooks. 

 

If you have any other questions, feel free to reach back out here.

JR_Admin
Level 1

Report showing unpaid vendor bills where related client invoice was paid

Hi Amanda, thank you for your response. How would I set up the Sales by Customer Detail report to show me client invoices that were paid where the related vendor bills were not paid?

Trish_T
QuickBooks Team

Report showing unpaid vendor bills where related client invoice was paid

Hi JR_Admin,

 

The Transaction List by Customer report, displays all transactions and subtotals of income and expenses per customer. 

 

Please follow the steps;

 

1. Select Reports from the top menu and choose Customers & Receivables, then Transaction List by Customer

2. Click the Customize Report button

3. In the Display tab, set the appropriate reporting date under the Report Date Range section.

4. In the Filters tab, select Transaction Type from the Filter menu.

5. Choose Multiple Transaction Types from the Transaction Type drop-down menu.

6. From the pop-up window, select Invoice and Payment then click OK

7. Hit OK again to complete the process.

Note; You can double-click the payments, to know which invoice it was linked to.

 

I recommend memorizing this report, to save the current customization settings.

 

Should you require additional assistance, please don't hesitate to contact us outside of this forum.  We would enjoy the opportunity to work with you personally, and ensure you're able to accomplish your QuickBooks goals without delay!

 

Let us know if you have other questions, we would be glad to assist!

JR_Admin
Level 1

Report showing unpaid vendor bills where related client invoice was paid

Hi Trish, I don't understand. How is that showing me the related vendor bills and whether they were paid or not?

Need to get in touch?

Contact us