3 ms·
I have a google sheet with an attached form. I then use simple queries to retrieve the data. For example, I have a sheet that displays the expenses per category
by YuukiRey 8y ago
I have a google sheet with an attached form. I then use simple queries to retrieve the data. For example, I have a sheet that displays the expenses per category (food, holidays, etc.) for the current month and also shows me the % of my income I have spent.
I added a few lines of Javascript which are run on what is probably a rough equivalent of a cronjob. They just check if it's the first of the month and if so append my current, recurring, monthly expenses to the form.
This is a simple and pragmatic approach where I can leverage the data analysis tools of google sheets (charts and stuff), access and add my data from everywhere and not have to implement anything myself.
I also use that to track what I buy for me and my GF so that we can eventually reimburse each other for shared purchases (mainly food). We could also get a shared account but so far it's been working really well.
If I am interested in my overall net worth I just log into my bank account and check out how much money I have and what my ETFs are doing.
The form is pretty simple: Amount, category, name, comment and then choose if it's both (me and my GF), I O (see comment for whom I am owing money).