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

[Mark Widdicombe]

On 13 June 2012 10:49, Chris Green <cl at isbd.net> wrote:
> 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

a spreadsheet is probably the best solution.  If you enter the formula
in the top cell of the running balance column yoiu can use the drag
handle to automatically enter the appropriate formula in all the cells
below it; you don't need to enter the formula in each cell manually.