Financial Data APIs: duplicate transaction fix

Greetings Financial Data API (CAD) Developers!

We are testing a new fix to solve for duplicate transactions in our Financial Data APIs.

A small number of banks are having duplicate transaction issues caused by changes the bank makes to the transaction after it’s initially posted. As we looked across the Intuit ecosystem on how to handle this thorny issue, we found our colleagues working on bank data down under (Australia) had pioneered a fix that we’re eager to try out with our developers.

Why are duplicates created
Some financial institutions (FIs) change the content of the transactions on their websites after they are originally posted and retrieved by the FD API, thus causing the same transactions to get retrieved a second time due to differences in descriptions, posted dates, etc.

The “correctAction” attribute
Transactions that were once returned, but now no longer exist in the bank in that same format will be returned with “D” (for delete) under the correctAction. This attribute has been documented, but not previously populated. The newer updated transactions will continue to be returned in the same way they are today.

Developers can choose to implement logic based on the correctAction attribute and delete the old defunct transactions. Other developers might choose to serve up a message to the user explaining that these transactions have been removed from the bank site and to take further action depending on the functionality of your application.

Limited roll out and your feedback
We are experimenting with this logic starting on Feb. 16, 2016 and only with USAA (2875), BBVA Compass (3144).

We are doing a limited roll out for 1 month and looking for developer feedback.

Please share your input via this survey.

We’ll collectively weigh all the feedback to decide if we roll out this change to additional FIs.

Going, going, going and duplicates gone … over and out!

Questions or comments? Share them on our developer forums!







4 responses to “Financial Data APIs: duplicate transaction fix”

  1. inDinero Avatar

    Hi there – Is there any update on this feature? One of our users is experiencing duplicates because the transaction id is changing the “QFX” file downloaded from the bank website.

    1. Lisa Rathjens Avatar
      Lisa Rathjens

      Hi inDinero, So sorry about this! Can you please submit a support ticket following the instructions here https://developer.intuit.com/help and one of our support engineers will get back to you.

  2. Casey T Avatar
    Casey T

    Hi, I have 2 clients on BBVA and both are experiencing the duplicate transaction issue. No matter what I do, I end up spending way too much time excluding the incorrect transactions. Any update here? Thanks!

    1. nimisha Avatar

      HI Casey,

      FDS api is deprecated as of 11/15/2016. Can you provide more details as to how you are still accessing the data using FDS api?


Leave a Reply

Your email address will not be published. Required fields are marked *