Converting GnuCash to Quickbooks

Mike or Penny Novack stepbystepfarm at mtdata.com
Fri Jan 16 14:07:19 EST 2015


On 1/16/2015 7:52 AM, Bob Brush wrote:
> Tom, the amount of work required to do this isn't reasonable considering why it is needed, however I know that isn't something any one would want to hear, I especially like to do things that are "impossible" :)  These guys are very good, they helped us build a custom reporting solution, and understand quick books inside and out.  There may be others, I think there's tens of thousands..
If it would be any help to amateur programmers who would like to try 
this on their own, here what might be a useful hint (I had LOTS of 
experience doing data conversion in my day; learned how to look for 
"tricks").

You DO have to know all about how QuickBooks can import data, have to 
know how Quickbooks would need a file of transactions formatted. 
Assuming these transactions were in the form of "journal entries". I 
can't help you with that.

You would then need to be able to write something that given a 
"standard" journal of transactions, could identify the pieces (for each 
journal entry, what's the date,  what are the accounts being debited and 
for how much, what the accounts being credited and for how much, and 
what's the description. In other words, write an "editor" that could 
parse a journal to separate journal entries and take these entries 
apart. Read a (machine readable) journal and produce the output file 
that could be imported to QuickBooks.

But you wouldn't need to learn anything about the internals of how 
gnucash stores data. Not if you could get gnucash to produce the journal 
for you (and you can; produce the report and export it as a file). 
That's the sort of "trick" you look for when given a problem like this.

What I am saying here is that you need QuickBooks help, not gnucash help.

Michael




More information about the gnucash-user mailing list