Layout:
Home > Import problems solved

Import problems solved

April 3rd, 2007 at 04:56 pm

Anyone who has been following my posts about envelope budget software knows that I've had issues with my Bank of America credit card.

I'm happy to report that there is a tool out there that solves my problem -- MT2OFX. It's available here:

Text is http://www.xs4all.nl/~csmale/mt2ofx/en/ and Link is
http://www.xs4all.nl/~csmale/mt2ofx/en/

This tool will convert between many formats, but my primary use is to take in a csv (comma separated value) file and convert it to OFX, which is what YNAB takes. It comes with scripts for a number of (mostly European) banks, unfortunately none of them worked out of the box for my csv. It took me about 3-4 hours of playing with the script, but in the end I was able to create a script that does the conversion that I need. I'd be happy to share my script and some pointers with anyone who wants it -- just PM me.

The good news is that this frees me up to use any software that takes QIF or OFX imports.

I did my end-of-month wrapup with YNAB last night. I still find the idea of changing my budget to match my actuals at the end of the month (in order to move money from underspent catagories to overspent catagories so that the month is in the black overall) to be counter-intuitive.

1 Responses to “Import problems solved”

  1. Andre Powell Says:
    1191867106

    I recently found your link that mentions MT2ofx would you mind sending the script that works with us banks
    thank you
    Andre

Leave a Reply

(Note: If you were logged in, we could automatically fill in these fields for you.)
*
Will not be published.
   

* Please spell out the number 4.  [ Why? ]

vB Code: You can use these tags: [b] [i] [u] [url] [email]