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.
Money in Excel is available on PC or Mac in the Excel desktop app, or in the browser with Excel for the web. You may view your Money in Excel file in the Microsoft Excel or Microsoft Office mobile app, but you will not be able to load new transactions, capture changes, or access the Money in Excel pane. On the New computer when I opened Ms Money I received this: Money cannot locate C: Users TheTerrace Desktop My Money back up my money back up jan 06 2013.mbf or cannot open it, possibly because it is a read-only file or you do not have permission to change it or your Disk is write protected. Because when it comes to your money, every little bit counts. Orange Everyday Youth bank account. Helping teens aged 15 to 17 to start out right. Personal Savings. All personal savings. ING is a business name of ING Bank (Australia) Limited ABN 24 000 893 292. Money in Excel. Seamlessly connect your financial accounts to Excel to view and manage all your finances in one place. Understand how you’re spending your money and receive personalized insights about your monthly spending so that you can achieve your financial goals.
Copying your Tangerine Bank Account Transaction History Onto Your Computer
/ Mastering Microsoft Money (Closed. I was told that Money has the ability to track subaccounts. With the discussions about Freedom Accounts on the LBYM and Budgeting Boards, I've decided to create a Freedom Account comprised of subaccounts such as insurance premiums, house, car, etc. I want the account to balance as it's in my ING.
To Login to your Tangerine account/s
- Go to: http://www.tangerine.ca/en/
- Click on I’m a Client, Let Me In!.
- Enter your Client Number, banking Card Number or Username in the Log me in box.
Click on the Go button. - If necessary, in the Your Secret Question: box, type the Answer: to the question.
Click on the Next button. - 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
- Click on the View My Accounts link.
- Scroll down to the bottom of that screen.
Click on the Download Transactions button. - From the drop-down list select the account for which you wish to download the history.
- 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.
- 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 - Click the Next button
- Review the information on the screen called Here is the information you selected for Download
If it looks correct, click on the Download button. - In the SomeName.CSV window, select either
- Open with; or
- If you select Open, you must also select a program from the drop-down list.
- Save File
- Click on the OK button.
- If applicable, select where you want to save the file.
- Click on the Save button.
- 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
- Credit
Credit does not mean you used your Credit card. It means money was put into your account. - Debit
Debit does not mean you used your Debit card. It means money was taken out of your account. - Other
Other is used for reporting things like you ordered your first (and only) free cheques. (If you want unlimited free cheques, consider opening a PC Financial no fee chequing account.) - Int
Int means interest. - There may be other codes that were not applicable to me.
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.
Ing Microsoft Money Transfer
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.
Ing Microsoft Money App
Related Reading
Ing Microsoft Money Market
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.