Entering a purchase transaction (or sale transaction) in the free Junto Portfolio Tracker requires three registrations: one in the Transactions tab, one in the Cash Register, and one in the Portfolio Holdings tab.
Let’s demonstrate how to correctly enter a purchase of a stock using the fictional company: Company XYZ Inc.
Step 1: Register the Transaction
We first register our purchase by navigating to the Transactions tab and enter the following.
In the date column, enter the date of the transaction.
In the type column, select whether the transaction is a buy, sale, dividend, or split.
In the name of security column, enter the name of the security purchased.
In the ticker column, enter the ticker symbol of the security.
In the quantity column, enter the amount of shares purchased.
In the cost per unit column, enter the price paid per share excluding trading fees.
In the currency column, enter the three-letter currency code for the security and enter the exchange rate at the transaction date in the next column. USD shall be the denominator in the exchange rate: eg. USD/EUR if the given security is traded in EUR.
In the fees (USD) column enter the amount of trading fee paid for the transaction.
Leave the split ratio column empty as it’s only used for stock splits (as explained in our article on stock splits).
After entering your purchase in the input cells, the Portfolio Tracker automatically outputs the following data to the right.
In the far right column, you will see the cash flow that you need to register in the Cash Register in order for the Portfolio Tracker to correctly calculate your money-weighted return over time.
As you can see, our purchase of Company XYZ resulted in a negative cash flow of 200,100 USD because we spent the amount buying the shares.
Step 2: Register the Cash Flow
Now, navigate to the Cash Register & Returns tab and enter the cash flow.
We skip the negative sign because we indicate that it’s an outgoing cash flow. Hence, remember to enter any amount, incoming or outgoing, as positive.
Register the source as an asset purchase and enter the exact cash flow shown from the Transactions tab. The total cash flow is your cost paid for the security plus any fees converted to USD.
Enter the security’s name under the corresponding asset column.
Lastly, enter the value of the non-cash portfolio value. Since we only purchased one security for now and the price hasn’t changed, we know that the value is 200,000 USD which was our cost excluding fees.
However, when the portfolio includes multiple securities and the market values change every day, you can navigate to the Portfolio Overview tab to derive the value as shown here:
Step 3: Register the Market Price
Now, navigate to the Portfolio Holdings tab to see your investment portfolio. Enter the current price of the security under current price (local currency) as well as the company’s/bond’s last annual dividend/interest payout, if any, under last DPU (local currency).
If the security was purchased in a currency other than USD, also enter the current exchange rate in the top bar.
You are now finished registering the purchase of Company XYZ Inc.
Let’s Add a Few More
Let’s add a couple more purchases conducted over the next two months of ‘Div Corporation’ and ‘Euro Ventures GmbH’:
Cash Register & Returns tab:
Portfolio Holdings tab:
Notice that because Euro Ventures GmbH is traded in EUR, we enter the USD/EUR exchange rate in the upper table. And since we only have USD and EUR denominated securities in the portfolio as of now, we don’t need to enter any other exchange rates.
Great job. You now know how the Portfolio Tracker works, how to register capital injections, and how to register any purchase transactions. Here are some other processes you would need to know to manage your portfolio.
How to Review Your Portfolio
Let’s say that 2 months have gone by and you wish to take a look at your portfolio status.
How to Register a Sale Transaction
Let’s say we now wish to sell half of our shares in Euro Ventures GmbH at the current price of 210 EUR.
How to Register a Dividend
It’s now 7 months later and Div Corporation decides to pay the same dividend as last year: 5 USD per share.
How to Register a Stock Split
Company XYZ Inc now decides to do a 2-for-1 stock split so that the amount of shares outstanding doubles and the market price of each share consequently halves.