Rounding errors after stock Split Transaction

Legacy KB ID: 4269

Question

The company I have shares in has undergone a corporate restructure which has lead to a reduction in the number of shares in the company.  The value (cost basis) of my holdings is staying the same.  I used the Stock Split option in Quicken but now my share holdings differ from the expected number of shares by a fraction of a share.  What can I do?

Answer

This difference is created by rounding of the ratio of the old shares to new shares. Some ratios (eg 1/3 or 0.333333333...) are infinitely repeating decimals and must be rounded at some point causing a loss of mathematical precision in the share calculation. Quicken attempts to be as accurate as possible but this may not match the whole number of shares assigned to you. The difference is usually a fraction of a share but will be visible when an odd number of shares are involved.

This issue also applies to a standard stock split where the number of shares are increased. 

 

 

Workaround

Sell the existing shares at the purchase price then buy the new shares at a price equal to the original purchase amount.

Example

Original transaction:  Buy 40,011 shares at $1.00 for $40,011

Later, receive 1,075 new shares for the 40,011 old shares.  Value (cost basis) to remain the same:

1.    Sell the old shares at $1.00

2.    Buy the new shares at 40,011 x 1 divided by 1,075 = $37.219535

3.    See that Quicken now lists 1,075 shares at $37.219535 for a Cost Basis of $40,011

4.    On each transaction enter a memo to describe the reason for the action.

5.    If you need to preserve the original date, then do the transactions at the date of the original transaction. 

 

How did we do?

Is the Rolling balance budgeting is missing

Some of my transactions don't report to the tax reports even though a tax code is selected.

Related Articles

Stock Split
Only allowed fifteen split lines in transactions.
Memorised Percentage Split transactions calculate GST incorrectly
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)