If you're using a capital gains tax calculator spreadsheet in Australia, the core logic today is straightforward: for eligible individuals and trusts, assets held for more than 12 months can usually access the 50% CGT discount, and the discounted gain is then added to taxable income and taxed at the person's marginal rate of 16% to 45% for 2025–26. For founders, that matters most when shares, options, IP, or secondary sale proceeds finally turn into a real tax event.

You might be dealing with a founder secondary, vested employee equity, a sale of software IP, or a messy cap table clean-up before diligence. That's usually the point where generic calculators stop being useful. A founder needs a practical worksheet that handles dates properly, captures a real cost base, and fits with broader startup finance discipline.

This guide is built for that situation. It gives you a downloadable Australian capital gains tax calculator spreadsheet mindset for founder scenarios, shows how to enter the right fields, explains the CGT rules that affect startup operators, and connects those records with the same evidence discipline you already need for the R&D Tax Incentive on business.gov.au.

Table of Contents

• Your Guide to Startup Capital Gains Tax in Australia
  • Why founders need a purpose-built worksheet
• How Do I Set Up the CGT Calculator Spreadsheet
  • Build the sheet around documents you can prove
  • Keep one event on one row
  • Use calculation columns in tax order
  • Add a separate tab for assumptions and record sources
  • Include startup-specific checks
• What Are Some Worked Examples for Tech Founders
  • Public shares sale
  • Asset disposal
  • Founder equity or vested ESOP shares
• What Key Australian CGT Rules Should I Know
  • The rule founders misapply most often
  • Losses come before any discount
  • Dates matter more than founders expect
  • Personal and company decisions often collide
• How Does CGT Planning Integrate with Your Startup's Finances
  • The finance function often determines how easy CGT work becomes
  • R&D discipline helps support CGT records
  • What to integrate into the spreadsheet and finance file
  • Practical controls that reduce rework
• Frequently Asked Questions on CGT for Startups
  • How should I treat carried-forward capital losses from an earlier venture?
  • Do startup shares held in a trust get the same discount treatment as shares held personally?
  • Are there different CGT record issues for cryptocurrency held by a founder or company?
  • What should I do if I expect to sell an asset after the 2027 CGT reform?

Your Guide to Startup Capital Gains Tax in Australia

A founder usually doesn't think about CGT until a term sheet, secondary window, acquisition discussion, or exercise event lands on the desk. Then it becomes urgent. The tax outcome may hinge on the contract date, whether the asset was held long enough, and whether your records support the cost base you're claiming.

A useful capital gains tax calculator spreadsheet isn't just a calculator. It's a working paper. It should let you track purchase date, sale date, proceeds, losses, and the costs you're legally entitled to include, so your eventual tax return reflects the actual transaction rather than a rough estimate.

That matters more in startups than in vanilla investing because founders often have mixed assets and mixed roles. You may hold listed shares personally, startup shares through a trust, and company-side assets such as a domain name or software IP. The tax treatment can differ, and one sloppy worksheet can blur everything.

Why founders need a purpose-built worksheet

A generic online calculator is fine for a simple listed share sale. It's weaker when you need to separate personal holdings from company assets, preserve records for diligence, and reconcile tax thinking with the rest of your finance stack.

Three things make the founder version different:

• Equity events are often staged: vesting, exercises, restructures, and secondaries create multiple dates and document trails.
• The cost base is easy to understate: legal fees, brokerage, and other incidental costs can be missed.
• Company finance hygiene matters: the same clean ledger discipline helps when a founder later needs support from an adviser, accountant, or buyer.

If you need broader support around startup tax and advisers, it's worth bookmarking ClaimKit's guide to finding a certified accountant near you.

Founders who keep transaction evidence as they go usually have more options later. Founders who reconstruct it at exit are stuck with whatever paperwork survived.

How Do I Set Up the CGT Calculator Spreadsheet

A founder signs a secondary sale in June, settlement lands in July, and the share registry updates a week later. If the spreadsheet tracks cash movement instead of the CGT event date, the gain can end up in the wrong tax year. I see this often with founder share sales and option exercises because the legal documents, payroll records, and bank receipts rarely line up neatly.

Build the sheet around documents you can prove

Set up the spreadsheet so each row ties back to a contract note, board approval, exercise notice, cap table update, or invoice. For startup founders, that usually means more detail than a basic investor spreadsheet. ESOP exercises, founder equity transfers, SAFE or note conversions, and IP-related transactions all create separate records and separate tax consequences.

Start with these fields:

• Asset description: founder ordinary shares, employee options or ESS interests, vested RSUs, trust-held shares, domain name, software IP, crypto, or other CGT asset.
• Holder and entity type: individual, trust, company, or SMSF. This changes discount treatment and keeps personal events separate from company assets.
• Acquisition date: the date that starts the holding period test. For startup equity, confirm whether the relevant date is grant, exercise, conversion, or another documented event.
• CGT event date: usually the contract date for a sale or disposal, not the settlement date.
• Cost base: acquisition price plus incidental costs you can substantiate, such as legal fees, brokerage, adviser fees tied to the transaction, and transfer costs.
• Capital proceeds: cash received, market value of non-cash consideration, or another documented disposal amount.
• Current year capital losses
• Prior year carried-forward capital losses
• Discount eligibility flag: yes or no, based on holder type and holding period.
• Notes and evidence reference: file name, Dropbox link, deed date, or ledger code.

For founders, the notes column does real work. If shares were issued under an ESS, exercised later, then partly sold in a secondary, you want the spreadsheet to show that chain without reconstructing it from memory at year-end.

Keep one event on one row

Do not combine multiple exercises, partial disposals, or conversion events into a single line. A founder who exercised options in two tranches and sold only part of the resulting holding needs at least three rows if the dates or prices differ. The same applies to company-side assets. If the startup acquired software IP, capitalised development work, and later assigned part of that IP under a commercial deal, each step needs its own line and support file.

That discipline also helps with R&D records. In early-stage tech companies, I often use the same source pack for both tax and finance review: contractor invoices, payroll allocation working papers, legal invoices, and board approvals. Those records support R&D claims on the company side and can also help establish what was spent to acquire, protect, or transfer a CGT asset. They do not all automatically form part of the cost base, but if you have not kept them, you cannot test the position properly.

Use calculation columns in tax order

The sheet should calculate the gain in the same order you would review it for an Australian return. Keep the logic visible. Hidden formulas and nested tabs create errors.

This structure matters for startup equity because not every holder gets the same treatment. An individual founder may qualify for the CGT discount on eligible shares held long enough. A company does not. A trust may, depending on the facts. If your spreadsheet skips the holder column, it can produce the right number for the wrong taxpayer.

Add a separate tab for assumptions and record sources

I recommend three tabs beyond the transaction sheet:

1. Assumptions tab. Record any judgment calls, such as which contract date governs the CGT event, how a conversion was treated, or whether a legal fee was included in cost base.
2. Loss register. Track carried-forward capital losses by year and entity so they are not mixed with revenue losses.
3. Documents index. List where each supporting file sits. If the source is trapped in a scanned PDF bundle, 5 methods to convert PDF to Excel is a practical way to extract the raw table before cleaning it.

This is the point where DIY spreadsheets either stay useful or become expensive. If another adviser, buyer, or ATO reviewer cannot follow your assumptions in ten minutes, the file is not finished.

Include startup-specific checks

Founders usually need a few extra control columns that ordinary investors skip:

• ESS or option origin: identify whether the shares came from founder stock, an employee plan, or a conversion event.
• Board or shareholder approval date: useful where transfer restrictions affect the transaction timeline.
• Cap table reference: tie each disposal back to the share class and parcel shown in your registry or legal records.
• Related party flag: transfers between founders, family trusts, and associated entities need closer review.
• Company ledger reference: for IP, domain names, or other business assets, cross-check the accounting treatment against the tax treatment.

These checks stop common founder mistakes. I regularly see spreadsheets that pull sale proceeds from the bank statement, cost base from memory, and dates from the cap table. That is how gains get overstated, discounts get missed, and trust or company holdings get treated as if they were personal investments.

A short explainer is useful if you're handing the file to another finance lead or external accountant:

If you are deciding whether the file is still a founder tool or should move to a professional review, ClaimKit's guide to tax agent requirements in Australia is a sensible checkpoint.

What Are Some Worked Examples for Tech Founders

A founder signs a secondary sale on Friday, sees cash hit on Monday, and wants the CGT number by the end of the week. The spreadsheet can do that, but only if the inputs reflect the legal and tax record, not just the cap table and bank statement.

The founder cases that create the most errors are usually these: listed shares held outside the startup, disposal of company-owned IP or domain assets, and sales of founder equity or vested ESOP interests. The formula is usually straightforward. The hard part is proving the cost base and using the correct owner, dates, and supporting documents.

Public shares sale

A founder buys listed tech shares personally, then sells part of the parcel to fund living costs between rounds. In the spreadsheet, record the acquisition date, contract date for sale, purchase amount, brokerage on entry and exit, and the exact number of shares sold from that parcel.

For an individual or trust, a discount may be available if the shares were held for more than 12 months. A company does not get that treatment. That single holder field changes the outcome, so it should never be left implied.

The practical problem is document retrieval. Founders often remember gross sale proceeds but cannot find the original contract notes or brokerage detail from years earlier. That pushes the cost base too low and overstates the gain.

A clean spreadsheet entry for this scenario should do four things:

• record each parcel separately rather than blending all purchases into one line
• include brokerage and other incidental buying and selling costs in the cost base calculation
• tie the sale to the contract date, not the settlement date
• show clearly whether the holder is the founder personally, a trust, or a company

Asset disposal

Tech companies also trigger CGT events when they sell assets that sit outside ordinary trading stock, such as a domain name, internally developed software IP, or another identifiable capital asset. The tax result depends on what the company owned and what expenditure can be tied to that asset.

I usually tell founders to slow down here. A domain sale that looks simple in the legal documents can be messy in the tax workpaper if the purchase cost, legal drafting, transfer fees, and later enhancement costs were scattered across different ledgers or advisers.

For software and IP, record-keeping around development matters more than many teams expect. If part of the asset's history sits in technical, legal, and finance files, the spreadsheet should pull those strands together. Contemporaneous project support built for an R&D Tax Incentive application process can also help substantiate what was created, when costs were incurred, and which costs are attributable to the asset rather than to general operations.

For founder-led companies, the tax risk usually sits in incomplete support for the cost base, not in the arithmetic.

Ownership also needs to be explicit. If the company owned the IP, the event belongs in the company's tax analysis. It should not be modelled as if the founder held the asset personally.

Founder equity or vested ESOP shares

This is the scenario unique to startup finance teams. A founder sells ordinary shares in a secondary, or an early employee exercises options and later sells vested ESOP shares as part of a liquidity event. The spreadsheet has to reflect both the cap table mechanics and the tax history.

Start with the basics, in order:

1. Identify the legal holder. Individual, trust, or company.
2. Confirm the acquisition date for the relevant parcel. That may be the original subscription date, the exercise date, or another date that follows from the documents.
3. Build the cost base from evidence. Include subscription price or exercise price, plus legal or transaction costs that are properly attributable.
4. Use the CGT event date shown by the transaction documents. In many cases that is the contract date.

Cap table software is useful, but it is not a tax file. It shows ownership and movements. It rarely captures the full cost base trail, ESS paperwork, exercise payments, or adviser invoices needed to support the return.

For vested ESOP shares, reconcile the option grant, vesting record, exercise notice, payment evidence, board approvals, and sale documents before you enter a number into the spreadsheet. For founder shares sold in a secondary, retain the signed sale agreement, any side letters affecting price, and legal invoices linked to that disposal. If part of the proceeds is deferred or contingent, flag that for adviser review instead of forcing a simple one-line gain calculation.

Personal planning also comes into play here. Founders often sell equity around the same time they buy or move homes, restructure trust holdings, or realise other investments. In those cases, Wealth Collective's main residence exemption insights are a useful companion if startup wealth events overlap with home ownership decisions.

If the founder also has carried-forward capital losses, keep the spreadsheet flexible enough to test different applications of those losses across current-year gains. That matters more for founders with a mix of startup equity, public investments, and legacy assets held across different entities.

What Key Australian CGT Rules Should I Know

A founder signs a secondary sale in June, sees cash in August, and assumes the later date drives the tax year. That single error can put the gain in the wrong return, distort loss utilisation, and throw off planning for Medicare levy, HELP repayments, and other personal tax settings.

The rule founders misapply most often

For Australian founders, the 50% CGT discount changes the size of the gain. It does not set the tax rate. If the asset qualifies and has been held for more than 12 months, the discounted gain still flows into taxable income and is taxed at the individual's marginal rate.

That matters in practice. Two founders can sell the same dollar value of shares and pay different tax because one has salary, bonus, or other investment income pushing them into a higher bracket.

It also matters for employee equity. With ESS interests, the tax result depends on what you hold and when taxing points arose. Options, exercised shares, and restricted stock do not all produce the same CGT starting point. In founder spreadsheets, I often see people use the grant date or vesting date as the acquisition date for everything. That shortcut creates errors fast.

Losses come before any discount

The order of calculation is where many spreadsheets fail. Capital losses are applied before any CGT discount is applied to eligible gains. If you reverse that order, the spreadsheet can understate the taxable gain.

For founders with a mix of startup shares, crypto, listed equities, and trust distributions, this is not a small modelling detail. It changes which losses are still available, how much discount remains, and whether a planned sale should happen before or after year end.

Keep separate columns for:

• current-year capital gains
• current-year capital losses
• carried-forward capital losses
• discount-eligible gains
• gains that do not qualify for the discount

That structure makes review easier and helps you avoid blending founder share disposals with assets that follow different rules.

Dates matter more than founders expect

The CGT event date is often the contract date, not the settlement date. Secondary sales, off-market transfers, buybacks, and deferred consideration arrangements all need the legal documents checked carefully before you assign a tax year.

ESS transactions need the same discipline. For exercised options, you need the grant documents, exercise notice, payment record, and share issue evidence lined up before you decide the cost base and holding period. For founder equity issued at incorporation, the supporting trail may include subscription documents, shareholder resolutions, and records of any later recapitalisation.

R&D records can matter here too. They do not determine CGT on their own, but they often help support the broader transaction history around intangible asset development, restructures, and expenditure that founders later need to explain. Finance teams that keep clean R&D and board records usually have a much easier time proving cost base components when an exit or internal restructure happens.

Personal and company decisions often collide

Founders rarely realise gains in isolation. A share sale can land in the same year as a home purchase, a trust restructure, an ESOP exercise, or an investment into another startup. If property decisions overlap with startup wealth events, Wealth Collective's main residence exemption insights are a useful reference point.

If your company is also raising capital and assessing investor tax settings, the founder side of CGT planning often sits alongside the company side of tax structuring. In that context, a practical explainer on the ESIC tax offset for startup investors helps connect personal tax outcomes with the way the business is funded.

The main lesson is simple. Keep the spreadsheet aligned to legal documents, preserve a full cost base trail, and treat ESS, founder shares, and company-level transactions as separate fact patterns until you have confirmed they belong in the same model.

How Does CGT Planning Integrate with Your Startup's Finances

A founder sells a small parcel of shares in a secondary round, exercises options under the ESOP, and the company is preparing its R&D Tax Incentive claim in the same quarter. Those events often hit the same finance stack, the same document folders, and the same people. If the records are fragmented, the CGT spreadsheet becomes guesswork at exactly the point founders need defensible numbers.

The finance function often determines how easy CGT work becomes

For Australian tech founders, CGT planning is rarely a stand-alone personal tax exercise. The key inputs usually sit inside company records. Board approvals for share issues, option grants, exercise notices, SAFEs or convertible notes converting into equity, legal invoices from a recapitalisation, and records supporting internally developed IP can all affect how an asset history is reconstructed later.

That matters most when the cost base is not obvious from a single subscription document. Founder equity issued early, shares acquired through ESS arrangements, and interests affected by restructures often require a timeline built from several sources. A clean cap table helps, but it is not enough on its own. Finance needs the underlying evidence to show what happened, when it happened, and which entity or individual bore the cost.

R&D discipline helps support CGT records

R&D records do not determine a capital gain by themselves, but they often help prove the surrounding transaction history for software and IP-heavy startups. If a founder later sells shares, transfers interests, or participates in a restructure, contemporaneous records about product development, contractor costs, and board-approved expenditure can support parts of the wider cost-base story, especially where intangible assets and development spend form part of the commercial context.

The same pattern shows up in companies claiming the R&D Tax Incentive. To support an R&D claim, businesses need activity-level evidence, cost support, and records created at the time the work was done. Finance teams that already collect that material in an orderly way are usually better prepared when founder CGT questions arise years later.

What to integrate into the spreadsheet and finance file

The spreadsheet should not sit outside the company finance process. It should pull from it.

For founder and executive tax planning, I would usually tie the CGT model back to four record sets:

• Cap table history: issue dates, vesting terms, option exercises, transfers, cancellations, and recapitalisations
• Board and legal records: resolutions, shareholder agreements, ESS documents, SAFE or note conversion paperwork, and sale agreements
• Ledger support: invoices, payment records, legal fees, broker costs, and other amounts that may form part of the cost base or disposal costs
• R&D and IP documentation: records that explain how the business developed key assets and what expenditure was incurred around that work

This is especially useful in founder scenarios that standard share calculators handle poorly. An ESOP exercise can create one tax question at exercise and a separate CGT question on later sale. A founder secondary sale may need pre and post-round ownership records, legal completion documents, and evidence of any transaction costs paid personally rather than by the company. A restructure involving IP or holding entities can require finance and legal records to line up across several dates.

Practical controls that reduce rework

Start with the events most likely to trigger future tax analysis. Share issues, option exercises, secondaries, note conversions, and restructures deserve their own folders and a named owner in finance.

Then test the records. If the signed documents say one thing, the cap table says another, and Xero says nothing useful, fix that now rather than during due diligence or tax return season.

Specialised tooling may help on the R&D side in this situation. If your team is trying to collect evidence across GitHub, Jira, Linear, Notion, Dropbox, email, and Xero, the problem is usually consistency rather than technical capability. The trade-off is straightforward. A spreadsheet remains transparent and easy for an adviser to review, but software can reduce the manual chase for source documents and activity evidence when the company is also preparing an R&D claim.

If you are tightening the controls behind both founder tax records and company tax claims, ClaimKit's guide to refundable tax offsets is a useful next reference.

Frequently Asked Questions on CGT for Startups

How should I treat carried-forward capital losses from an earlier venture?

Keep them visible in a separate part of the spreadsheet rather than blending them into one net figure. The ATO approach aims for the lowest CGT by applying capital losses against gains that are not eligible for the discount first, and generic templates often don't model that ordering well, as discussed in Sharesight's note on loss ordering and lowest CGT.

Do startup shares held in a trust get the same discount treatment as shares held personally?

The core point is that eligible individuals and trusts may access the 50% CGT discount for assets held more than 12 months, while companies can't, as outlined earlier from the linked Australian CGT material. The practical issue for founders is less about the headline rule and more about trust records, beneficiary reporting, and making sure the legal holder in the spreadsheet matches the actual structure.

Are there different CGT record issues for cryptocurrency held by a founder or company?

Yes. The spreadsheet logic still depends on acquisition date, cost base, disposal proceeds, and entity type, but crypto creates more record friction because transaction-level fees can be overlooked. For accurate calculations, disposal costs such as gas fees should be captured where relevant, as noted in Stockspot's CGT calculator discussion. If those records are incomplete, founders often overstate gains.

What should I do if I expect to sell an asset after the 2027 CGT reform?

Don't rely on an old workbook. The scheduled reform from 1 July 2027 changes the logic from a simple 50% discount model to CPI cost base indexation with a 30% minimum tax floor for relevant gains, according to Sharesight's Australian CGT reform summary. Keep a separate version of your capital gains tax calculator spreadsheet for transactions that may fall into that later regime.

---

If your startup is already juggling founder equity events, EOFY records, and an R&D claim, ClaimKit is worth a look. It helps eligible companies prepare R&D claims with AI-drafted narratives, expert review, ATO lodgement support, and integrations across GitHub, Jira, Linear, Notion, and Xero. You can also explore founder-focused guidance on the ClaimKit blog, read the R&D eligibility guide, learn more about the team, or check the help centre.