QIF Record and field layouts

[Rick Rogers]

Tom: These are Excel and Calc macros that you add on. They appear to be 
written by the same person. I can only relate my satisfaction with the 
OO Calc one. I have used it several times (including a few minutes ago) 
with no problems using Vista.

The data I converted with the macro was almost two years of checking 
account history downloaded from my bank that  I brought into Calc. I 
used Calc to assign each transaction to various category and 
sub-categories for the lowest levels of my chart of accounts. The author 
has a short but adequate help file showing a sample column layout. I 
have not attempted to import splits, however it appears able to do this.

I tested it first with a small segment of the data I wanted to import. I 
set GnuCash to not automatically save the file periodically, (I always 
do this before importing) so I can just close it if I have created 
problems and restart to where I was before the import. You can convert 
and import as many segments as you want. It doesn't have to be all at once.

Hope this helps, Rick


Tax Assistance Program - ( taptax ) wrote:
> Rick,
>
> Are you saying that XL2QIF should work using Excel because a different program worked using Open Office Calc?  Do I have your meaning?
>
> Tom
>
> -----Original Message-----
> From: Rick Rogers [mailto:rrogers at rcn.com]
> Sent: Monday, April 20, 2009 1:50 PM
> To: sunfish62 at yahoo.com
> Cc: gnucash-user at gnucash.org; Tax Assistance Program - ( taptax )
> Subject: Re: QIF Record and field layouts
>
> Regarding XL2QIF, I had complete success with their counterpart for Open
> Office Calc. They also have some links to QIF file format references.
>
> David T. wrote:
>   
>> 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
>>>
>>>       
>>
>> _______________________________________________
>> gnucash-user mailing list
>> 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.
>>
>>
>>
>>     
>
>
>