Live data from Hacker News

Simple Personal Finance Tracking with GnuCash

csun.io

211–220 of 323 posts

Re: Simple Personal Finance Tracking with GnuCash

#211
In the last 6 months I have built a set of Python scripts around Beancounter, that import and categorize and archive various bank and CC statements into the ledger.

Paired with Fava budgeting capabilities, my personal finance tracking is almost frictionless. It takes literally 5 minutes to go through 5 accounts.

Since I live in Germany, I still have to use cash, which is a bit a pain to track.

For that, I use an Android app that writes data directly into the Beancount ledger.

Re: Simple Personal Finance Tracking with GnuCash

#212

I've used GnuCash for years before switching to beancount ( https://bitbucket.org/blais/beancount/ with smart_importer: https://github.com/beancount/smart_importer ) and fava ( https://github.com/beancount/fava/ ). Much easier to work on your journals (ledger, trades, prices...) since they are just text files. Really great if you're using the beancount package for Sublime: https://packagecontrol.io/packages/Beancount…

"each file is saved into a folder that corresponds to my account structure such as Asset:Current:Cash, Liability:Mortgage, Income:Salary, Expenses:Health:Dentist"

Beancount user here, even if you don't bother with any finance tracking, organizing financial documents following the folder structure is useful - see "Filing Dcouments" in https://docs.google.com/document/d/1e4Vz3wZB_8-ZcAwIFde8X5Cj...

Shameless promos:

- People are starting to make Fava extensions for things like envelope budgeting, portfolio tracking, etc. Usually these are announced on the mailing list: https://groups.google.com/forum/#!forum/beancount

- The sublime plugin is great but I have a really useful improvement to search by org-mode headlines that never seemed to get merged - see https://github.com/norseghost/sublime-beancount/pull/14

Re: Simple Personal Finance Tracking with GnuCash

#213
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…

My way is as follows. Have three accounts: current, savings and retirement. The first two are cash, the third is something more long term. First work out the percentage of your income that you need to go into your retirement fund to maintain your current lifestyle when you retire. I plan to retire at 50. Your salary will get paid into your current account periodically. When it does, you check how much was still in your current account from last month and (hopefully) move the correct amount to your retirement fund. Whatever is left after that goes into your savings account. You can spend your savings on things you don't need like car, holiday etc. But never spend it all as you don't want to liquidate your retirement in an emergency. You'll know you always have enough in your current account for your essentials (bills, groceries). You never have to worry.

Re: Simple Personal Finance Tracking with GnuCash

#214

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…

The EU had the right intentions, but made a big mistake in pushing this onto the banks. Which indeed results in each bank now having a "mandatory" shitty expenses section.

What they should have done instead, is standardize a secure export function of all your expenses, allowing open source, and vendors to provide statistics and utilities based on this format.

Re: Simple Personal Finance Tracking with GnuCash

#215

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…

The EU had the right intentions, but made a big mistake in pushing this onto the banks. Which indeed results in each bank now having a "mandatory" shitty expenses section. What they should have done instead, is standardize a secure export function of all your expenses, allowing open source, and vendors to provide statistics and utilities based on this format.

Especially when you are a customer at multiple banks.

Re: Simple Personal Finance Tracking with GnuCash

#216
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…

> 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 to go into panic mode. Living on a very limited budget is not the end of the world. I actually chose my lifestyle. I had this idea that there are 2 ways to be rich: make more money than I need, or need less money than I make. Sometimes the second one involves a lot less stress (which is admittedly quite difficult for a lot of people to believe).

If you are on such a limited budget, it is quite important that you know whether or not that coffee on Monday means that you aren't going to eat on Sunday. At the same time, if you do have some wiggle room, it's quite important to treat yourself occasionally.

What is important to track as your expenses has nothing to do with absolute value. It has to do with the value relative to your total budget. If nothing you buy costs more than $5, then obviously you are going to track smaller values. On the other hand, one of the huge advantages of having no money is that it doesn't take long to count it ;-)

So I would rather say that if you need to track down to the level of individual dollars for a personal budget, something like GnuCash is probably not the appropriate tool.

Re: Simple Personal Finance Tracking with GnuCash

#217

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…

We've pretty much given up. Waiting for N26 or another neobank to support CHF deposits (not likely going to happen though).

Until then we've been using a mix of Excel and YNAB.

Re: Simple Personal Finance Tracking with GnuCash

#218
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…

Cutting down on the small stuff like has really helped us out over the long run.

Coffee is about 4.5 USD where I'm at, which is part of the reason.

The big expenses are still what matter though.

Re: Simple Personal Finance Tracking with GnuCash

#219
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…

Yeah, but how fancy is the fancy coffee though? Are we talking Starbucks or a three day roast sourced from a micro lot in Kenya?

If it fits your budget, go for it, but let's not confuse convenience with enjoyment or quality.

Re: Simple Personal Finance Tracking with GnuCash

#220
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…

> 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.

Yes and no. Late last year I did track everything to the cent (well, to the grosz, the fractional part of Polish złoty) and used ledger (the CLI double-entry accounting tool) to analyze it. My main discovery there was that most of our spending was so thoroughly distributed across every category that there was no easy wins to be had. Pretty much the only things we could do that weren't serious lifestyle changes involved garbage-collecting some subscriptions and instituting monthly limits on $favourite-foodstuffs. But before doing a high-granurality trace of expenses, I was sure there were trivial cuts to be made. Turns out, they weren't.

Doing this level of tracking is probably not sustainable in the long run (unless you're in emergency mode), but doing that for couple of months is a great opportunity to reevaluate all spending in your life.

Post reply on HN