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