Download transactions from Capital One Credit Card Services

Charles's Avatar

Charles

25 Sep, 2015 01:06 AM

Do you have the OXF codes necessary to download transactions from Capital One Credit Card Services?

  1. 1 Posted by Ian L on 25 Sep, 2015 01:22 PM

    Ian L's Avatar

    Capital One Credit Cards does not support direct connections, so you'll need to download and import OFX files to get your transactions into Moneydance. You can also open your bank's download page directly (after entering the appropriate address in the Account->Edit Account menu) by going to the menu bar and selecting Online->Open Account Website.

    Please let me know if I can be of further assistance, and thank you for your interest in Moneydance.

    Ian
    Infinite Kind Support

  2. Ian L closed this discussion on 25 Sep, 2015 01:22 PM.

  3. Chuck Fossen re-opened this discussion on 25 Sep, 2015 01:27 PM

  4. 2 Posted by Chuck Fossen on 25 Sep, 2015 01:27 PM

    Chuck Fossen's Avatar

    The reason I'm asking is that capital one supports quicken direct connect.
    Does intuit use a different method than moneydance?
    Thanks,
    Chuck

  5. 3 Posted by Ian L on 25 Sep, 2015 02:03 PM

    Ian L's Avatar

    Capital One supports direct connect for all of their accounts except credit cards for some reason. We do support downloading from other Capital One accounts, but for credit cards you'll need to use the download-and-import method.

    Ian
    Infinite Kind Support

  6. 4 Posted by noramar on 11 Oct, 2015 07:29 PM

    noramar's Avatar

    I'd like to piggy-back on this conversation, if I may. I never use Web Connect on any financial website, but have always been able to use either OFX or QFX downloads to update MD. However, today I tried to do this for my Capital One credit card, and couldn't do either of the two. It looks fine at first, but then I get this error message:

    ------ begin message -----
    There was an error communicating with your financial institution. The details of this error are below.
    Unable to determine account for payment list
    In English, this usually means Moneydance was unable to determine which account was associated with downloaded information
    ------ end message ------

    I get the same error for OFX and QFX. Any idea what is going on here? I don't have this problem anywhere else. I was also unable to open the QFX file in Numbers (Mac), which usually will open those files. I changed the extension to TXT and opened it in text edit. The format seems off, with everything running together, no end of lines.

    Then I went over to the Chase website and did the same thing. I was able to open the QFX file in Numbers as I knew I would, and when I changed the extension to TXT, I could see the format is very different. Looks like a proper XML file. Is this something I need to take up with Capital One? I haven't tried to set up Web Connect. Should I?

    Thanks.

  7. 5 Posted by Ian L on 12 Oct, 2015 12:00 PM

    Ian L's Avatar

    Capital One recently changed the format of their OFX files slightly. You should still be able to import it into Moneydance, but you will need to re-select your account in the import window. Everything should work from there. If you have any trouble, please let us know.

    Ian
    Infinite Kind Support

  8. 6 Posted by jonandkathy on 07 Nov, 2015 03:26 AM

    jonandkathy's Avatar

    I've seen several discussions about Capital One credit card direct download, all of them saying that Moneydance can't connect directly, but can accept imports of downloaded data. I see the following message on Capital One's credit card site:

    Capital One has recently updated our systems to provide an increased level of security and additional functionality to our customers. To continue using Quicken, you will need to complete a simple account deactivation and reactivation process outlined here: Quicken Instructions

    I clicked on the Quicken instructions link, and saw these steps for Quicken for Windows 2013-2015 Web Connect; there are several other options as well (7 in total, for variations of Quicken/QuickBooks/Mac, and Web Connect/Express Web Connect:

    Quicken Instructions
    Quicken for Windows 2013–2015 | Web Connect
    Task 1: Conversion Preparation

    Backup your data file. For instructions to back up your data file, choose Help menu > Search. Search for Backing Up Your Data and follow the instructions.
    Download the latest Quicken Update. For instructions to download an update, choose Help menu > Search. Search for Update Software and follow the instructions.
    Task 2: Deactivate Your Account(s) At Capital One Card Services on or after 9/21/2015

    Choose Tools menu > Account List.
    Click the Edit button of the account you want to deactivate.
    In the Account Details dialog, click on the Online Services tab.
    Click Deactivate. Follow the prompts to confirm the deactivation.
    Click on the General tab.
    Remove the financial institution name and account number. Click OK to close the window.
    Repeat steps 2–6 for each account at Capital One Card Services.
    Task 3: Re-activate Your Account(s) at Capital One Card Services on or after 9/21/2015

    Log in to http://www.capitalone.com and download your Quicken Web Connect file.
    Click File > File Import > Web Connect File.
    If prompted for connectivity type, select Web Connect.
    IMPORTANT: Take note of the date you last had a successful connection. If you have overlapping dates in the web-connect process, you may end up with duplicate transactions.
    Ensure you associate the account to the appropriate account already listed in Quicken. You will want to select Link to an existing account and select the matching account in the drop-down menu.
    IMPORTANT: Do NOT select Create a new account. If you are presented with accounts you do not want to track in this data file, select Ignore – Don’t Download into Quicken or click the Cancel button.
    Repeat steps 2 – 4 for all of your accounts.

    With this, I would have expected Moneydance could now direct connect to the Capital One credit card website (I understand that this historically has not been possible). I'm not sure exactly how to get these steps to work with Moneydance; could a power user chime in and explain why these instructions will/won't work with Moneydance to enable direct connecting with Capital One credit cards?

    Thanks.

  9. 7 Posted by Ian L on 09 Nov, 2015 12:10 PM

    Ian L's Avatar

    There are two methods that personal finance software can use to access your accounts: direct connect and web connect. With web connect, the software basically connects to your bank's website and downloads and imports OFX, QFX, QIF, and OFC files automatically. Direct connect actually connects to a server at your bank instead of their website and usually requires different login credentials than you would use to log into your banks website.

    Moneydance only supports automatic connections through direct connect and not web connect. It looks like capital One Credit cards still only support web connect after their update, so you'll still need to download and import files from them.

    Ian
    Infinite Kind Support

  10. 8 Posted by d0275daf on 05 Feb, 2016 11:43 AM

    d0275daf's Avatar

    I too am having the same issues trying to download from Capitol One. Spent an hour on the phone with their tech support that could not speak English and only knew how to read a script. IF this is correct that MD does not support web connect, even though I had no problems with Quicken, then why is it not being fixed?

    Another idea would be to create an extension that would automate the web login and download just for Capitol One. I really do not want to manually download and import each time.

    Thanks,
    Ron

  11. 9 Posted by Ian L on 05 Feb, 2016 07:15 PM

    Ian L's Avatar

    Supporting downloads from banks that only use web connect is very high on our requested feature list and is definitely something we are looking into. Unfortunately, it's not an easy problem to solve, especially given that their are thousands of banks in the world. It's at the top of our internal wishlist though, and something we discuss and research regularly. I can't give a specific timeline for this, but it is something we are working on.

    Ian
    Infinite Kind Support

  12. 10 Posted by Jim on 25 Apr, 2016 04:03 AM

    Jim's Avatar

    Too bad! I was finally ready to dump Quicken and pay for Money Dance, but I can't automatically download my Capital One MasterCard transactions.

    I now use my Capital One Card several times a day and I update my transactions through Quicken several times per week. I don't have time to log in to Capital One's website and manually download a qfx file several times a week, so I guess I'll have to stick with Quicken awhile longer.

    Not to be abrasive, but if Quicken can do it, you should be able to also!

  13. 11 Posted by d0275daf on 25 Apr, 2016 10:01 AM

    d0275daf's Avatar

    Those are my same thoughts too, and I agree, I do not have time to go to eight different sites and download a file, then import it, then finally open it. That is what computers are for, to SAVE you time, not waste your time.

    ----- Original Message -----

  14. 12 Posted by neek on 30 Apr, 2016 10:03 PM

    neek's Avatar

    yes, sorry - like your program, really wanted to dump Qkn for many reasons. But lack of ability to download transactions via web connect (Capital One credit cards) is a deal breaker for me. Would definitely switch if this were the case. Downloading then importing a file from Capital One is not a very plausible workaround on a regular basis. will revisit MoneyDance if/when this functionality is introduced.

    thank you !

  15. 13 Posted by dwg on 30 Apr, 2016 10:22 PM

    dwg's Avatar

    Web connect was developed by Quicken so it really should be called Quicken Web Connect, as far as I am aware there is no published specification of it so it is not open to all. Hence it is not easy for any vendor to implement it, therefore a statement like Quicken can do so someone else should be able to as well is a misrepresentation at best.

    As a reality check, Web Connect and Direct Connect are largely available to only people in the US - and not all institutions there support it. Pretty much the rest of the world has to use downloaded files or enter the data manually,

  16. 14 Posted by Jim on 01 May, 2016 01:01 PM

    Jim's Avatar

    Ignore

  17. System closed this discussion on 02 Oct, 2016 02:33 AM.

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

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