Capital One May Be Possible

gary.hammer's Avatar

gary.hammer

09 Jun, 2021 12:17 PM

I know Capital One has not been available but things change.
They now work with Money in Excel:
Capital One is here: get connected. We'll announce the most requested banks as our supported institution list grows.

Might be worth a look to see what can be done.

  1. Support Staff 1 Posted by Maddy on 09 Jun, 2021 01:01 PM

    Maddy's Avatar

    Hi Gary,
    Thank you for contacting Moneydance support.

    Moneydance only supports automatic downloads using Direct Connect, and unfortunately Capital One don't support this connection method. If they begin to support Direct Connect at any point, we'd be happy to establish a connection with them.

    Capital One use other connection methods that Moneydance does not support, called Web Connect and Express Web Connect.
    We are actively working on implementing a similar mechanism to what is called Web Connect.

    Web Connect is basically an embedded browser that automates the login and downloading of transactions from a bank's web site. It is easier for banks in that they basically just need a relatively simple login page, account selection, and file download.

    Quicken in the past couple of years has taken the route that this login+download process is done on their servers, but we are committed to doing it on your own computer where it will be under your control. The main difference there is that Moneydance ensures security and privacy, but it is a bit more difficult to implement because we have less control over the environment in which the process is running.

    We have applied for membership to FDX and we'll see how that goes. We have never been a member of the OFX consortium as it was basically run by Intuit, Microsoft, and (earlier) CheckFree and the specification was always public, but our developer have followed it closely since about 2000-2001.

    By only using Direct Connect, we can guarantee that your username, password and financial data only ever exists with your bank or on your own personal computer, and at no point are your details stored on another server.
    You can read more about why we only support this connection type in our blog and also in this article.

    Without Direct Connect, you are still able to easily import your data into the program. The best way to get your transactions into Moneydance is to use a web browser to download files from your bank's web site.

    We'd recommend you download using the OFX or QFX file format if available. If not, use the QIF file format. (These files are sometimes referred to as Quicken or MS Money files). You can import the files to Moneydance using File --> Import.
    The steps for manually importing your data are outlined in this article from the Knowledge Base.

    I hope this information is helpful. Please let us know if you have further questions or need more assistance.

    --
    Maddy, Infinite Kind Support

  2. 2 Posted by jenkins007 on 30 Jun, 2021 10:25 AM

    jenkins007's Avatar

    I use Capital One. please enable the automatic downloads!

  3. Support Staff 3 Posted by Maddy on 30 Jun, 2021 10:29 AM

    Maddy's Avatar

    @jenkins007 - Thank you for contacting Moneydance support.

    As per my reply in post 1 of this thread Capital One use other connection methods that Moneydance does not support, called Web Connect and Express Web Connect.
    We are actively working on implementing a similar mechanism to what is called Web Connect.

    Web Connect is basically an embedded browser that automates the login and downloading of transactions from a bank's web site. It is easier for banks in that they basically just need a relatively simple login page, account selection, and file download.

    Quicken in the past couple of years has taken the route that this login+download process is done on their servers, but we are committed to doing it on your own computer where it will be under your control. The main difference there is that Moneydance ensures security and privacy, but it is a bit more difficult to implement because we have less control over the environment in which the process is running.

    We have applied for membership to FDX and we'll see how that goes. We have never been a member of the OFX consortium as it was basically run by Intuit, Microsoft, and (earlier) CheckFree and the specification was always public, but our developer have followed it closely since about 2000-2001.

    I hope this information is helpful. Please let us know if you have further questions or need more assistance.

    --
    Maddy, Infinite Kind Support

  4. 4 Posted by Dan P on 30 Jun, 2021 12:19 PM

    Dan P's Avatar

    Maddy, correct me if I'm wrong.
    If you enter Capital One's website in the account setup, a Download button appears on the account screen. This will open the internal browser where the user can log in and download the QFX file. It will import automatically.

    just another user

  5. Support Staff 5 Posted by Maddy on 30 Jun, 2021 12:44 PM

    Maddy's Avatar

    Hi Dan,

    What you are describing is the manual download process, as outlined in this article of the Knowledge Base.
    More specifically, it refers to the Account Website Tool.
    On the other hand you can find further information on Direct connect on this page.

    --
    Maddy, Infinite Kind Support

  6. 6 Posted by dwg on 30 Jun, 2021 10:43 PM

    dwg's Avatar

    Dan,

    What you are describing is I believe the first step of what the developer would like to see with the internal browser. The initial step is to have the browser you can use inside of Moneydance much like an external browser, although having limited functionality. The difference at this stage is that Moneydance can monitor what you download and when you download a transaction file proeceed to the import stage.

    At this stage there are a lot of financial institutions it does not work with.

    Eventually the goal is to be able to automate the process through scripts.

  7. 7 Posted by dwg on 30 Jun, 2021 10:46 PM

    dwg's Avatar

    FWIW I looked at Money in Excel and it is using a third party to extract the transactions - Plaid. It would seem that this solution suffers from the same potential security and privacy issues that any aggregator has.

  8. 8 Posted by jenkins007 on 23 Aug, 2021 02:52 PM

    jenkins007's Avatar

    Plaid seems like a good security and privacy download tool using well established encryption with no passwords stored on external servers (I believe they are stored locally on the IOS device and/or local computer).

    StockTwits uses this 3rd party add-on to connect investment accounts with their Stock analysis IOS app. Unfortunately, I use 2 factor authentication and Plaid currently does not support 2 factor authentication.

    Not sure if this helps, but more information is better than none!

  9. System closed this discussion on 22 Nov, 2021 03:00 PM.

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