Home Page link  

Very odd problem - Category Groups in Reports

  
Groups | Search | About
User Password
Register Now! Lost Password?

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Very odd problem - Category Groups in Reports Mike C 12-20-2006
Posted by Mike C on December 20, 2006, 3:07 pm
Please log in for more thread options
 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.


Posted by John Pollard on December 20, 2006, 6:11 pm
Please log in for more thread options
>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.

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.



Posted by Mike C on December 21, 2006, 10:20 am
Please log in for more thread options

John Pollard wrote:
>
> >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.
>
> 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.

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.


Posted by Jim Jensen on December 21, 2006, 12:05 pm
Please log in for more thread options
>> 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.

> Yes, I noticed they were coming from investment accounts in split
> transactions.
>=20
> 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.

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.




Posted by Mike C on December 21, 2006, 5:37 pm
Please log in for more thread options

Jim Jensen 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.
>
> > 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.
>
> 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.

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.


Similar ThreadsPosted
Problem Formatting Reports February 25, 2007, 3:57 pm
Classes vs groups vs categories November 9, 2006, 10:00 pm
Add groups to Spending & Savings accounts? May 20, 2007, 4:31 pm
DSL and Cable Companies dropping all alt. news groups June 19, 2008, 9:58 pm
category reassignment. January 25, 2007, 8:14 pm
Category to SubCategory June 14, 2007, 5:31 pm
Investment Category? September 13, 2007, 2:12 pm
category list February 16, 2008, 10:27 pm
How to force use of _DivIncTaxFree category? February 1, 2007, 5:28 pm
Can't create a new income category May 29, 2006, 2:51 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap