QIF Record and field layouts

[Tom Bullock]

Hi Laura,

After reading everyone's replies to my questions, I realize that I 
should ask you to make clear whether or not you purchased that tool from 
bigredconsulting.com.  The tool talks mostly about converting excel 
spreadsheets into QIF files for import into Quicken & MS Money.  It also 
says it converts Quick Books into QIF files.  So I am inferring that you 
used the big red tool to convert QB to QIF.  Correct?  Or did you 
convert in some other manner because her file was very small?  Could you 
have done that simply by hand, transaction by transaction?

Your stated method was to load the trial balance as of a specific date 
(read chart of accounts with opening balances).  That could be done by 
hand I would guess and would not need the bigredconsulting tool.  Was 
that an option you used?  If so, how much time did you have to devote to 
it?  How many records did you manually convert?

TIA for your thoughts and ideas.

Tom

Laura Lincoln wrote:
> Hi Tom,
>
> I hope this works right...I am new to this mailing list...
>
> I recently converted a client from QuickBooks to GnuCash because she 
> bought a new laptop with Ubuntu installed. I ended up starting a new 
> file in GnuCash by entering the Trial balance from 12/31/08 and 
> started going forward with the January Transactions. I figured that 
> was the easiest for me to do the transfer. This is a tiny client of 
> mine so I was not in a position to incur massive amounts of billable 
> hours so I was looking for the easiest and quickest solution. I also 
> had never used Ubuntu or GnuCash before so I was doing this blindly.
>
> If you want to transfer the historical transactions then you need a 
> third party application like this one from Big Red Consulting. 
> QuickBooks supports IIF files while Quicken supports QIF files. You 
> can not export QIF files from QuickBooks.
>
> You would have to run Custom transaction report--one bank/credit card 
> account at a time, export the report to excel and then run this tool: 
> http://www.bigredconsulting.com/AboutXLQIFConverter.htm. The tool is 
> $49 which would be worth it if it meant having the history all in one 
> file.
>
> HTH,
> Laura
>
> On Mon, Apr 20, 2009 at 11:31 AM, Tax Assistance Program - ( taptax ) 
> <taptax at nd.edu <mailto:taptax at nd.edu>> wrote:
>
>     Hi everyone,
>
>     Still trying to get started.  I am moving my data from QuickBooks
>     (much different than Quicken) to Gnucash.  I can easily export
>     from QB to a tab or csv delimited file.  But moving that data into
>     the QIF format will by my challenge.
>
>     So I am studying what is involved and find that the information re
>     QIF format I found using google is pretty general.  I have some
>     sense of what it will look like but nothing specific.
>
>     Here are my questions:
>     a)    How many record types does QIF support?
>     b)    Where do I find the field-by-field layouts for each
>     supported QIF record type?
>     c)    What techniques did prior QB users invoke to make the data
>     conversion to QIF?
>
>     Once I have those answers I am assuming I should be able to
>     transfer my data from QB format to QIF.
>
>     Has anyone ever converted QB records to Gnucash?
>
>     Interested in all replies!  :)
>
>     Thanks.
>
>     Tom Bullock
>     _______________________________________________
>     gnucash-user mailing list
>     gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>     https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     -----
>     Please remember to CC this list on all your replies.
>     You can do this by using Reply-To-List or Reply-All.
>
>