Exporting an account as .csv with the balance column?
Maf. King
maf at chilwell.net
Fri Nov 7 12:58:14 EST 2014
On Fri 7 November 14 09:41:56 AfrikaDietmar wrote:
> Hi David,
>
> actually I need the entries identical as in GnuCash in calc which I then
> save, having the balance figures, even if not calculated but just static
> would be just fine. I suppose that won't be possible currently?
> Do you know the formula I could use in calc to get the balance column?
>
> Best regards,
> Dietmar
>
Hi Dietmar,
The formula isn't complicated.
assuming the transaction totals are in column C, and you want the balance in
column D you need the following:
Dn=(D(n-1)+Cn)
i.e.
cell D5 = D4+C5
cell D6 = D5+C6
HTH
Maf.
More information about the gnucash-user
mailing list