Re: [GNC] Payroll Report
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
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?
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?
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
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
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
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?
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
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
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?
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?
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?
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?
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?
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&L 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?
> 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
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?
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
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&L 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?
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?
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?
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?
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
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
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
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
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
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
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?
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?
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?
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?
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. Y
Re: [GNC] Change account type by editing XML?
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.