Heads up: This particular template only applies to individuals residing in Canada 🇨🇦.

Duplicate the template here

RRSP and TFSA Room Tracker

Each type of registered account has two databases: Transactions and yearly limits. They are connected in a way that all deposits and withdrawals are recorded in the transactions database, which are then used by the yearly limits to calculate the current available room for contributions.

Notion doesn't handle recursive formulas very well That is, formulas that depend on formulas that depend on ... etc. You get the idea. For that reason, unfortunately, there is a bit of manual work to be done here.

You'll notice both and have two similar properties:

The available room for the previous year can be brought over via Rollups, and the value will be correct. However, when trying to use that value as a number, things get wacky. For that reason, and hopefully temporarily, its important you manually enter the value you see in the Rollup version of the property into the regular Number version. By having them side-by-side you can make sure they match.

Luckily, this would only need to be done once: At the beginning of the year.

The Math

TFSA

$R = L_c + r_p + w_p -d_c$

RRSP

$R = r_p + r_c + a_c - d_c$

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/f4adf06d-33b7-4484-bcf7-eb9ccf530f80/Screen_Shot_2020-08-14_at_3.20.49_PM.png