[GNC] Cashflow-like report to show realized and unrealized gains / balance sheet delta report

Christian Kluge frakturfreak at gmail.com
Mon Feb 25 14:49:57 EST 2019


Hello,

Am 25.02.2019 um 01:02 schrieb Chary Chary:

> Say at the beginning of the year I have produced a Balance Sheet report.
> This report shows how much assets I have, which liabilities and delta
> between them. Suppose at begging of the year I had checking accounts in USD
> and Euro and some stock.
> Throughout the year I was getting salary, paying expenses, at the same time
> exchange rate was changing, stock price was changing etc. My be I sold some
> stock, moved money between USD and Euro accounts
> 
> Now at the end of the year I have produced a new balance sheet.
> 
> So, I want to be able to explain a delta between a balance sheet at the
> beginning of the ear and at the end.
> 
> E.g.:
> 
> I got so much salary
> I paid so much costs
> 
> But also:
> Lost so much due to exchange rate change
> Gained to much due to stock price increase etc.
> 

My advice would be to enable trading accounts and updating the price
database regularly.

Also always record income and expenses in one currency across all accounts.

You’ll have to book the expenses/income from exchange rate fluctuations
manually when money moves between accounts of different currencies.

Then in the end the trading accounts should yield the gain/loss due to
stock prize changes when selecting nearest in time.

Kind regards

Christian Kluge



More information about the gnucash-user mailing list