[GNC] Newbie Questions

[David Cousens]

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 <rlosey at gmail.com> wrote:
> 
> > 
> > 
> > On Thu, May 23, 2024 at 11:45 AM Joe Padavic <jpadavic at 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
> > rlosey at gmail.com
> > Micah 6:8
> > 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.