New parser for Quicken QIF files

[Uwe Ziegenhagen]

Maybe this is interesting for some of you.

I had some issues with the Python-based QIF parsers I found online (thay just gave errors parsing my QIF file) so I decided to write my own parser. I am not sure how stable it is, I still need to add tests and more documentation but if you can use it for something useful you find it in github:

https://github.com/UweZiegenhagen/PyQIF-Parser

So far I have concentrated on the export into pandas dataframes, if one of you needs some additional functionality let me know.

Uwe

--

Dr. Uwe Ziegenhagen

0179-7476050
<http://www.uweziegenhagen.de>

[Robert Hotchkiss]

Hi, 

I was able to get your importer to work after installing pandas and xlsxwriter, and change the date format to match my bank's format.

But now I'm not sure how to convert from excel to beancount transaction format, but will look into that.

[Uwe Ziegenhagen]

Oh, actually I have not implemented this, yet. Put I'll put it on the agenda for tonight. Check the github for any updates.

Uwe

[Uwe Ziegenhagen]

I have added a very basic Beancount export:

P.to_beancount('r:/beancount.txt')

* I used 50 characters of the description for the description in Beancount.

* EUR is currently hardwired, it seems as if the QIF export does not contain the currency for this account. :-O

* for both sides of the transaction I currently use the category. I'll switch this to the account the transactions were exported from, the other side will just be the category.

If you have some ideas how you need which transactions to appear, get back to me.

Uwe

--

Dr. Uwe Ziegenhagen

<http://www.uweziegenhagen.de>