I need to run a report of all invoices I have issued, that shows the date they are paid.

Thanks for bringing this to our attention, @Flyingfemme. 

I can see the relevance of having the Paid Date on the reports. Currently, the option to see the data in the Paid Date column is unavailable. 

As a workaround, we have to open the invoice manually to see when they were paid. 

You'll want to have a statement that shows each Paid Date of the invoice. You can export a report to an Excel file. From there, enter the date when the invoices were paid. 

Here's how:

1. In QuickBooks, go to the Reports menu and choose Reports Center.
2. Find and open any report.
3. Click the Excel on the toolbar.
4. To create a new Excel workbook, select Create New Worksheet. 
   
   
5. When you’re ready to export, choose OK. 
6. To open the report in Excel, you can also select Export.

For more insight, please see this article: Export reports as Excel workbooks in QuickBooks Desktop. 

Moreover, I've attached relevant articles you can utilize to manage reports in QuickBooks:

• Customize reports
• Create, access, and modify memorized reports

You're welcome to stop by the Community if you need anything else about managing reports. I'm always here and ready to help. Have a pleasant day ahead.

Thank you. I understand very well how to export a report to excel. But you can’t export data that isn’t on the report. Are you suggesting I should manually fill in the paid date on the spreadsheet? There are over 1700 invoices in this particular report.

It isn’t unreasonable to expect that a data field is available for reporting. Particularly when it appears in the drop down list of fields to select for reporting.........

This is a failing of the software and something that business owners are likely to need.

Quickbooks can't give the kind of report you want because there isn't a one-to-one relationship between invoices and payments. Sometimes customers will make partial payments making it too complicated to create a standard report.

The only way, so far, that I have found to create reports that I find useful is to use a 3rd party software called QODBC (the cost is modest, about $200, but it only works on existing and past versions of QB and won't work on upgrades after you buy it; you have to buy it again each time you upgrade QB). QODBC allows a "back door" into the data base tables in Quickbooks. You can get licenses for either QBO or QB Desktop. You can only set it up as the Admin and there is a bit of a process to setting it up, but it's not bad once you know what you are doing. In QB Enterprise there is a table called InvoiceLinkedTxn (I'm not sure if the table is the same in other versions of QB.) Within that table the following columns exist:

CustomerRefFull Name (the name of the customer, not just a database reference)

TxnDate (the date of the invoice)

RefNumber (the invoice number)

TermsRefFullName (e.g. Net 30)

Due Date (the date the invoice was due)

Ship Date (the date the product was shipped, assuming you tracked that)

Subtotal (I believe this is the invoice total before taxes, etc.)

SalesTaxTotal

AppliedAmount (the total amount applied to the invoice as of the date of the report - not the partial payment)

Balance Remaining (if not paid in full, this should show the balance as of the report date)

LinkedTxnTxnType (CreditMemo, Deposit, JournalEntry, ReceivePayment, SalesOrder)

LinkedTxnTxnDate (the date of the transaction e.g. payment received)

LinkedTxnAmount (the applied amount of the payment - relevant if the payment paid more than one invoice)

There are a bunch of other columns too, but these should suffice for the report you want.

Using Excel, you can connect to ODBC and import the data to Excel and then run your reports.

I have to re-teach myself the steps for this almost every time I haven't used it in a while (which is why I was looking for this information and ended up here; I haven't been smart enough to create a cheat sheet for next time).

I've found that the VLOOKUP function in Excel helps me pull up the data I want. I pull up a list of invoice numbers and use it to pull all the other data I want about the transaction payment. I can calculate the number of days between the date of the invoice and the paid date in Excel. However, this gets really complicated if a customer pays an invoice in two or more payments. For example, I have a customer who pays 50% up front and 50% soon after delivery. This is why QuickBooks can't give the kind of report you want.

In my opinion, the QODBC software is worth the price. I find very little info about it in the help sites, but I love it. The QODBC people will help you set it up, but you have to teach yourself how to navigate the different tables. That's a bit dense, but once you invest the time, you become a bit of a power user. I find that most QuickBooks Pro advisors don't have a clue that this exists. I find that the QuickBooks support people don't really know about it, even though QuickBooks is designed to work with QODBC. (If you click on File/Utilities you will find an option to "Configure QODBC", so this is a known solution.)

Good luck!

Yes. It is must to know when the each invoice is paid. Also note that some invoices may have more than one payment on different date