4 ms·

I use and love ledger-cli but importing/downloading bank data is the biggest pain point. I'm currently using ledger-autosync (https://github.com/egh/ledger-aut

I use and love ledger-cli but importing/downloading bank data is the biggest pain point. I'm currently using ledger-autosync (https://github.com/egh/ledger-autosync https://github.com/egh/ledger-autosync) to import OFX/QFX files. For some banks it can automatically pull the data using ofxclient (https://github.com/captin411/ofxclient https://github.com/captin411/ofxclient) but for most of my bank accounts this is broken and I need to manually download the OFX file before importing with ledger-autosync. It works OK, I wish I didn't have to do the manual download, but the simplicity of the setup is nice. I've read of other setups using Plaid or Puppeteer to download their data. Would be interested to hear about what other people are currently using in mid-late 2019 to pull their financial data.

0xdeadbeefbabe 7y ago
I'd rather do it manually. It's a feature. I really like the double entry journal.
egh 7y ago
Glad you like ledger-autosync! I agree, its very annoying to have to download OFX files. I wish more banks supported the OFX protocol, or really any sort of automated download. I should probably look into plaid and see if it might work.
BeetleB 7y ago
My ledger workflow is rather different. I use KMyMoney to enter transactions (or download). And I have a script to export all that to Ledger format.
- smichael 7y ago
  Could you blog about/link to that ? It sounds smart.
  - BeetleB 7y ago
    Yes, but likely only when I'm very reliant on it. As it is, it's very ad hoc and buggy. To be frank, I spend 90+% of my time in KMyMoney. I need Ledger only for its virtual transaction features (for budgeting). The other use case I have for ledger is to perform some analyses/reports in it that KMyMoney doesn't provide. There's nothing "smart" about it. It's simply a script that takes in a kmy file and creates a valid Ledger file. It's been a while since I looked at it, but at the moment I doubt it handles things like stocks and commodities, etc. Still, I'd rather use KMyMoney to enter transactions than using the Emacs mode for Ledger.
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 ago
  Maybe use something like moneydance? It talks directly to the financial sites to grab ofx and is extensible via plugins.
  - smichael 7y ago
    I believe many banks in the US don’t provide OFX, or not easily. Wells Fargo would charge me $10/month for it.
    - js2 7y ago
      That's insane. I'd change banks over something like that. FWIW, USAA, Ally, Fidelity, AmEx, Chase, no charge for OFX.
      - synesthesiam 7y ago
        This 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.

0xdeadbeefbabe 7y ago

I'd rather do it manually. It's a feature. I really like the double entry journal.

egh 7y ago

Glad you like ledger-autosync! I agree, its very annoying to have to download OFX files. I wish more banks supported the OFX protocol, or really any sort of automated download. I should probably look into plaid and see if it might work.

BeetleB 7y ago

My ledger workflow is rather different. I use KMyMoney to enter transactions (or download). And I have a script to export all that to Ledger format.

smichael 7y ago
Could you blog about/link to that ? It sounds smart.
- BeetleB 7y ago
  Yes, but likely only when I'm very reliant on it. As it is, it's very ad hoc and buggy. To be frank, I spend 90+% of my time in KMyMoney. I need Ledger only for its virtual transaction features (for budgeting). The other use case I have for ledger is to perform some analyses/reports in it that KMyMoney doesn't provide. There's nothing "smart" about it. It's simply a script that takes in a kmy file and creates a valid Ledger file. It's been a while since I looked at it, but at the moment I doubt it handles things like stocks and commodities, etc. Still, I'd rather use KMyMoney to enter transactions than using the Emacs mode for Ledger.

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 ago
Maybe use something like moneydance? It talks directly to the financial sites to grab ofx and is extensible via plugins.
- smichael 7y ago
  I believe many banks in the US don’t provide OFX, or not easily. Wells Fargo would charge me $10/month for it.
  - js2 7y ago
    That's insane. I'd change banks over something like that. FWIW, USAA, Ally, Fidelity, AmEx, Chase, no charge for OFX.
    - synesthesiam 7y ago
      This 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.