Hi John,
Well, I did some work building an open source Java Accounting Model (
adligo.org) a few times of the past two decades. Now I find my self using
QuickBooks online, so I have been looking for some collaborators and
gnucash seems like the most successful project out there. The enriched
Scott,
No, accounting software isn't a fancy spreadsheet. The math part is a lot
simpler, but accounting is all about rules. The rules part is harder. That's
not to say that you can't use a spreadsheet to do your accounting, lots of
people do, but a relational database approach is a much better
The SQL Schema is laid out in https://wiki.gnucash.org/wiki/SQL. There's an
attached ERD, but note that it shows secondary keys and auxiliary tables that
indicate how GnuCash treats the data once it's loaded. The actual schema
defines only a few secondary keys and the data represented in the aux
