Built a small app in Ruby + Angular to make some sense of my GTB transaction statement. You can play with it if you want to. Tried as much to ensure secure hashes and no snooping around. You can delete your summary anytime too.
Hahahahaha, Merry!
Gotta try this.
Nice idea. It would’ve been nice to see a screenshot first. I think it would persuade people who are reluctant to upload their bank statement.
1 Like
Screenshots. True. True. I did it for myself, so I didn’t really think about convincing people so to speak. But I’ll definitely do that by the end of the day. Gotta work now!
1 Like
I so love this. Just tried it myself. Yes, screenshots. Also include a short “how to download statement” e.g
Download your GTB statement (available in My Account >> Account Statement) then upload here
3 Likes
Nice. I was too lazy to do similar: https://twitter.com/stigwue/status/508938536708354048
Thanks. I’ll do that tonight (hopefully) too.
Since it is a CSV upload, this application is not nessarily limited to GTB statements, is it?
Very well done!
It’s not a CSV. GTB sheets are false XLS, i.e HTML tables saved as an XLS sheet. So for now, it won’t even work with a proper XLS sheet. As per the other banks thing, there is not standard format, so I’ll actually have to go through other bank sheets to be able to support the transaction rows, formats and pick out where the actual data is
Re other banks, I suspected that was the case, so all you have to do is create the template like 30 times 
Or you could just support the top three.
Top 3 is the most likely case. Depending on who wants it?
Nice one @FatherMerry … @lordbanks, started an open source parser for banks about 3 months ago with @FatherMerry when he first shared the idea with me. Maybe now is a good time to go finish up. The design is such that any one can write a parser for his/her bank while following specific guideline. Was in the middle of writing the tests when I got busy. @FatherMerry as a bad guy went on to learn Ruby to power his UI. - https://github.com/yomexzo/bank-statements/tree/develop
1 Like
Impressive! Nice one @FatherMerry
Nice UI @FatherMerry
So none of you can upload screenshot for us to see abi? 
Hypothetical Improvements
- Learn user’s spending pattern and give financial advice.
- Use account summary to categorize expenditure (e.g. spend at Shoprite is probably for grocery)
- Integrate with user’s accounts in real-time so that financial advice (in 1) can be offered in real-time
- Granularize user’s spend by allowing the upload receipts from checkouts
My assumption is that you are Genie, and you can make at least 3 of the above come to past 
2 Likes
Disclaimer! Disclaimer! Not Genie! Lol. I have some of those penned down already. Thanks for the list. Definitely in consideration
Awesome work you’ve done there. Welldone!