Thanks, Martin! I manually entered the reduction of all existing lots in
the previous fund. A pad directive for this discontinued fund combined with
balance assertion would have been handy here. But I see it is not supported
yet.
Thanks a lot for your time!
On Saturday, March 7, 2020 at 3:25:31 PM UTC-8, Martin Blais wrote:
>
> On Sat, Mar 7, 2020 at 2:12 PM <shekh...@gmail.com <javascript:>> wrote:
>
>> Thanks, Martin! Highly appreciate the quick response. However, I am doing
>> this import with python code. So in this case for the middle transaction I
>> don't know that cost was 34.6*3 *(unless I keep track of that in program
>> somehow).
>>
>
> Just change the booking method, leave it out and use {} and let beancount
> match it.
>
>
> I encounter same problem (old accounts being left with non-zero amount)
>> when the fund changes. For example, when all stocks are liquidated in
>> *Target
>> Ret 2045 Tr Sel* and converted to *Target Ret 2045 Tr *(below table)*. *If
>> I were to use what you are suggesting for that case also, then I will have
>> to keep track of all the previous prices and the quantities. Is there a
>> better way for doing this programmatically?
>>
>
> Use automated matching if you can (see above)
> If you cannot, do it by hand and move on (you do this once/year).
> You can produce the list of lots by running the bean-doctor context
> command over a transaction that includes the account in question, it will
> list all the available lots, which you can then cut-n-paste into your file
>
>
>
>
>>
>> Thanks!
>>
>> Date Transaction Description Source Fund Name Quantity Price Transaction
>> Amount
>> 04/11/2019 Plan Initiated TransferIn 2018 ROTH IN PLAN CONVERSION Target
>> Retire 2045 Tr 262.678 $100.0 $26,267.84
>> 04/11/2019 Plan Initiated TransferOut 2018 ROTH IN PLAN CONVERSION Target
>> Ret 2045 Tr Sel 525.36 $50.00 $26,267.84
>>
>> On Friday, March 6, 2020 at 11:47:24 PM UTC-8, Martin Blais wrote:
>>>
>>> plugin "beancount.plugins.auto"
>>>
>>> option "inferred_tolerance_default" "USD:0.01"
>>> option "inferred_tolerance_default" "TGT2045:0.0005"
>>>
>>>
>>> 2017-08-21 * "Plan contribution"
>>> Assets:401k:After-tax 7.219 TGT2045 {34.63 USD}
>>> Income:Salary -250 USD
>>>
>>> 2017-08-30 * "Source to Source/Fund to Fund Transfer Out"
>>> Assets:401k:After-tax -7.219 TGT2045 {34.63 USD} @ 34.65 USD
>>> Income:PnL
>>> Equity:Transfer 250.14 USD
>>>
>>> 2017-08-30 * "Source to Source/Fund to Fund Transfer In"
>>> Assets:401k:Roth 7.219 TGT2045 {34.65 USD}
>>> Equity:Transfer -250.14 USD
>>>
>>>
>>> ;; Or, merging the last two:
>>>
>>> ;;
>>>
>>> ;; 2017-08-30 * "Source to Source/Fund to Fund Transfer Out"
>>>
>>> ;; Assets:401k:After-tax -7.219 TGT2045 {34.63 USD} @ 34.65 USD
>>>
>>> ;; Income:PnL
>>>
>>> ;; Assets:401k:Roth 7.219 TGT2045 {34.65 USD}
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Sat, Mar 7, 2020 at 1:58 AM <shekh...@gmail.com> wrote:
>>>
>>>> I have transactions like those in the below table in my 401k plan.
>>>> I am trying to import those into beancount journal. I opened asset
>>>> accounts with booking method "NONE".
>>>> Can someone guide me how to create transactions for these? I tried
>>>> following
>>>>
>>>> 2017-08-21 Plan contribution
>>>> Assets:401k:After-tax 7.219 {34.63 USD}
>>>> Income:Salary 250 USD
>>>>
>>>> 2017-08-30 Source to Source/Fund to Fund Transfer Out
>>>> Assets:401k:After-tax -7.219 {34.6*5* USD}
>>>> Equity:Transfer 250.14 USD
>>>>
>>>> 2017-08-30 Source to Source/Fund to Fund Transfer In
>>>> Assets:401k:Roth 7.219 {34.6*5* USD}
>>>> Equity:Transfer -250.14 USD
>>>>
>>>> But it leaves some residual amount in the *Assets:401k:After-tax*
>>>> account. Although this number is small here it quickly adds up. Is there a
>>>> better way of doing this? Can I somehow make the Assets:401k:After-tax
>>>> balance go zero after this transfer?
>>>>
>>>> Thanks a lot in advance for your help!
>>>>
>>>>
>>>> Date Transaction Description Source Fund Name Quantity Price Transaction
>>>> Amount
>>>> 08/30/201
>>>> 7 Source to Source/Fund to Fund Transfer Out AFTER-TAX Target Ret 2045
>>>> Tr Sel 7.219 $34.65 $250.14
>>>> 08/30/2017 Source to Source/Fund to Fund Transfer In 2017 ROTH
>>>> CONVERSION Target Ret 2045 Tr Sel 7.219 $34.65 $250.14
>>>> 08/21/2017 Plan Contribution AFTER-TAX Target Ret 2045 Tr Sel 7.219
>>>> $34.63 $250.00
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Beancount" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to bean...@googlegroups.com.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/beancount/f2cdca3b-e052-4e34-95dd-117436b13290%40googlegroups.com
>>>>
>>>> <https://groups.google.com/d/msgid/beancount/f2cdca3b-e052-4e34-95dd-117436b13290%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Beancount" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to bean...@googlegroups.com <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/beancount/f5ce4f9f-0a17-458f-8f16-3ba690ed770e%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/beancount/f5ce4f9f-0a17-458f-8f16-3ba690ed770e%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>
--
You received this message because you are subscribed to the Google Groups
"Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to beancount+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/a180e898-df72-4dca-9337-5e5431996e54%40googlegroups.com.
