How to move from Quickbooks to Gnucash?

[LindenSys at aol.com]

Mr. Gibson, 
 
Never mind, reread the Linux comments. This will not work for  Windows.
 
Harry
 
 
In a message dated 6/18/2012 2:49:23 P.M. Pacific Daylight Time,  
LindenSys at aol.com writes:

Mr.  Gibson, 

Can you clarify what you mean by "run the script"? Everything  is fine up 
to 
that point (WinXP) but other than just open the document  which is 
basically a  text file the run command is not an option.  

Thank you,
Harry


In a message dated 6/18/2012 6:50:08  A.M. Pacific Daylight Time,  
flywire0 at gmail.com  writes:


Dean  Gibson wrote
> 
>> ... so I wrote  my own converter using  Linux's AWK program.
>>
>> The  Linux script is here:  http://www.ultimeth.com/download/Tsv2Qif.sh  
>> -- it's about 50  lines of AWK commands and about 40 lines  of 
>> "how-to".  The  "how-to" is displayed if you invoke  the script without 
>> any  parameters.

These notes need  to go into the FAQ. The important parts  are:

>>   Steps to export from QuickBooks (tested w/  2003 version) into a  
".QIF"
>>    file suitable for import  into  GnuCash:
>>
>>    1. In QuickBooks, select   menu items "Reports", "Accountant & Taxes",
>>      and "Journal".
>>
>>    2. Modify the  date  range to include the desired dates.
>>
>>      3. Using the "Modify Report" button, add "Item", "Item   
Description",
>>       & "Account Type",  and  then sort by "Date".
>>
>>    4. Select  the  "Print" button, "Settings" tab, "Print to File"  radio
>>     button, & "Tab delimited file"  pull-down, and then  "Print".
>>        Provide a suitable file name  ending in  ".tsv".
>>
>>    5. Exit QB and run this   script with the above filename (omitting
>>       the ".tsv" extension) as the only parameter.  The output   file
>>       will have the same name, with  the  extension ".qif".
>>
>>    6. Import  your new  ".qif" file into GnuCash.  The required  accounts
>>     should be automatically created, but  you will want to change  the
>>        account "Type" as appropriate for  each  account.
>>
>>    Copyright (c) 2012 by Dean   K. Gibson
>>    Free to use, modify, or  distribute;   just don't claim it's yours.

awk doesn't mean  much to a windows user  but the following is the  Field
Layout:

TRANSACTION =  1;
TYPE = 2;
DATE =  3;
NUMBER = 4;
NAME = 5;
MEMO = 6;
ITEM = 7;
DESCRIPTION  =  8;
ACCOUNT = 9;
DEBIT = 10;
CREDIT =  11;
ACCT_TYPE =  12;

===

Thanks Dean

--
View  this message in  context:   
http://gnucash.1415818.n4.nabble.com/How-to-move-from-Quickbooks-to-Gnucash-
tp4443254p4655414.html
Sent   from the GnuCash - User mailing list archive at   Nabble.com.
_______________________________________________
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.

_______________________________________________
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.