How to: Add your Interactive Brokers account(s) to your Mint.com account

36 Responses

  1. RF says:

    I did this and even used only “last business day” for date configuration and it still didn’t pull in any data.

    • JCarlos says:

      Did you get any error messages or did you complete the process in Mint.com but your transactions were not showing up / No account value?

      I would generate the flex report on Interactive Brokers to see if any information is showing on the XML. I recommend you try the last 7 days option too and if you get an error when creating the account try again at a later time. If the information is there in the XML and you don’t get any errors I would contact Mint.com to see what’s wrong. I’m not sure how many trades you have in a day, I suppose if you are an active day trader it could be too much for Mint.com to create all that in their system. If that is the case you might want to consider not having trade data in your Mint.com account and try to see if that helps.

      Let me know if any of the above ideas work for you. Good luck!

      • RF says:

        Transactions show up without balance or position information. I don’t make that many trades.

        • JCarlos says:

          Yeah, that seems to be an issue right now. I get my transactions on the log but for some reason it is not reading the symbol information. I already submitted an email asking them to take a look but haven’t heard back. I’ll post in the forums so hopefully they can address this soon. Meanwhile at least the account value is correctly reflected on Mint.com and all the transactions appear with the caveat of the missing symbol. I’ll let you know if I hear anything from them.

  2. Alex Garcia says:

    I followed the instructions and mint.com seems to connect to the query/account, but it just shows a $0 balance. Any ideas?

    • JCarlos says:

      Does it show any transactions on your log or the entire account is just a big blank?

      • Alex Garcia says:

        It’s the same issue as Ryan below. I checked the XML file, and the balances are correct. I only have one account in the XML. I checked on my phone, and it does show a transaction/deposit I made into that account, but the balance just says $0.

        • JCarlos says:

          RF suggests there is a delay, so I would go with that for now. My understanding is that mint calculates the balance based on your initial (or final) balance for the period and then the activity. If you are providing Mint with all the information available on the report they should be able to properly populate your account with the correct balance. Try opening the account list to see there aren’t any issues with the account and force a refresh of your IB account. If after a few days you still have a $0 balance I would submit a bug report to Mint.
          Also, I´m not sure if you have tried to add the account again. If you haven’t I would wait until a few days have passed in case there is a delay in the system and then do that. (I think) you can always add another IB account without deleting the previous one. Hopefully it is just a temporary issue that fixes itself after a few days. Good luck!

        • JCarlos says:

          Did you select all the information available for the XML when configuring the Flex Query (The 30+ sections they have)?

  3. Ryan says:

    MY account populates in mint, but shows $0. I ran the report to check the XML and the correct balance is shown. How did you get it to show the correct balance and not $0.

    • JCarlos says:

      Just as the site instructs… My next guest would be if you have more than one account on the query (paper trading, UK/US account, etc.) it could be picking an account in which you have a $0 balance. Try making the query for just one account, delete your account from Mint and add it again.
      Also, when I was playing with the settings, I did randomly encounter that when adding my account the whole thing would show a balance of $0 but after removing it and adding it again it imported it correctly. It could very well be that you just need to add it again… I thought it was me goofing around but seeing there are other people getting a $0 balance it could be a bug.

    • RF says:

      I think there’s a delay. If you just wait a day or two, I think it will fix itself. At least it did for me.

  4. John Galt says:

    I tried this following the instructions exactly…keep getting “temporary connectivity issue”. also tried changing time period, data included, all accounts to selecting a single account.

    Regarding the account…its an account with minimal activity so data size should not be an issue.

    • JCarlos says:

      I agree the data size should not be an issue in your case. I would keep it on 30 days and leave the account on “temporary connectivity issues” for few days, hopefully their servers will retry again and complete the initial sync. Meanwhile submit a bug report to Mint.com so they can see other people are facing this issue and address it. My guess is that they have started toying with the interface and that is causing a lot of people adding their accounts right now to face delays or new issues while others were able to sync with minor issues before. My account that I added like a week ago also reports temporary connectivity issues randomly but when I hit retry it syncs and gets out of the temporary error state. We just need to be patient and keep bugging Mint.com for them to address their problems. I still have the issue the share reporting is not working correctly as it doesn’t add the security symbol, but I really don’t care about having that visibility in Mint.

  5. Andy says:

    Tonight I followed the instructions above, with one major difference, I just selected EVERYTHING for the Flex Query, every single main topic and every single option in that query. When it tried just using the categories you listed above, I downloaded $0 balance. When I cleared that query and just selected everything, it worked great.

    Don’t have enough time using this to say if I’m getting connectivity problems, but so far so good.

    • JCarlos says:

      That’s great to hear! Now that I read the article again that is what I meant when I wrote “If you don´t want to take risks, add all the information for all the sections below”, but I guess that might be considered the sections below in the article, not below on the screen. I´ll reword it so people don’t do that. Thanks for the feedback!

  6. Andy says:

    Just so you know – today I noticed that all my Interactive Brokers accounts names were changed from “Interactive Brokers” to “Testing IB”. Could it be that Mint isn’t ready for this to be prime time yet?

    • JCarlos says:

      Yeah same here. Most likely they are going back and doing testing with all the new accounts that are coming in. If I had to guess they probably just got a sample from IB and tested against that but obviously they missed a few things. I already sent them screenshots and the information they asked for to address the ones I know of so it’s good to know they are working on fixing it. Hopefully they’ll fix it soon, they’ve got most of it working already. Below is their latest email:

      Dear Carlos,

      You are most welcome.

      Yes, we have seen the screenshot. I have forwarded your issue to my team lead to identify the root cause and work toward resolution. We’ll keep you posted on any updates we receive.

      Thanks for your continued patience as we work to resolve this issue, we apologize for the inconvenience.

      Best,
      Shelane D.
      Mint.com

  7. Alex Garcia says:

    My balance finally appeared in Mint.com for about 3 or 4 days, and now it is reading $0 again…

    I noticed the name of the account also changed to something like…”Testing IB”

    🙁

    • JCarlos says:

      Mine still shows the right balance… just checked it right now. Oh wait, just updated my accounts and now it’s $0! Probably they are having a great time trying to get this sorted out… On the bright side they finally added IB, better buggy than never. At least we know their team is working on it unlike when they kept talking about adding it ‘someday’ and we were in the dark.

  8. Miguel says:

    The instructions worked! Thanks for posting.

    • JCarlos says:

      That’s great! I am still communicating with them as I am experiencing issues but I’m glad to hear at least it works for some people, that is a good sign. Thanks for commenting!

  9. progruss says:

    This is exactly what I was looking for. Thanks for taking the time to post. Very helpful.

  10. Andy says:

    Just noticed they changed the name back to “Interactive Brokers” (from “Testing IB”). I hope this is an indication they are happy that it is functioning properly. Seems to be working flawlessly for me.

    • JCarlos says:

      That’s great! I noticed the same but for some issue it is detecting my account twice (might be that the UK account has almost the same name) so I haven’t been able to use it (Mint Support told me my account was coming in twice hence it wouldn’t work). I am going to only select my US account and see if that fixes the issue.

  11. Dean H. says:

    Great post!!! worked like a charm. thanks

  12. There is now a tab inside IB account settings for ‘Mint Service’. It is located under Delivery Settings.

    • Carlos says:

      Looks like they made it easy on us now! I will update the instructions, thanks for the heads up!

      • sb8636 says:

        Woo-hoo! Yes they did. I was also having problems getting a correct net value (liquidation value) for my account due to some non-USD-denominated positions. While the integration is still not perfect – e.g. can’t see cost basis for longs/shorts or cash balance within Mint, as far as I can tell, like Fidelity on Mint – the net Interactive Brokers account value used for calculating my net worth in Mint is spot-on. Good enough for what I want to do within Mint – budgeting and overall financial planning.

        • Carlos says:

          Yeah, I entirely agree. They also have issues with the correct symbols appearing on the transaction history but as you pointed out all I really care is my net worth and my budget. If I need to see my performance or what not I can just run a report on IB. It would be nice if all that worked so I could see my performance across all my accounts but having what we’ve got is more than half of the battle so I’m thankful for now. I did email them about these issues including the FX and they said their team would review them but they don’t know when they’ll get prioritize. But she did mention they do know of several issues regarding investments, etc.

  13. Peter Thomas says:

    It took me weeks to find out that there is a bug in the *new* IB Account Management portal for setting up Mint integration. When I went to the classic portal I was able to set up a Mint token instantly and the appropriate working DefaultMint query was created. In the new portal you’d get a query ID reported–but the actual “DefaultMint” query never got built.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: