cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 4

How can I run a report that shows all invoices or bills with the payment dates and amounts?

Dear All,

 

How can I run a report (or forms) that shows all payment dates and payment amounts of all invoices or bills?

 

TIA

8 Comments
Moderator

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

Hello, BenTam.

 

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:

  1. Go to Reports.
  2. Select Custom Reports.
  3. Choose Transaction Detail.
  4. In the Display tab, set the date range. Then, mark Paid Date and Amount Paid.
  5. Go to Filters.
  6. Enter Transaction Type in the Search Filters field.
  7. Highlight the Transaction Type and choose Multiple Transaction Types in the drop-down arrow.
  8. Select Invoices, Payment, Bill, and Bill Payment. Then, click on OK.
  9. Click on OK to close the Modify Report window.

To help you with the process, I've attached some screenshots below.

 

1.PNG

 

2.PNG

 

3.PNG

 

4.PNG

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. 

Level 4

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

Jane,

 

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?

 

image.png

QuickBooks Team

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

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.

Level 4

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

Hi Shiella,

 

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.

 

Thanks again.

Level 1

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

has this bug/problem been fixed?  I am still experiencing this same issue as of today August 9, 2019.

Moderator

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

Hello sbhetland_Insightra,

 

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. 

Level 1

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

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.

Moderator

Re: How can I run a report that shows all invoices or bills with the payment dates and amounts?

Hello BrookH,

 

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.

Need to get in touch?

Contact us