Simple (web?) application for producing something like a bank statement - ideas?

Chris Green cl at isbd.net
Wed Jun 13 08:49:13 UTC 2012


I want a simple way to maintain something like a bank account.  I.e. I
want to enter debits and credits and be able to show the running balance
in the account, something like:-

Date            Credit  Debit   Balance         Description
2012-01-01      0.00            0.00            Start of 2012, Initial balance
2012-01-01              200     -200.00         Livery for January (4 weeks)
2012-01-05              21.69   -221.69         1 x HiFi Lite, 1 x Pasture Mix
2012-01-06      200.00          -21.69          Cheque 
2012-01-19              10.99   -32.68          1 x HiFi Lite
2012-01-28              87.5    -120.18         Hay from Owen Smith, 5 bales for £175
2012-02-01              200     -320.18         Livery for February (to 26th)
2012-02-02      200.00          -120.18         Cash
2012-02-04      100.18          -20.00          Cheque
2012-02-09              43.38   -63.38          2 x HiFi Lite, 2 x Pasture Mix (invoice 99)
2012-03-01              200     -263.38         Livery for March (to 25th)
2012-03-02      200.00          -63.38          Cash


Ideally one would only need to enter credit/debit and description, the
date would default to today (with the ability to change it) and the
running balance would be automatically calculated.

I already have a PHP/Database application for doing this which I wrote
myself (using DokuWiki as a framework, simplifies the HTML side of
things) but I'm really after something with much simpler data entry as
my solution enters the data by editing the wiki.

A spreadsheet does some of what I want but I've never seen a neat
solution to showing a running balance, it always requires entering a
formula in the Balance column for every new entry.

Any ideas anyone?

-- 
Chris Green




More information about the ubuntu-users mailing list