cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Invoice & Sales report

I want to create a report that will show me my invoice total and sales order total for the year.  The total will be different.  Some order will have handling and shipping fees added to the invoice.  

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

You can run a Sales Report, such as Summary by Customer,...

You can run a Sales Report, such as Summary by Customer, or as Detail. Then, you filter on Transaction type = Sales Order, to see only SO. Or, filter on Posting Status = Either, to see all invoices, sales receipts, credit memos, sales orders and estimates. A summary report will make no sense, of course, because the SO and the invoices would be overlapping the same info (order and sale).

View solution in original post

8 Comments
Established Community Backer ***

You can run a Sales Report, such as Summary by Customer,...

You can run a Sales Report, such as Summary by Customer, or as Detail. Then, you filter on Transaction type = Sales Order, to see only SO. Or, filter on Posting Status = Either, to see all invoices, sales receipts, credit memos, sales orders and estimates. A summary report will make no sense, of course, because the SO and the invoices would be overlapping the same info (order and sale).

View solution in original post

Not applicable

This report provides item by item.   I also want a report...

This report provides item by item.   I also want a report which shows Invoice LIST: name & Grand Total only.  Thank you :-)
Established Community Backer ***

Which report is "this report?" I recommend a Few. Did you...

Which report is "this report?" I recommend a Few. Did you run Sales by Customer Detail? Did you run Customer Transaction report, filter on Transaction Type = Sales? Did you run a Quick Report on your AR, for Transaction Type = AR? No one can help you specifically, because we don't know how you use QB and you commented in a topic that was not started by you, so there is no Specific info. Please start your own topic, and make sure to select which QB Product you are using, and give your question some specific details, and then you are more likely to get Specific Help. Thanks.
Not applicable

Hi corey, Let me help you with this. Right now, you can o...

Hi corey,

Let me help you with this.

Right now, you can only pull up Custom Transaction Detail Report and customize it to show all the total amount of the Invoices or Sales order separately. There is no particular report that will show you both the invoices and sales order in one place.

Here's how to customize the report to show the total amount of invoices:

  1. Click Reports at the top menu bar.
  2. Select Custom Reports and select Transaction Detail.
  3. Click Customize Report at the top left of the report.
  4. Click the Filters tab and under the Filter box select Transaction Type.
  5. Under Transaction Type, select Invoice (screenshot attached).
  6. Hit OK.

You can follow the same steps in pulling up Sales Order total but after you select Sales Order under the Transaction Type, you have to select Posting Status under the Filter box and choose Non-posting (screenshot attached). 

Please let me know if you have other concerns. Take care, corey!

Frequent Explorer *

Re: Hi corey, Let me help you with this. Right now, you can o...

Is there a way to get the invoice totals without seeing the line items?

Thanks,

QuickBooks Team

Re: Hi corey, Let me help you with this. Right now, you can o...

Yes, there is, AlabamaPamela. Just remove the Item column. 

 

Let me show you how: 

  1. Go to Reports and select Custom Reports
  2. Select Transaction Detail
  3. In the Search column field, type Item and then uncheck it. 
  4. Click OK

 

You can also refer to the customize reports article that'll help you pull up the report you need. 

 

Keep me posted if there's anything else that I can help you with. 

Frequent Explorer *

Re: Hi corey, Let me help you with this. Right now, you can o...

Thank you -  I looked there to begin with and just missed it.

I appreciate it.

Content Leader

Re: Hi corey, Let me help you with this. Right now, you can o...

Thanks for taking the time to follow up with us, @AlabamaPamela.

 

It's great to know that you found the information helpful and were able to utilize the option for your reporting. 

 

The Community is always here for you, so please let us know if we can be of further assistance. Cheering you to a wonderful weekend ahead!

Need to get in touch?

Contact us