How to move from Quickbooks to Gnucash?

[flywire]

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.