This post has been closed and is not open for comments or answers.
Quicken Community Home Page

How to merge two accounts?

I've manually downloaded transactions from a financial institution to fill in the dates prior to 90 days past, which seems to be the extent range of Quicken's direct download. But how to get the data into the same Quicken account already created?

When I try importing the QFX file or dragging-n-dropping it into the proper account in Quicken, it turns into a separate new account.

So it seems I need to merge the two accounts, as the one I downloaded has transaction dates 10/1/2011 to 12/15/2011, where Quicken's direct download starts at 12/20/2011.

By the way, this is just one of eleven accounts (2 checking, 3 credit cards, 2 brokerage, 2 retirement, 1 mortgage, 1 HSA) where I have to manually do this to start using Quicken. I haven't successfully completed a single good account yet, and it's already getting tedious.
    It is easier than you think. Quicken allows you to drag misplaced transactions to the correct account.
    Assuming two accounts: 
    • NEW: The new 90-day one you created that is updating online
    • OLD: The old one with all of the historical transactions.
    While in the main window that list all of your accounts....
    Select all of the transactions in the OLD account, and drag them to the name of the NEW account (it will become highlighted) and let go.
    All transactions will be moved from the OLD to the NEW one.
    Then delete the now empty OLD account.
    done.

    Note: I am not associated with Intuit in any way. Do this at your own risk and always make a backup beforehand.
      You can't link because those accounts are already setup for download. (FAQ:Can't Link)

      http://www.youtube.com/user/MrJrs8084

      Do note that manually importing the .qfx does not guarantee that you will get more data. Banks might allow you to set a greater range, but it is still up to them if you get more. My bank allows you to-and you get an empty file with no transactions :-(

      In this case, i do NOT suggest turning off downloading just to bring in more transactions. For this one time event-let it add another account. That way, you can see if you get more data. Then, select and drag the transactions from the new to the existing account. Be careful-you will have to adjust the opening balance in the existing account accordingly. And, don't drag the opening balance from the newly created account. When done, you can delete the new account. (Right click on its name and delete)

      This is a lot of work just to get data history. You might just resign yourself to the fact that your banks only provide 90s days of history, and that your Quicken account starts last December.
      • So these are the limitations? Quicken won't download more than 90 days worth? Or that certain financial institutions won't allow more (via Quicken direct)?

        I'm already halfway resigned in disappointment, but it would be nice to know if I'm banging my head against the wall for good reason or no reason.

        It would also point me in another direction. I've finally completed a full resurrection of one checking account. It was an import of an old simple Quicken 2004 ledger. So if it's going to be tedious anyway, I might as well resurrect all my old ledgers transaction by transaction.

        Isn't the fundamental purpose of financial software to look at old transactions? How can you say "just to get data history?"
      • How far back you can go is totally dependent on your bank. Intuit/Quicken has no control over this. Same thing with the connection method you use-the bank is in control.

        sepoc88: I looked back at your previous questions and I answered one about your import of 2004. Why didn't you just import your 2004 file?

         (As noted, you would need to do this on 1) a PPC Mac or 2) under Leopard or Snow Leopard) Quicken needn't be installed on the machine you perform the conversion on.)
      • Yes I'll inquire at each of my financial institutions (there are so many that I have) about downloading *ALL* the available transactions. I anticipate them pointing the finger back at Intuit/Quicken. Why not. They always do that.  But regardless, each account will take some time. Ugggh.

        As for importing from Quicken 2004, the "full resurrection of one account" I mentioned was exactly that. I actually have another one to do, also from Quicken 2004, because back then I had separate business and personal accounts. My Quicken chores are piled up pretty high.

        But as I mentioned, I have 11 different accounts. And this here is about a credit card account -- Capital One Mastercard to be precise. Their website allows a direct download for what seems to be 6 months back, so why would they limit Quicken direct download to only 90 days? That's the question I'll have to ask them, unless there's some setting I'm missing in Quicken.

        And again, this is just one of my 3 credit card accounts. There are then the other accounts that might be similar.

        By the way, jrs8084, in the other discussion where you answered me, I wanted to add a thank you comment, but it locked me out after I pressed the "solved" button. So thank you. I'm testament to having a bootable backup -- I simply booted into the Snow Leopard drive, inserted the Quicken install disc and proceeded as you had advised. Then I transferred the files via an USB jump drive.
      • jrs8084:
        I've taken your hint and did the opposite of your advice -- I linked a Quicken download to the new account created from importing a manual download -- instead of the other way. It was the turning off of downloading (web connect in my case) that allowed it. Of course, this is for just one set from the same financial institution (Capital One Mastercard). So there was no confusion and no chance for mistaken cross-linking.

        What other hazards? Any? Isn't this the answer? It's called linking, not merging. It's not static combining of two old existing accounts, but it does bring two seemingly new accounts into one.
      • It sounds like you have figured out your problem.

        No, there are no hazards. As you learned, can't link=account is already setup to download. You had to turn it off to allow this.

        The reason I suggested above to simply let it add a new account (versus disabling downloading and then linking) is less relevant in your specific case  since you are using web connect. The reason is that some users are doing just like you did-using web connect files to "fill in" gaps in time. But, the user might be setup via another more advanced connection method (i.e. not web connect). In those cases, they have to go through a whole deactivate/reactivate process which can lead to other issues. But, as you saw-that doesn't apply in your case.