gnucash i spent money and profits increased

#Gnucash i spent money and profits increased how to
#Gnucash i spent money and profits increased download

So, right now, it’s mostly timeseries of categories (each category goes into a 3-tiers, for plotting purpose). That is where I saw that we were spending way too much on grocery! My aim was to get an idea of how much money was associated with each category.

Well, the analysis part is rather simple right now. And future is of course for prognosis, predictions, saving goals etc… Present is how I’m holding up my set budget, like how much money I have left to spend in the say Coffee category. Where past is a time-series plots of how it’s been going per category etc. My dream is to have a past, present, and future reports. It would be useful to know what stats you’re using. I have predefined like 26 categories that I have a lookup table for (so I just input the number and it gets the correct sub/category).Īnd that’s where I’m at now. if not, ask the user for the correct category (I’m using googler to get some extra info about the expense to help me remember what it was about).check if the cleaned comment of each expense is already in the Dict (you were describing) and get its associated category.read the content and clean it up a bit (e.g.

#Gnucash i spent money and profits increased download

manually download the csv and xlsx files from my (and my partner’s) bank.I’ve been working on this on and off since a few days now and you’re (more or less) describing what I’ve got up to now.

#Gnucash i spent money and profits increased how to

This table will then be used to create a key to categorize future expenses.Ī whole separate discussion might be how to best use this data (say a thousand comment => category pairs) to best automatically categorize never-before-encountered expenses (key words, small variations of the same comment, some other higher order associations, etc).Īwesome. That would be awesome, cause then I can just scroll down the table and choose a fitting category for each bank comment. | SKANETRAFIKEN, MALMO C |Expense:Transport:Public| | ICA SUPERMARKET SODER, MALMO|Expense:Food:Groceires | The initial value of each row in the category column can be missing or a Uncategorized category (whichever). The possible values a category can have are finite and come from a list of predefined categories. The table will have two columns, one column for the comments, and one for the categories. Having a table with unique (cleaned up) bank comments and associated categories. You know what falling short on my hopes for a more global solution with linking bank comments to businesses to categories, an awesome solution for now would be: I mean, we’ve managed to do something very similar with music and genres, why not with expenses and categories? It will be impossible to get everyone to agree on what categories should exist, or which business should be associated with which categories, but something is better than nothing.

The labels in #3 come from some community curated list of hierarchal categories, something like: expense

A list of categorization labels that business is associated with.

The comment (String) banks stick on each expense they register on our personal accounts.

It would be awesome to some how link these 3 entities:

What this makes me realize is that none of those programs has really solved the problem of categorizing the expenses. If there is no need for it to be more complicated it’ll stay at it’s simple status. I agree that it would be a lot more complicated. And more importantly, I am not sure Julia has a competitive advantage there. Recreating anything more complicated, approaching the tools you linked, is a significant undertaking.