Live data from Hacker News

GnuCash 5.9

gnucash.org

141–150 of 179 posts

Re: GnuCash 5.9

#141
post #140

Earlier quoted context omitted.

The other person said GnuCash has a scripting engine. These are just scripts. Not the same thing.

These are examine scripts for a REST API that gives access to internals of GnuCash.

Oh ok. I will have a look, thank you!

Does it allow setting values, or just reading?

Re: GnuCash 5.9

#142

Earlier quoted context omitted.

I don’t disagree with you, but I’d suggest that the accounting knowledge is pretty easy to pick up, and getting that under your belt will actually be incredibly valuable

Do you have any tips on where to start?

It was several years ago I’ve read it, but GNUCash’s documentation does actually start with some generic accounting knowledge, which I have found quite useful at the time.

Re: GnuCash 5.9

#143

I 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…

Cool, thanks for sharing, but is there no better way to automate GnuCash, eg with a Bash or Python script?

Re: GnuCash 5.9

#144
post #54

Earlier quoted context omitted.

How is SQLite DB simpler than a human readable markup language?!

If you intend to read it by human eyes, you're right. That seems like a rare edge case though. If you want to interact with the data outside of the software, the common case is you're writing some script for that, in which case being able to use SQL is much easier.

Being familiar != simple.

Sure, more people have used SQL, but it’s definitely not impossible to just query XMLs. Hell, if someone has written JS they are likely familiar with DOM manipulations, which are more or less the same.

Re: GnuCash 5.9

#145
post #57

GnuCash is solid. One thing that I love: I have full control over my data, and its stored as a simple xml (also supports SQLite, but why use more complex when simpler works just as well?) I have a few (comparatively minor) complaints about GnuCash, but they're around UI. Things like: it would be nice to assign all matching (eg Regen) transactions to a selected account, and stuff like that. But overall, having somethi…

XML is human readable, but barely. I do not trust any executable other than SQLite, postgres and a few others to correctly manage state on disk without corrupting it.

Arguably, XML’s schemas are better than SQLite’s constraints, especially in this domain.

Re: GnuCash 5.9

#146
post #3

I 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 like that I can version control the GNUCash XML file, and edit it by hand when needed while still having a GUI for entry.

Re: GnuCash 5.9

#147
post #92

I kind of surprised to see lots of hatered to GnuCash. What are your usecases? I run cafe business in Japan, but it does everything I need.

Don't you have to buy some Japan specific software like Freee for the e-Tax integration? I like GnuCash, but for a business, it doesn't automatically handle sales/consumption tax, or employee payroll withholdings, you'd have to manually make splits in every transaction for that. (Actually I think you all don't have to keep your consumption tax received in a separate account bc you net it out against purchases, but in…

Can't speak of Japan, but where I've lived the percentage of tax is calculated against total sales, you don't need it separated beforehand

I believe there are some exceptions, with regulated or specially taxed goods like cigarettes, but there was none of those where I worked so it's mostly speculation

Re: GnuCash 5.9

#148
GnuCash is really nice, and eventually it would have been my end game, but at some point numbers didn’t end up.

Everything was recorded correctly, but reports would show wrong numbers.

After migrating from GnuCash to beancount, I realized that some transactions where recorded with invalid currency conversion rates.

As someone who relocated recently, manage money in at least 3 currencies, and have an online business, I can’t handle it. I need everything to be explicit in order to avoid mistakes.

Re: GnuCash 5.9

#149

GnuCash is really nice, and eventually it would have been my end game, but at some point numbers didn’t end up. Everything was recorded correctly, but reports would show wrong numbers. After migrating from GnuCash to beancount, I realized that some transactions where recorded with invalid currency conversion rates. As someone who relocated recently, manage money in at least 3 currencies, and have an online business,…

plaintextaccounting to the rescue

Re: GnuCash 5.9

#150

I 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…

We used GNUCash for a few years for small business accounting. After a while we migrated to Quickbooks Online as it has some features that GNUCash was missing, e.g., automatically pulling in PayPal and bank transactions and inventory management. This turned out to be a very frustrating experience. Due to the following:

- The price increased every year. We started at about $60/month and after a few years it $80/month. Today the same plan is $99/month.

- The PayPal integration randomly stopped working and was missing transactions. QB customer support was completely useless and we spent hours searching and manually adding transactions. The bank integration (via Plaid) was also not reliable.

- The inventory management is very limited. E.g. you can't repack/combine items without using weird hacks.

So, after a few years I got very frustrated and ended up moving to ERPNext. Migrating all the data was quite a bit of work and involved a number of Python scripts to pull out the data from QB and re-create it in ERPNext, but after about a week we had 5 years of data migrated.

ERPNext is not perfect, but works quite well for us. A big difference to QB is that it supports inventory and manufacturing operations. It also has an API that is fairly easy to use and we use it to get transaction data from PayPal and Stripe.

Post reply on HN