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
- Sign in to your account/s.
- Go to https://www.bmoinvestorline.com/
- 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.
- In the Password field, type your password.
- Click on the Go button.
- From the drop-down list at the top right of the screen, select which account for which you want to save the history.
- From the My Portfolio tab, select Transaction History.
- To save your complete history
- From the From: drop-down list select the oldest date.
- Confirm the To: drop-down list has the most recent date selected.
- Click on the Refresh Transactions button.
- 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.
- 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.
- Click to select the radio button beside your preferred choice.
- Then click the OK button.
- 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.
- After checking the data is what you expect, you can save it.
- While holding down the Ctrl key, press S.
- You will be warned that you need to give the file a new name to save it.
To dismiss the warning, click OK.
- 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.
- If you are finished with your InvestorLine account, click on the Sign Out link.
- For extra security, close your Browser session.
- How to Lookup What You Did, When and for How Much in a BMO InvestorLine Account
- What is in the Transaction History for a BMO InvestorLine Account and What Should I Watch Out for?
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.