Home Page link  

parent/child category questions (Q08)

 

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
parent/child category questions (Q08) Scott Lindner 10-20-2007
Posted by Scott Lindner on October 20, 2007, 8:15 am
Please log in for more thread options
I've long had a gripe that sometimes Quicken (I just upgraded to 08) treats
the parent category as the total of everything below it, and sometimes it
treats the parent as everything that is assigned to the parent only
(parent:other), and not directly to any of its child categories. It isn't
consistent. Besides the inconsistency, in my view (but there could be other
views) it should always be the roll up of everything beneath it. Is there
an option to change this behavior?

In particular I have heartburn with the default behavior in the budget. I
have several categories that I simply want to allocate a budget to the
parent only, and don't care how it gets spent with the child categories.
You can't do this in Q. Or I haven't figured it out. Does anyone have any
comments on this, or solutions?

Cheers,
Scott

PS - If you're one of those Nazi financial planners that's going to tell me
to reduce all of our categories down to "Income" and "I spent it" don't
bother posting, my wife and I really enjoy the reports we can generate on
our spending habits.



Posted by Guy Scharf on October 20, 2007, 10:37 am
Please log in for more thread options

> In particular I have heartburn with the default behavior in the
> budget. I have several categories that I simply want to allocate
> a budget to the parent only, and don't care how it gets spent with
> the child categories. You can't do this in Q. Or I haven't
> figured it out. Does anyone have any comments on this, or
> solutions?

I also have several categories where I want to track expenses for sub-
categories but care about budget only for the parent category. What I
do is distribute the budget for the parent to the children, based on
averages for the past year. Then I monitor only the rolled-up total on
the reports.

I'm also careul never to allow expenses to fall into an Other
subcategory. At the end of each month, I examine the expense report
for the month and correct any entries have have fallen into an Other
subcategory.

You say you "don't care how it gets spent with the child categories."
I suspect you are like me and don't care for budget purposes but do
care for other purposes. If not for any purpose, then that's an
argument for consolidating the cateogry.

Guy

Posted by Scott Lindner on October 20, 2007, 10:46 am
Please log in for more thread options
> You say you "don't care how it gets spent with the child categories."
> I suspect you are like me and don't care for budget purposes but do
> care for other purposes. If not for any purpose, then that's an
> argument for consolidating the cateogry.

Exactly! There are some details we like to keep separated so we know how
we're spending our money, but for most cases we like to budget at a much
higher level.

So you deal with some of the displays that show you the most off budget
categories because Q doesn't treat the parent as the sum of all
subcategories, and then use other reports to see how you're performing on
your budget?

Why do you avoid "other" categories? The only reason I can assume you'd do
this is so the sum of all subcategories equals the parent, but couldn't you
consider "other" as being another child? What I've been doing is there are
some child categories that I find very useful to separate for reporting
reasons. However, there are other things that belong to the parent, but I
don't see any value in creating special sub categories for them because
their total value on an annual basis is way too small to care. Maybe that
is what's making it difficult for me to create a workable budget in Q?

Scott



Posted by Guy Scharf on October 20, 2007, 9:31 pm
Please log in for more thread options

>> You say you "don't care how it gets spent with the child
>> categories." I suspect you are like me and don't care for budget
>> purposes but do care for other purposes. If not for any purpose,
>> then that's an argument for consolidating the cateogry.
>
> Exactly! There are some details we like to keep separated so we
> know how we're spending our money, but for most cases we like to
> budget at a much higher level.
>
> So you deal with some of the displays that show you the most off
> budget categories because Q doesn't treat the parent as the sum of
> all subcategories, and then use other reports to see how you're
> performing on your budget?

I'm not sure what you mean by "Q doesn't treat the parent as the sum of
all subcategories." Mostly it does, unless you exclude some
subcategories from a report; that can confuse issues. I pay almost no
attention to the budget excesses report on the Quicken home page; I
find that an essentially useless curiosity. I look at two budget
reports monthly: last month and year to date. Those reports give us
guidance for the spending during the upcoming month. During the month,
I will sometimes look at the current month report to see how things are
going and whether we need to correct any spending.

> Why do you avoid "other" categories? The only reason I can assume
> you'd do this is so the sum of all subcategories equals the
> parent, but couldn't you consider "other" as being another child?
> What I've been doing is there are some child categories that I
> find very useful to separate for reporting reasons. However,
> there are other things that belong to the parent, but I don't see
> any value in creating special sub categories for them because
> their total value on an annual basis is way too small to care.
> Maybe that is what's making it difficult for me to create a
> workable budget in Q?

I avoid "other" categories because it's impossible to tell the
difference between a true "other" and an expense that has been sloppily
placed in the "other" category instead of its proper subcategory. Now,
I don't do that 100%. I do have one category where the child is used
to separate out some expenses but most of the expense goes into the
parent category. That developed when I combined two separate
categories by making one a subcategory of the other.

However, in most cases, a category is divided into discrete
subcategories. For example, the Taxes category has subcategories for
each specific kind of tax. It makes no sense to (for later tax
reporting purposes) to record something as a "tax" but not which kind
of tax. My Medical category has eight or so subcategories, and they
cover every reasonable division of medical expenses. When I later
prepare my tax return, I essentially copy the total of each subcategory
to the tax return.

We have a category for dining out, with subs for breakfast, lunch,
dinner, and snacks. This is an example where we have to make budgets
for the subcategories but monitor only the rolled up totals for the
Dining category. Medical is a mixed bag, where I monitor expense
against budget for some categories but also monitor the rolled up
totals.

Guy

Posted by Oilcan on October 21, 2007, 2:04 pm
Please log in for more thread options
I will say upfront that I do not use the Budget feature in Quicken. I have
always found it too complex to set-up. Of course I am probably making it
more difficult then necessary. :)

What I am doing in Q2008 is to use more of the TAGS feature to consolidate
subcategories back into the parent. Although TAGS aren't really different
then CLASSES in earlier versions, they are now easier to work with. About
the only place left I still have some subcategories is to breakout items for
income taxes - I have not spent the time to see if consolidating makes
sense.

The example for Breakfast, Lunch, Dinner and Snacks is a great use for TAGS.

Oilcan

>
>>> You say you "don't care how it gets spent with the child
>>> categories." I suspect you are like me and don't care for budget
>>> purposes but do care for other purposes. If not for any purpose,
>>> then that's an argument for consolidating the cateogry.
>>
>> Exactly! There are some details we like to keep separated so we
>> know how we're spending our money, but for most cases we like to
>> budget at a much higher level.
>>
>> So you deal with some of the displays that show you the most off
>> budget categories because Q doesn't treat the parent as the sum of
>> all subcategories, and then use other reports to see how you're
>> performing on your budget?
>
> I'm not sure what you mean by "Q doesn't treat the parent as the sum of
> all subcategories." Mostly it does, unless you exclude some
> subcategories from a report; that can confuse issues. I pay almost no
> attention to the budget excesses report on the Quicken home page; I
> find that an essentially useless curiosity. I look at two budget
> reports monthly: last month and year to date. Those reports give us
> guidance for the spending during the upcoming month. During the month,
> I will sometimes look at the current month report to see how things are
> going and whether we need to correct any spending.
>
>> Why do you avoid "other" categories? The only reason I can assume
>> you'd do this is so the sum of all subcategories equals the
>> parent, but couldn't you consider "other" as being another child?
>> What I've been doing is there are some child categories that I
>> find very useful to separate for reporting reasons. However,
>> there are other things that belong to the parent, but I don't see
>> any value in creating special sub categories for them because
>> their total value on an annual basis is way too small to care.
>> Maybe that is what's making it difficult for me to create a
>> workable budget in Q?
>
> I avoid "other" categories because it's impossible to tell the
> difference between a true "other" and an expense that has been sloppily
> placed in the "other" category instead of its proper subcategory. Now,
> I don't do that 100%. I do have one category where the child is used
> to separate out some expenses but most of the expense goes into the
> parent category. That developed when I combined two separate
> categories by making one a subcategory of the other.
>
> However, in most cases, a category is divided into discrete
> subcategories. For example, the Taxes category has subcategories for
> each specific kind of tax. It makes no sense to (for later tax
> reporting purposes) to record something as a "tax" but not which kind
> of tax. My Medical category has eight or so subcategories, and they
> cover every reasonable division of medical expenses. When I later
> prepare my tax return, I essentially copy the total of each subcategory
> to the tax return.
>
> We have a category for dining out, with subs for breakfast, lunch,
> dinner, and snacks. This is an example where we have to make budgets
> for the subcategories but monitor only the rolled up totals for the
> Dining category. Medical is a mixed bag, where I monitor expense
> against budget for some categories but also monitor the rolled up
> totals.
>
> Guy


Similar ThreadsPosted
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
Help - Memorized Payees don't insert category December 16, 2006, 9:49 pm
Very odd problem - Category Groups in Reports December 20, 2006, 3:07 pm
Can Quicken automatically put a category to a payee? April 19, 2007, 12:18 pm
Bank Account Category Field September 4, 2007, 9:52 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