Too many transactions downloaded

Posted by B on July 17, 2009, 10:33 am

Please log in for more thread options

Before we went on vacation I backed up my Windows Quicken 2007 file and
restored it on a laptop that we were taken along. During the vacation
we entered transactions into Quicken on the laptop. Upon returning home
I created a backup on the laptop and restored it on my home machine. (I
then had Quicken copy the file to a different folder - changing the name
at the same time.)

All appeared well and I entered additional transactions. Then I had
Quicken download transactions from all bank and credit card accounts as
I do regularly. And that is when the problem showed up. Quicken
downloaded transaction going back a year or more. The range varies by
account.

Some of the downloaded transaction are New and I can match to the
transactions we've entered, which is how it should work.

Most of the downloaded transactions had been downloaded before the
vacation and are listed as Match (and have a "c" in the reconciliation
column in the registers.) For transaction that Quicken thinks are
already matched, (already have a "c" in the reconciliation column) I can
easily take care of them by saying Accept All after I handle the new ones.

But in some accounts it has downloaded a very large number of old
transaction that have already been Reconciled. It lists those
transactions as New! The only way I've found to handle them is to
delete each of them in the "downloaded transaction" area, and they have
to be deleted one at a time.

Any suggestions on how to avoid this problem if I start with the backup
from the laptop again? Or other advice? Right now it would be faster
for me to just go back to the pre-vacation file and reenter all the
subsequent transactions

Thanks,
Bernie

Posted by ebloch on July 17, 2009, 3:17 pm

Please log in for more thread options

You say "Upon returning home I created a backup on the laptop and restored
it on my home machine."

It sounds to me that you either did not copy all of the Q files OR you did
not use Q Restore on the home machine before you did additional work there.

You should be copying the ENTIRE backup folder between machines and then use
Q to restore the files BEFORE attempting any other operations.

If this is the problem:
1. Write down the data for any manual transactions you did on the home Q
since returning
2. Copy the entire file folder from laptop to home backup
3. Use Q to restore file from home backup
4. Enter data in Q home from #1 above.

> Before we went on vacation I backed up my Windows Quicken 2007 file and

> restored it on a laptop that we were taken along. During the vacation we

> entered transactions into Quicken on the laptop. Upon returning home I

> created a backup on the laptop and restored it on my home machine. (I

> then had Quicken copy the file to a different folder - changing the name

> at the same time.)

> All appeared well and I entered additional transactions. Then I had

> Quicken download transactions from all bank and credit card accounts as I

> do regularly. And that is when the problem showed up. Quicken downloaded

> transaction going back a year or more. The range varies by account.

> Some of the downloaded transaction are New and I can match to the

> transactions we've entered, which is how it should work.

> Most of the downloaded transactions had been downloaded before the

> vacation and are listed as Match (and have a "c" in the reconciliation

> column in the registers.) For transaction that Quicken thinks are already

> matched, (already have a "c" in the reconciliation column) I can easily

> take care of them by saying Accept All after I handle the new ones.

> But in some accounts it has downloaded a very large number of old

> transaction that have already been Reconciled. It lists those

> transactions as New! The only way I've found to handle them is to delete

> each of them in the "downloaded transaction" area, and they have to be

> deleted one at a time.

> Any suggestions on how to avoid this problem if I start with the backup

> from the laptop again? Or other advice? Right now it would be faster for

> me to just go back to the pre-vacation file and reenter all the subsequent

> transactions

> Thanks,

> Bernie

Posted by B on July 17, 2009, 11:39 pm

Please log in for more thread options

I did do a Quicken Restore on the home computer. The backup files are
on a USB drive. Two files were created with suffixes of qdf and idx.
The Restore was done from the USB drive.

Bernie

On 7/17/2009 2:17 PM, ebloch wrote:

> You say "Upon returning home I created a backup on the laptop and restored

> it on my home machine."

> It sounds to me that you either did not copy all of the Q files OR you did

> not use Q Restore on the home machine before you did additional work there.

> You should be copying the ENTIRE backup folder between machines and then use

> Q to restore the files BEFORE attempting any other operations.

> If this is the problem:

> 1. Write down the data for any manual transactions you did on the home Q

> since returning

> 2. Copy the entire file folder from laptop to home backup

> 3. Use Q to restore file from home backup

> 4. Enter data in Q home from #1 above.

>> Before we went on vacation I backed up my Windows Quicken 2007 file and

>> restored it on a laptop that we were taken along. During the vacation we

>> entered transactions into Quicken on the laptop. Upon returning home I

>> created a backup on the laptop and restored it on my home machine. (I

>> then had Quicken copy the file to a different folder - changing the name

>> at the same time.)

>> All appeared well and I entered additional transactions. Then I had

>> Quicken download transactions from all bank and credit card accounts as I

>> do regularly. And that is when the problem showed up. Quicken downloaded

>> transaction going back a year or more. The range varies by account.

>> Some of the downloaded transaction are New and I can match to the

>> transactions we've entered, which is how it should work.

>> Most of the downloaded transactions had been downloaded before the

>> vacation and are listed as Match (and have a "c" in the reconciliation

>> column in the registers.) For transaction that Quicken thinks are already

>> matched, (already have a "c" in the reconciliation column) I can easily

>> take care of them by saying Accept All after I handle the new ones.

>> But in some accounts it has downloaded a very large number of old

>> transaction that have already been Reconciled. It lists those

>> transactions as New! The only way I've found to handle them is to delete

>> each of them in the "downloaded transaction" area, and they have to be

>> deleted one at a time.

>> Any suggestions on how to avoid this problem if I start with the backup

>> from the laptop again? Or other advice? Right now it would be faster for

>> me to just go back to the pre-vacation file and reenter all the subsequent

>> transactions

>> Thanks,

>> Bernie

Posted by John Pollard on July 18, 2009, 9:15 am

Please log in for more thread options

B wrote:

> I did do a Quicken Restore on the home computer. The backup files are

> on a USB drive. Two files were created with suffixes of qdf and idx.

> The Restore was done from the USB drive.

You're missing (at least) the .QEL file which contains the identities of
transactions that have been downloaded before (and your QPH file which
contains your security price history).

A missing (or corrupted) QEL file will produce just the results you
described.

--

John Pollard

Posted by B on July 18, 2009, 12:22 pm

Please log in for more thread options

On 7/18/2009 8:15 AM, John Pollard wrote:

> B wrote:

>> I did do a Quicken Restore on the home computer. The backup files are

>> on a USB drive. Two files were created with suffixes of qdf and idx.

>> The Restore was done from the USB drive.

> You're missing (at least) the .QEL file which contains the identities of

> transactions that have been downloaded before (and your QPH file which

> contains your security price history).

> A missing (or corrupted) QEL file will produce just the results you

> described.

Thanks. I'm going to try to create the backup again in a new folder,
and then restore again. It is possible I suppose that the problem
actually arose when I first did the restore to the laptop before the
vacation. I didn't download any transaction while we were away so
wouldn't have noticed the problem.

Bernie