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

 

How to Transfer Cash to an RRSP at ING Direct from another RRSP Using a T2033 Form

Many years ago when RRSP season rolled around we didn’t have much cash available to make a contribution. We did, however, have compound interest Canada Savings Bonds with good long term rates. At that time the government offered a program called the Canada Retirement Savings Plan. This plan allowed you to hold Canada Savings Bonds directly in a RRSP account. There were no fees to transfer bonds into or out of the plan. (An actual withdrawal of the bonds or their equivalent value was taxable.) So we phoned the 1-800 number before the February RRSP contribution deadline and then mailed our bond certificates in to Ottawa. There the bonds sat continuing to churn out annual interest which was in turn reinvested and earned more interest. Until eventually, the bonds matured. Alas, the recent federal governments have regrettably been trying to shut down the Canada Savings Bond programs. So the days of decent interest rates are, at least temporarily, over. It is time for us to move our investments as they mature out of the Canada Retirement Savings Plan and into other places. This is how we transferred the cash from a Canada Retirement Savings Plan to our ING Direct, now Tangerine.ca, RSP Investment Savings Account.

This same procedure works for a transfer from any bank or financial institution to ING Direct Tangerine.

UPDATE: Please be aware that as of January 2015, Tangerine has started charging a fee if you transfer your RRSP or TFSA from Tangerine to another bank, credit union, brokerage or financial institution.

I would no longer transfer RRSP or TFSA money to Tangerine unless I planned to keep it there for the long term.

To Transfer Cash to a Tangerine RRSP from another RRSP

To Log In to Tangerine

  1. Go to tangerine.ca
  2. Click on the I’m a Client, let me in link.
  3. In the Log me in text field, type your Client Number, Card Number or Username.
  4. Click on the Go button.
  5. In the Answer field, type the answer to Your Secret Question.
  6. Click on the Next button.
  7. Verify Your Picture and Your Phrase are correct. Then In the Personal Identification Number field, type Your PIN.
  8. Click on the Go button.

***BONUS***
Unlike most financial institutions, ING Direct Tangerine will begin paying you interest on the cash you transfer to your ING Direct Tangerine RRSP starting on the date that the RSP Direct Transfer transaction request is completed. To receive the interest, the funds must be transferred by the other financial institution within 60 days after the request is submitted.

***BONUS***
At the time this was written in June 2013, ING Direct Tangerine does not charge any fee to transfer RRSP money out to another bank or financial institution. [It still doesn’t in March, 2014.] So for now we’re moving our money from the Canada RSP into ING Direct Tangerine. Then it may move again to CIBC Investor’s Edge or BMO InvestorLine or RBC Direct Investing. So many choices!

***BOO-HOO***
Unfortunately, at the time this was written ING Direct Tangerine will not generally pay any fees you may be charged by the other bank or financial institution for transferring money out of their RRSP plan. So, for example, if CIBC charges you $100 to transfer out your RRSP, ING Direct Tangerine will NOT reimburse you this amount.

To Get and Complete the T2033 Form from Tangerine

  1. From the links listed on the left side of the screen, click on Transfer RSPs.
  2. Read the instructions. You will complete the form online, print it out, sign it and mail or fax it to Tangerine.
  3. Click on the Next button.

For the Amount section

  1. Click to select either
    • Transfer all my funds, or
    • Transfer a partial amount
    1. If you select to transfer all your funds, in the Approximate value $ field, type about how much money should be transferred.
    2. If you select a partial amount, in the $ field, type the amount
  2. Read the warning that your other institution will probably charge you a fee to make the transfer. These fees are often $100 or more.
  3. From the drop-down list, select which Financial Institution from which you are requesting the transfer.
    • If it’s not listed, select Other.
    • For Other, also type the Name of the Financial Institution in the field with that name.
      For the Canada Retirement Savings Plan, I typed: Trustee CSB Registered Products
  4. In the Account Number field, type the account number for your RRSP at the sending financial institution.
  5. In the Name of Plan field, type the descriptive name for the RRSP plan your money is currently in.
    For example, I might type

    • RRSP Daily Interest Savings for my CIBC RRSP account; or
    • Canada Retirement Savings S045 for my Canada Savings Bonds retirement bond series.
  6. As directed, type in the postal code for the sending bank and click on the Get Address button.
  7. If it can the Tangerine computer will put an address in the Street #, Street Name, City and Province boxes.
    If fields are left blank or are incorrect, type and select the information to provide the mailing address for the financial institution that will be sending the RRSP money to Tangerine.
  8. From the drop-down list answer Yes or No for whether you a trying to transfer a GIC.
  9. Click on the Next button.

In the Investment Section

  1. Choose where you want the RSP cash to be invested once it arrives at ING Direct Tangerine. You can choose
    • an existing RSP ISA
    • a new RSP ISA
    • a new short-term RSP GIC
    • a new RSP GIC
  2. If you select your existing RSP ISA it will ask you to select the appropriate account from the drop-down list.
  3. If you select a new short-term RSP GIC it will ask you to select the Term and the Renewal Options.
  4. If you select a new RSP GIC, it will ask you to select the Term, Renewal Options and whether to Compound the Interest each year it is earned, or whether to deposit the interest annually into another RSP investment.
  5. Click on the Next button.

If you are not transferring to an existing RSP ISA, a Legal Section will open.
In the Legal Section

  1. Read the anti-money-laundering information.
  2. From the drop-down list select whether any third party or other person will benefit from this account. (The usual answer is No.)
  3. Read the legal terms about applying for an ING product. From the drop-down list select whether you accept the terms.
  4. Click on the Next button.

In the Summary Section

  1. Review all the information for your request to transfer RSP money from one financial institution to ING Direct Tangerine.
  2. If the information is correct, click on the Submit button.
  3. Print off the T2033 form.
  4. Click on the Log me out tab.
  5. For increased security, close your browser session.
  6. Sign and date the form.
  7. Mail the form to ING Direct Tangerine or fax it.
    As of June, 2013, the address for ING Direct Tangerine is:
    ING Direct Tangerine
    111 Gordon Baker Road
    Toronto, Ontario
    M2H 3R1
    As of June, 2014, the address for Tangerine is:
    Tangerine
    3389 Steeles Avenue East
    Toronto, Ontario
    M2H 3S8
    Also mail or fax a copy of your most recent RRSP statement from the sending bank or financial institution. (This helps the two companies be sure they are talking about the same RRSP investments.)
  8. WAIT.

It can often take 2-6 weeks for the transfer to be made.

Related Reading

Join In
Did you join the Canada Savings Bonds Retirement Plan? Are you sorry to see CSBs on the endangered investments list? Please share your opinions with a comment.