Importing ICICI Bank, other Banks and Android Applicaton Transactions in GnuCash.

I posted about the same topic in 2011. I have decided to maintain the Books of Accounts on my own in the Current Financial Year 2015-16 (since the tryst with Steam Turbine is temporarily suspended and tryst with Linux is on which the readers of this Blog would have noticed anyway looking at frequency of my posts). I installed GnuCash 2.6.6 on Ubuntu through Software Centre couple of days ago and started importing the Bank Account Files. ICICI Bank no longer offers QIF/MSMoney Fomat download as stated in comments on the year 2011 post. No problem for me. I downloaded the Excel File and saved as CSV which was accepted by GnuCash in the option "Import Transactions from CSV".

I imported the transactions from Bank Accounts, Credit Card Accounts and the corresponding debit/credit entry went into Imbalance and only task then was to change the imbalance into the correct account.

I have again become my own CA, thanks to GnuCash.

I also installed GnuCash Application on Android Phone, created Expenses Account, entered the Cash transactions while shopping, exported the transactions in QIF File, imported that File on Desktop Application and the Transactions are entered there. Great going.

Importing ICICI Bank and other Banks account file in GnuCash

Update: This is four years old. A new post on same topic may be found here.

I wrote in the previous post that I would write about how to import Indian Banks Transaction files in GnuCash accounting software.

ICICI Bank offers download of Bank Transactions file in MS Money Format (.qif) and GnuCash accepts importing this file format but when you try to import it may fail and if it succeeds the import wizard will ask many questions. Open Office has a macro CALC2QIF which imports .qif file. When you import the file you will see that the Category column has entries like TCI, TBI, TIP etc and while GnuCash can import the transactions into the Bank Account it does not understand where to post the corresponding debit/credit entry into the other account. Let us consider one example.

Suppose you have received payment from your Customer there are two entries to be made. One in the Bank Account and the other in Accounts Receivable but the file downloaded from ICICI Bank shows TBI on the Category. You need to change TBI to Accounts Receivables. Similarly you should write the names of other accounts like Cash etc in the Category column. If you can't decide the account name you can write Imbalance against such entries in the Category and GnuCash will show them as imbalance till you change them.

After you change the entries in Category column you should select the cells and click on Save to QIF, clear the default fields and select them again in the order they are displaced i.e. Date, Amount, Check Number, Payee, Memo, Category and Sub-Category, select the destination for QIF output file and click on Convert.

Now you can import this file easily in GnuCash.