Yes David, I am sure my bank manager is going to provide me a detailed report, but it is fun to have all details under control :-D
In fact, it is not so complicated, I only miss the possibility to move the order of transactions of one account manually. Perhaps one solution (that I think it is quite habitual) is to have an optional column "effective date" that could have a different date value if required. El mié., 14 nov. 2018 a las 21:57, David Carlson (< david.carlson....@gmail.com>) escribió: > Wow! > > That would be very messy to track in GnuCash and even a challenge in a > simple spreadsheet. > > Do you have some other software designed to address this scenario? Can > the fund manager give you a detailed report ? > > David C > > On Wed, Nov 14, 2018, 1:28 PM Christian Pinedo Zamalloa < > chr.pin...@gmail.com wrote: > >> Hello, >> >> in our case, the capital/gain losses are delayed in fund transfers and >> only considered when the share is sold. I would try to put a clearer >> example: >> >> Fund A account >> 1, 2010-1-1, buy 10 shares @ 10 €, gross/net buy 100 € >> 2, 2015-1-1, transfer 10 shares @ 9 € to fund B, gross sell 90€ with 10€ >> capital losses, net sell 10 shares @ 10 € = 100€ to obtain 0€ capital >> gain/losess (capital/gain losses delayed because of a fund transfer) >> >> Fund B account >> 1, 2013-1-1, buy 10 shares @ 20 €, gross/net by 200 € >> 2, 2015-1-1, transfer 3 shares @ 30 € from fund A, gross buy 90€ with 10€ >> capital losses forwarded from fund A, net buy 100€ (3 shares @ 33,333333 €) >> >> >> Using net values per share instead of gross values I can track capital >> gain/losses delayed because of transfers automatically with gnucash. >> >> Now If a want to sell Fund B shares: >> >> Fund B account >> ...... >> 3, 2018-11-14, sell 3 shares @ 25 € with 3 x 8,333333 € capital losses >> >> In this case, according to FIFO laws of my country I am selling the >> transfered shares (2. transaction of Fund B). Becuase to order in time the >> sells of shares I have to take into account where I bought initially shares >> (2010-1-1) not when I transfer shares between funds (2015-1-1). So, this is >> why it should be great to we able to order transactions of Fund B account >> in the following way: >> >> Fund B account >> 2, 2015-1-1, transfer 3 shares @ 30 € from fund A, gross buy 90€ with 10€ >> capital losses forwarded from fund A, net buy 100€ (3 shares @ 33,333333 €) >> 1, 2013-1-1, buy 10 shares @ 20 €, gross/net by 200 € >> 3, 2018-11-14, sell 3 shares @ 25 € with 3 x 8,333333 € capital losses >> >> I hope it is now easier to understand my initial question. >> >> Thanks! >> >> >> >> El mié., 14 nov. 2018 a las 19:40, David Carlson (< >> david.carlson....@gmail.com>) escribió: >> >>> If funds were used to buy a different security first then that security >>> was >>> sold for a withdrawal and intermediate gains matter unlike in U.S. >>> custodial accounts, it could get very messy. >>> >>> David C >>> >>> On Wed, Nov 14, 2018 at 9:43 AM D <sunfis...@yahoo.com> wrote: >>> >>> > If OP is looking to track gains using FIFO, wouldn't the lots >>> > functionality work for them? I believe that it uses FIFO exclusively... >>> > >>> > David T. >>> > >>> > On November 14, 2018, at 8:23 PM, David Carlson < >>> > david.carlson....@gmail.com> wrote: >>> > >>> > I think that Christian is asking a slightly different question. I >>> > interpret it that in one parent custodial mutual fund account he >>> purchased >>> > Fund A on dates 1, 2 and later then sold some or all of Fund A and >>> bought >>> > Fund B in the same custodial account on date 3. >>> > >>> > Now I am not sure if he needs to account for capital gain at that >>> point or >>> > later on date 4 when he actually withdraws the funds from the parent >>> > custodial account. >>> > >>> > David C >>> > >>> > On Wed, Nov 14, 2018 at 8:05 AM Derek Atkins <de...@ihtfp.com> wrote: >>> > >>> > > Hi, >>> > > >>> > > On Wed, November 14, 2018 8:42 am, Christian Pinedo Zamalloa wrote: >>> > > > Hello, >>> > > > >>> > > > I would like to know if it is possible to order manually the >>> > transactions >>> > > > of a mutual fund account. >>> > > > >>> > > > When I transfer suscriptions from one mutual fund to another one, >>> the >>> > > > order >>> > > > of the transfer transaction depends on the date when the transfer >>> was >>> > > > done. >>> > > > >>> > > > However, it would be quite useful to reorder this transfer >>> transaction >>> > > > because according to FIFO laws for mutual funds in my country, >>> > transfers >>> > > > of >>> > > > mutual funds mut be ordered according to the initial purchase not >>> to >>> > the >>> > > > date of the transfer between funds. So: >>> > > > >>> > > > - Suscription of Fund A, date: 1, effective_date: 1 >>> > > > - More Subscriptions, date: 2, effective_date: 2 >>> > > > - Transfer of Fund A to Fund B, date: 3, effective_date: 1 >>> > > >>> > > GnuCash does have multiple dates, which include the post-date, >>> > entry-date, >>> > > reconcile-date.. but only one visible date: the post-date. >>> > > >>> > > You have two options: >>> > > >>> > > 1) You could set the post-date to date 3 and put date 1 in the >>> transfer >>> > > description, or >>> > > 2) You can set the post-date to date 1 (and put date 3 in the >>> > description). >>> > > >>> > > I can think of no other way to do what you want. >>> > > >>> > > Personally, (noting that IANAA), I would go with option 1. >>> > > >>> > > > Thanks! >>> > > > >>> > > > -- >>> > > > Christian Pinedo >>> > > >>> > > > Please remember to CC this list on all your replies. >>> > > > You can do this by using Reply-To-List or Reply-All. >>> > > >>> > > -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. >>> > > >>> > _______________________________________________ >>> > 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. >>> >> >> >> -- >> Christian Pinedo Zamalloa (zako) >> PGP keyID: 0xdb577d4ee6ffbd55 >> PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 >> > -- Christian Pinedo Zamalloa (zako) PGP keyID: 0xdb577d4ee6ffbd55 PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 _______________________________________________ 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.
