In the Portfolio display, total of lot amounts do not match total shown for the position.

ewoldde9

In the Investing/Portfolio display I have one position that is in error.

It has three lots in it. The problem is that the sum of the amounts (shares, cost, value, etc.) do not agree with the totals shown for the position as a whole.

By comparing the totals to my brokerage reports, I narrowed it down to one of the lots than has the errors.

Obviously something went wrong with that lot. It could have been some time ago, because I never looked that closely until now.

Is there some way to force Q-Win to recalculate it?

NotACPA

You can try going to that investment account and doing CTRL-Z … but while that will re-calc the account, I don't know what (if anything) it will do in your situation.

What sort of errors does that lot have? Have you previously had sales from that lot? Is the qty of units/shs off? The original purchase price? Have you compared that holding (all lots) to the brokerage's website?

ewoldde9

Of the three lots in that position, only one differs from the values in my brokerage account. The shares, cost, market value, and gain/loss for that lot are off.

This is an old lot (bought in 2009) with several splits, some partial sales, and several donations of shares to charities. (With a 2000% gain, I started giving appreciated shares to save taxes on the gains if I sold them and gave the cash—it also allowed me to raise my donations a bit.) In other words, there are quite a few transactions against this lot; in particular in my first attempts at recording the charitable donations, I vaguely remember having to make updates and deletions to get things to come out right.

I'll try that re-calc method and get back to you.

Tnx

ewoldde9

The re-calc with the Ctrl-Z fixed it.

In the process, Q displayed the following message.

This looks like it is probably one of the donations to charity.

Tnx

ewoldde9

BTW, I would suggest that Ctrl-Z is a poor choice for this function since throughout Windows (not sure of Mac OS) that short-cut is standard for 'undo'.

NotACPA

@ewoldde9 That's FAR from being the only instance in which a shortcut sequence in Q has a different function/meaning that in Windows.

You can see if EDIT, Preferences, Setup, Keyboard Mapping, Windows standard is more to your liking.