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

Moving quicken accounts to new quicken file

I thought I had asked before, but cannot find answer.  I have a corrupted account in a Quicken File. No one can figure out why. Suggestion was made to create new Quicken File and move Accounts (windows Q ver 2008), but am stuck with can't import QIF files for investment, checking, credit cards.  However I CAN export QIF it appears, and I can import Quicken Files into MS Money, and Quicken will import MS Money files - so is this a way.  If I don't find SOME way, I will lose years of history since only fairly recent data is available via OFX from Banks, Mutual Funds etc. Thanks.  There is SO much information here, I'm sure this has been asked before, but my searching can't find it
    Quote:" Moving quicken accounts to new quicken file: Read this:"Aha !  Thank you gmalis1 !   I knew there was something there about changing the header information, but I could not find it.  While this is good information, there may be slight caveats in using it, but I do remember trying something like that awhile ago, in speaking to someone - oh wait, with this information, i found it was YOU on 29Nov08 - passing me the same hint that I couldn't find.  Thank you.   All that it not rather incredible that something as basic as this requires a non-standard solution rather than an endorsed solution from the Quicken folks??  Thanks again...Dick
      Quote:" Moving quicken accounts to new quicken file: Aha !  Thank you gmalis1 !   I knew there was..."Quicken doesn't officially import_.qif files since it started charging banks a hefty sum to use Quicken's proprietary .qfx format to download transactions (a type of import, if you will).It's the only way Quicken could restrict downloads to .qfx type, without allowing a loophole to import .qif type files from banks (which Quicken couldn't charge them for).The workaround is the only fix at this time, and adding just four lines to the header isn't too bad an exercise to complete.BTW, it would be nice if Quicken did offer an Export/Import option for it's own file types...but I'm not sure how that would be implemented.
        Quote:" Moving quicken accounts to new quicken file: Read this:"Gmalis1 - I shall note these replies as 'helpful' as I see that you keep tabs of that, and you (via Pollard) certainly have been helpful.  One last note...when speaking to the Quicken Expert at my financial institution (I guess they require such expertise since Quicken directly isn't staffed to assist folks like me) - he made a suggestion...that was to look at  I did, and it also has  a free iTouch interface, and it truly is what Quicken used to be.  It is very intuitive and, while I've not delved into it in great detail (yet), it really has an elegant interface to  view any of the accounts to which I have online access.  And the reports it presents are also well thought out - reminds me of the days when Scott, as Quicken founder, developed Quicken so his mother could use it. Certainly it won't yet have all the flexibility of Quicken, but it appears to be fine - and is getting LOTS of good press, as strictly a web based app - AND also making money.   Check it out...
          Quote:" Moving quicken accounts to new quicken file: Gmalis1 - I shall note these replies as 'helpful' as I see that..."Here's the deal with my biased opinion.I used for about four months recently._ It has it's good points and bad.The good is that it downloads transactions way better than Quicken.The rest is all bad...I can't enter transactions manually._ I can't change the date of a transaction to reflect WHEN the transaction actually occurred, not when the check cleared the bank (for businesses, this is very important for tax reporting purposes...I have one employee who insists on holding her paycheck for weeks at a time, which may overlap to the next month...skewing my reports)._ I can't import my employee paychecks.That's to name a few.The topper is...NO preset reporting capabilities._ Everything must be exported to Excel and then you do all the work.If you are looking for a checkbook type of software, then works just great.I expect, and need, more from my financial software._ Quicken provides me with that.
            Quote:" Moving quicken accounts to new quicken file: Here's the deal with my biased opinion. I used for about..."Gmalis1 - Thanks for your comments - very valid ones.  Back to the QIF file transfer...I've been testing this all day long, and started with a CCARD account, figuring that may be easiest (before I tackle investments).  I am having difficulties - the transaction numbers all move just fine. But both categories and account transfers show as categories, and I'd hate to go thru hundreds of xactions to insert brackets on left and right of each.So any payments from checking to CCard in the CCard account show the checking account as a category. I expect it will get even more complex when doing investments. I've tried various combinations of checking the boxes of transactions/special handling of transfers/categories/security etc...And sometimes I get huge number differences, or a large initial dollar start, and another account will also show that same dollar amount.  I fix it by simply deleting the new test account (and the erroneous transactions and starting again.  Suggestions?  Thanks...Dick - I can call you or provide direct email, or allow you LOGMEIN access if that would help?? (your name is ??)
              Quote:" Moving quicken accounts to new quicken file: Gmalis1 - Thanks for your comments - very valid ones.  Back..."Thanks for the offer to have me log in to your computer, but:1 I volunteer on this forum and am not a Quicken employee2 I have a real day job.I'm not sure why the transfer categories are having such a problem._ I would think that you could open the .qif file and adjust the transactions from there, but that wouldn't save you that much time either.Perhaps No Way Jose, the resident Quicken guru, can chime in on this one and let you know how to handle the transactions with the transfer categories._ One final thing...are you sure that the account names match up perfectly from one file to the other?_ Having different account names in the files could mess this up (maybe).
                Quote:" Moving quicken accounts to new quicken file: Thanks for the offer to have me log in to your computer, but:..."Good thought_ here's what I did. I duplicated my quicken file and called it a test file.  I then gook one of the accounts from the original file (also in the new file)exported all the data and renamed the account only in the name of the QIF file and also in the NMyAccount name - everything else in the account transactions was identical to the original one.  That way I could see if all the transactions and dollars would export and import completely.  Of course had it imported correctly, and the transfers worked properly, the other affected accounts would go up or down accordingly as the "new" accounts transactions took affect.    My purpose, as stated was to insure that all the data got exported and imported completely.  Why am I doing this?  For testing of course, and originally there were only a couple of accounts that didn't move correctly when I went from 2005 to 2008 that have been driving me crazy.  Am I doing something I shouldn't be, by having duplicate transactions in a different account??  Thanks.   With your posting, will JEPollard see it, or do I need to post this somewhere else?
                  Quote:" Moving quicken accounts to new quicken file: Good thought_ here's what I did. I duplicated my quicken file and called..."Hopefully, Jose will see it and respond.I know he reads ALL the posts on here.
                    Quote:" Moving quicken accounts to new quicken file: Hopefully, Jose will see it and respond. I know he reads ALL the..."From what I wrote, since all the accounts would have matched, did you see anything obviously wrong?  BTW, I'm on Pacific Time_ I don't know your time zone, so it may or may not be late there or wherever Jose is.
                      Quote:" Moving quicken accounts to new quicken file: From what I wrote, since all the accounts would have matched, did you..."I've tried to get my head around what's happening, but_not sure I'm succeeding.Your original post said you had one invalid account in your Quicken data_ so my first question is: why do you need a new Quicken "file"?_ What happens if you create a new account in the existing file, and_if the problem account is a non-investment account, cut/paste, or copy/paste, or move the transactions from the old account to the new_... or,_if the problem account is an_investment account, limit your qif file export/import to the one investment account?To try to address the "new Quicken file" approach: if you are having a problem with the transfer categories not being imported as transfer categories, I suspect you should establish all the accounts in the new Quicken file before you begin importing the qif files._ That way the transfer categories will already be created in Quicken, so_when the import sees those categories it should handle them correctly (my guess is that the import process can't create a new account from a transfer category in a transaction)._ [If that doesn't help, you should check the qif file with Notepad to insure that the transfer categories are correctly formatted ... though I can't imagine why they would not be.]Also, if you are importing from multiple qif files (one per account), I think you need to tell Quicken to use "Special handling for transfers"._ I think when that option is set, Quicken should not create duplicate transactions for transfers ... assuming all the referenced accounts are already setup in the Quicken file being imported to._ [I am not certain that this always works, however.]
                        Quote:" Moving quicken accounts to new quicken file: I've tried to get my head around what's happening, but_not sure I'm succeeding...."Thanks for stepping in on this.Your help is appreciated.
                          Quote:" Moving quicken accounts to new quicken file: I've tried to get my head around what's happening, but_not sure I'm succeeding...."I understand your confusion...and now, I am getting confused, as I try to narrow the creation of the QIF file to find what's going wrong a/o correct it.  But it's getting out of hand, frankly - so let me try to do it CORRECTLY:  Brief history. When going from 2005 - 2008, I had trouble with my AMEX account, so I copy/paste all the transactions and that seemed to work, but then found that one brokerage firm's account had errors in some, but not all the brokerage accts we had there IRA/SEP/Roth the quicken experts there suggested I just create a 2nd quicken file (after trying many things) and put those few brokerage accts there.  And that worked fine - although it was a nuisance in creating a weekly spreadsheet to see how the overall networth stood - but it worked...UNTIL it came to end of 2008, when I couldn't run any reports because two Files were needed.  That's when I found the QIF solution/problems (maybe I found them beforehand as well thus creating two quicken files.  Additionally my wife's 401K changed providers, so they had to migrate old transactions, which also caused some consternation...but I got it to work - with the caveat that I seemed to be losing history, with large Starting balances, so while the bottom line was correct,i couldn't go back in history much before some time in 2008 in several accounts....some still go back to 1996. The real problem is with investments only.  And I've been doing my "testing" with a credit card account for the modified QIF files to "see how it worked" and that's where I got messed up most recently, with the transfer account names coming as categories - but there were other spurious transactions that added a large opening balance to a totally unrelated account - it was obvious to fix, but nevertheless mysterious..     So, with your insight, what I'd like to do is to (a) use my GOOD quicken file (I'll create a duplicate one for testing) and (b)try to move my errant investment accounts into it from the 2nd good quicken file that only has a few brokerage accts in it.  But I need some answers:  Besides Transactions, what other boxes should be checked in the IMPORT (categories/securities/transfers etc).  The new file will have all the categories/securities in it.  I shall manually create IDENTICALLY named accounts that will be empty into which to move the exported (from old file and imported to new file)  transactions_ If I can get that to work with just one, successfully, then I'll try the rest and then go "live" with it -  but if it does work, I'd like to then expand and from older backups of quicken, then import the history into the GOOD file, instead of simply having a large opening balance starting sometime late in 2008, so I can retain my history.  This exercise will be required for credit cards as well as investment accounts, but will take some time - ONCE I GET THE PROCESS DOWN Correctly.   Sorry to have gone on so long - I'm on Pacific Time and will gladly provide a phone or IM or email if that is easier for you to assist.  Thanks....Dick
                            Quote:" Moving quicken accounts to new quicken file: I understand your confusion...and now, I am getting confused, as I try to..."I'd just continue with the test you started, but creating the account(s) in the Quicken file before you start the import._ Importing transactions to one account should be pretty simple, but you do have to consider the effect of transfers._ I think you should have every account that will be named in a transfer transaction already setup in Quicken before you start an import of even one account."Special handling for transfers" is only needed when importing more than one qif_file of transactions.If you intend to export/import accounts, categories, or memorized transactions, then check the boxes for those options.If you're going to import security transactions, it would probably be best to have the securities defined in Quicken first._ You can manually define them (make sure you get the names exact), or export/import the Security List._ [It probably isn't necessary to have the securities defined before you import_ I'm pretty sure Quicken will ask you about each one during the import ... and Quicken can add a new security from a transaction._ If you already have the securities defined, you'll avoid the interruptions during the import ... and you'll get the correct info (like stock or bond, etc.)_for each security.]

                              Similar questions other people found helpful: