|
|
PORTFOLIO TRACKER 2008 © (ver 12.0) 2002-2009 all rights reserved |
|
|
PORTFOLIO
TRACKER 2008's ABILITY TO BRING IN A BROKERS STATEMENT IS LIMITED TO,
AND INTENDED FOR - STOCKS &
MUTUAL FUNDS & OPTIONS
! THE INTENT IS TO ASSIST YOU IN SCHEDULE "D" AND .TXF FILE GENERATION ! |
|
IT WILL, HOWEVER - GENERATE A .TXF FILE FOR INFORMATION YOU
MANUALLY ENTERED :
SUCH AS INTEREST EARNED, MARGIN INTEREST PAID, AND QUALIFIED / NON-QUALIFIED DIVIDENDS & MUTUAL FUND FEES (SEE BELOW). |
 |
 |
 |
 |
| TYPE 1 |
| TYPE 1 BROKER INPUT STOCKS & MUTUAL FUNDS & OPTIONS via .xls or MANUAL INPUT |
| EACH LINE IS COMPLETE WITH A BUY AND A SELL . CLICK HERE TO SELECT . |
| A | B | C | D | E | F | ||
| 1 | CLOSE DATE, CLOSE, CLOSED, SOLD/CLOSED, SALE DATE, SOLD DATE | OPEN DATE, OPEN, ACQUIRED/OPEN, DATE OPEN, DATE OPENED | SECURITY, TICKER, SYMBOL, DESCRIPTION | SHARE, SHARES SOLD, SHARES, QUANTITY, QUANTITY/PAR | SALES, PROCEEDS, TOTAL PROCEEDS, SALE PRICE, SALE AMOUNT | COST, COST BASIS, AMOUNT PAID, PURCHASE AMOUNT | ROW 1 MUST BE THE HEADER INFORMATION. |
| 2 | 1/30/07 | 1/4/07 | ABC | 200 | $19,234.67 | $18,789.45 | ROW 2 MUST BEGIN THE DATA. |
| TYPE 2 |
|
TYPE 2 BROKER INPUT
STOCKS & MUTUAL FUNDS & OPTIONS via .xls or MANUAL INPUT (MANUALLY INPUTTED OPTIONS MUST CONTAIN BUY / SELL INFORMATION) |
| EACH LINE OF STOCK CONTAINS A SINGLE TRANSACTION, BUY, SELL, SHORT OR COVER. CLICK HERE TO SELECT . . |
| A | B | C | D | E | F | G | ||
| 1 | DATE | ACTION | SYMBOL | QUANTITY | SHARE PRICE OR | TOTAL AMOUNT | OPTIONAL COLUMN COMMISSIONS | ROW 1 MUST BE THE HEADER INFORMATION. |
| 2 | 1/30/07 | BUY | ABC | 100 | $25.00 | $2,500.00 | 7.00 | ROW 2 MUST BEGIN THE DATA. |
| TYPE 3 |
|
TYPE 3 BROKER INPUT
STOCKS & MUTUAL FUNDS & OPTIONS via .xls or MANUAL INPUT (MANUALLY INPUTTED OPTIONS MUST CONTAIN BUY / SELL INFORMATION) |
| EACH LINE OF STOCK INFO CONTAINS A SINGLE TRANSACTION, BUY, SELL, SHORT OR COVER. CLICK HERE TO SELECT . . |
| A | B | C | D | E | F | ||
| 1 | DATE | ACTION | DESCRIPTION | SHARE PRICE OR | TOTAL AMOUNT | OPTIONAL COLUMN COMMISSIONS | ROW 1 MUST BE THE HEADER INFORMATION. |
| 2 | 1/30/07 | SELL | 100 ABC | $25.00 | $2,500.00 | 7.15 | ROW 2 MUST BEGIN THE DATA. |
|
|
| Manually Inputted Money Data - a .txf File will also be generated for the information below . . |
| Interest Received | Margin Interest Paid | Mutual Fund Fees Paid | Dividends Received | ||||||||
| Income | $57.87 | Expense | $6.61 | Expense | $40.00 | Qualified Dividend Income | $180.00 | Non-Qualified Dividend Income | $54.00 | ||
| Date | Amount | Date | Amount | Date | Amount | Q = Qualified N = Non-Qualified | Symbol | Date | Amount Per Share | # of Shares | Total |
| 01/31/08 | $15.45 | 01/31/08 | $5.40 | 01/31/08 | $15.00 | Q | IBM | 01/15/08 | $0.45 | 100 | $45.00 |
| 02/28/08 | $21.21 | 02/28/08 | $1.21 | 02/28/08 | $12.00 | N | GE | 01/15/08 | $0.27 | 200 | $54.00 |
| 03/31/08 | $27.11 | 03/31/08 | $0.00 | 03/31/08 | $22.00 | Q | WM | 01/15/08 | $0.45 | 300 | $135.00 |
|
|