Bout

Parse bank statements (csv) and export them to qif format.

Supports ICICI bank and credit card statements out of box. Contributions are most welcome for adding support for another bank. Create an issue to start.

Download the bank statements in csv format from the ICICI website and provide them as an input to the tool.

Installation

pip install bout

Arch Linux may use the bout package from AUR.

yaourt -S bout

Usage

$ # convert an ICICI statement to qif
$ bout ~/Downloads/icici_statement.csv --profile icici > /tmp/icici.qif
$ cat /tmp/icici.qif
!Account
NMyAccount
TMyBank
^
!Type:Bank
D01/07/2017
MBIL/12419860068/VF M Jun 17/344548182
T-354.56
^

$ # convert a password protected ICICI Credit Card statement
$ bout ~/Downloads/cc_jun.csv --profile icicicc > /tmp/icicicc.qif
$ cat /tmp/icicicc.qif
!Account
NMyAccount
TMyBank
^
!Type:Bank
D14/06/2017
MAPOLLO HOSPITALS HYDERABAD IN
T-60.00
^

$ # print verbose messages to diagnose conversion
$ bout ~/Downloads/cc_jun.csv --debug --profile icicicc > /tmp/icicicc.qif

Contribute

Please try bout and file any issues at github issues page. Your patches are welcome!