logoalt Hacker News

abdullahkhalidstoday at 1:55 PM4 repliesview on HN

I would like to use finance tracking products like GNUCash. But I don't have the patience to download the csv for half a dozen accounts every month (Products like plaid are a no go from a basic security perspective). I am in Canada, and there seems to be no hope that I will have API access to my bank accounts anytime soon.

Also, did I mention how much it annoys me that the transaction description differs between the CSV and the PDF statement for pretty much all banks I use.


Replies

bregmatoday at 2:57 PM

Well, there is legislation before Committee to mandate open APIs that any accredited institution can use. As a consumer you will not be eligible, but you will be allowed to pay some third-party to pull your data from your bank and save it in their database, after which maybe they might allow you to download it in their proprietary format should they choose.

Me, I use plain-text accounting (hledger) that automatically imports the CSVs from my bank and categorizes transactions automatically, and I wrote some quick scripts using Python to import the PDFs from my brokerages and paystubs. It's not automated pulls but I only have a handful of accounts so it's really not a pain to manually pull statements once a month and run the import scripts. It takes me longer to reconcile everything to the penny then it does to do the imports, and it's a whale of a lot faster than manually entering through GNUCash. Plus, it's plain text so all you need is vim, git, and the command line.

show 2 replies
vsviridovtoday at 2:43 PM

I'm using self-hosted Sure.am and also using SimpleFin to connect to Canadian banks. It works, but barely, since it effectively scrapes with no real API access. I have to login daily to update 2-FA on various accounts, and have suffered account lockouts a couple of times, due to "suspicious activity".

But it still beats downloading multiple exports from the bank and importing it manually...

vitalikpietoday at 2:00 PM

Agree. I wish banks have their APIs open. It's 2026 and we have OIDC.

But I used to actually pull the CSV once a week and feed it to GnuCash. It's pretty good at auto-categorization.

Also I simplified my finances to only a couple of checking accounts and only one credit account (for car rentals).

show 1 reply
phyzix5761today at 2:02 PM

I simplified to just 2 accounts and I enter them manually twice a week. I keep a detailed budget so it helps to do it that frequently.

show 1 reply