I am trying to Import data that I manually downloaded from my financial institutions and have a few questions:
Is it possible to convert a qif file to a qfx file? If not is there a way to recover qif data in Quicken 2007?
When I import a qfx file, there does not seem to be a way to tell Quicken to include category information? You could do this with a qif file right up front.
When I import a qfx file, all of my accounts do not show up in the box used to select which account to import to. Is there a way to make Quicken recognize all of the accounts I have?
There is no category information in a QFX file. The OFX specs - which control what is in an OFX or QFX file - have no capability to transmit category ... because your financial institution would have any way to know what category you wanted to use for the transactions it downloads.
The accounts that "show up" should be the accounts that are of the same type as the account downloaded, and the accounts which are NOT already activated for downloading.
If you are downloading transactions for an account that is already activated for downloading, and Quicken doesn't know what Quicken account they belong to; you can cancel the download, DeActivate the appropriate account for downloading, and initiate another download.
So when we used QIF files we could get Quicken to determine categories and enter them for us but with QFX files we have to manually enter categories for each item? That does not sound like progress.
Is this what everyone does with QFX files - enter the categories manually?
Memorized transactions come to a rescue - Quicken has a way to save an association of payee with the category. For a new payee - yes, need to select the category manually.
I just imported a QFX file and it did not categorize anything. Almost all of the items are in the Memorized list. When I import a QFX, there seems to be no options of any kind.Should the categories get assigned automatically or do I have to do something?
Is it possible that you refer to Payee list and not to memorized transactions? Memorized transactions are saved with a previously assigned category, dollar amount and even with the Memo. I believe, there is a setting in Quicken to allow a compilation of Memorized transactions (like a check box to use/not to use Memorized transactions -?)
Well, I have both Payee and Memorized transactions. I just want my categories to show up on each item when I import QFX files. Right now, categories are blank when I import.
I don't see anyplace in Quicken 2007 to activate categories when importing QFX files.
Does anyone know how I can activate categories when I import QFX files?
The type of file being imported has nothing to do with whether Quicken can/will assign a category to a downloaded transaction.
The category field in QIF files was useful for transferring transactions between Quicken files, so you wouldn't lose the transaction categories you already had. But financial institutions don't assign categories to transactions, so there is no need to "download" a category.
I don't think so. I think most people use Memorized Payees and Quicken's "Quickfill" capability to let Quicken assign categories ... where feasible.
I do have a whole list of Memorized Payees. I checked my Quickfill Options and they are all checked. But when I import the QFX file, I still do not get categories.
Is there a way to activate Quickfill after the download or is there some other procedure that I am missing? Could you describe the procedure to get categories listed upon importing?
"BobK" wrote in news:47beee22$0$36325 $ snipped-for-privacy@news.sonic.net:
I think the trick is to match the downloaded transaction with a memorized payee. I am having mostly the opposite problem from your situation. I have quickfill/memorize checked (always have had this, so I forget exactly what the settings are). Now when I get a downloaded transaction for CVS it remembers the latest settings and I have to change from Medical to Household and back, depending on what the transaction is and was.
hey - If this whole thread was about downloading a QFX file from some financial institution, (was it via a Web Connect) ?? or manually importing the QFX file & hoping to have it auto-assign categories then let's change the Subject line - instead of having anything to do with QIF files as was originally asked...
BTW - if you want to see what's really going on with your QFX (or QIF) file just open it with Notepad - they are all plain text files with "tags" indicating the information type and content
SO - is the file in question a Web Connect QFX file ?, or some other QIF file ? If Web Connect, then you can just have Quicken open it realtime without even saving/importing it.
There is no "procedure"; when the required conditions are met, Quicken fills in the category (and memo and amount, if specified) as new transactions are entered, either manually, or by "Accepting" a "New" downloaded transaction.
If the payee name in the downloaded transaction matches the payee name in the Memorized Payee List, and the memorized payee has a category assigned, and you have Quickfill turned on ... Quicken will fill in the category when you Accept the downloaded transaction.
[I'm assuming that you have verified that there is only one memorized transaction for the payees in question, and that memorized transaction has a category. If you have multiple memorized transactions for the same payee, and one, or more, of them has a blank category, it may be that transaction that Quicken is using to assign the category.]
If you're still not getting categories assigned, I'm almost out of ideas.
You can try creating a New Quicken file, setting up one account in it that you can download from, create a memorized payee for a transaction you know will download, make sure Quickfill is on, then do a download and see if Quicken assigns the category when you Accept the transaction with the memorized payee. If not, your regular Quicken data may be corrupted.
If your data is corrupted you can try deleting all your Memorized Payees, then re-creating the Memorized Payee List (hold down CTRL+SHIFT while clicking Cash Flow > Memorized Payee List). This is a shotgun approach to the problem; if it is helpful, you still may need to manually edit/prune the resulting Memorized Payee List, which will basically have one memorized payee for each payee with an existing transaction.
You can also try Validating a Quicken Copy of your data; if that helps, make the copy your regular file.
I originally wanted to know if you could convert a QIF file so it can be imported into Quicken 2007. I have two small files left over from before I changed to QFX files. Can that be done?
Then, the main part of the post referred to a QFX file that was manually downloaded and saved. Now when I manually import that QFX file, it does not show all my categories.
Actually, I think I may see the problem. I let Quicken Rename several Payee's. I think when it renames the Payee, it looses the category association. I wonder if I did not permit renaming, if that would permit the categories to show up?
After playing with some of your suggestions, I think I see the problem. Almost all of my imported QFX files have DEBIT PURCHASE or DEBIT PIN PURCHASE in the Payee line and the name of the actual payee in the memo line. This leaves the category blank.
I have not seen this before. In the past, the Payee's name was entered in the right spot. I turned off the Renaming Rules for this tryout.
I assume that the Memorized Payee List is not syncing up with the payee name on the import. I think if I got the payee name in the payee line it would result in categories. Is there something I can do to overcome this?
Yes. Newer versions of Quicken (including Q2007) can rename downloaded payees based on the contents of the Memo field. Once Quicken has renamed the DEBIT PURCHASE to the correct payee name (a name that matches the name in a memorized payee), you should get your categories filled in.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.