Home → SyncSpace →

Invalid Data During Download Process

• Edit

tross45

23 Aug, 2020 10:55 PM

Each time I do a manual download from my bank, I get invalid data, that is not coming from my bank. When I first started using Monydance, I first downloaded my data from Quicken and then later deleted a lot of this data due to the slow lag time I was experiencing. Now when I do a manual download from my bank, the data from the bank comes over correctly, but, I also get several incorrect items that appear to be coming from some where else. I have tried confirming and then deleting the items, but the show up again the next time I do the download. Is there a way to eliminate these transactions, or should I just save this file and then start over again with a new clean file?
I am using MoneyDance version 2019.3 on a Windows 10 computer.

1. 1 Posted by tross45 on 23 Aug, 2020 10:57 PM

   

   If I have posted this problem in the wrong area, please move to the appropriate place.

   • Edit

2. 2 Posted by derekkent23 on 24 Aug, 2020 08:11 AM

   

   I am not support staff, just a user.
   Hi tross45

   I think for support or other to be able to help you will need to provide more information.
   1. When you manually download from you bank what is the file type, e.g. OFX, QFX or QIF?
   2. Can you define and give examples of what you mean by “several incorrect items that appear to be coming from somewhere else”?
   3. are these items duplicates of transaction that were imported from Quicken?
   4. Have you opened the downloaded file in a text editor to determine if in fact these item are included in the file you have downloaded from your bank?

   • Edit

3. 3 Posted by tross45 on 24 Aug, 2020 03:04 PM

   

   I am downloading the QFX file.
   Examples: Shelter insurance for $300 or $30.00, when I have had no payments for these amounts.
   I don't know if these items are duplicates from Quicken, but I do suspect that they are.
   I have not opened the downloaded file to see if the errors were in the downloaded file. I will try to do this.

   • Edit

4. 4 Posted by derekkent23 on 24 Aug, 2020 03:19 PM

   

   I am not support staff, just a user.
   Hi tross45

   As you are importing a OFX file the following is worth knowing.

   OFX/QFX files should contain a "Unique Transaction ID" (FITID) for each transaction. Moneydance uses this ID to prevent duplicates.
   The following is an extract of one transaction from my credit card downloaded OFX file. Note the FITID number.

   DEBIT
   20190806000000

   <TRNAMT>-2.90</TRNAMT>
   
   <FITID>20190806000000001</FITID>
   
   <NAME>Southend On Sea Boroug, Southend</NAME>
   
   <CARD>Visa</CARD>
   
   <MEMO>On S XXXX/2.90 POUND STERLING GREAT BRITAIN</MEMO>
   

   It does not matter how many times you import this file into Moneydance the transaction only appears once.
   Also, If you right click on a transaction imported via an OFX file and select “Show transaction details” it should include the FITID
   The QIF file specifications do not include the equivalent to FITID and thus you can get duplicates on importing if transitions already exist in Moneydance.
   If you are setting up Moneydance and have imported your initial QIF file and then either import a second QIF file or OFX/QFX file from your bank which contains duplicates these duplicates will appear in Moneydance. If the duplicates were due to an OFX/QFX files import its important to delete the QIF file duplicates thus leaving the FITID transaction in tack. This will prevent duplicates on the next OFX/QFX files import.

   Hope this helps.

   • Edit

5. 5 Posted by tross45 on 24 Aug, 2020 04:05 PM

   

   I reviewed my QFX file and did not see any of the incorrect data in that file. It may to be coming from the data that I deleted from MoneyDance.

   The following is the data I see when I click on Show Transaction Detail. It looks a little different the the info posted above.

   0.acctid: 7cc30b11-bb61-4335-8e9c-ab35e8adc9a6
   0.desc: Melissa Dougherty
   0.id: daddc15f-d61d-462c-a512-9630f796bb5a
   0.obj_type:
   0.oldid: -1
   0.pamt: -4000
   0.samt: 4000
   0.tags:
   acctid: 3ca7d564-82a2-4061-b3ef-a012e457ac80
   chk: 1089
   desc: Melissa Dougherty
   dt: 20200723
   dtentered: 1596716553011
   id: a0724cfe-ea46-4afe-a0c4-c7bdfd7713fb
   memo:
   obj_type: txn
   oldid: -1
   stat: X
   td: 20200723
   ts: 1597680180692

   • Edit

6. 6 Posted by derekkent23 on 25 Aug, 2020 08:31 AM

   

   I am not support staff, just a user.
   Hi tross45

   The info I posted was from the OFX file.

   After import clicking “Show transaction details” give:

   0.acctid: 3aeb1ad8-1a51-4e73-92ee-a98205fdd6ca
   0.desc: Southend on sea
   0.id: c0e7db04-5c0d-4325-871b-6baefd0c0334
   0.obj_type:
   0.pamt: -290
   0.samt: 290
   acctid: ced1a7e0-e60a-4452-ac3e-c9047191cbd2
   chk:
   desc: Southend on sea
   dt: 20190806
   dtentered: 1598279690328
   id: c35b2d0a-9384-43ae-8b18-709c43a3ebae
   memo:
   obj_type: txn
   td: 20190806
   ts: 1598266651985

   which is the same structure as you are seeing.

   • Edit

7. System closed this discussion on 24 Nov, 2020 08:40 AM.