How can I keep accounts with 0 balances from printing on reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an old copy of Quick Books Pro and am dumping into an Excell
spread sheet. How do I not print old accounts with 0 balances? When I make
them inactive in Quick Books they still show up on all reports. Thanks
 
Coahoma said:
I am using an old copy of Quick Books Pro and am dumping into an Excell
spread sheet. How do I not print old accounts with 0 balances? When I make
them inactive in Quick Books they still show up on all reports. Thanks
Click to expand...

Not really an Excel question unless you want to know how to delete the
rows with 0 balances. If you go to modify reports in QB select amount
and it should give you a choice of All, >, < , >=, <=. Select > than 0.
This should limit all of the 0 balnces off your report.

gls858
 
You can do it with formatting Format, Cells, Custom
Make the 3rd operand empty
so if you General change it to General;General;;

Also of interest Tools, Options, View
[x] Zero Values should be checked to show zero values
but you can uncheck it and zero values will not show, but you
won't know if it is zero, or empty, so it would be better to
do your exceptions with formatting.
 
You can set up an autofilter to cover your Balance column, and then on
the pull-down for the filter select Custom | Does Not Equal | 0 (zero)
and then the rows which do contain 0 will be hidden.

Hope this helps.

Pete
 
Back
Top