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

[Christopher Lam]

Unfortunately there is *no* income statement type report which will
calculate unrealized gains for you.
Your best bet is to reevaluate periodically using the usual balance sheet.

On Tue, 26 Feb 2019 at 06:28, Chary Chary <chary314 at gmail.com> wrote:

> Hi everyone,
>
> thank you for help, but I just can't make it work.
>
> I try a very simple setup:
>
> Main currency - Euro
>
> 1000 USD are moved to checking Account at the beginning of the period.
>
> Exchange rate at the beginning - 1 USD costs 1 Euro
>
> Middle of the year it changes - 1 USD costs 2 Euro
>
> No transactions
>
> Net Worth Barchart  correctly shows increase is Net Worth throughout
> the year. However Income statement report does not show any traces on why
> net wort has increased now.
>
> Based on my understanding of the Tutorial on multiple currency accounting (
> https://www.mathstat.dal.ca/~selinger/accounting/tutorial.html ) I would
> expect, that the statement would include line:
>
> Unrealized gain due to USD/Euro exchange rate  - 1000 Euro  or something
> similar
>
>
> Any ideas on how to achieve this with Gnucash?
>
> For illustration I have created simple document with screenshots as well my
> test file
>
> https://drive.google.com/open?id=1T3KEhAOkkytyW1Dne0vVs259cv0WxtfK
>
>
>
>
>
> On Mon, Feb 25, 2019 at 1:02 AM Chary Chary <chary314 at gmail.com> wrote:
>
> > Hello everybody,
> >
> > I just started learning gnucash with the goal to depart from my from my
> > Excel-based bookkeeping system with pivot tables, so forgive me if I ask
> > stupid question. i think I read pretty much all of the help file, but
> still
> > didn't understand whether the following is possible:
> >
> > I am just wondering  whether there is a cashflow-like report which shows
> > also realized and unrealized gains for certain period
> >
> > What exactly I mean by this:
> >
> > 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.
> >
> > So, effectively I need to be able to drill down in the delta in Balance
> > Sheet report
> >
> > Regards.
> > Chary
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>