[GNC] Exporting from QuickBooks / Importing to GnuCash

[Chris Skudder]

>From Intuit:
"Intuit Interchange Format (.IIF) files are ASCII text, TSV 
(Tab-Separated Value) files that QuickBooks Desktop uses to import or 
export lists or transactions"

source: 
https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577

So this could very well work, but I can't test it:
Export from QB as IIF.
Open IIF in a spreadsheet
Save as a COMMA separated value file- that is, CSV ...
    ... instead of Intuit's TAB separated IIF file
Then in GnuCash: File> Import> Import Txn's from CSV

Hope it helps.

Chris

FWIW ... IMHO ... Intuit seems to have a track record of aggressively, 
even unethically, hiding technical pathways, or anything, which might 
help people do something which costs Intuit revenue. As contrasted with 
building a product which offers real value for money. IMHO.


------------------------------------------------------------------------

On 3/30/23 12:00, gnucash-user-request at gnucash.org wrote:
> Message: 4
> Date: Thu, 30 Mar 2023 10:47:48 -0400
> From: Richard Lindgren<rlindgren74 at gmail.com>
> To: "gnucash-user at gnucash org"<gnucash-user at gnucash.org>
> Subject: [GNC] Exporting from QuickBooks / Importing to GnuCash
> Message-ID:
> 	<CAD8ROJa_mSd4-Ft2AJGKUi7PX=fSEGZJT+MKzG0_Bzwg4GTdiw at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
> I have been in contact with QuickBooks and they tell me that they only
> export IIF formatted files. As I look in GnuCash, I do not find where it
> will import the IIF files. Is there something that I am doing wrong or is
> there a work around to import my files from QuickBooks?
>
> I really need your help here.
>
> Please advise me as to a good plan of attack?
>
> Thank you very much for help in this matter, and look forward to hearing
> from you.
>
> Richard Lindgren