Re: [GNC] Automatic population of posting values based on description ACROSS accounts
On 2023-09-23 08:55, Jan via gnucash-user wrote: > Just trying it one more time, in case somebody knows the answer. Thanks in > advance, Jan You got some suggestions when you posted this before. Did you try them? I think your best solution -- maybe your only solution -- is to work in the General Journal. Auto-completion of new transactions references anything in the current view of the General Journal. Once a new transaction has been created by auto-completion, you can edit it just like any other transaction in the General Journal. All splits are visible and remain where they are even if you change the account in a split.(*) If you want older transactions to provide the source of auto-completion, once you have opened General Journal click View » Filter By, and be sure to tick the Save Filter box. (*) This is not necessarily true in the account registers. Suppose you are working in the register for Account A, and you see all splits because your view is Auto-Split or Transaction Journal, or because you have clicked the Split button for a particular transaction. At least one split in that transaction will reference account A, and it is said to "anchor" the transaction to Account A. If only one split in a particular transaction references Account A -- the usual case -- and you change Account A in that split to reference some other account, the transaction will disappear from Account A's register and appear in the other account's register. Stan Brown Tehachapi, CA, USA https://BrownMath.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
Jan, There were several responses, some of which went to you directly as well as the to the group, to your original posting, between the 12th and the 17th. Perhaps you're not receiving them directly, check your spam folder, and also check wherever you see other postings in the group. Alan A Holmes -Original Message- From: gnucash-user On Behalf Of Jan via gnucash-user Sent: Saturday, September 23, 2023 4:55 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] Automatic population of posting values based on description ACROSS accounts Just trying it one more time, in case somebody knows the answer. Thanks in advance, Jan From: jhoe...@googlemail.com Sent: Tuesday, September 12, 2023 6:48 AM To: gnucash-user@gnucash.org Subject: Automatic population of posting values based on description ACROSS accounts Hi everyone: GnuCash "remembers" the description of postings and fills in previous values, e.g. for account and value. This memory seems to be account dependent, i.e. postings from one account are not remembered in another. Is it possible to turn the automatic population of posting values based on description ACROSS accounts on? Alternatively, is there an easy way to cut a posting out of one account and put it in another (other than using the Transaction Journal view and changing the account manually). With Quicken, you could just cut and paste . Thanks for any help, Jan ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
Just trying it one more time, in case somebody knows the answer. Thanks in advance, Jan From: jhoe...@googlemail.com Sent: Tuesday, September 12, 2023 6:48 AM To: gnucash-user@gnucash.org Subject: Automatic population of posting values based on description ACROSS accounts Hi everyone: GnuCash "remembers" the description of postings and fills in previous values, e.g. for account and value. This memory seems to be account dependent, i.e. postings from one account are not remembered in another. Is it possible to turn the automatic population of posting values based on description ACROSS accounts on? Alternatively, is there an easy way to cut a posting out of one account and put it in another (other than using the Transaction Journal view and changing the account manually). With Quicken, you could just cut and paste . Thanks for any help, Jan ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
I always went the 'pen and ink' route at work, I firmly believe a paper-trail is essential, especially when every transaction is logged in an audit trail, like in Sage Line 50 etc. This way you have a reason and provable explanation as to why a transaction was altered, especially months later when an auditor asks 'Why was this changed?'. For personal finances I go the 'correct the transaction' route, after all I'm not going to 'carpet' myself. On Sat, 16 Sept 2023 at 22:32, Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > On 2023-09-16 13:31, R Losey wrote: > > > There are functions to Cut, Copy, and Paste Transactions... I use them > when > > I find I have posted a transaction to the wrong credit card account. > > For those who may not know ... It's also possible simply to change the > wrong credit card to the right one, directly in the original > transaction. If you do it in the account register for the wrong account, > the transaction will disappear from that register (and appear in the > correct account's register, if you have it open) as soon as you press > Enter to commit the transaction. > > There are two main philosophies around correcting transactions. One > thinks in pen-and-ink terms and so will enter a correcting transaction: > in the case of a credit-card transaction that means a debit to the wrong > account and credit to the correct account. The other will correct an > error by editing the original transaction as outlined above. (Some > people will edit a recent transaction but not a transaction that was > entered months ago. That's my own approach.) > > For people's personal finances, it's a matter of taste which approach to > use. I just mentioned editing an old transaction as another possibility. > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com/ > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
On Sat, Sep 16, 2023 at 4:31 PM Stan Brown (using GC 4.14) < stan...@fastmail.fm> wrote: > On 2023-09-16 13:31, R Losey wrote: > > > There are functions to Cut, Copy, and Paste Transactions... I use them > when > > I find I have posted a transaction to the wrong credit card account. > > For those who may not know ... It's also possible simply to change the > wrong credit card to the right one, directly in the original > transaction. If you do it in the account register for the wrong account, > the transaction will disappear from that register (and appear in the > correct account's register, if you have it open) as soon as you press > Enter to commit the transaction. > > There are two main philosophies around correcting transactions. One > thinks in pen-and-ink terms and so will enter a correcting transaction: > in the case of a credit-card transaction that means a debit to the wrong > account and credit to the correct account. The other will correct an > error by editing the original transaction as outlined above. (Some > people will edit a recent transaction but not a transaction that was > entered months ago. That's my own approach.) > > For people's personal finances, it's a matter of taste which approach to > use. I just mentioned editing an old transaction as another possibility. > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.com/ > While I know I can do this, I just keep forgetting to use it when I put a transaction in the wrong account. Personally, I consider using the wrong account akin to a typographical error, and I don't have a problem editing it correctly, as long as that account has not been reconciled... and usually, reconciliation is when I find I made the error. -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
On 2023-09-16 13:31, R Losey wrote: > There are functions to Cut, Copy, and Paste Transactions... I use them when > I find I have posted a transaction to the wrong credit card account. For those who may not know ... It's also possible simply to change the wrong credit card to the right one, directly in the original transaction. If you do it in the account register for the wrong account, the transaction will disappear from that register (and appear in the correct account's register, if you have it open) as soon as you press Enter to commit the transaction. There are two main philosophies around correcting transactions. One thinks in pen-and-ink terms and so will enter a correcting transaction: in the case of a credit-card transaction that means a debit to the wrong account and credit to the correct account. The other will correct an error by editing the original transaction as outlined above. (Some people will edit a recent transaction but not a transaction that was entered months ago. That's my own approach.) For people's personal finances, it's a matter of taste which approach to use. I just mentioned editing an old transaction as another possibility. Stan Brown Tehachapi, CA, USA https://BrownMath.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
On Tue, Sep 12, 2023 at 5:48 AM Jan via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi everyone: > > > > GnuCash "remembers" the description of postings and fills in previous > values, e.g. for account and value. This memory seems to be account > dependent, i.e. postings from one account are not remembered in another. Is > it possible to turn the automatic population of posting values based on > description ACROSS accounts on? > > > > Alternatively, is there an easy way to cut a posting out of one account and > put it in another (other than using the Transaction Journal view and > changing the account manually). With Quicken, you could just cut and paste > . > > > > Thanks for any help, Jan > There are functions to Cut, Copy, and Paste Transactions... I use them when I find I have posted a transaction to the wrong credit card account. -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Automatic population of posting values based on description ACROSS accounts
On 2023-09-12 03:48, Jan via gnucash-user wrote: > GnuCash "remembers" the description of postings and fills in previous > values, e.g. for account and value. This memory seems to be account > dependent, i.e. postings from one account are not remembered in another. Is > it possible to turn the automatic population of posting values based on > description ACROSS accounts on? Sure -- do data entry in the General Journal rather than in a particular account register. Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Automatic population of posting values based on description ACROSS accounts
Hi everyone: GnuCash "remembers" the description of postings and fills in previous values, e.g. for account and value. This memory seems to be account dependent, i.e. postings from one account are not remembered in another. Is it possible to turn the automatic population of posting values based on description ACROSS accounts on? Alternatively, is there an easy way to cut a posting out of one account and put it in another (other than using the Transaction Journal view and changing the account manually). With Quicken, you could just cut and paste . Thanks for any help, Jan ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Advanced Portfolio Template: Population of data with dividends
Maybe something along the lines of "Money Invested"? On Thu, 9 Dec 2021 at 13:26, D wrote: > > Well, it seems that "Money In" is an ambiguous phrase. Perhaps there is a > better term that this report could use instead? "Purchase Cost" comes to > mind > On Dec 9, 2021, at 06:39, Thomas wrote: >> >> Thanks for the clarification Richard! >> it seems like the dividends are added in another column that I did not >> look into as I always expected to see the dividends in the 'money in' >> column. >> >> Thanks to all of your feedback! >> >> On Wed, 8 Dec 2021 at 19:09, Richard Ullger wrote: >>> >>> >>> I recall the discussions that took place on the mailing list years ago >>> when fixing up the Advanced Portfolio Report. >>> >>> The 'Money In' column reflects only the actual cash You have used to >>> purchase the security. Dividend and interest income is included in the >>> 'Income' column only and not in the 'Money In' column. >>> >>> 'Basis' does include the cost of the security whether bought from your >>> own funds or from income. >>> >>> >>> On 08/12/2021 17:36, Thomas wrote: Thanks Tom and David for your quick replies! I actually found that info some time ago as well, but it seems not to do the trick (for me). In the security's account I have the buy transactions (which are taken into account by the advanced portfolio template) and also the dividend payments in a "neutral" transaction as part of the dividend payment transaction. That means that the dividend transaction has multiple accounts involved (translated, so terms might not be 100% accurate): - "Earnings:Dividends" containing the whole amount I get from the company - "Expenses:Taxes" the amount of taxes that was deducted from the above - "Assets:ClearingAccount" the amount that remained after the deduction of taxes - "Assets:Securities:CompanyXY" just added without any amount Is there something I am missing to make it work? Best, Thomas On Wed, 8 Dec 2021 at 16:45, David Carlson wrote: > > > IIRC Tom's suggestion is the key to getting dividends correctly assigned > in > the Advanced Portfolio Report. I cannot find the documentation either, > but > there is a lot of information in the Tutorial chapter on investments < > https://gnucash.org/viewdoc.phtml?rev=4=C=guide> > > On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira > wrote: > >> On 12/8/21 10:09 AM, Thomas wrote: >>> >>> Dear User-List, >>> >>> I successfully populated the advanced portfolio template with most of >>> the data by selecting of all the accounts of my securities. >>> What I did not manage to get filled is the "money in" column, to also >>> include received dividends in the calculations. I tried to add the >>> accounts with the dividends, but that was not successful. >>> My question essentially is, how to properly fill the "money in" column >>> with dividends. >> >> >> I don't remember where it is in the manual, but add a split to the >> dividend transaction and include the asset account for the stock. You >> shouldn't have to enter any amount for the stock itself unless you are >> reinvesting some or all of the dividend. >> >> >> >> >> 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. > > > > > -- > David Carlson > > > 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] Advanced Portfolio Template: Population of data with dividends
Well, it seems that "Money In" is an ambiguous phrase. Perhaps there is a better term that this report could use instead? "Purchase Cost" comes to mind On Dec 9, 2021, 06:39, at 06:39, Thomas wrote: >Thanks for the clarification Richard! >it seems like the dividends are added in another column that I did not >look into as I always expected to see the dividends in the 'money in' >column. > >Thanks to all of your feedback! > >On Wed, 8 Dec 2021 at 19:09, Richard Ullger wrote: >> >> I recall the discussions that took place on the mailing list years >ago >> when fixing up the Advanced Portfolio Report. >> >> The 'Money In' column reflects only the actual cash You have used to >> purchase the security. Dividend and interest income is included in >the >> 'Income' column only and not in the 'Money In' column. >> >> 'Basis' does include the cost of the security whether bought from >your >> own funds or from income. >> >> >> On 08/12/2021 17:36, Thomas wrote: >> > Thanks Tom and David for your quick replies! >> > >> > I actually found that info some time ago as well, but it seems not >to >> > do the trick (for me). >> > In the security's account I have the buy transactions (which are >taken >> > into account by the advanced portfolio template) and also the >dividend >> > payments in a "neutral" transaction as part of the dividend payment >> > transaction. That means that the dividend transaction has multiple >> > accounts involved (translated, so terms might not be 100% >accurate): >> > - "Earnings:Dividends" containing the whole amount I get from the >company >> > - "Expenses:Taxes" the amount of taxes that was deducted from the >above >> > - "Assets:ClearingAccount" the amount that remained after the >deduction of taxes >> > - "Assets:Securities:CompanyXY" just added without any amount >> > >> > Is there something I am missing to make it work? >> > >> > Best, >> > Thomas >> > >> > On Wed, 8 Dec 2021 at 16:45, David Carlson > wrote: >> >> >> >> IIRC Tom's suggestion is the key to getting dividends correctly >assigned in >> >> the Advanced Portfolio Report. I cannot find the documentation >either, but >> >> there is a lot of information in the Tutorial chapter on >investments < >> >> https://gnucash.org/viewdoc.phtml?rev=4=C=guide> >> >> >> >> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira > >> >> wrote: >> >> >> >>> On 12/8/21 10:09 AM, Thomas wrote: >> Dear User-List, >> >> I successfully populated the advanced portfolio template with >most of >> the data by selecting of all the accounts of my securities. >> What I did not manage to get filled is the "money in" column, to >also >> include received dividends in the calculations. I tried to add >the >> accounts with the dividends, but that was not successful. >> My question essentially is, how to properly fill the "money in" >column >> with dividends. >> >>> >> >>> I don't remember where it is in the manual, but add a split to >the >> >>> dividend transaction and include the asset account for the stock. >You >> >>> shouldn't have to enter any amount for the stock itself unless >you are >> >>> reinvesting some or all of the dividend. >> >>> >> >>> >> >>> ___ >> >>> 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. >> >>> >> >> >> >> >> >> -- >> >> David Carlson >> >> ___ >> >> 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
Re: [GNC] Advanced Portfolio Template: Population of data with dividends
Thanks for the clarification Richard! it seems like the dividends are added in another column that I did not look into as I always expected to see the dividends in the 'money in' column. Thanks to all of your feedback! On Wed, 8 Dec 2021 at 19:09, Richard Ullger wrote: > > I recall the discussions that took place on the mailing list years ago > when fixing up the Advanced Portfolio Report. > > The 'Money In' column reflects only the actual cash You have used to > purchase the security. Dividend and interest income is included in the > 'Income' column only and not in the 'Money In' column. > > 'Basis' does include the cost of the security whether bought from your > own funds or from income. > > > On 08/12/2021 17:36, Thomas wrote: > > Thanks Tom and David for your quick replies! > > > > I actually found that info some time ago as well, but it seems not to > > do the trick (for me). > > In the security's account I have the buy transactions (which are taken > > into account by the advanced portfolio template) and also the dividend > > payments in a "neutral" transaction as part of the dividend payment > > transaction. That means that the dividend transaction has multiple > > accounts involved (translated, so terms might not be 100% accurate): > > - "Earnings:Dividends" containing the whole amount I get from the company > > - "Expenses:Taxes" the amount of taxes that was deducted from the above > > - "Assets:ClearingAccount" the amount that remained after the deduction of > > taxes > > - "Assets:Securities:CompanyXY" just added without any amount > > > > Is there something I am missing to make it work? > > > > Best, > > Thomas > > > > On Wed, 8 Dec 2021 at 16:45, David Carlson > > wrote: > >> > >> IIRC Tom's suggestion is the key to getting dividends correctly assigned in > >> the Advanced Portfolio Report. I cannot find the documentation either, but > >> there is a lot of information in the Tutorial chapter on investments < > >> https://gnucash.org/viewdoc.phtml?rev=4=C=guide> > >> > >> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira > >> wrote: > >> > >>> On 12/8/21 10:09 AM, Thomas wrote: > Dear User-List, > > I successfully populated the advanced portfolio template with most of > the data by selecting of all the accounts of my securities. > What I did not manage to get filled is the "money in" column, to also > include received dividends in the calculations. I tried to add the > accounts with the dividends, but that was not successful. > My question essentially is, how to properly fill the "money in" column > with dividends. > >>> > >>> I don't remember where it is in the manual, but add a split to the > >>> dividend transaction and include the asset account for the stock. You > >>> shouldn't have to enter any amount for the stock itself unless you are > >>> reinvesting some or all of the dividend. > >>> > >>> > >>> ___ > >>> 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. > >>> > >> > >> > >> -- > >> David Carlson > >> ___ > >> 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your
Re: [GNC] Advanced Portfolio Template: Population of data with dividends
If dividends are reinvested, they do add to the cost basis. Wouldn't that be considered "Money In" by the Advanced Portfolio Report? Or is it only "New" money? I think that the dividend income and security purchase or zero share security reference split lines need to be in the same transaction for the APR to assign the dividends to the correct security. Then, if "Money In" does include the reinvested dividends, the report should find them. On Wed, Dec 8, 2021 at 12:09 PM Richard Ullger wrote: > I recall the discussions that took place on the mailing list years ago > when fixing up the Advanced Portfolio Report. > > The 'Money In' column reflects only the actual cash You have used to > purchase the security. Dividend and interest income is included in the > 'Income' column only and not in the 'Money In' column. > > 'Basis' does include the cost of the security whether bought from your > own funds or from income. > > > On 08/12/2021 17:36, Thomas wrote: > > Thanks Tom and David for your quick replies! > > > > I actually found that info some time ago as well, but it seems not to > > do the trick (for me). > > In the security's account I have the buy transactions (which are taken > > into account by the advanced portfolio template) and also the dividend > > payments in a "neutral" transaction as part of the dividend payment > > transaction. That means that the dividend transaction has multiple > > accounts involved (translated, so terms might not be 100% accurate): > > - "Earnings:Dividends" containing the whole amount I get from the company > > - "Expenses:Taxes" the amount of taxes that was deducted from the above > > - "Assets:ClearingAccount" the amount that remained after the deduction > of taxes > > - "Assets:Securities:CompanyXY" just added without any amount > > > > Is there something I am missing to make it work? > > > > Best, > > Thomas > > > > On Wed, 8 Dec 2021 at 16:45, David Carlson > wrote: > >> > >> IIRC Tom's suggestion is the key to getting dividends correctly > assigned in > >> the Advanced Portfolio Report. I cannot find the documentation either, > but > >> there is a lot of information in the Tutorial chapter on investments < > >> https://gnucash.org/viewdoc.phtml?rev=4=C=guide> > >> > >> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira > >> wrote: > >> > >>> On 12/8/21 10:09 AM, Thomas wrote: > Dear User-List, > > I successfully populated the advanced portfolio template with most of > the data by selecting of all the accounts of my securities. > What I did not manage to get filled is the "money in" column, to also > include received dividends in the calculations. I tried to add the > accounts with the dividends, but that was not successful. > My question essentially is, how to properly fill the "money in" column > with dividends. > >>> > >>> I don't remember where it is in the manual, but add a split to the > >>> dividend transaction and include the asset account for the stock. You > >>> shouldn't have to enter any amount for the stock itself unless you are > >>> reinvesting some or all of the dividend. > >>> > >>> > >>> ___ > >>> 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. > >>> > >> > >> > >> -- > >> David Carlson > >> ___ > >> 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. > - >
Re: [GNC] Advanced Portfolio Template: Population of data with dividends
IIRC Tom's suggestion is the key to getting dividends correctly assigned in the Advanced Portfolio Report. I cannot find the documentation either, but there is a lot of information in the Tutorial chapter on investments < https://gnucash.org/viewdoc.phtml?rev=4=C=guide> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira wrote: > On 12/8/21 10:09 AM, Thomas wrote: > > Dear User-List, > > > > I successfully populated the advanced portfolio template with most of > > the data by selecting of all the accounts of my securities. > > What I did not manage to get filled is the "money in" column, to also > > include received dividends in the calculations. I tried to add the > > accounts with the dividends, but that was not successful. > > My question essentially is, how to properly fill the "money in" column > > with dividends. > > I don't remember where it is in the manual, but add a split to the > dividend transaction and include the asset account for the stock. You > shouldn't have to enter any amount for the stock itself unless you are > reinvesting some or all of the dividend. > > > ___ > 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. > -- David Carlson ___ 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] Advanced Portfolio Template: Population of data with dividends
On 12/8/21 10:09 AM, Thomas wrote: Dear User-List, I successfully populated the advanced portfolio template with most of the data by selecting of all the accounts of my securities. What I did not manage to get filled is the "money in" column, to also include received dividends in the calculations. I tried to add the accounts with the dividends, but that was not successful. My question essentially is, how to properly fill the "money in" column with dividends. I don't remember where it is in the manual, but add a split to the dividend transaction and include the asset account for the stock. You shouldn't have to enter any amount for the stock itself unless you are reinvesting some or all of the dividend. ___ 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] Advanced Portfolio Template: Population of data with dividends
Dear User-List, I successfully populated the advanced portfolio template with most of the data by selecting of all the accounts of my securities. What I did not manage to get filled is the "money in" column, to also include received dividends in the calculations. I tried to add the accounts with the dividends, but that was not successful. My question essentially is, how to properly fill the "money in" column with dividends. I also tried to decipher the template definition in GitHub, but unfortunately, I couldn't identify what I would need to do to achieve my goal. Version: 4.8 Version-ID: 4.8a+(2021-09-28) Thanks a lot in advance! Best, Thomas ___ 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: population
Hi Maf I followed your instructions and I am happy I have completely removed the memo and it works well now. -Original Message- From: Maf. King [mailto:m...@chilwell.net] Sent: Friday, August 04, 2017 9:19 AM To: Christine Maloney <cmalon...@talktalk.net> Cc: gnucash-user@gnucash.org Subject: Re: population Hi Christine, OK, so if you can see the "memo" boxes, then you are looking at a splits-view of the transaction. That's fine, I shall do the same and tell you exactly what I press to enter a new transaction in my bank account register. I use auto-split double line as my default view settings, and for this I've got Formal Account labels set, which I think you have too. From the Chart of Accounts view, I double-click to open my bank account register, and the view switches to show it. The Date field of a new transaction is already selected. I press minus twice to enter a transaction from 2 days ago. TAB -> num field. Leave blank. TAB -> Description field. Type TestTransaction TAB -> New Row, Notes field. Type TestNote (won't be visible in single line view) TAB -> New Row, Action field (was num, but the heading has changed) LEave Blank TAB -> 1st Memo. Type test1 TAB -> Account. Already shows bank account. leave it as is. TAB -> Debit. Leave blank TAB -> Credit. Type 1.00 TAB -> New Row, Action. leave blank TAB -> Memo. Type test2 TAB -> Account. Type Expenses TAB -> Debit already filled with 1.00. Leave it. TAB -> Credit. leave blank TAB -> new row, action, leave blank ENTER -> Transaction remains in bank account register in the correct place in date order. what happens if you follow the exact sequence above? If it differs, please explain clearly in terms like above, press such-and-such, click here etc. If you don't want to see the memo lines, then you'll have to go to the View Menu, and select "Basic Ledger", but if you ever need to enter a transaction with more than 2 splits, you'll see them anyway (all transactions in GC have at least 2 splits (to 2 accounts)). HTH, Maf. On Friday, 4 August 2017 00:14:39 BST Christine Maloney wrote: > I am not able to add anything to the credit/debit columns I can only > add entries to the memo lines which I do not even want there. The > version is > 2.6.17 > > -Original Message- > From: Maf. King [mailto:m...@chilwell.net] > Sent: Thursday, August 03, 2017 5:51 PM > To: gnucash-user@gnucash.org; Christine Maloney > <cmalon...@talktalk.net> > Subject: Re: population > > On Thursday, 3 August 2017 17:01:22 BST Christine Maloney via > gnucash-user > > wrote: > > When I add the small amount of £1.00 the system takes it in the memo > > entries, but when I press enter it disappears from the system. > > Hi, > > Only press Enter if you are ready to commit a transaction to the register. > Tab to move between all the various fields for data. > > If you are putting a 1.00 in the memo, then what are you putting in > the transfer account and Credit/Debit/Deposit/Withdrawal etc columns? > > Which version of GC have you installed, so as to be more stable than > what you had previously? > > Maf. > > > --- > This email has been checked for viruses by AVG. > http://www.avg.com -- Maf. King PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7 2B7C E591 E8E1 0DE7 C542 ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
On Thursday, 3 August 2017 17:01:22 BST Christine Maloney via gnucash-user wrote: > When I add the small amount of £1.00 the system takes it in the memo > entries, but when I press enter it disappears from the system. > > Hi, Only press Enter if you are ready to commit a transaction to the register. Tab to move between all the various fields for data. If you are putting a 1.00 in the memo, then what are you putting in the transfer account and Credit/Debit/Deposit/Withdrawal etc columns? Which version of GC have you installed, so as to be more stable than what you had previously? Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: population
When I add the small amount of £1.00 the system takes it in the memo entries, but when I press enter it disappears from the system. From: John Ralls [mailto:jra...@ceridwen.us] Sent: Thursday, August 03, 2017 3:52 PM To: Christine Maloney <cmalon...@talktalk.net> Cc: GNU Cash User <gnucash-user@gnucash.org> Subject: Re: population On Aug 3, 2017, at 2:59 PM, Christine Maloney <cmalon...@talktalk.net <mailto:cmalon...@talktalk.net> > wrote: I have now uninstalled Gnucash and reinstalled a more stable version. This has resolved the issue. However, I am having other issues, such as the accounts will not take a small payment of £1.00 and a memo keeps showing when before it done it all behind the scenes as it were. Christine, Sorry, I don't understand. Can you explain in detail (at the level of "I select x from the menu, enter £1.00 in field y, ...) exactly what you're doing and what happens at each step? Regards, John Ralls --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
> On Aug 3, 2017, at 2:59 PM, Christine Maloneywrote: > > I have now uninstalled Gnucash and reinstalled a more stable version. This > has resolved the issue. However, I am having other issues, such as the > accounts will not take a small payment of £1.00 and a memo keeps showing when > before it done it all behind the scenes as it were. Christine, Sorry, I don't understand. Can you explain in detail (at the level of "I select x from the menu, enter £1.00 in field y, ...) exactly what you're doing and what happens at each step? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: population
Sorry I have uninstalled the version before receiving this message. From: David Carlson [mailto:david.carlson@gmail.com] Sent: Wednesday, August 02, 2017 2:29 PM To: Christine Maloney <cmalon...@talktalk.net> Cc: Dave H <hell...@gmail.com>; AC <gnuc...@acarver.net>; John Ralls <jra...@ceridwen.us>; gnucash-user@gnucash.org Subject: Re: population Christine, It seems that you are the first to report your problem. That is why the developers are asking so many questions about details. Please check the about gnucash screen and tell them the exact release number and build date. David C On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via gnucash-user <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > wrote: Yes the date and time are correct on the PC, I have windows 7 home premium. And I got the latest I think Gnucash 2017. I wonder if there is a fix for this. From: Dave H [mailto:hell...@gmail.com <mailto:hell...@gmail.com> ] Sent: Wednesday, August 02, 2017 12:00 PM To: AC <gnuc...@acarver.net <mailto:gnuc...@acarver.net> >; Christine Maloney <cmalon...@talktalk.net <mailto:cmalon...@talktalk.net> >; John Ralls <jra...@ceridwen.us <mailto:jra...@ceridwen.us> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: population On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > wrote: 13/01/1899 is the exact date. I have downloaded a later version, 2017 and it is still doing the same. The date range is amended correctly but the report still does not show it. Is the date and time correct on your pc and in other programs/apps (clock/calendar) running on your pc ? Cheers Dave H --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: population
I have now uninstalled Gnucash and reinstalled a more stable version. This has resolved the issue. However, I am having other issues, such as the accounts will not take a small payment of £1.00 and a memo keeps showing when before it done it all behind the scenes as it were. From: John Ralls [mailto:jra...@ceridwen.us] Sent: Wednesday, August 02, 2017 4:45 PM To: Christine Maloney <cmalon...@talktalk.net> Cc: Dave H <hell...@gmail.com>; AC <gnuc...@acarver.net>; gnucash-user@gnucash.org Subject: Re: population On Aug 2, 2017, at 2:24 PM, Christine Maloney <cmalon...@talktalk.net <mailto:cmalon...@talktalk.net> > wrote: Yes the date and time are correct on the PC, I have windows 7 home premium. And I got the latest I think Gnucash 2017. I wonder if there is a fix for this. From: Dave H [mailto:hell...@gmail.com] Sent: Wednesday, August 02, 2017 12:00 PM To: AC <gnuc...@acarver.net <mailto:gnuc...@acarver.net> >; Christine Maloney <cmalon...@talktalk.net <mailto:cmalon...@talktalk.net> >; John Ralls <jra...@ceridwen.us <mailto:jra...@ceridwen.us> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> Subject: Re: population On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user < <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org> wrote: 13/01/1899 is the exact date. I have downloaded a later version, 2017 and it is still doing the same. The date range is amended correctly but the report still does not show it. Is the date and time correct on your pc and in other programs/apps (clock/calendar) running on your pc ? Cheers Dave H _ <http://www.avg.com/internet-security> This email has been checked for viruses by AVG antivirus software. <http://www.avg.com/internet-security> www.avg.com Christine, Windows being Windows, have you rebooted since installing GnuCash? The tag at the end of your email suggests another possibility: Have you tried disabling your antivirus program? If neither of those resolves the problem the next test is to create a new user and try running GnuCash while logged in as the new user. Don't customize the new user id at all. Regards, John Ralls --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
> On Aug 2, 2017, at 2:24 PM, Christine Maloney <cmalon...@talktalk.net> wrote: > > Yes the date and time are correct on the PC, I have windows 7 home premium. > And I got the latest I think Gnucash 2017. I wonder if there is a fix for > this. > > From: Dave H [mailto:hell...@gmail.com] > Sent: Wednesday, August 02, 2017 12:00 PM > To: AC <gnuc...@acarver.net>; Christine Maloney <cmalon...@talktalk.net>; > John Ralls <jra...@ceridwen.us> > Cc: gnucash-user@gnucash.org > Subject: Re: population > > > On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user > <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>> wrote: >> 13/01/1899 is the exact date. I have downloaded a later version, 2017 and it >> is still doing the same. The date range is amended correctly but the report >> still does not show it. > > Is the date and time correct on your pc and in other programs/apps > (clock/calendar) running on your pc ? > > Cheers Dave H > > > > <http://www.avg.com/internet-security> > This email has been checked for viruses by AVG antivirus software. > www.avg.com <http://www.avg.com/internet-security> > Christine, Windows being Windows, have you rebooted since installing GnuCash? The tag at the end of your email suggests another possibility: Have you tried disabling your antivirus program? If neither of those resolves the problem the next test is to create a new user and try running GnuCash while logged in as the new user. Don't customize the new user id at all. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
Christine, It seems that you are the first to report your problem. That is why the developers are asking so many questions about details. Please check the about gnucash screen and tell them the exact release number and build date. David C On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via gnucash-user < gnucash-user@gnucash.org> wrote: > Yes the date and time are correct on the PC, I have windows 7 home > premium. And I got the latest I think Gnucash 2017. I wonder if there is a > fix for this. > > > > From: Dave H [mailto:hell...@gmail.com] > Sent: Wednesday, August 02, 2017 12:00 PM > To: AC <gnuc...@acarver.net>; Christine Maloney <cmalon...@talktalk.net>; > John Ralls <jra...@ceridwen.us> > Cc: gnucash-user@gnucash.org > Subject: Re: population > > > > > > On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user < > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > wrote: > > 13/01/1899 is the exact date. I have downloaded a later version, 2017 and > it > is still doing the same. The date range is amended correctly but the report > still does not show it. > > > > Is the date and time correct on your pc and in other programs/apps > (clock/calendar) running on your pc ? > > > > Cheers Dave H > > > > > > --- > This email has been checked for viruses by AVG. > http://www.avg.com > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: population
Yes the date and time are correct on the PC, I have windows 7 home premium. And I got the latest I think Gnucash 2017. I wonder if there is a fix for this. From: Dave H [mailto:hell...@gmail.com] Sent: Wednesday, August 02, 2017 12:00 PM To: AC <gnuc...@acarver.net>; Christine Maloney <cmalon...@talktalk.net>; John Ralls <jra...@ceridwen.us> Cc: gnucash-user@gnucash.org Subject: Re: population On Wed, 2 Aug 2017 at 8:25 pm, Christine Maloney via gnucash-user <gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > wrote: 13/01/1899 is the exact date. I have downloaded a later version, 2017 and it is still doing the same. The date range is amended correctly but the report still does not show it. Is the date and time correct on your pc and in other programs/apps (clock/calendar) running on your pc ? Cheers Dave H --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
RE: population
13/01/1899 is the exact date. I have downloaded a later version, 2017 and it is still doing the same. The date range is amended correctly but the report still does not show it. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+cmaloney4=talktalk@gnucash.org] On Behalf Of John Ralls Sent: Wednesday, August 02, 2017 7:26 AM To: AC <gnuc...@acarver.net> Cc: gnucash-user@gnucash.org Subject: Re: population > On Aug 2, 2017, at 2:10 AM, AC <gnuc...@acarver.net> wrote: > > On 2017-08-01 08:30, John Ralls wrote: > >> The date range is selected on the general tab of report options. You'll find a convenient button in the report toolbar for opening that dialog. >> >> 1899 is a weird value. Have you set an accounting period? >> >> > Windows uses 1/1/1900 as the first second of its epoch rather than the > Unix epoch of 1/1/1970. The year 1899 will sometimes show up if you > feed Windows a zero for epoch seconds (depending on the program it > might also display as January 0, 1900 instead of December 31, 1899, > Excel does > this) Hmm. That's interesting. We don't use the Windows date library at all, so I don't understand how that could be leaking in to GnuCash, but it's a better explanation than anything else I can think of. Christine, what is the *exact* date on the report? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
> On Aug 2, 2017, at 2:10 AM, ACwrote: > > On 2017-08-01 08:30, John Ralls wrote: > >> The date range is selected on the general tab of report options. You'll find >> a convenient button in the report toolbar for opening that dialog. >> >> 1899 is a weird value. Have you set an accounting period? >> >> > Windows uses 1/1/1900 as the first second of its epoch rather than the > Unix epoch of 1/1/1970. The year 1899 will sometimes show up if you > feed Windows a zero for epoch seconds (depending on the program it might > also display as January 0, 1900 instead of December 31, 1899, Excel does > this) Hmm. That's interesting. We don't use the Windows date library at all, so I don't understand how that could be leaking in to GnuCash, but it's a better explanation than anything else I can think of. Christine, what is the *exact* date on the report? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
On 2017-08-01 08:30, John Ralls wrote: > The date range is selected on the general tab of report options. You'll find > a convenient button in the report toolbar for opening that dialog. > > 1899 is a weird value. Have you set an accounting period? > > Windows uses 1/1/1900 as the first second of its epoch rather than the Unix epoch of 1/1/1970. The year 1899 will sometimes show up if you feed Windows a zero for epoch seconds (depending on the program it might also display as January 0, 1900 instead of December 31, 1899, Excel does this) ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
On 2 August 2017 at 04:07, John Rallswrote: > > > On Aug 1, 2017, at 6:07 PM, Christine Maloney > wrote: > > > > Hi john > > I am sorry but I am not sure how to reply to all it does not seem to work > > with outlook. > > Yes I have changed the date on my reports but it still goes to 1899. It > is > > either a bug or I have a corrupt copy or something else I am guessing. > > > > > > > Christine, What version of Outlook are you using as "Reply all" has worked with Outlook for years - just make sure you either have the ribbon with the icons at the top displayed and click the envelope icon that has "Reply All" underneath it (if the icon ribbon is not displayed click the Home menu which should display the ribbon and then click on Reply All. Having said that what version of Windows are you running ? And as John already asked for what version of GnuCash are you running ? Cheers Dave H. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
> On Aug 1, 2017, at 6:07 PM, Christine Maloney <cmalon...@talktalk.net> wrote: > > Hi john > I am sorry but I am not sure how to reply to all it does not seem to work > with outlook. > Yes I have changed the date on my reports but it still goes to 1899. It is > either a bug or I have a corrupt copy or something else I am guessing. > > > >> On Aug 1, 2017, at 2:02 PM, Christine Maloney <cmalon...@talktalk.net >> <mailto:cmalon...@talktalk.net>> > wrote: >> >> Hi john >> Not at all the date is year 1899. Do you know how I can populate the >> columns? >> >> >>> Hello >>> >>> Whenever I try and get a report for the trial balance it produces >>> itself without being populated with amounts although all the accounts >>> are >> there. >>> Could you let me know what I am doing wrong please. >>> >>> Thank you >> >> Does the date shown in the title cover the transactions you've created? >> > > Christine, > > Please remember to copy the list on all replies (reply all works well for > most users). Please also bottom-post. > > The date range is selected on the general tab of report options. You'll find > a convenient button in the report toolbar for opening that dialog. > > 1899 is a weird value. Have you set an accounting period? > > Regards, > John Ralls > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us <mailto:jra...@ceridwen.us>] > Sent: Tuesday, August 01, 2017 4:31 PM > To: Christine Maloney <cmalon...@talktalk.net <mailto:cmalon...@talktalk.net>> > Cc: GnuCash-User List <gnucash-user@gnucash.org > <mailto:gnucash-user@gnucash.org>> > Subject: Re: population > > >> On Aug 1, 2017, at 2:02 PM, Christine Maloney <cmalon...@talktalk.net> > wrote: >> >> Hi john >> Not at all the date is year 1899. Do you know how I can populate the >> columns? >> >> >> -Original Message- >> From: John Ralls [mailto:jra...@ceridwen.us] >> Sent: Monday, July 31, 2017 5:17 AM >> To: Christine Maloney <cmalon...@talktalk.net> >> Cc: GnuCash Users List <gnucash-user@gnucash.org> >> Subject: Re: population >> >> >>> On Jul 30, 2017, at 11:39 PM, Christine Maloney via gnucash-user >> <gnucash-user@gnucash.org> wrote: >>> >>> Hello >>> >>> Whenever I try and get a report for the trial balance it produces >>> itself without being populated with amounts although all the accounts >>> are >> there. >>> Could you let me know what I am doing wrong please. >>> >>> Thank you >> >> Does the date shown in the title cover the transactions you've created? >> > > Christine, > > Please remember to copy the list on all replies (reply all works well for > most users). Please also bottom-post. > > The date range is selected on the general tab of report options. You'll find > a convenient button in the report toolbar for opening that dialog. > > 1899 is a weird value. Have you set an accounting period? Christine, https://support.office.com/en-us/article/Reply-to-or-forward-an-email-message-2d7a77e7-b55d-4921-9c8a-d04b4c70c5a7 <https://support.office.com/en-us/article/Reply-to-or-forward-an-email-message-2d7a77e7-b55d-4921-9c8a-d04b4c70c5a7> has instructions for forwarding and replying to messages.If I misunderstand and you know how to reply all but outlook is ignoring you when you use the "reply all" button then you can just type "gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>" into the "CC" header. What version of GnuCash are you using? I think we might have seen this problem a year or two ago. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
> On Aug 1, 2017, at 2:02 PM, Christine Maloney <cmalon...@talktalk.net> wrote: > > Hi john > Not at all the date is year 1899. Do you know how I can populate the > columns? > > > -Original Message- > From: John Ralls [mailto:jra...@ceridwen.us] > Sent: Monday, July 31, 2017 5:17 AM > To: Christine Maloney <cmalon...@talktalk.net> > Cc: GnuCash Users List <gnucash-user@gnucash.org> > Subject: Re: population > > >> On Jul 30, 2017, at 11:39 PM, Christine Maloney via gnucash-user > <gnucash-user@gnucash.org> wrote: >> >> Hello >> >> Whenever I try and get a report for the trial balance it produces >> itself without being populated with amounts although all the accounts are > there. >> Could you let me know what I am doing wrong please. >> >> Thank you > > Does the date shown in the title cover the transactions you've created? > Christine, Please remember to copy the list on all replies (reply all works well for most users). Please also bottom-post. The date range is selected on the general tab of report options. You'll find a convenient button in the report toolbar for opening that dialog. 1899 is a weird value. Have you set an accounting period? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
> On Jul 30, 2017, at 11:39 PM, Christine Maloney via gnucash-user >wrote: > > Hello > > Whenever I try and get a report for the trial balance it produces itself > without being populated with amounts although all the accounts are there. > Could you let me know what I am doing wrong please. > > Thank you Does the date shown in the title cover the transactions you've created? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: population
Hello Whenever I try and get a report for the trial balance it produces itself without being populated with amounts although all the accounts are there. Could you let me know what I am doing wrong please. Thank you Christine --- This email has been checked for viruses by AVG. http://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.