Hi gtceitf,
It’s indeed easier to see a report of all billable items with payment statuses both on the project and on the vendor side.
I just got one for you. In this case, we'll customize the Transaction Detail by Account report.
- Go to Reports and search for Transaction Detail by Account.
- Set the date range, and group by Vendor.
- In the Sort drop list, select NUM.
- Click the small Gear icon and add the following columns: Product/Service, A/P Paid, A/R Paid, and Customer.
- Uncheck other columns like Memo/Description and Split.
- Click Run Report.
In the example below, I have 1 unpaid bill (#100) with two billable items. One of the items is invoiced to the Bathroom Repair project (#1018) and the other is to the Kitchen Repair (#1019) project. By looking at the A/P Paid and A/R Paid columns, you'll know which items are paid or unpaid on both the vendor and customer sides.
For accounting reasons, QuickBooks created 3 lines for each item on the customer side, but you can export the report to Excel to remove the lines you don't need.
Let me know if you have questions about the report. Take care and have a good one!