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.
Show HN: A simple FOSS and self-hosted budgeting app
11–20 of 23 posts
Re: Show HN: A simple FOSS and self-hosted budgeting app
#12Looks nice. I am already very invested in YNAB at this point but this looks impressive. I’ve learned that I need automatic syncing for budgeting, otherwise I slowly give up because inputting transactions from multiple sources can be too time consuming for me. I’ve read that many people are the opposite and rely on manual entry for accountability but in my case a quick glance once or twice a week to reconcile my budgeting tool with spending accounts is all I need.
Re: Show HN: A simple FOSS and self-hosted budgeting app
#13The 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.
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
#14Claiming "self hosted" or "self-hostable" is a bit weird without a Dockerfile being provided, I think. That's not a mean-spirited comment, I just think most people would expect it as it's the standard for relatively quick and easy deployment (in my case for testing).
If you're one of those people you might appreciate the hint that someone has made a Dockerfile, it's just not merged yet.
https://github.com/filipeforattini/ontrack/blob/develop/Dock...
Re: Show HN: A simple FOSS and self-hosted budgeting app
#15Claiming "self hosted" or "self-hostable" is a bit weird without a Dockerfile being provided, I think. That's not a mean-spirited comment, I just think most people would expect it as it's the standard for relatively quick and easy deployment (in my case for testing). If you're one of those people you might appreciate the hint that someone has made a Dockerfile, it's just not merged yet. https://github.com/filipeforat…
To be fair, the README says "can be" self hosted.
Re: Show HN: A simple FOSS and self-hosted budgeting app
#16The 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.
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
#17The 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.
So OFX? https://en.wikipedia.org/wiki/Open_Financial_Exchange
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.
Re: Show HN: A simple FOSS and self-hosted budgeting app
#18I'm using Hledger for my personnal finances. Is there any way to import my ledger to this tool?
I don’t know about hledger but getting out of ledger to YNAB was a royal PITA. Partly because ledger is so flexible because it is based on pure unadulterated double entry accounting, so its csv export is based on an entry per line rather than per transaction and that’s useless for most imports as they assume it’s a one transaction per line and you do splits once imported
Re: Show HN: A simple FOSS and self-hosted budgeting app
#19The 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.
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.
I thought that was Germany-only?
Re: Show HN: A simple FOSS and self-hosted budgeting app
#20I'm using Hledger for my personnal finances. Is there any way to import my ledger to this tool?
It looks like this tool imports bank CSV. You can produce similar CSV with hledger's register command (or aregister, in master). Export one account and one currency at a time. Eg:
$ hledger -f examples/sample.journal reg checking cur:'\$' -O csv
"txnidx","date","code","description","account","amount","total"
"1","2008-01-01","","income","assets:bank:checking","$1","$1"
"2","2008-06-01","","gift","assets:bank:checking","$1","$2"
"3","2008-06-02","","save","assets:bank:checking","$-1","$1"
"5","2008-12-31","","pay off","assets:bank:checking","$-1","0"