all invoices report

The recommended report includes a row for each detail.  Is there a way to subtotal by invoice number and, if possible, suppress the line item detail?

Thanks in advance,

David

Hello ... I use the QB Desktop version, and I find it simpler to do this:

• Go to the CUSTOMER CENTER
• Click on the TRANSACTIONS tab (not the New Transactions menu!) and a selection list will be displayed
• Click on INVOICES and a list of invoices will be displayed
• Select the DATE range that includes the specific date range that you want (e.g. Last Fiscal Year for any invoices you want from last year)
• Click the RUN REPORT button at the bottom of the list of invoices and select VIEW AS A REPORT
• The INVOICES FOR ALL CUSTOMERS report appears, and you can now CUSTOMIZE the report to suit your specific needs such as adding or removing columns, adjusting the date range, etc.

Note that this generates a list of INVOICES rather than TRANSACTIONS which I find to be an ambiguous term.

I hope this is helpful.

I agree it is easier to view invoices thorugh customer tab however taxes are included. I can not find an option to remove taxes. The taxes vary on each invoices so there is no formula to back out the tax other than reviewing every invoice.  The report option shows each line item and not an invoice sub total. There must be a way to generate a report showing 1 invoice per line with the invoice total before tax. I've been searching for a while and am getting frustrated! Can anyone help?

Is there a way to show 1 invoice per line (not multiple lines with invoice next to each line and no sub total) with the invoice total without any tax? It doesn't seem to be an option. 

Hello, Nathan-Online. 

Thank you for choosing QuickBooks as your accounting software. When you pull up an invoice of a customer, the line item will depend on how many transactions that the customer has. 

Also, for the tax, once you apply taxes on the said invoice, it will show up under the tax column. You may modify it and change it to non-taxable. 

To learn more about what reports you can create and access in QuickBooks Desktop and how to customize them, you can check out these articles: 

• Customizing reports in your QBDT
• Create, access and modify memorized reports 

Let me know if there's anything else you need from me or additional questions in QuickBooks. I'm still here to help you. Have a good one!

I want to see sum of all invoices of last month or anotker period. What should I do

Welcome back to the Community, bahadir.

I can see how essential for your business to have a report that shows the total for all invoices to date. Let’s run the Open Invoices Report and customize it to show the data you need.

The report will show all invoices for each customer and the total amount. I’ll help you build the statement.

Here’s how:

1. Go to the Reports menu at the top to choose Customers & Receivables and Open Invoices.
2. Set the correct period in the Dates field.
3. Click the Customize Report button open the Modify Report screen.
4. Choose the Display tab and remove the items that you don’t want to show on the report.
5. Hit the Filters tab and type Transaction Type in the field box to select Invoice.
6. Press the OK button.
7. Scroll down to the bottom of the page to see the total amount for invoices.

For more insights into the process, check out this article. It provides detailed information on how to use the Display, Filter, Header/Footer, Fonts & Numbers tabs: Customize reports in QuickBooks Desktop.

Additionally, this link outlines the complete instructions about customizing customer, job, and sales reports.

Please let me know if I can be of further assistance. I’ll be around to lend a helping hand. Wishing your business continued success. 

This is helpful information but how can we make the report show the invoices in numerical order with a total at the bottom rather than organized by the customer with sub-totals for each customer? Is this feature available? If there were 100 invoices created in the period selected, I'd just like to show from 0-100 in numerical order, one per line, not categorized by customer. I could manipulate in excel to get this but there must be a way to show this list in quickbooks. 

Thanks for getting back with the Community, Nathan-Online.
 

I can certainly understand how an ability to run an Open Invoices report that's not organized by customer name/totals and has a total number of invoices displayed at the bottom could be useful and have submitted a suggestion about it as of today.
 

You can also submit your own feature requests while using QuickBooks.
 

Here's how:

1. In the top menu bar, go to Help, Send Feedback Online, then Product Suggestion....
   
2. Choose a Type of Feedback and Product Area (optional) from your available drop-down menus.
   
3. Enter any suggestions/feedback in the Here is my suggestion: field.
   
4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.
   
5. Select Send Feedback.
   

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest information about your product by reviewing Intuit's Product Updates page.
 

As for your Open Invoices report being in numerical order, the report already does this for you in its Num column.

You can also export copies of your reports and further customize them in Excel if necessary.
 

Please don't hesitate to send a reply if there's any questions. Have a wonderful day!

Actualyy I want to learn how much should I have earne in the last periods . So I want to learn sum of invoices before they have been closed. For example: On December 2021 I had 50 open inoices for January 2022 . Now on February 2022 I see the total invoioices (Account Receivable is '0' ) Because I got the payments and all invoices are closed now. But I want to see on February 2022 , sum of open invoices on Jan 2022. How can I see

Hi there, @bahadir.

Since your open invoices have been closed, you won't be able to them in the Open Invoices report. 

However, you can run the Transaction List by Customer report. This way, you'll be able to see the invoices that were posted in the Accounts Receivable account. This is where the open invoices went through while waiting for the payment. 

Simply filter the report to view this data. Here's how:

1. Go to Reports and select Customers & Receivables. 
2. Select Transaction List by Customer.
3. Click Customize Report and go to the Filters section.
4. In the Account drop-down list, select All accounts receivable. 
5. Click OK.
6. Filter the Dates to Custom and enter the date. 

QuickBooks Desktop allows you to customize any report that you generate. You can filter the data it shows to draw information from your business. To get more details, check out this article: How to Customize Reports in QBDT.

Let me know how else I can help you with QuickBooks by adding a comment below. I'm more than happy to lend a helping hand. Keep safe!

This is the best answer, if you want to see Invoices by ascending or descending order or any time frame.

Others are wasting your time.

This is what I was looking for.

Thank You !!!!!

Hello ... I use the QB Desktop version, and I find it simpler to do this:

• Go to the CUSTOMER CENTER
• Click on the TRANSACTIONS tab (not the New Transactions menu!) and a selection list will be displayed
• Click on INVOICES and a list of invoices will be displayed
• Select the DATE range that includes the specific date range that you want (e.g. Last Fiscal Year for any invoices you want from last year)
• Click the RUN REPORT button at the bottom of the list of invoices and select VIEW AS A REPORT
• The INVOICES FOR ALL CUSTOMERS report appears, and you can now CUSTOMIZE the report to suit your specific needs such as adding or removing columns, adjusting the date range, etc.

Hey, this was absolutely the simplest, best!! Exported report to Excel and it has a row count so got our number of invoices for last year in under 5 minutes. Yay!! The other report instructions are not helpful because like the one client said, it gives a line by line list for each invoice which isn't what we want.

There is no Reports tab any more. What happened to it? I used it all the time, now it's gone.

Hi, Rhino.

Let's isolate why the Reports tab disappears on your end.

To start with, close all open windows. Then, go to the File menu. Under Utilities, select Verify Data. If the system prompts you with an error message, you can search for it on our QuickBooks Desktop support site for specific instructions. If you see Your data has lost integrity, you'll have to rebuild the file.

Feel free to pin these references as additional resources in managing reports:

• Customizing reports in your QBDT
• Create, access, and modify memorized reports 

I'll be around whenever you have concerns with customizing reports.

QB is dumb..incredibly stupid how people have to search through the weeds for what should be simple straight forward info..I hate this program...I despise it...it could be so much easier

Another (easier) option is to:

1.  Go to Edit, click on Find

2.   Select Transaction Type: Invoice

3.   Enter the Dates for the period you wish to generate invoices (or leave the date fields blank for ALL invoices that has ever been created)

4.   Then click Find

If you wish to generate a report of the Results:

1.  Click on Report (to the right of the results window)

2.  Or click on Export to get an Excel spreadsheet version

Can this report also include when the invoice was created and when it was emailed to the customer? 

I've got the information and the instructions about tracking the created and emailed invoices in QuickBooks Desktop (QBDT), rubenc53.
 
May I know what specific report you're referring to? You can customize a report to show when invoices are created within the program. I'll show you how:

1. Select the Reports menu, then open the report in question.
2. Click the Customize Report option.
   
   
3. Go to the Display tab.
4. Check the Entered/Last Modified option.
   
   

However, QBDT doesn't have a feature that displays when invoices are emailed in the reports. As a workaround, you can open each invoice and click the See History link to see the status flow. For more details and types of invoice statuses, check out this article: Verify that an invoice was emailed and read by the recipient.

Here's the visual reference:

I've also included the following articles for managing reports moving forward:

• Customize reports
• Create, access, and modify memorized reports
• Combine reports from two or more company data files

Drop a message below if you need further assistance with your invoices or have questions about monitoring your business finances within the program. I'm available around the clock to guide you through the process.