cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
cjkhunt
Level 1

Open Invoice Report-showing zero dollar balance for customers.

Hello- need some help with my "Open Invoice" Report. When I pull this report it prints some customers showing a "0" dollar balance. I onl

Solved
Best answer September 22, 2020

Accepted Solutions
RCV
QuickBooks Team
QuickBooks Team

Open Invoice Report-showing zero dollar balance for customers.

We can perform some troubleshooting steps to get the Open Invoice report working and provide you the correct data, cjkhunt.

 

This report lists unpaid invoices and statement charges, grouped and subtotaled by customer and job. Before performing any steps, let's make sure QuickBooks is updated to the latest release.

 

Then, try changing the period covered. Just click the Dates drop-down list and choose a different date range or change the dates shown in the From and To fields. Once done, click the Refresh tab to give you the right report data.

 

If the same thing happens, let's try opening another company file to check if you're having a problem with only one file and not the program itself. Here's how:

 

  1. In your QuickBooks, go to the File menu at the top left.
  2. Choose Close Company.
  3. In the No Company Open window, click the drop-down arrow in the Open a sample file icon.
  4. Choose a sample file and click on it.

Then, try running the report again. You can also customise the report, just follow the steps in this article: Customise customer, job, and sales reports in QuickBooks Desktop

 

If it works, it's possible there's a damaged data on the company file you've been working with. Just run the Rebuild Data tool is built-in to fix any company file data issues. You can check out this article for the steps and details: Fix data damage on your QuickBooks Desktop company file.

 

We can also repair your software to fix any damaged component in QuickBooks. This also fixes any errors while using, installing, or updating QuickBooks. See the Repair your QuickBooks Desktop for Windows article for more details.

 

I have a link here that provides you with articles about managing your reports in your software: Setting up reports to customise, run, and share.

 

You can always count on me if you need a hand with memorizing your reports or any QuickBooks related. Assistance is just one post away. Have a great day ahead.

View solution in original post

1 REPLY 1
RCV
QuickBooks Team
QuickBooks Team

Open Invoice Report-showing zero dollar balance for customers.

We can perform some troubleshooting steps to get the Open Invoice report working and provide you the correct data, cjkhunt.

 

This report lists unpaid invoices and statement charges, grouped and subtotaled by customer and job. Before performing any steps, let's make sure QuickBooks is updated to the latest release.

 

Then, try changing the period covered. Just click the Dates drop-down list and choose a different date range or change the dates shown in the From and To fields. Once done, click the Refresh tab to give you the right report data.

 

If the same thing happens, let's try opening another company file to check if you're having a problem with only one file and not the program itself. Here's how:

 

  1. In your QuickBooks, go to the File menu at the top left.
  2. Choose Close Company.
  3. In the No Company Open window, click the drop-down arrow in the Open a sample file icon.
  4. Choose a sample file and click on it.

Then, try running the report again. You can also customise the report, just follow the steps in this article: Customise customer, job, and sales reports in QuickBooks Desktop

 

If it works, it's possible there's a damaged data on the company file you've been working with. Just run the Rebuild Data tool is built-in to fix any company file data issues. You can check out this article for the steps and details: Fix data damage on your QuickBooks Desktop company file.

 

We can also repair your software to fix any damaged component in QuickBooks. This also fixes any errors while using, installing, or updating QuickBooks. See the Repair your QuickBooks Desktop for Windows article for more details.

 

I have a link here that provides you with articles about managing your reports in your software: Setting up reports to customise, run, and share.

 

You can always count on me if you need a hand with memorizing your reports or any QuickBooks related. Assistance is just one post away. Have a great day ahead.

Need to get in touch?

Contact us