QIF Record and field layouts

[Tax Assistance Program - ( taptax )]

Hi David,

I appreciate your reply.  Great reference to follow up on.  Thanks.

Tom

-----Original Message-----
From: David T. [mailto:sunfish62 at yahoo.com]
Sent: Monday, April 20, 2009 12:26 PM
To: gnucash-user at gnucash.org; Tax Assistance Program - ( taptax )
Subject: Re: QIF Record and field layouts


Removing devel list, as this isn't a developer question.

This has been tackled by others, so before you put in a great deal of effort, you might search out some of the CSV (or XLS) to QIF converters that address this. One that's been mentioned here before is XL2QIF (http://xl2qif.chez-alice.fr/xl2qif_en.php). I can't vouch for the success, but there you are.

HTH,
David

--- On Mon, 4/20/09, Tax Assistance Program - ( taptax ) <taptax at nd.edu> wrote:

> From: Tax Assistance Program - ( taptax ) <taptax at nd.edu>
> Subject: QIF Record and field layouts
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>, "gnucash-devel at gnucash.org" <gnucash-devel at gnucash.org>
> Date: Monday, April 20, 2009, 8:31 AM
> 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-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel