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

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

30 Comments
Highlighted
Moderator

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. 

Highlighted
Level 5

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

Highlighted
QuickBooks Team

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.

Highlighted
Level 5

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.

Highlighted
Level 1

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.

Highlighted
Moderator

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. 

Highlighted
Level 1

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.

Highlighted
Moderator

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.

Highlighted
Level 1

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

Any updates to this issue?  I need a report of payment dates for paid invoices.

Highlighted
QuickBooks Team

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

Hi CornCounter,

 

As of the moment, we haven't received any updates yet about running a report that shows the payment date of the invoice. As a workaround, you can customize the Transaction Detail report to show the list of invoices and payments by date. Let me guide you through the steps.

  1. Go to Reports at the top menu bar.
  2. Under Custom Reports, choose Transaction Detail.
  3. Under Display, add the Paid column.

  4. Remove the unnecessary column.
  5. Click on the Filters tab.
  6. In the Search Filters field type Transaction Type.

  7. Click the Transaction Type drop-down and select Multiple Transaction Types.
  8. In the Select Transaction Types window, click Invoice and Payment.
  9. Click OK twice.
  10. In the Total By drop-down, select Customer.
  11. Update the report date.

I'll pass this along to our product team again to let them know of your business needs.

 

You can also customize any report that you want to generate in QuickBooks. Please check this article for more information: Customize Reports In QuickBooks Desktop.

 

Post your questions if you have any other concerns. I'm always right here to help you.

Highlighted
Level 1

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

Please add me to the list o users who need this feature. Not only will the paid date column not work  but also the Check# column as well. I just switched over to quickbooks desktop premier from a little 50.00 program that i used for years and it would run this report with on click of a button. I would also run a report called checks by job which for a contractor is nice to have. A report that list each job  with each check written for that job. Of course if i could get the paid date column and the check no column to work i would be able to create this report in  quickbooks.

Highlighted
QuickBooks Team

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

We're taking notes of your suggestions and feedback, @rgwsell1.

 

Our product engineers are considering all suggestions based on the number of requests and their impacts on the user interface before they're rolled out.

 

I know how important it is for you and your business to have a report that can generate paid date and check # column. At this time, you can consider following the workaround shared by my colleagues above.

 

Also, I want to let you know that your voice matters and I'm submitting feedback directly to our product engineers for consideration. For now, you can visit our blog site so you'll be able to get the latest news about QuickBooks and what our Product Care Team is working on. 

 

If you have other concerns, just comment below or post again. I'll be sure to get back to you. Have a good one.

Highlighted
Level 1

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

It's 2020 and quickbooks still does not seem to have a way to sort invoices by the date they were paid, which is a crucial feature to have for many of us, particularly when it's time to sort through payments for tax purposes.  If quickbooks has no plan to include this, we're probably going to have to switch to another program. 

Highlighted
Level 2

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

Sorry, I don't mean to hijack this thread but I need slight modification to original request by the author.

 

Is there a way to just see all the payments for a particular invoice? We send shipments to Amazon and all payments received for that invoice is tracked by the invoice #. It's very difficult to track payments we receive from Amazon when it comes to verification/reconciliation but would really love to filter the transaction details in the steps you provided to see just the payment against a particular invoice. Just don't see the option to filter by Invoice #. 

 

Thanks! 

Highlighted
Moderator

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

Let's do a little change on the report to generate all the payments for specific invoices, FzAll.
 

We can use the Custom Transaction Detail report, as suggested by my colleague here. Then, customize it to display the paid and payment method status of the invoices.

 

The paid and payment method columns track all the transactions that have been paid already. I'll guide you step by step on how to add these columns. Here's how:

 

  1. Click the Customize Report button.
  2. In the Display tab, select Paid and Pay Meth to add them as one of the columns to be displayed in the report. You can add the Transaction number if you would like to. Then, OK.
  3. Select the Filters tab and choose Transaction Type and Payment Method one at a time.
  4. In the Transaction Type, click Invoice and select type of payments as well. Then, OK.

 

Along with the steps above, here are the sample screenshots for additional reference:

filter.PNG filter2.PNG

 

I'll share with you an article where you'll learn more about customizing QuickBooks Desktop (QBDT) reports. 

 

Please get back to me if you have follow-up questions about modifying reports in QBDT. Thanks!

Highlighted
Level 2

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

Thanks for your response. I did read QBDT page but I couldn't figure exactly how to achieve what I'm trying. 

 

I followed your steps but adding Payment Method causes issues because we rarely that properly so I removed that from filter criteria because I don't get any data. 

 

How to filter based on invoice.jpg

 

As you can see in the image, it's extremely difficult for us to identify what payment we are tracking against which invoice. I wish this had a tree and branch structure so expanding invoice will show us all the payments we've received against the invoice. The customized filter is not allowing me to set the invoice number so I can see exactly the payments we've marked against the invoice. At times, we mistakenly attach payment to wrong invoice and reconciliation becomes a nightmare. A single invoice can take 4+ hours in current approach that we are using to reconcile differences. 

 

See the last row in the image with Tran # 4747, it's associated invoice is 768 but it's not easy to link payments with invoice in the current approach, perhaps I'm missing something. 

 

Thanks!

Highlighted
Level 2

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

Since we can figure it out in excel and pivot tables, it seems pretty unresponsive to not have an update on something requested nearly a year ago. The requirements are not complicated. Timeline or 'it's behind a thousand other things' is a real answer. You guys are too expensive now for this kind of non-responsiveness.

Highlighted
Level 2

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

Crickets?

Highlighted
Level 1

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

I've also been waiting for this to be fixed for years.  That or allow us to remove the summary breaks on the days to pay report... 

 

When will this be fixed? 

Highlighted
QuickBooks Team

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

Hi there, @beckysright.

 

As of now, we still don't have a timeline on when our engineers will give updates to fix this concern. Rest assured this is a work in progress of our development team.

 

However, we can still review your individual transactions and note the payment dates. You can also use the report customization suggested in the previous responses.

 

I want you to be the first to hear about the latest QuickBooks innovations, so I’m adding an article to view the details: Firm of the Future.

 

I appreciate your patience as we get to the bottom of this. We'll keep you posted for any updates, too.

Highlighted
Level 1

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

I was requested by management to produce a report that shows all 2018 invoices that were paid in 2019 with their exact payment date. Sadly as I can read through this thread it seems that Quickbooks has ignored this issue for a long time now.  It is quite difficult to go through each invoice to document the payment date as the volume of transactions is pretty high. 

 

I went through all these steps and found the same issue that the paid date column does not display the paid date, just blank. Unfortunately I can't be helped for this now but in this should be resolved as soon as possible. 

Highlighted
QuickBooks Team

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

Let me help you in getting the report you need, Abdiel.

 

You can follow the steps suggested in this thread. I understand that the Paid Date and Amount Paid columns are empty when you add them to the suggested report. You can make use of the Date column since the date showing in this field is the date that you entered when recording the transaction. Also, the amounts of the transactions will reflect under the Debit and Credit column.

 

Click on these screenshots for your reference:Custom.PNG

 

custom 1.PNG

 

custom 2.PNG

 

Please comment again if you have more questions. I'll be here to help.

Highlighted
Level 5

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

Hi Alex,

 

Thanks for you reply. Your suggestion is a perfect workaround to my problem. However I won't mark it as a solution because it is not a bug fixing.

Highlighted
Level 1

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

Hi Alex,

 

If there was no bug the report would have been done in less than 5 minutes. It's a workaround but it took me almost three days to make this report since there were 3,000 + invoices. 

 

Thanks for the suggestion.

Need to get in touch?

Contact us