I’ve covered the mechanics of getting paid in retirement at what is a pretty detailed level, but maybe you’re curious about the actual, blow by blow steps of getting paid?

In a typical month, I make 6 sell trades (one for each RRIF, one for the non-registered account) and perform 2 cash movements (one withdrawal from my non-registered, and either a withdrawal from the cash cushion or an inter-account cash movement from the non-registered account to the cash cushion).

The diagram from the previous post¹ I’ll include here, since it may make things a bit clearer:

Step 1. Make sure net worth is accurate in my spreadsheet

By the time the end of the month rolls around, this is normally fine. The beginning of the month has a bunch of (of mostly, but not fully, automatically reinvested) dividend payments and reward payments (aka “free money”) so the opening few weeks of the month always require tweaks to share amounts and outstanding cash amounts.

A quick login to Passiv, which connects in real time to all my retirement accounts held at Wealthsimple and Questrade, allows me to do a sanity check of my spreadsheet values versus what’s actually in all of my accounts. In the event there are discrepancies, I fix them in the spreadsheet before proceeding.

That’s what is behind step A in the diagram.

Step 2: Decide the order of priority for liquidating various assets in my non-registered accounts

Every month, I know that I will have to liquidate shares in my non-registered account, but since I have four different holdings to choose from, I have to input which ones are the most important to liquidate first². This year, I’ve been trying to reduce dividend-paying holdings to reduce that source of income come tax-time. Another factor I consider is how far my portfolio has drifted from the asset allocation targets. Selling a fund to reduce an overweight asset class (e.g. Canadian Equity) is always a good way to take advantage of a needed asset sale.

This is an input for step G in the diagram.

Step 3: Run the Monthly Macro

The monthly macro³ does a bunch of things to help me figure out exactly what I need to do:

• It plugs my current net worth into the VPW spreadsheet which then generates the VPW suggestion; the macro then squirrels the suggestion away
• It takes a look at the current value of my cash cushion and squirrels that away;
• It takes a look at the current value of the CAD/USD FX rate and squirrels that away⁴
• It saves the current month’s numbers into a monthly ledger, which allows me to share with all of you things like my salary and net worth over time.

None of that, strictly speaking, is in the diagram, but is a necessary step for Step 4, below.

Step 4: Follow the step by step instructions that result

With the static copies of key bits of data (VPW suggestion, value of cash cushion, FX rate) these now plug into a specially crafted spreadsheet that provides instructions in English, step by step.

• It tells me how many shares to sell in each of my accounts⁵
  • How many XGRO⁶ to sell based on the current share price and current cash position in each of the 5 RRIF accounts (steps E and F in the diagram; the RRIF payment amount is fixed at the beginning of the calendar year)
  • How many and which shares I need to sell in my non-registered account based on VPW’s suggestion (step G)
• It tells me if I have to move money to my chequing account from my cash cushion or if I have to move money from my non-registered account to my cash cushion. (That’s step D or D’ in the diagram above).
• The RRIF payments (steps E’ and F’ in the diagram) are automatic; nothing for me to do there
• Step G’ requires a visit to Questrade’s “Move Money: Withdraw” menu in order to get money into my chequing account

In summary, I have to execute as many as 6 “sell” trades — one for each of the RRIFs⁷, and one (possibly more⁸) in the non-registered account. And then there are two “move money” transactions I have to make — one from my non-registered to my chequing account, and one representing step D/D’ (one of the two is always in play).

Step 5: Update my records

This I usually do right away since I have all the necessary data in front of me. That means

• updating my holdings spreadsheet to reflect the reduction in XGRO in my RRIFs and the reduction of whatever holdings I liquidated in my non-registered account
• Add the transaction in my non-registered account to adjustedcostbase.ca so I know what my capital gain/loss was.

Step 6: Wait for the Money

The non-registered cash is usually the first to arrive in my bank account, a day or two later.

Wealthsimple is next, and Questrade’s payments inexplicably arrive on different days depending on what I don’t know. Although all 4 Questrade RRIFs are set up with the same payment schedule, the 4 RRIF payments never arrive on the same date.

1. Ok, I lied, it’s not exactly the same. I decided I didn’t like the D/D’ arrows in the original post since it wasn’t 100% accurate. ↩︎
2. And usually, the first one listed is the only one sold. My spreadsheet can handle the scenario where there’s not enough shares held to meet the amount I’m requesting. ↩︎
3. The macro mostly just makes static copies of these values (aka “squirrels away”) and puts them in known places so I can perform other calculations on them. Since my retirement spreadsheet uses live market data — delayed by 20 minutes, that’s what you get for relying on googlefinance(), the value of things is constantly changing. If I didn’t make static copies, it would make it hard to perform consistent calculations. ↩︎
4. The value of my cash cushion is dependent on the USD/CAD rate since the majority of my holdings there are in USD since the interest rates are better. ↩︎
5. It doesn’t actually need to do this for my Wealthsimple RRIF since I’m permitted to sell a dollar amount of assets instead of a number of shares with Wealthsimple’s trading tool. Handy, that. But I haven’t yet made the change to the macro. ↩︎
6. It’s always XGRO I sell since that’s the majority CAD holding in each of the 5 RRIF accounts ↩︎
7. My spousal RRIF and my spouse’s individual RRIF are both rather modest in size and their monthly payments are sometimes covered by cash on hand. And I have cash on hand there because Questrade doesn’t offer fractional trading for CAD listed ETFs. . ↩︎
8. My spreadsheet is fancy enough that I can sell up to 3 different non-registered assets, but only in the scenario where I reduce the holding of a given asset to 0. ↩︎