Merrill Account - Cash Reconciliation

Michael Manna
Michael Manna Member ✭✭

I recently opened a Merrill Account. I can download the account investments and updates with no problem however I noticed that the Quicken (for Mac) numbers didn't match the Merrill on line numbers. What I found was an "investment" (Blackrock Liquidity) is counted in Quicken both as an investment and as cash. For whatever reason I cannot update the cash number (transactions is greyed out). Not sure why this happens.

Comments

  • Quicken Jasmine
    Quicken Jasmine Moderator mod

    Hello @Michael Manna,

    Thanks for reaching out about your Merrill account.

    What you’re seeing with the Blackrock Liquidity fund being counted both as an investment and as cash is pretty common with money market or liquidity funds. Quicken treats these as “cash equivalents,” so their value shows up in both places, which can make it look like the cash balance is higher than it should be. The reason the cash transactions are greyed out is that Quicken updates that cash balance automatically based on the investment transactions. So, you won’t be able to edit those cash transactions directly.

    Here’s what I suggest:

    1. Take a look at your investment register for the BlackRock Liquidity fund and make sure the share count and price match what Merrill shows online.
    2. Double-check you don’t have a separate cash account that might be counting the same money twice.
    3. When reconciling, focus on matching the total account balance (investment plus cash equivalents) in Quicken to what you see on Merrill’s website, rather than trying to separate cash from investment.

    If you’re still seeing a difference after that, please let me know, and we can continue troubleshooting.

    Thanks!

    -Quicken Jasmine

    Make sure to sign up for the email digest to see a round-up of your top posts.