Skip to main content
J
JR_Admin
March 22, 2024
Question

Report showing unpaid vendor bills where related client invoice was paid

  • March 22, 2024
  • 1 reply
  • 0 views

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.

1 reply

A
Amanda-B
March 22, 2024

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.

J
JR_AdminAuthor
April 2, 2024

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?

T
Trish_T
April 2, 2024

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!

Terms & ConditionsAccessibility statement