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中文
Capital Gains Calculator Ultimate ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Capital Gains Calculator Spreadsheet Template for Google Sheets & Excel

Twenty tax lots on one list, with the days held and the short or long term classification derived from the purchase and sale dates rather than typed. The Essentials Capital Gains Calculator spreadsheet template carries losses through the totals as negatives, where they belong, and keeps a short-term and a long-term rate in labelled cells you control. Three working sheets and a dashboard. Google Sheets and Excel. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Capital Gains Calculator Spreadsheet Template
$29
Essentials Capital Gains Calculator spreadsheet template - Google Sheets and Excel preview

What's Included

  • Twenty tax lots on one list
  • Days held derived from the purchase and sale dates rather than typed
  • Short or long term classification following from those dates
  • Gain or loss per lot, with losses carried through the totals as negatives
  • A short-term and a long-term tax rate as labelled cells you set
  • Dashboard totalling everything realised and splitting it by term
  • Lot count and how many finished ahead
  • A chart setting the two terms against each other
  • A currency dropdown on the Dashboard that relabels money columns across both sheets
  • Step-by-step "How to Use" guide on a tab of its own
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Twenty tax lots on one list
  • Days held derived from the purchase and sale dates rather than typed
  • Short or long term classification following from those dates
  • Gain or loss per lot, with losses carried through the totals as negatives
Ultimate - $29
  • Fifty realised lots with shares, both dates, basis and proceeds
  • A percentage return per lot, so positions of different sizes compare
  • Days held and the term derived from the dates
  • Both rates entered by you on a summary sheet rather than assumed
  • An effective rate across everything realised, reflecting the actual mix
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Capital Gains Calculator Spreadsheet Template for Google Sheets and Excel is a two-sheet workbook that handles a year of sales rather than one, with a How to Use guide on a third tab. It works as an Essentials Capital Gains Calculator Excel template and an Essentials Capital Gains Calculator Google Sheets template from the same download. Where the Free build takes one position and a holding period you type, this Essentials Capital Gains Calculator spreadsheet template holds twenty lots and works out how long each was held, and which term it falls into, from the dates themselves. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Capital Gains Calculator spreadsheet template

The FinancialAha Essentials Capital Gains Calculator 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 Capital Gains Calculator spreadsheet holds.

  1. 01 of 02

    Tax Lots

    The sheet you type into, twenty lots deep. Each row takes the asset, the date it was bought and the date it was sold, what it cost to acquire and what it brought in. From those the gain or loss follows, along with the number of days the position was held and which term that puts it in - so the classification comes from the dates rather than from you deciding. A loss simply shows as a negative gain and carries through the totals the same way.

    FinancialAha Capital Gains Calculator spreadsheet template - Tax Lots sheet

  2. 02 of 02

    Dashboard

    The year summarised: everything realised, split into the two terms, with an estimated tax figure, how many lots are recorded and how many finished ahead. A chart sets the two terms against each other. The tax figure is an estimate rather than a calculation of what you owe. It applies the two rates from the Tax Lots sheet to each term separately, and floors each at zero first - so a losing term contributes no tax rather than a negative one, and a loss on one side never offsets tax on the other. Nothing in it knows about brackets, allowances or carried-forward losses.

    FinancialAha Capital Gains Calculator Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what cost basis and proceeds should include, how the classification is arrived at, and how to read the dashboard. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Capital Gains Calculator Spreadsheet template for Google Sheets

Upload the Essentials Capital Gains Calculator Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Capital Gains Calculator Google Sheets template needs no conversion step and the chart survives the trip intact - the dates and 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 Capital Gains Calculator Google Sheets template setup

A shared copy of the Essentials Capital Gains Calculator Google Sheets template works where someone else prepares or reviews the figures, and Sheets version history covers a date or a basis typed over. Because the reporting sits on its own tab, the lot list stays a list.

Sharing the Essentials Capital Gains Calculator Google Sheet

The Essentials Capital Gains Calculator Google Sheet is a per-sale job rather than a daily one: add the lot as it closes, and the classification and the year's totals follow. Keeping it current through the year is what makes it useful at the end of one.

Also available as:

Essentials Capital Gains Calculator Spreadsheet template for Excel

The Essentials Capital Gains Calculator spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Capital Gains Calculator Excel template directly, with no import step and no compatibility prompt, and the chart is a native Excel chart that redraws as lots go in. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Capital Gains Calculator Excel template setup

The same Essentials Capital Gains Calculator 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 Capital Gains Calculator spreadsheet download to choose between.

Essentials Capital Gains Calculator spreadsheet Excel notes

The Essentials Capital Gains Calculator spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Capital Gains Calculator 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 Capital Gains Calculator spreadsheet Excel file

Nothing in the Essentials Capital Gains Calculator Excel template is version-specific, so this Essentials Capital Gains Calculator spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Capital Gains Calculator spreadsheet template tracks

You enter five things per lot and the Essentials Capital Gains Calculator Spreadsheet Template derives the rest:

Asset
the ticker, fund or holding the lot covers
Date Bought
when the position was acquired
Date Sold
when it was disposed of
Cost Basis
what it cost to acquire, fees included
Sale Proceeds
what the sale brought in, net of fees
Gain / Loss auto
derived, proceeds less basis, negative where it was a loss
Days Held auto
derived, the span between the two dates
Short / Long auto
derived, the term that span falls into

Compare builds

FinancialAha Capital Gains Calculator spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 5
Positions handled One at a time 20 lots 50 lots
Gain or loss Yes Yes, per lot Yes, with % return
Short or long term From days you enter From the dates you enter From the dates you enter
Rates Both set by you Both set by you, under the totals Both set by you, on a summary sheet
Charts – 1 2
Totals by term – Yes Yes
Effective rate – – Yes
Bracket grid – – Every rate combination
Wash sale helper – – Flags repurchases against losses

The FinancialAha Essentials Capital Gains Calculator Spreadsheet Template covers two working sheets and twenty lots. Against the Free Capital Gains Calculator Spreadsheet Template, which handles one position and takes the holding period as a number you type, this build works the days held and the term out from the dates themselves, totals the year by term, and reports it on a dashboard with a chart, with both tax rates as labelled cells beneath the totals. The Ultimate Capital Gains Calculator Spreadsheet Template holds fifty lots with a percentage return on each, puts the rates under your control on a summary sheet, adds an effective rate across the year, a grid of every rate combination, and a helper that flags losses where the same asset was bought back soon after.

Compare the other builds: Free Capital Gains Calculator spreadsheet template or the Ultimate Capital Gains Calculator spreadsheet template .

Good to know

Notes on working in the Essentials Capital Gains Calculator spreadsheet template

  • The classification comes from the two dates rather than from a judgement you make, so entering them accurately is what the row turns on.
  • Cost basis and proceeds are both meant to be the real amounts - acquisition costs in, selling costs out - rather than the quoted prices.
  • A loss carries through as a negative gain, so the totals reflect the year rather than only the winners.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Capital Gains Calculator spreadsheet. It changes the label only and does not convert the numbers.
  • The two rates sit under the totals on the Tax Lots sheet, and the dashboard estimate reads them. What the rates should be is not something the sheet decides.
  • The estimate floors each term at zero before applying its rate, so a losing term adds no tax and a loss on one side does not reduce the tax on the other. Brackets, allowances and losses carried forward are all outside it.

How to Use the Essentials Capital Gains Calculator Spreadsheet Template

1

Add a lot

Enter the asset and the dates it was bought and sold.

2

Enter the money

Add what it cost to acquire and what the sale brought in, both net of fees.

3

Let it classify

Days held and the term follow from the dates, and the gain or loss from the two amounts.

4

Read the year

The Dashboard totals everything realised, split by term, with a chart alongside.

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.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Capital Gains Calculator Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Capital Gains Calculator Google Sheets template needs no conversion step and the chart survives the trip intact.

Is the FinancialAha Essentials Capital Gains Calculator Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Capital Gains Calculator 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 Capital Gains Calculator spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Capital Gains Calculator spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Can I set my own rates in the Essentials Capital Gains Calculator spreadsheet?

Yes. Both rates sit as labelled cells under the totals on the Tax Lots sheet - one short-term, one long-term - and the dashboard's estimate reads them, so changing a rate moves the figure. What the rates should be is not something the sheet decides. The Ultimate build moves them onto a summary sheet, adds an effective rate across everything realised, and runs a grid of every rate combination.

How is short or long term decided?

From the two dates. The sheet works out how many days the position was held and classifies the lot from that, so it follows from what you entered rather than from a judgement you make.

How many lots does it hold?

Twenty in a single period. The Ultimate build holds fifty and adds a percentage return on each.

How are losses handled?

A loss shows as a negative gain and carries through the totals the same way, so the year's figure reflects everything realised rather than only the profitable lots.

What should cost basis and proceeds include?

Cost basis is what the position cost to acquire including fees; proceeds is what the sale brought in after selling costs. Using the real amounts rather than quoted prices is what makes the gain meaningful.

How do I open the Essentials Capital Gains Calculator 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 →