Wells Fargo Advisors brokerage cash account balance discrepancy

Options
pkelley
pkelley Member ✭✭
edited August 2023 in Investing (Windows)

I have been tracking a cash balance issue for months. I can't say exactly when it started. Use to be a couple cents from time to time. Now it's never correct and can be anywhere from a few pennies to several dollars out of balance, day to day. I have recently noticed that the balance downloaded for corrections, does not match the current cash balance shown by Wells Fargo Advisors.

I only update after all transactions (pending etc..) have cleared and markets are closed to avoid confusion. No errors are reported or indicated. I have run the Quicken Validation process several times with no issues. The security's value for the account is and always has been, correct.

I am using Windows 10, Quicken R50.16 Build 27.1.50.16.

Quicken Screenshot of downloaded Wells Fargo cash balance.

Wells Fargo Advisors screenshot of Cash Balance

Any help with this issue will be greatly appreciated.

Answers

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    edited July 2023
    Options

    " I have recently noticed that the balance downloaded for corrections, does not match the current cash balance shown by Wells Fargo Advisors."

    Wells Fargo Advisers uses the Direct Connect method of downloading, per Quicken's fidir.txt file, so I'd say the problem has to be on Wells Fargo's end of the chain.

    With Direct Connect Wells Fargo is responsible for coding each transaction and updating balances as they occur, pretty much in "real time", and putting that information on their OFX server, making it available to you any time you do an Account update. So, assuming that their client-facing information at their website really is a "real time" number, it seems like there's some lag going on in the updating of their OFX server. You should be able to confirm this by looking at the OFX log when you see this sort of discrepancy.

    "Back in the day" when Schwab used Direct Connect I used to see this sort of discrepancy once in a while with the number of shares of a security on the occasion of reinvested dividends; sometimes the number of shares presented as "per broker" omitted the shares just purchased with the dividend, but the balance would "catch up" with a subsequent download.

    One other thought, I see that the title of the Available Funds is "Cash/Cash Alternative and Margin." Going back to my experience with Schwab, I did notice one time when I incurred a small margin liability with Schwab that the "Cash and Money Market" line of my "Positions" page at Schwab showed a dollar amount before subtracting the margin liability, while a different page at their site showed a dollar amount - the amount I could really withdraw - that was after the margin liability deduction. Any chance that something like that is going on?

    If your actual transactions in the Account are all correct, properly showing activity in line with what Wells Fargo is stating, then it would appear that something hinkey is going on with Wells Fargo's "balance" number in their OFX server, so you might try asking to speak to one of their "Quicken" IT guys to see if that's the source of the problem.

  • pkelley
    pkelley Member ✭✭
    Options

    Thank you for the quick reply. My cash account is not approved for margin transactions, so margin liability should not be a factor.

    I agree with you that this is pointing to a Wells Fargo issue(s) rather than a Quicken issue. I'm surprised no other Quicken users have seen similar behavior or that this is unique to me. This morning, I noticed an $0.08 increase in my Online balance online with no transactions to explain the increase. I also noticed Quicken received the same incorrect balance from Wells Fargo as the previous day, so now Quicken is .08 cents further out of balance if the Wells Fargo website is correct.

    I was able to show the discrepancies to my financial advisor at Wells Fargo this morning. He too cannot explain the discrepancies but agrees the website is reporting balance changes without corresponding transactions to support the change. He is taking the issue to IT Development for an explanation.

    I suspect this is a secondary or perhaps unrelated issue to the balance being sent to Quicken via the OFX server. The balance received via the OFX server is different than what the website shows and does not always change at the same rate/amount as the website. My advisor and I agreed we'd tackle this one once we explain the website discrepancies.

    Securities shares, cost basis, value, etc... still remain (as of this morning) in balance/sync with Quicken.

    Thanks for your feedback.

  • pkelley
    pkelley Member ✭✭
    Options

    Just FYI,

    Working with my Wells Fargo advisor and IT folks, we confirmed interest earned is made available to a cash account daily. There is not a transaction created for this event. A monthly interest deposit transaction is made on the last day of the month, which totals all interest earned that month offsetting the daily interest credited to the cash account balance.

    The cash account balance sent to Quicken does not include the interest made available to the account daily. Therefore, the account balance shown in Quicken will only be in balance with the balance shown on the Wells Fargo website, the last day of the month when the interest deposit transaction is posted. The very next day they will be out of balance again, until the next interest deposit transaction is posted.

    I have other brokage accounts other than Wells Fargo and have not seen this behavior. I see the value in that the interest is available daily to reinvest but makes it difficult to impossible to keep Quicken in balance on a daily basis.

  • Tom Young
    Tom Young SuperUser ✭✭✭✭✭
    Options

    That is bizarre and frankly makes no sense! If the cash is truly available - you can withdraw it - then it should be in the download. If it's not really available - you can't withdraw it - then it shouldn't be showing at their site.

    So it seems like you can make daily downloads, assume the difference in cash between the downloaded online balance and the balance show at their site is interest, make a daily entry for the interest and, assuming you got all your daily entries right, delete the downloaded IntInc entry at month end, or completely ignore the difference throughout the month and just wait until month end to get things in sync.

This discussion has been closed.