Adjusting Asset Value Post Import

[B2B_Investing]

Aloha Mark,

I am adding additional existing brokerage accounts to FM Personal. The brokerage firm export I was using had some very messy dividend transactions for historic transactions. The effort to clean up was just too messy. As such I imported all of the BUY, SELL transactions. About half of the investments then needed Transfer In / Out entries to true up the shares and dollars. This was mostly for sold investments to zero them out but also a few active investments.

There are a handful of active investments with the correct share amount but the value is off by a penny, always high. I there a clean way to adjust them so the reconcile function will not raise a discrepancy?

Jason

[Mark]

Hello Jason,

You can turn up your "Options / General Preferences... / Display / Share Digits" to the maximum of 6. Then, open up the investment in the Data Register, and make sure you own the exact correct number of shares. If there is an error, either correct the incorrectly recorded prior transactions, or you can make an adjustment entry.

When reconciling the share balance is what is reconciled, not the value. The value is determined by multiplying the shares time the market price. Once you have your shares correct, check the market price is also correct in the Data Register under the data type of "Prices".

[B2B_Investing]

Great. Thanks Mark.

Jason