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

[David Carlson]

Chary,

There are some reports that do show unrealized gains, including the Balance
sheet report, but as I stated in my first post you need to adjust the
detailed settings carefully to get exactly the numbers you want.

Unfortunately, I am not the best person to help you as I have not migrated
to release 3.4, which has reports that are changed from those in earlier
releases.

David Carlson

On Wed, Feb 27, 2019, 4:21 AM Chary Chary <chary314 at gmail.com> wrote:

> Christopher,
>
> thanks.
>
> But I must say, I still have a sneaky feeling, that I may be missing
> something, because I just don't understand how people who deal with several
> currencies and who have stock can possibly live without such report, which
> would show unrealized gains.
>
> Without report with unrealized gains you have a situation, that you have
> some balance at the beginning, balance at the end, but you have no report,
> which would show how you got from balance at the beginning to balance at
> the end. Even though all your individual transactions are balanced, if you
> add them all together they will not produce a delta between balance sheets,
> in case you deal with  more then one currency or have stock / gold
> (anything).
>
> In a very simple situation:
>
> Say I want to report in EUR, but I keep money in USD. Say I have 1000 USD
> and exchange rate was 1:1 at the beginning.
> So, starting balance sheet will say, that I have 1000 EUR
> Then exchange rate changed and now 1 USD costs 2 EUR. So, all of a sudden
> balance sheet at the closing will show, that I now have 2000 EUR.
> But how did happen?
> I would then expect some line, saying something like: "unrealized gain due
> to USD/EUR" exchange rate changes"  - 1000 EURO.
>
> The same applies to stock changes.
>
> Am I talking some nonsense? How do people manage their finance without such
> analysis in our modern world?
>
> On Tue, Feb 26, 2019 at 1:49 PM Christopher Lam <christopher.lck at gmail.com
> >
> wrote:
>
> > 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.
> >>
> >
> _______________________________________________
> 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.
>