Re: [GNC] Is there a better way enter multi-currency split transaction?
John Ralls writes: > Trading splits are ignored; they don't turn on the ---split > transaction--- flag in the Transfer Account cell. I think what's > causing grief is the no-value Asset:Stock:ABC split. Oh, yeah, you're absolutely right. That extra split in there is what's causing the confusion! > Regards, > John Ralls -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Is there a better way enter multi-currency split transaction?
Bugzilla will be a better forum to discuss issues with the multicolumn P report: bugs.gnucash.org On Mon, 18 May 2020, 7:31 am davygc, wrote: > Just want to share what I will do as I don't think there will be a solution > soon. > > I will create a sub-account for each currency under all my income and > expense accounts. Foreign income/expenses will be transferred to respective > currency. At the end of each month, I will then transfer all foreign > income/expense to home currency. This way, I can still use the memorized > transaction, I just have to key in the amount twice and it is easier to > spot > the error (typo will create imbalance entry). > > Without converting the income/expense account to home currency, I noticed > the annual total of the multi-column P/L report won't match the sum the > individual months due to the fluctuation in exchange rates. > > Anyway, I have submitted a feature request. If memorized transaction can > add > some extra logic to ignore dummy split with 0 qty and treat it as a normal > debit/credit transaction, everything will be perfect. Hope > someone can look into it. > > Feature request: > > https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/40444765-ignore-dummy-split-in-memorized-transaction-for-pr > > > > -- > 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] Is there a better way enter multi-currency split transaction?
Just want to share what I will do as I don't think there will be a solution soon. I will create a sub-account for each currency under all my income and expense accounts. Foreign income/expenses will be transferred to respective currency. At the end of each month, I will then transfer all foreign income/expense to home currency. This way, I can still use the memorized transaction, I just have to key in the amount twice and it is easier to spot the error (typo will create imbalance entry). Without converting the income/expense account to home currency, I noticed the annual total of the multi-column P/L report won't match the sum the individual months due to the fluctuation in exchange rates. Anyway, I have submitted a feature request. If memorized transaction can add some extra logic to ignore dummy split with 0 qty and treat it as a normal debit/credit transaction, everything will be perfect. Hope someone can look into it. Feature request: https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/40444765-ignore-dummy-split-in-memorized-transaction-for-pr -- 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] Is there a better way enter multi-currency split transaction?
John Ralls-2 wrote > Trading splits are ignored; they don't turn on the ---split transaction--- > flag in the Transfer Account cell. I think what's causing grief is the > no-value Asset:Stock:ABC split. > > > Regards, > John Ralls Yes, the memorized transaction works perfectly without the dummy split -> Asset:Stock:ABC. I also tried the following account structure to record dividend without using dummy transaction: Assets (type ASSET) Broker (type ASSET) Widget Stock (type STOCK) Income (type INCOME) Dividends (type INCOME) Widget Stock (type INCOME) It works but unfortunately it can't handle multi-currency (i.e. reporting the wrong amount) -- 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] Is there a better way enter multi-currency split transaction?
Trading splits are ignored; they don't turn on the ---split transaction--- flag in the Transfer Account cell. I think what's causing grief is the no-value Asset:Stock:ABC split. Regards, John Ralls > On May 16, 2020, at 9:39 AM, Derek Atkins wrote: > > Arguably a transaction that has 2 trading account splits and 2 regular > account splits should be treated like a regular transaction. > > -derek > Sent using my mobile device. Please excuse any typos. > On May 16, 2020 10:07:02 AM John Ralls wrote: > >>> On May 16, 2020, at 4:48 AM, Adrien Monteleone >>> wrote: >>> >>> >>> On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: Not sure whether this is a software limitation or there is a better way to do this. For example, the following memorized transaction for recording stock dividend in USD and Dividend Income in EUR Totalal Deposit Withdrawal Asset\Citibank\USD100.00 Trading\Currency\EUR 92.00 Asset\Stock\ABC Income\Dividend 92.00 Trading\Currency\USD 100.00 My experience is the first time I enter this transaction in the Bank's USD account, the exchange rate screen will popup and convert USD 100.00 to EUR 92 in Income\Dividend. All I have to do is to add a dummy split to indicate the relevant stock for this dividend. >>> >>> You could just put the stock as a Memo in one of the relevant splits. I >>> don’t see a need for a dummy split. >>> However, if I re-enter this transaction with USD 50.00 using the memorized transaction feature, only the first split transaction will be updated with "50.00" and I have to manually change the remain 3 figures. Exchange rate windows won't popup to calculate the currency conversion. >>> >>> Hmm... Seems like a bug. If you are entering transaction with two >>> currencies GC will either ask, or make a guess, but I’ve never seen it do >>> neither. What happens if you change the Dividend amount (as if you were >>> entering this for the first time)? Does GC create new Trading or Imbalance >>> splits? Does it alter the existing Trading splits? >>> >> >> It's not autofill, that finished when it filled in the transaction with a >> copy of the other one that matched. It's because if there's more than two >> splits GnuCash doesn't know how to apportion the changed amount so the edit >> in basic view changes only the split in the current account. >> >> Regards, >> John Ralls >> >> ___ >> 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] Is there a better way enter multi-currency split transaction?
Arguably a transaction that has 2 trading account splits and 2 regular account splits should be treated like a regular transaction. -derek Sent using my mobile device. Please excuse any typos. On May 16, 2020 10:07:02 AM John Ralls wrote: On May 16, 2020, at 4:48 AM, Adrien Monteleone wrote: On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: Not sure whether this is a software limitation or there is a better way to do this. For example, the following memorized transaction for recording stock dividend in USD and Dividend Income in EUR Totalal Deposit Withdrawal Asset\Citibank\USD100.00 Trading\Currency\EUR 92.00 Asset\Stock\ABC Income\Dividend 92.00 Trading\Currency\USD 100.00 My experience is the first time I enter this transaction in the Bank's USD account, the exchange rate screen will popup and convert USD 100.00 to EUR 92 in Income\Dividend. All I have to do is to add a dummy split to indicate the relevant stock for this dividend. You could just put the stock as a Memo in one of the relevant splits. I don’t see a need for a dummy split. However, if I re-enter this transaction with USD 50.00 using the memorized transaction feature, only the first split transaction will be updated with "50.00" and I have to manually change the remain 3 figures. Exchange rate windows won't popup to calculate the currency conversion. Hmm... Seems like a bug. If you are entering transaction with two currencies GC will either ask, or make a guess, but I’ve never seen it do neither. What happens if you change the Dividend amount (as if you were entering this for the first time)? Does GC create new Trading or Imbalance splits? Does it alter the existing Trading splits? It's not autofill, that finished when it filled in the transaction with a copy of the other one that matched. It's because if there's more than two splits GnuCash doesn't know how to apportion the changed amount so the edit in basic view changes only the split in the current account. Regards, John Ralls ___ 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] Is there a better way enter multi-currency split transaction?
> On May 16, 2020, at 4:48 AM, Adrien Monteleone > wrote: > > > >> On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: >> >> Not sure whether this is a software limitation or there is a better way to >> do this. For example, the following memorized transaction for recording >> stock dividend in USD and Dividend Income in EUR >> >> >> Totalal Deposit Withdrawal >> Asset\Citibank\USD100.00 >> Trading\Currency\EUR 92.00 >> Asset\Stock\ABC >> Income\Dividend 92.00 >> Trading\Currency\USD 100.00 >> >> My experience is the first time I enter this transaction in the Bank's USD >> account, the exchange rate screen will popup and convert USD 100.00 to EUR >> 92 in Income\Dividend. All I have to do is to add a dummy split to indicate >> the relevant stock for this dividend. > > You could just put the stock as a Memo in one of the relevant splits. I don’t > see a need for a dummy split. > >> >> However, if I re-enter this transaction with USD 50.00 using the memorized >> transaction feature, only the first split transaction will be updated with >> "50.00" and I have to manually change the remain >> 3 figures. Exchange rate windows won't popup to calculate the currency >> conversion. > > Hmm... Seems like a bug. If you are entering transaction with two currencies > GC will either ask, or make a guess, but I’ve never seen it do neither. What > happens if you change the Dividend amount (as if you were entering this for > the first time)? Does GC create new Trading or Imbalance splits? Does it > alter the existing Trading splits? > It's not autofill, that finished when it filled in the transaction with a copy of the other one that matched. It's because if there's more than two splits GnuCash doesn't know how to apportion the changed amount so the edit in basic view changes only the split in the current account. Regards, John Ralls ___ 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] Is there a better way enter multi-currency split transaction?
> On May 16, 2020 w20d137, at 4:19 AM, Davy Roid wrote: > > Not sure whether this is a software limitation or there is a better way to > do this. For example, the following memorized transaction for recording > stock dividend in USD and Dividend Income in EUR > > > Totalal Deposit Withdrawal > Asset\Citibank\USD100.00 > Trading\Currency\EUR 92.00 > Asset\Stock\ABC > Income\Dividend 92.00 > Trading\Currency\USD 100.00 > > My experience is the first time I enter this transaction in the Bank's USD > account, the exchange rate screen will popup and convert USD 100.00 to EUR > 92 in Income\Dividend. All I have to do is to add a dummy split to indicate > the relevant stock for this dividend. You could just put the stock as a Memo in one of the relevant splits. I don’t see a need for a dummy split. > > However, if I re-enter this transaction with USD 50.00 using the memorized > transaction feature, only the first split transaction will be updated with > "50.00" and I have to manually change the remain > 3 figures. Exchange rate windows won't popup to calculate the currency > conversion. Hmm... Seems like a bug. If you are entering transaction with two currencies GC will either ask, or make a guess, but I’ve never seen it do neither. What happens if you change the Dividend amount (as if you were entering this for the first time)? Does GC create new Trading or Imbalance splits? Does it alter the existing Trading splits? 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.