Why does the planning tab and current budget report have different totals when using subcategories??

Question

So I have a Utilities category and then several subcategories under it.  One subcategory underneath it is called "Telephone".  Under "Telephone" I have more subcategories - "Home", "Internet", and "Cell" since they come from different providers.  So year to date I have a $0 balances for Internet and Home but a $2.64 surplus in Cell which is accurate.  This $2.64 surplus is rolled up into its parent category - "Telephone" which then shows a $2.64 surplus which again is accurate.  The problem occurs because the overall category - "Utilities" adds both of these together and shows a $5.28 surplus which is wrong.   However, this is only under the Planning tab.  If I pull a current budget report it shows the overall category - "Utilities" as a $2.64 surplus which is correct.

Since I usually build my budget and refer daily to the Planning Tab I'd like to get this fixed.  Am I doing something wrong or is this a bug in Quicken?

Sherlock · Answer

The November balance for Utilities is correct: 500 + .40 + 31.18 = 531.58

You have not provided sufficient prior months to check the calculation for the Utilities To Date balance.

The November balance for Food is correct: 298.84 - 215.71 = 83.13

You have not provided sufficient prior months to check the calculation for the Food To Date balance.

Doug Mundrick · Answer

Here is another example.  In this case there are two subcategories to Food:  Restaurants and Other.  However, in the to date balance for Food, it only includes the Restaurants in the total and ignores the Other subcategory.

Can you tell me what is going on?

image.png

Doug Mundrick · Answer

I am using Quicken Deluxe for Windows Version R30.10 Build 27.1.30.10.  I've attached two snips.  The first shows the top half of the Utilities category.  The second shows the bottom of the category.  You can see that it overlaps.

If you look at cellular to date balance it shows $2.48.  Cellular is a subcategory to Telephone.  The telephone to date balance shows the correct figure of $2.48 which adds up Cellular, Internet and Everything Else.  Telephone is a subcategory to Utilities. However, the utilities total to date balance is $573.73.  It should be $576.21. It has included the $2.48 twice in its total.  This issue also occurs with other categories where I have a subcategory to a subcategory.

I can't recall when this started but I think its been a while.

image.png

Snip 2.PNG