What Linux software is good for managing a household budget?
Up to now I enter receipts by hand into a spreadsheet and cross-reference everything to my bank statements. Is there a Linux program that'll let me download a bank statement and then intelligently categorize different entries on my bank statement? Or allow me to manually categorize entries? No spyware or intrusive software.
I have used GNUCash for maybe a decade (sounds impossible to me) but it's actually difficult to get much out of it for all the data one puts in. I'm in the XML data store I think, so maybe the SQL data implementation is better.
The graphs are ok and correctly setting up sub accounts as virtual envelopes within your normal account for your current account allows you to replicate the buckets/envelopes/spaces in, say, Starling bank (UK bank which sells its software to other banks as hussle).
I'm looking to set up something like Actual Budget (server) going forward.
I use Buckets . It's a small 1 person freeware, dev asks for a 30 dollar one time donation but it isn't mandatory. It's based on the software and idealogy of ynab which enshittified several years ago. The learning resources of ynab should be mostly compatible but I haven't looked at it in a while.
It interopts with simplefin, an open source tool that reads your bank transactions and gives read only access to buckets. It costs 10dollars per year to use their servers. It creates some annoying quirks that is mostly the fault of my bank but its passable. The app can also take csv files if you would prefer (which most banks allow you to export).
I manually add receipts from my partner and myself to a CSV file, too. I have a custom R scripts to calculate the monthly contribution. This way we can see who paid more/less each month and needs to componsate.
In the future I want to plot graphs to see how we are affected by inflation over the past years.
Great question I've been wondering the same thing. I've been using a spreadsheet with some fancy lookup sheets for far too long, which results in only one 'category' of expenses ever being tracked.
We use KMyMoney for all our stuff for years now. Very happy with it! It came in very useful when we were considering some big purchases to figure out what we could afford.
It can read Quicken files which most banks support. Those have account numbers inside them, so KMyMoney will automatically recognize which account it should go into if you set enter those numbers when setting up the account in KMyMoney in the first place. Some banks only allow you to export to CSV which is a bit more cumbersome, but KMyMoney supports that too.
It will intelligently categorize statement entries too. If you've set a particular entry as belonging to a certain category once, it will remember that for the next time you import a statement. Then you just confirm.
Those categories are very handy when making the reports to see our spending and income patterns.
I've been using Homebank for years now and I'm very happy with it.
Download transaction data from your bank in QuickBooks format and import it into homebank. Then, you can create auto-categorizing rules for all those recurring purchases, and manually assign a category to the other transactions.
I do this every month and it now takes 10-15min max to go through all my transactions and check/categorize everything, and see some nice customizable charts of where my money's going.
Personally I use ledger for something like this. It's a double-entry accounting system and from what I've heard similar to GnuCash though I haven't used that one.
Parsing and Categorizing of bank statements would probably need to be done manually or with a self-developed script, though maybe there's already something made for that. I haven't looked so far.
Here we run a docker image of Actual Budget. We just need to update it by importing the bank statements and you can create rules that will automatically categorize things, it is great.
Indeed, came to add spreadsheets, e.g. LibreOffice Calc or OnlyOffice on NextCloud if you want it Web based. If it's "good enough" to manage the budget of countries, huge corporations, etc and is taught in schools, it's probably good enough for a household.
I don’t know what people call this, but I’m curious if you also need future balance prediction, basically “here’s how much left over you’re going to have this payday, next payday, etc”. I might switch from my homegrown spreadsheet to one of these recommendations if they also support that.
(I’m talking about something where you input your known scheduled debits and credits, especially for people with biweekly paychecks but monthly debits, and then you match recent actual activity with what’s expected. So you get “current balance is $1800 but it’ll get as low as $300 before you get paid next” type info to keep you from over spending.)