"A fool may earn money, but it takes a wise man to keep it." - Scottish Proverb
logo

Go Back   Saving Advice > Financial Chit Chat > Personal Finance

Personal Finance Credit cards, home loans, retirement plans and taxes. The place for all your personal finance questions.

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 04-03-2007, 09:26 AM
zetta zetta is offline
$ Saving College Sophomore
 
Join Date: Oct 2006
Posts: 793
Last Blog Entry: Quarterly Goals Review 2009 Q4
Points: 5914.60
Donate
Default Tool for converting transactions to OFX or QIF formats

Anyone who has been following my posts about envelope budget software knows that I've had issues with importing transactions from my Bank of America credit card. I can cut-n-paste into excel and convert the text to CSV, but needed a way to then generate an OFX or QIF file.

I'm happy to report that there is a tool out there that solves my problem -- MT2OFX. It's available here:
Welcome to MT2OFX
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.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Powered by vBulletin®
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.0.0 RC6 © 2006, Crawlability, Inc.

Copyright © 2012 SavingAdvice.com. All Rights Reserved.