Graphing of "Projected Balances" in "Bills & Income" does not work properly

Jeff_W
Jeff_W Quicken Windows Subscription Member

I'm trying to make sure my bank account balance doesn't fall below $0 when I integrate the two accounts in the Projected Balances option in Quicken. As shown in the images below, I've selected just two accounts and left the box "Show Separate Accounts" unchecked so it will integrate together and compute the balance over time using the upcoming bills list. As can be seen in the graph below, Quicken grabs all the accounts instead of just the two I've selected and graphs them all separately anyway.

I'm using Version R59.18 Build 27.1.59.18 and have done a Super Validation of the data before graphing this data. It was happening before the Super Validation as well.

[Edited - Removed personal information]

Comments

  • Quicken Kristina
    Quicken Kristina Quicken Windows Subscription Moderator mod

    Hello @Jeff_W,

    To assist with this issue, please provide more information. When did you first notice this problem? Do you keep your Quicken file directly on your local hard drive? Is it synced with any cloud services, such as OneDrive, iCloud, or Dropbox? You mentioned that you did a Super Validate prior to using the Projected Balances tab. Was there some unexpected behavior that prompted you to perform that validation?

    I attempted to replicate the issue in my own Quicken, but my Quicken worked properly and graphed the selected accounts only. Do you see this issue regardless of what account type is selected? Does it make any difference whether the accounts you select are manual or connected accounts? Does the financial institution the accounts are connected to have any impact on the behavior you see in your Quicken file?

    If you haven't already done so, I'd recommend restarting your computer, and testing to see if the issue is resolved after the restart.

    I look forward to your response!

    Quicken Kristina

    Make sure to sign up for the email digest to see a round up of your top posts.

  • Jeff_W
    Jeff_W Quicken Windows Subscription Member

    Hi Kristina. Thank you for your feedback and desire to help solve this issue.

    I restarted the computer per your recommendation, but the problem still persists.

    I first noticed this the first time I started using the feature about 3 months ago.

    I keep my Quicken files directly on my local hard drive. The hard drive files are backed up daily with OneDrive at the end of each day.

    The performed both the validation and super validate because while researching this topic on the community I saw where someone recommended to do that to solve a problem also involving Projected Balances. It did identify some fixes performed but no change in the graphing/charting issue I am experiencing.

    The issue occurs regardless of the type of account. I've selected two very simple cash accounts, completely manual entry, and it continues to graph everything separately.

    I decided it would be a good idea to make a completely new file with simple, manual accounts and avoid the existing file I was trying to do this with. So I did that and created four accounts and used the Projected Balances feature and made sure the Separate accounts feature box was unchecked. As can be seen below, it still will not integrate the amounts into one curve.

    Regards,

    Jeff

  • Quicken Kristina
    Quicken Kristina Quicken Windows Subscription Moderator mod

    Thank you for your reply,

    To clarify, the Separate Accounts checkbox is not referring to the graph; unchecking that box will not cause all account values to be merged into one line/curve.

    In Quicken, you can mark accounts as Separate. Accounts that are marked Separate are not included in Net Worth data, are excluded from reports and graphs by default, and are excluded from features that show history. You can see this article for more information:

    In your new file, did you try unselecting one or more accounts to verify if the graph shows only the accounts you have selected?

    Thank you!

    Quicken Kristina

    Make sure to sign up for the email digest to see a round up of your top posts.

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 11

    The Projected Balances graph shows the accounts separately so that you can see if any of your accounts will be close to being overdrawn.

    In your graph, it appeared you have about 5 accounts selected. Most of the accounts are close to zero because one of the selected accounts has about $290,000. Perhaps it is an account that you have marked as Separate. If you exclude that account, the other accounts should be more visible.

    QWin Premier subscription
  • Jeff_W
    Jeff_W Quicken Windows Subscription Member

    Kristina, Jim, thank you for your feedback. I see the error of my way now in regard to what the box marked "Separate Accounts" refers to. I took as an integration of the accounts I had selected into one graph to see where I would go into the negative based on income and expenses associated with those selected accounts. Maybe something Quicken would consider making a part of the projected balances balances in the future.

    Jeff

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    II can see it would be helpful to know how the total projected cash in your "bill paying" accounts compares to your projected spending.

    I don't use it regularly, but you might look at the In/Out What's Left panel on the Home tab traditional dashboard.

    QWin Premier subscription