How to bring Brokerage accounts into agreement with Broker statements


Somehow my investment accounts have gotten hosed. Considering removing them and just starting over with the current balance, but any help will be very much appreciated.

Two IRA accounts with the same investment broker. Call them 1 and 2. Neither agree with the statements by very similar amounts, call it 10,000.00 in account1 and 10,250.00 in account 2.

Account 1 shows the total value more than the statement by exactly the amount shown in Cash Balance, but the Cash Balance is correct so I can't reduce that amount. Need to somehow reduce the total without reducing the cash balance.

Account 2 shows the total value more than the statement by "almost" the same amount as above. Removing the $10k from the cash balance will result in the total still being $250 too much.

So there are several questions.

Regarding Account1, how to bring the balance into agreement without changing the cash balance.

Regarding Account 1, how to remove the cash balance and then remove an additional $250 from the total.

Thanks for any help.


  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭
    edited December 2020
    In these accounts, are some of the Buys BoughtX instead of Buy? That would account for the balance being off by the amount of the cash balance.
    QWin Premier subscription
  • splasher
    splasher SuperUser ✭✭✭✭✭
    You only refer to amounts ($), what is really important is the QTY of each stock or mutual fund. 
    Are the QTY in agreement with the brokerage?  If so, it is then just a matter of getting the correct price quotes in place for the same date of the brokerage's numbers.
    -splasher  using Q continuously since 1996 -  Subscription Quicken  -  Win11
    -Questions? Check out the  Quicken Windows FAQ list
  • Frankx
    Frankx SuperUser ✭✭✭✭✭
    Hi @FCG

    How are you connecting to your broker (Direct Connect, Express Web Connect, Web Connect)?  Did the differences just start showing up, or have the accounts been off for some time?  Are the investments held in these accounts typical investments such as stocks, bonds, mutual funds, etc. or something different?

    Let us know and we'll go from there.


                            Quicken Home, Business & Rental Property - Windows 10-Home Version

                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -