Was it useful for you?
Average 4.33 Votes: 9

Loading ...

08/03/2010 10 comments

If you think this tool was useful for you, please leave your comments

Blog, Feedback comments, CSV, Feedback, help, QIF, support

Comments

Leave a comment Trackback

Written by drewrosenberg on 24/03/2010.

very useful. I have been using this site for several months now. I use GNUCash because the double entry accounting makes it easy for me to manage my budget, but my wife hates it. She uses mint.com to assign expenses to budgets. I can download CSVs from there, tweak them, and then convert to QIF on this site. It has been very helpful on linking my GNUCash planning with my wife’s mint.com allocations. I have found no other tool that does it.
Written by David on 05/04/2010.

I’m just setting up a gnuCash for my personal finances, and my bank only exports CSVs. I’m not entirely sure what each field means in the drop-down list provided for matching with columns in the import CSV file, and there isn’t any documentation to this effect on the website. Mind providing some descriptions of what each means / what technical limitations it has, etc.?
Written by Webmaster on 05/04/2010.

We are working on online manuals and tutorial videos, which should be ready by Mid-May.

To map your banking statements, you will use mainly:

Date – Depending on your location and system configuration i.e. US (Monty/Day/Year), UK (Day/Month/Year)
Num – Transaction number
Category – Type of transaction i.e. Deposit, Withdraw, etc
Payee – i.e. Supermarket X, ATM, etc
Memo – Anything you like
Value – The amount of the transaction. Use Value(-) for debits
Splitter – Used to split your CSV into multiple QIFs. If you download a CSV with all your bank accounts, you can use Splitter for the Account Number and then import the QIFs into each individual account

Here are some links for GnuCash explanation on how to import QIF files:
http://svn.gnucash.org/docs/guide/basics-import1.html

http://svn.gnucash.org/docs/guide/accts-concepts1.html

http://www.gnucash.org/docs/v2.0/C/gnucash-help/set-prefs.html#prefs-online
Written by Ely Bonder on 21/04/2010.

Thank you for this service. But it did not work 1st try.

My bank exports the transaction history as Excel .CVS , as far as i can tell…so that’s what i uploaded to your site, and without pressing any of the side buttons, i pressed “convert”, and saved the QIF file.

No success when i had Quicken Home and Business (2009) import the QIF file.

Apparently nothing was saved in that file, even tho i saw all the records from my .cvs upload on your site.

Help ? (I hate banks that don’t give a damn about their clients by not participating in Web Connect). So thank you for your initiative.
Written by Webmaster on 21/04/2010.

Hi Ely,

We are working on manuals and tutorials. We should get them ready by the end of May.

Meanwhile I will give some steps to have your CSV files imported into Quicken:

1 – Click Choose and open your CSV file
2 – Map each content to the appropriate field by clicking in the selectable dropdown lists on the left. Example [Value] $56,01
You can map [Date MM/DD/YY] to the content that is a date, the description of the transaction can be mapped as [MEMO], etc
3 – Click Save as CSV
4 – Import the QIF file into Quicken
5 – You can Save the mapping to use it again with another CSV file from the same Bank

If you are still having difficulties, please let me know and I will try to help.
Regards,
Marcelo
Written by Ely Bonder on 25/04/2010.

First off:

No dropdown date is available that is typical for Quebec : 2010-04-19 , and is the way my CSV file is configured by the bank . Is that important ?

Do the drop-downs have to be functional in order to convert to QIF ?

Do I have to logon in order to load the map ? (Does that then retain my info inadvertantly on your servers?).

Quicken says they are not servicing QIF files, only OFX or QFX. But then it only offers QIF import in its FILE actions, i think . Can you convert to OFX or QFX if necessary ?

Thanks for your advice. I am a candidate for CSV or excel to QIF (OFX/QFX) for dummies, at this point !
Written by Ely Bonder on 25/04/2010.

I tried plugging in MEMO to each of the lines, and saved my file as QIF, and it finally showed some 39k of data in it. When i try to import into QUICKEN as a QIF, an error message says : No valid records to import.

I will stay calm…i will stay calm…
Written by Webmaster on 28/04/2010.

@Ely
Regarding the format YY/MM/DD: The converter will try to detect the input format and should recognize any format. The dropdown box will specify the output format. As far as I know Money/Quicken will use either DD/MM/YY or MM/DD/YY. If your accounting software requires YY/MM/DD please let me know and we will implement this.

In order to have your CSV file converted, it is compulsory that you use the dropdowns to specify which field will be assigned to each content.

You do not need to login in order to convert. By signing in you will be updated of any news and improvements on this tool. We do not keep your data. Once your converting session is finished, the temporary files are erased from the server.

Regarding OFX files, we have plans to provide support for this format in the future.
Written by Webmaster on 28/04/2010.

@Ely
You need to map Memo just once, for the field that shows description of the transaction.
Date to a date content.
Value to a value content.
and so on…
Written by Nick on 06/03/2011.

Coop Banking Business do not make life easy if you use Money. It took a while to get the software running, but I can now convert my bank downloads without too many errors to .QIF. Saves me a lot of time.