Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
jbNIS23
Level 1

Closed Sales Order Report

Hi,

 

How to create a report in QB Desktop Enterprise Accountant 24.0 that shows only closed sales orders but have not been invoiced.

 

I attempted to create one using: Customers & Receivables ~ Transaction List by Customer

 

Filters used: 

  • Paid Status: Closed
  • Posting Status: Non Posting
  • Transaction Type: Sale Oder

 

This semi works but also shows some open sales orders on the report. I only want to see ones that have been marked closed but not invoiced.

 

Thank you

 

 

1 Comment 1
RheaMaeH
QuickBooks Team

Closed Sales Order Report

QuickBooks Desktop Enterprise doesn't have a built-in report that displays only closed sales orders that have not been invoiced, jbNIS23.

 

When generating reports, such as the Transaction List by Customer, open sales orders may still appear because the Paid Status filter indicates whether an invoice or payment exists for a transaction, rather than determining whether the sales order itself has been marked as Closed.

 

The Mark as Closed feature on sales orders indicates that the transaction is no longer active. Since QuickBooks doesn't provide a direct filter for closed sales orders, these transactions don't appear in reports, which primarily focus on open or active items.

 

To help identify closed sales orders that have not been invoiced, you can manually add a note in the MEMO field to determine these transactions.

 

Here's how:

 

  1. Open the Sales order you want to mark.
  2. In the MEMO field, add a note such as Closed - Not Invoiced to indicate its status
  3. Click Save & Close once finished.
    Screenshot 2025-10-23 011519.png

 

Once you've added notes in the MEMO field, you can customize your report to display this information. Please note that this approach doesn't automatically filter out open sales orders from the report.

 

Here's how:

 

  1. Navigate to the Reports menu.
  2. Select Customers & Receivables and choose Transaction List by Customer.
  3. Click the Customize Report button.
  4. In the Display tab, check the Memo field under the COLUMNS section to include it in the report.
  5. Once completed, click OK.
    Screenshot 2025-10-23 011619.png

 

You can revisit this thread if you have follow-up questions.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us