How can I run a report (or forms) that shows all payment dates and payment amounts of all invoices or bills?
It's good to see you here. I'm here to help locate the report you need in QuickBooks Desktop.
You can pull up the Custom Transaction Detail report and filter it with paid invoices and bills. To do so, please follow these steps:
To help you with the process, I've attached some screenshots below.
For further guidance in customizing a report, you can also check out this article: Create, access, and modify reports.
That should do it. Please keep me posted on how it goes. I want to make sure everything you're all set with this concern. Have a great week.
Thanks for your reply. I followed your instructions to construct the report. However, both the columns "Paid Date" and "Amount Paid" are blank. What am I wrong?
You did great in filtering the report, BenTam.
While these columns are unavailable, you'll want to use the Date and Amount column as your reference. The date column shows the date the transaction was last modified.
I will be sending a report about this functionality to our engineers. That way, they can keep the report updated.
The Community is always here for you if you need anything else.
I regard this blank columns as a bug. Thanks for sending a report about this functionality to your engineers. Thus I'll not mark your answer as a solution until the bug is fixed.
has this bug/problem been fixed? I am still experiencing this same issue as of today August 9, 2019.
We've been sending feedback to our engineers about this. While we are waiting for their response, let's try to export the report to Excel and customize it from there to show the amount paid.
Let us know if you have any questions. We are here to help.
Has there been any word about this issue? I am having to go through each invoice manually to document the pay dates in my report.
Though we've already submitted a feedback about this, we still don't have a timeline on when our engineers will give updates. Rest assured this is a work in progress of our development team.
For now, we can only review the individual invoices and take note of the payment dates. You can also use the report customization suggested on the earlier responses.
I appreciate your patience as we get to the bottom of this. We'll keep you posted for any updates, too.