joint accounts: ownership multiplier

Please add an ownership multiplier to the attributes for each account that I can use for joint accounts where I want to track only my share of a joint account (that has transactions downloaded from a bank or broker).  This multiplier would be used only when computing my assets and/or net worth.  For example, if one third of the money (or shares) in an account were mine (and the other two thirds were for my co-owners), then setting the multiplier to 33.3333333% would result in only one third of the net account value being used in my Net Worth report.  The default multiplier would, of course, be 100%.  Also, every report would have a (single) check-box controlling whether to apply the account multipliers or not.
Aside: To allow precise math for typical use, this multiplier might be better expressed as a divisor.  That is, a 1/3 or 33.3333333% share would be expressed as 3 and a 40% share as 2.5.  On the other hand, that would probably be confusing to explain.  Maybe allowing lots of digits after the decimal point would be the better solution.
0
0 votes

No Status · Last Updated

Comments

  • Richard KennedyRichard Kennedy Member
    edited June 2018
    I concur. I have some joint assets with a sibling and they do not use Quicken (or even a computer!). It would be most useful to have an automated method to calculate my net worth calculation correctly.
  • RickORickO SuperUser ✭✭✭✭✭
    edited October 2018
    Not to be a bubble burster, but Quicken is personal finance software. IOW, intended to be used by an individual or household. Given all the important features that have been requested and the relative rare need for this, I don't see it getting implemented anytime soon. But who knows?

    One possible workaround: split the account into two, record the assets/value in each at the appropriate ratio and include only your part via Net Worth Report customization. But it might be easier to just break out a calculator.
  • volvogirlvolvogirl SuperUser ✭✭✭✭
    edited June 2018
    Or export the report to Excel and add columns to do the splitting. Like a column for each person.
  • Jim_HarmanJim_Harman SuperUser ✭✭✭✭✭
    edited November 2018
    Or set up the joint account as a Separate account in Quicken so it will not be included by default in your reports or net worth.


    Then make another normal account with 1000 shares of a made-up security called "Share of joint account" or whatever. Periodically you can set the share price of that security so that the total value matches your share of the joint account.

    You can also set the asset allocation of the made up security to match that of the joint account, so you will get a correct picture of your overall asset allocation.
    -- Jim QWin Premier subscription
  • Rick GumpertzRick Gumpertz Member
    edited August 2018
    That is a twisted way to accomplish something.  The whole idea of Quicken is to AUTOMATE things, not add complicated manual updating activity by the user.
  • Rick GumpertzRick Gumpertz Member
    edited June 2018
    RickO said:

    Not to be a bubble burster, but Quicken is personal finance software. IOW, intended to be used by an individual or household. Given all the important features that have been requested and the relative rare need for this, I don't see it getting implemented anytime soon. But who knows?

    One possible workaround: split the account into two, record the assets/value in each at the appropriate ratio and include only your part via Net Worth Report customization. But it might be easier to just break out a calculator.

    This doesn't work well for accounts with frequent activity, such as joint checking accounts.
  • Jim_HarmanJim_Harman SuperUser ✭✭✭✭✭
    edited November 2018
    Sorry if my idea does not work for your situation.



    You could still use Quicken to track all the transactions in the joint account, which I would think is the major burden.



    If your goal is to see the impact of the account on your net worth, perhaps a monthly update would suffice, so only one calculation and one manual entry per month would be needed.
    -- Jim QWin Premier subscription
  • NotACPANotACPA SuperUser ✭✭✭✭✭
    edited June 2018
    RickO said:

    Not to be a bubble burster, but Quicken is personal finance software. IOW, intended to be used by an individual or household. Given all the important features that have been requested and the relative rare need for this, I don't see it getting implemented anytime soon. But who knows?

    One possible workaround: split the account into two, record the assets/value in each at the appropriate ratio and include only your part via Net Worth Report customization. But it might be easier to just break out a calculator.

    I concur with RickO on this one.  A single Q data file is supposed to hold ONLY the financial info for a single tax entity.
    From your description, it sounds like some sort of partnership account is being discussed ... and that partnership account doesn't belong in Q because the OP doesn't own ALL  of it.

    Try Quickbooks,  which already has the function that's being requested here.
    Q user since DOS version 5
    Now running Quicken Windows Subscription
    Retired "Certified Information Systems Auditor"
  • q_lurkerq_lurker SuperUser ✭✭✭✭✭
    edited August 2018
    @Rick:  While I understand what you are asking for, I don't think you have gotten to a level of selling the concept.  In particular, what accounts and circumstances are you seeing the need for such a factorization?  Two spouses filing jointly doesn't apply.  Two spouses filing taxes separately, might (I don't know).  Siblings?  Again, I can't say.  Three business partners?  Not a likely sale as that is not the demographic for Quicken's business modules.  So what are your known cases for needing this type of factor?  
    This multiplier would be used only when computing my assets and/or net worth.
    Why?  I understand that from your side - that is all you are interested in.  But from Quicken's side, what is the rationale for having a partial ownership account but including 100% of the income in tax projections or reports?  Or 100% of the expenses in budgeting considerations?  Seems to me that virtually every aspect of Quicken would need to consider this ownership factor.  That then adds substantial complexity to the breadth of the idea. 

    I am not trying to rain on your parade or squelch your offering, but it needs to be better conceptualized, IMO.  
  • Rick GumpertzRick Gumpertz Member
    edited October 2018
    OK, I was too quick when I specified assets and/or net worth.  Tax projections would also use the multiplier, as would budgeting.
    Simple use case: My children and I jointly own assets in an account. My share is 20%.  Each of two children owns 40%.  If I "Keep this account separate", then my assets are understated.  If I don't, my assets are overstated.  In other words, Quicken already supports something like this option but is limited to only two possible multipliers: 0% and 100%,
    Another, similar use case: I beneficially own assets in a Investment Club.  I can download transactions for the Investment Club as a whole.  I want to include in my net wortyh, and such, only my share of the club's assets.
  • NotACPANotACPA SuperUser ✭✭✭✭✭
    edited July 2018

    OK, I was too quick when I specified assets and/or net worth.  Tax projections would also use the multiplier, as would budgeting.
    Simple use case: My children and I jointly own assets in an account. My share is 20%.  Each of two children owns 40%.  If I "Keep this account separate", then my assets are understated.  If I don't, my assets are overstated.  In other words, Quicken already supports something like this option but is limited to only two possible multipliers: 0% and 100%,
    Another, similar use case: I beneficially own assets in a Investment Club.  I can download transactions for the Investment Club as a whole.  I want to include in my net wortyh, and such, only my share of the club's assets.

    Excel.  Even QB won't do what you're asking ... because it doesn't support investment accounts.
    Q user since DOS version 5
    Now running Quicken Windows Subscription
    Retired "Certified Information Systems Auditor"
  • edited October 2018
    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

  • Hopeful1Hopeful1 Member
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    It doesn't seem like this would be difficult for you to implement.

    You obviously haven't been a Quicken user for very long.

    EVERYTHING is difficult to implement in Quicken.

    And as pointed out:

    1 Quicken is PERSONAL finance management software...not implemented for partnerships, S Corps or such.

    2 Aside from a few users, this isn't something that the vast majority of mainstream Quicken users would have any use for.

    Sorry to rain on your parade, but I wouldn't think this is something Quicken developers would have any interest in adding.  

    But then again... you never know. 
  • Rick GumpertzRick Gumpertz Member
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    I understand that this is not a high priority idea.

    As for use case, many Quicken users may be in Investment clubs or partnerships with family members.
  • NotACPANotACPA SuperUser ✭✭✭✭✭
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    many Quicken users may be in Investment clubs or partnerships
    Then they're using an inappropriate product. Q is intended for individuals and families ... AKA, a single Tax Entity.

    It's not intended for either grouping that you cite.  And, really, doesn't work well for those groupings.

    Why does this thread bring to mind the old saying: "When all that you've got it a hammer ... everything looks like a nail"?
    Q user since DOS version 5
    Now running Quicken Windows Subscription
    Retired "Certified Information Systems Auditor"
  • Rick GumpertzRick Gumpertz Member
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    I, at least, would like to track MY portion of joint investment accounts that I hold with family members.  That's pretty close to being personal.
  • edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    "You obviously haven't been a Quicken user for very long."

    27 years.

    "I
    t doesn't seem like this would be difficult for you to implement."

    Been writing computer software since 1961.

    "Q is intended for individuals and families ... AKA, a single Tax Entity."

    Says who?


  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    Yes, it is circular reasoning...
    Quicken does not handle situation x because it is only intended for situation y (often presumed, since is not advertised as such).
    Since Quicken is intended for situation y (again presumed), it should not be made to handle situation x.

    In other words, because it does not do it now, it should not be made to do it.

    P.S. I am not saying I am for or against this idea thread, just pointing out possible circular logic.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • Hopeful1Hopeful1 Member
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    "You obviously haven't been a Quicken user for very long."

    27 years.

    Mazel Tov!

    "I
    t doesn't seem like this would be difficult for you to implement."

    Been writing computer software since 1961.

    Great.  Quicken Inc is probably looking for people JUST like you, who can take a difficult situation and just whip out new code in a day or two.  

    Sorry, but your prior experience has no merit here.  You don't work for Quicken.  Adding ANYTHING to Quicken is a major chore.

    "Q is intended for individuals and families ... AKA, a single Tax Entity."

    Says who?

    This is from the quicken.com website:



    Track, budget and organize your PERSONAL FINANCES.  

    Also, if you noticed, Quicken ONLY supports Schedule C (sole proprietorship) tax line items.  It NEVER has and doesn't support S Corps or Partnerships.

    Now, I don't want to get into a pissing match here... but you're not going to find support in Quicken for what you need.  And as noted by most other users, the chances of adding what you need are slim to none. 
  • Tom YoungTom Young SuperUser ✭✭✭✭✭
    edited August 2018
    In any case, every owner of a "Joint Account" has 100% rights to everything in the account.  You, or any of your children, could clean out that account tomorrow.

    Set up a partnership and account for it using Quickbooks. 
  • Rick GumpertzRick Gumpertz Member
    edited August 2018
    So much flaming over a simple suggestion.  It may or may not be worth implementing.  Just posted it to put my wish on the list.

    Arguing over things like the suitability of using Joint Accounts and split ownership) is totally irrelevant: they exist and are used for many reasons!

    Arguing over what Quicken IS (or should be) is also irrelevant: that will be determined by Quicken, Inc.
  • mshigginsmshiggins SuperUser ✭✭✭✭✭
    edited August 2018

    So much flaming over a simple suggestion.  It may or may not be worth implementing.  Just posted it to put my wish on the list.

    Arguing over things like the suitability of using Joint Accounts and split ownership) is totally irrelevant: they exist and are used for many reasons!

    Arguing over what Quicken IS (or should be) is also irrelevant: that will be determined by Quicken, Inc.

    I don't see flaming, I see users expressing differing opinions. Quicken Inc will want to listen to and consider all the various viewpoints on posted suggestions when deciding which ideas to implement.
    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the  Quicken Windows FAQ list
  • Jim_HarmanJim_Harman SuperUser ✭✭✭✭✭
    edited November 2018
    This is probably not the solution you are looking for, but another way to adjust your net worth for your share of a joint account would be to track the full value of account in your Quicken file and use a Property and Debt account to track the (negative) value of other partners' share of the account. 

    -- Jim QWin Premier subscription
  • JakeJake Member
    edited August 2018
    This reply was created from a merged topic originally titled Feature Request.


    Hello,


    I would like to see Quicken create the option to have a percentage of account ownership when creating an account. My girlfriend and I have our own bank accounts for discretionary spending. For housing and joint bills we have a joint account and we also have a joint mortgage. I do not track her personal discretionary account but I do track the joint and mortgage accounts because those directly affect me.


    For our joint account I only own 50% of the account and my girlfriend owns the other 50%. This is the same for the mortgage. So it would be amazing if I could go under the account settings and specify that I own 50% of the account so the net worth and reports will accurately reflect the amount of money that I spent/received rather than what we spent combined.


    I have talked to some other people that are in similar situations and others that have invested in rental properties with other people (sometimes more than one other). With the rental properties they could set it to 33.33% if split equally between three people or whatever percentage they want.


    I think it would be a great feature to accurately reflect that not all people have full ownership for their accounts/assets.


    Thanks for your time and consideration.
  • NotACPANotACPA SuperUser ✭✭✭✭✭
    edited August 2018

    Since 1991, I have used Quicken to track my personal finances. I agree with the desirability of the simple added Quicken feature that Mr. Gumpertz proposes. My son and I recently purchased a multifamily rental property, each contributing half to the purchase. I would like my Net Worth report to reflect 50% of the values of each of the three accounts I maintain in Quicken for this property: the Property itself (showing purchase price and accumulated appreciation); the Mortgage account (reflecting the initial mortgage balance and subsequent payoffs); and the Brokerage account (containing cash and working capital for the property).

    I was planning to implement the report I want by exporting Quicken's Net Worth report to Excel and recalculating there. But I would love to see the capability built in to Quicken. It doesn't seem like this would be difficult for you to implement. For my use, the multipliers could be tied to the Net Worth report only. More uses for other cases could be added by making the multipliers be more global.

    slim to none
    I'm not sure that the odds are THAT high.
    Q user since DOS version 5
    Now running Quicken Windows Subscription
    Retired "Certified Information Systems Auditor"
  • Bob_LBob_L SuperUser ✭✭✭✭✭
    edited August 2018
    Instead of a multiplier, maybe a better approach might be to allow asset and liability sub-accounts. (Like in quickbooks). Then balance sheet type of reports like net worth could be run that either include or exclude the various sub-accounts.
    Quicken Premier Subscription, Windows 10 Pro
  • Rick GumpertzRick Gumpertz Member
    edited August 2018
    Bob L said:

    Instead of a multiplier, maybe a better approach might be to allow asset and liability sub-accounts. (Like in quickbooks). Then balance sheet type of reports like net worth could be run that either include or exclude the various sub-accounts.

    If that were done, I would need/want it for banking and investment accounts too.  I suppose others might want it for loans and credit cards.

    Do sub-accounts provide for automatic allocation/splitting of assets, liabilities, purchase, sales, etc. in the top-level account?  Downloaded transactions too?  All of that would be needed as well.
  • Bob_LBob_L SuperUser ✭✭✭✭✭
    edited August 2018
    Bob L said:

    Instead of a multiplier, maybe a better approach might be to allow asset and liability sub-accounts. (Like in quickbooks). Then balance sheet type of reports like net worth could be run that either include or exclude the various sub-accounts.

    Sorry, I should have used quicken terms. Instead of quickbooks terms. That is I would think a meaningful start could be for checking accounts and asset accounts. Mortgages might be messy. Investment accounts holding securities would really be messy so that might be too much to ask for as well. Credit card accounts seem unnecessary in that presumably different owners would use different cards with separate accounts if the liability was in fact separate.

    Having said this, I personally am neutral on it. That is, the number of users that would benefit from something like this is needed in order to justify something like this.


    The notion of automatic splitting makes no sense to me.
    Quicken Premier Subscription, Windows 10 Pro
  • Rick GumpertzRick Gumpertz Member
    edited August 2018
    Bob L said:

    Instead of a multiplier, maybe a better approach might be to allow asset and liability sub-accounts. (Like in quickbooks). Then balance sheet type of reports like net worth could be run that either include or exclude the various sub-accounts.

    Given what you just said, a fractional ownership factor seems cleaner. than sub-accounts  Has no affect on updates.  Most importantly, the underlying transactions and balances are not affected.

    Another way to look at this is QW already has "separate" accounts.  This feature would offer "partially owned, partially separate" accounts.

    Finally, a differnet way to implement this might be to implement (read-only) "view accounts".  The joint account would be unaffected by any changes.  The "view" account would shadow the joint account except that the transaction values would be an appropriate fraction of the underlying joint account.  To include the fraction in Net Worth, the underlying joint account could be marked "separate" and the view account would not be.

    There are lots of ways to get the desired functionality.  I doubt Quicken will implement any of them.  Nevertheless, it never hurts to ask.
  • JRuffJRuff Member
    I am 10000% with you on needing this feature.  In fact, I am about to delete Quicken because of this.

    I have a joint bank account with my brother, joint ownership in a building, joint ownership of a car.  I can't say that i own 50% of this?  I can't run a personal financial statement from the software?  Well that's the whole point of having this software for me.  I can work around the building and the car manually, though it's stupid.  The bank account is an exercise in pointlessness.  I don't need the software if it can't track my money.  

    I have picked the wrong software.  This is a simple household budget software with no accommodation for a more complicated investor with accounting knowledge.  I will be moving to actual accounting software.
Sign In or Register to comment.