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

[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

Quoting toli <toli at marketcetera.com>:

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



-- 
       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
       warlord at MIT.EDU                        PGP key available