this post was submitted on 27 Aug 2023
33 points (100.0% liked)

Free and Open Source Software

17926 readers
47 users here now

If it's free and open source and it's also software, it can be discussed here. Subcommunity of Technology.


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS
 

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

all 12 comments
sorted by: hot top controversial new old
[–] [email protected] 7 points 1 year ago (1 children)

I use Nextcloud + OnlyOffice, both self-hosted.

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

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

[–] [email protected] 5 points 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.

[–] [email protected] 1 points 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.

[–] [email protected] 5 points 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.

[–] [email protected] 4 points 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.

[–] [email protected] 4 points 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"

[–] [email protected] 3 points 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)

[–] [email protected] 2 points 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 ...

[–] [email protected] 1 points 1 year ago

GetGrist.com