cancel
Showing results for 
Search instead for 
Did you mean: 
KenSmith
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
HoneyLynn_G
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 6
HoneyLynn_G
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!

KenSmith
Level 2

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

Perfect!  Thanks, @HoneyLynn_G 

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!

MikeInMpls
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

Mark_R
Moderator

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.

MikeInMpls
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 expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us