Self-hosted Personal Finance Suggestions
-
I really want this too. Neither Actual nor Firefly III support stocks/funds (open issues for Actual and for Firefly III.
I use GnuCash for my transactions, which I manually export from my accounts as QFX files. Although GnuCash has support for tracking fund values and generating reports, I do this with a custom Python script and Metabase instead.
-
So that actually doesn't do what I want. It will record buying and selling of securities but only as if it were like making purchases or payments in a credit card or bank account. It doesn't keep track of the value of the security or any other asset. For example, I have a Roth account and it has a couple hundred shares of an index fund in it. Actual will only show that I spent several thousand on that index fund (listing it's name in the notes) but not the number of shares I bought and at what price at the time of purchase. I won't be able to track gains or losses for each security, only as a whole of the entire Roth. Actual doesn't do what I want it to do and I don't know enough TypeScript to contribute.
-
Holy shit. This is both awesome and so overkill that I want to try it.
-
I haven't used it myself so I'm not entirely sure it's what you're looking for, but paisa might be worth looking into.
-
GnuCash will do the sort of security trade accounting you’re talking about. I don’t know how GnuCash compares to the other offerings, but it can be fully offline and has a lot of features.
-
Some of the features you're looking for led me to switch to Quicken a few years ago. It's a legacy desktop app (Quicken Online sucks) and it's not very fast but it is still the gold standard for personal accounting software. I've honestly been happier with it than I was with anything else I've tried.
Thankfully Intuit sold it off so they can't enshitify it anymore.
-
I’ve used Gnucash for investment accounting and market valuation. It’s got plenty of features for tracking personal investments.
-
I think this probably still won’t do what you want, but actual-helpers has a script that will track the balance of an investment account. It won’t track shares or funds separately or anything, but it could maybe be enough if your goal is just net worth tracking?
-
Since no one has addressed the stocks part yet, give ghostfolio a try:
-
Actual Budget is amazing!
-
I spent a lot of time trying to find an open source self hosted tool to replace mint and ended up just moving to Monarch and paying. Honestly it's been a really great experience as if long as you don't mind the annual $50.
-
Oh we finally have a way to sync Actual in North America? Might actually start running it again
-
Ghostfolio looks really neat, thanks! I wonder, can it import data from say Interactive Brokers?
-
One thats under active development but getting more and more insteresting would be https://maybefinance.com/ – a Rails app. It supports investments and stuff which seems rare. For import they appear to double down on Plaid, which appears to also do a Europe thing which was recently added, however CSV is also supported
-
Downloading this
-
I'll check this one out. I don't see any documentation on it so I don't know if they can sync with my banks.
-
I can share the script on GitHub if anyone is interested. Among other things, it converts funds to their value at the time of the transaction and adds additional transactions to reflect capital gains and losses. This allows Metabase to accurately report net worth over time.
-
If you want to track all your wealth with one single tool (bank accounts, stocks, bonds, funds, properties...) I would recommend plain text accounting tools suchs as ledger-cli, hledger or beancount. I began with ledger-cli and move later to hledger.
You will learn a lot of double entry accounting and you will keep accounts with plain text files with version control.
It is a rabbit hole...
-
at least the recent (non-release) docker image should have plaid support for that. It appears to require a few environment variables. Have not yet "plaid" with that but might do so soon.
Oh and for stocks, it is bound to their Synth thing, 1K request are free per month (not all of my etfs are listed atm tho). The synth api key also goes into the env. (which confuses me right now as it also is an input field in the app, dunno but works)
