How to move from Quickbooks to Gnucash?
Dean Gibson
gnucash at ultimeth.com
Sun Jun 17 11:08:07 EDT 2012
On 2012-06-17 04:44, flywire wrote:
> This whole QBW / IIF format thing is a red herring. IIF can be
> considered as CSV for all intensive purposes. Users could more easily
> move from Quickbooks to gnucash with: 1. Some sort of guideline on the
> process (the FAQ is pathetic). 2. An explanation of the best way of
> getting transaction information out of Quickbooks and loading it into
> gnucash. 3. A CSV import process for the Chart Of Accounts (>> RFE <<)
> would be nice but it is probably not a big issue if the transaction
> import works well. So 1&2 just come down to a bit of guidance from
> someone that has done it.
I don't know if this will help you (post by me here on 2012-02-18):
On 2012-02-18 14:16, Dean Gibson wrote:
> Oh, no! Not another "QuickBooks to GnuCash" thread !!!
>
> Well, after trying the steps documented at
> http://en.wikipedia.org/wiki/Quicken_Interchange_Format#Export_Hacks_for_QuickBooks:_exporting_to_QIF
> and obtaining http://xl2qif.chez-alice.fr/xl2qif_en.php , I found the
> latter wasn't really suitable for output from QuickBooks, so I wrote
> my own converter using Linux's AWK program.
>
> The Linux script is here: http://www.ultimeth.com/download/Tsv2Qif.sh
> -- it's about 50 lines of AWK commands and about 40 lines of
> "how-to". The "how-to" is displayed if you invoke the script without
> any parameters.
>
> The only hard work is changing the account type for each account in
> GnuCash after the import. Since each fixed asset was a different QB
> account, the reorganization took a while, but was otherwise trivial.
>
> Suggestions / comments / improvements welcome !!!
>
> -- Dean
More information about the gnucash-user
mailing list