Tag: ACB

man juggling on a tightrope against cloudy sky

What do you have to actually DO to get paid?

RobHLeave a comment

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 post1 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 first2. 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 macro3 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 away4
  • 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 accounts5
    • How many XGRO6 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 RRIFs7, and one (possibly more8) 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. ↩︎
dollar cut in half

Another quarter, another gambit

RobHLeave a comment

Every quarter, I convert some of my USD to CAD using Norbert’s Gambit. A good chunk of my retirement holdings are in USD, but since I spend in CAD, I need a cheap way to convert. I’ve been tracking my actual costs using Questrade’s platform for the past year. You can read about that over here.

Anyway, over the past year, the conversion has been effective. I have never paid the usual FX rates charged by Questrade (1.5% over the spot rate). My most recent conversion was the most expensive one to date, and that was a rate 0.7% over the going rate on the day I started the process. On three other occasions, I actually made out better than the spot rate, but that was because the foreign exchange rate moved in my favour in between the purchase and the sale.

My need for US cash has evaporated now that I have a no-FX fee credit card. (You can read about what cards I’m using over here.) So this makes me wonder if it’s time to get rid of the majority of my US holdings. Note this doesn’t mean that I will stop investing in US equities — that would be unwise — it just means I will stop holding assets denominated in US dollars.

The are downsides to holding USD-denominated assets, of course:

  • It adds complexity to the portfolio. AOA is the US equivalent of XGRO; both are 80/20 asset allocation ETFs. But because AOA is a US ETF, it holds a paltry amount of Canadian Equity, and I have to make up that difference elsewhere by holding pure Canadian Equity ETFs like HXT or XIC.
  • If you hold too much USD (or any foreign property) in non-registered accounts, you’ll be obliged to file a T1135 with CRA1.
  • It may limit the universe of online brokers you can deal with. Wealthsimple, for example, does not currently support USD RRIF accounts.
  • Foreign exchange can work for or against you. It’s another variable that can impact your returns. I’m not convinced this is a downside, but it does make tracking things like ACB in a non-registered account a little more tedious.

    One big hesitation I have about converting all my USD holdings would be the time I’d have to be out of the market while the Gambit runs its course. As you can see in from my tracking, each conversion means I’m not invested in AOA for 3-4 trading days. I just hate that idea. I also hate the idea of converting at a time when the CAD<->USD exchange rate is perhaps not optimal. (A low Canadian dollar would be a good thing for me in this case.)

    One place I sort of like having the USD assets is in my cash cushion, especially since US interest rates are quite a bit higher than Canadian rates. (I track current rates over at HISA and short-term bond table (Canada & US)).

    So perhaps I just need to craft a plan where I make more aggressive conversions over a fixed time frame. x% every month, with a deadline. This helps mitigate the “time out of market” and “exchange rate” issues. Crafting the plan with fixed milestones also takes emotion out of the equation; if I set a series of future transactions, then all I have to do is press the button mechanically.

    More to come on that.

    1. If your cost base exceeds $100,000 CAD ↩︎

    MyACB: A new ACB Tool

    RobHLeave a comment

    ACB stands for “Adjusted Cost Base”, and is something you need to care about if you have non-registered stocks/ETFs that you buy and sell. If you don’t track your ACB, you can’t calculate the capital gains and losses for a given asset sale.

    “But that’s what the T5008 is for, isn’t it?”

    Theoretically, yes, but online brokers are notoriously sloppy with tracking ACB and hence your T5008 may not track capital gains properly. Some common reasons why this is are:

    • You hold the same asset at multiple brokers (or even within multiple accounts at the same broker). The CRA doesn’t care where you own the asset, they only care that you own the asset. No matter how many ways and in how many accounts the asset is sliced, CRA considers there to be only one ACB for all of them.
    • You move the asset from one broker to another and the ACB gets set incorrectly by the receiving broker
    • Your asset is priced in USD and your broker is using a different FX rate from you1
    • Your asset delivers a return of captial (RoC for short) which lowers your ACB (and increases future capital gains); your broker may or may not track this on your behalf
    • Your asset reinvests dividends into the fund (this sounds the same as a DRIP, but it isn’t — it’s commonly known as a “phantom distribution”). This increases your ACB.
    • Your asset undergoes a share split or share merge.

    For these reasons, I don’t trust T5008s, and I track my own ACB. In Tools I Use I mention the ACB tool I use; it’s the one I have been using for many years now, namely Adjusted Cost Base. (Before that I think I used an Excel template…which I converted to ClarisWorks format, but I digress…)

    I use the free version of Adjusted Cost Base because it suits my needs, and I wasn’t aware of a reasonable alternative, and I’m a cheapskate. But it seems there is one now — MyACB. I gave MyACB a quick spin this week, here’s how it compares to Adjusted Cost Base, both in “Free” mode:

    User InterfacePortfolios Automated FX Automated RoC and phantom distributions Import from other sourcesPay models
    Adjusted Cost Base Not pretty; subscription eliminates ads– two; 5 with subscriptionNoNo, requires subscriptionNo, requires subscription$49/year
    MyACB Pretty– one; 5 with family subscription,
    100 with “pro” subscription     		YesFor one asset only; more assets require subscriptionYes$29/year for family

    $99/year for pro2

    User Interface

    Adjusted Cost Base won’t win any graphic design awards3. The design is functional but not at all modern looking. MyACB looks like a modern website. Dark mode? Check. Logical layout? Check. And at present, MyACB is ad-free4.

    One big thing MyACB does better than Adjusted Cost Base is its support for editing portfolios, specifically related to deleting symbols. It’s far too easy to accidently trash an in-use symbol in Adjusted Cost Base. MyACB makes it very clear how destructive your desired action will be and asks for a specific and impossible-to-click-too-fast confirmation!

    Portfolios

    Tracking ACB for me means tracking it in my account, my spouse’s account, and our joint account. So that’s three portfolios. And I try to hold different assets in different portfolios to avoid raising the CRA’s ire.

    Anyway, my three portfolios exceed the “free” capacity of both products; I get around the restriction by having my spouse have her own Adjusted Cost Base account to track her portfolio. Not a big deal, just a minor inconvenience. With MyACB it would be a bit trickier.

    Once nice thing that MyACB does here is support for a “Group” of portfolios. This allows for a user to have multiple portfolios at multiple brokers to keep an eye on superficial losses. I wasn’t able to test this function, since MyACB is limited to one portfolio in the free version. But I can see it as being useful. (In my case, as an Adjusted Cost Base user, I just merge all my transactions across multiple accounts into one portfolio and achieve the same result. The MyACB model is cleaner and more useful).

    Automated FX

    Since I trade in both USD and CAD, I need to know what the CAD<->USD exchange rate is on day of settlement5. If you only hold CAD-denominated assets, then this won’t matter to you.

    Here the free version of MyACB wins hands down. MyACB will do FX calculations for you by looking up the FX rate on the day of settlement. This is a something Adjusted Cost Base makes you enter manually.

    Automated RoC and phantom distributions

    ETFs have a habit of using these means of distributing money to their unit holders. I’m no tax accountant, but you can read all about these weird distributions over on both of the websites

    Both tools offer support for these, no issue there. I’ve been tracking these distributions in Adjusted Cost Base for years.

    MyACB adds a small teaser in the free version that allows you to automatically add these transactions for any ONE asset in your portfolio6. So if your non-registered account has one asset, this might be construed as useful. For me, and my 10 different non-registered assets, it’s merely an effort to entice me to pony up and pay for the family version of MyACB. Anyway, I tried it out and it performs as advertised, and is an exceedingly useful feature, but in the free version, it’s really just a way to kick the tires for most of us.

    But compared to the free version of Adjusted Cost Base, one thing missing is support for multiple portfolios. Adjusted Cost Base’s free version supports two portfolios. I actually need three portfolios: one for my account, one for my spouse’s account, and one for our joint account. To get around that restriction, my spouse tracks her portfolio in her own Adjusted Cost Base account.

    .

    Import from other sources

    Adjusted cost base doesn’t offer this in their free version, but it’s in the subscription version.

    MyACB allows this in the free version, not too surprising, since it’s the new kid in town. The feature seems well thought out, and includes contributions from others (“schemas”) to save you time in figuring out how to map fields to MyACB.

    I did try to do an export from Adjusted Cost Base to MyACB and ran into a few problems:

    • The way splits are modelled in the two platforms is different. MyACB puts the split ratio in a dedicated field, whereas Adjusted Cost Base puts in two places — once in the Transaction field and once in the Shares field. A bit of Google Sheets post-processing can fix this, but this may be a problem for a user less familiar with string manipulations.
    • In MyACB, the ticker symbol is mandatory, whereas in Adjusted Cost Base it isn’t.
    • Adjusted Cost Base doesn’t call out the currency used, just the exchange rate, and a “yes/no” if it’s a foreign currency transaction. MyACB stores the currency “kind” (e.g. USD, EUR etc). Again, a minor difference, but one that requires some thought as to how to covert one to the other.

    Am I switching?

    For the moment, no. Adjusted Cost Base meets my needs, and it would require some work for me to move to MyACB. To get the most out of the switch, I would have to pony up for a family plan given the portfolio limitations in MyACB’s free version. If you’re just starting out in getting help with your ACB tracking, either tool will meet your needs. MyACB has some nice features in the free version (automatic FX lookups, transaction importing) that warrant giving it a close look.

    What do you think? Let me know at comments@moneyengineer.ca!

    1. There’s more than one acceptable way to do this. What I do is find the Bank of Canada rate on the settlement date and use that. ↩︎
    2. “Tax pros” is an assumption on my part. I don’t see how even the most dedicated DIYer has a need for 100 portfolios… ↩︎
    3. I see that the top hat guy for Adjusted Cost Base’s logo has had a makeover; he looks a little less scary and seems to have given up cigars. ↩︎
    4. I do respect the need for content creators and developers to be compensated somehow for the work they do. The ads on Adjusted Cost Base are quite prominent and can be quite distracting. ↩︎
    5. You track your ACB in Canadian dollars, always. And you convert each transaction — buy or sell — to CAD. ↩︎
    6. The UI to do this is a bit (uncharacteristically) clunky, in my view — you can only import one year of transactions at a time, which gets tedious pretty quickly. ↩︎