Joe, The IIF format is a TSV (tab separated format see https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US ). You should be able to import them with the gnucash CSV importer which has provision for changing the separator used from a "," to a tab or any other character.
The CSV importer has a number of headers which define the data in GnuCash. Setting up the importer will require identifying the appropriate columns in the IIF file to which you assign the headers and/or rearranging the IIF file into a format more suitable for CSV import in GnuCash. The easiest way to understand the format GnuCash imports is to manually setup transactions of the type you wish to import in gnuCash then export them in CSV format and examine the exported file ina text editor See https://code.gnucash.org/docs/C/gnucash-manual/trans-import.html for details on the importer. You may also find additional information in this thread in the mailing list archives https://lists.gnucash.org/pipermail/gnucash-user/2008-March/024282.html It may pay to work with a dummy set of books in Gnucash and practise with the sample files in the IIF import kit in the reference above before importing data into your current books. You may also find this article helpful https://lwn.net/Articles/833616/ as it has some Python scripts. This seems to require a version of GnuCash compiled with the Python bindings. David Cousens On Thu, 2024-05-23 at 15:03 -0400, Joe Padavic wrote: > I hadn't imported any Quickbook file to GNUCASH, but the "Welcome to > GNUCASH" (splash page) wasn't showing up so I didn't know when to go > to > import the files. I eventually uninstalled the app and deleted the > registry > entry and the Welcome page is being displayed. > [image: image.png] > > My intentions are to convert personal checking/credit card accounts > from > Quicken and business data from Quickbooks. Having all transactions > make > Year End Tax Reporting for the business easier. Any comparisons from > previous to current year would be helpful. This would hold true for > budgeting purposes for personal accounts, also. > > So the question remains - can I import the IIF files from Quickbooks > and > what files can be imported from Quicken? > The first time I import my bank transactions, both business and > personal, > what date would these transactions start with? > > > On Thu, May 23, 2024 at 1:52 PM R Losey <rlo...@gmail.com> wrote: > > > > > > > On Thu, May 23, 2024 at 11:45 AM Joe Padavic <jpada...@gmail.com> > > wrote: > > > > > I have a few questions: > > > > > > Is there a way to reset the splash page? > > > I have Quickbook 2021 Pro. > > > There aren't any QIF files, but I can create IIF files. Can these > > > be used > > > for importing into GNUCASH? > > > If so, should I create individual IIF files for each type of file > > > to > > > import > > > or can I select all files and create 1 IIF file? > > > How do I import existing bank transactions (checking, Credit > > > Card) from QB > > > 2021? > > > When I'm ready to import transactions from my back, where will > > > the > > > activity start? > > > > > > > Welcome! (also, don't forget to do reply-all, not just reply) > > > > I'm not sure what you mean by "reset the splash page"? Do you want > > to > > show up again? Do you want to turn it off? Do you want to edit it? > > I've > > just left the splash page. If it can be turned off, there is > > probably a > > button to disable or enable it; you can have fun with the settings. > > > > Regarding importing, consider if you need to do any importing. I > > changed > > from Quicken to Gnucash by ceasing to use Quicken and starting to > > use > > Gnucash. I figured that I could always run Quicken if I really > > needed to > > look something up, and I didn't (that's been some years ago). > > However, if > > you have stocks or mutual funds and you need to track gains/losses, > > you may > > need to import at least that data. I only had a few such items, so > > I merely > > hand-entered the transactions. > > > > > > _________________________________ > > Richard Losey > > rlo...@gmail.com > > Micah 6:8 > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
