Re:Show HN: A simple FOSS and self-hosted budgeting app
by bantunes on Saturday August 08, 2020 @06:37AM
(#24090548)
The biggest hurdle for me with these tools is CSV import - banks are so crappy with them. If only we had a universal banking API system that all these tools could tap into. "Challenger" banks like Monzo and N26 and so on could unite behind a form of OAuth for banks that would kick ass.
[ Parent
| on HN ]
Re:Show HN: A simple FOSS and self-hosted budgeting app
by xupybd on Saturday August 08, 2020 @07:13AM
(#24090702)
And an open standard for digital receipts. If I could get a record of what I purchased at the store it would be amazing.
Re:Show HN: A simple FOSS and self-hosted budgeting app
by Gasp0de on Saturday August 08, 2020 @06:44AM
(#24090571)
I don't know about other areas, but in Europe there is such a standard (called FinTS) and there are libraries for every language. I actually once wrote a python tool that did something similar to this app.
Re:Show HN: A simple FOSS and self-hosted budgeting app
by breakingcups on Sunday August 09, 2020 @06:17AM
(#24098559)
I thought that was Germany-only?
Re:Show HN: A simple FOSS and self-hosted budgeting app
by inoda on Saturday August 08, 2020 @11:50AM
(#24092539)
I feel ya. I wrote a script to reformat my bank's CSV export to make it easier to work with for OnTrack [0]. I imagine it wouldn't take too much work to write a script that reformats and combines multiple sources.
0: https://github.com/inoda/ontrack/blob/master/lib/csv_helper....
Re:Show HN: A simple FOSS and self-hosted budgeting app
by os7borne on Saturday August 08, 2020 @09:22AM
(#24091451)
I'm guessing the reason these universal API's don't exist is because there would be no business model and hence no billion dollar companies. However, Europe's PSD2 regulation was essentially launched to establish these open API's for banking
Re:Show HN: A simple FOSS and self-hosted budgeting app
by cube00 on Saturday August 08, 2020 @10:28AM
(#24091841)
I watched a bank CEO claim the security of their customer's data was the reason it was tightly controlled and API access was only available to their trusted partners for the purposes of running credit checks and other things that make the bank's own life easier. They also followed that up with a spiel about how open to competition they are.
Re:Show HN: A simple FOSS and self-hosted budgeting app
by P4wl0w on Sunday August 09, 2020 @05:03AM
(#24098317)
If N26 is an important part of this I will not use it.
They have a track record of handling security in a way that would cause nightmares for me if I had an account there.
Edit:
We could solve the CSV import/export issues with templates for each bank until there is a usable standard maybe.
Re:Show HN: A simple FOSS and self-hosted budgeting app
by reubano on Sunday August 09, 2020 @10:16PM
(#24104828)
You may find https://github.com/reubano/csv2ofx useful. It coverts csv files to qif and ofx. It has built in support for numerous banks, and can be easily customized to parse unsupported csv formats.
Re:Show HN: A simple FOSS and self-hosted budgeting app
by quickthrower2 on Sunday August 09, 2020 @05:49AM
(#24098461)
Yep OFX imports to YNAB classic work fine for me. QIF too and indeed CSV. Whatever code they use to import is pretty robust I guess.