How to Set Up a US Dollar Ledger or Side for a BMO InvestorLine RRSP Account

If you have an InvestorLine RRSP account you can buy US stocks paying for them in Canadian dollars and receiving any dividends, interest or distributions they pay out in Canadian dollars. You will have to pay InvestorLine a foreign exchange fee, though, each time you buy a US stock or each time you receive money in US dollars that has to be converted back to Canadian dollars. There is an alternative: you can set up a US Dollar account within your existing InvestorLine RRSP account.

Why Might You Want a US Dollar Sub-Account within your RRSP?

Every time you listen to the business news on the radio or skim a news website, you will hear or see what the current exchange rate is for the Canadian dollar versus the American dollar. That’s because the exchange rate changes constantly. As recently as 2002 the Canadian dollar was only worth about 62 cents US; in 2007, the CAD was worth $1.10 US. That’s quite a range. (This is information from the Bank of Canada website at http://www.bankofcanada.ca/rates/exchange/can-us-rate-lookup/.)

This variability means you may pay more to buy one US dollar on one day than on another. Or, conversely, you might get more Canadian dollars for each US dollar you earn in dividends in one month than in another.

If you have a US dollar sub-account you can do all of your US business using US dollars. You can keep any US cash in a US cash account ready to re-invest. If you need more US dollars, you can choose when to buy them based on a good exchange rate. Similarly, you can wait till the foreign exchange rates are favourable before moving money back into your Canadian currency account.

For example, if you hold shares in Walmart in the US dollar side of your RRSP account, you will receive the dividend payment in US dollars into your US dollar cash account. You can then use it to buy more US dollar investments without ever paying a foreign currency exchange fee.

How Do I Set Up a US Dollar Sub-Account within my InvestorLine RRSP?

At first I thought I could do this by selecting something online but I can’t.

To set up the US side of my account, I phoned BMO InvestorLine at 1 888 776 6886.

As usual, I needed to provide my InvestorLine account number and my access password.

When I spoke to an InvestorLine representative, he assured me the US side of my account could be set up quickly and easily based on my phone call.

How Soon Will I See a US Ledger or Journal for my BMO InvestorLine Account?

If I understood correctly, I will see this new part of my account tomorrow, one business day after I requested its creation. I’ll update this post then.

Related Reading

Join In
Do you use a US side or ledger for your InvestorLine account? Do you wish CIBC Investor’s Edge accounts had one? Please share your experiences with a comment.

How to Download Your Transaction History for an ING Direct Bank Account to a Spreadsheet

Many people keep track of their finances using a program like Quicken. Others, like me, who are incredibly cheap, er, frugal use a spreadsheet. Either way, it’s a bit easier and often more accurate to download the info directly from your bank than to type it in line by line. Here’s how you can download what’s been happening in your Tangerine, formerly called ING Direct, bank account.

Copying your Tangerine Bank Account Transaction History Onto Your Computer

To Login to your Tangerine account/s

  1. Go to: http://www.tangerine.ca/en/
  2. Click on I’m a Client, Let Me In!.
  3. Enter your Client Number, banking Card Number or Username in the Log me in box.
    Click on the Go button.
  4. If necessary, in the Your Secret Question: box, type the Answer: to the question.
    Click on the Next button.
  5. If the Your Picture and the Your Phrase fields are correct, if applicable, in the Your PIN box, type your personal identification number.
    Click on the Go button.

To  Download Your Transaction History

  1. Click on the View My Accounts link.
  2. Scroll down to the bottom of that screen.
    Click on the Download Transactions button.
  3. From the drop-down list select the account for which you wish to download the history.
  4. In the Download Information section, select either
    • Get all from last download (which presumably translated from the Dutch-English means “Get all the data since the last download”; or
    • Get all for the following date range:
      If you choose a period, from the drop-down lists select the start date and end date day, month and year.
  5. In the Available Download Formats section, from the drop-down list select
    • QFX Quicken
    • Microsoft Money; or
    • Excel/Other software, CSV

    Yes, just like PC Financial they support downloading to Microsoft Money even though Microsoft no longer supports Money itself.
    CSV means comma separated values. In other words, they will put a comma between each entire number. So the two numbers one hundred thousand and the number ten would be sent as: 100000,10

  6. Click the Next button
  7. Review the information on the screen called Here is the information you selected for Download
    If it looks correct, click on the Download button.
  8. In the SomeName.CSV window, select either
    • Open with; or
    1. If you select Open, you must also select a program from the drop-down list.
    • Save File
    1. Click on the OK button.
    2. If applicable, select where you want to save the file.
    3. Click on the Save button.
  9. When you are finished using Tangerine click on the Log Me Out button.
    For increased security, close your browser session.

In my case the saved file was called Chequing.CSV.

CSV means comma separated text. If you open the file in a spreadsheet it will put one line of data on one line of the spreadsheet. It will put the data after each comma into a new column.

You will likely find some columns are full of ######s when you open your file in a spreadsheet. This is because the information is too large to fit the width of the column. To correct this, hover the mouse over the small vertical line between the Letter Names at the top of the column. Click and holding the mouse key down, drag the line to widen the column.

What is Reported for my Tangerine Transaction History

Cool! The info is different than that reported by PC Financial.

The columns reported are

  • The Date
  • The type of transaction
  • Name; a description of what happened. For example Bill Payment AMEX
  • Memo; another description of what happened
  • Amount; the dollars that moved in or out of the account

The types of Transactions are

The types of Memos showing up for my account include

  • Transferred
    This is used when I transfer money between accounts.
  • BILLPO
    This just means I paid a bill, not that I am P.O.d about it, though it does make me smile to think that might be what they meant. I wonder who programmed that?
  • Cheque Order Fee
    This was 0 because I only ordered the free first cheques. I use PC Financial to get as many free cheques as I need.
  • There may be other codes that were not applicable to me.

How Accurate is the Transaction History Information?

I found the way PC Financial reported my credit card transactions resulted in the numbers being in the wrong column.

The Tangerine information, however, is all lining up properly.

How Risky Is It to Download and Store This Information on my PC?

The file does not include any of my credit card numbers, or the account numbers for businesses I paid bills for online. For example, it does not list my Cable TV account number.

The file did not include any information about my bank account number or my bank balance.

This information, therefore, is not very risky to store on my home computer. However, I would suggest storing it instead on a DVD or USB stick and that storing that somewhere safe. No sense in making it too easy for financial crooks, er, criminals.

Related Reading

Join In
Do you download your bank info from Tangerine to a money management program or a spreadsheet? Have you ever had any hiccups? Please share your experiences with a comment.

image of thin green double line