Bureaucrats, confirmed, Administrators
4,558
edits
Changes
adds importing Customer data
== Getting Started ==
install gnucash and gnucash-docs
=== Fix the Help ===
Due to [https://bugzilla.gnome.org/show_bug.cgi?id=661705 a bug], the help does not open properly, even in GnuCash 2.6.3 (on Ubuntu 12.04 LTS)
<source lang="bash">
sudo su -
cd /usr/share/gnome/help
ln -s gnucash gnucash-help
ln -s gnucash gnucash-guide
exit
yelp ghelp:gnucash-help
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 ==
[[wp:Debits and credits]]