Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
mischa3176
Level 1

historical open invoice list

Hello everyone, in QB I can access an invoice list with the open balance per invoice as of today. I need a similar report, but with a specific date, for example, as of 12/31/2023. This report should show the outstanding balance per invoice as of 12/31/2023. Does anyone know if this is possible or how I can achieve this in another way?

1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

historical open invoice list

We’ve got you covered, mischa3176.

 

We appreciate you for performing the initial steps in trying to find a report for all open balances per invoice. Let us help find a report that will show the outstanding balance per invoice for a specific period.

 

We can run the Invoice List report to see open invoices and open balances in QuickBooks Online (QBO). Then, set the date to 12/31/2023 however, the due date will always differ from it. I've attached a screenshot with a different sample date for your reference:

 

invoice list1.png

 

Here's how to run and customize the report:

 

  1. Go to the Reports tab on the left-hand menu bar.
  2. Enter Invoice List in the search bar and click on the option.
  3. Click the Switch to classic view link. 
  4. In the Report period, choose Custom dates and manually enter the period you need.
  5. Hit Customize
  6. Select the filter section and choose the Due Date and Created Date options. 
  7. Hit Run Report when done. 

 

This reference provides in-depth information about the process: Customize reports in QuickBooks Online. It includes instructions on how to share custom reports and automate one.

 

Moreover, the resources below will guide you on how to handle any customer-related activities. You’ll also see the list of reports for your QuickBooks subscription:

 

 

Drop a comment below if you have additional questions about running an open invoices report or other QuickBooks concerns. We’ll get back to make sure this is taken care of for you. Wishing your business continued success, mischa3176.

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

Need to get in touch?

Contact us