3 ms·
I was using Tiller (https://www.tillerhq.com https://www.tillerhq.com), pulling from US and European banks to a Google sheet, then a command line tool to pull C
by smichael 7y ago
I was using Tiller (https://www.tillerhq.com https://www.tillerhq.com), pulling from US and European banks to a Google sheet, then a command line tool to pull CSV from there. This worked well except for not handling foreign currency (it calls everything $), adding a bit of extra latency/uncertainty on top of the back end (Yodlee), and eventually forgetting to update your sheet unless you manually visit it every so often.
Currently I’m using plaid2qif (https://github.com/ebridges/plaid2qif https://github.com/ebridges/plaid2qif) to pull CSV from US banks via Plaid’s (https://plaid.com https://plaid.com) API. This is more developer friendly and gets the latest data to me faster, but the data is not quite as good as Tiller/Yodlee’s, at least for Wells Fargo bank; Plaid gives more truncated transaction descriptions.
Both of these have the big downside of sharing your bank credentials with others. With Plaid I guess there’s one less party involved. My current alternative is manually visit each bank’s site and download CSV. Ideally I want to get timely data every day (the easiest way to stay on top of the books), so the manual downloading (click, wait, click, relogin after timeout..., wait, wait for paypal’s download, retry when it gets stuck..) gets really tiresome.
- js2 7y agoMaybe use something like moneydance? It talks directly to the financial sites to grab ofx and is extensible via plugins.
- smichael 7y agoI believe many banks in the US don’t provide OFX, or not easily. Wells Fargo would charge me $10/month for it.
- js2 7y agoThat's insane. I'd change banks over something like that. FWIW, USAA, Ally, Fidelity, AmEx, Chase, no charge for OFX.
- synesthesiam 7y agoThis page suggests that it's actually $3/mo: https://www.wellsfargo.com/online-banking/software/fees https://www.wellsfargo.com/online-banking/software/fees However, I've been pulling OFX data from my Wells Fargo for years via AqBanking (https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect) and have never been charged.