duplicates are downloaded only with my citi card

steves8860's Avatar

steves8860

12 Jun, 2021 01:29 PM

I only download from my bank/CC by going to their site and downloading.
When I download all other accounts, if there is a duplicate transaction it is weeded out. With my citicard they don't weed out so I need to be very careful about looking at what I download.

Have I set something up incorrectly with this account?

  1. 1 Posted by Stuart Beesley ... on 12 Jun, 2021 02:16 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    What happens if you delete the original txns and keep the downloaded ones? Does that fix it? Try on a test backup copy

    (Not support, just a fellow user)

  2. Support Staff 2 Posted by Ethan on 13 Jun, 2021 11:09 PM

    Ethan's Avatar

    Hello,

    What file types are you downloading in importing for the different sites? QFX, OFX, QIF, etc. If you are downloading a QFX or OFX file, those formats contain enough information that Moneydance can tell that it has seen a transaction before, and won't reimport that transaction. Any other format doesn't contain the unique transaction IDs necessary for this, so the transactions will be reimported, and can only be resolved by deleting the duplicates or merging them with the existing transactions in the confirmation process.

    Ethan
    Infinite Kind Support

  3. 3 Posted by steves8860 on 14 Jun, 2021 02:15 AM

    steves8860's Avatar

    Actually I am using QFX. What is strange is that my other account I do also and have no duplicates.SteveSent from my T-Mobile 4G LTE Device
    -------- Original message --------From: Ethan <[email blocked]> Date: 6/13/21 6:10 PM (GMT-06:00) To: [email blocked] Subject: Re: duplicates are downloaded only with my citi card [Online Banking
      #18986]

  4. Support Staff 4 Posted by Ethan on 14 Jun, 2021 02:41 AM

    Ethan's Avatar

    Are all transactions being duplicated? If not, does there appear to be any kind of pattern with the ones that are? For example, are they from a certain payee, or are they of a particular type like transfers between accounts, etc?

    Ethan
    Infinite Kind Support

  5. 5 Posted by steves8860 on 17 Jun, 2021 09:24 PM

    steves8860's Avatar

    I just tried. Looks like all of them.Don't have this happen with different accounts

        On Sunday, June 13, 2021, 9:41:28 PM CDT, Ethan <[email blocked]> wrote:
     
       
    |

  6. 6 Posted by steves8860 on 22 Jun, 2021 02:05 PM

    steves8860's Avatar

    Still happening. I've learned to be on the lookout and download carefully with dates so I only have a minimum of items to delete.
    This card pays back 2%. 1 when you purchase and then 1 when you pay. I wonder if there is some type of tag the have on them so they can keep track of what items still need to have the 2nd cash back released when I pay.

       On Sunday, June 13, 2021, 9:41:28 PM CDT, Ethan <[email blocked]> wrote:
     
       
    |

  7. 7 Posted by Stuart Beesley ... on 22 Jun, 2021 02:46 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    To see the raw data. Help. Show console. Keep console open. Go to the register. Select a txn. Right click and then show record details.

  8. 8 Posted by dwg on 22 Jun, 2021 09:37 PM

    dwg's Avatar

    I'm a fellow user.

    With OFX data there is a transaction ID. This is supposed to be unique. Moneydance stores this as part of the transaction so that if it sees it again it knows to discard a newly downloaded transaction as it is a duplicate.

    There is a couple of way this can go wrong.

    If a transaction is manually entered and the downloaded transaction is not merged into it it never gets the Transaction ID.

    Another other thing we sometimes see is the institution changes the transaction ID thus giving Moneydance no hope of identifying duplicates.

    If a bank does not include an ID that just breaks the whole system.

    What Stuart is proposing is to capture the downloaded transactions so that the data can be examined to see what it contains.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac