israeli banks transaction dumps .xls exporter to .qif

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

Installation

run “npm install”. this is expected to setup dependencies (coffee-script, qif, cheerio).

Usage

1. login to mizrahi-tefahot.co.il and export the data you’d like to work with in .xls format.
2. 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
3. import the .qif file in GnuCash or whatever it is that you use.

Example

cat ~/path/to/AccountActivity.xls | coffee xls2qif.coffee mizrahi-checking > AccountActivity.qif

Issues / TODO

• [ ] 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

• תומך בפורמטי היצוא של
  • בנק מזרחי טפחות
  • בנק הפועלים
  • ישראכרט
  • בנק לאומי
• הופך קבצי אקסל ל .qif
• מאפשר לייבאם לתוך GnuCash או Quicken