Recommendation for Manual Reconciliation of Shares

I enter my share transactions each month by hand, followed by checking my holdings against that month's brokerage report. The obvious way to do that is to click on the line for the holding I'm checking, which allows me to click on RECONCILED, but doing that opens that register line into a double line display, which hides the share balance. Since the share balance is the one thing I need to see at this point, I don't know why this would be omitted from the display.

So I'm forced to highlight a line above or below the line I'm interested in, check the share balance of the holding of interest, then click the holding of interest and then click on R for Reconciled. This seems to make reconciling much more difficult that it needs to be.

Am I missing something? Is there a setting that will get that share balance displayed even when that line is selected?
2 votes

New · Last Updated


  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    May I ask why you're not downloading from your brokerage into Q?
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    Before I started downloading investing transactions into Quicken and having it reconcile the shares at the end of each download session, I would enter all the transactions for the month, then click on Holdings. I would set the As of date to the statement date and compare all the holdings in Quicken to the statement. If all agreed, I would put a check mark on the statement. 

    If you want a reconciliation indication in Quicken, you could make that comparison, then go to the last transaction for the closing date and select Reconciled. 
    QWin Premier subscription
  • Temp2311
    Temp2311 Member ✭✭
    > @NotACPA said:
    > May I ask why you're not downloading from your brokerage into Q?

    For me it's because my employer chose the awful MassMutual, now Empower, as our retirement platform. They refuse to implement Quicken download or any other method of downloading and managing the transactions. It must all be performed manually - entry, reconcile, etc. Hate it! I need Quicken to be much more efficient for manual data entry.
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    For people that don't have to do manual updating, this might not be that easy to understand what is going on.  I have the exact same problem with my Lending Club notes that have no way to download automatically.

    Here is a typical sequence of transactions I need to enter once a month for each of three accounts when the statements come in.

    To reconcile this statement (make sure that I entered it correctly) I need to know the number of shares to make sure they are correct, and then if they are I can do the cash part of the reconcile.

    If I could see what you see above after entering the transactions I could just look at the 42,820.78 share balance.  But that isn't how it looks when I finish entering the transactions.  This is how it will look:

    The last transaction will always be in two line mode because it is the "active/selected" one, and for some reason not show the share balance.  In this mode the share balance isn't shown.

    And as @jadney points out the only way to get it to show up is to click on a different transaction so that you can see the share balance of the transaction.

    Note this behavior is only for the selected transaction.  Here is what it looks like in two line mode.

    This is my website: