Hello everyone.

Currently me and my GF have our finances organized in a Google sheet file (hosted on Google drive), being that file integrated with a Google form.

What we do is having on our cellphones a shortcut to the form, where we input all our expenses, they are directly and automatically registered in the sheet, and on another tab we’ve built some sort of dashboard based on all the values the form registers.

So given this context, is there any option or group of options that are open source, and that achieve this same purpose / scenario?

If possible everything acessible on a cloud or at least onlinez so we don’t lose this flexibility and accessibility on our cellphones.

Thanks in advance

    • Erunn@lemdro.idOP
      link
      fedilink
      English
      arrow-up
      6
      ·
      1 year ago

      Hmm I’ve found some comments over the internet about it, but I must confess self-hosting is not yet for me, since I’m a newbie still :(

      Any other alternative or guide you can recommend ?

      Thanks in advance again

      • lckdscl [they/them]@whiskers.bim.boats
        link
        fedilink
        English
        arrow-up
        5
        ·
        1 year ago

        If you want some cloud syncing but also want privacy, then you will have to self-host, or pay someone to do it for you. There are some free tier Nextcloud accounts, but quite limited in storage. Disroot is one of them. If you do end up self-hosting, there are really good budgeting stacks out there:

        https://awesome-selfhosted.net/tags/money-budgeting–management.html

        My partner and I use Actual budget, and I can recommend it.

        For any of these services, you don’t even have to have a server running 24/7 if you don’t add transactions live. If you do it once a day, just boot up the Docker container, store your stuff, and go about your day. But if you want constant access, you’d have to leave the server running all the time, and to access from the public network, then I recommend Tailscale.

        • gaael@beehaw.org
          link
          fedilink
          arrow-up
          2
          ·
          1 year ago

          Cryptpad is great but I don’t think it entirely fits OP’s requirements :

          • it’s really private
          • it’s in the cloud, so no self hosting is necessary
          • they have a spreadsheet and a form app

          However, last I checked, there was no way to automatically get the form answers in an already existing spreadsheet.

      • MiddledAgedGuy@beehaw.org
        link
        fedilink
        arrow-up
        1
        ·
        1 year ago

        I used to host my own nextcloud instance. It takes a bit of effort to setup and requires some maintenance. As far as self hosting goes I would grade it as easy to do. So if you like a Dropbox style option and want to try it out, you should.

        But honestly I’m here to steer you towards syncthing if you go the file sync + libreoffice (or whatever) path. Once I found out about it I switched, and am happy I did.

  • flatbield@beehaw.org
    link
    fedilink
    English
    arrow-up
    5
    ·
    1 year ago

    You could just use Libreoffice/Colabora Office App and sync however. If you want it encrypted then it would need to be an e2e service. Syncthing, Proton Drive, Treaserit, or just Cypomator in front of Drive.

  • Many Shapes@beehaw.org
    link
    fedilink
    arrow-up
    4
    ·
    1 year ago

    Cryptpad.fr offers spreadsheets and up to 1gb free storage, and if i recall right theyre using foss. Im unsure about the dashboard youve mentioned, but id hazard a guess that you can perform automatic calculations based upon cells in the spreadsheet, to for example sum all expenses.

  • DogMuffins@discuss.tchncs.de
    link
    fedilink
    English
    arrow-up
    4
    ·
    1 year ago

    Syncthing and maybe pro expense.

    I’ve never used pro expense, I just searched f-droid for “finance” and looked for something using local storage.

    You probably need to acknowledge that whatever you find isn’t going to be a 1 for 1 replacement for your current workflow.

    , and something like “pro expense”

  • sounddrill@lemmy.antemeridiem.xyz
    link
    fedilink
    English
    arrow-up
    3
    ·
    1 year ago

    For forms, make a simple wordpress site with contact form 7

    I use oci free tier but whatever goes(that supports php hosting, preferably a lamp or xamp stack)

  • jlow (he/him)@beehaw.org
    link
    fedilink
    arrow-up
    1
    ·
    1 year ago

    Mmmh, it’s difficult. I personally would look into hosted Nextcloud services that have an office suite enabled.

    We used https://windcloud.de/produkte/managed-nextcloud (German company / website)

    a while ago but only for (large amounts) of data storage, not sure if they do office.

    Also I’m unsure about Nextcloud’s encryption, this says it’s encrypted during transport (https 🤷‍♀️ which I would close the tab immediately if they didn’t do that) and that their disks are encrypted locally. I think what they’re saying is that they’re not using Nextcloud’s encryption feature, not sure if that’s good or bad since it might be that it’s terrible …