Hi. I am trying to use a QIF file to import transactions into my Quicken 2007 for Windows checking account. These transactions have been exported from Paytrust. I have used the technique posted in this forum and elsewhere to modify the QIF file header so that it will import properly.
It works great with one exception: it doesn't import transactions that have an account name after the "L" as opposed to a category. I have a QIF file from PayTrust, which I edited per your instructions. All of the payments that had a category name after the "L" imported into my checking account just fine. But all of the payments that have an account name enclosed in brackets ([]) after the "L" don't import.
To try to narrow down the problem, I created a QIF file with a single transaction and set up a dummy checking account in Quicken named TestChecking. Here is the body of the QIF file:
I then go File->Import->QIF, select the file, click "Transactions", "Account List" and "Special Handling" and then "Next". I am asked if I want to import into TestChecking, and I click yes. Then I get a message that says "E-Pay account does not exist. Add new account?" I click no. It then asks me "Continue importing?" and I click OK. I get the little spinning wheel icon for a few seconds, and then I’m back at the Import dialog box, and nothing has changed. Nothing is imported into my test account. I have tried deselecting "Account List" and "Special Handling", and even tried allowing Quicken to add an account called "E-Pay". Nothing works. And if I change the "E-Pay" in my test QIF to 99999, I’m asked if I want to create the account 99999 when I try to import.
Hi. I am trying to use a QIF file to import transactions into my Quicken 2007 for Windows checking account. These transactions have been exported from Paytrust. I have used the technique posted in this forum and elsewhere to modify the QIF file header so that it will import properly. It works great with one exception: it doesn't import transactions that have an account name after the "L" as opposed to a category. I have a QIF file from PayTrust, which I edited per your instructions. All of the payments that had a category name after the "L" imported into my checking account just fine. But all of the payments that have an account name enclosed in brackets ([]) after the "L" don't import. To try to narrow down the problem, I created a QIF file with a single transaction and set up a dummy checking account in Quicken named TestChecking. Here is the body of the QIF file: !Account
NTestChecking
TBank
^
D09/24/2008
T-244.0
PDiscover
NE-pay
L[Discover]
M Ref #:IBVB6FGS
^ I then go File->Import->QIF, select the file, click "Transactions", "Account List" and "Special Handling" and then "Next". I am asked if I want to import into TestChecking, and I click yes. Then I get a message that says "E-Pay account does not exist. Add new account?" I click no. It then asks me "Continue importing?" and I click OK. I get the little spinning wheel icon for a few seconds, and then I?m back at the Import dialog box, and nothing has changed. Nothing is imported into my test account. I have tried deselecting "Account List" and "Special Handling", and even tried allowing Quicken to add an account called "E-Pay". Nothing works. And if I change the "E-Pay" in my test QIF to 99999, I?m asked if I want to create the account 99999 when I try to import. Any ideas? Thanks.
A couple of suggestions.
1.) Create the "Discover" account in your Quicken file before you import.
2.) Uncheck "Special handling for transfers"
3.) Add a new line in the QIF file, just before the first transaction line ... the one with the transaction date (a "D" in position one).
!Type:Bank
So the QIF file looks like this:
!Account NTestChecking TBank ^
!Type:Bank D09/24/2008 T-244.0 PDiscover NE-pay L[Discover] M Ref #:IBVB6FGS
[Note: the forum software is placing a blank line in my post where none belongs (before the newly added QIF file line). There are no blank lines in QIF files.]
A couple of suggestions.
1.) Create the "Discover" account in your Quicken file before you import.
2.) Uncheck "Special handling for transfers"
3.) Add a new line in the QIF file, just before the first transaction line ... the one with the transaction date (a "D" in position one).
!Type:Bank
So the QIF file looks like this:
!Account NTestChecking TBank ^
!Type:BankD09/24/2008 T-244.0 PDiscover NE-pay L[Discover] M Ref #:IBVB6FGS
[Note: the forum software is placing a blank line in my post where none belongs (before the newly added QIF file line). There are no blank lines in QIF files.]
NoWayJose - Thanks for the tips. I did all of the things you mentioned: made sure the Discover account was already created, deselected Special Handling, and made the QIF file read exactly as you specified (without the blank line). I go to the Import dialog box, select my test QIF file, select "<All Accounts>", "Transactions" and "Account List", then click Next. Quicken tells me that it found transactions for TestChecking. I then click Yes to import, and I get the spinning wheel icon, but I end up right back at the QIF Import dialog box, and nothing has been imported into either the TestChecking or Discover accounts.
NoWayJose - Thanks for the tips. I did all of the things you mentioned: made sure the Discover account was already created, deselected Special Handling, and made the QIF file read exactly as you specified (without the blank line). I go to the Import dialog box, select my test QIF file, select "", "Transactions" and "Account List", then click Next. Quicken tells me that it found transactions for TestChecking. I then click Yes to import, and I get the spinning wheel icon, but I end up right back at the QIF Import dialog box, and nothing has been imported into either the TestChecking or Discover accounts. Any other ideas? Thanks for the help...
Try creating a Cash Account, removing the first 4 lines in the QIF file then importing to the Cash Account.
If successful, select all of the transactions in the Cash Account using Windows "select/shift select", right click and move the transactions to the desired account.
NoWayJose - Thanks for the tips. I did all of the things you mentioned: made sure the Discover account was already created, deselected Special Handling, and made the QIF file read exactly as you specified (without the blank line). I go to the Import dialog box, select my test QIF file, select "", "Transactions" and "Account List", then click Next. Quicken tells me that it found transactions for TestChecking. I then click Yes to import, and I get the spinning wheel icon, but I end up right back at the QIF Import dialog box, and nothing has been imported into either the TestChecking or Discover accounts. Any other ideas? Thanks for the help...
Just for reference: I imported the QIF file I put in my previous post successfully, with the caveats I named. {But I didn't select "<all accounts>"; I selected an account that was valid to import to (it was probably a cash account).]
Problem solved! Thank you both for your posts - they led me to the problem. It was as simple as selecting a cash or asset account in the QIF Import dialog box instead of selecting <All Accounts>. Once I did that, everything imported properly into my checking account. Thanks again for your help!
Forums 
