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 <chary...@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....@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 <chary...@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 <chary...@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@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@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@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.
