Tag Archives: transaction history

When Will I Get My Dividends in my InvestorLine and Investor’s Edge Brokerage Accounts?

Posted on by

Before I opened a self-directed brokerage account at BMO InvestorLine I owned some shares that I kept in a safe deposit box at the bank. Every quarter, about a week before it was payable, a dividend cheque would arrive from the company’s agent. On the payable date, I would deposit the cheque in my account and could spend my capitalistic largesse immediately. So I was very curious when I first bought stock in my InvestorLine and Investor’s Edge accounts to see when the dividends would appear.

BMO InvestorLine Is Not Too Swift

I was a bit disappointed to discover, and verify over many payments, that BMO InvestorLine takes one full day after receiving a dividend on my behalf to post it to my brokerage account.

For example, Cineplex, which pays a monthly dividend which is great for income seekers, paid its June dividend on July 31 this month. If I had received a paper cheque in the mail, I could have cashed it and spent the money going to a movie that night. With InvestorLine, however, the money doesn’t appear in my account ready to spend till the morning of August 1.

Frankly given this is all done electronically, I’m a bit surprised by the delay. Since the paper cheques are mailed and delivered to my home several days before the payable date, one would think the electronic file would be available ahead of time too.

Now let’s look at Investor’s Edge.

CIBC Investor’s *Edge* Isn’t a Faster Dividend Payment

CIBC may be trying to give investor’s an edge but if they are it’s not by paying them their dividends on the day they are earned. Just like BMO, CIBC is taking one full day after receiving a dividend on my behalf to show it in the transaction history and cash balance of my brokerage account.

Is There a Benefit to Brokerages In This Delay?

Having a nasty suspicious mind, I wonder whether there is any benefit to the brokerages in this delay. Where is the money during the missing one day? Still in the issuing company’s bank account? Or sitting in an undisbursed slush pile in my brokerage? I think I should send a secure email by MyLink to BMO InvestorLine and ask them.

Checking Your Transaction History for Your Dividends

I’ve mentioned before that BMO InvestorLine back dates dividend payments to when they should have been made in the Transaction History.

CIBC Investor’s Edge does the same thing in its Transaction History.

Why Does It Matter If the Dividend Shows Up a Day Late?

For ultra conservative slow poke investors like me, it doesn’t particularly matter if the dividend payment is made a day late. But I can see how it might matter to others:

  • if there is a great buy available on the day the dividend money should have been available, it must hurt to watch it slide out of reach while waiting one more day: even GIC rates flutter day by day
  • if someone is using the dividend income to pay bills, even a day’s delay might cause problems depending on how the dates line up between bills and dividend payments

Related Reading

Join In
When does your brokerage pay your dividends? Remember you can’t always tell by the Transaction History. You may have to actually check your cash balance on the day the money should have appeared. Please share your experiences with a comment.

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

Posted on by

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