Finance::Quote on a Mac

[Benny Webster]

Hi there, Im having trouble setting up Finance::Quote… Documentation states it 
should have installed on a Mac but that does not seem to be the case. I have 
found FinanceQuote Update but when I try to run it it doesn’t work. Im new to 
GnuCash and just trying to set things up. Not too good at figuring things out 
on my own but should be able to follow any instructions. Perhaps an 
uninstall/reinstall of GnuCash? would just want to make sure my file stays 
intact…

Any advice or links to documentation would be helpful. Sorry for the trouble.

Best Regards,
Ben Webster
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

footer

[claudia via gnucash-user]

Hi, how can I add a footer to my invoice.scm, i am not sure how else to do
this.  I edited the stylesheet but is not an option anywhere that i can see,
so i chose the invoice template from the options but it doesn't appear in
the stylesheets.  I am very confused, can somebody help me please.  Thank
you very much. claudia



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNUCASH] Commas on graph

[Adrien Monteleone]

I normally use a Mac, but I just opened my file in a Ubuntu Xenial virtual 
machine and ran a report. It shows comma separators.

Check your OS system settings under Language. Make sure the local is set for US 
and check the currency example at the bottom of the window. (second tab) It 
should show commas and a decimal with two places.

If that all checks-out I’m stumped.

Regards,
Adrien

> On Jan 11, 2018, at 8:07 PM, Irving Duran  wrote:
> 
> Hi Adrien,
> 
> Yes, that is what I meant and Thanks for the info.  I looked on my
> settings under... "locales" (en_US.UTF-8) and GnuCash "Reports" and
> "Accounts" under "Preferences" and they are set as "USD (US Dollar)",
> but there are no commas separator on the graphs.  I am on Ubuntu 16.04 LTS.
> 
> Any thoughts?
> 
> Thank you,
> 
> Irving Duran
> 
> On 01/09/2018 05:24 PM, Adrien Monteleone wrote:
>> If you mean you want to see commas as a thousands separator, that is 
>> dependent on currency/locale I should think. I have mine set to US 
>> Dollar/US. I don’t see any setting for that display in particular, but this 
>> option does exist in my OS locale settings.
>> 
>> All reports I run that are over $1,000.00 show a thousands separator.
>> 
>> If you want to use commas as a decimal separator, then you’ll have to set 
>> the appropriate currency/locale.
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 9, 2018, at 2:17 PM, Irving Duran  wrote:
>>> 
>>> Is there a way to place commas on the income vs. expense report graph
>>> without having to build a special report?
>>> 
>>> Thanks!
>>> 
>>> Irving
>>> 
>>> 
>>> -- 
>>> Thank You,
>>> 
>>> Irving Duran
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> 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
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: footer

[Adrien Monteleone]

In the invoice Options on the first tab at the bottom there is an ‘Extra Notes’ 
field that prints under the line-item block. Does that accomplish what you want?

Note, there is also a Footer stylesheet. (by default it is a bit garish and 
could use some customization) Edit it and you’ll see there is a entry field for 
footer text. Applying the stylesheet to your invoice will make that footer text 
appear. It will show up below the Extra Notes block from the Options screen. 
(you could have two footers that way - one generic, and one specific to that 
invoice)

Regards,
Adrien

> On Jan 11, 2018, at 11:11 PM, claudia via gnucash-user 
>  wrote:
> 
> Hi, how can I add a footer to my invoice.scm, i am not sure how else to do
> this.  I edited the stylesheet but is not an option anywhere that i can see,
> so i chose the invoice template from the options but it doesn't appear in
> the stylesheets.  I am very confused, can somebody help me please.  Thank
> you very much. claudia
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNUCASH] Commas on graph

[David Carlson]

Irving,

If you are referring to the values on the Ordinate axis of a graph produced
by GnuCash, you are quite observant.  There are no thousands separators in
values displayed.  Everywhere else, as far as I know, there are thousands
separators.

I suspect that the reason lies in the graphic code used by GnuCash for that
function, but since I am not a programmer, I do not know why this exception
exists.

David C

On Fri, Jan 12, 2018 at 6:59 AM, Adrien Monteleone <
adrien.montele...@gmail.com> wrote:

> I normally use a Mac, but I just opened my file in a Ubuntu Xenial virtual
> machine and ran a report. It shows comma separators.
>
> Check your OS system settings under Language. Make sure the local is set
> for US and check the currency example at the bottom of the window. (second
> tab) It should show commas and a decimal with two places.
>
> If that all checks-out I’m stumped.
>
> Regards,
> Adrien
>
> > On Jan 11, 2018, at 8:07 PM, Irving Duran 
> wrote:
> >
> > Hi Adrien,
> >
> > Yes, that is what I meant and Thanks for the info.  I looked on my
> > settings under... "locales" (en_US.UTF-8) and GnuCash "Reports" and
> > "Accounts" under "Preferences" and they are set as "USD (US Dollar)",
> > but there are no commas separator on the graphs.  I am on Ubuntu 16.04
> LTS.
> >
> > Any thoughts?
> >
> > Thank you,
> >
> > Irving Duran
> >
> > On 01/09/2018 05:24 PM, Adrien Monteleone wrote:
> >> If you mean you want to see commas as a thousands separator, that is
> dependent on currency/locale I should think. I have mine set to US
> Dollar/US. I don’t see any setting for that display in particular, but this
> option does exist in my OS locale settings.
> >>
> >> All reports I run that are over $1,000.00 show a thousands separator.
> >>
> >> If you want to use commas as a decimal separator, then you’ll have to
> set the appropriate currency/locale.
> >>
> >> Regards,
> >> Adrien
> >>
> >>> On Jan 9, 2018, at 2:17 PM, Irving Duran 
> wrote:
> >>>
> >>> Is there a way to place commas on the income vs. expense report graph
> >>> without having to build a special report?
> >>>
> >>> Thanks!
> >>>
> >>> Irving
> >>>
> >>>
> >>> --
> >>> Thank You,
> >>>
> >>> Irving Duran
> >>> ___
> >>> gnucash-user mailing list
> >>> gnucash-user@gnucash.org
> >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >>> -
> >>> 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
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -
> >> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Investment Question

[Jay Ridgley]

Good Morning,

I AM NOT AN ACCOUNTANT

I have decided that I want to track my investments in USD and let my 
brokerage take care of the details of my holdings.


How would be the best way to make the conversion in GnuCash? Just "sell" 
all my holdings and put the funds in opening balances then adjust the 
amounts in the accounts by transferring funds from opening balances 
after changing the account type to asset or would it be better to delete 
the current investment accounts and start over using a new set of names. 
I favor the former.


This is a sample of what I am dealing with:

IRA
IRA:Cash
IRA:Stocks
several IRA:Stocks:Symbol
IRA:Funds
several IRA:Funds:Symbol
IRA:Bonds
several IRA:Bonds:Symbol

The result would be the same except the several X:X:Symbol accounts 
would go away. I would update the remaining accounts each month when I 
receive my statement form my broker by debit or credit to the account 
and the other side credit or debit to unrealized gains and loses. If I 
sell or buy the other side would be Cash


Will that cause problems with the way GnuCash works? Is there a better way?

Cheers,
Jay
--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Mutual fund cost basis changes between 2.6.6 and 2.6.19

[John Ralls]

> On Jan 12, 2018, at 3:43 AM, Deva -  wrote:
> 
> Hello,
> 
> I am on Mac OS Sierra v10.12.6.
> 
> Until a few days ago, I was using GnuCash 2.6.6 and just in the last 2 days, 
> I upgraded to the latest version 2.6.19.
> 
> After running a preliminary test of some of the reports I use for tax 
> reporting purposes, I noticed that the cost basis on one of my mutual funds 
> has changed significantly (see attached screenshot for the transactions on 
> that mutual fund account).
> 
> Some history on this fund. It used to be called Fidelity Flexi Gilt Fund and 
> I had invested INR 850,000 and accumulated 70,362.427 shares as of 16-Nov-12. 
> But on 23-Nov-2012, Fidelity sold its mutual fund business in India to L&T 
> Mutual Fund and the latter decided to merge Fidelity’s gilt fund into its own 
> - now called L&T Gilt Fund.
> 
> When this merger happened, I simply used the stock split assistant to reduce 
> the no. of shares by 34,769.081 based on the account statement sent by L&T.
> 
> As of 2.6.6, the (average) cost basis on the balance sheet report correctly 
> showed INR 850,000 even after the “stock split” transaction. But in the 
> latest version 2.6.19, the balance sheet report shows the same cost basis as 
> 429,978.69. I think it has reduced the cost basis by the cost of the shares 
> reduced from the merger i.e., 34,769.081 shares.
> 
> This is causing such differences to show up as imbalance in my reports!
> 
> Has the computation of cost basis changed between these versions? If so, how 
> should I go about accounting for cases such as above to maintain proper cost 
> basis?
> 
> Odd thing though is that I have a no. of stocks that declared a stock split, 
> but in those cases, the cost basis is correctly maintained even after the 
> split. This behaviour is only seen in mutual fund shares (as far as I can 
> tell).
> 
> I rely on GnuCash reports for my annual tax reporting, so it’s important that 
> the reports I generate have a proper explanation for the numbers shown.
> 
> Thanks in advance for your time.

Yes, the calculation of average cost changed in 2.6.12 to fix a bug, but that 
opened another can of worms, see 
https://bugzilla.gnome.org/show_bug.cgi?id=775368 
. I intend to have a 
solution for 3.0 and if you can add the details of your use-case to the bug 
that will help.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance::Quote on a Mac

[John Ralls]

> On Jan 10, 2018, at 6:51 PM, Benny Webster  wrote:
> 
> Hi there, Im having trouble setting up Finance::Quote… Documentation states 
> it should have installed on a Mac but that does not seem to be the case. I 
> have found FinanceQuote Update but when I try to run it it doesn’t work. Im 
> new to GnuCash and just trying to set things up. Not too good at figuring 
> things out on my own but should be able to follow any instructions. Perhaps 
> an uninstall/reinstall of GnuCash? would just want to make sure my file stays 
> intact…
> 
> Any advice or links to documentation would be helpful. Sorry for the trouble.

Open Applications:Utilities:Terminal and at the command line enter:
  sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update

You’ll be prompted for your password and may get some questions to which you 
can just select the default by pressing .

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Finance::Quote on a Mac

[John Ralls]

> On Jan 12, 2018, at 7:22 AM, John Ralls  wrote:
> 
> 
> 
>> On Jan 10, 2018, at 6:51 PM, Benny Webster  wrote:
>> 
>> Hi there, Im having trouble setting up Finance::Quote… Documentation states 
>> it should have installed on a Mac but that does not seem to be the case. I 
>> have found FinanceQuote Update but when I try to run it it doesn’t work. Im 
>> new to GnuCash and just trying to set things up. Not too good at figuring 
>> things out on my own but should be able to follow any instructions. Perhaps 
>> an uninstall/reinstall of GnuCash? would just want to make sure my file 
>> stays intact…
>> 
>> Any advice or links to documentation would be helpful. Sorry for the trouble.
> 
> Open Applications:Utilities:Terminal and at the command line enter:
>  sudo /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-update
> 
> You’ll be prompted for your password and may get some questions to which you 
> can just select the default by pressing .

Oh, and I tested Update Finance Quote on High Sierra. It works fine but it’s a 
bit non-obvious: It opens Terminal behind other windows and waits for you to 
enter your password there. If you’ve run it you should find a Terminal instance 
in your dock that you can click to bring it up. From there it should proceed 
the same as the terminal instructions above. Note that it expects to be in the 
same directory as a Gnucash instance and that you’re logged in to an 
administrator account--the latter is also the case for the command line 
instructions above.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Invoices: multilingual & tax detail questions

[Macho Philipovich]

Dear fellow Gnucash users,

I have two questions about invoices.

First, I deal with some of my clients in French, some in English. I'd
like to be able to provide invoices in either language. Gnucash reports
generally allow me to edit all of the headings in the options menu and
then save the report configuration, which is helpful, but is there a way
that I can switch the display to use the French style for currency
amounts, i.e. use a comma instead of period to indicate cents, and show
the dollar sign after the amount instead of before?

Second, in Quebec we have to charge two VAT taxes (federal GST and
provincial QST), and my understanding is that the authorities prefer
that we show the calculation of those taxes separately on invoices and
that we provide customers with our registration numbers for each tax as
part of the invoice, so that they can provide them when claiming those
taxes back if need be. Is there any way to separate the two VAT taxes
within the invoice? Currently I've just added a note explaining this and
providing the registration numbers in the notes/terms part of the
invoice, but I wonder if there isn't a better way.

Thanks, as always,

Macho


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

NUM Column Defaults

[Jack Slater]

Is it possible to create/save default NUM items such as:

EFT (electronic funds transfer)
DEP (deposit)
TRN (transfer)
ATM (auto teller machine)
And a simple free form text entry (this would allow for sequenced check
number entries)

This would save a great deal of typing these items if just typing 1st
letter of each item.

And a thought while I'm asking - 2 time saving capabilities in Quicken were:

1 - in NUM cell - type "n" would lookup prior check entry and populate that
number + 1.
2 - in DATE cell - type "t" would enter today's date

I don't know if these are options than can be turned on/off or if they
would be added features for future releases.

So far GNUCASH is a wonderful tool and I'm thankful to developers creating
and maintaining it!

Jack in Illinois
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: NUM Column Defaults

[AC]

On 2018-01-12 08:19, Jack Slater wrote:

> 
> And a thought while I'm asking - 2 time saving capabilities in Quicken were:
> 
> 1 - in NUM cell - type "n" would lookup prior check entry and populate that
> number + 1.
> 2 - in DATE cell - type "t" would enter today's date

1:  Type "+" (the plus sign) twice to get the next check number
2:  Type "t" to get today's date.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: NUM Column Defaults

[Jack Slater]

AC Thanks!
I could have sworn I had done the "t" when first getting started -
obviously not! LOL and the "+" works great! Time saver.
Thanks again!

On Fri, Jan 12, 2018 at 10:26 AM, AC  wrote:

> On 2018-01-12 08:19, Jack Slater wrote:
>
> >
> > And a thought while I'm asking - 2 time saving capabilities in Quicken
> were:
> >
> > 1 - in NUM cell - type "n" would lookup prior check entry and populate
> that
> > number + 1.
> > 2 - in DATE cell - type "t" would enter today's date
>
> 1:  Type "+" (the plus sign) twice to get the next check number
> 2:  Type "t" to get today's date.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: NUM Column Defaults

[Fross, Michael]

Thank you AC.  I knew about 't' but did not realize next check number.
That's handy.

On Fri, Jan 12, 2018 at 10:47 AM, Jack Slater 
wrote:

> AC Thanks!
> I could have sworn I had done the "t" when first getting started -
> obviously not! LOL and the "+" works great! Time saver.
> Thanks again!
>
> On Fri, Jan 12, 2018 at 10:26 AM, AC  wrote:
>
> > On 2018-01-12 08:19, Jack Slater wrote:
> >
> > >
> > > And a thought while I'm asking - 2 time saving capabilities in Quicken
> > were:
> > >
> > > 1 - in NUM cell - type "n" would lookup prior check entry and populate
> > that
> > > number + 1.
> > > 2 - in DATE cell - type "t" would enter today's date
> >
> > 1:  Type "+" (the plus sign) twice to get the next check number
> > 2:  Type "t" to get today's date.
> >
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Investment Question

[David Carlson]

I am not an accountant either, and I do not quite understand your question.

Do you already track your investments in detail in GnuCash and you want to
stop tracking details, just track overall values with periodic (manual)
value updates after monthly reports?  That is the only scenario where I
would suggest "selling" securities in your data file.  I do not think that
you need to delete brokerage or custodial accounts and replace them with
accounts of a different type. Brokerage accounts are already asset
accounts, just under a different top account name.

I think that would work.

David C

On Fri, Jan 12, 2018 at 9:15 AM, Jay Ridgley 
wrote:

> Good Morning,
>
> I AM NOT AN ACCOUNTANT
>
> I have decided that I want to track my investments in USD and let my
> brokerage take care of the details of my holdings.
>
> How would be the best way to make the conversion in GnuCash? Just "sell"
> all my holdings and put the funds in opening balances then adjust the
> amounts in the accounts by transferring funds from opening balances after
> changing the account type to asset or would it be better to delete the
> current investment accounts and start over using a new set of names. I
> favor the former.
>
> This is a sample of what I am dealing with:
>
> IRA
> IRA:Cash
> IRA:Stocks
> several IRA:Stocks:Symbol
> IRA:Funds
> several IRA:Funds:Symbol
> IRA:Bonds
> several IRA:Bonds:Symbol
>
> The result would be the same except the several X:X:Symbol accounts would
> go away. I would update the remaining accounts each month when I receive my
> statement form my broker by debit or credit to the account and the other
> side credit or debit to unrealized gains and loses. If I sell or buy the
> other side would be Cash
>
> Will that cause problems with the way GnuCash works? Is there a better way?
>
> Cheers,
> Jay
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Investment Question

[Jay Ridgley]

Thanks David,

Perhaps, I can clarify. The answer to your question is yes. The reason 
for the new name is that currently the accounts are defined as place 
holders, they would have to be regular accounts, would they not?


Regards,
Jay

On 01/12/2018 11:13 AM, David Carlson wrote:

I am not an accountant either, and I do not quite understand your question.

Do you already track your investments in detail in GnuCash and you want 
to stop tracking details, just track overall values with periodic 
(manual) value updates after monthly reports?  That is the only scenario 
where I would suggest "selling" securities in your data file.  I do not 
think that you need to delete brokerage or custodial accounts and 
replace them with accounts of a different type. Brokerage accounts are 
already asset accounts, just under a different top account name.


I think that would work.

David C

On Fri, Jan 12, 2018 at 9:15 AM, Jay Ridgley > wrote:


Good Morning,

I AM NOT AN ACCOUNTANT

I have decided that I want to track my investments in USD and let my
brokerage take care of the details of my holdings.

How would be the best way to make the conversion in GnuCash? Just
"sell" all my holdings and put the funds in opening balances then
adjust the amounts in the accounts by transferring funds from
opening balances after changing the account type to asset or would
it be better to delete the current investment accounts and start
over using a new set of names. I favor the former.

This is a sample of what I am dealing with:

IRA
IRA:Cash
IRA:Stocks
several IRA:Stocks:Symbol
IRA:Funds
several IRA:Funds:Symbol
IRA:Bonds
several IRA:Bonds:Symbol

The result would be the same except the several X:X:Symbol accounts
would go away. I would update the remaining accounts each month when
I receive my statement form my broker by debit or credit to the
account and the other side credit or debit to unrealized gains and
loses. If I sell or buy the other side would be Cash

Will that cause problems with the way GnuCash works? Is there a
better way?

Cheers,
Jay
-- 
Jay Ridgley

jridgley2 at austin.rr.com 
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png

Registered Ubuntu User ID - 23320
___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





--
Jay Ridgley
jridgley2 at austin.rr.com
Registered Linux User ID - 9115
https://linuxcounter.net/cert/9115.png
Registered Ubuntu User ID - 23320
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Investment Question

[David Carlson]

Aha!

Placeholder status is not a part of an account type.  Your regular
brokerage accounts would not ordinarily be placeholders because they  need
to contain transactions pertaining purchases, sales, income and expenses.
You may have placed placeholder above your accounts if that helped you
organize your account tree.

In any case, any account can be changed at any time to be a placeholder
account or not.  Just check or uncheck the box in the account editor.

It might be helpful to re-read the section of the tutorial about
investments before proceeding.

David C

On Fri, Jan 12, 2018 at 12:30 PM, Jay Ridgley 
wrote:

> Thanks David,
>
> Perhaps, I can clarify. The answer to your question is yes. The reason for
> the new name is that currently the accounts are defined as place holders,
> they would have to be regular accounts, would they not?
>
> Regards,
> Jay
>
> On 01/12/2018 11:13 AM, David Carlson wrote:
>
>> I am not an accountant either, and I do not quite understand your
>> question.
>>
>> Do you already track your investments in detail in GnuCash and you want
>> to stop tracking details, just track overall values with periodic (manual)
>> value updates after monthly reports?  That is the only scenario where I
>> would suggest "selling" securities in your data file.  I do not think that
>> you need to delete brokerage or custodial accounts and replace them with
>> accounts of a different type. Brokerage accounts are already asset
>> accounts, just under a different top account name.
>>
>> I think that would work.
>>
>> David C
>>
>> On Fri, Jan 12, 2018 at 9:15 AM, Jay Ridgley > > wrote:
>>
>> Good Morning,
>>
>> I AM NOT AN ACCOUNTANT
>>
>> I have decided that I want to track my investments in USD and let my
>> brokerage take care of the details of my holdings.
>>
>> How would be the best way to make the conversion in GnuCash? Just
>> "sell" all my holdings and put the funds in opening balances then
>> adjust the amounts in the accounts by transferring funds from
>> opening balances after changing the account type to asset or would
>> it be better to delete the current investment accounts and start
>> over using a new set of names. I favor the former.
>>
>> This is a sample of what I am dealing with:
>>
>> IRA
>> IRA:Cash
>> IRA:Stocks
>> several IRA:Stocks:Symbol
>> IRA:Funds
>> several IRA:Funds:Symbol
>> IRA:Bonds
>> several IRA:Bonds:Symbol
>>
>> The result would be the same except the several X:X:Symbol accounts
>> would go away. I would update the remaining accounts each month when
>> I receive my statement form my broker by debit or credit to the
>> account and the other side credit or debit to unrealized gains and
>> loses. If I sell or buy the other side would be Cash
>>
>> Will that cause problems with the way GnuCash works? Is there a
>> better way?
>>
>> Cheers,
>> Jay
>> -- Jay Ridgley
>> jridgley2 at austin.rr.com 
>> Registered Linux User ID - 9115
>> https://linuxcounter.net/cert/9115.png
>> 
>> Registered Ubuntu User ID - 23320
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>>
>>
>
> --
> Jay Ridgley
> jridgley2 at austin.rr.com
> Registered Linux User ID - 9115
> https://linuxcounter.net/cert/9115.png
> Registered Ubuntu User ID - 23320
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Collecting payments from others then remitting to one vendor

[gn00b]

So my roommates and I split utilities cost and every month they remit to me
the required amount and I then remit all of those smaller payments to our
utilities company. What's the best way to set up the accounts/transactions
so I only have an expense of what I owe.

Example:

Utilities bill is $30

Roommate A: $10
Roommate B: $10
Me: $10

I collect $10 from A and B and remit $30 to the utilities company.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Collecting payments from others then remitting to one vendor

[Maf. King]

On Saturday, 13 January 2018 00:15:07 GMT gn00b wrote:
> So my roommates and I split utilities cost and every month they remit to me
> the required amount and I then remit all of those smaller payments to our
> utilities company. What's the best way to set up the accounts/transactions
> so I only have an expense of what I owe.
> 
> Example:
> 
> Utilities bill is $30
> 
> Roommate A: $10
> Roommate B: $10
> Me: $10
> 
> I collect $10 from A and B and remit $30 to the utilities company.
> 
>

Hi, 

I'd imagine that setting up your roommates as liability accounts might work.  
Consider that you don't "own" the money they've contributed - you're just 
looking after it in your current account until it either goes to pay the bill 
or, if the bill were ever to be cancelled, you'd owe the money back to your 
buddies.

then, when you pay the bill, you end up with a multi split transaction, 
reducing your bank account (the total bill), the roommate liability accounts 
(by their contributions), but increasing expense:utility by your share.

HTH,
Maf.


w  

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Collecting payments from others then remitting to one vendor

[Christopher Lam]

You could do liability accounts for each utility bill but I like the
concept of 'kitty funds' which gives you/them a real-time view of monies
owed by whom.


*You pay the full $30 bill from your bank, but only $10 is your share*
Asset:Bank -$30
Expense:Utilities $10
Asset:Alice $10
Asset:Bob $10


*The $10 are your assets because you are owed $10 from each, and they can
discharge their debt anytime*
Asset:Alice -$10
Asset:Bank $10
Her balance is now $0


*Another day you buy $30 groceries but Bob asks you to buy $10 item on her
behalf*
Expense:Groceries $30
Asset:Bob $10
Asset:Bank -$40
Bob's balance is now $20. (He owes you)

On 13 January 2018 at 11:15, gn00b  wrote:

> So my roommates and I split utilities cost and every month they remit to me
> the required amount and I then remit all of those smaller payments to our
> utilities company. What's the best way to set up the accounts/transactions
> so I only have an expense of what I owe.
>
> Example:
>
> Utilities bill is $30
>
> Roommate A: $10
> Roommate B: $10
> Me: $10
>
> I collect $10 from A and B and remit $30 to the utilities company.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Mutual fund cost basis changes between 2.6.6 and 2.6.19

[Deva -]

Thanks John.

I haven’t filed a bug/enhancement before - GnuCash has been wonderful as it is! 
I will look into how to do this and add the use case as you suggested.

In the meantime, should I downgrade to 2.6.11 (last version where cost basis is 
correctly reported)? The reason I upgraded was because I saw some post on the 
list stating that if I upgrade to Mac OS High Sierra, then GnuCash needs to be 
at 2.6.19. So I upgraded GnuCash in preparation of the Mac OS upgrade.

If I downgrade to 2.6.11, will it be compatible with Mac OS High Sierra?

I don’t say it enough - this community’s immense support is deeply appreciated. 
Not just on technical aspects, I have gotten so many good ideas on accounting 
concepts as well, just by reading through other’s posts. Many thanks to all of 
you for your timely help!

Cheers.
On 12-Jan-2018, at 8:44 PM, John Ralls 
mailto:jra...@ceridwen.us>> wrote:



On Jan 12, 2018, at 3:43 AM, Deva - 
mailto:pobox.d...@outlook.in>> wrote:

Hello,

I am on Mac OS Sierra v10.12.6.

Until a few days ago, I was using GnuCash 2.6.6 and just in the last 2 days, I 
upgraded to the latest version 2.6.19.

After running a preliminary test of some of the reports I use for tax reporting 
purposes, I noticed that the cost basis on one of my mutual funds has changed 
significantly (see attached screenshot for the transactions on that mutual fund 
account).

Some history on this fund. It used to be called Fidelity Flexi Gilt Fund and I 
had invested INR 850,000 and accumulated 70,362.427 shares as of 16-Nov-12. But 
on 23-Nov-2012, Fidelity sold its mutual fund business in India to L&T Mutual 
Fund and the latter decided to merge Fidelity’s gilt fund into its own - now 
called L&T Gilt Fund.

When this merger happened, I simply used the stock split assistant to reduce 
the no. of shares by 34,769.081 based on the account statement sent by L&T.

As of 2.6.6, the (average) cost basis on the balance sheet report correctly 
showed INR 850,000 even after the “stock split” transaction. But in the latest 
version 2.6.19, the balance sheet report shows the same cost basis as 
429,978.69. I think it has reduced the cost basis by the cost of the shares 
reduced from the merger i.e., 34,769.081 shares.

This is causing such differences to show up as imbalance in my reports!

Has the computation of cost basis changed between these versions? If so, how 
should I go about accounting for cases such as above to maintain proper cost 
basis?

Odd thing though is that I have a no. of stocks that declared a stock split, 
but in those cases, the cost basis is correctly maintained even after the 
split. This behaviour is only seen in mutual fund shares (as far as I can tell).

I rely on GnuCash reports for my annual tax reporting, so it’s important that 
the reports I generate have a proper explanation for the numbers shown.

Thanks in advance for your time.

Yes, the calculation of average cost changed in 2.6.12 to fix a bug, but that 
opened another can of worms, see 
https://bugzilla.gnome.org/show_bug.cgi?id=775368. I intend to have a solution 
for 3.0 and if you can add the details of your use-case to the bug that will 
help.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.