Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHow do I run an aging or open invoices report for a previous point in time?
For example, I want to run a detailed report as of July 31, 2021. When I run an open invoice report with that date, it doesn't show me what was open at that time, it only shows me what is open NOW with a date prior to July 31.
How do I run a historical report?
Hello there, @dLearned. Allow me to help you run a report that shows all your open invoices.
You'll need to pull up an Open Invoices Report to see all the open invoices. You can use the Filter feature to view open invoices under a specific date.
To begin with, here’s how:
In case you want to print a copy of the report, click the Printer icon beside the Envelope icon.
For visual reference, please refer on the screenshot below.
Let me know if you have other QuickBooks related question. I’d be more willing to help you sort it out. Keep safe!
Thank you! It was the "unpaid" that was problematic I think.
Now, is there a way to produce the same report but with product detail OR with sales tax included?
Good to see you back, dLearned.
In QuickBooks Online (QBO), we have the Sales by Location Detail that you can run. We can customize the report to show all paid and unpaid invoices together with the Product/Service and Tax amount.
To run the report to have what you need. Let me show you:
That's it! You'll have the data you're looking for dLearned.
To learn more about running reports in QBO, visit these articles:
If you need further assistance in managing your account, leave me a comment below. It's always a pleasure to help you. Take care.
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