If you happen to be a customer/user of
- mizrahi-tefahot.co.il
- bankhapoalim.co.il
- isracard.co.il
- bankleumi.co.il
and you’d like to put your financial data using something more sensible, like Quicken or GnuCash - this script is for you. Has been tested and found to work with Mizrahi exported files from June 2015, and imported with GnuCash 2.6.1
run “npm install”. this is expected to setup dependencies (coffee-script, qif, cheerio).
- login to mizrahi-tefahot.co.il and export the data you’d like to work with in .xls format.
- pipe the exported file(s) into the conversion utility. Be sure to specify either “checking” or “credit” as an argument to the importer, depending on the file type. Pipe the output to your destination file
- import the .qif file in GnuCash or whatever it is that you use.
cat ~/path/to/AccountActivity.xls | coffee xls2qif.coffee mizrahi-checking > AccountActivity.qif
- [ ] mizrahi’s checking mode export date is ambiguous. As a result, GnuCash will prompt what format the file could be used for.
- [ ] when importing exports with overlapping date ranges, the burden of deduplication falls upon GnuCash. we could make it easier by allowing to provide date range arguments for the QIF exported data.
- תומך בפורמטי היצוא של
- בנק מזרחי טפחות
- בנק הפועלים
- ישראכרט
- בנק לאומי
- הופך קבצי אקסל ל .qif
- מאפשר לייבאם לתוך GnuCash או Quicken