How to Manage Stock Splits in iScheduleD Portfolio Manager

Many stocks have gone through splits or reverse splits. This issue is not complicated but often causes troubles in calculating capital gains and losses. Our software iScheduleD Portfolio Manger can help you manage stock splits and reverse splits. This tutorial will show you how to manager stock splits in several simple steps.

We start with a sample csv file in Generic Format - Transaction History and import this data file into a iScheduleD portfolio. Pleas note that the stock XYZ had a 5:1 split on Nov 1, 2010.

Date,Action,Symbol,Quantity,Price,Commission
07/02/2010,Buy,XYZ,1000,59.3,2
08/30/2010,Sell,XYZ,1000,63.25,2
10/03/2010,Buy,XYZ,1000,61.24,2
11/30/2010,Sell,XYZ,3000,13.25,2
12/1/2010,Sell,XYZ,2000,13.93,2
Calculate Schedule D Gains and Losses

 

Without managing stock splits, you do a simple schedule D calculation and you will see that 4000 Sells of XYZ cannot be matched. This is because there are not enough Buy side trades. So you need go to the Widgets tab and click on the 3:1 Stock Split Manager icon. Choosing a stock symbol like XYZ will present you a list of stock trades associated with that symbol.

Found Unmatched Trades

 

There are 3000 shares of XYZ sold on 11/30, 2010 and 2000 shares of XYZ sold on 12/01, 2010. The Buy side trade is the 1000 shares of XYZ bought on 10/03, 2010 before the stock had a 5:1 split. So you only need to split those 1000 shares into 5000 shares in order to match the two sales on 11/30, 2010 and 12/01, 2010 respectively.

You enter a date range from 10/01/2010 to 10/31/2010 and click on the magnifying-glass search icon to select trades to split. You then specify the Split Ratio as 5:1 before clicking on the Split button.

Check Unmatched Trades

 

After clicking on the Split button, you will see the selected stock trades split according to your specifications. If the split results do not look right, go back and check your specification carefully. In this example, the 1000 shares of XYZ at the price of $61.24 are converted to 5000 shares at the price of $12.248. After verifying that the split results are correct, you can click on the Update Portfolio button to update your portfolio.

Export Unmatched Trades to CSV

 

After you have finished splitting stock trades and updating your portfolio, you can go to the Schedule D tab to calculate capital gains and losses. In this example, you will see that all trades of XYZ were matched properly.

Save unmatched_trades.csv

Schedule D
Wash Sale Software

iScheduleD Portfolio Manager Unlimited Edition

iScheduleD 4.0
Portfolio Manager
Unlimited Edition
$29.99 USD