this post was submitted on 20 Dec 2024
65 points (98.5% liked)

Linux

48663 readers
557 users here now

From Wikipedia, the free encyclopedia

Linux is a family of open source Unix-like operating systems based on the Linux kernel, an operating system kernel first released on September 17, 1991 by Linus Torvalds. Linux is typically packaged in a Linux distribution (or distro for short).

Distributions include the Linux kernel and supporting system software and libraries, many of which are provided by the GNU Project. Many Linux distributions use the word "Linux" in their name, but the Free Software Foundation uses the name GNU/Linux to emphasize the importance of GNU software, causing some controversy.

Rules

Related Communities

Community icon by Alpár-Etele Méder, licensed under CC BY 3.0

founded 5 years ago
MODERATORS
 

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.

top 22 comments
sorted by: hot top controversial new old
[–] [email protected] 3 points 17 hours ago* (last edited 17 hours ago)

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).

[–] [email protected] 5 points 20 hours ago* (last edited 20 hours ago)

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.

[–] [email protected] 4 points 20 hours ago

I use firefly-iii. You can setup rules and import from csv files. I even have it integrated with enablebanking so it is fully automatic.

There are also mobile apps that will work with your own server.

[–] [email protected] 2 points 17 hours ago

MoneyManager EX. It is the closest FOSS application I've seen to Quicken. Imports bank statements, catagorize different expenses, monthly budgets . .

https://moneymanagerex.org/

Linux, Windows, Android, iOS versions all available.

[–] [email protected] 5 points 22 hours ago

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.

[–] [email protected] 1 points 18 hours ago (1 children)

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.

[–] [email protected] 2 points 13 hours ago

If you're willing to use a web app and pay $50 a year. Monarch has been incredible for me.

[–] [email protected] 22 points 1 day ago (1 children)

Here are your choices to try out yourself and see if they can do what you need:

  • GnuCash (distro support, flatpak)
  • HomeBank (distro support)
  • KMyMoney (distro support, appimage, flatpak)
  • ActualBudget ( https://actualbudget.org/ , appimage, flatpak)
  • Denaro (the newest on the block with modern UI, flatpak)

And for Android:

  • IvyWallet
[–] [email protected] 3 points 21 hours ago

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.

Anyway, I highly recommend it.

[–] Flaqueman 12 points 1 day ago (1 children)

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.

[–] [email protected] 1 points 14 hours ago

I also use Homebank, and it’s more than enough for my needs as a single guy

[–] [email protected] 6 points 1 day ago

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.

[–] [email protected] 8 points 1 day ago (1 children)

I heard ActualBudget can do this, but less a software but a server.

[–] [email protected] 3 points 1 day ago

Actual Budget is software. It can be run on a home server if desired.

[–] [email protected] 8 points 1 day ago

GNU Cash may satisfy at least some of your requirements.

[–] [email protected] 7 points 1 day ago (1 children)

If you are not indimidated by selfhosting, then definitely give Firefly III a try.

[–] [email protected] 2 points 19 hours ago

Second this! I like the interface. Especially useful for euro banks where you can auto sync.

[–] [email protected] 5 points 1 day ago (1 children)

You should be able to do all that stuff with spreadsheets. Any program you use will be a spreadsheet under the hood anyhow.

[–] [email protected] 1 points 19 hours ago

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.

[–] [email protected] 5 points 1 day ago* (last edited 1 day ago)

i tried GnuCash, but i didn't find it very useful.

there's also Homebank & KMyMoney; i haven't tried either.

i doubt any will auto import statements, so there's work to be done there.

[–] [email protected] 4 points 1 day ago

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.)

[–] sentient_loom -1 points 1 day ago