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
- On the spreadsheet, click the tab that shows “Profit / Loss“
- Click on the Extensions menu at the top of the Google Sheets interface.
- Hover over Stock Profit in the dropdown menu.
- In the expanded menu, click on Capital Gains.
How to set the financial year
- To start a separate Financial Year input the relevant year, eg 2024 in “Filters” section, End Date
- 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
- 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
- If there is data in the copied sheet go to Extension Stock Profit Capital Gains “Clear” Tab to delete any copied data
- Click on Update Sheet Names to refresh the years in the Profit / Loss Tab
Profit / Loss Destination Sheet
In the Profit / Loss Sheet select the Destination Sheet to match the financial year that you recently created
Updating Profit / Loss
Under the Capital gains tab select Update and Auto Fill the transactions
- Click Update Profit and Loss in the Capital Gains section to auto populate the duplicated sheet set up earlier
- Profit & loss transactions will now be added to the destination sheet.
- Repeat Steps 1 & 2 until all the transactions are completed.
How to carry forward losses from previous years
- In the financial year sheet EG 2007 click on the Previous Year to select the previous year losses.