Skip to content
The title slide and first slides of the CPP and OAS Income Planner template

CPP and OAS Income Planner

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Style
Minimal
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

Canadian retirees often stack several payments that begin at different ages: CPP and OAS at 65, a workplace pension earlier, RRIF withdrawals later. The Sources tab takes the monthly amount, the age it starts and the age it stops for each one. The Timeline tab then adds the sources that are active at every age from 60 to 80 and shows the yearly and monthly total.

The Total tab picks out income at 65 and 70, the monthly figure at 70, the government share and a stacked chart by source at seven ages. The sample shows part-time work ending at 66 and RRIF withdrawals starting at 71. Use the amounts from your own statements; benefit amounts change with the age you start and each year with indexing.

Useful for

  • See how much monthly income you would have at 65 versus 70
  • Plan when RRIF withdrawals and part-time income overlap
  • Compare the share that comes from CPP and OAS

What's included

  • 4 tabs: Sources, Timeline, Total, How to use
  • Sources: a table
  • Timeline: a table
  • Total: a dashboard with 5 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Sources tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I plan my retirement income in Canada?

List each source with its monthly amount and the age it starts, then add them by age. Government benefit amounts depend on your contributions and when you start, so use your own statements.

Where do I find my CPP amount?

Your My Service Canada Account shows your contribution record and an estimate. Type the amount for the age you plan to start into the Sources tab.

Does this planner calculate tax or clawbacks?

No. It adds the amounts you enter. Income tax and the OAS recovery tax depend on your total income, so check with the CRA or a tax professional.

  • #investment-tracker
  • #cpp-and-oas-income-planner
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…