ossblogger.com

I have been using jGnash for the past few month to manage my financial statement. However, I have not been very keen to use the software properly, (I just installed it as a trial and error basis) until last week when I realize that I have to do something to get the most out of my jGnash.

Yesterday, I decided to try to import all my financial statement that I have, mostly online statements, into jGnash. It looks easy at the beginning by just exporting the statement to QIF file, and import it directly to jGnash; but it actually not. Most of the time, I have to run “trial and error” before I could get the correct data field transfered into jGnash. A lot of issues occurred along the process, but fortunately, I could manage it after cracking “the geek brain” out of me.

These would be the challenges that I face during the process:

1. I would like to import my Google Adsense income statement to jGnash. Unfortunately, Google can only export the data as a comma separated value (CSV) file. As I need the data to be transferred straight to jGnash, I would have to do either manually (which will be very time consuming) or just convert the CSV file to QIF.
2. Importing my Paypal statement into jGnash is not as straightforward as it looks like. Although Paypal can export my statement to QIF, the file that it produces does not seems to be able to be “compatible” during the importing process.
3. The worst issues that I faced was my Maybank2u.com account. It’s my online bank and credit card account. It seems that I could not export the statement out easily, as they don’t have “export” feature, let alone CSV or QIF converter! I have to print the statement out (as PDF), and have to enter the data manually. Maybank will charge me RM10 if I were to request my bank statement printed out, have to wait for a few days before the statement ready, and have to go to the specific Maybank branch here in Kota Kinabalu to get the statement. Sigh…
4. Similar thing happened with my E*trade account. I could not export the statement out directly to jGnash, and they provide a PDF files of my monthly statement to be printed out. Another additional burden to enter the data manually into jGnash.

The solution for *some* of the challenges that I face above:

1. On exporting CSV file into jGnash: Use CALC2QIF to convert CSV file to QIF. You have to have Open Office installed in your computer first before you install CALC2QIF, because CALC2QIF is a macro for Open Office. It can convert almost all Open Office Calc data into QIF for easy import to jGnash.
   1. The installation for CALC2QIF is very straightforward. Download the ZIP file, extract it and just click calc2qif.sxc.
      

      

   2. It will automatically open your Open Office Calc with a security warning, saying that you are opening a document with macros. You don’t have to worry as the macros you are running is safe.

      

      

   3. You can choose where you would like CALC2QIF situated. I prefer it to be as one of the features in “Top Menu”.

      

   4. To convert your CSV file with this macros in Open Office, just click on the “calc2qif” tab on the main menu. A window will open and show the parameters that can be changed. You should arrange your data according to column that is sorted by type of field.
2. I use the step above to transfer my Google Adsense statement to jGnash, as Google just provide .CSV file download for the report.
3. For Paypal, I think there was some *bugs* with jGnash. The QIF file that Paypal produce does not seems to be behaving properly while in the process of importing. During the second stage of importing, at “2. Modify QIF transactions”, the changing of “Account” could not be done. I end up exporting Paypal statement to CSV and convert it to QIF with CALC2QIF…

   

4. For my Maybank2u.com and E*trade account - I have to transfer the data manually…

This entry was posted on Wednesday, November 14th, 2007 at 4:40 pm and is filed under . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.