Re: [GNC] Accounting for gold coins

2019-03-02 Thread Adrien Monteleone
Don’t let the detail disuade you. I was just being as thorough as I could muster. Even without knowing where everything is, the entire setup shouldn’t take more than about 15–30 minutes. (maybe a tad longer if you have lots of opening entries you need to make for current holdings, or if you want

Re: [GNC] Accounting for gold coins

2019-02-28 Thread Michael or Penny Novack
On 2/28/2019 10:01 AM, Gary Holtum wrote: Adrien, Thank you for the detailed response. I will work on the steps you describe but I am beginning to think GnuCash is not suited for providing the data I would like. Maybe an Excel spreadsheet would be easier. Thanks again for your expertise. Gar

Re: [GNC] Accounting for gold coins

2019-02-28 Thread Gary Holtum
: gnucash-user [mailto:gnucash-user-bounces+diamondhranchqh=earthlink@gnucash.org] On Behalf Of Adrien Monteleone Sent: Wednesday, February 27, 2019 11:35 AM To: gnucash-user Subject: Re: [GNC] Accounting for gold coins Gary, 1. Turn on Trading Accounts. File > Properties > Accounts

Re: [GNC] Accounting for gold coins

2019-02-27 Thread Adrien Monteleone
Gary, 1. Turn on Trading Accounts. File > Properties > Accounts > Use Trading Accounts 2. Set full transaction view options. (I find this helps to see everything about a transaction and to better understand double-entry) View > Transactions Journal (optionally, View > Double Li

Re: [GNC] Accounting for gold coins

2019-02-27 Thread David T. via gnucash-user
Gnucash by policy uses the ISO currency definitions, which precludes any additions or extensions. And yes, this had been discussed before. Workarounds have focused either on treating metals like any other commodity, as you have done here, or by loading your alternative (e.g., bitcoin) on an unu

Re: [GNC] Accounting for gold coins

2019-02-27 Thread Gary Holtum
On Behalf Of Adrien Monteleone Sent: Tuesday, February 26, 2019 7:46 PM To: gnucash-user Subject: Re: [GNC] Accounting for gold coins Since XAU and XAG are one-ounce quotes, I simply enter them as their own currency unit. So if I buy a 10oz. bar of silver, I’d enter it in the XAG account as 10

Re: [GNC] Accounting for gold coins

2019-02-26 Thread Adrien Monteleone
Since XAU and XAG are one-ounce quotes, I simply enter them as their own currency unit. So if I buy a 10oz. bar of silver, I’d enter it in the XAG account as 10.00. (because I have trading accounts turned on, GnuCash will create the USD equivalent splits for me and auto-balance them) If I buy

Re: [GNC] Accounting for gold coins

2019-02-26 Thread Gary Holtum
Adrian - How do you enter them in ounces? Gary -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+diamondhranchqh=earthlink@gnucash.org] On Behalf Of Adrien Monteleone Sent: Sunday, February 24, 2019 9:51 AM To: gnucash-user Subject: Re: [GNC] Accounting for gold

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 did

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 tr