| The following was written by Roger Gale who uses the software to import details from a Canadian bank. And is reproduced with his permission. This is a picture of a credit card statement (top and bottom cut-off). 
Highlight the items in the statements as follows: 
Right click and select copy, or use CTRL+C. Now start Excel and do a “Paste Special” in Cell A1, select paste as Text. The data will look something like this:
All the data is in the first column so then we need to go to Data/Text to Columns and select “fixed width” to separate the items into columns: 
Click Next and put lines where you want the columns to appear. Some of the items might be slightly offline because of the difference in lengths of the name field… I’ll edit them later:  After selecting the break-lines (double clicking on a break-line makes it disappear – and pointing and clicking allows you to move a line) click Next and then select the date format for the first column (in this case MDY). The rest can be left in General. After I click “Finish” I have:
Which I then adjust for width, move and type items that are not in the right places (I also had to delete row 11 after moving the $11.19 to the end of line 10). I then moved the “Reference” to the Memo field (after the Name). Oh – and since Excel does is so nicely I sorted in descending order based on Column A. The final sheet looks like this:  The final sum at the bottom was just a double-check I then save this as a CSV format sheet (after deleting the sum) and answer all of Microsoft’s warnings about the format (can’t they believe that I REALLY want to save something as csv???). Anyway... I then load the csv file into a text editor. I do a global search and replace on Feb-04 and replace it with [space]February[space]2004 (dates are a real pain!):  I also have to get rid of the KELOWNA CAN since that (seems) to make the line too long (I end up with a “Corrupted Data” error from Money). So I replace all instances of this with nothing. The Final CSV looked like:  I then ran OFXConverter on this file and received an error on import (GBP is not supported when not an installed currency – thank goodness I had not installed it!)… I then opened the OFX file and edited the GBP to CAN (Canadian Dollars).  I double-clicked on the file (without the XXX’s for the credit card number) and lo-and-behold, it imported!! Anyway – this may seem like a lot of work – but if I can cut-and-paste from any type of account and just edit a file afterwards to get it to import – that is GREAT… Saves a lot of typing!! 
| 
