Skip to Content

Reader shares his budgeting experience with iBank and Singapore Bank’s transaction format

I did an article sometime back teaching readers how to plan, create and use a budgeting software in 10 steps and its been a very popular topic primarily because it is something most people would always want to make sense of.

One of my readers YYT shares with us some really interesting comparison of how each Singapore bank stack up in their support for electronic bank statements.

For International Readers info, a lot of web budgeting apps like Quicken and Mint allows automatic pulling of transactions from banks. Perhaps international users don’t have that luxury.

YYT uses the iBANK for MAC which looks to be very powerful. It allows offline sync to your iPhone through WEBDav and allows you to plan using the envelope budgeting method.

Here are his thoughts:

For Mac users, guys might wanna try iBank, Moneywell, Quicken for Mac to track your bank accounts.

Personally I’m on iBank. It also an app for your iPhone to track your expenses on the go. You can then sync it with the program when you’re back homoe. Haven’t tried that yet though…haha, not on an iPhone yet

My tracking involves exporting all my monthly bank statements into either OFX or CSV formats, then import them into iBank. iBanks can then “learn” frequent transactions and categories them automatically :) this is what I like haha.

Some additional notes regarding exporting bank accts/Credit card statements from local bank:

Citi accts/CC – variety of formats OFX, csv, qif, etc
DBS accts – only csv format
UOB accts/CC – csv, BUT with a .xls extension
SCB accts/CC – csv and pdf format

I believe citi has the best online platform out there so far. Formatting is consistent and most imptly the data is easily exported with inter-operability high on their minds. You can easily import their data to any financial softwares.

DBS and SCBs are not that bad, at least they standardize their export formatting (i.e. CC statements and Savings statements looks relatively the same).

UOB can really really work on thier online platform.
The exported data for Accounts and Credit Cards are formated so differently, which is a pain in the *** when you try to parse it.

Haha, so hope this helps in the audit trail too for pple on the Mac.

[Read How to create a budget plan in 10 easy steps >>]

Kyith

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Nepa Luzinka

Thursday 18th of April 2013

Convert your OCBC Bank CSV files to QIF or OFX using iCreateOFX Basic from www.icreateofx.co.uk/basic.php using the OCBC Bank (SG) script

Kyith

Thursday 18th of April 2013

hi Nepa good share. are you a Singaporean? how do you know about OCBC bank?

yyt

Tuesday 2nd of November 2010

some updates on this...

Only Citibank allows you to download ALL your bank and CC statements at a shot. Another plus for them is that they give meaningful filenames to the downloaded statements.

For the rest of the banks, you'll have to d/l them individually, and they give weird generated filenames. :/

Drizzt

Tuesday 2nd of November 2010

thats good to know. if i had my way i would have come up with a php solution to message this.

This site uses Akismet to reduce spam. Learn how your comment data is processed.