cross-posted from: https://eviltoast.org/post/14412290

I’ve been really lazy with keeping track of my money over the last few years. I still use personal capital (now empower)'s dashboard, but it’s not self-hosted and they can be pretty aggressive with their marketing.

Previously, I was using Beancount + Fava to track all of my money, including investments. Every time I think about updating my ledger and importing the last several years of transactions, it just feels overwhelming and I put it off again.

I’m still a fan of plain-text-accounting, but importing a large number of transactions always feels cumbersome.

I tried Firefly-III briefly, but it didn’t support investment tracking. I also saw Ghostfolio for the investment side, but haven’t tried it yet and it seems to only do investments.

My wishlist of features is below, are there any self-hosted/oss finance apps that would meet most of these?

  • self-hosted
  • import via csv at minimum, ideally support for yodly/plaid/some other bank syncing api
  • support for regular accounts (checking/savings), credit cards, and investment accounts (stocks, 401k, etc)
  • misc. asset tracking like for a car or house
  • mobile app or mobile-friendly web view
  • local llm support for categorizing transactions and fixing merchant semi-automatically
  • multi-user support - not required, but it’d be nice if my partner and I can use the same app but still have our own private accounts too
  • tags or some other way to group expenses together (like all expenses related to a trip)
  • good reporting
  • bonus: support for custom reports/calculations like “If i retired next year, how much money would I have per month?”

Alternatively, what do you all use for this type of thing?

  • lemmy@lemmy.technowizardry.net
    link
    fedilink
    English
    arrow-up
    2
    ·
    14 hours ago

    I’m currently using firefly-iii + Ghostfolio simultaneously. I’m not really a fan of this approach because Firefly-iii shows the wrong net worth without my investments and Ghostfolio doesn’t handle tax lots correctly. The Firefly-iii importer was terrible and created a mess of my transaction history too because I tried to import data from Mint going back a decade. I ended up writing my own Python-based analyzer to clean-up the data to get it imported. Now I just use those tools for visualization until I find alternatives.

    Plaid didn’t work because I couldn’t use OAuth to banks without going through compliance reviews (not sure if that has changed.) I instead focused on building scraping tools to pull directly from banks or my bank aggregator, Monarch (I use this when I couldn’t directly scrape from a bank due to auth issues.) I had to build Playwright scripts to scrape website and it’s all very janky code, but it technically works. Some of that has been open-sourced, the actual scrapers need to be cleaned up.

  • Colloidal@programming.dev
    link
    fedilink
    English
    arrow-up
    4
    ·
    17 hours ago

    I use GNUCash with the file on a NAS. I’ve been using GC for over 20 years, I just don’t see myself changing soon.

    • johntash@eviltoast.orgOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      15 hours ago

      Have you tried any of the other options by any chance? Anything that GNUCash does well that keeps you using it? I think not having mobile access would be the thing I’d miss the most

      • Colloidal@programming.dev
        link
        fedilink
        English
        arrow-up
        2
        ·
        14 hours ago

        When I started, it was only GNUCash as a free option. Never tried anything else. It fits my needs as a family very well.

        There’s no mobile or web access, and that’s fine for me. Updating it is something done once a week or less for me anyway.

        I manage mortgage, virtual account for kids allowances, budget for future expenditures, and have a set of reports that I refresh to keep tabs on my money and goals.

    • astrsk@fedia.io
      link
      fedilink
      arrow-up
      8
      ·
      1 day ago

      I love Actual. It’s fantastic and easy to use. I use off-budget accounts and weekly / monthly reconciliation just to keep the general value of these accounts at stable intervals.

      I have a slight bone to pick with the PWA version of the site though. After a couple months of using the PWA front end to keep my budget and transactions accurate manually, I opened the site on my desktop browser and it completely lost all that work due to a sync issue. Apparently the PWA for weeks had not remained in sync and so all manual entries were not making back to the server. But the app works so well I never noticed because it kept just working. Supposedly there’s an alert saying it’s not synced with the server but it’s not prominent enough. So if you use that feature (the PWA) then be sure it’s syncing often.

    • johntash@eviltoast.orgOP
      link
      fedilink
      English
      arrow-up
      3
      ·
      24 hours ago

      I tried Actual before, but I don’t remember what I didn’t like about it. I’ll take another look at it. The budgeting part does remind me of YNAB.

  • nelson@lemmy.world
    link
    fedilink
    English
    arrow-up
    7
    ·
    edit-2
    23 hours ago

    Maybe one of these is interesting? I have no actual experience with them though:

    https://actualbudget.org/

    https://github.com/DumbWareio/DumbBudget

    https://maybefinance.com/

    https://paisa.fyi/

    They should all be self-hostable.

    Edit: I don’t know of these all match your criteria. Maybe finance looks pretty Sleek imho. I just dread the thought of exporting my transactions and importing them because my bank is forking horrible w.r.t. integrations.

    And logging in every time to do a CSV export is just annoying.

    Edit 2: formatting

    • johntash@eviltoast.orgOP
      link
      fedilink
      English
      arrow-up
      3
      ·
      24 hours ago

      Oh wow, Maybe does look pretty slick and covers most of what I want. It looks like it supports importing transactions automatically (without csv files?) but I don’t see much about how that’s configured for hte self-hosted version yet. I’ll definitely try it out.

      Paisa looks pretty nice too. I might try it if I can import/convert my old beancount ledger files into it.

      • Uninvited Guest@lemmy.ca
        link
        fedilink
        English
        arrow-up
        4
        ·
        edit-2
        20 hours ago

        I tried out a whole bunch of these recently, and think I will be landing on Actual Budget due to the ease of use.

        Maybe is the slickest looking, but it is on of the most cumbersome in terms of tagging/categorizing transactions.

        I tried:

        • Actual Budget
        • Firefly III
        • Maybe
        • WYGIWYH
        • johntash@eviltoast.orgOP
          link
          fedilink
          English
          arrow-up
          1
          ·
          15 hours ago

          What was cumbersome around tagging/categorizing in Maybe? I’m probably going to have to install all of the ones I’m interested in at the same time to test them side by side

          • Uninvited Guest@lemmy.ca
            link
            fedilink
            English
            arrow-up
            1
            ·
            14 hours ago

            From what I recall, it is buried behind multiple clicks - click in to the transaction, click in to another section, perform the operations you want, go back to the transaction list, etc

  • This2ShallPass@lemmy.world
    link
    fedilink
    English
    arrow-up
    7
    ·
    1 day ago

    Firefly III is an option, but I found it difficult to set up and the importer tool works well for Europe but not the US.

    You could also just create your own Docker container which has Skrooge, GnuCash, or KMyMoney in it. I have done this with Skrooge since it imports data well and is simpler than GnuCash.

    With the Linuxserver.io KasmVNC base image and install any GUI application to run it from a browser.

    • johntash@eviltoast.orgOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 day ago

      I haven’t seen skrooge before, thanks. I was looking for a web app but I guess that isn’t really a hard requirement. I did try gnucash before and didn’t spend enough time learning how to use it. If skrooge is simpler, I’ll try it out.

      Kasmvnc looks really cool too even if I don’t use it for this.

    • johntash@eviltoast.orgOP
      link
      fedilink
      English
      arrow-up
      2
      ·
      1 day ago

      I’m pretty sure i read that the dev didn’t want to add support for investment tracking.

      I didn’t realize it has plug-ins though, I might give it another shot. Worst case I could use it for everything except investments and find something else for the rest…

      Do you add transactions manually or import them somehow?