LIMITED TIME 90% 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.
CaliberAccounts
Level 2

Open Invoices Report

I'm running the Customers > Open Invoices report as of 12/31/2024.  This is the same report we used for EOY last year.  This year for some reason the same report is giving us the open balance as of today, NOT as of the Last Fiscal Year (12/31/2024.)  

 

For example, I'm looking at a 12/20/2024 invoice for $12,820.00.  It was paid on 2/12/2025 but was entirely unpaid as of the report date 12/31/2024.  Yet QuickBooks is reporting the balance as of today.  It didn't do this last year.  

 

How do I fix this to report the correct open amount as of the closing date of 12/31/2024?

Solved
Best answer February 25, 2025

Best Answers
CaliberAccounts
Level 2

Open Invoices Report

I found the answer thanks to a coworker.  You have to go to Customize Report > Advanced > Open Balance - Report Date

Why the default for a date range (12/31/2024) would default to not using the selected date range is way beyond me.

View solution in original post

1 Comment 1
CaliberAccounts
Level 2

Open Invoices Report

I found the answer thanks to a coworker.  You have to go to Customize Report > Advanced > Open Balance - Report Date

Why the default for a date range (12/31/2024) would default to not using the selected date range is way beyond me.

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

Need to get in touch?

Contact us