[HN Gopher] Simple Personal Finance Tracking with GnuCash
       ___________________________________________________________________
        
       Simple Personal Finance Tracking with GnuCash
        
       Author : igpay
       Score  : 227 points
       Date   : 2020-05-19 17:20 UTC (5 hours ago)
        
 (HTM) web link (www.csun.io)
 (TXT) w3m dump (www.csun.io)
        
       | mcguire wrote:
       | " _For my stocks and non-money assets, I opt not to track them
       | super closely in order to avoid having to update the values of
       | each stock every time._ "
       | 
       | GnuCash's Price Editor can fetch values automatically. It used to
       | be able to use Yahoo finance, but they cut that off a while back.
       | There is a replacement, but I cannot remember what it is at the
       | moment (and am on the work laptop).
       | 
       | GnuCash is actually pretty easy to use, once you get used to the
       | double-entry system and how it handles some things. I have a
       | moderately complex situation (and it's been stupid complex in the
       | past), and I don't spend more than a few minutes a month on it
       | (unless I'm trading stocks; it can take more time to set up each
       | stock's account for proper tracking).
        
         | pseudoramble wrote:
         | You need to setup an AlphaVantage API key. See here: https://wi
         | ki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_qu.... I set it
         | up a few years ago and it seems to keep work. If I break my
         | setup messing around, I'll just copy the values directly from
         | my investment site into GnuCash.
         | 
         | This is definitely one of the clumsier parts of GnuCash. Still
         | works though.
        
         | memling wrote:
         | > GnuCash's Price Editor can fetch values automatically. It
         | used to be able to use Yahoo finance, but they cut that off a
         | while back. There is a replacement, but I cannot remember what
         | it is at the moment (and am on the work laptop).
         | 
         | It's possible to get Yahoo! data through web scraping, but it's
         | certainly less convenient than it used to be.
         | 
         | IEX also has an open API for querying historical data.[1] I
         | don't think it has as much historical data as Yahoo! has, and
         | it's changed a bit since the last time I thought about putting
         | together a backtester.
         | 
         | [1] https://iexcloud.io/docs/api/
        
       | mattbillenstein wrote:
       | This all seems too complex for most people. I use Google Sheets,
       | I import a year-to-date csv from my bank and credit card every
       | month, categorize each transaction, then use QUERY to aggregate
       | expenses by category. This data I feed into a rough budgeting
       | sheet which I use for expense trimming. This monthly maintenance
       | takes maybe 30 minutes.
       | 
       | And I have another sheet to compute net worth - retirement and
       | brokerage accounts hold funds for which I can get a price using
       | the GOOGLEFINANCE function, so the numbers change over time and I
       | know pretty much down to the penny what my net worth is after I
       | sorta manually enter in a couple bank balances.
        
         | NicoJuicy wrote:
         | Do you have a similar public sheet as example?
        
           | mattbillenstein wrote:
           | Yes, I've tried to get a few friends who don't budget at all
           | into some sort of system - so I made this template: https://d
           | ocs.google.com/spreadsheets/d/1c24ZmUy19_n_QggMOjcE...
        
         | igpay wrote:
         | I'd definitely agree that this is overkill for most people. In
         | your case, though, I think that you could put the same amount
         | of work into GnuCash and get the same results without writing
         | any code. Plus you'd have a GUI with built in reports and
         | whatnot. Not sure if that matters to you.
         | 
         | In the article, I briefly touch on skipping manual transaction
         | logging and just importing statements from your bank / credit
         | card. And I gloss over this, but it looks like GnuCash offers
         | similar functionality for automatically updating stock prices
         | https://wiki.gnucash.org/wiki/Online_Quotes - not sure if it's
         | a pain to set up or not, but it's probably not as easy as just
         | calling a google sheets function.
         | 
         | Seems like you wouldn't have any reasons to switch over given
         | that you've already got a nice system going, but just wanted to
         | point out that you can use GnuCash in a way that's not quite
         | as... rigid as the way I use it :)
        
           | mattbillenstein wrote:
           | I don't really want a GUI - or the GUI I want is a
           | spreadsheet.
           | 
           | I have some charts and graphs embedded with the data - like
           | net worth over time, brokerage over time, etc. My worry with
           | a baked system is it doesn't have the data in a way I want in
           | a chart, whereas with this system, I can pretty much create
           | whatever I want from the raw data in the sheet...
        
             | lbotos wrote:
             | Tiller is trying to build exactly that:
             | https://www.tillerhq.com/
             | 
             | I haven't used, because I use personal capital and they
             | both used Yodlee, and my biggest gripe about personal
             | capital is yodlee isn't keeping up with 2fa style logins
             | from banks
        
           | jldugger wrote:
           | Online quotes is fairly easy to set up. First you set up the
           | ticker symbol in the prices menu, then you set an account for
           | the stock, make the type "Stock" and set the currency to the
           | symbol in question. From then on, you can just 'get new data'
           | and stuff mostly updates automatically.
           | 
           | However, stock symbol APIs break on the regular, so there can
           | be times when this process is broken until a fix is published
           | and you upgrade.
        
       | candiddevmike wrote:
       | Shameless plug, our product, Domestica, is better for personal
       | finance tracking as it uses the envelope model of categorization.
       | It also includes to do lists, meal planning and more--in the
       | cloud or self hosted.
       | 
       | https://about.domestica.app
        
       | darcys22 wrote:
       | To all the people who are running ledger with bash scripts and
       | piping thru sed & awk I've been working on another open source
       | alternative.
       | 
       | https://godbledger.com/
       | 
       | I've always thought that having the data recorded in a single
       | text file made the software only suitable for extremely small
       | financial accounts. So I've put a SQL database that you have
       | control over as the place where the data is saved (using a
       | similar schema to what GNUCash does). Also added GRPC endpoints
       | so scripts can talk to it easily.
       | 
       | It's still early stage but plan is to make a bunch of front ends
       | so that every financial task within a business can talk to the
       | same backend (bank reconciliations, payroll etc)
        
       | komali2 wrote:
       | It's kinda fun to idly scroll through gnu's list of free software
       | 
       | https://directory.fsf.org/wiki/GNU
       | 
       | As far as I can tell, everything there was made simply because
       | somebody out there thought it's important for a Free version of
       | said software to exist. That's pretty cool. There's gnucash of
       | course, but also a gnutrition calorie/macro/micro tracker, a
       | flight simulator, some sort of comic saving software... the list
       | goes on. Fun!
        
       | raz32dust wrote:
       | I've been using YNAB. I want to switch out because YNAB is too
       | expensive. What I miss with open source alternatives is the
       | mobile app. I don't like to link my bank accounts, so I enter
       | expenses manually whenever I buy anything. The mobile app is
       | critical for that to work.
        
         | hybridtupel wrote:
         | For the same reasons I am still using the classic version of
         | YNAB (paid once). But unfortunately the Mac version is not
         | compatible with Catalina so I am also forced to search for a
         | new app.
        
           | raz32dust wrote:
           | I paid once as well, but was forced to upgrade to Catalina
           | for other reasons. Felt cheated, but I understand why they do
           | it.
        
         | taftster wrote:
         | YNAB can sometimes feel expensive. And while I could use an OSS
         | solution like Gnucash or ledger, I don't have the time to deal
         | with the tech support needed to be able to share my setup with
         | my spouse. Likewise, we extremely value the mobile experience.
         | To me, YNAB is cheap and well worth the money.
         | 
         | You might want to try "Every Dollar" which is free and has a
         | mobile experience. It's not open source, of course, but it
         | might fit what you're looking for.
        
         | dsd wrote:
         | Too many of these personal finance apps aren't putting the web
         | first
        
           | taftster wrote:
           | YNAB (web version) has a pretty excellent web-first
           | experience. And I'm not sure that I want a total web
           | experience if half of my battle is recording transactions at
           | the time they occur, right in the store. This is super
           | convenient, no reason to keep receipts and enter them when I
           | get home.
        
       | fossuser wrote:
       | I'd be curious if anyone has used this and also used YNAB (and
       | can compare them).
       | 
       | I'd put YNAB along with 1Password (and probably Fastmail) in the
       | class of best single purpose pieces of software that I pay for.
        
         | boromi wrote:
         | Why 1Password? I've tried it throughout the years, and IMO
         | nothing has beat KeePass.
        
           | fossuser wrote:
           | It works really well across all of my devices and operating
           | systems (and will continue to do so as those systems change).
           | 
           | I'm glad keepass exists, but I'm happy to support polished
           | software in this domain. I like paying for software I think
           | is really good and focuses on a narrow problem.
        
           | codazoda wrote:
           | +1 for keypass. The apps aren't quite as polished, but they
           | do what I need, and I can store my encrypted password file in
           | my Dropbox folder so that I've still got it if any single
           | company in this small chain folds.
        
             | jorvi wrote:
             | 1Password its vault format is open source, so even if the
             | company goes belly up a 3rd party tool that can decrypt
             | your vault can easily be written.
        
         | memling wrote:
         | > I'd be curious if anyone has used this and also used YNAB
         | (and can compare them).
         | 
         | I'm a long-time user of both. YNAB wins hands-down in budgeting
         | and basic usability.
         | 
         | When I got married, we integrated finances. I had been using
         | GnuCash for years by then. Its interface was an immediate non-
         | starter, even though as an application it's more powerful than
         | YNAB (e.g., stocks and retirement planning, mortgage
         | amortization, business expenses, easier splits--at least in my
         | opinion). If it had a better budget and reporting system, I
         | might have been able to swing it--but it didn't and doesn't,
         | and that was that. The other killer feature YNAB offered was a
         | mobile application.
         | 
         | Financial apps have to reduce friction. Interpersonal first
         | (although that's a tall order for software), but also in
         | delivering fast entry and a big-picture view of what you're
         | doing with your money. GnuCash really isn't designed for any of
         | that. And that's honestly fine for what it is, although I wish
         | the database were easier to wrap your head around--it should be
         | possible to build a cleaner and/or web UI around it than it
         | seems to be.
         | 
         | As it is, I'm not really content with YNAB either, but if
         | that's what it takes to get our internal financial reporting in
         | order, it's a lot better than nothing.
        
         | whycombagator wrote:
         | I've looked at YNAB before, I keep wanting to try a finance
         | tracking tool - but I can't ever decide which one is worth my
         | time. What's so good about YNAB? It seems to be marketed at a
         | certain segment that I'm not in. At least, based on their
         | homepage line:
         | 
         | > Stop living paycheck-to-paycheck, get out of debt, and save
         | more money.
         | 
         | As for 1Password, given your username I'm assuming you've tried
         | Bitwarden? What is better about 1Password?
        
           | fossuser wrote:
           | I actually hadn't heard about bitwarden (thanks) - I'll check
           | that out.
           | 
           | I'm not in YNAB's target market either, but the value they
           | provide is useful even if you're not struggling month to
           | month with finances. You get really good control over your
           | money and a much better understanding of how you're spending
           | it and where.
           | 
           | Being really aware of that makes it easier to actually
           | leverage it _more_ because you know exactly what you can put
           | where so you can be closer to zero in your checking account
           | (push more towards investments, etc.).
           | 
           | It also makes it easier to change behavior and know exactly
           | what knobs you can turn with your finances.
           | 
           | Only downside with it is that the auto-import sucks (I
           | suspect because the bank APIs suck). I move all transactions
           | through one credit card and I manually create transactions in
           | YNAB when the card is charged. I use the Apple Card which has
           | really good software so it's easy to notice transactions and
           | make sure things line up.
           | 
           | My username is also from when I was 13 and really excited
           | about linux :-), now mostly on macOS - I haven't really lived
           | up to it.
        
             | PascLeRasc wrote:
             | Which file export do you use from Apple Card to YNAB? I'm
             | looking at doing the same thing and I'm curious which works
             | best.
        
               | fossuser wrote:
               | I don't export - when a transaction is made I open the
               | YNAB app and quickly add it.
               | 
               | I resisted doing this for a long time because I thought
               | it would be awful, but it's actually easier than dealing
               | with import issues and reconciling later.
        
             | jonjohn84 wrote:
             | I'll give the opposing opinion that YNAB's auto-import
             | works well for me (I use it with a local credit union, 2
             | credit cards, and an online savings account). In fact, I
             | used my own homebrew budgeting software for over a year
             | before I found that YNAB exists and does everything I
             | needed from my own software plus imports from banks
             | automatically which was my biggest pain point with my own
             | solution (it involved painful csv exports every month). I
             | have been happy with YNAB for a year and a half at this
             | point. Your luck may depend on which bank(s) you want it to
             | work with. I believe their bank import api provider was
             | recently acquired by Plaid so they are now using Plaid (as
             | I understand it).
        
           | godtoldmetodoit wrote:
           | I've been using YNAB for about 6 months now. I was not living
           | paycheck to paycheck when I started - but I have made
           | significant improvements to my financial well being since I
           | started using it.
           | 
           | Previously I had been using Mint to keep track of my
           | spending, but I never felt in control, it was only useful as
           | a reporting tool of what had already happened.
           | 
           | YNAB is all about giving every dollar a job and setting
           | priorities for your life. It's the envelope system in digital
           | form if you are familiar with that. With Mint and similar
           | systems, I'd just be looking at my pile of cash in my account
           | and thinking "yeah I can easily afford a new gaming PC!".
           | 
           | But I wouldn't be taking into account my 6 month auto
           | insurance bill coming up in 2 months that would require a
           | bunch of cash. YNAB let's me see that easily - it was painful
           | in the beginning as I was "catching up" in all these
           | categories, but now I feel so much more comfortable with my
           | money and how it can be put to good use.
        
             | fossuser wrote:
             | Yeah - I had a similar experience. A lot of people suggest
             | Mint is a similar thing to YNAB, but except for being money
             | related it really isn't.
             | 
             | I used it first too and I think it may actually be worse
             | than nothing.
             | 
             | It's both infested with a ton of ads and makes you think
             | you understand where your money is going without really
             | understanding it.
        
       | chad_strategic wrote:
       | I tried GnuCash and generally liked it. However, it was a little
       | more complicated than I wanted. In addition, I wanted to be able
       | to access via the web, when I was away from my computer. (cause
       | at the time, I thought it was only available locally)
       | 
       | I also wanted my life partner (my lovely wife) to participate.
       | This was going to be the hard part. Behavior modification. So I
       | built a very simple "tracker".(php/codeigniter/mysql) Date,
       | description, category, spender, cost, that could be accessed
       | anywhere.
       | 
       | I asked my wife to start tracking spending. As we had just bought
       | a new house and 1 1/2 year old. She was extremely resistant to
       | the idea. Six months after using the "tracker" she told me that
       | she didn't plan on doing it more than 2 days before she gave up.
       | However since starting it 3 years ago she and I have increased
       | our "frugalness" and really looked where we should spend money
       | (vacations, artisan food and not items to impress other people...
       | such as fancy cars.)
       | 
       | I think part of the trick is not necessarily import or export or
       | "api"ing data. The trick is doing a manual entry for each
       | transaction. Kind of like a spending journal, food journal or
       | just a journal. There still seems to be power in manually
       | entering a transaction, although it might not be by pen and
       | paper.
        
         | pseudoramble wrote:
         | > The trick is doing a manual entry for each transaction. Kind
         | of like a spending journal, food journal or just a journal.
         | There still seems to be power in manually entering a
         | transaction, although it might not be by pen and paper.
         | 
         | This was a big realization for me. I tend to prefer getting the
         | "robots" to do things for us (in other words, automate things).
         | Developing an intuition of what's happening with your money is
         | hard when you use an automated tool though.
         | 
         | The process of managing the ledger bi-weekly really adds
         | something more for me. Working on each entry to determine a
         | category, writing down amounts, noticing how many entries I've
         | entered into a category each session, and looking at it in
         | aggregate afterward gives me some greater sense of how my
         | financial life works. I can almost picture writing the
         | transactions in GnuCash before I even do it.
         | 
         | I get what you mean about it being complicated though. I
         | learned the bits I needed to get by and mostly stick to that.
         | So that works for me. In the long run, the double-ledger manual
         | style is what I think is most important.
        
         | projproj wrote:
         | >The trick is doing a manual entry for each transaction.
         | 
         | I would second this for anyone whose goal is to spend less
         | money. I think some people keep track of purchases just to see
         | all spending and may not care about reducing spending. In that
         | case, importing data can save time.
         | 
         | This article also agrees with your suggestion. She suggests
         | it's th that knowing you are going to have to write down your
         | purchase helps you think before automatically spending:
         | https://www.nytimes.com/2018/11/28/smarter-living/budget-mon...
        
       | balnaphone wrote:
       | In the first pie chart [0], am I the only one having a hard time
       | with colours in the legend? For example, the second colour in the
       | legend is #ff851b [1], but that doesn't appear in the pie chart.
       | Going by the amount (33.69%), it must be the segment with colour
       | #ffa85f [2].
       | 
       | [0] https://www.csun.io/images/gnucash/expenses_piechart.png
       | 
       | [1] https://www.color-hex.com/color/ff851b
       | 
       | [2] https://www.color-hex.com/color/ffa85f
        
       | lbotos wrote:
       | Is anyone regularly or reliably getting bank/credit card data via
       | OFX? I've considered switching from Personal Capital to these
       | libre/open solutions, but I'd love to automate the data
       | gathering.
        
       | clum wrote:
       | I've been using GnuCash for years. It has a great many fantastic
       | features and it has some annoying quirks for sure. I haven't
       | found anything to replace it, but if I could I would. One of the
       | most annoying things: Export account names with Umlauts -> Import
       | them again. Now they are all broken. I have to manually fix the
       | csv file to prevent that and there's never been a fix/devs don't
       | see this as an issue.
        
       | rcMgD2BwE72F wrote:
       | 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.
       | 
       | More importantly, the importers (for all my banks and financial
       | services) let me import and reconcile all transactions, but also
       | archive all documents (including PDF, text files, etc) in one,
       | well organized directory: 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. It's
       | great to rely on fava (example:
       | https://fava.pythonanywhere.com/example-beancount-file/incom...)
       | to check your accounting (with all files listed in the journal by
       | date, with tags and links and other neat features) and still be
       | able to browse documents in your file browser.
        
         | simonebrunozzi wrote:
         | This sounds amazing. It would be great if one day you could
         | publish a detailed how-to / tutorial.
        
         | riffraff wrote:
         | I'm also a happy beancount user. It's also pretty simple to
         | extend, if not too documented.
         | 
         | I was able to write a plugin to get data from the Milan stock
         | exchange in a few hours, which was very nice. The vim plugin is
         | also pretty ok.
        
         | haberman wrote:
         | 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 run
         | completely in parallel and I use "ninja" to make it very fast).
         | 
         | Then another process can run over these files looking for
         | matches (+$X, -$X), and spit out "transaction groups", where
         | each transaction group is a set of transaction ids that sum to
         | zero. And then a different interactive tool lets you categorize
         | transactions and spits out transaction groups with embedded
         | "expense" transactions. It's all non-destructive; each tool
         | only adds data, and nothing ever modifies existing files. Then
         | a final step can combine all these files and spit out a
         | beancount file for Fava.
         | 
         | How does this compare with the way beancount's importer does
         | it? How does its importer handle transfers and categorization?
         | Is it destructive or non-destructive?
        
           | cobby wrote:
           | > beancount wants everything to live in One Giant Journal
           | file
           | 
           | Actually, beancount supports include directive. See includes
           | section [1] of the language syntax document
           | 
           | [1]: https://docs.google.com/document/d/1wAMVrKIA2qtRGmoVDSUB
           | JGmY...
        
             | haberman wrote:
             | Thanks for the reference. But a single transaction can span
             | multiple financial institutions. Say you pay off a credit
             | card. One half of the transaction comes from the credit
             | card statement, the other half comes from your bank. The
             | two halves sum to zero.
             | 
             | My understanding is that the whole transaction has to live
             | in one file with Beancount. This doesn't seem amenable to
             | having each bank statement generate a single Beancount
             | output file.
             | 
             | But I could be wrong. I don't know how Beancount's importer
             | works.
        
           | mattbillenstein wrote:
           | You're parsing PDF? I'd imagine most places allow some sort
           | of data export like csv or something? That's how I get the
           | data out of Chase and BofA.
        
             | mehrdadn wrote:
             | There are a few problems with exporting data... here's what
             | comes to my mind at the moment:
             | 
             | - It's an additional step and unnecessary when you're
             | already downloading PDF statements, which you probably
             | should be doing regardless
             | 
             | - Data is often unavailable for export after a few months
             | or a year or two (depending on the bank), far earlier than
             | PDFs
             | 
             | - If you have PDF scans (especially from earlier days) then
             | you need to parse the OCR anyway
             | 
             | - If you're using official APIs (instead of writing a
             | scraper or or downloading by hand) then you may need to pay
             | extra
        
               | mattbillenstein wrote:
               | To each their own, csv for me has been the easiest thing
               | moving forward every month or three.
               | 
               | I did do a historical net worth calculation and the only
               | data I had going back far enough was PDFs, so through a
               | mix of bash scripts and pdftotext, I was able to get a
               | number for each month back about 10 years. But I ended up
               | just putting that monthly balance for each account in a
               | google sheet so I could sum and plot it there. Now I just
               | stick the month-end balance for each account in a sheet
               | to keep this updated.
        
             | haberman wrote:
             | Yes, in my experience CSV/XML/etc export is spotty. Some
             | institutions don't have it at all, and even when they do
             | the time range can be limited or hard to time-window
             | reliably.
             | 
             | For example, I can't get CSV about my pay stub and all the
             | places money flows (taxes, insurance, etc). So I use PDF as
             | the best way to get all the data.
             | 
             | Parsing PDF is a huge PITA, since PDF is really designed
             | only for layout and not to encode semantic document
             | structure. But if you want the greatest amount of
             | visibility, nothing is as authoritative as the actual
             | statements.
        
               | mattbillenstein wrote:
               | Yeah, I guess I don't really look at paystubs often and
               | my banks support good csv export for like 2+ years, so
               | I'll always have it when I need when I refresh those
               | sheets. I do year-to-date in those sheets to make them
               | not huge.
               | 
               | Regarding taxes, I do a tax year calculation using my
               | W2's and returns to compute an effective tax rate and
               | figure out ways I can improve my situation re taxes --
               | but my budgeting basically only starts once the net money
               | hits a bank account which has worked pretty well.
        
           | mehrdadn wrote:
           | 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?
        
         | boromi wrote:
         | Thanks for this. Looks compelling. Is there a simple
         | installation guide, I find it hard to figure out how to get
         | going.
        
           | djhworld wrote:
           | The installation is really just a python library, but if you
           | want to keep everything contained you can put them in a
           | Dockerfile
        
           | jonahbenton wrote:
           | As a longtime beancount user- it should be easy to install-
           | there are packages for most OSes, they mostly work, the
           | maintainer, Martin Blais is amazing and indefatigable, and
           | the community is active and friendly and technical.
           | 
           | But the "how to get going" part is where I find the real
           | difficulty lies.
           | 
           | There is a conceptual friction in double-entry accounting,
           | which beancount enforces. If you do not have prior exposure
           | to it, even if you are financially and mathematically
           | inclined- grokking double entry can be a life-changing
           | practice. It is the Iyengar Yoga to the 7 minute workout that
           | is just tracking transactions as per GnuCash or Quicken or
           | whatever.
           | 
           | One has to have the appetite to consume a worldview. As
           | someone living in that world, FWIW, I highly recommend it. I
           | would not undersell the conceptual work required. It is not
           | for everyone.
           | 
           | But if the approach speaks to you, reach out on the mailing
           | list and people will help with the mechanics.
           | 
           | Cheers.
        
         | djhworld wrote:
         | Been an avid beancount'er for about two years now too!
         | 
         | I've never used the import features, the manual inputting of
         | transactions into a text file doesn't take too long.
        
         | anonymousDan wrote:
         | How do you parse the pdfs?
        
       | spodek wrote:
       | I tracked my finances for a while with GnuCash and found myself
       | in the category he describes here:
       | 
       | > _If you're happy with just knowing that your credit card
       | balance is less than a certain amount each month, that's great!
       | You don't need GnuCash._
       | 
       | I'm curious what fraction of people track personal finances
       | versus those who don't. I don't know if I'm in a big majority,
       | small majority, big minority, small minority, or what.
       | 
       | Do you track your personal finances? If so, in how much detail?
       | Maybe it would make an interesting Ask HN.
        
         | swimfar wrote:
         | I tracked every single expenditure in GnuCash for a year,
         | mostly out of curiosity. But in general I don't worry too much
         | about budgeting because I'm naturally a bit frugal. However, I
         | do a yearly summary of assets in order to track long-
         | term/retirement trajectory. I can also use that to get a single
         | number showing me how much I spend each year.
        
         | mcguire wrote:
         | I do. I started because I would find myself surprised by the
         | occasional credit card bill that was larger than I expected. It
         | made life easier later when I started seriously putting money
         | in investments, and then much easier when my mother died---she
         | had put my name on all of my parents' accounts so I inherited
         | two more, different bank accounts, two retirement accounts and
         | some honest-to-gosh stock certificates. By the time I got
         | everything cleaned up, I had a love affair with GnuCash and a
         | checking account number that starts with seven zeros.
         | 
         | I track transactions in and out of accounts that I get
         | statements for, with a "cash" expense for withdrawals (I know
         | someone who would track his pocket change in spreadsheets.),
         | and broadish categories for income and expenses (my Books
         | expense account is ... large).
         | 
         | I wish I had created some kind of asset account when we bought
         | a house; instead I just treat the mortgage like rent and have
         | this great big windfall followed by an equal expense when we
         | moved. :-)
        
         | Jtsummers wrote:
         | I was a ledger user for years, then some things happened, it
         | got out of date, and I haven't gone back. But I tracked it in
         | great detail. Every transaction, updated prices on stocks every
         | month. It was really nice, and I had a tmux configuration that
         | automatically loaded an emacs buffer with an org file holding
         | all my ledger entries, and other panes containing various
         | reports (uncleared balance, balance in cash/credit card
         | accounts, total balance, monthly reports, etc.).
         | 
         | I will do it again, but haven't. I'm presently using YNAB
         | because it's easier for my wife and I to share. I use it to a
         | similar level of detail, but don't track my stocks and
         | retirement accounts with it. IT's been very helpful for us to
         | know how much money we have and where it's all going. Last year
         | was very expensive and we ended up in some debt, so this is
         | also helping us get things back on track. It's hard to get out
         | of debt (especially if it's become a habit to rely on credit)
         | without knowing this kind of information.
        
         | berkut wrote:
         | I've sporadically tracked my finances for the past 14 years
         | (started using commercial software on OS X before getting fed
         | up of some of the software and writing my own open source
         | finance app to learn Objective C / Cocoa back in 2009 to do it
         | which I still use), and over the past 6 years have been
         | tracking it rather meticulously, which I find helpful for two
         | reasons:
         | 
         | 1. I'm a contractor now, so need to do tax filings, and having
         | detailed finances helps with that.
         | 
         | 2. I find it quite interesting (but not always that useful!,
         | although it sometimes is) what my expenditures are each month,
         | i.e. how much I spend on electronics/gear vs holiday vs other,
         | compared to potential savings.
        
         | veddox wrote:
         | I did for a couple of years - actually wrote my own small CLI
         | app to take care of my very basic student needs :D
         | 
         | At some point I dropped the habit, more out of laziness than
         | anything else. I still have a budget spreadsheet with a rough
         | plan for my monthly finances, I just don't track the actual
         | expenses anymore. Reading this makes me think I ought to start
         | again...
        
         | codazoda wrote:
         | I'll bite here... I used to track my finances and balance my
         | checkbook. But, it took hours of my time. The best thing I ever
         | did was create a separate account for my disposable income. My
         | bills account gets the exact amount it needs and everything is
         | payed automatically. The rest of my income goes into my fun
         | account and I rest easy knowing I can spend until it's gone and
         | my bills still get payed.
         | 
         | After that worked well for me, I now put small amounts into
         | various savings accounts, like "tires", "vacation", or
         | "emergency". I use an Ally account with "buckets".
         | 
         | I don't balance anymore, and haven't for 20 years. Just a quick
         | glance at recent transactions to make sure I recognize
         | everything.
         | 
         | It's also amazing how quickly some of those savings accounts
         | add up when I'm not thinking about them much.
        
         | gen220 wrote:
         | I use ledger to document my personal finances, and I've been
         | using it for about a year.
         | 
         | I do it less for budgeting, and more for a method of
         | _centralizing_ information. I have 4 credit cards that I use
         | regularly, from 3 banks, I 'm a w-2 employee with a 401k and
         | benefits, and I file my own taxes. It's hard to keep track of
         | everything, when the relevant data is behind login walls, in
         | occasionally proprietary formats.
         | 
         | I wrote a bunch of scrapers and parsers for obtaining this
         | data, and translating it into a ledger transaction format. Once
         | it's there, I can do all the reporting and whatnot to my
         | heart's content. Writing all of the infrastructure has been a
         | labor of love, with a non-trivial emphasis on _labor_. I
         | balance out about once a month, but since automating the
         | various transformers, I pretty much never have to debug
         | balances any more, which is a godsend.
         | 
         | It tracks down to a pretty excruciating level of detail, enough
         | that I compute (for example) how much it costs my employer to
         | employ me, my average monthly spread in my checking accounts
         | (between when cc bills, rent are due and when income comes in),
         | average costs of travel-vacation-days, and how that's changed
         | over seasons.
         | 
         | At this point, it mostly "just works", and it's easy to append
         | to my records. The next fun part will be getting useful and
         | actionable insights out of it, and applying them to my life and
         | decisions.
         | 
         | It's very nice to feel "in control" about these things; I don't
         | really worry about money any more.
        
         | iffycan wrote:
         | I've tracked my finances for as long as I can remember. It's
         | become even more important since getting married.
         | 
         | We track every penny. About once a month we sit down and
         | categorize every purchase we made the last month. We only keep
         | receipts if the purchase was for a non-obvious category (e.g.
         | buying both diapers and groceries at Target) so that we can
         | split each transaction between categories.
         | 
         | For some banks, we manually download transaction data in
         | whatever nice format they provide. For others, we use a syncing
         | service that works with the app.
         | 
         | It's been so great throughout our marriage to know that we're
         | both in charge of the money and make decisions together.
         | 
         | That said, I've talked with many people who don't like that
         | level of detail. At first, it was baffling to me that people
         | didn't know the details of their finances, but as I've grown,
         | I've realized that there's plenty more than one good way to
         | manage your money.
         | 
         | Full disclosure: I actively work on and sell budgeting
         | software.
        
         | samastur wrote:
         | I do, each bill or bank transaction being its own entry. I'm
         | sure I belong in minority of people who do this. It's all
         | manual labour too without any imports from banks etc. (never
         | tried).
         | 
         | I do it for two reasons. Occasionally I found a problem with
         | double-billing that I would otherwise miss, but mostly it is to
         | be able to check where my money went and plan realistically.
        
         | nicolaslem wrote:
         | Before I started using GnuCash I had no clue how much I spent
         | monthly. I was fine with the fact that the my savings account
         | seemed to grow over time.
         | 
         | Then one day I got mad at a random fee from my bank after
         | realizing how much they charged me over the years. I closed my
         | account at this bank, decided that I will be more careful with
         | my spendings and started tracking everything with GnuCash.
        
       | every wrote:
       | I've been playing around with ledger[1] recently. On one level,
       | it is the simplest of tools requiring only a command line and a
       | text editor. But once you wade into the documentation[2] you will
       | begin to see it quite differently. Its capabilities are
       | staggering...
       | 
       | [1] https://www.ledger-cli.org/index.html
       | 
       | [2] https://www.ledger-cli.org/3.0/doc/ledger3.html
        
         | gen220 wrote:
         | I strongly recommend people give ledger a try, especially if
         | you're a UNIX-nerd who gets a lot of use out of sed/grep/awk.
         | 
         | It's totally changed the way I think about finance, for my
         | person and for businesses. It also means I can have very
         | informed conversations with accountants! :)
         | 
         | Double-entry accounting as a domain is super interesting, and
         | Ledger's intersection of that domain with UNIX hackery is a joy
         | to experience.
        
         | pmoriarty wrote:
         | I looked in to switching from GnuCash to Ledger about 5 years
         | ago, and found that it would have been too painful to use for
         | manually inputting the thousands of transactions I had because
         | it just didn't have the nice auto-complete and GUI nicities
         | that GnuCash had.
         | 
         | I'm a hardcore command-line and keyboard-only power user, so I
         | would have absolutely loved to have made Ledger work for me
         | rather than use the mouse-heavy GnuCash interface, but
         | couldn't, and went back to GnuCash with my tail between my
         | legs.
         | 
         | I'd still rather use it, so maybe I'll give it another try some
         | day.
        
           | hesk wrote:
           | +1 for ledger.
           | 
           | I switched from GnuCash to ledger about 8 years ago and never
           | looked back.
           | 
           | I have a script that pulls my bank account using aqbanking
           | [1] and icsv2ledger.py [2]. The latter can match transactions
           | to templates and set transaction accounts and payees
           | automatically. It also supports autocompletion of account
           | names when a transaction is not matched by a template.
           | 
           | For cash entries, I use ledger-mode in Emacs. (I also use Org
           | mode, so I spent a lot of time in Emacs anyway.) ledger-mode
           | also supports autocompletion.
           | 
           | I only use the command line for reporting and have aliases
           | for the most common reports. These mostly revolve about
           | showing my current budget.
           | 
           | [1] https://wiki.gnucash.org/wiki/AqBanking [2]
           | https://github.com/quentinsf/icsv2ledger
           | 
           | Fun fact: The second program I wrote was a database in Turbo
           | Pascal to keep track of my loose change.
           | 
           | Not so fun fact: I lost my GnuCash files after I made the
           | switch. Ten years of accounting gone. :(
        
           | igpay wrote:
           | This is exactly what made me switch _away_ from ledger. I
           | thought that a command-line /plaintext only workflow would be
           | great, because that's what I usually prefer. However, a GUI +
           | autocomplete just ended up being way more useable for me in
           | this case.
        
           | every wrote:
           | Assuming GnuCash can do some sort of plain text record dump,
           | I would probably try to cobble something together to convert
           | that to an acceptable ledger format. Maybe with AWK or
           | something similar...
        
           | gen220 wrote:
           | I've been using ledger for a year next month.
           | 
           | As you imagine, the fact that it's text-only has been both a
           | burden and a blessing.
           | 
           | Burdens:
           | 
           | - inserting transactions takes a long time, when you're
           | starting out. will always take a long time if you never
           | "automate"
           | 
           | - it's easy to make little mistakes and not catch it until
           | the next time you compile or make a report.
           | 
           | blessings:
           | 
           | - git, sed, grep, awk all "work as advertised"
           | 
           | - you can automate the boring things, as they get more
           | boring, and you can learn a lot along the way
           | 
           | at this stage, I have a combination of awk and python scripts
           | (maybe 500 lines total, but a lot of it is regex) that
           | convert my financial institutions' transaction export csvs
           | into ledger transactions. I pretty much copy paste that into
           | specific ledger files. The next step that I'm currently
           | automating takes a concatenated `git diff` and interactively
           | categorizes expenses/splits/assigns to the correct ledger
           | file.
           | 
           | I also blew a ton of time (maybe 40 hours) on scraping those
           | csvs from bank websites, workday, and fidelity (basically, a
           | puppeteer script for logging in, downloading all the files
           | available). Getting past google auth for workday was hard.
           | But learning these things has been fun.
           | 
           | With all this automation, I spend maybe 20 minutes every
           | weekend importing things over from the banks. I'd do it every
           | month, but I'm still a control freak with it.
           | 
           | Doing this has been super fun! And it also has yielded a lot
           | of insight into my finances. Above all, it gives me a feeling
           | of "control" over my finances like no other. Itemizing
           | deductions takes an hour, just as a throwaway example.
        
         | jonahbenton wrote:
         | Beancount as well, very similar in philosophy and staggering in
         | capability, slightly different flavor and rendition compared to
         | ledger.
         | 
         | http://furius.ca/beancount/
        
       | suyash wrote:
       | Most banking services - at least mine already provides reports
       | and graphs along with simple budgeting features for free with
       | online banking. I prefer to use that, as that is where most of
       | the data lives anyways.
        
       | m0zg wrote:
       | No sync with banks - a complete non-starter for most people. Even
       | if you enthusiastically start using something like this, in a
       | month or two it'll get super old.
        
         | detaro wrote:
         | It supports multiple methods of sync with banks, although I
         | don't know how common these methods are in various parts of the
         | world.
        
       | fensterblick wrote:
       | 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.
        
         | gyrocode wrote:
         | I am still using Microsoft Money too, it's great! There is also
         | Money Plus Sunset Home and Business edition available at
         | https://www.microsoft.com/en-us/download/details.aspx?id=756...
         | which includes features for small businesses, see comparison at
         | http://moneymvps.org/faq/article/499.aspx
        
       | cascom wrote:
       | I've been using Gnucash for my personal finances for a several
       | years now, and really love it - it's not dead simple, and
       | requires an understanding of double entry bookkeeping, but where
       | it really shines is flexibility. A couple of examples are as
       | follows:
       | 
       | 1. Expenses in the future - If I book a bunch of plane tickets
       | for later in the year today, I can book those expenses in those
       | months in which I'm traveling (pre-paid asset until then) there-
       | by seeing when I'm incurring those expenses vs. the cash flow of
       | those expenses.
       | 
       | 2. Corporate expenses - I can book expenses that I will be re-
       | imbursed for as receivables and not have them run through my
       | "income statement" (nothing like putting some business class
       | plane tickets on your personal card to make things look weird)
       | 
       | 3. Loans - whether it's an auto loan on your car or simply a loan
       | to a friend it's great to be able to see your entire balance
       | sheet (and remember that some items are outstanding!)
       | 
       | 4.variable granularity - decide how detailed you want to get for
       | some accounts you may decide you don't need that much detail
       | (because you track it some other way - like your 401k) and you
       | can just track your total balance at month end (+/- deposits)
       | 
       | 5. Track illiquid investments in your net worth (not saying the
       | marks are right, but at least you have a placeholder value for
       | them on your balance sheet (your home - private company stock
       | etc.)
       | 
       | 6. Privacy - it's your data - no sharing it with anyone else
        
       | clircle wrote:
       | I was an avid GnuCash user for a year or two in grad school,
       | keeping track of my finances using GnuCash Mobile on my android
       | phone. Then I bought a new phone and exported my finances
       | database. When I loaded it into my new phone, I found the xml had
       | been corrupted.
       | 
       | That was a sad day because I'd like to use an offline finance
       | tracker on my phone.
       | 
       | BTW GnuCashMobile is not GnuCash, it's some third party android
       | app.
        
       | brnt wrote:
       | Hold up. Did Gnucash get better reporting or did he make his own?
       | Last time I used Gnucash, which admittedly was 10 years ago, but
       | for a business, I found reporting and the lack of budgeting
       | lacking. The latter could be solved by envelopes (but I find
       | hacky), but the former only by learning Guile, something I was
       | and am not up to. Alternatives like Money dance have a more
       | complete solution, certainly for personal use, in my view.
       | 
       | I guess I'm asking what happened in the past decade to Gnucash ;)
       | 2014 is the last time I really used it, and reporting had then
       | not really changed.
        
         | jldugger wrote:
         | It did not get better. I am contemplating making a GNUCash
         | adaptor for Grafana.
        
         | igpay wrote:
         | The very first plot shown in the article was generated with
         | custom scripts, published here
         | (https://github.com/csun/simple_gnucash_budget_plots)
         | 
         | I'm not sure how much it's changed since 2014. I think the
         | "budgeting" system is still probably as bad as it was back
         | then, though (and by bad I mean not really applicable for
         | personal use, probably good for businesses). That's why I wrote
         | this budget plotting script.
        
       | BrandonBradley wrote:
       | Until the open source options have direct download options that
       | 'just work', Quicken is the best.
       | 
       | I've tried GnuCash and Skrooge, can't ever get the direct
       | downloads to work for more than two months without breaking.
        
         | Voyiatzis wrote:
         | Quicken died for me ten ir so years ago, as did many other
         | personal finance software applications. It is the syncing
         | between devices that's imperative these days, and this is where
         | Quicken is failing, especially when your database gets larger:
         | it syncs, but as your database grows its latency becomes ever
         | more apparent.
         | 
         | Quickbooks Online, which I have been using for a little over a
         | year, does syncing exceptionally well; but at the cost of a
         | polished UI.
         | 
         | Ideally I would love to be able to access my Quickbooks desktop
         | database using iOS or web, alas that's not doable.
        
           | zie wrote:
           | Quicken is out from under the Intuit Monster now, so it may
           | be worth looking at again.
        
       | briocheco wrote:
       | I needed a way to track my kids' allowance, so I built this
       | https://play.google.com/store/apps/details?id=com.fivesaver -
       | very simple and very free. Hopefully, not too massive-aggressive
       | self promotion:)
        
       | downerending wrote:
       | Related: Does anyone know of free-ish software to do cash-
       | flow/retirement projections, etc.? For example, I'd input some
       | guesses about income, 401ks, Soc Sec, rent, major necessary
       | expenditures, rates of return and inflation, etc., and have it
       | output balances for several decades. Extra credit for multiple
       | runs with random variation on assumptions.
       | 
       | I could write this myself, and have done a trivial one in the
       | past. Is there anything better?
        
         | ziga wrote:
         | https://www.firecalc.com/ is a good retirement calculator.
        
       | tmerse wrote:
       | The last time I used GnuCash, it was not able to import it's own
       | export. Does anyone know if this has been fixed?
        
       | cosmie wrote:
       | Firefly[1][2] is also a really useful personal finance app.
       | 
       | It's more akin to a self-hosted version of Mint. Combined with
       | the Plaid connector[3], I find it the easiest to use for my
       | workflow. And despite the instructions, you don't need a paid dev
       | account. The free Plaid account will let you access up to 100
       | live financial institutions.
       | 
       | [1] https://github.com/firefly-iii/firefly-iii
       | 
       | [2] Live demo: https://demo.firefly-iii.org/
       | 
       | [3] https://gitlab.com/GeorgeHahn/firefly-plaid-connector
        
         | dsd wrote:
         | I use this too. Maybe I like the beancount more, but having my
         | finances available on the web to share with my so is valuable.
         | Too many told are meant for one pers,on and don't support
         | modern ideas like tagging.
        
           | cosmie wrote:
           | The multi-user aspect is super handy.
           | 
           | It's also nifty that it exposes pretty much all of the
           | functionality via a REST API, complete with the ability to
           | manage OAuth clients/tokens. Not something I expected to
           | really leverage, but have been surprised how frequently it's
           | come in handy.
        
           | AdamGibbins wrote:
           | Have you tried fava recently? A web interface for beancount.
           | Its become very powerful in the past year or so, allows
           | editing etc too.
        
         | _Anima_ wrote:
         | I've used mmex for years and it's been not so stable recently
         | so I gave firefly a try.
         | 
         | There were too many simple use cases that could not be done
         | simply, compared to mmex.
         | 
         | One example is credit card partial chargeback/refunds. The dev
         | suggested to edit the initial charge and substract the refunded
         | amount. I dont want to do that. I like to keep a 1:1 mapping of
         | transactions.
         | 
         | Also income vs expense accounts, instead of payees. If Amazon
         | refunds me partially (let's say $10 from a $100 purchase) it
         | now creates an Amazon income account with $10. I had an Amazon
         | expense account of $100. Both accounts are not linked in any
         | way and it's impossible to know your Amazon balance ($90).
         | 
         | I buy a lot of stuff for my girlfriend and she pays me back
         | around the end of the month. Keeping track of her balance is
         | not possible with Firefly.
         | 
         | A few other things were not working properly or at all.
         | 
         | Dev is very nice and active but I doubt he has any accounting
         | background. Firefly turned out to me as a prettified excel
         | sheet, not a double entry book keeping.
        
       | monkeydust wrote:
       | I kinda want to try it but just not convinced I will see a good
       | return on my time esp with manual entry. I wish some of these
       | features were baked into my main bank account though.
        
       | cproctor wrote:
       | My partner and I have been tracking all our spending for the last
       | five years with hledger (ledger reimplemented in haskell) and
       | some custom import and management scripts inspired by "Full-
       | fledged hledger" [1]. More recently we added Plaid [2] for auto-
       | importing from financial accounts. I love having a plain-text
       | history and being able to ask complex queries.
       | 
       | One unexpectedly-sweet benefit is that your spending is a high-
       | granularity record of where you have been and what you have been
       | doing, encoding some signals you might not have thought to write
       | in a diary. Things like "that was when we were saving for our
       | down payment" or "I was going to coffee shops every day trying to
       | finish my dissertation" or "that was when we had a pandemic." I
       | enjoy looking back through our ledger the same way I enjoy going
       | way back in my gmail history.
       | 
       | [1] https://github.com/adept/full-fledged-hledger [2]
       | https://plaid.com/
        
         | karlicoss wrote:
         | also highly recommend its tui https://hledger.org/hledger-
         | ui.html
        
         | jibcage wrote:
         | +1 for full-fledged hledger! I just got it set up last week,
         | and putting together the small scripts for parsing all of the
         | CSVs was (to me) a fun programming exercise that reaped huge
         | visibility into how I spend my money :)
         | 
         | It's hugely valuable to have all of your financial data in one,
         | human-readable place. Not only to you, but to whomever might be
         | executing your will ;)
        
           | cproctor wrote:
           | Imagining my will as a poorly-documented API makes me feel
           | present stress on behalf of my unborn descendants :)
        
       | johanlarsson wrote:
       | A macOS and iOS alternative:
       | https://hochgatterer.me/finances/macos/
       | 
       | > No data is stored on servers, except when you enable Cloud Sync
       | to keep your data up-to-date on all your devices. In this case
       | the data is stored encrypted on iCloud.
        
       | TheApexTheater wrote:
       | Like many people here, I tried GnuCash. I enjoyed it, but when I
       | would import data from my bank, it would crash. That, and not
       | having any real way of categorizing my expenditures was annoying.
       | The other thing that annoyed me was not being able to select
       | multiple items
       | 
       | I recently moved to KMyMoney and everything just clicked. I found
       | the interface to be nicer, especially combining the filter
       | functionality with the ability to select multiple things and tag
       | them appropriately.
       | 
       | I appreciate the article trying to explain Double-Entry
       | bookkeeping, and I would suggest people look into KMM as an
       | alternative to GnuCash.
        
         | mtrower wrote:
         | No way to categorize your expenses? Could you elaborate and
         | compare to KMM? I've used both programs, so I'm curious which
         | of us is missing something.
        
       | pstrateman wrote:
       | Importing records in GnuCash is a pain.
       | 
       | Credit card payments end up with two records of the payment, one
       | from the credit card and another from your bank.
       | 
       | There's no way to merge records in GnuCash, ideally you would be
       | able to mark them as the same record, but keep them both to keep
       | the import logic happy.
        
         | jldugger wrote:
         | How are you doing this? The OFX import tool has a bayesian
         | matcher that will update and reconcile existing records, and
         | classify them based on past behavior.
         | 
         | The big challenge IMO is that each transaction has a date, but
         | sometimes the ends disagree on when it happened. E.g. you
         | transfer money from checking to a brokerage, it takes multiple
         | days but you have to choose one date for that transaction.
        
       | dang wrote:
       | See also:
       | 
       | 2019 https://news.ycombinator.com/item?id=20109545
       | 
       | 2018 https://news.ycombinator.com/item?id=16857884
        
       | spurdoman77 wrote:
       | I never understood the point of these personal finance apps. When
       | I run out of money I just withdraw a some more out of our familys
       | multimillion trust fund.
        
         | chad_strategic wrote:
         | are you looking for any relatives. :)
        
       | ISL wrote:
       | Does GnuCash integrate well with exports from credit-card
       | companies or banks? It seems like the big blocker is the time
       | spent logging transactions.
        
         | sjamaan wrote:
         | It supports imports from QIF and OFX/QFX files, CSV files,
         | MT940 and MT942 files and DTAUS files. It also has an "online
         | banking" integration thing, but I have no idea what kind of
         | bank has username/password logins that would work with this.
         | 
         | Personally, I don't mind manually entering the stuff, because
         | you'll need to classify everything into the correct accounts
         | anyway.
        
           | jldugger wrote:
           | > It also has an "online banking" integration thing, but I
           | have no idea what kind of bank has username/password logins
           | that would work with this.
           | 
           | That stuff is the OFX/QFX setup. Basically it logs in and
           | fetches those files for you. Banks are notoriously bad at
           | this however.
        
         | abdullahkhalids wrote:
         | Worked fine with my bank. I had to sanitize the csv file a bit,
         | which can be done with a simple script.
        
         | jdofaz wrote:
         | I always use QFX import and haven't had any issues
        
       | neogodless wrote:
       | > We don't care about how much money we've spent at Amazon
       | 
       | That's like, your opinion man. While I'm sure that's one
       | perfectly valid approach, I find a lot of value in knowing where
       | my money has gone beyond categories.
       | 
       | To make it more concrete, how much I spend at Amazon my Rewards
       | Visa determines whether the 2% bump in rewards is worth the cost
       | of Prime. (I know - most people find enough value in the videos
       | or not thinking about shipping. But I find that I simply spend
       | _more_ at Amazon when I have Prime, so I avoid having it!)
       | 
       | To counter myself, my own software is probably too granular and I
       | waste time on those little details of where I've spent money. I
       | could stand to simplify a bit.
        
         | igpay wrote:
         | And that's definitely an important shortcoming in GnuCash. I
         | don't know of a great way to deal with transactions that go
         | beyond "categories". You could use the description field +
         | custom reporting, but that seems a bit error-prone. Luckily, I
         | haven't run into many cases where I felt like I needed
         | something like this.
        
         | gen220 wrote:
         | You can track these kinds of things in GNU Ledger (cousin of
         | GNUCash)
         | 
         | The expense category is still something like
         | `Expenses:Books:SciFi`, or whatever. The payee for the
         | transaction is then `Amazon`. If you prefer to make the payee
         | the specific retailer that's selling to you, using Amazon as a
         | platform, you can do that, and instead "tag" the transaction
         | with `:Amazon:`.
         | 
         | You can also track points as a byproduct of the transaction,
         | but that's another rabbit hole.
        
         | UncleEntity wrote:
         | Last time I looked they seem to have a pretty decent python API
         | so splitting down transactions by retailer shouldn't take too
         | much python-fu methinks.
        
           | jldugger wrote:
           | na, the problem is the data doesn't commonly exist in the
           | model. If I buy a book from a local independent bookstore,
           | that's a debit on checking and a credit in the 'Books'
           | account. If--perhaps due to coronavirus--I buy the sequel on
           | Amazon, that again results in a transaction from checking to
           | books. The payee data isn't there.
           | 
           | I think you can do it via vendors but the small business
           | feature set is somewhat cumbersome.
        
       | elric wrote:
       | "Simple" is not an adjective I'd associate with GnuCash. Maybe it
       | is if you're coming from a background in accounting or have a
       | penchant for numbers. It's pretty complicated, and I wouldn't
       | recommend it to someone who just wanted to keep an eye on their
       | budget. A simple spreadsheet will suffice. Or any number of more
       | user friendly tools.
       | 
       | That being said, GnuCash is a powerful double entry book keeping
       | system which can almost certainly handle all your bookkeeping
       | needs. But simple, it is not.
        
         | holri wrote:
         | Double entry booking is complicated but it pays off to learn if
         | also for personal finance because errors are much less likely
         | than with a spreadheet.
        
           | ahnick wrote:
           | This is commonly stated, but I found it relatively
           | straightforward once I saw the _extended accounting equation_
           | (https://en.wikipedia.org/wiki/Accounting_equation) and knew
           | every entry needed a corresponding entry to make the equation
           | balance.
           | 
           | Assets = Liabilities + Equity + (Income - Expenses)
           | 
           | For some reason the (Income - Expenses) part gets left off in
           | many introductory explanations of the accounting equation. I
           | think that leads to a lot of confusion about how to treat
           | Income and Expense accounts in programs like GnuCash for
           | newcomers to double entry accounting.
        
         | igpay wrote:
         | I also wasn't super sure about sticking "simple" in the title,
         | but while writing this article and going through the GnuCash
         | setup steps, I actually started to feel like it was
         | appropriate.
         | 
         | As another commenter mentioned, I think that the "complicated"
         | part of using GnuCash is understanding double-entry
         | bookkeeping, which is why I devoted so much time in the article
         | trying to explain it in concrete terms. My intention here isn't
         | necessarily to steer people to GnuCash itself (I'm learning
         | about a lot of alternatives from these comments), but to
         | simplify the core underlying concepts. Not sure if I achieved
         | that, but I tried!
        
         | nicolaslem wrote:
         | It is not that hard, I followed a Youtube tutorial and about a
         | week later things clicked in place for me. I am glad I put the
         | effort because I feel that I've gained a skill that will change
         | my approach to money for the rest of my life.
        
         | pmoriarty wrote:
         | Given the typical audience of HN.. if you already know how to
         | program you already know how to use something that's way more
         | complicated than GnuCash.
         | 
         | GnuCash is very simple if you already know double-entry
         | accounting... and learning double-entry accounting would
         | probably be the work of a weekend or less for anyone who knows
         | how to program. Not hard.
        
         | CobrastanJorji wrote:
         | The first time I tried to use GnuCash was many years ago. I
         | began by opening up the documentation and reading the overview,
         | which, it turned out, began with a fairly lengthy history of
         | the practice of double-book accounting. I later found that this
         | choice, which isn't necessarily a negative, did a fair job of
         | representing GnuCash as a whole.
        
         | jldugger wrote:
         | I've been a longtime GnuCash user, and really it's as simple as
         | you want it to be. You can, for example simulate the
         | Spreadsheet approach with 3 accounts: Checking, and two hidden
         | accounts: Income and Expenses. Make Checking the default tab,
         | hide a few columns you're basically done. And if you decide you
         | need a more complicated model, all those extra features are
         | there and available on your schedule.
         | 
         | Probably the biggest hurdle IMO is the single user nature. Even
         | the SQL backend requires a global lock.
        
       | lifeisstillgood wrote:
       | 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 matters if I have trouble with the
       | real problem - sticking to a budget. Solving that one is what I
       | want personal finance apps to help me with. Keeping track of my
       | finances should be a solved problem, locked in a box and
       | forgotten about.
        
       ___________________________________________________________________
       (page generated 2020-05-19 23:00 UTC)