Skip to main content
December 7, 2022
Question

How do I create a report that lists all of my invoices but is not grouped by customer and includes both the creation date of the invoice and the paid date?

  • December 7, 2022
  • 1 reply
  • 0 views
I can create a transaction list, but can't pull both the create date of the invoice and the paid date.  All other invoice lists group by customer which I don't want.

1 reply

MaryLandT
December 7, 2022

I appreciate you creating a transaction list report to have both the invoice and payment dates, smr360. And, you're right that invoices are grouped by customers.

 

It's working as design since invoices are made for customers. You can pull up the Invoices and Receive payments report as it shows both the invoice and payment date without sorting the list by customer.

 

Here are the steps you can follow.

 

  1. Go to Business overview then select Reports.
  2. Select the Standard tab.
  3. Find the Invoices and Receive payments from the Who owes you area.
  4. Use the Customize button to adjust things like the report dates and filters.
  5. Click Run report.
  6. From the Date column, you'll see when was the invoice created and paid.

 

The financial reports tell you a lot about your business. If you want to check the data outside of QuickBooks, you can export them to Excel. Or memorize the report so you won't have to go through the customization again.

 

Use these articles below as guidance for memorizing and exporting reports.

 

 

You're always welcome for follow-up questions about creating a report that lists all invoices or any other QuickBooks concerns. Take care always @smr360.

smr360Author
December 7, 2022

Thank you Mary, but I want a much simpler report than the standard one offered.  I want just the list of invoices, not grouped by customer, that has one line per invoice and includes both the date the invoice was created as well as the date the invoice was paid.  All the data is in the database - how do I make this happen?

December 7, 2022

Hi there, @smr360. Thanks for getting back to the thread. 

 

Based on your details, the report that you want isn't available and can't be customized in QuickBooks Online. I agree with MaryLandT that the Invoices and Receive payments report is the best option for obtaining the data you need. Then, you may export it to excel as a workaround to modify the columns. You may refer to the steps provided by my MayLandT on how to run the report, and please see the screenshot below.

 

 

The following articles will help you keep track of and manage your reports in QuickBooks Online:

 

 

Keep us posted if you need further assistance with your financial reports. Just click the Reply button below. We're always here to help you. Stay safe.