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