Tag Archives: transaction history

How to Save your Account Transaction History for a BMO InvestorLine Account

Posted on by

Tax time has just ended and with it I have been sorting out and storing various financial records for possible future audits. One record I like to keep on file is the transaction history for my BMO InvestorLine account. It provides me with a simple reference of every time money moved into or out of my trading account. Although I have other records with the same information, I like this format. Here’s how I made a copy of the transaction history in Excel and saved it on my personal computer. (Well, actually I saved it on a removeable disk that I store somewhere much more secure than on my PC.)

How to Save the Transaction History for your BMO InvestorLine Account

  1. Sign in to your account/s.
    1. Go to https://www.bmoinvestorline.com/
    2. In the User ID or Account # field, type your account number or if you have grouped your accounts under one User ID, type your User ID.
    3. In the Password field, type your password.
    4. Click on the Go button.
  2. From the drop-down list at the top right of the screen, select which account for which you want to save the history.
  3. From the My Portfolio tab, select Transaction History.
  4. To save your complete history
    1. From the From: drop-down list select the oldest date.
    2. Confirm the To: drop-down list has the most recent date selected.
    3. Click on the Refresh Transactions button.
  5. Near the top of the screen look for the blue Save link after the sentence:
    The information provided may be downloaded as a spreadsheet (.CSV format). Save
    The phrase .csv means comma separated values. This is a format that can be imported easily into most spreadsheets and even word processing programs.
    Click on the Save link.
  6. You will be prompted to either
    • Open the file with a spreadsheet program like Microsoft Office Excel; or
    • Save File

    Personally, I prefer to open the file first.

    1. Click to select the radio button beside your preferred choice.
    2. Then click the OK button.
  7. If you chose to open the file, your spreadsheet program will open a window with the data displayed.
    You may see a lot of ########## fields. That just means your column is too narrow to display the information.
    You can click on the narrow vertical line between two columns and pull the column to the right to widen it.
    You should then see proper values in the cells of that column.
    Repeat as desired.
  8. After checking the data is what you expect, you can save it.
    1. While holding down the Ctrl key, press S.
    2. You will be warned that you need to give the file a new name to save it.
      To dismiss the warning, click OK.
    3. In the Save As window
    • In the File Name: field, type a new name for the transaction history file.
    • In the Save as type: field, select the type of file to save it as. For example, I selected Excel Workbook.
    • Click on the Save button.
  9. If you are finished with your InvestorLine account, click on the Sign Out link.
  10. For extra security, close your Browser session.

Related Reading

Join In
Do you find the Transaction History is useful when you are reviewing your InvestorLine account? Or do the e-statements meet your needs better? Please share your experiences with a comment.

What is in the Transaction History for a BMO InvestorLine Account and What Should I Watch Out for?

Posted on by

When you buy or sell an investment with BMO InvestorLine you will usually get a statement in the mail [or by the MyLink secure email system] for the transaction. But when you receive a dividend, interest or distribution payment the only record is your e-statement and a line item in your Transaction History. I find the Transaction History screen quite useful as a simple list of everything going into and out of my account. Unfortunately, InvestorLine only keeps a 24-month version of the report available online. So periodically, I save the data to my own computer to keep my long term records simply and easily available. There are a few things you should be cautious about in the report, though.

What Does the Transaction History Report for my BMO InvestorLine Account?

Here’s a quick refresher of what info is stored in the Transaction History:

  • Transaction Date
    This is the date you issued the order, earned the distribution or payment, requested the contribution or withdrawal etc.
  • Settlement Date
    This is the date you became the owner on record for a new investment, or ceased to be the owner.
  • Activity Description
    This is a simplified description of what happened. For example: Dividend. Interest.
  • Description
    This usually is the (shortened) name of the company that is involved in the transaction. For example, K-Bro Linen or Dundee Investment Sving Acct.
  • Symbol
    This is the trading symbol for a stock or mutual fund. For example, AW.UN for the A&W Revenue Royalties Inc Fund T.
  • Quantity
    If the transaction involves a volume of shares or units etc that value is reported here.
  • Price
    If the transaction involved purchasing or selling units at a specific price that value is reported here.
  • Total Amount
    This is the total dollar value of the transaction.

Cautions about the InvestorLine Transaction History Report

While the Transaction History screen and report is very useful it does have some quirks you should be cautious about.

Reporting the Sales of Fractional Mutual Fund Units

The method of reporting the sale of units of a mutual fund can be misleading. As I detailed in How to Sell a Mutual Fund Using BMO InvestorLine, I found the report of the sale of one of my funds confusing.

I owned both whole units and a few fractional units. For clarity, I’ll say I owned 100.25 units of ABC fund. When I sold, the Transaction History reported I had sold 100 units for $1002.50. It then reported a day later that I had sold 0.25 units for $0. It looked like I wasn’t paid for the 0.25 units. In reality, I was paid $1000 for the 100 units and $2.50 for the 0.25 units. It just wasn’t reported clearly.

Neither the Transaction Date nor the Settlement Date is the Actual Activity’s Date

BMO InvestorLine back dates deposits to the date they should have been available in your cash or trading account.

That can be a bit frustrating when trying to determine exactly when you really received something. For instance, when one of my stocks split off a sub-company to shareholders it was supposed to be effective on a certain day, call it June 1. The shares of the new company did not appear in my trading account though till about June 9. When they appeared, the transaction was back dated to June 1. I understand why they did that, but it does make it a bit confusing.

Dividends are Not Really Paid on the Transaction Date

Again, the dates can be a bit misleading. A dividend payment or other distributive payment will not show up in your cash account or in your transaction history until at least the next day. When it is posted, though, it is back dated to the true distribution date. Again, while not a major issue it is a minor annoyance.

Oversimplified Activity Descriptions

The activity description may be so simplified that it’s not really accurate. For example, the transaction history may report: Interest when a payment was actually not interest.

The 2012 monthly distribution from AW.UN, for example, is listed in the Transaction History as Interest. According to the tax information for 2012 provided on A&Ws on website, the payment is actually a Non-eligible Dividend.

Please look at your more detailed statements (such as a T3) if you need to confirm what type of distribution you received.

Foreign Currency Transactions

To keep the screen simple, InvestorLine does not report everything about a transaction visibly on the screen.

I’m trying to determine whether InvestorLine reports whether a distribution or payment was originally made in a foreign currency on the Transaction History screen and what foreign currency conversion rate was used. (It shows this information on the e-statements.) If your account is in Canadian dollars only, then the transaction will be reported in CDN $ after conversion.

It’s tricky because the Canadian stocks I own which pay dividends in US dollars will directly pay the dividends in Canadian dollars if advised to do so by the brokerage. I need to own one of the many Canadian resource and mining stocks that simply pay their dividends in USD and let the brokerage handle the conversion. I don’t particularly want to buy one of these stocks just to check, though! Maybe I’ll have to. Hmmmmm. (If you are in this exact situation, please let me know what InvestorLine is reporting by adding a comment below. It would be greatly appreciated!)

Related Reading

Join In
Have you found any other odd quirks about the Transaction History? Or does it sound like information you wish your brokerage had available? Please share your experiences with a comment.