Am looking for some guidance on how to possibly adjust my BV back to match BV as reported by my broker's statements after a partial Sale:

Using Average Cost method (same as my Broker). No Rounding -- full accuracy.

I have bought units of a Mutual fund in 3 "lots". Then I sold a portion. Unfortunately, this now leads to a BV for the remaining position that went from 2 decimals to 4. Worse, it's off by a few Pennies from what my Broker reports the new BV is. Don't ask me why, no logic there.

How do I best "adjust" the BV of the remaining position
a ) back to a value that has exactly 2 decimals -- the way it was prior to the partial sale, and
b ) align with my broker's recorded BV?

I believe I need an "adjustment transaction" that
a ) increases or decreases the BV,
b ) leaves # shares unchanged,
c ) leaves Cash balance unchanged.
d ) doesn't change the value of the partial sale, as that needs to align with the increase in Cash from the partial Sale.

Basically, some sort of transaction which allows me to manually specify/ override the BV change from a particular Sales transaction in PSM. Or, in other words, allows me to specify the split b/w Realized and Unrealized Gain/ Loss from a particular transaction (which informs the remaining BV).

I can't think of such a transaction type. Closest is Return of Capital, but that only works to REDUCE BV, not increase it. Also, it changes the Cash Balance, I believe.

Any help? Thx.

Just because the initial lots only had two decimals, what happens when you take the average cost of something is that you're dividing, which can create additional decimals. So I don't see a problem with the value having 4 decimals if that is an accurate representation of the remaining BV after the partial sale. If your broker is not showing more decimals, then they are rounding. As far as it being off by a few pennies, it may be the aforementioned 4-digit precision limit that is causing that, in relation to the average cost calculation.

I will take a closer look at the sample file you sent in email to see if there is an issue.

Hi -- I have been thinking a bit more about a Transaction Type (to adjust BV) that meets the above criteria a - d.

What do you think about me using a Dividend Reinvestment Transaction with zero Shares, zero Price per Share, zero everything EXCEPT Fee. For Fee, I set it to exactly the amount of BV adjustment I want to accomplish. Positive fee if I want to increase the BV of remaining Holding, negative Fee to decrease BV of remaining Holding.

I know it's kind of a roundabout way to manually adjust the BV to re-match my brokers' records, but if it's necessary, can you see any Downside to this later on if it otherwise makes the records match again?
I think this meets a - d.

Too bad I couldn't do it right as part of the Sales transaction through a "BV Adjustment" field that doesn't impact Cash and MV of Sale. I think all current Fields in a Sales transaction do impact both Cash Balance and MV of Sale/ remaining Holdings.

If this works well to adjust BV, would it be possible to kind of replicate the "Dividend Reinvestment" transaction type, but give the exact replica a different Transaction type name like "Book Value Adjustment", and only enable the "Fee" field in such transaction type (everything else is zero)? Other than that, it would feed all calculations exactly like a Reinvested Dividend with zero shares, zero commission, zero Share Price.

Having a dedicated transaction type for this would keep such transactions cleanly separate from "true" Dividend Reinvestments. I am kind of just bastardizing that transaction type as it allows a BV adjustment -- but not exactly what it was meant for.

Am curious what you think.

If it gives you the numbers you want to see, I don't see a problem with using it. Just make a note as to why it's there in case you need to remove it in the future.

Total Cost Adjustment of Holding (both positive or negative) via Reinv. Dividend with zero # Shares, zero Share Price, positive/ negative Fee appears to be working well -- ver9.2.3. build 350.

Thanks for the enhancement!