Capital gains walkthrough

A practical example how to use the capital gains calculator

  • How to setup seperate a financial year
  • How to carry forward losses from previous years
  • How to do a batch update for faster calculations
  • How to summarise the capital gains over the previous financial years

  • How to access the Capital Gains Feature

    1. On the spreadsheet, click the tab that shows “Profit / Loss“
    2. Click on the Extensions menu at the top of the Google Sheets interface.
    3. Hover over Stock Profit in the dropdown menu.
    4. In the expanded menu, click on Capital Gains.

  • How to set the financial year

    1. To start a separate Financial Year input the relevant year, eg 2024 in “Filters” section, End Date
    2. Click in the “Sell” Section to see all the relevant transactions relating to a particular selected stock

  • Creating a New Financial Year Destination Sheet and Clearing Data

    1. Create a Destination Sheet by copying the given sheet tab ‘2022’ by right clicking on the arrow and selecting “duplicate”.  Re-label the duplicate sheet tab eg 2007
    2. If there is data in the copied sheet go to Extension Stock Profit Capital Gains “Clear” Tab to delete any copied data
    3. Click on Update Sheet Names to refresh the years in the Profit / Loss Tab

  • Profit / Loss Destination Sheet

    1. In the Profit / Loss Sheet select the Destination Sheet to match the financial year that you recently created

  • Updating Profit / Loss

    1. Under the Capital gains tab select Update and Auto Fill the transactions

    2. Click Update Profit and Loss in the Capital Gains section to auto populate the duplicated sheet set up earlier
    3. Profit & loss transactions will now be added to the destination sheet.
    4. Repeat Steps 1 & 2 until all the transactions are completed.

  • How to carry forward losses from previous years

    1. In the financial year sheet EG 2007 click on the Previous Year to select the previous year losses.