Google Answers Logo
View Question
 
Q: Quicken 2001 deluxe-duplicate Transaction QIF Imports ( No Answer,   4 Comments )
Question  
Subject: Quicken 2001 deluxe-duplicate Transaction QIF Imports
Category: Computers
Asked by: geoartist-ga
List Price: $10.00
Posted: 02 Jun 2004 12:13 PDT
Expires: 02 Jul 2004 12:13 PDT
Question ID: 355449
I need to find out where in Quicken's software file structure the QIF
imports reside as I want to delete them to correct a problem I am
having. I'm using Quicken 2001 Deluxe version and have imported the
same QIF file twice. The results is a duplicate version of
transactions that are waiting for me to bring them into the register
(these transactions are located in a separate window and have the
option to "accept all, or manually approve " before they are added
into the register. I feel that if I can erase the QIF data that I
imported before it is added to the register then I can proceed from
there. Any ideas of where this file/folder is located on the quicken
software structure?

Request for Question Clarification by aceresearcher-ga on 07 Jun 2004 06:11 PDT
Greetings, Geoartist!

Has this occurred more than once? Is it possible that you believed you
had downloaded a new Import file, when in reality the old file still
remained?

Do you download the Import file manually from your bank online, or do
you get it by clicking on the lightning bolt?

I use Quicken 2002 Deluxe, and it doesn't have this problem. I import
files using both methods, depending on the account. However, using the
manual download method, I have on occasion erroneously not entered a
correct "All Transactions from" begin date, and have gotten
transactions that I had previously pulled. On one occasion, I did the
usual "Save As" of the Import file, but apparently did not complete
the process, since the old file still remained when I tried to do the
import.

Regards,

aceresearcher

Clarification of Question by geoartist-ga on 08 Jun 2004 11:17 PDT
Greetings, Geoartist!

Q-Has this occurred more than once? Is it possible that you believed you
had downloaded a new Import file, when in reality the old file still
remained?
A-I downloaded from my bank transactioons with the same date range
twice resulting in duplicate transactions "waiting' to be OK'd by me
and added to the register. I'm using Quicken 2001.

The real question is do you know where this qif data resides ( or what
is has been converted to) in the Quicken file structure so that I can
delete it and repopulate the register correctly. I could manually
delete all items but as there are several hundred entries I find it
too time consuming.
P



I use Quicken 2002 Deluxe, and it doesn't have this problem. I import
files using both methods, depending on the account. However, using the
manual download method, I have on occasion erroneously not entered a
correct "All Transactions from" begin date, and have gotten
transactions that I had previously pulled. On one occasion, I did the
usual "Save As" of the Import file, but apparently did not complete
the process, since the old file still remained when I tried to do the
import.

Regards,

Request for Question Clarification by aceresearcher-ga on 08 Jun 2004 11:26 PDT
geoartist,

I guess what I'm trying to determine is why you believe that the file
has been changed and stored elsewhere, and whether the problem has
occurred more than once. If it's a one-time occurrence, the Commenter
below is correct, and the entries have now been pulled into the
register and reside as part of *all* of your data in the .qdf file --
and you **don't** want to mess with that file, except by using
functions inside Quicken, which will do so safely. Deleting the
register entries for a date range, then reimporting the .qif file as
they suggested, will work.

On the other hand, if this has occurred to you more than once, there
may be something else going on, and I can help you to troubleshoot
that.

Let me know whether you need further assistance,

ace

Clarification of Question by geoartist-ga on 09 Jun 2004 10:12 PDT
Hi Ace

You wrote:
I guess what I'm trying to determine is why you believe that the file
has been changed and stored elsewhere, and whether the problem has
occurred more than once. 

My answer
- the problem has only occured because I imported the same .qif data
into the program twice. Now I have two sets of data that I have yet to
bring into my register. This scenerio has only happened once.

You wrote:
If it's a one-time occurrence, the Commenter
below is correct, and the entries have now been pulled into the
register and reside as part of *all* of your data in the .qdf file --
and you **don't** want to mess with that file, except by using
functions inside Quicken, which will do so safely. Deleting the
register entries for a date range, then reimporting the .qif file as
they suggested, will work.

My comment
-Well if that's the case then do you know of any way of selecting a
date range for deletion versus manually deleting some 500 plus
transactions? If there is a way to select a date range (say
12/03/03-05/12/04) for deletion then my problem is solved and you have
provided an answer.

thanks

Request for Question Clarification by aceresearcher-ga on 10 Jun 2004 16:15 PDT
geoartist,

I've been poking around trying to see what I can find for you. It
certainly appears that Intuit has made it as difficult as possible to
do what you need to do, but I'm still looking for a solution. However,
any Researcher who can find an Answer for you is welcome to post it,
because I'd like you to get the information as soon as possible.

In the meantime, something you could do to get these out of your way
is a "Find and Replace" on all transactions after a certain date;
change their Category to Void, change their Amount to 0.00, change
their Payee to spaces, and finally, change the date to 01/01/1975,
which will make them go to the old end of your register where you
shouldn't have to look at them.

Regards,

aceresearcher
Answer  
There is no answer at this time.

Comments  
Subject: Re: Quicken 2001 deluxe-duplicate Transaction QIF Imports
From: wasting_time-ga on 03 Jun 2004 01:38 PDT
 
correct me if i am wrong, i have never used quiken but if you imported
the same file twice then just close the program and start it again and
import that file only once. if that dosent help then go into start >
search > for files and folders > select all files and folders and type
in *.qif and then hit search.

when the search is finished you will notice it has found qif files...
if you look closley it will tell you the directory were they are
stored. follow that directory and access your files.
Subject: Re: Quicken 2001 deluxe-duplicate Transaction QIF Imports
From: geoartist-ga on 03 Jun 2004 08:36 PDT
 
After importing a .QIF file quicken changes it to another file
extention (don't know this file extention) and stores it who knows
where. i want to find out where the where is, and what the new
extention is called, so I can delete it before I bring it in to my
register. Searching for a *.qif yields nothing.
Any other thoughts?
Subject: Re: Quicken 2001 deluxe-duplicate Transaction QIF Imports
From: crythias-ga on 06 Jun 2004 21:11 PDT
 
If Quicken is like any other database, once you import something, it's
inside the database. The .QIF is still intact. In this case, the data
is in the Quicken data file (.qdf?) that you open when you open
Quicken. (That means it's live data...)

Your best bet might be to back up your Quicken data, delete the ENTIRE
affected register date range (all the entries that are duplicated) and
import the QIF once again.
Subject: Re: Quicken 2001 deluxe-duplicate Transaction QIF Imports
From: crythias-ga on 09 Jun 2004 19:14 PDT
 
I regret I don't have Quicken, so I can't verify if you have this
option. Accounting wise, you really can't delete transactions, you
have to void them. If you still have the ability to match
transactions, which it sounds like you do, you may be able to just
accept the transactions as matched. You may wish to manually accept
one by one, but matching transactions doesn't duplicate, as I see it.
From what I can tell from

(Intuit Support, keyword IMPORT, select Using the Compare to Register
feature when importing a QIF file in Quicken.)
"Matching Transactions

If a transaction has a status of Match, and is the same as the
transaction that appears in the Register section, select the
transaction in the Compare to Register window, and then click Accept.
"

Deleting Transactions

To delete a transaction from the Compare to Register window, select
the transaction, and then click Delete.

Note: Once all of the transactions have been either accepted or
deleted, click Done. If you receive the message "There are too many
Quick Tabs already open." close any unnecessary Quick Tabs to complete
the import.

My (uninformed) Opinion? Just make sure the matches are correct. As
long as you don't have to unmatch any of them. It doesn't seem to
affect your register until  you UNmatch transactions. You (apparently)
must purposefully (and knowingly) make a new transaction to duplicate.

*hits forehead* This is what my wife does on Money (similar concept):
She'll enter a transaction, later download from the bank, and if they
match, she accepts. This is the same thing. I apologize for not
getting this right earlier. (I am not an answerer, and don't have
Quicken).

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy