Live data from Hacker News

Simple Personal Finance Tracking with GnuCash

csun.io

301–310 of 323 posts

Re: Simple Personal Finance Tracking with GnuCash

#301
post #140

Earlier quoted context omitted.

I know you're not asking directly for advice, but if you'd be interested, I find the following is the easiest way of keeping a budget. 0. Forget about tracking things down to the dollar, or even the tens of dollars. That level of precision is unnecessary. If a coffee here or there is going to break your budget, it's already broken and you need to go in to panic mode. 1. Have a spreadsheet with vague monthly costs lik…

some years back I started working on an app to track finances in that kind of way. No micro-management, just macro-management of budgets and categories. It would also forecast considering past data and future predictions and see where you would attain goals or go broke! :) I should get back to it sometime

I like the idea, but I would be wary of it for this reason: the people who would like to use it are probably the most miserly members of /r/personalfinance. The kind who are likely to quibble about the $8/mo plan compared to the $9.50/mo plan. Basically the worst customers you can imagine.

That said, let me know if you do it!

Re: Simple Personal Finance Tracking with GnuCash

#302

Earlier quoted context omitted.

Wow, your setup sounds very similar to what I've converged on. Except I wrote a fairly substantial pipeline that preprocesses the data before giving it to beancount and Fava. Maybe I missed something, but it seemed like beancount wants everything to live in One Giant Journal file. I really wanted a pipeline where each bank statement PDF would output one file with a corresponding list of transactions (this stage can r…

Can I ask how you parse PDFs? I'm curious both in terms of reading the PDF data (Python library?) and parsing it (regex?)... and do you have to deal with OCR as well?

I use "pdftotext -layout" and then parse that. Here is some more info from people who have tried this approach:

https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...

Re: Simple Personal Finance Tracking with GnuCash

#303

Earlier quoted context omitted.

Can I ask how you parse PDFs? I'm curious both in terms of reading the PDF data (Python library?) and parsing it (regex?)... and do you have to deal with OCR as well?

I use "pdftotext -layout" and then parse that. Here is some more info from people who have tried this approach: https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...

Thanks!

Re: Simple Personal Finance Tracking with GnuCash

#304
post #299

Earlier quoted context omitted.

> If a coffee here or there is going to break your budget, it's already broken and you need to go in to panic mode. I understand exactly what you are saying here, however, there have been several times in my life where buying a coffee here or there will break my budget. I know that's a level of poverty that most people on HN have never experienced before, but it's a reality for many people. You don't really ever want…

I hope my comment wasn't too insensitive to this issue.

I don't think so! It's just a different point of view. For a lot of people, having to scrape by with a small amount of money is a really frightening situation. And truly if you are in debt (especially if you are in a cycle of debt), it can be absolutely crushing. So there are definitely times where you need to engage emergency measures. But a lack of money (from a Western perspective) is not in itself reason to worry, per se. There is enough money and there is not enough money. Where you draw that line is surprisingly flexible. Especially in these difficult times, it's something that I would like people to understand.

Re: Simple Personal Finance Tracking with GnuCash

#305

Earlier quoted context omitted.

I love the IWTYTBR philosophy too. My favorite part is the concept of "guilt-free spending". Once you get the "big wins" down like you talked about, you can set aside 15-20% of your monthly net income to be spent any way you like. This seems intuitive at face value, but the example Rami uses with buying a $150 pair of cashmere sweatpants brings it home. It was inside his $500/month or whatever "guilt-free spending" b…

I think there's a distinction to be made between "guilt-free" and "dumb/wasteful" spending. I can totally understand spending $150 on a pair of sweatpants if they "bring you joy" and are useful and will last you a decent amount of time. But just because you're willing and able to spend your money without guilt, doesn't mean any and every purchase is a good one. At the very least, spending a lot of money on a series o…

I don't feel guilty at all. I feel fantastic not buying the sweatpants. I [quite specifically] don't want the joy from them. I just need clothing and I like to look sharp. A month ago I visited a second hand store. It was really well maintained, the experience was much like visiting a museum. They had a lot of second hand clothing all washed, ironed and nicely folded / on coat hangers and it was all nicely sorted by size.

I buy 8 pants for 3 euro each simply because they look fantastic on me. If it was a [new] clothing store I wouldn't buy 8 but I'd spend 100 euro on 5 of them and at most 50 for the other 3 if I ran into them there. I just didn't put myself in a [new] clothing store type of situation. I prefer to expose myself to (usually not very nice) second hand clothing at some interval. Sometimes they have something nice. Parts missing I buy new.

I see some wonderful old leather chairs too, the best one was sold regrettably. I also consider buying a really heavy suitcase massage table that I absolutely do not need but it looked really awesome, was in mint condition and was absurdly cheap. A fun day.

Clothing stores nowadays strike me as if everyone is going to a funeral. By comparison its a depressing experience but sometimes you have to. I wouldn't be able to sell those cloths at those prices, I'm paying for their ability to sell me things. (fool me)

Re: Simple Personal Finance Tracking with GnuCash

#306
post #140

Aaaaaaaaarrrrrrrgggggggghhhhh! I just want a bank account and to have that bank record my spending and let me download it, securely, and automatically. I mean the European Union has taken years to force, yes force banks to do this, and it is basically still broken. I don't want to spend this much effort on something so obviously solvable. It just offends me. Yes that is the right word. And, finally, none of this matt…

I know you're not asking directly for advice, but if you'd be interested, I find the following is the easiest way of keeping a budget. 0. Forget about tracking things down to the dollar, or even the tens of dollars. That level of precision is unnecessary. If a coffee here or there is going to break your budget, it's already broken and you need to go in to panic mode. 1. Have a spreadsheet with vague monthly costs lik…

You should try my sheet: https://docs.google.com/spreadsheets/d/1c24ZmUy19_n_QggMOjcE...

Re: Simple Personal Finance Tracking with GnuCash

#307
post #148

Earlier quoted context omitted.

Nice! I just stop spending money unless I absolutely have to. A cup of coffee and a bit of candy at the gas station every other day (2+4 euro) * (365/2) * 10 years. Thats ELEVEN THOUSAND euro I could probably be doing something more interesting with. At 7 euro/kg and 30 gr/liter 11k is 52380 liters of coffee or 314285 cups or 86 cups/day for 10 years. 2/3 was candy (we are not buying that) so we only have 28 cups lef…

> More time to enjoy life! What if I enjoy life by buying a fancy coffee & drinking it on my walk to work? The downside of your formulation of "why buy coffee? you could be enjoying life instead!" is that this worldview encourages people to feel guilty about buying coffee. Extreme frugality has its place, but remember that "your life" that you have to enjoy isn't something that starts in 5 years or 10 years or once y…

> What if I enjoy life by buying a fancy coffee & drinking it on my walk to work?

haha, are you asking for my permission here? We are different people! Thank god! Imagine if our hard worked grand-design for life turned out exactly the same. Now that would be truly terrible.

> this worldview encourages people to feel guilty about buying coffee.

I don't feel guilty when I don't, I feel stupid when I do.

> Extreme frugality has its place, but remember that "your life" that you have to enjoy isn't something that starts in 5 years or 10 years or once you save $x, it's what's happening right now, all the time.

Right, dopamine is going to happen. Don't worry about it. I resist the cravings also because I don't want to become an instinct and emotion driven creature.

> I might not be alive in 5 years, none of has that guarantee. So I enjoy my coffee.

If you skip this one the next one will taste at least twice as good. Eventually you sit there clamping onto the cup with both hands and making conversation with it.

The thing with bodies is that they always want something. There is no end to it! (haha)

> It sounds like you enjoy frugality for its own sake which is fantastic, and more power to you. But I think most personal financial planners would suggest that you have a goal you're working towards rather than "hoard cash."

Of course! They wouldn't have a job if they didn't!

> What's the point of that?

I'm not hoarding cash. There is no point in that for me!

> "Thats ELEVEN THOUSAND euro I could probably be doing something more interesting with" figure out what that "something more interesting" is and it might make sense to forgo your daily coffee.

I just want to be able to live without ever worrying about money.

> Hoarding cash is not a goal.

Money doesn't make you happy but a lack of it is just awful. Hoard enough until it stops making sense.

> > If we take 50 years it is 55 000 euro. > Yippee! I'm 85 years old (assuming I haven't died already) and I have an extra €55k. Am I allowed to drink coffee now?

haha, thanks for that. I can live comfortably on 1000 euro so the 55 k would allow me to reduce my earnings to 500 euro for 110 months spread out over the 50 years or 11 months every 60 months. If I brutally cut 5 more corners like this I could spend most of the 50 years reading HN poke peoples mind like this (and better)

Thanks for just saying what you think.

Re: Simple Personal Finance Tracking with GnuCash

#308

Earlier quoted context omitted.

I think the old addage "look after the pennies and the pounds will look after themselves" really applies. Some people don't seem to mind not really tracking their spending down to an extremely granular level (ie everything) because they make so much money that small outgoings on their bank account are worthless, or they have to dedicate their time to their family and can't be bothered to track it. That seems odd to m…

I have mixed feelings about this and overall I still want to engage in better financial tracking. However, the obvious flip side of the coin is that if I need several hours a month to keep proper track of the budget to save a few hundred more a month it might not be worth it, as I value more what I do with that time and not worry about a budget. The problem of course is that once I start tracking in detail I may find…

You probably only need a few months of data to make conclusions.

Re: Simple Personal Finance Tracking with GnuCash

#309
post #247

I was a bit flummoxed right at the first example. You bought something at a bakery, so the balance in your credit card increased ? It's right there in the increased column. Surely it decreased to a larger negative number? (Credit card accounts are almost always negative, although mine occasionally goes slightly positive when I pay it off and round up to the next pound.) And why are the columns different to the exampl…

The "credit card" account is a liability account, unlike a bank account which is an asset account. If you spend something on a credit card, your liability increases. > Credit card accounts are almost always negative This is only true if you think of them like a bank account. Every credit card statement I've ever receive has shown the amount I owe as a positive amount.

> > Credit card accounts are almost always negative

> This is only true if you think of them like a bank account. Every credit card statement I've ever receive has shown the amount I owe as a positive amount.

I just checked my online banking - I bank with Nationwide, a UK building society (a bit like a US credit union but functions like a bank). In the main statement of accounts, which looks like this [1], the credit card balance is shown negative. So is my mortgage, which makes for a depressing overall sum! I won't bore you with more detail but generally they mostly stick to this pattern in other screens. Oddly, in that example screenshot, the credit card balance is shown as positive - I'm not sure if that's because it's just an example and they faked it wrongly or because the way balances are shown have changed since that picture was taken.

I've never had a credit card with anyone else, so that's why I'm surprised that the debt is presented as a positive number. It's interesting to see (from your comment and others) that's it's normally done that way. My initial cynical reaction was that this is a marketing ploy to make you feel a bit less bad about it, and I'm not surprised that Nationwide doesn't follow suit given that it's not run for profit.

[1] https://i0.wp.com/money-watch.co.uk/wp-content/uploads/2011/...

> The "credit card" account is a liability account

Interesting, thank you, I hadn't heard of "liability account" before. So it seems that it is something accountants really do use, not just the cynical marketing plot I initially thought. But it still does seem an unnecessary complication to me compared to just having all accounts working the same way (but some happen to be negative). Maybe it's a just mathematician / computer scientist thing of preferring things that make mathematical sense rather normal intuitive sense, a bit like zero-based indexing or end iterators that point one past the end.

Re: Simple Personal Finance Tracking with GnuCash

#310

I want to like GnuCash but I just can't. I have found the UI to be confusing. I still use a freeware, abandoned version of Microsoft Money: https://www.microsoft.com/en-us/download/details.aspx?id=207... The UI is still excellent. It is the only reason I have Windows installed on a spare computer. Despite never being updated, the principals of personal finance haven't changed that much.

I'm in the same boat! One Windows laptop in the house dedicated to MS Money. With 27 years of financial history, and counting, it still does everything I need it to. Once a year I export it into Excel to do some forecasting and analysis. I'd really love if there were a reliable and future-proof way to get at the data. Sunriise[0] is the only way I know to export raw data but it has a few issues and the source code isn't public.

[0] https://bitbucket.org/hleofxquotesteam/dist-sunriise/wiki/Ho...

Post reply on HN