Exclude a "Class" from report?

Run the P&L with columns as classes. Do not apply a class filter. One of the columns will display the unclassified accounts.

My 2008 came with a P&L Unclassified.

Missed that one, so does mine.

Do question the use of QB by a company that has grown to the point where they require 1,000 expense accounts in their chart of accounts.

He said 1,000 entries, not 1,000 accounts.

And if they were using the Class feature properly there would not be 750 transactions with no class specified.

messagenews: snipped-for-privacy@news6.newsguy.com...

Haskel LPort is correct: 1,000 entries, not 1,000 accounts. It's all hypothetical to easily illustrate my issue.

I'm using QBs Pro 2005.

I only need one class to tag expenses occuring at an off-site location, all within the same time period as on-site expenses. There are two questions in this:

1. How can I get a sums for on-site expenses -- by account and combined total -- without having to manually delete the off-site entries?

1. If I do have to manually delete the off-site expenses, how can I save the original file and restore it after deleting the off-site expenses?

Thanks,

You can get to this data a couple of ways.

One way is to run the Profit and loss by class report for the period in question. You will get 3 columns of data: Off-site, Unclassified and Total. I believe that you can also modify the report and select the Offsite Class for the report. You just can not select the Unclassified class. (one reason to alway specifiy a class if you are going to use that feature).

Another way is to run a Custom Transaction report and make sure the class column is included in the report. Again filter the report to only select the "off site" class transactions.

Thanks. You're correct. My problem is that I've been asked to generate a hardcopy print-out showing only the UN-classed entries. He doesn't want it to show the classed (off-site) entries at all.

Am I correct in assuming that it cannot be done without manually deleting the classed entries?

If I do have to delete the classed entries, is there a way to restore the entire original file without having to manually re-enter the classed entries I deleted?

Thanks again for your help.

Does that report HAVE to be generated out of QuickBooks or can a report printed from Excel be acceptable?

There is no need to delete the classed entries. Under Reports>>Company & Financial look for the Profit & Loss Unclassified report. That is exactly what you are looking for. If you think this will be a regular request you might discuss recoding those "unclassified" transactions with a meaningful class so that you can utilize the QB reports.

If you needed to do something like this I would make a backup file, make my changes and then restore the back up file.

If I was going to do something like this I would not delete those unclassified transactions. I would code them with a meaningful class value instead. That would make using the QB report filters easier in the future.