Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

What does checking the box do  vs.  unchecking it?

Solved
Best answer March 19, 2019

Best Answers
QuickBooks Team

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

Hi there, @KenSmith.

 

Thank you for visiting us today. I can share the difference between checking and unchecking the "Except zero amount" box on the reports.

 

You have a lot of options in customizing QuickBooks Online (QBO) reports. One of which is the "Except zero amount" box.

 

Checking this box will leave the field blank if it has no corresponding information. However, if you uncheck it, the report will automatically zero out the fields.

 

Please see this sample report below.

 

 

 

 

That should keep you going today, @KenSmith. Let me know if you have additional questions about customizing reports. I'm still here to help you more. Have a good one!

View solution in original post

6 Comments
QuickBooks Team

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

Hi there, @KenSmith.

 

Thank you for visiting us today. I can share the difference between checking and unchecking the "Except zero amount" box on the reports.

 

You have a lot of options in customizing QuickBooks Online (QBO) reports. One of which is the "Except zero amount" box.

 

Checking this box will leave the field blank if it has no corresponding information. However, if you uncheck it, the report will automatically zero out the fields.

 

Please see this sample report below.

 

 

 

 

That should keep you going today, @KenSmith. Let me know if you have additional questions about customizing reports. I'm still here to help you more. Have a good one!

View solution in original post

Level 2

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

Perfect!  Thanks, @HoneyLynn_G 

QuickBooks Team

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

I'm glad to know that I was able to help you today, KenSmith.

 

Please remember I'm here anytime you have additional questions or concerns with QuickBooks Online. Just feel free to leave a comment/post here in the Community.

 

Wishing you and your business continued success!

Level 1

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

I am a 'newbie'  to QBO.  Apologies if I am just missing something... but I do not see the "Except zero amount" box referenced in this thread.  Where can I find this function.  I would like to display 'zeros' rather than 'blanks'. Can I find it elsewhere?  Many thanks! Mike

QuickBooks Team

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

I can see from your screenshot that you're running the Budget vs. Actuals report, @MikeInMpls.

 

At this time, the Except zero amount option isn't available in the Budget vs. Actuals report. You can consider utilizing the Show non-zero or active only option to remove all the zero amount.

 

Here's how:

 

  1. Click Reports from the left menu.
  2. Search for Budget vs. Actuals report from the field.
  3. From the Show non-zero or active only section, select Non-zero from both Show rows and Show columns.
  4. Click Run report.

However, if you're running financial reports, like Profit and Loss, Balance Sheet, and Trial Balance, you can find the option from the Customize button. Let me show you how.

 

  1. Click Reports from the left menu.
  2. Search for a financial report from the field.
  3. Select the Customize button.
  4. From the Number format section. put a checkmark in the Except zero amount checkbox.
  5. Click Run report.

Here's an article you can read for more details: Customize reports in QuickBooks Online.

 

Just in case you want to memorize this report, you can check out this article for more guidance: Memorize reports in QuickBooks Online.

 

Please know you can continue to reach me here with any additional questions. Thanks for coming to the Community, wishing you continued success.

Level 1

Customize a report's number format: option to Check or Uncheck the "Except zero amount" box

Thank you!  I will work through your suggestions.

 

Mike

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us