Bank statement import strategies from bad formats?

[David T.]

I don't think you have the wrong tree. Others have pointed out:

http://xl2qif.chez-alice.fr/calc2qif_en.php


That's a tool that takes a spreadsheet (in OpenOffice Calc in this case. there may be one for Excel as well) and converts it to QIF, which you can then import into GnuCash.

I am not a user of this tool, but there it is.

David


________________________________
 From: "yggdrasil at gmx.co.uk" <yggdrasil at gmx.co.uk>
To: gnucash-user at gnucash.org 
Sent: Tuesday, February 4, 2014 11:49 AM
Subject: Bank statement import strategies from bad formats?
 

Hi,

Sorry for polluting the list with a very peripheral gnucash issue, but I
guess others have faced challenges in getting bank statements imported
to gnucash when the bank doesn't kindly provide any usable format.

,---- PROBLEM STATEMENT
| I can get only xls or csv from my bank(s). I would like an
| easy way to import this into gnucash, is there any good and reliable
| method? 
`----

,---- OPTIONEERING
| I know there's a csv import, but I haven't succeeded in getting it
| reliably imported from various bank formats and in any way would prefer
| to first get it into a spreadsheet so I can check the crap my bank
| produces if it looks reasonable, and then using a convenience function
| to export to a stable format. 
| 
| I am thinking .ods to .ofx export here, and preferrably through a python
| macro, as it is one of the few languages I barely comprehend. Now, I did
| start looking into this to get pyuno up, but realise I have some mileage
| to cover, so hence I ask the collected experience out there:
`----

,---- QUERY
| Am I barking up the wrong tree? Should I really learn to use the csv
| import feature reliably? If so any tips on work flow? Or is there a nice
| python macro to achieve this for libreoffice somewhere already? Is there
| maybe a better way?
`----

Many thanks for any creative ideas!

Cheers,

Johnny
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.