Love Gnucash... allows me to look at my expense history for more than a decade. I think it would benefit from some changes in the next major version though - the GL of account is good but requires a lot of work for example to track vendors. If I want to track where I'm buying my groceries I have to create separate account for those, rather than being able to optionally specify vendor.
GnuCash 5.9
111–120 of 179 posts
Re: GnuCash 5.9
#112Earlier quoted context omitted.
I agree with bdjsiqoocwk that XML is way simpler than SQLite. In the case where I'm making changes by hand, it's much easier to open an XML file in a text editor and edit it, than it is to figure out an SQL query to do the same thing. In the case where I'm making changes programmatically, libraries will handle the complexity of XML for me, but I will still have to struggle through figuring out an SQL query if I'm try…
Disclaimer: no stats I bet if we do a random poll of the people here, more people would be comfortable writing a SQL query then doing xpath processing to query the same data.
Re: GnuCash 5.9
#113I use GnuCash for business accounting and it does what I need. I don't use QuickBooks as VC's recommend in blog posts. QB has some convenient features, but that is not enough for me to pay the price QB is asking. I don't need VC money or a CPA. I haven't tried using GnuCash with Sqlite, but I would like to experiment when I get the time. Is it reliable? I used to be a technical/functional engineer for Oracle EBS, so…
It's great for personal or very small businesses but god help you if you are building a real startup with GNUCash. I am speaking from experience here, GNUCash zealotry is a plague. I honestly wish this project basically did not exist, because the business world despises GNUCash, ONLY cares about QuickBooks, and using anything else is a giant waste of everyone's time. Believe me, I have been fighting this fight in non…
It depends on geography. According to Codat's 2021 report [0] on SME accounting market share:
- In the US, QuickBooks is the clear market leader, with 75.7% combined market share across their three main offerings (QB Online, QB SE and QB Desktop). FreshBooks is in second place at 4.5%, and Wave and Xero equal third at 3.5% each
- In the UK, Sage is the market leader, with a combined market share of 28.8% across their three main UK products (Sage 50/50 Cloud, Sage Accounting, and Sage 200cloud); QuickBooks combined market share (Online+Desktop+SE) is closely behind, in second place at 26.2%; and Xero is in third place at 24%
- In Australia + New Zealand, Xero is in first place at 49.4% market share, MYOB in second place at 33.8%, QuickBooks comes third at 11.2%
- In Canada, QuickBooks is the clear market leader with a combined market share of 68.2%; FreshBooks is in second place at 6.9%; while Sage at 6.4% is in third place. Kashoo comes fourth at 4.3%, and Wave, Xero and Logiciel Actiff are equal fifth at 3.8% each.
So, it is really only in North America that "no one can use anything but Quickbooks" is remotely true – and even there, close to 25% of US SMEs and over 30% of Canadian SMEs are successfully using "something other than Quickbooks".
But I agree it is likely true, that for the vast majority of US small-to-medium businesses, GNUCash is not a realistic alternative to Quickbooks. But what about FreshBooks or Wave or Xero? Or the dozen other commercial accounting software vendors with some presence in the US market?
[0] https://www.codat.io/wp-content/uploads/2021/02/Codat_Global...
Re: GnuCash 5.9
#114I use scheduled transactions for all my fixed expenses, and Gnucash enters them 100 days in advance. I manually enter my income, usually also 3 months in advance. My income is very predictable, but can of course vary a little. I then plan out how much to transfer on payday to my debit card account, my bills account, my savings account, etc. I enter any "random" bills (variable or unexpected expenses) as they show up. This allows me to see, in Gnucash, quite exactly how much money I'll have available at any point in time the next 2-3 months.
I keep every receipt for things I buy during the week, and every Sunday I have a routine. It's become a bit overkill, but I enjoy it. First I scan the receipts with a scanner app on my phone. Then I sync the scans to my computer using Syncthing. Then I enter each transaction and link it to the scanned receipt. My hierarchy of expense accounts are reasonably detailed, I'd say.
I've gone so far as to program useful shortcuts into a numpad, to make this process even easier. So for example, instead of Ctrl-A or whatever is the default for linking a transaction to a file in Gnucash, I have one convenient button on the numpad. Other buttons select different transaction views. For a while I even had a setup where I could RDP to a docker container with Gnucash, so I could use it while at the office. For this I'd also use Syncthing to sync my gnucash data between my desktop and the container.
Is it overkill to scan every grocery receipt and whatnot? Yes. Do I need all this historical data? No, not really. But it's somewhat interesting to scroll 3 years back and look at some random dates to see what I bought and what prices were like. It's also useful for tax purposes. And I'm a bit of a data hoarder ;) (I should add that I don't always keep the receipt - I often pay with Google pay and then if it's just food or coffee or something simple like that I just keep the notification until I can enter the transaction in Gnucash.)
The biggest thing this setup gives me is great peace of mind. I've struggled with anxiety and depression, and I've lived through times where I've had credit card debt and very little income, so money has been a big stressor at times. Now I have a reasonably well paid job in IT and no debt except student loan, so I could probably live well without Gnucash, but it's still a source of mental well-being, even comfort. I enjoy my weekly routine and micro-managing my money. Sometimes I just open Gnucash to look at how well I'm doing financially (not wealthy by any means, but my net worth is at least in the positive). Gnucash was also great for planning how to pay off my credit cards.
Re: GnuCash 5.9
#115I've tried many personal accounting software and all of them (but old Pcoket Money for PalmOS!) are very unhelpful in filling in expenses. If you need to record whole shop visit as one transaction (like "Food at Lidl") it is tolerable, but as soon as you want to enter each line in your receipt as separate part of split transaction (like, food:milk = 2 euro, food:bread = 1 euro, food:eggs = 3 euro, food:meat:pork = 8…
Re: GnuCash 5.9
#116Earlier quoted context omitted.
It's great for personal or very small businesses but god help you if you are building a real startup with GNUCash. I am speaking from experience here, GNUCash zealotry is a plague. I honestly wish this project basically did not exist, because the business world despises GNUCash, ONLY cares about QuickBooks, and using anything else is a giant waste of everyone's time. Believe me, I have been fighting this fight in non…
> We live in a world where Intuit has fought VERY hard to make damn sure no one can use anything but Quickbooks It depends on geography. According to Codat's 2021 report [0] on SME accounting market share: - In the US, QuickBooks is the clear market leader, with 75.7% combined market share across their three main offerings (QB Online, QB SE and QB Desktop). FreshBooks is in second place at 4.5%, and Wave and Xero equ…
And even this post only lists English-speaking countries, as the Babylonian barrier is impenetrable. Who knows what happens in these strange places where people communicate in unknowable sigils?
Re: GnuCash 5.9
#117Earlier quoted context omitted.
True, but I don't want to. And that is the biggest barrier of all.
I was going to say what GP said, but, yeah, XSLT is just no fun to write by comparison to SQL.
Re: GnuCash 5.9
#118Earlier quoted context omitted.
> Suppose you don't have SQLite, how do you open a SQLite database? The only way is you have to re-implement SQLite from scratch. Good luck with that. Or, you know, install SQLite. Although it is so ubiquitous that it is almost certainly installed already. Even on a mac it's there already. Or if you are on some system where it is not, a single package install away.
Yes, I know what to do. Doesn't change the fact it's more complex. In fact, any database is more complex than a text file. You sound like the kind of person to push at work for a database when a file would suffice, introducing needless complexity.
This statement is true, at a very superficial level. But it is missing all the nunace that goes into why would someone be using this file.
Are you comparing opening a text file in a text editor vs. opening the db.sqlite file in a text editor? Yes, of course the text file is more usable.
But what is the use case of just staring at the file? I can't imagine any.
If you are someone who wants to programmatically use the contents of that file (outside gnucash application), surely you are writing code to process the data. And thus, being able to use SQL is massively more convenient.
Re: GnuCash 5.9
#119It's good software! I eventually wrote code that dynamically links with the libgnucash library so I can auto-generate monthly invoices for the member's dues.
Re: GnuCash 5.9
#120Earlier quoted context omitted.
> We live in a world where Intuit has fought VERY hard to make damn sure no one can use anything but Quickbooks It depends on geography. According to Codat's 2021 report [0] on SME accounting market share: - In the US, QuickBooks is the clear market leader, with 75.7% combined market share across their three main offerings (QB Online, QB SE and QB Desktop). FreshBooks is in second place at 4.5%, and Wave and Xero equ…
Come on, of course Hacker News is a local Bay Area forum, nothing happens beyond Bay Area ever. /s And even this post only lists English-speaking countries, as the Babylonian barrier is impenetrable. Who knows what happens in these strange places where people communicate in unknowable sigils?
Also your accountant will universally have a bizarre custom font for Vietnamese characters, that they downloaded ten years ago from a now-defunct forum. It will never correctly transcribe into any other font, and they don't know how to change it. If I switch accountants, it's always a different cursed font. This is a great and enduring mystery.
So I keep a second set of books -- GnuCash is fantastic for this, but I've also used QuickBooks sometimes. Then I use that to make sure the accountant is producing something that at is at least adjacent to reality. I'm audited by law every year (at my own expense), and they only support spreadsheets.
Surely one day soon this will change (except the font thing I bet), but for now I thought you might get a laugh out of this little slice of my life :)