Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi, I would like to create a report that shows all our open sales orders totaled by due date (preferably month), so we can get a good look at our future sales. I'd like to see the total sales scheduled to close in October, November, and December, for instance. Thank you.
Solved! Go to Solution.
You can create a transaction detail report that shows the Due Date, and sort on the Due Date, but there isn't a way to total by the Due Date month (or any other date's Month, as far as I know) within QuickBooks.
Probably the best way using QB reports is to export such a report to Excel and then subtotal it by month manually.
You can create a transaction detail report that shows the Due Date, and sort on the Due Date, but there isn't a way to total by the Due Date month (or any other date's Month, as far as I know) within QuickBooks.
Probably the best way using QB reports is to export such a report to Excel and then subtotal it by month manually.
Okay, thank you.
Greetings, @pantone06.
I appreciate you visiting us here again in the Community. Allow me to chime in and add some information about the report you'd like to run in QuickBooks Desktop (QBDT).
As mentioned by BigRedConsulting above, the option to pull up the Open Sales Order by Due Date report is unavailable in QBDT. However, you can run the Open Sales Order by Customer report instead. Then, customize it to add the Due Date.
Here's how to do it:
You can also check out this article for more information about customizing sales and other reports in QBDT: Customize customer, job, and sales reports in QuickBooks Desktop.
In case you need it, I'm adding this article that tackles exporting reports to Excel for future reference: Export reports as Excel workbooks in QuickBooks Desktop.
Fill me in if you have further questions. I'll be around if you need any help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here