Very odd problem - Category Groups in Reports

I am experiencing an odd problem I haven't seen until this week. This is in Quicken H&B 2006.

I have a category Services Fees and that is assigned to Category Group Misc. If I do a P&L report (which is one of few that allow grouping expenses by category groups), I get a line under Misc for Service Fees with an amount of -$160. When I double click, it brings up all the transactions totalling -$160. The problem is that at the top of the report, under a heading "Unassigned", there is a line for Service Fees with an amount of -$21. When I double click that, I get a listing that totals -$181!

I verfifed the transactions are indeed assigned category service fees and that there is only 1 category "Service Fees" and not something similar (like "Service Fee"). This is happening for 1 category and 2 sub-categories under completely different categories. I am not sure why a few of these transactions are getting misclassified. I tried validating my file, and no change. I'll add this report worked for at least a year before experiencing the problem.

Reply to
Mike C
Loading thread data ...

"Mike C" wrote

I believe you are experiencing a known Q2006 problem. I don't remember the details at the moment (though I think I can find some of them, if necessary). See if the problem amounts (transactions) are coming from investment accounts ... maybe from split transactions in investment accounts. If I recall correctly, there is no solution for Q2006.

Reply to
John Pollard

Yes, I noticed they were coming from investment accounts in split transactions.

It is sad they put out these new versions every year and expect you to pay to upgrade and they don't even fix exisitng problems. My opinion is they just add features that are designed to make them more money like links to their site and affiliates. There are many useful features I've wanted for years and they don't add those.

Reply to
Mike C

I just upgraded from Q2005 to Q2007 and had a problem reconciling my balance sheet to my profit and loss statement. It's a "checks and balances" thing for me that lets me know I've assigned a category to every transaction, and I was in balance before the upgrade. This is what I observed:

If you have a split transaction in an investment account (in my case, a deposit of $20,000, recorded in the same category, but split between two different classes), the entire transaction is improperly ignored in the balance sheet, unless you check the "include unrealized gains" box in the report settings. If the same transaction is NOT split, the transaction is properly included in the balance sheet regardless of the "include unrealized gains" report setting. In all cases, the transaction is properly included in the profit and loss statement.

That one took awhile to track down since, in Q2005 and earlier, I never needed the "include unrealized gains" setting.

Reply to
Jim Jensen

sheet to my profit and loss statement. It's a "checks and balances" thing for me that lets me know I've assigned a category to every transaction, and I was in balance before the upgrade. This is what I observed:

deposit of $20,000, recorded in the same category, but split between two different classes), the entire transaction is improperly ignored in the balance sheet, unless you check the "include unrealized gains" box in the report settings. If the same transaction is NOT split, the transaction is properly included in the balance sheet regardless of the "include unrealized gains" report setting. In all cases, the transaction is properly included in the profit and loss statement.

the "include unrealized gains" setting.

I tried checking "include unrealized gains" and got the same result. Oh well. Their reports are wrong and they don't seem to care. It is not a mis-classification issue. When I looked more into it, amounts are being counted 2X!

I really want to switch to MS Money. Over the years, Quicken/Intuit really have aggravated me, I switched last year to TaxCut to do my taxes. The problem with switching to Money is I have over 10 yrs of data in Quicken and the import has problem with certain data requiring major clean-up.

Reply to
Mike C

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.