Acow

Acow is a command line accounting application that I wrote as an experiment in the use of SQL (using MySQL in particular).

It is a relatively simple system, but supports multiple accounts and transactions between accounts.

Note that the application is entirely console based, however, it could be combined with a graphical frontend.

[wedge@regulus ~/projects/acow]$ ./acowc ls -a current
Listing transactions for account: current (ID=1)

    ID    DATE     PAYEE                              DEBIT    CREDIT   BALANCE
--------------------------------------------------------------------------------
     2 2009-10-20  bank loan                                    99.99     99.99
     3 2009-10-20  savings                             1.23               98.76
     5 2009-10-20  price busterz                       1.00               97.76
     6 2009-10-20  expensives r us                   100.00               -2.24
     7 2009-10-20  savings                                     200.00    197.76
--------------------------------------------------------------------------------

[wedge@regulus ~/projects/acow]$ ./acowc acc
    ID  NAME                             BALANCE
--------------------------------------------------------------------------------
     1  current                           197.76
     2  savings                          -155.56
--------------------------------------------------------------------------------

[wedge@regulus ~/projects/acow]$

Screenshot of acow in use

The first version of acow was written in perl using the DBI database module to connect to MySQL. I also wrote a C version which uses text files in place of a database to store the account details.

You can download acow v1.0.0 here.