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

[toli]

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.

_______________________________________________
gnucash-user mailing list
gnucash-***@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.

[Derek Atkins]

What I do is perform an Income Statement (P&L), Balance Sheet, and
Full Transaction Report, then I email the Txn Report to my accountant
in an exported HTML Table form, and send them the printend IS and BS
Reports. That's worked for me for years with my accountant.

-derek

Post by toli
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.
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
--
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.
_______________________________________________
gnucash-user mailing list
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.

--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
***@MIT.EDU PGP key available

_______________________________________________
gnucash-user mailing list
gnucash-***@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.

[Ken Gordon]

What I do (using 1.8 still until I get the time figure out how to
install 2.x on OS X) is to export a report (a Transactions report is
really all that's needed, choose all accounts for the whole year),
then open the resulting html file in Word (you could use something
else), convert the table to comma separated values and save as text,
then import the resulting .txt file into Excel using Data>Get
External Data>Text File. You could do the same with any report (P&L
or some customized report). My accountant has always been able to
work with the Excel file. If yours can't, and insists on Quickbooks,
then get him or her to buy you a copy of Quickbooks :) .

-----
Ken Gordon
[phone]

Post by toli
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.
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.
_______________________________________________
gnucash-user mailing list
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-***@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.