Bug 460131 - Make it possible/easier to open account's web site to download transactions
Summary: Make it possible/easier to open account's web site to download transactions
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: git (master)
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-10-08 18:58 UTC by Jack
Modified: 2022-10-09 17:59 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jack 2022-10-08 18:58:44 UTC
Given the increasing number of institutions discontinuing OFX Direct Connect, KMM should make it easier to use Web Connect, which seems to be what the banks are suggesting.  This means at minimum, an easy way to go to the bank's main web site, or better (if possible,) to go to the page showing activity for that account.

Currently, a web site is only kept for Institutions, not for Accounts.  In addition, there is no hierarchy of institutions, only accounts.  In my case, I have an Institution for Bank of America/Merrill Lynch.  (Even though they are formally separate, one owns the other, so I prefer to group them.)  However, they have separate web sites.  Thus I would like to either be able to store a URL for an Account, or to have a hierarchy for Institutions.  Just using two separate Institutions is certainly an option, but less desirable for me.

For ML, it does not look like there is a URL for activity for a single account, as the account is selected by dropdown - but the URL does not change.  I don't know about other banks, but if possible, it would be desirable to be able to specify that specific URL.
Comment 1 Brendan 2022-10-08 21:17:44 UTC
I think this would help but I have another suggestion, which would make it easier to import OFX files downloaded from multiple banks. The number of manual imports is increasing, thank Chase.

Currently you save the ofx or qfx file somewhere on your system. Then you have to import each saved ofx/qfx file one by one. As the number of accounts that require manual selection increases this becomes a bigger burden.

It would be nice if the process could be included as part of the "Update account" and "Update all accounts" process. This could be done a couple of different ways. A global path where the ofx/qfx files are saved could be set and then all existing ofx/qfx files are imported when you run "Update all accounts". Another option would be to define the path and file name for each ofx/qfx file for each account. This would allow you to update one account with the latest ofx/qfx file or update them all along with accounts that are still available directly from the bank via KMM ofx import.

I can make this a new wishlist item if this makes sense.
Comment 2 Jack 2022-10-08 21:35:07 UTC
You're missing one shortcut.  If you configure your browser to open the OFX or QFX file in KMyMoney directly instead of saving it, you save that step.

The hard part of your request is that I don't believe there is a single URL to use to request the data from a bank, although if there is, THAT is what I would save for each account.  I suppose you could trace the actual packets sent when making such a request to see if you can really craft such a URL  Merrill Lynch lets you distinguish since last statement, this month, last month, ...  At least for Merrill Lynch, I can download for the chosen period for all my accounts at once, but that does not appear the case for Bank of America, and it doesn't help with multiple institutions.
Comment 3 Brendan 2022-10-09 17:41:34 UTC
I'm not sure I have any banks where it is possible (or at least obvious) to get the ofx file directly from a URL. If it was, seems like a way to simulate direct connect so why save the file, just import it.

How does KMM handle an ofx file with multiple accounts in it (your Merrill Lynch accounts)? I've never tried it.

Every bank that I currently download ofx files from manually seems to do things their own way. I have more than one account at some of the banks and have always downloaded them separately. At a credit union, matching is a disaster so I'm always filtering by date to minimize duplicates.

It's for this reason, I'm proposing a way to import all saved ofx files along with any remaining direct connect accounts (or separately, if that's preferred). I assume it will take a fair amount of work to save the files manually but if that can be simplified, that would be even better. I'm not concerned about links to the banks in KMM, I always have one Firefox window open with all of my banks in tabs so getting to the web page is not an issue.

I'm imaging this as an update to the OXF Importer plugin, but I'm not sure how involved that would be. Maybe a new plugin, which would be a simplified version of the OFX Importer. I could see it starting out basic and improving with experience.

I currently have 6 or 7 accounts where I download the ofx file once a month and have to manually import the file to KMM. Now I've added my Chase credit card, Which I will probably import 4 to 6 times a month, basically doubling the number of times I have to go File, Import, OXF, and select the file. Automating just this part would be very helpful.
Comment 4 Jack 2022-10-09 17:59:39 UTC
Importing my ML OFX file with multiple accounts "just works." :-)  If you look into the file, you can see there is a section for each account, so some combination of libofx and KMM know what to do.  The data for each account gets imported into the correct account.

I agree there is a problem with naming downloaded OFX files.  Every bank uses different conventions, some even always using the exact same name for any ofx download.  However, I don't think it should be too hard for the ofx importer to allow pointing to more than one file - it can then just loop through them.  Pending any comments from the developers, I'll considering opening that specific change as a wishlist.

With your last item, if you don't have any reason to save the downloaded file after import, then I again suggest configuring  your browser to directly open the file in kmymoney instead of saving it.  That save the entire File Import/... process.