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