Skip to main content
D
DBAeroSphere
April 22, 2024
Solved

Invoice Payment Date Report

  • April 22, 2024
  • 1 reply
  • 0 views

Hello, 

My goal is simple I need a list of invoices, and the date it was paid. I'm fine with doing some processing to get the data into the format necessary. But I need a payment date for each invoice if It was paid. I have explored the "Transaction List by Customer", TLC, report and formatted that, but there are problems with that report. If the customer paid for multiple invoices with one payment, that payment will only show up under one invoice. We get a lot of bulk payments so that's not a valid option unless the report can be made to show split payments. I can also handle combining multiple reports if I have to. I'm currently using a TLC report whitelisted to payments to track income reliably, but I can't get class / ship state information from the payments. 

If possible, I would like to request that this be added as a feature, as it seems like a pretty simple and useful piece of data for a variety of tasks. 

If anyone can help me with this, I would be very grateful. 

Best answer by BigRedConsulting

Hello BigRedConsulting,

 

While your message isn't a solution, at least not within QuickBooks, I would like to express my amusement towards your marketing approach. 


@DBAeroSphere  @kasia4 

RE: While your message isn't a solution, at least not within QuickBooks, I would like to express my amusement towards your marketing approach. 

 

Well, it's the promise of a solution, but as it turns out, I was wrong. In fact you can see the paid date, but only on one particular report.

 

To see the paid date for paid invoices, start on the QuickBooks menu at Reports | Customers & Receivables | Average Days to Pay.

 

The report will look something like this, though I removed some columns, added the Name column, and rearranged others:

 

 

 

1 reply

I
IrishNinoJ
April 22, 2024

I appreciate you for what you've done on your end, DBAeroSphere.

 

Upon replicating here on my end, you can go to Custom Reports to show the Class and Ship To State information. However, we're currently unable to display the paid date of an invoice in the report. The report only shows the invoice payment as another transaction. Let me guide you on how to run the said report.

 

Here's how:

 

  1. Go to Reports.
  2. Choose Custom Reports and select Transaction Detail.
  3. Under Display, look for Columns and filter the Class and Ship To State.
  4. Go to Filters and search for Transaction Type.
  5. Click the dropdown under Transaction Type and choose Multiple Transaction Types.
  6. Select Invoice and hit OK
  7. Click OK
  8. Manually change the dates, then click Refresh. 

 

You can memorize reports in QuickBooks if you want the same settings of the customized report to be available for future use. You can visit this article: Create, access and modify memorized reports

 

If you have further concerns about customizing reports in QuickBooks Desktop, feel free to come back here in the Community. We're here to assist you 24/7.

D
DBAeroSphereAuthor
April 22, 2024

Hello IrishNinoJ,

 

Thank you for replying. After running that report it looks like that that does give me the class and ship state of the invoice. However, it doesn't seem to give the paid date, which is something I need. Also it seems to break down each invoice by each line item. It seems like the total value of the invoice in the sum of "Credit" for each given invoice number.

 

Thank you for your time,

 

 - D.B.

    Bryan_M
    Bryan_M
    April 23, 2024

    Thanks for a prompt reply, @DBAeroSphere.

     

    Currently, we're unable to display the paid date of an invoice in the report. We can only view the invoice payment as another transaction in the report. I know how this section would be helpful to track when an invoice is being paid.

     

    As a workaround, we can export the report and edit it there to add the paid date manually. Here's how:

     

    1. From the report, move your mouse to the Excel button above and select Create New Worksheet.
    2. Select what would you like to do with the report. Then, click Export.
    3. Follow the on-screen steps.

     

    If you want to see the invoice breakdown, you need to open the transaction by clicking it in the report or by going to the customer transactions to look for it.

     

    In the meantime, you can submit direct feedback to our product engineers about this feature. They might add this to our future product updates.

     

    You might want to view two reports on one page. Check out this article: Combine reports from multiple company files.

     

    Leave a comment below if you have additional questions about managing your reports. I'll be willing to lend a hand. Keep safe always. 

    Terms & ConditionsAccessibility statement