Earlier 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.
XQuery is easier and can be fun to use!
GnuCash 5.9
121–130 of 179 posts
Re: GnuCash 5.9
#122I use GnuCash for the accounting of my hackerspace. It was either this or a site called "wave" which the treasurer of a nearby makerspace recommended. After signing up for wave and playing around, I still wasn't sure. A few weeks later I decided I would use wave, but then I found they had locked my account for no reason. GnuCash it is! It's good software! I eventually wrote code that dynamically links with the libgnu…
Interesting, can you share the code?
Re: GnuCash 5.9
#123How come no one mentioned ERPNext.
It's open source, can be self hosted, free and biggest growing software in the market. It also scores high on user recommendations.
I switched from GnuCash to ERPNext and it has been a blessing.
Re: GnuCash 5.9
#124I'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…
Would only work for Lidl, but I wonder if there's anyway of pulling the data using the APIs that they use for the Lidl Plus app. The Lidl Plus app contains a digital receipt of every shop you've done with them.
Not something I've looked at and specific to Lidl but if you shop there regularly it might be worth trying.
Re: GnuCash 5.9
#125Earlier 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?
India had / has a bunch of indie vendors of small financial accounting packages (that's what it is called here), some years back and for quite a while before that. When a new Indian software product company starts up, this is often the field they enter first, partly because the domain knowledge is widely available via chartered accountants and is fairly standardized, I think. Not an expert in the field myself.
I don't know how many there are nowadays, but my guess is that they must be at least a few of them, still, if not many.
Tally was one of the more successful ones and is still around. I heard someone talk about it the other day.
I am talking about the small businesses sector.
Larger companies tend to use ERPs, either commercial or home-grown. There are even some indie vendors in this sector.
Re: GnuCash 5.9
#126I tried it years ago but finally settled on HLedger. Like GnuCash, I own and control my data, but with HLedger I have an ability to go in and correct or change something (and not in a "accounting-appropriate" way) in bulk just by editing it in Sublime Text. Then again, my use case is pretty basic and not mission critical so YMMV.
I actually run a little script that converts the gnucash xml to ledger[0] and keep that (and the original xml) tracked in git. Run that fairly regularly while entering into gnucash ui and I have an easily readable git log/diff of my changes. But it's missing the "bulk change" ability, yes. (The gnucash is just xml so one could edit that, I haven't dared to yet.)
[0] based on https://gist.github.com/nonducor/ddc97e787810d52d067206a592a...
Re: GnuCash 5.9
#127As a freelance consultant from Sweden I looked at GnuCash several times over the past 10+ years but it was always the same issue.
It's not tailored for our economy and our revenue services.
Here in Sweden if your revenue is below 3 million SEK/year, then you can use "simplified bookkeeping" (rough translation of "förenklat årsbokslut").
In practice it means I could write a very basic program to manage my expenses and income and just have it generate all the necessary numbers that I then enter manually into our revenue service's online app every year.
Re: GnuCash 5.9
#128I've used Gnucash for my personal finances for 15-20 years, except for some periods (e.g. a few years where I was unemployed and depressed). It gives me great control of every cent, I know exactly what I've spent where, and I even use it to plan ahead. I 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 i…
> I enter each transaction and link it to the scanned receipt
How do you link transactions to receipts? The one that's on right-click and "Update Association"? When I tried that, I found it way too cumbersome, I feel like I should be able to just drag-and-drop a file onto a transaction. (I know I can set up keyboard shortcuts to open the dialog, but drag-drop would be so much simpler.)
In an ideal world, when drag-and-dropping a file onto a blank line, gnucash would run tesseract or something and extract the date, amount and summary ... one can dream.
Re: GnuCash 5.9
#129I use GnuCash for the accounting of my hackerspace. It was either this or a site called "wave" which the treasurer of a nearby makerspace recommended. After signing up for wave and playing around, I still wasn't sure. A few weeks later I decided I would use wave, but then I found they had locked my account for no reason. GnuCash it is! It's good software! I eventually wrote code that dynamically links with the libgnu…
Interesting, can you share the code?
Sure: https://github.com/blackle/GnuCashAutoInvoice/tree/main
It's kinda a mess tbh, and it actually also requires some non-exposed symbols to work properly, so it needs access to the GnuCash source code. I wouldn't recommend doing this unless you're ok with maintaining your own unsupported GnuCash feature.
Re: GnuCash 5.9
#130I'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…
Frankly the easiest way seems to be apps that parse your sms messages in your phone and build up an expense report out of that. Many people here will balk at this, but it takes a lot of effort out of keeping expense reports.
I haven't gotten a single bill over SMS, is this an US thing?