Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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!
Cate
Solved! 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!
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!
Thank you, very helpful!
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