What's the easiest way to export Gnucash to QuickBooks?

toli toli at marketcetera.com
Tue Jan 16 20:39:43 EST 2007


Hi, 
We've been using Gnucash for about a year to keep track of our startup's
finances, and it's been wonderful.
Find it really easy and straightforward to keep track of everything.

However, now that we have to pay taxes, I'm trying to find an easy way to
convert the data into something that can be imported into Quickbooks, since
our accountant obviously wants to use Quickbooks to do our taxes.

I've seen an old thread
(https://lists.gnucash.org/pipermail/gnucash-user/2002-November/004591.html)
on a similar topic, but it never got answered.

I know there are 2 approaches i can take, but neither is really simple:

1. Use the Gnucash -> Gnumeric -> XLS approach from
http://edseek.com/archives/2005/08/18/gnucash-export-to-gnumeric-and-csv/
I'm not a Quickbooks expert, but this results in an Excel file with a
worksheet for each account, and it's fairly non-trivial to map it for import
into Quickbooks afterwards. For example, I have no idea how to connect the 2
sides of double-entry for each transaction later in quickboooks.

2. Use gnucash --> QIF --> IIF approach
(http://gnucashtoqif.sourceforge.net/ for gnucash -> QIF and
http://www.bigredconsulting.com/AboutQIFConverter.htm for qif -> excel ->
IIF conversion).
Unfortunately, the Gnucash --> QIF step treats almost all accounts as "Bank"
accounts, and the last step requires a $50 registration before i can get it
to process all my records.
Even using the trial version of the qif-->iif tool i don't think that i get
"reasonable" results after the import into Quickbooks. I can hand-edit the
initial QIF to name the account types correctly (since gnucash->qif
converter fails here), but even afterwards all the transactions look very
confusing.

Any recommendations or suggestions? has anybody encountered a similar
situation before?
I'd rather not futz with outputs of either stages too much, or hand-enter
all the data into quickbooks.

Does anybody even know what format the data files need to be in order for
both sides of double-entry transaction to show up in QuickBooks correctly?

Thanks!

toli
-- 
View this message in context: http://www.nabble.com/What%27s-the-easiest-way-to-export-Gnucash-to-QuickBooks--tf3024711.html#a8402761
Sent from the GnuCash - User mailing list archive at Nabble.com.



More information about the gnucash-user mailing list