Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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.
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?
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!
Hi Trish, I don't understand. How is that showing me the related vendor bills and whether they were paid or not?
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here