Open Sales Orders Report

You can run a Open Sales Orders report by Customer, @NelsonLPI. This report will show pending sales orders with their due date.

Here's how:

1. Go to Reports from the top menu.
2. Select Sales.
3. Choose Open Sales Orders by Customer.
4. You can customize the Dates to show the period you want to check.

For future reference, read through this article and learn about customizing your report to show the details that only matter to you and your business. 

To learn more about the different ways to track your transaction in QuickBooks Desktop, feel free to read the details from this link.

That should point you out in the right direction today. Let us know if you have any other QuickBooks questions.

I ran the report "Open Sales Orders by Customer".

I added DUE DATE to the columns, and opened my date range up to start at on May 1 (so I could see sales orders that were created within the last 5 weeks - this should capture any open sales orders).

I clicked on sort by DUE DATE - but it is still sorting by customer name in alphabetical order.

And it shows all sales orders created, even with due dates in July (which I don't really want to see right now).

All I really want to see is a quick snapshot that shows the sales orders that are due to be completed by the end of this month (regardless of when they were created).  I am just trying to estimate remaining sales for the month, based on the sales orders that are scheduled to be complete this month....

Thank you for providing additional details, NelsonLPI. To manage the unwanted dates in your report, we can export the report to Excel and manually remove those dates.

It's important to note that the Open Sales Order report captures transactions based on their creation date, not the due date. For instance, if you have two sales orders created on June 1, 2025—one due on June 30, 2025, and another on July 30, 2025—both will appear in the report if your selected date range covers June.

Here’s how to export the report to Excel:

1. Click the Excel button and choose either Create New Worksheet or Update Existing Worksheet. 
2. Hit Export.
3. Follow the on-screen instructions to specify where you want to save the file.

You can also memorize your reports to save your customizations for future use.

Please return to this thread if you have other questions about your reports.