Tag Archives: taxes

How to Download Your Transaction History from a BMO Online Bank Account

Posted on by

If you like to keep an eye on your budget or if you just want a simple electronic record of your banking transactions for future reference, you may want to download your information and save it on a disk or stick. You’ll notice I don’t recommend you keep the data on your hard drive or handheld and I’ll mention why in this article. Here’s how you can download what’s been going in and out of your BMO online bank account.

Downloading Your BMO Bank Account Data to Use in a Spreadsheet or Financial Program

You can download your data directly in the format needed for

  • Quickbooks
  • Quicken, or
  • Simply Accounting

You can also download it in comma separated values format to use in most spreadsheets including Excel.

  1. Sign in to your BMO online banking account.
  2. Under the My Accounts section on the list of links on the left side of the screen, click on the bank account for which you wish to download the transactions.
  3. Under the name of the account, click on the link: Download Account Details

The Download Your Bank Account Details Page

  1. Confirm that the box is checked beside the account for which you wish to download the transactions. If not, click to select the box.
  2. In the Download: section, click to select the radio button beside
    * Activity since last download
    * Transactions in the following date range
  3. If you select the date range option, you must also enter the From: and To: dates.
    You can click on the Calendar icon to select the From: and To: dates, or you can type them in MM/DD/YYYY format.
  4. In the Format: section from the drop-down select the software in which you intend to use the information. Choices include:
    * Quickbooks
    * Quicken
    * Simply Accounting
    * Spreadsheet (CSV format)
  5. NOTE CSV format means “comma separated values.” Each column of information will be separated from the next by a comma. This is the format that can be opened by Microsoft Office Excel and many other spreadsheet programs.
  6. Click on the Continue button.
  7. If you chose to download for a spreadsheet, the Opening statement.csv popup window will open.

The Opening Statment.CSV Page

  1. Click to select the radio button beside
    • Open with Microsoft Office Excel
      (or choose another program from the drop-down list); or
    • Save File

    then click on the OK button.

  2. If selected, a spreadsheet will open with your transaction history. You may need to widen some columns to see the values properly formatted.
  3. The data reported includes:
    • Your debit card number
    • The Transaction type;For example: Credit or Debit
    • the date posted
    • the transaction amount
    • a description
  4. So for example, it will show that you used your debit card on a certain date to make a purchase at Victoria’s Secret.
  5. If you are finished with online banking, sign out of your account.
  6. For increased security, clear your browser cache and close your browser session.

You can sort your spending by description which may be useful if you use Debit to pay for certain purchases regularly such as groceries

Drawbacks of the Transaction History for a BMO Bank Account

Unfortunately, the history does not differentiate between various types of transactions. For example, a pre-authorized bill payment is reported as a DEBIT just like an in-store purchase.

Keep Your Financial Information Safe and Secure

You may want to keep your downloaded banking transaction history on a separate device rather than on the hard drive of your computer, laptop or handheld.

For sure, I would recommend deleting your bank card number from the file. Why make it easier for someone to know how to sign in to your account?

Related Reading

Join In
Have you found any quirks when downloading your BMO bank account history? Do you download it regularly or only when you’re hunting for some anomaly? Please share your views with a comment.

How to Open a Tangerine TFSA Kick Start to Save in the Fall of 2014 for January 2015

Posted on by

It’s back! Once again, Tangerine is offering a savings account bonus rate for people who set aside money to be transferred immediately into their Tangerine TFSA Savings Account on January 1 2015. So if you have money you plan to put in your TFSA January 1 that is not earning much interest, you may want to open a Tangerine TFSA Kick Start Account and earn an expected annual rate of 2.6% for the next 2 plus months.

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.

Given that change, I would no longer recommend the Kick Start program unless you plan to keep your TFSA money at Tangerine for the long term.

Why Does the TFSA Kick Start Account Pay “Double” Interest?

You can’t put your 2015 money into your TFSA in 2014 without paying a big penalty to the CRA. So Tangerine can’t really offer you an early start on your 2015 TFSA.

However, most people are in a tax bracket where they pay a tax rate of 50% or less on their savings account interest. So if Tangerine pays you twice as much interest on your savings as they normally would, they consider that they are paying you the money you will need to pay your taxes on that interest. So the Kick Start account mimics a tax-free account.

For example, say you would normally earn $2 in interest on your savings account funds from October 1-December 31. If you are in a 50% tax bracket, you would have to pay $1 of that money to the government when you file your tax return in April.

Now if Tangerine paid you $4 in interest instead of $2, you would have to pay $2 to the government, but you would be left with $2—that’s the same amount as if you had not had to pay any taxes on your savings account funds.

Of course the real reason Tangerine is paying you extra interest is that they would like you to put your 2015 TFSA contribution into one of their financial products. The Kick Start account will automatically transfer your TFSA savings into your TFSA account on January 1 (up to $5500.)

Tangerine is hoping you’ll leave your TFSA money in that account or use it to buy one of their TFSA GICs or TFSA mutual funds.

They won’t be really happy with me: I will transfer (for no fee!) my TFSA money out of my Tangerine account on January 2, 2014, and send it to my brokerage account.

UPDATE: Since Tangerine is planning to charge a fee for transfers out of its TFSA to another financial institution starting January 2015, there is no longer any value to me in using the Kick Start program. I am withdrawing my contribution immediately. I will not earn any bonus interest, but I will be able to contribute my 2015 TFSA contribution without any fee in January to my brokerage account.

Why Go To So Much Trouble to Earn an Extra Couple of $$?

Personally, I don’t find it much work to enroll in the Tangerine TFSA Kick Start program. It takes about 3 minutes. What I’m putting into the account is money that would otherwise be earning only 1.3%. (It’s money that was not eligible for the recent interest rate promotions from PC Financial and Tangerine, partly because some of it had not been earned yet!)

It doesn’t matter to me if I have to wait a couple of weeks for my TFSA money to transfer from Tangerine to my brokerage, either. I like to study what I want to invest in, and I often find things are overpriced during TFSA and “RRSP Season.”

Last year, by the way, it took 11 business days for my TFSA money to transfer from Tangerine to my brokerage, including the time my request spent in the mail. It took 18 business days for my husband’s money to move.

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

Given that change, I would no longer recommend the Kick Start program unless you plan to keep your TFSA money at Tangerine for the long term.

How to Open a Tangerine TFSA Kick Start Account

  1. Click on the tab: Open a new Account
  2. Look for the Tangerine 2015 TFSA Kick Start Account section.
  3. Click on the button: Learn more
  4. Read through the program details. Click on the Enroll Now button.
  5. Click on the link: Legal Terms and Conditions. Read through the details. Click on the Back link.
  6. Click on the Open an Account button.
  7. If you don’t already have a TFSA savings account at Tangerine, you will have to give Tangerine permission to open a new one on January 1, 2015. Consequently, the following page will open.

The Open a Tax-Free Savings Account Page

Review your name, address, SIN and date of birth in the Client Information section. If they are not correct call Tangerine to fix them before continuing. If they are ok, continue.

In the Account Information section

The fields in this section are a bit confusing because they’ve combined two different activities: opening and funding your Kick Start account and opening a TFSA daily interest savings account on January 1, 2015. I confirmed what should go in each field with Tangerine.

For example, it seems to say “how much should Tangerine put into your TFSA on January 1 2015” but what it means is “how much do you want Tangerine to put into your TFSA Kick Start account today?”

  1. In the Amount field, type the amount of money you want to contribute to your Kick Start TFSA account today.
  2. If desired, change the Nickname for the account. They have pre-typed a name of: 2015 TFSA Contributions.
  3. From the drop-down list for Fund from this Account, select where you want the money to come from to fund your TFSA Kick Start account.
  4. Note the new TFSA account will be set up with the displayed Effective Date of January 1, 2015.

In the Legal section

  1. Answer Yes or No to the question: Will a third party of any other person benefit from this Account?
  2. From the drop-down list, select the intended use of your TFSA Kick Start account.
  3. Read the statement about how Tangerine will be applying to create a new TFSA savings account for you to begin in January 2015. If you agree that they can do this, click YES. If not, click No.
  4. Click on the Next button.

The You’re almost done…here’s what’s going to happen Page

  1. Review the information provided.
  2. If it looks correct, click on the Confirm button.

The You’re All Done! Page

  1. Copy down the confirmation number and other information from screen for future reference.
  2. Click on the button: Continue banking
  3. On the My Accounts page, under the heading Saving you should see your new
    Tangerine TFSA Kick Start Account – 2015 TFSA Contributions
    account with the balance you asked to transfer into it.
  4. If you’re finished banking, click on the Log me out link.
    For increased security, empty your cache and close your browser session.

UPDATE: I recommend you only apply for the Kick Start program if you intend to leave your TFSA money at Tangerine for the long term.

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

Related Reading

Join In
Do you take advantage of the increased interest paid on a Tangerine TFSA Kick Start account? Please share your experiences with a comment.