Quicken rounding problem leaves 0 shares with negative .01 cent value!

What I do when something like that happens is just put in an adjustment for the amount--in this case $.01.

Hi Ken, thanks for the response. Can you tell me how you enter the correction so that it doesn't change the cash balance in the account?

Jerry - I would wait for a reply from either RC White or John Pollard on this. I believe this should NOT happen (ie: be out of whack for .01 after selling an entire position) and we've talked about this a number of times over the years.

It goes something like this (And they can tell you better since I'm bound to have messed this up) that if you had entered the Q purchase information listing shares and total costs (and letting Q figure out any PPS) then when you sell all of the shares with costs per 'lot', Q will NOT be telling you have any $ 'left over'.

But again, wait for them to give you the skinny.

responding to

Jerry wrote: Thanks,Andrew, I will watch for a response from them. Further investigation into the situation reveals that the error occurs when a per share price ends in a .xx5 amount exactly and there are two or more trades to completely exit the position. The software does not round these up, and thus leaves a final value of .01 with no shares left. This may have happened during an upgrade from an earlier version, but I am still checking each and every trade over the last 10 years to see where and when each instance occurred.

I would really like to be able to correct it. I am a nut for total accuracy and I do NOT download anything from brokers. All manually entered.

Thanks again, Jerry

>

Sorry, I don't understand that question. If the cash balance is out by a penny, isn't that what you *do* want to change?

>

responding to

Jerry wrote: Hi Ken,

The cash balance in the account is correct. It is the cash VALUE of a particular stock that is incorrect. The stock has all been sold and the stock is no longer on the Portfolio List, but in the Security List, it has a value of -.01 and a zero number of shares. These small differences are collected in the account and show up on a Net Worth report, creating a difference in the total value of the account, as compared with the Portfolio. This error is most likely due to the rounding that occurs when partial sales are made. It is inevitable. However, there should be a way to correct the small errors that accumulate over time, but it seems there is not.

responding to

Jerry wrote: Thanks,Andrew, I will watch for a response from them. Further investigation into the situation reveals that the error occurs when a per share price ends in a .xx5 amount exactly and there are two or more trades to completely exit the position. The software does not round these up, and thus leaves a final value of .01 with no shares left. This may have happened during an upgrade from an earlier version, but I am still checking each and every trade over the last 10 years to see where and when each instance occurred.

I would really like to be able to correct it. I am a nut for total accuracy and I do NOT download anything from brokers. All manually entered.

Thanks again, Jerry

Jerry,

The final sale should utilize the "sell all" feature for the selected shares. Let Q figure the cost per share. Just enter the total amount received. You will never have any residual amounts when using this method.

Hi, Jerry.

As Andrew and David said, always enter the exact number of shares (including decimal fractions when appropriate) and exact dollars and cents. Let Quicken calculate Price Per Share; that's of only academic interest when we know the number of shares and total dollars. Never enter the PPS for a transaction.

And the "Sell All" choice helps to eliminate these annoying small decimal fractions. The resulting number of share sold may look the same on your screen, but deep inside Quicken, the rounding errors will get resolved.

RC

-- -- R. C. White, CPA San Marcos, TX (Retired. No longer licensed to practice public accounting.) snipped-for-privacy@grandecom.net Microsoft Windows MVP (2002-2010) (Using Quicken 2013 Deluxe R 8 and Windows Live Mail in Win8 x64)

I am not sure how many places Q rounds out to, but here is just one example of many that have accumulated in my accounts.

Bought 2401 shares at one time. Total cost 31,851.60 including commission.

Sold all shares on one day, but the broker apparently sold them in 3 different lots, as the statement I received listed them like this:

1 share sold for 14.39 (including commission)

100 shares sold for 1429.54 (incl. commission)

2300 sh sold for 32,810.34 (incl. commission)

On the account page, there is listed 0 shares remaining at a value of -.01 cents, leaving a current value of .01 cents.

If I change any of the inputs, it will put my cash out of balance. Does anyone have a suggestion as to how this type of error may be reconciled?

Thank you.