1. Home
  2. Quicken Personal Finance
  3. Too many transactions downloaded

Too many transactions downloaded

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

Reply to
B
Loading thread data ...

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.

Reply to
ebloch

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

Reply to
B

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.

Reply to
John Pollard

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

Reply to
B

Just to close this topic, I wound up going back to the pre-vacation file and downloading all the transactions. Then correcting the categories where necessary for the downloaded transactions. Then made a new backup and checked to see which files were included.

A reason that I made a copy of the file in another folder was to enable my automatic backup program to be able to backup the Quicken files when they change, just like it does for .doc and other files. Quicken must open and close some files a lot as it runs and I think Q and the backup program were interfering with each other based on some of the messages I was receiving. I've disabled the backup program from seeing the Q file and hope all will be well going forward.

Thanks to those that offered advice.

Bernie

Reply to
B

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.