reconcile using share balance instead of cash value in mac version (4 Legacy Votes)

kashyapa
kashyapa Member
edited December 2019 in Investments (Mac)
I was using Quicken 2017 windows. Now moved to mac version. I used to reconcile using share balance and not cash value. How do I reconcile using share. balance and not cash value. Do not tell it is the only way.
24
24 votes

New · Last Updated

Comments

  • Unknown
    Unknown Member
    edited December 2019

    Reconcile Securities Along with Cash in Investment Accounts


    It would be very helpful to be able to reconcile the securities within an investment account. Sometimes, I can end up with different security values because of an error on a transaction. But because it does not involve cash, I don't catch it. This would allow these to be caught relatively quickly.

  • John Burgess
    John Burgess Member ✭✭
    edited January 2018
    I’ve also wanted this for a long time. anyone else think this is a good idea? Vote for it!
  • Lyn Buddenhagen
    Lyn Buddenhagen Member ✭✭
    edited September 2018
    IMHO, Quicken is supposed to be a DIY application. The more we ask for, the more the app will cost.
    I reconcile to my paper statements every so often, and go hunting for what I did wrong - or what did not get translated correctly in a download. To reconcile a security I look at transactions, filtered by the security (the magnifying glass/search area), and going to the Columns icon at the bottom, I choose Shares and Share Balance (usually getting rid of Amount and Cash Balance, since you can change back at any time). I do hope this helps you, Matt.
  • Unknown
    Unknown Member
    edited September 2018
    I would completely disagree with this being a DIY app. If that was the case, it would have user programmable capability. This app is meant to be easy to use with a lot of functionality built in.

    Honestly, I don't understand how anyone could consider a proper reconciliation of an account that doesn't look at all possible elements of value in that account. This would mean that it includes securities for an investment account. You typically have very little, if any, cash in these accounts. Yet that is all you are looking at when reconciling. By not reviewing securities transactions and balances, you are turning the reconciliation process into a completely manual approach, which defeats the entire purpose of using finance software.
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited August 2018
    I miss some transactions too, even after over 25 yrs of using Quicken, I have gotten good at eventually catching them...but I agree, this would be a very useful and appropriate feature.
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • Quicken_Tyka
    Quicken_Tyka Alumni ✭✭✭✭
    Hello kashyapa,

    Thank you for taking the time to come to the Community to post your question.

    Unfortunately, the ability to reconcile using the share balance is unavailable at this time.

    I have gone ahead and changed this thread to an Idea so that others may vote on this feature.

    Thank you,
    -Quicken Tyka
    ~~~***~~~
  • cjl06
    cjl06 Member
    Thanks for putting this to a vote. I have recently converted from windows to mac version and was really thrown by the "0" balance when reconciling. I have added my vote.
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    I agree that being able to reconcile share balances could be useful.

    I'm not sure what this would look like, though. Would there be a second column for reconciling shares? Would we reconcile an account twice, once for dollars and once for shares? Would it be a choice of cash or shares to reconcile?
    Quicken Mac Subscription • Quicken user since 1993
  • smayer97
    smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    Yes still desired.
    Have Questions? Help Guide for Quicken for Mac
    FAQs: Quicken Mac Quicken Windows Quicken Mobile
    Add your VOTE to Quicken for Mac Product Ideas

    Object to Quicken's business model, using up 25% of your screen? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires

    (Canadian
    user since '92, STILL using QM2007)
  • rhd99
    rhd99 Member ✭✭
    Reconcile shares in Mac is definitely still wanted. It allows a quick check that the share balances by security in Quicken agree with the financial institution’s records for one’s account.
  • mekuehn
    mekuehn Member
    I used it on my PC while I waited for you to update the programs for the Mac. I purchased a Mac this year because of your improvements and moved my files over. I would really like that option with the Mac so the all versions are the same. I've been using your product for over 20 years and recommend it to friends and family.
  • Just moved from quicken for windows to Mac. Disappointed that this feature, which is available in windows version, is not available in the Mac version. Please add ability to reconcile shares in investment accounts in addition to reconciling by cash balance.
  • JBS2021
    JBS2021 Member
    Reconciling shares in investment accounts should be a mandatory function of Quicken for Mac. When dividends are automatically reinvested, the cash balance doesn't change but the number of security shares does change. An error in the reinvestment transaction or a missing reinvestment transaction would only affect the share balance and not the cash balance so it would never be detected unless the shares are reconciled. Please provide this functionality.
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    @JBS2021 First, I agree fully that this should be added to Quicken Mac.

    But until it is, I'll tell you how I reconcile my investment shares. At the end of each quarter (you could do it monthly if you wish), I review my brokerage statements versus Quicken. (I prefer to keep printed hard copies of my brokerage statements, but you can do this with a downloaded PDF if you're all-digital in that regard.)
    • Click on the account in the left sidebar
    • Click on Portfolio view
    • Set the filter to show "Portfolio Value" and "Group by Security"
    • Set the "Price and Holdings as of" date to the quarter-end date matching the brokerage statement
    Now it is easy to go through the brokerage statement and compare it to the Shares column in Quicken for each security held, in each account. There's nothing to check off to mark my work as reconciled in Quicken, but since I know I do this every quarter and I have, in fact, reconciled my share balances in Quicken. This gives me complete confidence that my investment data is recorded correctly in Quicken.
    Quicken Mac Subscription • Quicken user since 1993
  • Dan Twohig
    Dan Twohig Member ✭✭
    I have been using Quicken PC for many years and looking to move to the MAC version which appears to have some excellent improvements. However, I can’t understand why anyone would consider reconciling the cash in an investment account without first reconciling the shares. Over the years being able to reconcile shares has caught problems that would have cascaded into massive if only cash was being reconciled. In my opinion, the absence of an ability to reconcile shares prohibits the product from being viable for investment accounting. Why would anyone pay so they can manually do an investment accounting requirement? I wonder if the Quicken manager for the MAC development uses the product for tracking investment accounts.
  • vdub
    vdub Member
    Need this feature. NOW! What’s holding it up?
  • MissMy2007
    MissMy2007 Member
    As others have said- need the feature, can't believe quicken for mac doesn't have it, it's on the windows version. I don't care about reconciling the dollar amount, I do care that my shares balance with the investment institution.
  • ccondrich
    ccondrich Member ✭✭
    edited November 2022
    Cannot believe that this thread started in 2018 and that Q for Mac is still lacking this functionality. I recently migrated from Windows and am still finding investment functionality that is missing. Mac is easy to navigate but why can the two platforms not have the same functionality??
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    jacobs said:
    I agree that being able to reconcile share balances could be useful.

    I'm not sure what this would look like, though. Would there be a second column for reconciling shares? Would we reconcile an account twice, once for dollars and once for shares? Would it be a choice of cash or shares to reconcile?
    I thought I would just clarify what "Reconcile Shares..." does in Quicken Windows.
    When downloading investment data there is a "summary" part to it where the financial institution lists all your securities and number of shares and prices and the cash balance.

    What "Reconcile Shares..." does is compare securities/number of shares to this "summary data" and puts up a dialog say that they compare or one that shows the differences. Note there is an option that allows this comparison to be done after every download.  This is in fact what leads to adding placeholder or not (hopefully the user doesn't use them).  I note from the Quicken Mac threads that at times it puts in placeholders.  One would have to assume it is using same "summary data" to do this. As such, this really shouldn't be a really hard feature to put in.

    Note that even though the cash balance is also in that summary, Quicken Windows doesn't use it for the cash reconcile, even though it has a checkbox for doing it, it is none functional in an investment account:
    https://community.quicken.com/discussion/7923770/it-would-be-nice-if-reconcile-using-online-balance-was-actually-implemented
    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    @Chris_QPW And does the Quicken share reconciliation create a "reconciliation history" so you can go back and see what had been marked reconciled in the March 2022 or October 2019 reconciliation, if you want to?

    In Quicken Mac, the Portfolio view can list each of your securities in an account, showing the number of shares, price, market value, etc. by security, plus cash, as of any date you select — today, end of last month, last quarter, or any date you enter. So this sounds like it has similar data as the "summary" screen you're describing in Quicken Windows.

    What Quicken Mac doesn't have is a recorded history of reconciliations for shares of investments, showing each individual transaction included in that reconciliation, as it does for investment cash and all banking-type accounts. for someone who does a lot of trading and has many transactions in a month, and who might have transactions dated on the last day of a mo nth but not posted until a few days later, I can see there might be a benefit to marking off individual transactions in a monthly reconciliation, in order to have a history of what existed as of each month- or quarter-end. 

    But if the Quicken Windows share reconciliation is only to share totals, not transactions posted, as of a certain date, that doesn't sound like a real transaction reconciliation, and it seems to me one can already see the monthly summary value as of any past date in the Quicken Mac Portfolio. 
    Quicken Mac Subscription • Quicken user since 1993
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    edited November 2022
    @jacobs Quicken Windows doesn’t have a reconcile history for either investment accounts or non-investment accounts.  Quicken Mac is superior in this since they have a reconcile history for non-investment accounts.

    Frankly for most of the time I have ever used Quicken Windows I reconciled the share in exactly the same way that you deceived, go to the investment tab/portfolio view and select a date and grouped by accounts (securities are separated in this sorting).

    I should have also pointed out the main weaknesses of “Reconcile Shares…”.  First off, the only date you can reconcile to is the current one, or more precisely the date of the last download/date in the “summary data” that was downloaded.

    Not only does that mean it is probably useless to people reconciling to a statement, there isn’t anything that guarantees the data is up to date/accurate/consistent.  For instance, in Vanguard if I had a buy/sell on a given date the transaction would be downloaded that day by the end of the day, but the “summary data” wasn’t usually updated until late at night.  This one of the main reasons why some people would get placeholders suggested when in fact their transaction data in Quicken was fine.

    The Reconcile Shares and the ability to run it automatically is a nice feature, but it far from a critical one.
    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • schmatt
    schmatt Member

    I would like the ability to reconcile investments, not just cash, in my investment accounts.

    I've always been confused as to why your investments (stocks, mutual funds, etc.) are not reconciled. It makes it very difficult to verify that all of the transactions are correct. You have to manually check all of this. If you find an issue, it's a very manual process to find the error.

  • Quicken Kristina
    Quicken Kristina Moderator mod

    Hello @schmatt,

    Thank you for reaching out to the Community with your request.

    I went ahead and merged your Idea to this active Idea thread regarding this topic.

    Ideas are reviewed by our Development and Product teams to see what features people would like to have available in the future. Please, be sure to add your own vote as well by clicking the up arrow.

    Thank you.

    Quicken Kristina