We do excel roughly but invest our surplus.
I have a bunch of we scrapers that check for items on sale and for certain ones trigger purchase and others send me an alert.
this post was submitted on 03 Dec 2024
70 points (93.8% liked)
Selfhosted
41084 readers
291 users here now
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
-
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
Resources:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
founded 2 years ago
MODERATORS
Firefly III
Amazing, really hit's the spot of fully featured but a tool and not a new system you need to learn
GnuCash running locally on my PC. Had worked for me for about 25 years.
Same here but now struggling to keep on top of it. I wish there was a mobile solution that would just nicely integrate with selfhosted
I use GnuCash. I typically update every couple weeks up to a month. Beyond that it can be hard to remember what specific transactions were.
It's double ledger and I really like that it forces strict accounting. That sounds cumbersome but once you're set up (it may take some trial and error), for me my workflow is essentially:
- Copy prior paycheck splits & update them to reflect new paychecks.
- export QFX files from credit cards
- import QFX, check / set transaction accounts
- any small manual updates (interest payments in accounts, etc)
It's not automated but my data always remains local, and I can use the Linux or android application. I don't bother daily tracking on my phone, else it might be cumbersome. I've never used any of the budget features, just tracking where my money comes and goes.
Weird question, but what does GnuCash do that you wouldn't get easily from excel? I haven't used any of these apps and wondering what I'm missing out on.
Under the hood its mostly tables and reports, so ultimately not much, if you were dedicated enough to using Excel to rebuild GnuCash's views. It's more streamlined than excel would be because you won't have to worry about implementation, overhead of adding a new account, etc. Some things like auto-recommending accounts during import (and import itself) could be arduous in excel if not supported natively. Split transactions could be a headache (think your paycheck, which might be split into 401k contributions, several taxes, money into your bank, etc).
But fully recreating it in excel when it already exists would be a headache. More than likely you will have a more limited view in Excel if you're just creating a handful of tables to represent all of your many accounts.
I have a excel sheet on my laptop
I'm saying this as someone who used Mint for years due to how it integrated with banks so easily.
I'm currently using Money Manager EX, which is open source. I "self-host" the database file on my NAS, and simply open the file through MM EX' Windows program.
Since it's just a simple database (encrypted, of course), it's easy to back up.
Now, I lost the ability to automatically sync with my bank. This was a blessing in disguise, since it forced me to go over each transaction carefully.
Granted, Mint had me doing the same, but because I spent a lot of time removing duplicates and fixing errors in their sync system. LOL
MM Ex has been very easy to use, and I don't see a need to self-host the software itself.
Actual Budget, because it supports SimpleFIN to import my transactions.
It's still not "automated," but I have a lot of rules now so it's getting there.
I'm not super happy w/ how it works, but I'm too lazy to do anything about it. Maybe I'll end up adding SimpleFIN to something else, idk.
I use ledger. I have not automated so much outside of autocomplete macros in my text editor, but it doesnt't take too much time and forces me to look over my spend, so I like it. I will eventually attempt to build some kind of Dash-application for visualisation of the output, but have only started on the parsers so far.
Ledger is awesome.
Gnucash books split for personal, joint, and business with a mysql backend. I wrote a read-only web frontend for wife and OTG access. Sadly no automation so I just stay on top of it.
Actual Budget all the way
Is there some tutorial you'd recommend to get started? I didn't find the docs or demo helpful and a lot of videos seem to be focused on background or setup. I can install the app fine, but like how does one actually use this?
I've never used budgeting apps. I'd like to learn more about them and why they're useful. My current budgeting is: positive balance=good; negative balance=bad
They have an excelent documentation for new starters. https://actualbudget.org/docs/getting-started/roadmap-for-new-users
That link kinda showcases exactly my point... It's pretty useless to me. I know how to install the app. I don't know what the daily workflow looks like.
Compare that to the tutorials YNAB has on YouTube. Those talk more about how to use the app to budget.
Anyway, it's fine. I understand I'm not the target audience for Actual. It seems like it's for people who already have prior experience with finance apps.
Hehehe hold on. Just try it and fins your own way to use it. You never know what you can find out. I can give you my experience, my only past experience was with Excel files to control my spending. It was pretty enough to be honest , at first when tried this app I was like ok why I need to do all this job of put every spending ... Then after two month I realized that mechanical doing so made more aware of my day by day spending and my month budget became better. It's just that, helps to be aware of what you are doing every months and it feels good filling it every 2 or 3 days. And also having all visualized and granular of were are doing it wrong or what can be adjusted is excellent .
As a note for people new to budgeting apps, YNAB has a toooonnn of tutorials and videos about how to create a budget and what the end-to-end workflow looks like in their apps.
I switched over to Actual last month, and am not looking back. I will miss the native android app, but it is an otherwise direct replacement. I was using YNAB4, and had forever.
view more: next ›