Formula for a bank statement running balance calculation

  • Hi


    I can download statements from my bank (HSBC, for future Googlers) in the following format. Does anyone know what formula I can use to show a running balance in column D (i.e. to the right of 'amount')?
    I've tried various things and the only way I've had success is to filter the credits and debits into seperate columns due to the way the formula interprets the '-' symbols...


    Thank you!
    [TABLE="class: grid, align: center"]

    [tr]


    [TD="width: 64, bgcolor: transparent"]date[/TD]
    [TD="width: 64, bgcolor: transparent"]description[/TD]
    [TD="width: 64, bgcolor: transparent"]amount[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]01.12.2011[/TD]
    [TD="bgcolor: transparent"]supermarket[/TD]
    [TD="bgcolor: transparent, align: right"]-10[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]02.12.2012[/TD]
    [TD="bgcolor: transparent"]wages[/TD]
    [TD="bgcolor: transparent, align: right"]1000[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]04.12.2011[/TD]
    [TD="bgcolor: transparent"]butcher[/TD]
    [TD="bgcolor: transparent, align: right"]-5[/TD]

    [/tr]


    [tr]


    [TD="bgcolor: transparent"]06.12.2011[/TD]
    [TD="bgcolor: transparent"]child benefit[/TD]
    [TD="bgcolor: transparent, align: right"]80[/TD]

    [/tr]


    [/TABLE]

  • Re: Formula for a bank statement running balance calculation


    hi,


    If you are saying running balance, you can just provide the opening balance somewhere and then just add them.


    It should provide you with results.


    Regards
    Segu

  • Re: Formula for a bank statement running balance calculation


    Hi Segu,


    I'm wondering if I've just asked the world's stupidest question, because I've just tried this and it works fine...


    Let me come back to you when I've tried it on my real (slightly more complicated but not by much) data.


    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!