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