Connect with and learn from others in the QuickBooks Community.
Hi, I need to develop a customized report that reflects what items were paid for when we receive our payments from our clients.
For example, if a client sends a payment of $100, and their invoice is for $50 of material, $50 of labor, I need the report to reflect that the check paid for those specific items.
I've tried customizing the check detail report, but it's pulling in all invoice details, paid and unpaid.
Any help will be greatly appreciated!
Go to Solution.
Aside from the Check Details, there are different reports that we can pull up to show the paid items on your invoices, CateQ.
One report I can think is the Sales By Customer Detail report. Here's how we can customize it:
This'll display the items under the PRODUCT/SERVICE column, while their status shows under the A/R PAID column.
You can also pull up the Invoices and Received Payments report to compare the payment date and amounts.
If necessary, you can further customize and export the report to Excel. Have a great day!
View solution in original post
Thank you, very helpful!