How to move from Quickbooks to Gnucash?

[Michael Henry]

Sure it'll work on Windows [?]

http://www.cygwin.com/


On Tue, Jun 19, 2012 at 10:26 AM, <LindenSys at aol.com> wrote:

> 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.
>
> _______________________________________________
> 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.
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 328.png
Type: image/png
Size: 569 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20120619/8dcb03e1/attachment.png>