Jawesome! Thanks everyone. With everyone mentioning the cost basis, I
rechecked the website and it says explicitly "…your cost basis information
will carry over." If I'd have read the very site I linked I probably
could've figured it out 😅.
In any case, lining up all of the lots worked perfectly. Thanks again for
the explanations and examples!
On Tuesday, December 14, 2021 at 11:52:44 AM UTC-8 redst...@gmail.com wrote:
> Hi,
> Problem: you have a bunch of old investor lots, and you want to convert
> them into new admiral lots. The new lots must be scaled for quantity and
> price, but must retain the original dates for the cost bases. Essentially,
> you want your transaction to look like:
>
> 2021-01-01 * "Conversion"
> Assets:Vanguard:VINV -100 VINV {1 USD, 2010-01-01}
> Assets:Vanguard:VINV -80 VINV {1.2 USD, 2010-08-23}
> ...
> ...
> Assets:Vanguard:VADM 50 VADM {2 USD, 2010-01-01}
> Assets:Vanguard:VADM 40 VADM {2.4 USD, 2010-08-23}
> ...
>
> That's the entire transaction. No gains are realized. Your lots retain
> their original dates, which is important.
>
> You probably can take it from here, but for anyone reading along who wants
> an easy way to hit the keystrokes to make it happen: given this is a
> one-time thing, a hack suffices. Simply transform your input lines using
> any kind of scripting. Here is what I do in vim:
>
> Here <https://groups.google.com/g/beancount/c/vDX1oA2mJXA/m/e-GridwaAQAJ>
> is a thread where I discuss this.
>
> 1. Use your editor to edit your transaction and bring up the lots in
> bean-context once you visually select the transaction. I use the excellent
> vim-beancount <https://github.com/nathangrigg/vim-beancount>, and have:
> au FileType beancount nnoremap <buffer> <leader>g vip:GetContext<CR>
>
> 2. filter it through this script:
> !awk '{print $1, -$2*(NEW_QTY/OLD_QTY), $3, $4, $5*(OLD_QTY/NEW_QTY), $6,
> $7}'
> replace the QTY (quantity) fields with your data.
> (you might need to insert a space after the '{' for this to work)
>
> 3. Copy paste the lines into your source .beancount file, and fix up as
> needed
>
> On Tuesday, December 14, 2021 at 7:00:44 AM UTC-8 Hardy Jones wrote:
>
>> I've got an issue that I cannot figure out. I've tried searching here, on
>> GitHub, and reading the docs. But, I'm a bit stuck on what to do.
>>
>> Vanguard has three different share classes
>> <https://investor.vanguard.com/mutual-funds/share-classes>. The
>> important ones for this situation are: Investor and Admiral. The Investor
>> shares have a higher expense ratio, but a lower minimum. The Admiral shares
>> have a lower expense ratio, but a higher minimum. The idea there being that
>> if you cannot afford the minimum for Admiral shares, you can buy the
>> Investor shares instead.
>>
>> Vanguard also allows converting Investor shares to Admiral shares
>> <https://investor.vanguard.com/mutual-funds/convert-to-admiral-shares>
>> if you qualify. The idea there being you might buy some Investor shares
>> over time until you get enough to meet the minimum. The conversion is
>> tax-free, and there are no fees.
>>
>> The issue I'm running into is how do I track this with Beancount? Let's
>> make up some numbers and say I do the naïve thing of buying 100 shares of
>> VTSMX (an Investor class) at $150.00/share:
>>
>> 2010-01-01 * "Vanguard" "Buy VTSMX"
>> Assets:Checking -15,000.00 USD
>> Assets:Vanguard:VTSMX 100 VTSMX {150.00 USD}
>>
>> At the end of the month, I log onto Vanguard's website and convert from
>> VTSMX to VTSAX. In that time, the price of VTSMX has gone up to
>> $175.00/share. The price of VTSAX is $200.00/share. Since this is using
>> Vanguard's conversion, there is no buy/sell event for the shares so no
>> taxes and not profit/loss. Ideally, I'd be able to enter a transaction like:
>>
>> 2010-01-31 * "Vanguard" "Convert VTSMX to VTSAX"
>> Assets:Vanguard:VTSAX 87.5 VTSAX {200.00 USD}
>> Assets:Vanguard:VTSMX -100 VTSMX {150.00 USD} @ 175.00 USD
>>
>> But, this doesn't balance. There's $2,500.00 that needs to be accounted
>> for. There needs to be another posting to balance the transaction, but what
>> is that other posting? On my statement there is only one "Conversion (in)"
>> and one "Conversion (out)" transaction. There are no realized gains or
>> losses from this conversion, no money moves to a settlement account or
>> anything. No taxes had to be paid, etc.
>>
>> It doesn't seem right to make up some fake account to dump the difference
>> into only so the transaction balances, but that's the best I can come up
>> with. Any other ideas about what to do, or maybe what I can do differently
>> to track this correctly?
>>
>
--
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/cc5fb20b-c1d9-4c49-a1fc-c37cd6582574n%40googlegroups.com.
