QIF to OFX
in [Quicken]
|
From: gordito995 on 10 Apr 2010 17:50 In retrospect, I guess I do not fully understand the instructions. Here is my current .qif file that I would like to import into Quicken. These are what my Credit Union provided for on-line bill pay transactions. I have been using this type of transactions for years in Microsoft Money. They could also supply comma delimited transaction files: !Type:Bank D03/16/2010 T-38.40 NE-PMT PAARP MedicareRx Plan - Preferred ^ D03/12/2010 T-146.23 NE-PMT PAmerican Express ^ Could I prevail upon you to show me what the modified file should look like? Also, do I keep the .qif file extension? Thank You and Best Regards, "Art McClinton" <Art.McClinton(a)cox.net> wrote in message news:ZO4wn.61146$u62.19541(a)newsfe10.iad... > Steve Jordi responded to a similar question on March 10th. > I assume you do not really want to convert to OFX (or QFX) but you just > want to import the data. Converting to OFX format requires that you know > the transaction number. > > From Steve's previous post. Which I am using for a couple of credit > cards: > > You can import QIF files to ANY account, but you must first > edit them to change the header. > It's a trick as a workaround. > > I guess that you need this in order to be able to import your QIF > files into all of your accounts in Quicken. > This latter refuses to do so for saving, checking, credit card > accounts etc. Isn't it? > > If I'm correct, qfx is a licensed format from Intuit and you have to > pay $$$ if you want the specifications. > > The workaround to still be able to work with QIF files is to simply > modify their headers. > > ADD The Following to the HEAD of the QIF file > > The date format of each transaction should also be MM/DD/YYYY > > As an example, if you have an account called "My American Express > Gold" that would give > !Account > NMy American Express Gold > TCCard > ^ > > Or a bank account called "My savings" > !Account > NMy savings > TBank > ^ > > For the type next to the "T" you have the following options: > Bank, CCard, or Invst > > Next to the "N" you add your account name > > Actually you even can be more detailed by adding extra information: > Field Indicator Explanation > N Name > T Account type (Bank, CCard, Invst) > L Credit limit (for credit cards) > D Description > ^ End of entry > > Hope that this helps. > > Sincerely, > Steve JORDI > > "gordito995(a)teranews.com" <none(a)phony.net> wrote in message > news:x3Ovn.27825$iL1.7828(a)newsfe24.iad... >> My bank only provides .qif files for on line bill pay transactions. Does >> anyone know if there is a good free (or very inexpensive) converter that >> converts .qif to .ofx transactions? This is for Quicken 2010 with Windows >> 7. >> >> I have gone looking but don't find anything satisfactory yet. >> >> Thanks, >> >> Gordon >
From: Art McClinton on 11 Apr 2010 08:08 I edit the qif file using Notepad. Add the following 4 lines to the beginning of the file: !Account NMy Quicken Account Name TBank ^ Change "My Quicken Account Name" to be EXACTLY the name of the account within Quicken. Within Quicken you will import the file as a QIF file. It will then place the file into the account you have listed. "gordito995(a)teranews.com" <none(a)phony.net> wrote in message news:1p6wn.180778$2r7.33729(a)newsfe05.iad... > In retrospect, I guess I do not fully understand the instructions. Here is > my current .qif file that I would like to import into Quicken. These are > what my Credit Union provided for on-line bill pay transactions. I have > been using this type of transactions for years in Microsoft Money. They > could also supply comma delimited transaction files: > > !Type:Bank > D03/16/2010 > T-38.40 > NE-PMT > PAARP MedicareRx Plan - Preferred > ^ > D03/12/2010 > T-146.23 > NE-PMT > PAmerican Express > ^ > Could I prevail upon you to show me what the modified file should look > like? > > Also, do I keep the .qif file extension? > > Thank You and Best Regards, > > > > > "Art McClinton" <Art.McClinton(a)cox.net> wrote in message > news:ZO4wn.61146$u62.19541(a)newsfe10.iad... >> Steve Jordi responded to a similar question on March 10th. >> I assume you do not really want to convert to OFX (or QFX) but you just >> want to import the data. Converting to OFX format requires that you know >> the transaction number. >> >> From Steve's previous post. Which I am using for a couple of credit >> cards: >> >> You can import QIF files to ANY account, but you must first >> edit them to change the header. >> It's a trick as a workaround. >> >> I guess that you need this in order to be able to import your QIF >> files into all of your accounts in Quicken. >> This latter refuses to do so for saving, checking, credit card >> accounts etc. Isn't it? >> >> If I'm correct, qfx is a licensed format from Intuit and you have to >> pay $$$ if you want the specifications. >> >> The workaround to still be able to work with QIF files is to simply >> modify their headers. >> >> ADD The Following to the HEAD of the QIF file >> >> The date format of each transaction should also be MM/DD/YYYY >> >> As an example, if you have an account called "My American Express >> Gold" that would give >> !Account >> NMy American Express Gold >> TCCard >> ^ >> >> Or a bank account called "My savings" >> !Account >> NMy savings >> TBank >> ^ >> >> For the type next to the "T" you have the following options: >> Bank, CCard, or Invst >> >> Next to the "N" you add your account name >> >> Actually you even can be more detailed by adding extra information: >> Field Indicator Explanation >> N Name >> T Account type (Bank, CCard, Invst) >> L Credit limit (for credit cards) >> D Description >> ^ End of entry >> >> Hope that this helps. >> >> Sincerely, >> Steve JORDI >> >> "gordito995(a)teranews.com" <none(a)phony.net> wrote in message >> news:x3Ovn.27825$iL1.7828(a)newsfe24.iad... >>> My bank only provides .qif files for on line bill pay transactions. Does >>> anyone know if there is a good free (or very inexpensive) converter that >>> converts .qif to .ofx transactions? This is for Quicken 2010 with >>> Windows 7. >>> >>> I have gone looking but don't find anything satisfactory yet. >>> >>> Thanks, >>> >>> Gordon >>
From: gordito995 on 11 Apr 2010 08:39 OK, got that. Should I leave the !Type:Bank statement just where it is? Thanks, Gordon "Art McClinton" <Art.McClinton(a)cox.net> wrote in message news:vZiwn.76027$NH1.16721(a)newsfe14.iad... > I edit the qif file using Notepad. > > Add the following 4 lines to the beginning of the file: > !Account > NMy Quicken Account Name > TBank > ^ > > Change "My Quicken Account Name" to be EXACTLY the name of the account > within Quicken. > > Within Quicken you will import the file as a QIF file. It will then place > the file into the account you have listed. > > > "gordito995(a)teranews.com" <none(a)phony.net> wrote in message > news:1p6wn.180778$2r7.33729(a)newsfe05.iad... >> In retrospect, I guess I do not fully understand the instructions. Here >> is my current .qif file that I would like to import into Quicken. These >> are what my Credit Union provided for on-line bill pay transactions. I >> have been using this type of transactions for years in Microsoft Money. >> They could also supply comma delimited transaction files: >> >> !Type:Bank >> D03/16/2010 >> T-38.40 >> NE-PMT >> PAARP MedicareRx Plan - Preferred >> ^ >> D03/12/2010 >> T-146.23 >> NE-PMT >> PAmerican Express >> ^ >> Could I prevail upon you to show me what the modified file should look >> like? >> >> Also, do I keep the .qif file extension? >> >> Thank You and Best Regards, >> >> >> >> >>> >>> ADD The Following to the HEAD of the QIF file >>> >>> The date format of each transaction should also be MM/DD/YYYY >>> >>> As an example, if you have an account called "My American Express >>> Gold" that would give >>> !Account >>> NMy American Express Gold >>> TCCard >>> ^ >>> >>> Or a bank account called "My savings" >>> !Account >>> NMy savings >>> TBank >>> ^ >>> >>> For the type next to the "T" you have the following options: >>> Bank, CCard, or Invst >>> >>> Next to the "N" you add your account name >>> >>> Actually you even can be more detailed by adding extra information: >>> Field Indicator Explanation >>> N Name >>> T Account type (Bank, CCard, Invst) >>> L Credit limit (for credit cards) >>> D Description >>> ^ End of entry >>> >>> Hope that this helps. >>> >>> Sincerely, >>> Steve JORDI >>> >>> "gordito995(a)teranews.com" <none(a)phony.net> wrote in message >>> news:x3Ovn.27825$iL1.7828(a)newsfe24.iad... >>>> My bank only provides .qif files for on line bill pay transactions. >>>> Does anyone know if there is a good free (or very inexpensive) >>>> converter that converts .qif to .ofx transactions? This is for Quicken >>>> 2010 with Windows 7. >>>> >>>> I have gone looking but don't find anything satisfactory yet. >>>> >>>> Thanks, >>>> >>>> Gordon >>> >
From: Art McClinton on 11 Apr 2010 17:04 yes the remainder of the file remains the same. "gordito995(a)teranews.com" <none(a)phony.net> wrote in message news:mqjwn.76028$NH1.8728(a)newsfe14.iad... > OK, got that. Should I leave the !Type:Bank statement just where it is? > > Thanks, > > Gordon > > > "Art McClinton" <Art.McClinton(a)cox.net> wrote in message > news:vZiwn.76027$NH1.16721(a)newsfe14.iad... >> I edit the qif file using Notepad. >> >> Add the following 4 lines to the beginning of the file: >> !Account >> NMy Quicken Account Name >> TBank >> ^ >> >> Change "My Quicken Account Name" to be EXACTLY the name of the account >> within Quicken. >> >> Within Quicken you will import the file as a QIF file. It will then >> place the file into the account you have listed. >> >> >> "gordito995(a)teranews.com" <none(a)phony.net> wrote in message >> news:1p6wn.180778$2r7.33729(a)newsfe05.iad... >>> In retrospect, I guess I do not fully understand the instructions. Here >>> is my current .qif file that I would like to import into Quicken. These >>> are what my Credit Union provided for on-line bill pay transactions. I >>> have been using this type of transactions for years in Microsoft Money. >>> They could also supply comma delimited transaction files: >>> >>> !Type:Bank >>> D03/16/2010 >>> T-38.40 >>> NE-PMT >>> PAARP MedicareRx Plan - Preferred >>> ^ >>> D03/12/2010 >>> T-146.23 >>> NE-PMT >>> PAmerican Express >>> ^ >>> Could I prevail upon you to show me what the modified file should look >>> like? >>> >>> Also, do I keep the .qif file extension? >>> >>> Thank You and Best Regards, >>> >>> >>> >>> >>>> >>>> ADD The Following to the HEAD of the QIF file >>>> >>>> The date format of each transaction should also be MM/DD/YYYY >>>> >>>> As an example, if you have an account called "My American Express >>>> Gold" that would give >>>> !Account >>>> NMy American Express Gold >>>> TCCard >>>> ^ >>>> >>>> Or a bank account called "My savings" >>>> !Account >>>> NMy savings >>>> TBank >>>> ^ >>>> >>>> For the type next to the "T" you have the following options: >>>> Bank, CCard, or Invst >>>> >>>> Next to the "N" you add your account name >>>> >>>> Actually you even can be more detailed by adding extra information: >>>> Field Indicator Explanation >>>> N Name >>>> T Account type (Bank, CCard, Invst) >>>> L Credit limit (for credit cards) >>>> D Description >>>> ^ End of entry >>>> >>>> Hope that this helps. >>>> >>>> Sincerely, >>>> Steve JORDI >>>> >>>> "gordito995(a)teranews.com" <none(a)phony.net> wrote in message >>>> news:x3Ovn.27825$iL1.7828(a)newsfe24.iad... >>>>> My bank only provides .qif files for on line bill pay transactions. >>>>> Does anyone know if there is a good free (or very inexpensive) >>>>> converter that converts .qif to .ofx transactions? This is for Quicken >>>>> 2010 with Windows 7. >>>>> >>>>> I have gone looking but don't find anything satisfactory yet. >>>>> >>>>> Thanks, >>>>> >>>>> Gordon >>>> >>
First
|
Prev
|
Pages: 1 2 Prev: Transaction appears twice? Next: Quicken 2010 sees transfers in as debits |