Re: [GNC] Payroll Report

[D. via gnucash-user]

Since each of the lines has its own account, that should be eminently possible 
with a transaction report. I have something just like this to track my personal 
wage situation--a W-2 in US tax parlance. It's just a simple transaction report 
for the proper time period, using only the accounts in question, showing totals 
only. 

I can forward a sample if you need more detail. 

David T. 


 Original Message 
From: Aaron Laws 
Sent: Sun May 03 08:49:14 GMT+05:30 2020
To: Gnucash 
Subject: [GNC] Payroll Report

My accountant recently asked for a "payroll" report. I think he wants
something like this: https://imgur.com/tPemh4e.png (this is an image of the
attached PDF). What is the best way to create such a report? I'm hoping I
can do better than a set of Account Reports just showing the transactions.

One idea I have is to try to add this kind of report to Gnucash. I realize
I'm on the "user" list, so I'll stick to "user" solutions, and if nothing
compelling shows up, I'll go to the developer list and see if I can either
make something that will work for my needs or something I can contribute to
Gnucash.




___
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.

[GNC] Payroll Report

[Aaron Laws]

My accountant recently asked for a "payroll" report. I think he wants
something like this: https://imgur.com/tPemh4e.png (this is an image of the
attached PDF). What is the best way to create such a report? I'm hoping I
can do better than a set of Account Reports just showing the transactions.

One idea I have is to try to add this kind of report to Gnucash. I realize
I'm on the "user" list, so I'll stick to "user" solutions, and if nothing
compelling shows up, I'll go to the developer list and see if I can either
make something that will work for my needs or something I can contribute to
Gnucash.


payroll.pdf
Description: Adobe PDF document
___
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.

Re: [GNC] How do I add stock trades?

[D. via gnucash-user]

Hear, hear! Thanks John! 

David


 Original Message 
From: Adrien Monteleone 
Sent: Sun May 03 07:59:18 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] How do I add stock trades?

An even more thorough explanation and understanding.

Thanks John!

Regards,
Adrien

> On May 2, 2020 w18d123, at 5:11 PM, John Ralls  wrote:
> 
> Not quite right. While it's correct that in GnuCash's code a currency is a 
> commodity with a special namespace, and that an account has only one 
> commodity member variable, it's not quite right about a non-currency 
> commodity account not having a currency.
> 
> Remember that a split has two commodity fields, amount and value, and that 
> transactions have a transaction currency field. It's called transaction 
> currency because it *must* be a currency, and it's the currency in which all 
> of the value fields are denominated.
> 
> If you begin a transaction in an account register whose commodity is 
> non-currency GnuCash will look up the hierarchy until it finds a parent 
> account in currency and use the first one it finds for the transaction 
> currency. It does the same in reports, in the Accounts page, and in the 
> summary bar when applying prices from the pricedb. That currency of the first 
> parent account with a currency for its commodity is sometime referred to in 
> the documentation as that child account's currency.
> 
> Regards,
> John Ralls
> 
>> On May 2, 2020, at 10:16 AM, Adrien Monteleone 
>>  wrote:
>> 
>> Yes, I misspoke. Thank you. Technically it is denominated in itself. And 
>> technical accuracy is no minor point, especially with accounting, and leads 
>> to clearer understanding.
>> 
>> Regards,
>> Adrien


___
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.

Re: [GNC] How do I add stock trades?

[Adrien Monteleone]

An even more thorough explanation and understanding.

Thanks John!

Regards,
Adrien

> On May 2, 2020 w18d123, at 5:11 PM, John Ralls  wrote:
> 
> Not quite right. While it's correct that in GnuCash's code a currency is a 
> commodity with a special namespace, and that an account has only one 
> commodity member variable, it's not quite right about a non-currency 
> commodity account not having a currency.
> 
> Remember that a split has two commodity fields, amount and value, and that 
> transactions have a transaction currency field. It's called transaction 
> currency because it *must* be a currency, and it's the currency in which all 
> of the value fields are denominated.
> 
> If you begin a transaction in an account register whose commodity is 
> non-currency GnuCash will look up the hierarchy until it finds a parent 
> account in currency and use the first one it finds for the transaction 
> currency. It does the same in reports, in the Accounts page, and in the 
> summary bar when applying prices from the pricedb. That currency of the first 
> parent account with a currency for its commodity is sometime referred to in 
> the documentation as that child account's currency.
> 
> Regards,
> John Ralls
> 
>> On May 2, 2020, at 10:16 AM, Adrien Monteleone 
>>  wrote:
>> 
>> Yes, I misspoke. Thank you. Technically it is denominated in itself. And 
>> technical accuracy is no minor point, especially with accounting, and leads 
>> to clearer understanding.
>> 
>> Regards,
>> Adrien


___
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.

Re: [GNC] Asking again - Finance::Quote

[Randy Brachman]

I thought so too, when I saw it in the path, but that's what Strawberry did
as the default install.
C:\Strawberry\c
C:\Strawberry\cpan
C:\Strawberry\licenses
C:\Strawberry\perl
C:\Strawberry\win32
and in 'c':
C:\Strawberry\c\bin
C:\Strawberry\c\etc
C:\Strawberry\c\include
C:\Strawberry\c\lib
C:\Strawberry\c\libexec
C:\Strawberry\c\x86_64-w64-mingw32

... and 2200+ more directories!






*Randy Brachman -- Live where you
are. You must be present to win. There is no collective wisdom of
individual ignorance. The organism only acts in its own best interest.*


On Sat, May 2, 2020 at 4:31 PM David H  wrote:

> C:\Strawberry\c\bin - should that be C:\Strawberry\bin. ???
>
> Cheers David H.
>
>
> On Sun, 3 May 2020 at 09:09, Randy Brachman  wrote:
>
>> I did see that issue and fixed it before all my latest attempts...   But
>> thanks.  Here's a piece of the System Path Variable:
>>
>> ...;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin
>>
>>
>>
>>
>>
>>
>> *Randy Brachman -- Live where you
>> are. You must be present to win. There is no collective wisdom of
>> individual ignorance. The organism only acts in its own best interest.*
>>
>>
>> On Sat, May 2, 2020 at 2:35 PM Fross, Michael  wrote:
>>
>> > Hello Randy,
>> >
>> > When last I installed it I had to make sure both the Strawberry\c\bin
>> and
>> > the Strawberry\Perl\bin in my path.  Maybe that will help?
>> >
>> > Michael
>> >
>> > On Sat, May 2, 2020 at 3:25 PM Randy Brachman 
>> wrote:
>> >
>> >> I asked for suggestions on this 9 days ago, but haven't gotten any.
>> >> Anyone
>> >> have recommendations for where else I might get ideas?
>> >>
>> >> Windows 10 Pro 10.0.18362 on a Dell XPS 8300 x64 PC.
>> >>
>> >> gnucash version (Help/About):
>> >> Version: 3.10
>> >> Build ID: 3.10+(2020-04-11)
>> >> Finance::Quote: -
>> >>
>> >> F::Q seems to be installed, having used the Windows "Install Online
>> Price
>> >> Retrieval" tool.
>> >>
>> >> gnc-fq-check,  gnc-fq-dump,  gnc-fq-helper,  gnc-fq-update all report
>> >> successful completion and/or retrieval of data.
>> >> gnc-fq-check:
>> >> ("1.49" "adig" "aex" "aiahk" "alphavantage"   "yahoo_json"
>> "yahoo_yql"
>> >> "za" "za_unittrusts")
>> >> gnc-fq-update:
>> >> ... Updating database file ... Done!
>> >> Date::Manip is up to date (6.81).
>> >> Finance::Quote is up to date (1.49).
>> >>
>> >> gnc-fq-dump nyse ibm:
>> >> perl gnc-fq-dump nyse ibm
>> >> Finance::Quote fields Gnucash uses:
>> >> symbol: ibm  <=== required
>> >>   date: 05/01/2020   <=== recommended
>> >>   currency: USD  <=== required
>> >>   last: 121.8700 <=\
>> >>nav:  <=== one of these
>> >>  price:  <=/
>> >>   timezone:  <=== optional
>> >>
>> >>
>> >> Strawberry Perl successfully installed.
>> >> "This is perl 5, version 30, subversion 2 (v5.30.2) built for
>> >> MSWin32-x64-multi-thread"
>> >>
>> >> gnucash Security Editor indicates >Warning: Finance::Quote not
>> installed
>> >> properly.<
>> >> Entire area below "Quote Source Information" header is grayed out.
>> >> Numerous uninstall and reinstall for gnucash, Perl, F::Q without any
>> >> change
>> >> to this situation.  As far as I can tell, everything else seems OK.
>> >>
>> >> Thanks for any help.
>> >>
>> >> *Randy Brachman *
>> >>
>> >> * -- *
>> >> ___
>> >> 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.

Re: [GNC] Asking again - Finance::Quote

[David H]

C:\Strawberry\c\bin - should that be C:\Strawberry\bin. ???

Cheers David H.


On Sun, 3 May 2020 at 09:09, Randy Brachman  wrote:

> I did see that issue and fixed it before all my latest attempts...   But
> thanks.  Here's a piece of the System Path Variable:
>
> ...;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin
>
>
>
>
>
>
> *Randy Brachman -- Live where you
> are. You must be present to win. There is no collective wisdom of
> individual ignorance. The organism only acts in its own best interest.*
>
>
> On Sat, May 2, 2020 at 2:35 PM Fross, Michael  wrote:
>
> > Hello Randy,
> >
> > When last I installed it I had to make sure both the Strawberry\c\bin and
> > the Strawberry\Perl\bin in my path.  Maybe that will help?
> >
> > Michael
> >
> > On Sat, May 2, 2020 at 3:25 PM Randy Brachman  wrote:
> >
> >> I asked for suggestions on this 9 days ago, but haven't gotten any.
> >> Anyone
> >> have recommendations for where else I might get ideas?
> >>
> >> Windows 10 Pro 10.0.18362 on a Dell XPS 8300 x64 PC.
> >>
> >> gnucash version (Help/About):
> >> Version: 3.10
> >> Build ID: 3.10+(2020-04-11)
> >> Finance::Quote: -
> >>
> >> F::Q seems to be installed, having used the Windows "Install Online
> Price
> >> Retrieval" tool.
> >>
> >> gnc-fq-check,  gnc-fq-dump,  gnc-fq-helper,  gnc-fq-update all report
> >> successful completion and/or retrieval of data.
> >> gnc-fq-check:
> >> ("1.49" "adig" "aex" "aiahk" "alphavantage"   "yahoo_json"
> "yahoo_yql"
> >> "za" "za_unittrusts")
> >> gnc-fq-update:
> >> ... Updating database file ... Done!
> >> Date::Manip is up to date (6.81).
> >> Finance::Quote is up to date (1.49).
> >>
> >> gnc-fq-dump nyse ibm:
> >> perl gnc-fq-dump nyse ibm
> >> Finance::Quote fields Gnucash uses:
> >> symbol: ibm  <=== required
> >>   date: 05/01/2020   <=== recommended
> >>   currency: USD  <=== required
> >>   last: 121.8700 <=\
> >>nav:  <=== one of these
> >>  price:  <=/
> >>   timezone:  <=== optional
> >>
> >>
> >> Strawberry Perl successfully installed.
> >> "This is perl 5, version 30, subversion 2 (v5.30.2) built for
> >> MSWin32-x64-multi-thread"
> >>
> >> gnucash Security Editor indicates >Warning: Finance::Quote not installed
> >> properly.<
> >> Entire area below "Quote Source Information" header is grayed out.
> >> Numerous uninstall and reinstall for gnucash, Perl, F::Q without any
> >> change
> >> to this situation.  As far as I can tell, everything else seems OK.
> >>
> >> Thanks for any help.
> >>
> >> *Randy Brachman *
> >>
> >> * -- *
> >> ___
> >> 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.

Re: [GNC] Asking again - Finance::Quote

[Randy Brachman]

I did see that issue and fixed it before all my latest attempts...   But
thanks.  Here's a piece of the System Path Variable:

...;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin






*Randy Brachman -- Live where you
are. You must be present to win. There is no collective wisdom of
individual ignorance. The organism only acts in its own best interest.*


On Sat, May 2, 2020 at 2:35 PM Fross, Michael  wrote:

> Hello Randy,
>
> When last I installed it I had to make sure both the Strawberry\c\bin and
> the Strawberry\Perl\bin in my path.  Maybe that will help?
>
> Michael
>
> On Sat, May 2, 2020 at 3:25 PM Randy Brachman  wrote:
>
>> I asked for suggestions on this 9 days ago, but haven't gotten any.
>> Anyone
>> have recommendations for where else I might get ideas?
>>
>> Windows 10 Pro 10.0.18362 on a Dell XPS 8300 x64 PC.
>>
>> gnucash version (Help/About):
>> Version: 3.10
>> Build ID: 3.10+(2020-04-11)
>> Finance::Quote: -
>>
>> F::Q seems to be installed, having used the Windows "Install Online Price
>> Retrieval" tool.
>>
>> gnc-fq-check,  gnc-fq-dump,  gnc-fq-helper,  gnc-fq-update all report
>> successful completion and/or retrieval of data.
>> gnc-fq-check:
>> ("1.49" "adig" "aex" "aiahk" "alphavantage"   "yahoo_json" "yahoo_yql"
>> "za" "za_unittrusts")
>> gnc-fq-update:
>> ... Updating database file ... Done!
>> Date::Manip is up to date (6.81).
>> Finance::Quote is up to date (1.49).
>>
>> gnc-fq-dump nyse ibm:
>> perl gnc-fq-dump nyse ibm
>> Finance::Quote fields Gnucash uses:
>> symbol: ibm  <=== required
>>   date: 05/01/2020   <=== recommended
>>   currency: USD  <=== required
>>   last: 121.8700 <=\
>>nav:  <=== one of these
>>  price:  <=/
>>   timezone:  <=== optional
>>
>>
>> Strawberry Perl successfully installed.
>> "This is perl 5, version 30, subversion 2 (v5.30.2) built for
>> MSWin32-x64-multi-thread"
>>
>> gnucash Security Editor indicates >Warning: Finance::Quote not installed
>> properly.<
>> Entire area below "Quote Source Information" header is grayed out.
>> Numerous uninstall and reinstall for gnucash, Perl, F::Q without any
>> change
>> to this situation.  As far as I can tell, everything else seems OK.
>>
>> Thanks for any help.
>>
>> *Randy Brachman *
>>
>> * -- *
>> ___
>> 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.

Re: [GNC] How do I add stock trades?

[John Ralls]

Not quite right. While it's correct that in GnuCash's code a currency is a 
commodity with a special namespace, and that an account has only one commodity 
member variable, it's not quite right about a non-currency commodity account 
not having a currency.

Remember that a split has two commodity fields, amount and value, and that 
transactions have a transaction currency field. It's called transaction 
currency because it *must* be a currency, and it's the currency in which all of 
the value fields are denominated.

If you begin a transaction in an account register whose commodity is 
non-currency GnuCash will look up the hierarchy until it finds a parent account 
in currency and use the first one it finds for the transaction currency. It 
does the same in reports, in the Accounts page, and in the summary bar when 
applying prices from the pricedb. That currency of the first parent account 
with a currency for its commodity is sometime referred to in the documentation 
as that child account's currency.

Regards,
John Ralls

> On May 2, 2020, at 10:16 AM, Adrien Monteleone 
>  wrote:
> 
> Yes, I misspoke. Thank you. Technically it is denominated in itself. And 
> technical accuracy is no minor point, especially with accounting, and leads 
> to clearer understanding.
> 
> Regards,
> Adrien
> 
> 
>> On May 2, 2020 w18d123, at 11:42 AM, D.  wrote:
>> 
>> Adrien,
>> 
>> I'm sure I have this wrong, but my understanding is that stock and 
>> currencies are both commodities, and that any given account is denominated 
>> in one. So a stock's "currency" is that commodity (that is, the ABC account 
>> is denominated in the ABC commodity). How it gets converted into a different 
>> currency (e.g., AUD) depends on the parent account.
>> 
>> That is, of course, all technicalities. The rest is correct.
>> 
>> David
> 
> 
> ___
> 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.

Re: [GNC] Asking again - Finance::Quote

[Fross, Michael]

Hello Randy,

When last I installed it I had to make sure both the Strawberry\c\bin and
the Strawberry\Perl\bin in my path.  Maybe that will help?

Michael

On Sat, May 2, 2020 at 3:25 PM Randy Brachman  wrote:

> I asked for suggestions on this 9 days ago, but haven't gotten any.  Anyone
> have recommendations for where else I might get ideas?
>
> Windows 10 Pro 10.0.18362 on a Dell XPS 8300 x64 PC.
>
> gnucash version (Help/About):
> Version: 3.10
> Build ID: 3.10+(2020-04-11)
> Finance::Quote: -
>
> F::Q seems to be installed, having used the Windows "Install Online Price
> Retrieval" tool.
>
> gnc-fq-check,  gnc-fq-dump,  gnc-fq-helper,  gnc-fq-update all report
> successful completion and/or retrieval of data.
> gnc-fq-check:
> ("1.49" "adig" "aex" "aiahk" "alphavantage"   "yahoo_json" "yahoo_yql"
> "za" "za_unittrusts")
> gnc-fq-update:
> ... Updating database file ... Done!
> Date::Manip is up to date (6.81).
> Finance::Quote is up to date (1.49).
>
> gnc-fq-dump nyse ibm:
> perl gnc-fq-dump nyse ibm
> Finance::Quote fields Gnucash uses:
> symbol: ibm  <=== required
>   date: 05/01/2020   <=== recommended
>   currency: USD  <=== required
>   last: 121.8700 <=\
>nav:  <=== one of these
>  price:  <=/
>   timezone:  <=== optional
>
>
> Strawberry Perl successfully installed.
> "This is perl 5, version 30, subversion 2 (v5.30.2) built for
> MSWin32-x64-multi-thread"
>
> gnucash Security Editor indicates >Warning: Finance::Quote not installed
> properly.<
> Entire area below "Quote Source Information" header is grayed out.
> Numerous uninstall and reinstall for gnucash, Perl, F::Q without any change
> to this situation.  As far as I can tell, everything else seems OK.
>
> Thanks for any help.
>
> *Randy Brachman *
>
> * -- *
> ___
> 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.

[GNC] Asking again - Finance::Quote

[Randy Brachman]

I asked for suggestions on this 9 days ago, but haven't gotten any.  Anyone
have recommendations for where else I might get ideas?

Windows 10 Pro 10.0.18362 on a Dell XPS 8300 x64 PC.

gnucash version (Help/About):
Version: 3.10
Build ID: 3.10+(2020-04-11)
Finance::Quote: -

F::Q seems to be installed, having used the Windows "Install Online Price
Retrieval" tool.

gnc-fq-check,  gnc-fq-dump,  gnc-fq-helper,  gnc-fq-update all report
successful completion and/or retrieval of data.
gnc-fq-check:
("1.49" "adig" "aex" "aiahk" "alphavantage"   "yahoo_json" "yahoo_yql"
"za" "za_unittrusts")
gnc-fq-update:
... Updating database file ... Done!
Date::Manip is up to date (6.81).
Finance::Quote is up to date (1.49).

gnc-fq-dump nyse ibm:
perl gnc-fq-dump nyse ibm
Finance::Quote fields Gnucash uses:
symbol: ibm  <=== required
  date: 05/01/2020   <=== recommended
  currency: USD  <=== required
  last: 121.8700 <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional


Strawberry Perl successfully installed.
"This is perl 5, version 30, subversion 2 (v5.30.2) built for
MSWin32-x64-multi-thread"

gnucash Security Editor indicates >Warning: Finance::Quote not installed
properly.<
Entire area below "Quote Source Information" header is grayed out.
Numerous uninstall and reinstall for gnucash, Perl, F::Q without any change
to this situation.  As far as I can tell, everything else seems OK.

Thanks for any help.

*Randy Brachman *

* -- *
___
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.

Re: [GNC] Change account type by editing XML?

[Michael or Penny Novack]

For a small business I was carrying Cost-of-Goods-Sold (COGS) as an
expense item.  When my CPA filed the taxes, I noticed that he placed it
as a deduction to revenue.  So, after a chat with the in-house
accountant, I moved COGS to be under the Income parent.

Thankfully, the internal representation for amounts still worked
correctly and the COGS account now showed as a reduction to Income
without me having to go change the sign on each transaction.


That's a matter of choice. I have never done a "business" tax filing but 
a non-profit has to show total sales and cost of goods sold (line 
items). You can of course put both under a "goods revenue" parent. 
Accounts of type income and type expense are both temporary accounts of 
fundamental type equity and are simply the inverse of each other. In 
other words, expense accounts normally have a debit balance and income 
accounts a credit balance. You can put COGS as a "contra" income account.


BUT -- people who make a lot of use of contra accounts MIGHT be better 
off with the "formal" option (debit and credit) as the "user friendly" 
column titles will be misleading for  contra accounts.


Michael D Novack


___
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.

Re: [GNC] Change account type by editing XML?

[Stephen M. Butler]

On 5/2/20 11:10 AM, Stephen M. Butler wrote:
> On 5/2/20 9:29 AM, Geert Janssens wrote:
>> Do you mean that when you moved the COGS account under the Income
>> parent you also changed the account type to "Income" or did it remain
>> an expense ?
>>
> I changed it to be an Expense type.


Oops.  I meant to say that I changed it to be an Income account.  It
shows as a negative number in the COA.

>>  
>>
>> Note by the way that I have seen it mentioned several times on the
>> mailing lists that the Account Hierarchy view does not necessarily
>> follow the same ordering as your balance sheet.
>>
>>  
>>
>> Regards,
>>
>>  
>>
>> Geert
>>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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.

Re: [GNC] Change account type by editing XML?

[Stephen M. Butler]

On 5/2/20 9:29 AM, Geert Janssens wrote:
>
> Op zaterdag 2 mei 2020 17:58:11 CEST schreef Stephen M. Butler:
>
> > On 5/2/20 2:44 AM, Geert Janssens wrote:
>
> > > Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone:
>
> > >> Indeed, I clicked Edit on an Asset account and I can only change
> it to:
>
> > >>
>
> > >> Bank
>
> > >> Cash
>
> > >> Asset
>
> > >> Credit Card
>
> > >> Liability
>
> > >>
>
> > >> I get the first three if there is going to be a limitation, but
> allowing
>
> > >> the last 2 and not allowing even another debit balanced account like
>
> > >> Expenses?
>
> > >>
>
> > >> Strange.
>
> > >>
>
> > >> I’m starting to wonder if this is a bug. If not, can someone shed
> light
>
> > >> on
>
> > >> the reasoning for not being able to refactor accounts except
> within their
>
> > >> current parent type?
>
> > >
>
> > > The idea here is that you can't put expense accounts under the an
> Asset
>
> > > parent account. So if you want to change an asset account to become an
>
> > > expense account, you will first have to select a parent account
> that is
>
> > > an expense account. That will then allow you to change the account
> type.
>
> > >
>
> > > I agree the UI can use some more polish to make this a better
> experience.
>
> > > The UI's original idea was to show the valid account types that are
>
> > > available for a given parent account. I think this would be more
> easily
>
> > > understood if the parent account and the accountype widgets would
> switch
>
> > > places. It is more intuitive if a lhs selection (for left to right
>
> > > interfaces) affect what can be selected in a rhs selector. Not the
> other
>
> > > way around.
>
> > >
>
> > > Playing with this a bit more I wonder if other combinations make
> sense or
>
> > > possibly conflict with gnucash' internal assumptions. For example, are
>
> > > there valid use cases to store an income account under an expense
> account
>
> > > or the other way around ?
>
> >
>
> > For a small business I was carrying Cost-of-Goods-Sold (COGS) as an
>
> > expense item.  When my CPA filed the taxes, I noticed that he placed it
>
> > as a deduction to revenue.  So, after a chat with the in-house
>
> > accountant, I moved COGS to be under the Income parent.
>
> >
>
> > Thankfully, the internal representation for amounts still worked
>
> > correctly and the COGS account now showed as a reduction to Income
>
> > without me having to go change the sign on each transaction.
>
> >
>
> Do you mean that when you moved the COGS account under the Income
> parent you also changed the account type to "Income" or did it remain
> an expense ?
>
I changed it to be an Expense type.
>
>  
>
> Note by the way that I have seen it mentioned several times on the
> mailing lists that the Account Hierarchy view does not necessarily
> follow the same ordering as your balance sheet.
>
>  
>
> Regards,
>
>  
>
> Geert
>
-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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.

Re: [GNC] How do I add stock trades?

[Adrien Monteleone]

Yes, I misspoke. Thank you. Technically it is denominated in itself. And 
technical accuracy is no minor point, especially with accounting, and leads to 
clearer understanding.

Regards,
Adrien


> On May 2, 2020 w18d123, at 11:42 AM, D.  wrote:
> 
> Adrien,
> 
> I'm sure I have this wrong, but my understanding is that stock and currencies 
> are both commodities, and that any given account is denominated in one. So a 
> stock's "currency" is that commodity (that is, the ABC account is denominated 
> in the ABC commodity). How it gets converted into a different currency (e.g., 
> AUD) depends on the parent account.
> 
> That is, of course, all technicalities. The rest is correct.
> 
> David


___
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.

Re: [GNC] Change account type by editing XML?

[Adrien Monteleone]

I’ve read the location of COGS to be a personal preference. (may even be a 
legal one in some cases)

I can’t see it is anything but an expense, though there is certainly 
disagreement on the subject.

My experience with using it in a P involved Restaurant and Retail. In both 
cases, it appeared *after* the Revenue section but before the general Expenses 
section. (as its own section)

Likely the reason for the placement for tax purposes is a better advantage as a 
reduction of Gross Revenue rather than as deductible expense. (again, might 
even be a legal requirement)

Regards,
Adrien

> On May 2, 2020 w18d123, at 10:58 AM, Stephen M. Butler  wrote:
> 
> 
> For a small business I was carrying Cost-of-Goods-Sold (COGS) as an
> expense item.  When my CPA filed the taxes, I noticed that he placed it
> as a deduction to revenue.  So, after a chat with the in-house
> accountant, I moved COGS to be under the Income parent.
> 
> Thankfully, the internal representation for amounts still worked
> correctly and the COGS account now showed as a reduction to Income
> without me having to go change the sign on each transaction.


___
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.

Re: [GNC] Change account type by editing XML?

[Adrien Monteleone]

> On May 2, 2020 w18d123, at 4:44 AM, Geert Janssens 
>  wrote:
> 
> Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone:
> > Indeed, I clicked Edit on an Asset account and I can only change it to:
> > 
> > Bank
> > Cash
> > Asset
> > Credit Card
> > Liability
> > 
> > I get the first three if there is going to be a limitation, but allowing the
> > last 2 and not allowing even another debit balanced account like Expenses?
> > 
> > Strange.
> > 
> > I’m starting to wonder if this is a bug. If not, can someone shed light on
> > the reasoning for not being able to refactor accounts except within their
> > current parent type?
>  
> The idea here is that you can't put expense accounts under the an Asset 
> parent account. So if you want to change an asset account to become an 
> expense account, you will first have to select a parent account that is an 
> expense account. That will then allow you to change the account type.

Thanks for the info Geert,

I keep forgetting the need to assign a new parent first, my apologies.

>  
> I agree the UI can use some more polish to make this a better experience. The 
> UI's original idea was to show the valid account types that are available for 
> a given parent account. I think this would be more easily understood if the 
> parent account and the accountype widgets would switch places. It is more 
> intuitive if a lhs selection (for left to right interfaces) affect what can 
> be selected in a rhs selector. Not the other way around.


Interesting musing on the UI. I see now, having the type first can lead one to 
think the order is to select it rather than parent first. But as you mention, 
handedness is a concern.

How difficult would it be to show all types, but with some indication that 
certain types are allowed, and if other types are chosen, a warning is issued 
that a new parent matching it *also* needs to be selected, otherwise the change 
will not commit? This would keep the restriction in place, but make the process 
discoverable.

>  
> Playing with this a bit more I wonder if other combinations make sense or 
> possibly conflict with gnucash' internal assumptions. For example, are there 
> valid use cases to store an income account under an expense account or the 
> other way around ?

I could see a case for various mess in the tree, probably to track performance 
of jobs, properties, etc. This would be abusing the tree as an analysis or 
tracking tool, rather than a classification tool. There is a more proper way to 
handle such cases, so allowing it would likely just introduce mess and 
confusion. As it is, some people go through the trouble of creating elaborate 
trees for such things when some additional means of classification or tagging 
would work better.


>  
> And another minor glitch: when you start from for example an Asset account, 
> then change the parent to a liability account and back to an asset account 
> without closing the window in between, the asset account now suddenly has 
> become a Liability account.

Hmm.. Sounds like a bug. I would expect whatever was the last thing I had 
selected would be what would be saved. If any other preference worked this way, 
I could imagine some confusion. I like the idea of real-time preferences 
without `Apply` or `Okay` but it seems then the last change isn’t getting 
applied even with one of those buttons. (as in the first change seems ’sticky’)

Regards,
Adrien
___
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.

Re: [GNC] AqBanking for Canadian banks

[Evenmoreconfused]

Nelson wrote
> Just wondering if anyone was successful in setting up any Canadian banks
> for
> online banking in GnuCash. Thanks for sharing.

I download transactions from several Canadian banks (BMO, TD, CIBC)  in
three different GnuCash files on a regular basis. Works just fine.

I simply select OFX format (sometimes called MS-Money) and let Firefox
download into the downloads folder. Then I go into GnuCash and use File >
Import > Import OFX/QFX...

I imagine there are more automated ways of achieving this, but I'm a bit of
a control freak and hate cleaning up the messes that happen when something
goes awry. This way is roughly the way I like it, actually. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] How do I add stock trades?

[D. via gnucash-user]

Adrien, 

I'm sure I have this wrong, but my understanding is that stock and currencies 
are both commodities, and that any given account is denominated in one. So a 
stock's "currency" is that commodity (that is, the ABC account is denominated 
in the ABC commodity). How it gets converted into a different currency (e.g., 
AUD) depends on the parent account. 

That is, of course, all technicalities. The rest is correct.

David


 Original Message 
From: Adrien Monteleone 
Sent: Sat May 02 21:55:02 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] How do I add stock trades?

As well, the currency of a stock or fund is determined by the currency of the 
parent account.

So if you set up a brokerage with sub-accounts, you set the brokerage to AUD 
and each sub-account is per fund/stock and those are set to their ticker 
symbol. If you own funds/stocks of different currencies with the same brokerage 
you have to set up a different brokerage parent with the proper currency 
assigned and likely put the currency in the brokerage account name for sanity, 
e.g.,

Assets:Current Assets:Investments:Morgan Stanley USD
-Assets:Current Assets:Investments:Morgan Stanley USD:Stock1
-Assets:Current Assets:Investments:Morgan Stanley USD:FundA

Assets:Current Assets:Investments:Morgan Stanley AUD
-Assets:Current Assets:Investments:Morgan Stanley AUD:Stock2
-Assets:Current Assets:Investments:Morgan Stanley AUD:FundB

I’m pretty sure this is covered in the Guide, however.

Regards,
Adrien

> On May 2, 2020 w18d123, at 2:08 AM, D. via gnucash-user 
>  wrote:
> 
> Hello, 
> 
> You have a number of misconceptions going here, beginning with the purpose 
> and implementation of Trading Accounts. If you go to the external article on 
> trading accounts referred to in the wiki, you should get a clearer picture. I 
> am no expert on trading accounts, so I'll let others clear the air on that 
> topic further. 
> 
> However, you would be best advised to go back to the chapter on investments 
> in the Tutorial & Concepts Guide, which is the official documentation for 
> GnuCash. There you will see, for example, that your ABC account should be set 
> up as a Stock or Mutual Fund type account, denominated in ABC commodity 
> (which you will have to add in the security editor), and not in AUD. That 
> account will indicate then how many shares of ABC you own. The price db will 
> be used to determine the value of those shares in your book currency.
> 
> When you sell those shares, you will need to account for the gain or loss, 
> which can be manually calculated and entered, or be done automatically using 
> the lots scrub feature. 
> 
> All of this is covered, as I said, in the Tutorial. Have a read of that, and 
> try again. 
> 
> HTH,
> David

___
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.

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[Adrien Monteleone]

If you want the report in Calc, you can:

1. Copy paste from GnuCash report tab to a Calc spreadsheet

2. Within Calc, use Sheet > Insert Sheet From File (I think File > Open from 
within Calc works also) and choose the saved HTML report.

Now you get to customize the report, adding formulas, additional labels, notes, 
etc.

I use this method to create a Comparison P and Balance Sheet.

Regards,
Adrien


> On May 2, 2020 w18d123, at 7:11 AM, flywire  wrote:
> 
> Thank you. Yes, calc opens them directly with File, Open *.html.
> 
> With Right-click, File open with, select calc and it opens in writer. (File
> association for html is chrome.)
> 
> 
> On Sat, May 2, 2020 at 9:51 PM Derek Atkins  wrote:
> 
>> Yes, it will.. And will parse tables properly into rows/columns.


___
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.

Re: [GNC] Change account type by editing XML?

[Geert Janssens]

Op zaterdag 2 mei 2020 17:58:11 CEST schreef Stephen M. Butler:
> On 5/2/20 2:44 AM, Geert Janssens wrote:
> > Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone:
> >> Indeed, I clicked Edit on an Asset account and I can only change it to:
> >> 
> >> Bank
> >> Cash
> >> Asset
> >> Credit Card
> >> Liability
> >> 
> >> I get the first three if there is going to be a limitation, but allowing
> >> the last 2 and not allowing even another debit balanced account like
> >> Expenses?
> >> 
> >> Strange.
> >> 
> >> I’m starting to wonder if this is a bug. If not, can someone shed light
> >> on
> >> the reasoning for not being able to refactor accounts except within their
> >> current parent type?
> > 
> > The idea here is that you can't put expense accounts under the an Asset
> > parent account. So if you want to change an asset account to become an
> > expense account, you will first have to select a parent account that is
> > an expense account. That will then allow you to change the account type.
> > 
> > I agree the UI can use some more polish to make this a better experience.
> > The UI's original idea was to show the valid account types that are
> > available for a given parent account. I think this would be more easily
> > understood if the parent account and the accountype widgets would switch
> > places. It is more intuitive if a lhs selection (for left to right
> > interfaces) affect what can be selected in a rhs selector. Not the other
> > way around.
> > 
> > Playing with this a bit more I wonder if other combinations make sense or
> > possibly conflict with gnucash' internal assumptions. For example, are
> > there valid use cases to store an income account under an expense account
> > or the other way around ?
> 
> For a small business I was carrying Cost-of-Goods-Sold (COGS) as an
> expense item.  When my CPA filed the taxes, I noticed that he placed it
> as a deduction to revenue.  So, after a chat with the in-house
> accountant, I moved COGS to be under the Income parent.
> 
> Thankfully, the internal representation for amounts still worked
> correctly and the COGS account now showed as a reduction to Income
> without me having to go change the sign on each transaction.
> 
Do you mean that when you moved the COGS account under the Income parent you 
also 
changed the account type to "Income" or did it remain an expense ?

Note by the way that I have seen it mentioned several times on the mailing 
lists that the 
Account Hierarchy view does not necessarily follow the same ordering as your 
balance sheet.

Regards,

Geert
___
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.

Re: [GNC] How do I add stock trades?

[Adrien Monteleone]

As well, the currency of a stock or fund is determined by the currency of the 
parent account.

So if you set up a brokerage with sub-accounts, you set the brokerage to AUD 
and each sub-account is per fund/stock and those are set to their ticker 
symbol. If you own funds/stocks of different currencies with the same brokerage 
you have to set up a different brokerage parent with the proper currency 
assigned and likely put the currency in the brokerage account name for sanity, 
e.g.,

Assets:Current Assets:Investments:Morgan Stanley USD
-Assets:Current Assets:Investments:Morgan Stanley USD:Stock1
-Assets:Current Assets:Investments:Morgan Stanley USD:FundA

Assets:Current Assets:Investments:Morgan Stanley AUD
-Assets:Current Assets:Investments:Morgan Stanley AUD:Stock2
-Assets:Current Assets:Investments:Morgan Stanley AUD:FundB

I’m pretty sure this is covered in the Guide, however.

Regards,
Adrien

> On May 2, 2020 w18d123, at 2:08 AM, D. via gnucash-user 
>  wrote:
> 
> Hello, 
> 
> You have a number of misconceptions going here, beginning with the purpose 
> and implementation of Trading Accounts. If you go to the external article on 
> trading accounts referred to in the wiki, you should get a clearer picture. I 
> am no expert on trading accounts, so I'll let others clear the air on that 
> topic further. 
> 
> However, you would be best advised to go back to the chapter on investments 
> in the Tutorial & Concepts Guide, which is the official documentation for 
> GnuCash. There you will see, for example, that your ABC account should be set 
> up as a Stock or Mutual Fund type account, denominated in ABC commodity 
> (which you will have to add in the security editor), and not in AUD. That 
> account will indicate then how many shares of ABC you own. The price db will 
> be used to determine the value of those shares in your book currency.
> 
> When you sell those shares, you will need to account for the gain or loss, 
> which can be manually calculated and entered, or be done automatically using 
> the lots scrub feature. 
> 
> All of this is covered, as I said, in the Tutorial. Have a read of that, and 
> try again. 
> 
> HTH,
> David

___
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.

Re: [GNC] How do I add stock trades?

[Adrien Monteleone]

I haven’t done stock tracking either, so I can’t comment on if you get 
commodity entries in that tree or not, but as far as I understand them, 
normally, you are *not* doing transactions in them directly. Your transactions 
are entered between your various assets denominated in either your book 
currencies or funds/stock, etc. GnuCash will auto-create the needed Trading 
Accounts splits to keep everything in balance. It is rare you should have to 
touch those Trading splits yourself.

Certainly, you shouldn’t have manually created accounts in the Trading tree 
containing your manually entered investment transactions. All investments go 
under Assets.

Regards,
Adrien

> On May 2, 2020 w18d123, at 2:16 AM, David Cousens  
> wrote:
> 
> The trading accounts should be created automatically when you buy and sell
> shares and stock once the feature is enabled as described in the WIki. You
> don't need to create them at all. I have just started on documneting the use
> of trading accounts with currency transactions. They appear under their own
> top level account Trading of type Trading ( which is a specialized form of
> income account) .This will have a subaccount CURRENCY under which the
> currency exchange transactions are recorded in subaccounts for each currency
> in use. I would expect for stock trades you should get a sub-account
> COMMODITY automatically created and under that a trading account for each
> commodity/security you have buy/sell transactions for.  I haven't tried to
> set it up yet myself but from my experience with the CURRENCY transactions
> this is what I would expect to happen.
> 
> David Cousens


___
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.

Re: [GNC] Change account type by editing XML?

[Stephen M. Butler]

On 5/2/20 2:44 AM, Geert Janssens wrote:
> Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone:
>> Indeed, I clicked Edit on an Asset account and I can only change it to:
>>
>> Bank
>> Cash
>> Asset
>> Credit Card
>> Liability
>>
>> I get the first three if there is going to be a limitation, but allowing the
>> last 2 and not allowing even another debit balanced account like Expenses?
>>
>> Strange.
>>
>> I’m starting to wonder if this is a bug. If not, can someone shed light on
>> the reasoning for not being able to refactor accounts except within their
>> current parent type?
> The idea here is that you can't put expense accounts under the an Asset 
> parent account. So if 
> you want to change an asset account to become an expense account, you will 
> first have to 
> select a parent account that is an expense account. That will then allow you 
> to change the 
> account type.
>
> I agree the UI can use some more polish to make this a better experience. The 
> UI's original idea 
> was to show the valid account types that are available for a given parent 
> account. I think this 
> would be more easily understood if the parent account and the accountype 
> widgets would 
> switch places. It is more intuitive if a lhs selection (for left to right 
> interfaces) affect what can be 
> selected in a rhs selector. Not the other way around.
>
> Playing with this a bit more I wonder if other combinations make sense or 
> possibly conflict with 
> gnucash' internal assumptions. For example, are there valid use cases to 
> store an income 
> account under an expense account or the other way around ?

For a small business I was carrying Cost-of-Goods-Sold (COGS) as an
expense item.  When my CPA filed the taxes, I noticed that he placed it
as a deduction to revenue.  So, after a chat with the in-house
accountant, I moved COGS to be under the Income parent.

Thankfully, the internal representation for amounts still worked
correctly and the COGS account now showed as a reduction to Income
without me having to go change the sign on each transaction.

>  
>
> And another minor glitch: when you start from for example an Asset account, 
> then change the 
> parent to a liability account and back to an asset account without closing 
> the window in 
> between, the asset account now suddenly has become a Liability account.
>
> Regards,
>
> Geert
> ___
> 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.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
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.

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[flywire]

Thank you. Yes, calc opens them directly with File, Open *.html.

With Right-click, File open with, select calc and it opens in writer. (File
association for html is chrome.)


On Sat, May 2, 2020 at 9:51 PM Derek Atkins  wrote:

> Yes, it will.. And will parse tables properly into rows/columns.
>
___
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.

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[Derek Atkins]

Yes, it will.. And will parse tables properly into rows/columns.

-derek
Sent using my mobile device. Please excuse any typos.
On May 2, 2020 7:47:16 AM flywire  wrote:


Off-topic but will LO calc directly open a HTML file? (It opens in
writer and wiki is more about excel.)
___
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.

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[flywire]

Off-topic but will LO calc directly open a HTML file? (It opens in
writer and wiki is more about excel.)
___
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.

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[Derek Atkins]

Yep.  Known issue on windows due to webkit.  Export to html and then load 
into browser and convert to pdf from there.


-derek
Sent using my mobile device. Please excuse any typos.
On May 2, 2020 7:24:29 AM flywire  wrote:


Is exporting Transaction Report as pdf splitting the last line horizontally
over 2 pages a known issue? Occurs on 15 of 38 pages viewed in either
Chrome or Edge under Win10.
___
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.

Re: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[D. via gnucash-user]

Yes. 

Save as html and open/print from browser. 



 Original Message 
From: flywire 
Sent: Sat May 02 16:52:56 GMT+05:30 2020
To: Gnucash Users 
Subject: [GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

Is exporting Transaction Report as pdf splitting the last line horizontally
over 2 pages a known issue? Occurs on 15 of 38 pages viewed in either
Chrome or Edge under Win10.
___
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.

[GNC] Export Transaction Report as pdf Splits Last Line over 2 Pages

[flywire]

Is exporting Transaction Report as pdf splitting the last line horizontally
over 2 pages a known issue? Occurs on 15 of 38 pages viewed in either
Chrome or Edge under Win10.
___
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.

Re: [GNC] How do I add stock trades?

[Arman Schwarz]

Thanks guys for the clarity, I will look into that documentation.

On Sat, 2 May 2020 at 17:19, David Cousens  wrote:

> The trading accounts should be created automatically when you buy and sell
> shares and stock once the feature is enabled as described in the WIki. You
> don't need to create them at all. I have just started on documneting the
> use
> of trading accounts with currency transactions. They appear under their own
> top level account Trading of type Trading ( which is a specialized form of
> income account) .This will have a subaccount CURRENCY under which the
> currency exchange transactions are recorded in subaccounts for each
> currency
> in use. I would expect for stock trades you should get a sub-account
> COMMODITY automatically created and under that a trading account for each
> commodity/security you have buy/sell transactions for.  I haven't tried to
> set it up yet myself but from my experience with the CURRENCY transactions
> this is what I would expect to happen.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.

Re: [GNC] Change account type by editing XML?

[Geert Janssens]

Op zaterdag 2 mei 2020 08:23:19 CEST schreef Adrien Monteleone:
> Indeed, I clicked Edit on an Asset account and I can only change it to:
> 
> Bank
> Cash
> Asset
> Credit Card
> Liability
> 
> I get the first three if there is going to be a limitation, but allowing the
> last 2 and not allowing even another debit balanced account like Expenses?
> 
> Strange.
> 
> I’m starting to wonder if this is a bug. If not, can someone shed light on
> the reasoning for not being able to refactor accounts except within their
> current parent type?

The idea here is that you can't put expense accounts under the an Asset parent 
account. So if 
you want to change an asset account to become an expense account, you will 
first have to 
select a parent account that is an expense account. That will then allow you to 
change the 
account type.

I agree the UI can use some more polish to make this a better experience. The 
UI's original idea 
was to show the valid account types that are available for a given parent 
account. I think this 
would be more easily understood if the parent account and the accountype 
widgets would 
switch places. It is more intuitive if a lhs selection (for left to right 
interfaces) affect what can be 
selected in a rhs selector. Not the other way around.

Playing with this a bit more I wonder if other combinations make sense or 
possibly conflict with 
gnucash' internal assumptions. For example, are there valid use cases to store 
an income 
account under an expense account or the other way around ?

And another minor glitch: when you start from for example an Asset account, 
then change the 
parent to a liability account and back to an asset account without closing the 
window in 
between, the asset account now suddenly has become a Liability account.

Regards,

Geert
___
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.

Re: [GNC] How do I add stock trades?

[David Cousens]

The trading accounts should be created automatically when you buy and sell
shares and stock once the feature is enabled as described in the WIki. You
don't need to create them at all. I have just started on documneting the use
of trading accounts with currency transactions. They appear under their own
top level account Trading of type Trading ( which is a specialized form of
income account) .This will have a subaccount CURRENCY under which the
currency exchange transactions are recorded in subaccounts for each currency
in use. I would expect for stock trades you should get a sub-account
COMMODITY automatically created and under that a trading account for each
commodity/security you have buy/sell transactions for.  I haven't tried to
set it up yet myself but from my experience with the CURRENCY transactions
this is what I would expect to happen.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] How do I add stock trades?

[D. via gnucash-user]

Hello, 

You have a number of misconceptions going here, beginning with the purpose and 
implementation of Trading Accounts. If you go to the external article on 
trading accounts referred to in the wiki, you should get a clearer picture. I 
am no expert on trading accounts, so I'll let others clear the air on that 
topic further. 

However, you would be best advised to go back to the chapter on investments in 
the Tutorial & Concepts Guide, which is the official documentation for GnuCash. 
There you will see, for example, that your ABC account should be set up as a 
Stock or Mutual Fund type account, denominated in ABC commodity (which you will 
have to add in the security editor), and not in AUD. That account will indicate 
then how many shares of ABC you own. The price db will be used to determine the 
value of those shares in your book currency.

When you sell those shares, you will need to account for the gain or loss, 
which can be manually calculated and entered, or be done automatically using 
the lots scrub feature. 

All of this is covered, as I said, in the Tutorial. Have a read of that, and 
try again. 

HTH,
David


 Original Message 
From: armanschwarz 
Sent: Sat May 02 12:12:15 GMT+05:30 2020
To: gnucash-user@gnucash.org
Subject: [GNC] How do I add stock trades?

I would like to start recording my stock trades in GnuCash (3.10). Based on
the instructions I could find
(https://wiki.gnucash.org/wiki/Trading_Accounts) I enabled "Trading"
accounts and then created a top-level Trading account with the name
"Trading".

I tried to fumble through the instructions by creating a sub account with a
stock type "ABC". Then I clicked on "Transfer" and selected "Trading" as my
"From" Account (I had deposited $10,000 into it from my Equity account), and
"ABC" as my "To" account. For "Amount" I picked $10,000 and for "To Amount"
I selected 20,000, at which point GnuCash correctly calculated "1 ABC =
0.5 AUD" (Australian dollars is my currency).

At this point my accounts look like this:

- Trading ($10,000)
  - ASX (-$10,000)
- ABC (20,000- ABC)
  - CURRENCY ($10,000)
- AUD ($10,000)
  ABC (20,000 ABC)

I can't really tell whether this is right or not. In any case I now tried to
sell the stocks, say at $0.6 to simulate a 20% profit. So I hit "Transfer
funds" again and type $12,000 as the amount and select "Trading:ABC" as my
"From" account. However, now Gnucash incorrectly says "Currency AUD
(Australian Dollar)" for the "From" account, when the currency is actually
ABC stock. There's no option for me to select the number of stock or, if
"Amount" is already supposed to represent the number of stock (I can't tell)
then I have no option to select the price I achieved per stock on the sale.

The other thing I tried was sending a negative amount of money from
"Trading" to "Trading:ABC" to simulate the sale, so I typed "-12000" into
the amount column and -2 in the "To Amount" column, which results in the
message "1 ABC = 0.6 AUD" which seems right.

However, now my whole account appears to be in a somewhat buggy state; the
"Trading" account says $10,000 next to it when viewed from the main accounts
window, but when I enter the account, I can see 3 transactions ($10k
transfer from equity, $10k transfer to ABC and $12k transfer back in from
ABC from the sale) with a final balance of $12,000, which doesn't match up
with what I see in the main account. Also, if I click on any of the
transactions I get a popup saying "The current transaction is not balance."
with two options; "Balance it manually" and "Let GnuCash add an adjusting
split". Chosing either option or pressing cancel have no effect, and I can't
click anything else in the window without that popup coming back unless I
close the account or delete the transaction.

I can't inspect any transaction other than the first transfer from Equity as
the popup prevents me from looking at any other splits. However, if I click
on View -> Transaction Journal I can see that all f the transactions seem to
balance, with an equal number of "Increase" and "decrease" amounts for AUD
as well as for ABC.

I also tried this tutorial:
https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-buy-stock1.html

However, the instructions on that wiki page don't match with what I see in
GnuCash (e.g. they have screenshots of "Shares", "Price", "Buy" and "Sell"
columns - I only have "Decrease" and "Increase"), so I wasn't really sure
how to make that work.

Any ideas on how I can use this feature?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] Change account type by editing XML?

[Adrien Monteleone]

They are both debit balanced accounts. Moving the errant asset account to an 
expense type wouldn’t change the debit/credit (sign) of the changed account, 
and the other split could be left alone. (of course, it might be wrong also, 
but that is a bigger problem for the user)

So the incorrect entry might be:

Dr. Assets:Bad Account
  Cr. Assets:Cash

or

Dr. Assets:Bad Account
  Cr. Liabilities:Credit Card

The fixed versions would be:

Dr. Expenses:Correct Account
  Cr. Assets:Cash

or

Dr. Expenses:Correct Account
  Cr. Liabilities:Credit Card

The same would hold true if the errant account had all credit balances, they 
would just become ‘refunds/returns’ of expenses. This depends of course on the 
user getting the debits and credits right in the first place to model the real 
world event correctly. (just with one of the account types wrong)


Regards,
Adrien

> On May 2, 2020 w18d123, at 1:48 AM, D.  wrote:
> 
> Just fishing, but wouldn't the signs change if you moved an asset account, 
> say, to expenses? How would/should GnuCash handle existing transactions in 
> such a moved account?
> 
> David T.

___
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.

Re: [GNC] Change account type by editing XML?

[D. via gnucash-user]

Just fishing, but wouldn't the signs change if you moved an asset account, say, 
to expenses? How would/should GnuCash handle existing transactions in such a 
moved account? 

David T. 


 Original Message 
From: Adrien Monteleone 
Sent: Sat May 02 11:53:19 GMT+05:30 2020
To: Gnucash Users 
Subject: Re: [GNC] Change account type by editing XML?

Indeed, I clicked Edit on an Asset account and I can only change it to:

Bank
Cash
Asset
Credit Card
Liability

I get the first three if there is going to be a limitation, but allowing the 
last 2 and not allowing even another debit balanced account like Expenses?

Strange.

I’m starting to wonder if this is a bug. If not, can someone shed light on the 
reasoning for not being able to refactor accounts except within their current 
parent type?

Regards,
Adrien

> On May 2, 2020 w18d123, at 12:43 AM, flywire  wrote:
> 
> The intent of my post was to report you can't reassign transactions between
> Asset and Expenses accounts either using the process previously described.
> Yes, the account in Asset was created by the import wizard.
> 
> It's nothing serious, went back to the previous file and imported again.


___
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.

[GNC] How do I add stock trades?

[armanschwarz]

I would like to start recording my stock trades in GnuCash (3.10). Based on
the instructions I could find
(https://wiki.gnucash.org/wiki/Trading_Accounts) I enabled "Trading"
accounts and then created a top-level Trading account with the name
"Trading".

I tried to fumble through the instructions by creating a sub account with a
stock type "ABC". Then I clicked on "Transfer" and selected "Trading" as my
"From" Account (I had deposited $10,000 into it from my Equity account), and
"ABC" as my "To" account. For "Amount" I picked $10,000 and for "To Amount"
I selected 20,000, at which point GnuCash correctly calculated "1 ABC =
0.5 AUD" (Australian dollars is my currency).

At this point my accounts look like this:

- Trading ($10,000)
  - ASX (-$10,000)
- ABC (20,000- ABC)
  - CURRENCY ($10,000)
- AUD ($10,000)
  ABC (20,000 ABC)

I can't really tell whether this is right or not. In any case I now tried to
sell the stocks, say at $0.6 to simulate a 20% profit. So I hit "Transfer
funds" again and type $12,000 as the amount and select "Trading:ABC" as my
"From" account. However, now Gnucash incorrectly says "Currency AUD
(Australian Dollar)" for the "From" account, when the currency is actually
ABC stock. There's no option for me to select the number of stock or, if
"Amount" is already supposed to represent the number of stock (I can't tell)
then I have no option to select the price I achieved per stock on the sale.

The other thing I tried was sending a negative amount of money from
"Trading" to "Trading:ABC" to simulate the sale, so I typed "-12000" into
the amount column and -2 in the "To Amount" column, which results in the
message "1 ABC = 0.6 AUD" which seems right.

However, now my whole account appears to be in a somewhat buggy state; the
"Trading" account says $10,000 next to it when viewed from the main accounts
window, but when I enter the account, I can see 3 transactions ($10k
transfer from equity, $10k transfer to ABC and $12k transfer back in from
ABC from the sale) with a final balance of $12,000, which doesn't match up
with what I see in the main account. Also, if I click on any of the
transactions I get a popup saying "The current transaction is not balance."
with two options; "Balance it manually" and "Let GnuCash add an adjusting
split". Chosing either option or pressing cancel have no effect, and I can't
click anything else in the window without that popup coming back unless I
close the account or delete the transaction.

I can't inspect any transaction other than the first transfer from Equity as
the popup prevents me from looking at any other splits. However, if I click
on View -> Transaction Journal I can see that all f the transactions seem to
balance, with an equal number of "Increase" and "decrease" amounts for AUD
as well as for ABC.

I also tried this tutorial:
https://www.gnucash.org/docs/v3/C/gnucash-guide/invest-buy-stock1.html

However, the instructions on that wiki page don't match with what I see in
GnuCash (e.g. they have screenshots of "Shares", "Price", "Buy" and "Sell"
columns - I only have "Decrease" and "Increase"), so I wasn't really sure
how to make that work.

Any ideas on how I can use this feature?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] Change account type by editing XML?

[Adrien Monteleone]

Indeed, I clicked Edit on an Asset account and I can only change it to:

Bank
Cash
Asset
Credit Card
Liability

I get the first three if there is going to be a limitation, but allowing the 
last 2 and not allowing even another debit balanced account like Expenses?

Strange.

I’m starting to wonder if this is a bug. If not, can someone shed light on the 
reasoning for not being able to refactor accounts except within their current 
parent type?

Regards,
Adrien

> On May 2, 2020 w18d123, at 12:43 AM, flywire  wrote:
> 
> The intent of my post was to report you can't reassign transactions between
> Asset and Expenses accounts either using the process previously described.
> Yes, the account in Asset was created by the import wizard.
> 
> It's nothing serious, went back to the previous file and imported again.


___
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.

Re: [GNC] Working with dates in Postgresql DB

[GWB]

Hmm, not able to get to the .sql files yet, but the xml has things like:



  2019-02-14 00:00:00 -0600

...
  
2014-08-05
...
  
2019-04-11 21:30:12 -0500
  

Still digging.

It would be hard to get rid of timestamps altogether, I think, and I'm
not sure if there is an alternative to UTC.  Timestamps are not quite
a data primitive, but gcc, bash, C++, and quite a few other shells and
compilers have it "cooked" into their libraries.  It's probably in the
old assembler compilers.  If ts:date is used for quotes, then it's
necessary for other reasons, right?  I don't use GnuCash for forex or
options, but someone might try that, in which case you need
timestamps.  The Perth to California traveler isn't trivial when it
comes to those markets.  They literally trade on the second over
several time zones.  That's not something I would try to track or
trade in GnuCash, but who knows, it may be reflected in the
accounting.

So gdate is derived from ts:date, or is it entered manually or from
the .ofx, .qfx and .qif files?  It looks like it has to come from the
DTPOSTED field in .ofx, or be manually entered.

More digging.

Gordon

On Sat, May 2, 2020 at 12:46 AM D. via gnucash-user
 wrote:
>
> Was the problem that he entered variant dates, or that GnuCash reinterpreted 
> his Perth transactions to a new date? My point is this: if he entered 
> transactions in Perth for the 11th, and then returned to California, and they 
> showed the 10th, wouldn't his problem have been solved if GnuCash had stored 
> the local date time and then ignored the time zone?
>
>
>  Original Message 
> From: John Ralls 
> Sent: Sat May 02 03:53:01 GMT+05:30 2020
> To: David H 
> Cc: "D." , "Eric H. Bowen via gnucash-user" 
> 
> Subject: Re: [GNC] Working with dates in Postgresql DB
>
> That's exactly what happened a few years ago to a guy from California who did 
> some updates while visiting New Zealand.
>
> Regards,
> John Ralls
>
>
> > On May 1, 2020, at 3:16 PM, David H  wrote:
> >
> > Might be a problem if you were in Perth on April 11 entering txns and then 
> > back in California on April 10 entering further txns using today's date ?  
> > i.e. if you travelled to a timezone that was still the previous day ?
> >
> > Cheers David H.
> >
> >
> > On Sat, 2 May 2020 at 04:35, D. via gnucash-user  
> > wrote:
> > I understand that a lot of debate and discussion and heartache had gone 
> > into this, so I really don't mean to be a pain, but it would seem to me 
> > that if I entered April 10, 2020 for a transaction, and GnuCash then stored 
> > 2020-04-10 HH:MM:SS (where HH:MM:SS represents any arbitrary time), if 
> > GnuCash then ignored the time portion from that point forth, then I'd see 
> > April 10, 2020 no matter how many times I crossed the date line. If I'm in 
> > California on April 10, or in Perth on April 11, I'm presumably going to 
> > pick "today's" date for my transaction. The two dates would be different, 
> > even if the transactions were entered at the exact same time, but I could 
> > only see this as a potential problem for a business with offices in both 
> > cities.
> >
> > As I said, I don't remember all the details, but I'm sure there were solid 
> > reasons for choosing to take transaction dates and store them in UTC, to be 
> > converted back to some arbitrary time zone at a later time. It makes my 
> > head hurt, though.
> >
> > David
> >
> >
> >  Original Message 
> > From: John Ralls 
> > Sent: Fri May 01 23:30:37 GMT+05:30 2020
> > To: "D." 
> > Cc: finf...@gmail.com, "D. via gnucash-user" 
> > Subject: Re: [GNC] Working with dates in Postgresql DB
> >
> > David,
> >
> > You're not thinking it through: It's about 11:00 on Friday 1 May here in 
> > California but it's 03:00 on Saturday 2 May in Western Australia. Chopping 
> > off the time doesn't solve anything, a point illustrated by Finfort when he 
> > pointed out that just changing the time on the errant dates would put them 
> > in the wrong day.
> >
> > Regards,
> > John Ralls
> >
> >
> >
> >
> > > On Apr 30, 2020, at 10:24 PM, D.  wrote:
> > >
> > > Thanks for the reply. I do understand the challenges this poses-- both 
> > > from the perspective of managing it on a daily basis, and from that of 
> > > the difficulty of changing the underlying system. At least, conceptually!
> > >
> > > Is there any option to simply ignore the time portion in these 
> > > timestamps? It would seem to me that one could focus on that, and 
> > > simplify the process piece by piece. Of course, not being a programmer, 
> > > I'm just a silly voice in the wilderness.
> > >
> > > David
> > >
> > >
> > >  Original Message 
> > > From: John Ralls 
> > > Sent: Fri May 01 10:32:09 GMT+05:30 2020
> > > To: "D." 
> > > Cc: "finf...@gmail.com" , "D. via gnucash-user" 
> > > 
> > > Subject: Re: [GNC] Working with dates in Postgresql DB
> > >
> > > David,
> > >
> > > I don't 

Re: [GNC] Mortgage repayment schedule : error while inputting million

[Murugan]

   Hi DerekPlease find the screen shot
 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.