Prev: Downloaded wrong amount
Next: What does validate do? - Averting disaster
From: foxta on 6 Jan 2010 21:48
All,

I have Quicken 2009 Premier R7 running on Windows Vista.

My issue pertains to a 401(k) account. I had been tracking investments
manually, until I found the option with my institution to download a QFX
file for Quicken (I do not believe I can do a direct connect to the
account.)

I downloaded and imported the Web Connect file, and the information
appeared in my 401(k) account, parallel to my manual transactions (I
accepted the transactions). However, the funds had separate names. I
decided to delete the downloaded transactions, as I have historical price
data associated my manually entered funds.

After deleting the transactions from the register, I later decided to
re-import the transactions from the QFX file and remove my manual
transactions, using the new security name, for ease of future downloads.
When I used the import function, however, I was told there were no new
transactions in the file, but the balances were updated. In response, I
deleted my manual transactions. I retried the import, but was given the
same message. Further, I have disconnected the 401(k) account from the
institution and removed the institution information from the Online
Center, but when re-connecting the account with the import file, I am
again given the message "There are no new transactions."

My question after all of this - how can I have Quicken forget/delete/not
see previously imported/accepted transactions from a QFX file? I
appreciate any advice anyone may have. Thanks.

-------------------------------------




##-----------------------------------------------##
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
alt.comp.software.financial.quicken - 20022 messages and counting!
##-----------------------------------------------##
From: John Pollard on 8 Jan 2010 10:37
foxta wrote:
> I have Quicken 2009 Premier R7 running on Windows Vista.
>
> My issue pertains to a 401(k) account. I had been tracking investments
> manually, until I found the option with my institution to download a
> QFX file for Quicken (I do not believe I can do a direct connect to
> the account.)
>
> I downloaded and imported the Web Connect file, and the information
> appeared in my 401(k) account, parallel to my manual transactions (I
> accepted the transactions). However, the funds had separate names. I
> decided to delete the downloaded transactions, as I have historical
> price data associated my manually entered funds.

You should not have needed to do that.

When Quicken sees a security name in a download that it does not
recognize, it should ask you if it is a new security, or one you already
have in your Security List. If you choose a name already in your Security
List, Quicken should link the two names (keeping your original name) from
that point on.

For future reference: if you decide to make such a decision in the future,
it would be a good idea to backup before you do the delete.

> After deleting the transactions from the register, I later decided to
> re-import the transactions from the QFX file and remove my manual
> transactions, using the new security name, for ease of future
> downloads. When I used the import function, however, I was told there
> were no new transactions in the file, but the balances were updated.

Quicken remembers which transactions have been downloaded before (even if
you never Accepted them into Quicken). If if didn't, and you really never
wanted to see a downloaded transaction again, it would still keep
appearing in your downloads.

> In response, I deleted my manual transactions. I retried the import,
> but was given the same message. Further, I have disconnected the
> 401(k) account from the institution and removed the institution
> information from the Online Center, but when re-connecting the
> account with the import file, I am again given the message "There are
> no new transactions."

This is not normal, in my opinion. The deactivation of an account should
(and usually does) wipe out Quicken's record of previously downloaded
transactions for that account. Usually this results in every transaction
available from the fi for that account being presented in the next
download.

> My question after all of this - how can I have Quicken
> forget/delete/not see previously imported/accepted transactions from
> a QFX file? I appreciate any advice anyone may have.

The simplest way would be to restore a backup from before you deleted your
manually entered transactions.

If that's not possible, there is a somewhat clumsy possible workaround;
how clumsy depends on how many transactions are involved.

The basic idea is to prevent Quicken from recognizing the downloaded
transactions as having been downloaded before.

If the transactions are in the download (in your QFX file), but Quicken
says there are no transactions available, that usually means that Quicken
thinks all the downloaded transactions have been downloaded before.

The key that Quicken uses to identify downloaded transactions is the
Financial Insitution Transaction Identifier ("FITID"). The financial
institution is supposed to create a unique FITID for each transaction they
provide to be downloaded. That FITID should never be the same as the
FITID for any other transaction, for that same account, from that fi.

The trick is to modify the downloaded transactions for the specific
account, so each has an FITID that Quicken has never seen for that account
before. This can usually be done just by adding a character (any
character) to the end of the existing FITID in the downloaded QFX file.
[You can edit a QFX file in Notepad. You can use "Find" to locate the
FITID's and modify them (they have an OFX tag of "<FITID>" - no quotes).
It might be a good idea to make a copy (backup) of the QFX file before you
begin to modify it.]


--

John Pollard
news://<YOUR-NNTP-NEWSERVER-HERE>/alt.comp.software.financial.quicken
Your source of user-to-user Quicken help


From: Tyler Fox on 9 Jan 2010 18:43
"John Pollard" <8plus7isf(a)gmail.com> wrote in
news:hi7jft$2o2$1(a)news.eternal-september.org:

> foxta wrote:
>> I have Quicken 2009 Premier R7 running on Windows Vista.
>>
>> My issue pertains to a 401(k) account. I had been tracking
>> investments manually, until I found the option with my institution to
>> download a QFX file for Quicken (I do not believe I can do a direct
>> connect to the account.)
>>
>> I downloaded and imported the Web Connect file, and the information
>> appeared in my 401(k) account, parallel to my manual transactions (I
>> accepted the transactions). However, the funds had separate names. I
>> decided to delete the downloaded transactions, as I have historical
>> price data associated my manually entered funds.
>
> You should not have needed to do that.
>
> When Quicken sees a security name in a download that it does not
> recognize, it should ask you if it is a new security, or one you
> already have in your Security List. If you choose a name already in
> your Security List, Quicken should link the two names (keeping your
> original name) from that point on.
>
> For future reference: if you decide to make such a decision in the
> future, it would be a good idea to backup before you do the delete.

I do have a backup - I was waiting to load it, as I had a few transactions
I posted to other accounts that I didn't want to re-enter if I didn't have
to.

On the issue of linking names, how do I know if it accurate links them? The
fund names are very similar - my manual transactions are "Index Fund" while
the downloaded are "Index Fund-111111". Because Quicken inserted the
placeholder transactions to zero out my manual funds and bring up the
downloaded fund names, I'm guessing they didn't link. I was never given a
prompt with the options you describe.

>> After deleting the transactions from the register, I later decided to
>> re-import the transactions from the QFX file and remove my manual
>> transactions, using the new security name, for ease of future
>> downloads. When I used the import function, however, I was told there
>> were no new transactions in the file, but the balances were updated.
>
> Quicken remembers which transactions have been downloaded before (even
> if you never Accepted them into Quicken). If if didn't, and you really
> never wanted to see a downloaded transaction again, it would still
> keep appearing in your downloads.

I understand - it's my desire to edit the list of remembered FITIDs by
Quicken.

>> In response, I deleted my manual transactions. I retried the import,
>> but was given the same message. Further, I have disconnected the
>> 401(k) account from the institution and removed the institution
>> information from the Online Center, but when re-connecting the
>> account with the import file, I am again given the message "There are
>> no new transactions."
>
> This is not normal, in my opinion. The deactivation of an account
> should (and usually does) wipe out Quicken's record of previously
> downloaded transactions for that account. Usually this results in
> every transaction available from the fi for that account being
> presented in the next download.

I did not delete the entire 401(k) account - only the accepted downloaded
transactions, and the manual transactions for that time period.

Also, I deleted the connection between the account and the FI, and removed
the FI from the Online Center (as it was not linked with any other
account). But I didn't delete the entire account - I have more manual
transactions than just the time period of the QFX file.

>> My question after all of this - how can I have Quicken
>> forget/delete/not see previously imported/accepted transactions from
>> a QFX file? I appreciate any advice anyone may have.
>
> The simplest way would be to restore a backup from before you deleted
> your manually entered transactions.
>
> If that's not possible, there is a somewhat clumsy possible
> workaround; how clumsy depends on how many transactions are involved.
>
> The basic idea is to prevent Quicken from recognizing the downloaded
> transactions as having been downloaded before.
>
> If the transactions are in the download (in your QFX file), but
> Quicken says there are no transactions available, that usually means
> that Quicken thinks all the downloaded transactions have been
> downloaded before.
>
> The key that Quicken uses to identify downloaded transactions is the
> Financial Insitution Transaction Identifier ("FITID"). The financial
> institution is supposed to create a unique FITID for each transaction
> they provide to be downloaded. That FITID should never be the same as
> the FITID for any other transaction, for that same account, from that
> fi.
>
> The trick is to modify the downloaded transactions for the specific
> account, so each has an FITID that Quicken has never seen for that
> account before. This can usually be done just by adding a character
> (any character) to the end of the existing FITID in the downloaded QFX
> file. [You can edit a QFX file in Notepad. You can use "Find" to
> locate the FITID's and modify them (they have an OFX tag of "<FITID>"
> - no quotes). It might be a good idea to make a copy (backup) of the
> QFX file before you begin to modify it.]
>

Thanks for your help.

As I understand your response, you are saying there is no manual way to
edit Quicken's database of remembered downloaded transactions (FITIDs),
even if that FI is removed from the Online Center(!?) - you can only edit
the QFX file if you have it?

--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---
From: John Pollard on 9 Jan 2010 20:50
Tyler Fox wrote:
> "John Pollard" <8plus7isf(a)gmail.com> wrote in
> news:hi7jft$2o2$1(a)news.eternal-september.org:
>
>> foxta wrote:
>>> I have Quicken 2009 Premier R7 running on Windows Vista.
>>>
>>> My issue pertains to a 401(k) account. I had been tracking
>>> investments manually, until I found the option with my institution
>>> to download a QFX file for Quicken (I do not believe I can do a
>>> direct connect to the account.)
>>>
>>> I downloaded and imported the Web Connect file, and the information
>>> appeared in my 401(k) account, parallel to my manual transactions (I
>>> accepted the transactions). However, the funds had separate names. I
>>> decided to delete the downloaded transactions, as I have historical
>>> price data associated my manually entered funds.
>>
>> You should not have needed to do that.
>>
>> When Quicken sees a security name in a download that it does not
>> recognize, it should ask you if it is a new security, or one you
>> already have in your Security List. If you choose a name already in
>> your Security List, Quicken should link the two names (keeping your
>> original name) from that point on.
>>
>> For future reference: if you decide to make such a decision in the
>> future, it would be a good idea to backup before you do the delete.
>
> I do have a backup - I was waiting to load it, as I had a few
> transactions I posted to other accounts that I didn't want to
> re-enter if I didn't have to.
>
> On the issue of linking names, how do I know if it accurate links
> them? The fund names are very similar - my manual transactions are
> "Index Fund" while the downloaded are "Index Fund-111111". Because
> Quicken inserted the placeholder transactions to zero out my manual
> funds and bring up the downloaded fund names, I'm guessing they
> didn't link. I was never given a prompt with the options you describe.
>
>>> After deleting the transactions from the register, I later decided
>>> to re-import the transactions from the QFX file and remove my manual
>>> transactions, using the new security name, for ease of future
>>> downloads. When I used the import function, however, I was told
>>> there were no new transactions in the file, but the balances were
>>> updated.
>>
>> Quicken remembers which transactions have been downloaded before
>> (even if you never Accepted them into Quicken). If if didn't, and
>> you really never wanted to see a downloaded transaction again, it
>> would still keep appearing in your downloads.
>
> I understand - it's my desire to edit the list of remembered FITIDs by
> Quicken.
>
>>> In response, I deleted my manual transactions. I retried the import,
>>> but was given the same message. Further, I have disconnected the
>>> 401(k) account from the institution and removed the institution
>>> information from the Online Center, but when re-connecting the
>>> account with the import file, I am again given the message "There
>>> are no new transactions."
>>
>> This is not normal, in my opinion. The deactivation of an account
>> should (and usually does) wipe out Quicken's record of previously
>> downloaded transactions for that account. Usually this results in
>> every transaction available from the fi for that account being
>> presented in the next download.
>
> I did not delete the entire 401(k) account - only the accepted
> downloaded transactions, and the manual transactions for that time
> period.
>
> Also, I deleted the connection between the account and the FI, and
> removed the FI from the Online Center (as it was not linked with any
> other account). But I didn't delete the entire account - I have more
> manual transactions than just the time period of the QFX file.
>
>>> My question after all of this - how can I have Quicken
>>> forget/delete/not see previously imported/accepted transactions from
>>> a QFX file? I appreciate any advice anyone may have.
>>
>> The simplest way would be to restore a backup from before you deleted
>> your manually entered transactions.
>>
>> If that's not possible, there is a somewhat clumsy possible
>> workaround; how clumsy depends on how many transactions are involved.
>>
>> The basic idea is to prevent Quicken from recognizing the downloaded
>> transactions as having been downloaded before.
>>
>> If the transactions are in the download (in your QFX file), but
>> Quicken says there are no transactions available, that usually means
>> that Quicken thinks all the downloaded transactions have been
>> downloaded before.
>>
>> The key that Quicken uses to identify downloaded transactions is the
>> Financial Insitution Transaction Identifier ("FITID"). The financial
>> institution is supposed to create a unique FITID for each transaction
>> they provide to be downloaded. That FITID should never be the same
>> as the FITID for any other transaction, for that same account, from
>> that fi.
>>
>> The trick is to modify the downloaded transactions for the specific
>> account, so each has an FITID that Quicken has never seen for that
>> account before. This can usually be done just by adding a character
>> (any character) to the end of the existing FITID in the downloaded
>> QFX file. [You can edit a QFX file in Notepad. You can use "Find" to
>> locate the FITID's and modify them (they have an OFX tag of "<FITID>"
>> - no quotes). It might be a good idea to make a copy (backup) of the
>> QFX file before you begin to modify it.]
>>


> As I understand your response, you are saying there is no manual way
> to edit Quicken's database of remembered downloaded transactions
> (FITIDs), even if that FI is removed from the Online Center(!?) - you
> can only edit the QFX file if you have it?

No, that's not what I said. While there is no way to modify Quicken on a
transaction-by-transaction basis; as I said (in this thread):

"The *deactivation* of an account
should (and usually does) wipe out Quicken's record of previously
downloaded transactions for that account. Usually this results in
every transaction available from the fi for that account being
presented in the next download."

[Emphasis added]

You can see the same statement in the quoted text above ... well above my
current response.

That statement doesn't refer to removing the account from the Online
Center; it refers to deactivating it from downloading. Which you do by
going to the Overview tab of the account, clicking the "Change Online
Services" button, and clicking "Remove from One Step Update", or "Remove
Connection". Something which I believed you had already done, when I
posted my response.

Assuming you have truly deactivated your account for downloading; I have
no idea why you are not seeing Quicken's "normal" behavior when you
deactivate your account for downloading.

Sometimes strange anomolies indicate data corruption: the only answer I
know for that is to Validate a Quicken Copy of your data - and if the
Validated Copy doesn't exhibit the unwanted behavior; make the Validated
Copy your regular Quicken data file(set).

--

John Pollard
news://<YOUR-NNTP-NEWSERVER-HERE>/alt.comp.software.financial.quicken
Your source of user-to-user Quicken help



 | 
Pages: 1
Prev: Downloaded wrong amount
Next: What does validate do? - Averting disaster