Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials ETF & Index Fund Tracker Spreadsheet Template for Google Sheets & Excel

Cost basis against current value on fifteen funds, and the gain, the overall return and each holding's share of the portfolio all follow from that pair. The Essentials ETF & Index Fund Tracker spreadsheet template records the annual charge per fund and weights it by holding size instead of averaging it flat, then reports the whole portfolio on a Dashboard. Two working sheets and an allocation chart. One file for Google Sheets and Excel. No macros, no VBA.

Instant digital delivery · Terms & Conditions apply

Essentials ETF & Index Fund Tracker spreadsheet template - Google Sheets and Excel preview

What's Included

  • Fifteen funds with name, ticker, units, cost basis and current value
  • Gain and overall return derived from cost against value
  • Each holding's share of the portfolio
  • Annual charge recorded per fund
  • A weighted average charge across the portfolio, not a flat average
  • Dashboard with total value, total gain, return, and how many funds are ahead
  • A pie chart carrying the allocation by value
  • Values entered by you rather than pulled from a feed
  • A currency dropdown on the Dashboard that relabels money columns across both sheets
  • Works in Microsoft Excel and Google Sheets with no setup required

The FinancialAha Essentials ETF & Index Fund Tracker Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that measures a fund portfolio rather than valuing it, with a How to Use guide on a third tab. It works as an Essentials ETF & Index Fund Tracker Excel template and an Essentials ETF & Index Fund Tracker Google Sheets template from the same download. Where the Free build totals what you hold, this Essentials ETF & Index Fund Tracker spreadsheet template sets cost against current value to give the gain, each fund's share of the whole, and what the charges weigh across the portfolio. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials ETF & Index Fund Tracker spreadsheet template

The FinancialAha Essentials ETF & Index Fund Tracker Spreadsheet Template runs on two working sheets - one you type into, one that reports back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials ETF & Index Fund Tracker spreadsheet holds.

  1. 01 of 02

    Funds

    The sheet you type into, a row per fund. Each takes its name and ticker, the units held, what you put in and what it is worth now - and from those last two the share of the portfolio it represents follows. Alongside sits the annual charge, one of the few things that separates one index fund from another once the index itself is the same. Both the cost and the current value are entered, so nothing here depends on a price feed.

    FinancialAha ETF & Index Fund Tracker spreadsheet template - Funds sheet

  2. 02 of 02

    Dashboard

    The portfolio in six figures: what it is worth, the gain against what went in, the return that represents, how many funds are held, how many are ahead, and the weighted average charge across the whole thing. That last one is the figure worth having - an average of the ratios would be misleading, because the charge on a large holding matters more than the charge on a small one. A pie chart carries the allocation by value.

    FinancialAha ETF & Index Fund Tracker Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what each column expects, and how the dashboard figures are arrived at. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials ETF & Index Fund Tracker Spreadsheet template for Google Sheets

Upload the Essentials ETF & Index Fund Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials ETF & Index Fund Tracker Google Sheets template needs no conversion step and the chart survives the trip intact - the totals keep working exactly as they do in Excel. The currency dropdown on the Dashboard relabels every money column across both sheets at once.

Essentials ETF & Index Fund Tracker Google Sheets template setup

A shared copy of the Essentials ETF & Index Fund Tracker Google Sheets template suits a portfolio held jointly or reviewed by someone else, and Sheets version history covers a value typed over. Because the reporting sits on its own tab, the fund list stays a list.

Sharing the Essentials ETF & Index Fund Tracker Google Sheet

The Essentials ETF & Index Fund Tracker Google Sheet is a periodic job rather than a daily one: values are entered rather than fetched, so updating on a monthly or quarterly rhythm keeps it useful without turning it into a chore.

Essentials ETF & Index Fund Tracker Spreadsheet template for Excel

The Essentials ETF & Index Fund Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials ETF & Index Fund Tracker Excel template directly, with no import step and no compatibility prompt, and the chart is a native Excel chart that redraws as values change. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials ETF & Index Fund Tracker Excel template setup

The same Essentials ETF & Index Fund Tracker Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials ETF & Index Fund Tracker spreadsheet download to choose between.

Essentials ETF & Index Fund Tracker spreadsheet Excel notes

The Essentials ETF & Index Fund Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials ETF & Index Fund Tracker spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials ETF & Index Fund Tracker spreadsheet Excel file

Nothing in the Essentials ETF & Index Fund Tracker Excel template is version-specific, so this Essentials ETF & Index Fund Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Spreadsheet template highlights

What the Essentials ETF & Index Fund Tracker spreadsheet template tracks

You enter the holding and what it cost. The Essentials ETF & Index Fund Tracker Spreadsheet Template derives the rest:

Fund Name
the holding the row covers
Ticker
its symbol
Shares
how many units you hold
Cost Basis
what you put into it in total
Current Value
what the holding is worth now, entered rather than fetched
% of Portfolio auto
derived, the holding's share of the total value
Expense Ratio
the annual charge the fund carries
Gain / Loss %
what each position is worth against what you paid

Compare builds

FinancialAha ETF & Index Fund Tracker spreadsheet template: Free and Essentials compared

Feature Free View Spreadsheet Template Essentials This page
Working sheets 1 2
Funds 14 15
Market value From shares and price Entered directly
Cost basis – Yes
Gain or loss – Yes, with overall return
Share of portfolio – Per fund
Expense ratio Recorded per fund Recorded, plus a weighted average
Return since cost basis – Per fund
Charts – 1

The FinancialAha Essentials ETF & Index Fund Tracker Spreadsheet Template covers two working sheets and fifteen funds, and it measures rather than values. Against the Free ETF & Index Fund Tracker Spreadsheet Template, which multiplies shares by price and stops at a total, this build carries the cost basis alongside the current value - so a gain, an overall return, and each holding's share of the portfolio all become available. It also weights the expense ratios by holding size rather than averaging them flat, and charts the allocation. Both builds take their values from you rather than from a price feed.

Compare the other builds: Free ETF & Index Fund Tracker spreadsheet template .

Good to know

Notes on working in the Essentials ETF & Index Fund Tracker spreadsheet template

  • Cost basis is what makes the difference here - without it there is no gain and no return, which is exactly why the Free build reports neither.
  • The weighted average charge is the meaningful one: a flat average would treat a small holding's fee as equal to a large one's.
  • Current value is entered rather than derived from a price, so the sheet does not need a price per unit at all.
  • Allocation follows from the values you enter, which means it is only as accurate as your last update.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials ETF & Index Fund Tracker spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials ETF & Index Fund Tracker Spreadsheet Template

1

Add your funds

Enter each holding's name and ticker along with the number of units you hold.

2

Enter cost and value

Add what you put into the fund in total and what it is worth now.

3

Record the details

Add the annual charge for each fund.

4

Read the dashboard

Total value, gain, return, how many funds are ahead, and the weighted average charge, with an allocation chart.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials ETF & Index Fund Tracker Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials ETF & Index Fund Tracker Google Sheets template needs no conversion step and the chart survives the trip intact.

Is the FinancialAha Essentials ETF & Index Fund Tracker Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials ETF & Index Fund Tracker Excel template opens directly in Excel with no import step. The chart is a native Excel chart, and there are no macros or VBA.

Will the FinancialAha Essentials ETF & Index Fund Tracker spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials ETF & Index Fund Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Why is the average expense ratio in the Essentials ETF & Index Fund Tracker spreadsheet weighted?

Because a flat average would treat the charge on a small holding as equal to the charge on a large one. Weighting by holding size gives the figure that actually reflects what the portfolio pays.

Does the Essentials ETF & Index Fund Tracker spreadsheet pull prices or values automatically?

No. Both the cost basis and the current value are entered, so nothing depends on a price feed - and every derived figure is only as current as your last update.

How does the Essentials ETF & Index Fund Tracker spreadsheet work out each fund's share of the portfolio?

From the current values you enter - each holding measured against the total. It updates as you revise the values.

How many funds can the Essentials ETF & Index Fund Tracker spreadsheet track?

Fifteen, each with its cost, value and charge.

What does the Essentials ETF & Index Fund Tracker spreadsheet add over the free build?

The cost basis, and everything that depends on it: the gain, the overall return, and the allocation percentages. The free build multiplies shares by price and stops at a total.

How do I open the Essentials ETF & Index Fund Tracker spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Investing & Trading Templates

Investment Portfolio Tracker

A name beside every ticker and a percentage return on each position, so holdings of very different sizes can be compared. The Essentials Investment Portfolio Tracker spreadsheet template carries 20 holdings, works out market value and gain per position, and puts total portfolio value and total gain on a dashboard with a chart of how the value splits between holdings. Google Sheets and Excel, one file. No macros, no VBA.

$19

Stock Trading Journal

Each of the thirty rows is one side of a trade, so buys and sells are logged apart and the cash flow takes its direction from the side, its size from the quantity and price, and its fees netted in. The Essentials Stock Trading Journal spreadsheet template settles a realised figure on closing rows against what you paid for that ticker, and an open position stays visible as a buy with no sell against it. Two working sheets and a chart, Google Sheets or Excel. No macros, no VBA.

$19

Options Trading Journal

Pick the leg you traded and the money works itself out - direction, premium, contract count and fees all folded into one cash flow. The Essentials Options Trading Journal spreadsheet template handles opening and closing legs in both directions so the sign follows the action, nets fees into the result rather than reporting them separately, holds thirty trades on a single log, and shows the net total, the win rate and the number logged on a dashboard. Google Sheets and Excel. No macros, no VBA.

$19

Crypto Portfolio Tracker

Percentage return sits beside value and gain on every one of twenty holdings, so a small position that doubled is tellable from a large one that drifted. The Essentials Crypto Portfolio Tracker spreadsheet template takes coin, symbol, quantity, average cost and current price per row, with a Dashboard carrying total value, total gain, overall return, total cost basis and how many holdings are ahead. Two working sheets and an allocation chart. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Investing Ultimate Pack 8 templates included • Save $123

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →