With the growth of third-party online financial management sites (like Mint and Buxfer, to name two), the ability to get detailed financial data out of your bank’s portal and into somewhere else is more important than ever. If you’re doing this, you should be using OFX (sometimes labeled Microsoft Money) format files. They’re very simple, humanly-editable, and financial websites love to read from them.
Some banks, however, aren’t as flexible as one would like in controlling what they export – for example, my bank (RBC) won’t let me select a specific date range to export. To simulate this, I decided to edit the OFX files they did offer by hand.