In this article

How to Register a Purchase Transaction in the Portfolio Tracker

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.

Entering a purchase transaction

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.

Output cells in the transactions tab

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.

Registering cash flows in the Portfolio Tracker

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:

Finding the non-cash portfolio value

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).

How to register the current market price under portfolio holdings

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’:

Transactions tab:

Registering multiple purchases in the Portfolio Tracker

Cash Register & Returns tab:

Entering multiple cash flows in the Portfolio Tracker

Portfolio Holdings tab:

3 stocks portfolio holdings

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.

Next Steps

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.

Not the solution you were looking for? Go back to the knowledge base or get in touch.

Portfolio tracker for stocks and investments
It's free. Now and forever.

The Junto Portfolio Tracker is the complete tool to track your transactions, flows, performance, and decisions.

Every Sunday. Free.

Sign up for the Sunday Briefing newsletter. Each email includes the best stuff I’ve read, a business of the week, a quote of the week, and one short idea to ponder.