Bureaucrats, confirmed, Administrators
4,558
edits
Changes
Jump to navigation
Jump to search
adds importing Customer data
yelp ghelp:gnucash-guide
</source>
=== Importing Customers ===
QuickBooks will only export "lists" to IntuitFinanacialFormat (IFF) files. From QuickBooks, in the menu, open File -> Utilities -> Export -> Lists to IFF Files. Select only Customers and save. Repeat, selecting only Vendors and save to a different file.
GnuCash will import a variety of formats, but not IFF directly. GnuCash wants CSV data for importing Customers and Vendors. But IFF files are essentially proprietary CSV files. So, using Kate or any text editor, just discard the first few meaningless lines of the file(s) saved earlier until you only have headers and data left. Save and rename that as a .csv file, and open with LibreOffice. Then you can rearrange the file in LibreOffice calc to match the header requirements of GnuCash.
The [http://www.gnucash.org/docs/v2.6/C/gnucash-guide/import-customers-vendors.html Importing Customers and Vendors] page in the GnuCash help gives you the column headers you need.
Import your data using the 'File'->'import'->'Import Customers and Vendors' menu option.
Strangely, I couldn't get it to import without the header line, but it ends up importing the header line as a (meaningless) record. You can only make that record 'inactive'.
=== Importing Vendors ===
Do the same for Vendors.
== Double entry Accounting basics ==
