Rss

ICS Cards – Export Statements

As part of my banking with ABN Amro I get a credit card managed by ICS Cards.

The single most annoying thing about ICS Cards is that they don’t provide any means of exporting my statements. The next most annoying thing is that they haven’t responded to any of my emails request that feature.

Time to help myself then, in true developer fashion, I’ll write my own.

I’ve used loads of languages over the years and different languages suit different tasks. Python turns out to be my go-to language for scraping web-pages and pulling out information from them. Mostly because it’s really easy to knock up a script and because there are loads of great libraries already available to do most of the grunt work.

So here it is. A quick and dirty script to log into my account, parse the monthly statement page, fix the formatting and write it out as CSV.

This is by no means a finished script (have you seen how messy it is!!) and it’s kinda hard-coded what it will download.

Here’s an example output once the script is done with it:

Share on Google+0Share on Facebook0Digg thisShare on Reddit0Share on StumbleUpon0Share on Tumblr0Tweet about this on TwitterPin on Pinterest0Share on LinkedIn0Email this to someone

Comments (4)

  1. On the business side, ICS Card Services decided in all their wisdom to only offer downloadable PDF statements; the URLs you’re referring to don’t even exist there. I’ve called and emailed them and intend to follow up; I mean, it’s 2014, every other bank and non-bank (hello Paypal) offers export functions so I’m not sure what they were thinking, but they must’ve skipped coffee that day.

    Does this still work for you on the consumer card site?

  2. Martin Gill

    I agree with your sentiments, which is why I wrote this script.

    It still works, as the site I log into hasn’t changed.

    It’s not an overly reliable nor stable approach, as I had to intercept and reverse engineer the login process and then do the same for the URL scheme before even getting to parsing the page. I’m not sure it even works for statements with multiple pages, as I never had any to test.

    Since ICS-cards appears to have custom sites for different banks (and business as well, it seems), those pages could well be different and break the script.

    While this script is probably a very good starting place, you’d probably need to customise it for the site you have to log into.

  3. I share your frustration. Thanks a lot for this script!

    Unfortunately it doesn’t work any more, they must have changed the HTML. With some tweaking here and there, I got it to work again. Here’s the 2015 version 🙂

    http://pastebin.com/6uab5g3S

Leave a Reply