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

2019-02-24 Thread Michael or Penny Novack
On 2/24/2019 7:02 PM, Chary Chary 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

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

2019-02-24 Thread David Carlson
Welcome to the GnuCash user community! A caveat: GnuCash reports sometimes give erroneous values when there is more than one currency in the book and when there are securities included in the assets. There is no simple way to say certain settings will give accurate results for all cases.

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

2019-02-24 Thread Stephen M. Butler
You are describing an "Income Statement" aka "Profit/Loss Statement".  This is available from the reports menu. On 2/24/19 4:02 PM, Chary Chary wrote: > Hello everybody, > > I just started learning gnucash with the goal to depart from my from my > Excel-based bookkeeping system with pivot tables,

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

2019-02-24 Thread Chary Chary
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

Re: [GNC] Connect MySQL to GnuCash

2019-02-24 Thread Colin Law
On Sun, 24 Feb 2019 at 19:18, Steve Isenberg via gnucash-user < gnucash-user@gnucash.org> wrote: > That partially works. There is a non-specific error given after > converting to MySQL: > > ** Tables are created but no data is brought forward ** > ERROR Converting to MySQL > I don't

Re: [GNC] Connect MySQL to GnuCash

2019-02-24 Thread Steve Isenberg via gnucash-user
That partially works. There is a non-specific error given after converting to MySQL: ** Tables are created but no data is brought forward ** ERROR Converting to MySQL The server at URL mysql://___/t4h_gnucash experienced an error or encountered bad or corrupt data. **

Re: [GNC] Accounting for gold coins

2019-02-24 Thread Michael or Penny Novack
On 2/24/2019 9:35 AM, Joseph Vernice wrote: Treat the gold coins as investments just like stocks. Instead of shares just use your unit of purchase (ounces, grams, etc.). On 2/24/2019 9:30 AM, Gary Holtum wrote: I purchased 3 lots of gold bullion coins at different times at different prices. I

Re: [GNC] Accounting for gold coins

2019-02-24 Thread Adrien Monteleone
Gary, I turned on Trading Accounts and set them in their own account with XAU as the currency. (not exactly the best price source, but it saves me having to look it up and it is ‘close enough’ for estimating net worth until I decide to sell them) I entered them in the account as ounces. I

Re: [GNC] Accounting for gold coins

2019-02-24 Thread Joseph Vernice
Treat the gold coins as investments just like stocks.  Instead of shares just use your unit of purchase (ounces, grams, etc.). On 2/24/2019 9:30 AM, Gary Holtum wrote: I purchased 3 lots of gold bullion coins at different times at different prices. I physically have the coins. I want to keep

[GNC] Accounting for gold coins

2019-02-24 Thread Gary Holtum
I purchased 3 lots of gold bullion coins at different times at different prices. I physically have the coins. I want to keep track of their total value over time, adjusted as the price of gold fluctuates. How do I set up the asset and make the changes in value?

Re: [GNC] insurance policy with guaranteed value: how to record increase in value?

2019-02-24 Thread Andrea Borgia
Hello, Michael. Ah, my line of country, insurance. Good thing this is your field of expertise, mine is programming :) a) Do they not give you an annual statement? One that indicates increase in "cash value". I have the receipts for the payments made and I can check the current value on