Please see the sourceforge info site for screen shots and download links.

GnuAccounting

GnuAccounting is a open source java accounting software that creates and administrates e.g. invoices and credit notes. It embeds OpenOffice to design templates and output invoices and uses MySQL or OpenOffice's HSQLDB to store transactional metadata on a central server or on the client computer.

News

0.6.2, 2008-09-07

Refactorings:

  • require libchipcard config for HBCI usage
Bug fixes:
  • quantity 1.11 gets senselessly floatpointed
  • personal drawings and credit memos share credit memo index (in numbers&formats)
  • mysql corrections
  • Transaction selection showed credit memo for personal drawings
New features:
  • move to swt 3.4
  • be able to start shell script from any location
  • database to support vouchers and contact bank information
  • support account short description (title) in database
  • add database field for incoming or outgoing numbers
  • configure script (installable version!)
  • check bank account/code correctness
  • support HBCI in balance window

0.6.1, 2008-07-24

Refactorings:

  • removed the need for the refresh button in accoutingEditWindow
  • reorganize about window
  • minor other refactorings
Bug fixes:
  • wrong root document error when saving settings
  • send invoices by email always shows customer had no email address
  • correctly calculate VAT to announce when 2 taxes refer to the same tax IDs
  • period end not to be included in account listing, otherwise e.g. VAT announcement for june includes july 1st.
  • fix windows compile classpath problem
New features:
  • open business data exchange
  • hide SMTP password when entering via dialog
  • makefile
  • HBCI account import
  • support HBCI chipcard settings

0.6.0, 2008-06-22

Changed from alpha to beta development stage.
Refactorings:

  • merge source, binary release
  • subversion directory changes (/gnuaccounting -> /trunk, added /branches, /tags)
  • remove community window remnants
  • use centralized default font instead of decentral bitstreamverafonts
  • distinguish between appLayer, GUILayer and dataLayer
Bug fixes:
  • 7% VAT get floatpointed to 7.000000000000001
  • allow german 7% VAT booking in vat announcement
  • windows do not open in correct sizes
  • due dates not calculated correctly
  • two-digit month, day numbers in transaction number
  • Stabilization!
  • VAT should default-select some credit&debit accounts (otherwise null pointer exception after saving TAX after clicking new tax)
  • Windows:can not select products in transaction creation wizard
New features:
  • store phone&fax for contacts
  • have a help window
  • enable help
  • support VAT IDs for contacts (reqd' for credit memos)
  • support personal drawings

Source forge page

For download links, additional information, screen shots and such please refer to the project's info site on Sourceforge.

SourceForge.net Logo

How to install/uninstall this thing

Installation

Uninstall

rm -r <the directory in which e.g. gnuaccounting.sh is located>
rm -r ~/.gnuaccounting
If you used MySQL instead of the default HSQLDB:
mysql --user=root --password=<your mysql root pwd>
mysql> drop database gnuaccounting;
mysql> delete from mysql.user where user='gnuaccounting' and host='localhost';

System requirements

OOoOpenOffice.org 2.x
Javarecommended 1.4.2 or higher, NOT 1.3.1 or 1.4 (due to Transparent Use of Office UNO Components)
MySQL
  • 4.0
  • Connector/J required for MySQL use

History

0.5.7, 2008-05-04

Bug fixes:
Fixed the last known 0.5.5 regressions

  • refresh button in accounting edit does not refresh added entries properly
  • in bookkeeping add window: voucher column does not keep entries
  • in bookkeeping add window: VAT "received" and "spend" is missing
  • in bookkeeping add window: <please select> entry is missing
  • 0.5.5 regression: VAT announcements do not seem to have the right values
Additionally
  • in bookkeeping edit: can not deselect entries
New features:
  • use datetime control in accounting edit and accounting add window

0.5.6, 2008-04-13

Bug fixes:

  • fixed 2 of at least 6 regressions in gnuaccounting 0.5.5 (if you are affected, please use 0.5.4)
  • export spread sheets grouped by accounts did not respect period start/end dates
New features:

0.5.5, 2008-03-24

Refactorings (under the hood):

  • mysql jdbc driver now in libs
  • refactored numbersWindow&new client&application class
Bug fixes:
  • tons of MySQL fixes,
  • load the correct transaction template,
  • corrected removeItemButton in new transaction wizard,
  • correctly load transactions,
  • use only one number per selected transaction type
  • dont show VATs in accountingEditWindow
  • use only one number per selected transaction type, dont show VATs in accountingEditWindow
New features:
  • ability to automatically create databases
  • be able to book own transactions (e.g. invoices) correctly also in accountingedit, not only in balanceWindow

0.5.4, 2008-03-02

Resolved a relatively heavy bug in the bookkeeping part.

0.5.3, 2008-03-02

Refactorings (under the hood):

  • productsWindow,
  • contactsWindow,
  • taxesWindow,
  • accountsWindow,
  • less database redundancy
Bug fixes:
  • Fixed a split-booking bug
New features:
  • "Export journal" (now "Export as spread sheets") shows account balances in account list
  • "Export as spread sheets" new sheet for account statements (journal grouped by account)
  • prepared I18N,
  • sending transaction vouchers (.pdf) via email is now possible,
Remarks:
  • If used with caution, the bookkeeping part now works, at least I was able to book the year 2007 of my business

0.5.2, 2008-01-28

0.5.2 adds the ability to change booked entries and the template designer for the first time allows to have items in tables. Additionally, the templates are now based on OpenOffice.org placeholders instead of proprietary, text-based ones.

0.5.1, 2007-12-22

This release fixes some problems in the linux version (the template designer with GTK2 is still problematic but there is a workaround), makes use of the embedded Firefox (XULrunner) for the first time and allows for formatted text for items in the templates.

0.5.0, 2007-12-08

Overhaul:
The template designer has been overhauled, now it allows to design header/footer and items in a single template.

New features:
Firefox integration has been prepared, Gnuaccounting now allows for Karm (timetracker) import and Winston (german electronic tax declaration) export. It's now possible to specify a timeframe in "export accounts" and the T-accounts now have cell borders. A single, cross plattform font has been included (Bitstream Vera) to overcome rendering problems on some plattforms. When creating a transaction, it's now possible to choose a date.

Bug fixes:
Moneyplex import, bugs in the accounting logic, I finally found a work around for a very old bug in the template designer, performance increases when reading XML files etc...

0.4.4, 2007-10-18

Some bugfixes (important ones too), some improvements and some new features like rudimentary support for offer, cancelations and reminder transaction types.

I will try to improve usability and user-friendlyness of the template designer drastically in versions >0.4.5 since although one of the two big bugs in the template designer has been fixed but it's still almost impossible to work with the remaining bug and even if it worked it's almost unusable.

Please remove or rename the ~/.gnuaccounting directory of former versions before installing this update.

The changes in detail are:
some code cleanups and bugfixes (bugs 1804084,1796610,1804256), transaction remarks (1804706), autorefresh todo items (1804646), add transaction type offer, cancelation, reminder (1804086, 1804088, 1804087), default for products (1799636)

0.4.3, 2007-09-15

This release is an overhaul which removes some old things which should have gone long ago (e.g. a way to book called "continuations") and introduces some features which should have been introduced long ago. It's now based on SWT 3.3 (Eclipse Europa) and NOA 2.0.9.

The items in detail were: code cleanups(bugs 1756730,1762621,1781961,1781967,1790963), now using SWT 3.3 (1762622) and NOA 2.0.9 (1762623), datepicker in balancewindow(1757811), dropped recordswindow and 'continuations'(1735535), credit memos are now automatically booked(1781964)

By default, this will install a new database file due to changes in the internal structure.

0.4.2, 2007-07-18

The bookkeeping now imports Starmoney data (bug 1745973), accounts can now be edited (bug 1735538) and the todo-button is now more than just the old records view (bug 1735534): It now shows e.g. installation tasks and invoices to balance. The "Customers" menu is now renamed Business Contacts and can also cater suppliers (bug 1754779). Transactions (at least invoices) are now automatically booked (bug 1754782) (with default VAT). Some changes and bug fixes under the hood (bugs 1749913, 1749917, 1754794, 1755460, 1755461).

I'm removing the "old way" of booking (continuations) completely, so all transactions which are not invoices currently won't work. Particularly, the automatic booking of transactions upon their creation is a very experimental feature and will be stabilized in following versions of the 0.4.x line.

0.4.1, 2007-06-17

Introduction of a database versioning (bug 1738616) and VAT-based split entries (1736061). Usability improvements (1735542, 1734376, 1734372, 1734370, 1734369 and 1734368).

0.4.0, 2007-06-08

GnuAccounting is now a portable application and introduces the first bookkeeping features. Additionally, an import for Moneyplex has been added.

Please have a look at the release notes and the change log for details.

0.3.9, 2007-04-04

One minor, one critical fix and one new feature: bugs 1694463, 1694464 and 1694468 respectively. The new feature is: be able to load transactions from records, this can e.g. be used to create an invoice from an offer.

0.3.8, 2007-01-14

This is a minor bug fix (bug 1626141). When the product or number of items are now changed in the wizard to create new invoices (credit memos etc.) the new total (per item) gets updated already in the wizard not only in the final invoice.

0.3.7, 2007-01-02

This release now makes HSQLDB, the database embedded in gnuaccounting, usable. Previously only MySQL would work and you could not insert/edit products or taxes with HSQLDB. Additionally, now changes on the transaction document in the preview part of the wizard are no longer discarded.

If you are using HSQLDB, please delete your ~/.gnuaccounting/ dirctory to upgrade.

0.3.6, 2006-12-29

Gnuaccounting now uses SWT 3.2, the windows version should now be fully functional again (yet another Windows-related bug fix) and printing now works again.

Finally the complete configuration has be refactored, that means that important errors may now block the user (e.g. please select your OpenOffice.org path) and Gnuaccounting will now no longer require a restart after the first configuration.

PS: good news, there was a bug in KDE and Gnome e.g. in SuSE 10.1 which troubled the OfficeBean (the embedding of OpenOffice.org) and which seems to be resolved in 10.2. Also, GnuAccounting is now completely Eclipse-3.2 (you can use the one that ships with OpenSuSE 10.2) based.

0.3.5, 2006-11-11

The starter/splash screen was redundant since 0.3.4 and now was removed. HSQLDB-shutdown is now clean, the lockfile now gets removed upon application shutdown.

Known bugs: Since 0.3.4 GnuAccounting starts again in the proprietary MS Windows (r)(tm) operating system but transactions, e.g. invoices, seem to suffer another bug.

0.3.4, 2006-11-04

Fixed problem starting GnuAccounting in the proprietary Microsoft Windows (r)(tm) operating system. Despite previous doubts, GnuAccounting seems to run at least in SuSE 10.1's KDE unaltered.

The only changed (besides the version number) was to change the windows batch file to

java -Djava.library.path=. -cp "./org.eclipse.core.runtime_3.1.0.jar; ./swt.jar;./org.eclipse.jface_3.1.0.jar; ./swt.jar; ./noa-2.0.jar; ./unoil.jar; ./ridl.jar; ./hsqldb.jar; ./bion_officebean-2.0.jar; ./juh.jar;./bion_jurt-2.0.jar; ." gnuaccounting/gnuaccounting

0.3.3, 2006-11-03

This release uses the Nice Office Access library (NOA) instead of accessing OpenOffice directly: this e.g. eliminates the need for a starter application since NOA features setting the OpenOffice.org directory at runtime. This also improves windows compatibility.

Some other bugs have been fixed as well, e.g. canceled OpenOffice.org operations no longer result in zombie documents.

0.3.2, 2006-07-20

0.3.2 Now has a starter: What seems like a splash screen will read the configuration for the openoffice path and let you specify one if not yet available. This eliminates the need for passing the OOo directory as parameter to the application.

0.3.1, 2006-04-04

0.3.0 failed the smoke test, so this is a version which will also install without a former installation.

0.3.0, 2006-04-02

MySQL is now optional, the HSQLDB that comes with OpenOffice.org can be used. That means it is no longer required to download and install MySQL and the JDBC driver. Also, HSQLDB, if used, will create data files that can be easily backupped. The drawback is that HSQLDB will allow only one instance of GnuAccounting to run at the same time.

0.2.1, 2006-02-19

Sorry guys -- 0.2.0 would not start if no prior version created a config file. 0.2.1 fixes this bug. Besides: the new screenshots (which were already available for 0.2.0) give you an impression of the new SWT look&feel.

0.2.0, 2006-02-12

After 0.1.4 and 0.1.5 with minor bugfixes, 0.2.0 is a major rewrite in Eclipse using SWT instead of AWT. This removes some of the most uncomfortable shortcomings in the UI, like absolute positioning in the transaction-compose window.

The binary can be used in Linux and Windows (r)(tm), for other operating systems that support both SWT and OpenOffice.org, like Solaris, it should be fairly easy to run by adding the corresponding SWT classes and libraries.

0.1.5 I already called Windows-compatible, nevertheless, a small bug-fix now also allows OpenOffice.org to be installed in a path with a space, e.g. "\program files\openoffice.org 2\".

I do not consider 0.2.0 to be ready for productional use but it marks the milestone where the proof-of-concept evolves into an actual alpha version.

Have fun!

0.1.4, 2005-09-12 This version now compiles with OpenOffice 1.9.122. Please let me know it it also runs with other, especially older versions of OO. There now is a batch file intended for windows, but I did not get it running (let me know if you have a version within windows), I suspect the JDBC classloader might not be working, I will check this.
0.1.3, 2005-09-11Minor bug fixes, now compiles also for OpenOffice 1.9.122, preparations for windows version.
0.1.2, 2005-05-26Deletion that lead to inconsistent application now no longer possible, default templates are copied instead of generated (less error-prone, more user friendly and better customizable), there now is form to change numbers (e.g. invoice numbers), formats and some data about transaction types, e.g. invoice with IN- can now be translated into the german Rechnung with RE prefix.
0.1.1, 2005-05-17Fixed some bugs, e.g. the possibility to delete the last product/customer/vat id: one of each is needed to flawlessly run GA. Please use a new database to start this. Reason is a new feature that after changing an entry, only new transactions will be affected.
0.1.0, 2005-05-09completely migrated from OOo 1.1.x to OOo 2.0 (no backward compatibility), database is created on demand by configuration frame, sample customer, products, value-added-taxes and invoice/credit-memo templates are generated upon installation. All of these things greatly improve the installation process to almost a out-of-the-box-procedure on the preferred OS, SuSE 9.3. Another new feature: transactions are not only saved as ODT but also as PDF-file.
0.0.9, 2005-03-25initial release

How you can help

If you like to develop and add your own new features, you're welcome. Pull the source and if you like, mail me and ask for advice. If you have bugs that need fixing, enter them in the bug reports and/or mail me. If you like to document on GnuAccounting, like writing developer documentation or a user's guide, mail me. If you are a graphic artist, we could need some icons, illustrations etc.. And if you like to translate this whole thing, you're welcome either. This also applies to translations to english, I'm sure my english is very bad and so there are probably a lot of words that are more appropriate in the regarding context.

Oh, and if you just have questions or suggestions... mail me.

Warranty

No warranty can be given in any form. This means, it will not be guaranteed that this application works as expected, is bug free, will compute precisely and correctly, or does not corrupt data. The author will not guarantee that the use of this program does not violate laws regarding proper accounting in your country.

The only thing I can say is that the author has a degree in commercial information technology (Diplom in Wirtschaftsinformatik). The software may soon become legal to use for small companies the european union: as of 0.1.0 and below, at least german Umsatzsteuergesetz will invalidate some invoices: those with more than one VAT rate. As far as I know, in this case there has to be something like "this invoice contained 514 Euro VAT with the rate of 16% and 134 Euro VAT with the rate of 7%" at the end of the invoice which is not yet possible with GnuAccounting.

License

GnuAccounting, a Java-based application to created invoices, credit memos etc..
Copyright (C) 2005  Jochen Staerk, Am Wald 3, D-55270 Ober-Olm

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

GnuAccounting, Copyright (C) 2005 Jochen Staerk
GnuAccounting comes with ABSOLUTELY NO WARRANTY; for details
see http://www.gnu.org/copyleft/gpl.html.  
This is free software, and you are welcome
to redistribute it under certain conditions; see 
http://www.gnu.org/copyleft/gpl.html for details.