Home → Questions →

Downloading transaction from banks...need tips about overlaping dates...

Admin Functions

• Remove

nzdreamer55

30 May, 2012 12:44 AM

Hello everyone,

So a number of my financial institutions don't have direct connect. I wish in time that Moneydance will support web connect, but until then it is the old manual download of transactions to check against what I have entered. I have realized that if I select a date from before the last time I downloaded stuff, then I have to re-merge transactions that are already cleared.

Is there a solution to make matching up transactions less redundant so I am not re-merging transactions that I mistakenly downloaded again? Should I use the last date where I have a cleared transaction as the start date for transactions that I need to down load?

Thanks
-S

1. Support Staff 2 Posted by Jessica Little on 31 May, 2012 02:19 PM

   

   Hi,

   What file format are you downloading? If you have the option to download a QFX/OFX file, you should choose that. The OFX format includes transaction IDs, which allow Moneydance to uniquely identify each transactions and automatically discard duplicates. Other file formats don't include IDs, and so require manual merging.

   If you don't have the option to download OFX/QFX files, then using your last download date is a good way to minimize the number of duplicates you need to merge.

   Jessica Little
   Moneydance Support

   Admin Functions

   • Echo
   • Remove

2. 3 Posted by nzdreamer55 on 31 May, 2012 02:49 PM

   

   Thanks so much Jessica for the help. I was really excited to hear about this feature and went to try it out as soon as I saw you posted. I opened my checking account and saw that I had downloaded transactions and accepted or merged them through the 5/25/2012. So I went to the chase web site (my bank), and selected the QFX format (they don't have OFX) and selected a date range of 05/01/2012 to 05/31/2012.

   If this feature works then it should only bring in transactions dated 05/26/2012-05/31/2012.

   It did not. It brought in all transactions from the date range that I specified. I have attached a picture showing the outcome of my experiment.

   Am I doing something wrong? Is there another step that I need to do to get rid of the duplicate transactions?

   Is the QFX format not providing the uniquely identifiers that the OFX format should have?

   Thanks for the help.

   -Steve

   • Money_Dance_Import_pic_1.jpg 248.4 KB

   Admin Functions

   • Split
   • Remove

3. Support Staff 4 Posted by Jessica Little on 02 Jun, 2012 11:19 AM

   

   Hi Steve,

   The first time you import a QFX file, none of your current transactions will have IDs, so Moneydance won't be able to match them. So, you'll get a lot of duplicates (as you discovered). However, when you match the transactions from the QFX file, the IDs will be saved, so you should get less duplicates in future downloads. Once most of your transactions are from QFX downloads, you shouldn't get any duplicates at all.

   Jessica Little
   Moneydance Support

   Admin Functions

   • Echo
   • Remove

4. 5 Posted by nzdreamer55 on 03 Jun, 2012 04:44 PM

   

   Thanks for the explanation. That makes sense. So I just need to give it some time and keep using the QFX files accepting them as I can and eventually there won't be duplicate downloads.

   Thanks for the help.
   -Steve

   Admin Functions

   • Split
   • Remove

5. Scott Meehan closed this discussion on 04 Jun, 2012 01:07 AM.

Comments are currently closed for this discussion. You can start a new one.