Home Quicken for Windows Investing (Windows)
Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

How to bring Brokerage accounts into agreement with Broker statements

Hello,

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.

Answers

  • Jim_HarmanJim_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.
    -- Jim QWin Premier subscription
  • splashersplasher 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 since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list

  • FrankxFrankx 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.

    Frankx


    Quicken H&B-Subscription - Ver. R29.20 - Build 27.1.29.20  - Windows 10 Home - Ver. 2004
                                             - - - - Quicken User since 1984 - - - 
      -  If you find this reply helpful, please click "Helpful" (below), so others will know! Thank you.  -
Sign In or Register to comment.