User:Jeremy Butler

From GnuCash
Jump to: navigation, search

I began using GnuCash on 3 April 2010, having gotten fed up with Micro$oft Money's approach to financial software.

Things for me to remember about GnuCash

Export to Excel

One way to easily export GnuCash data to Excel is to find a report (such as the General Ledger) that you can adjust to a satisfactory output, and export the report to an HTML file. Then open the HTML file from Microsoft Excel. (Using File>Open from within Excel, selecting "html" as the file type.) The Excel program will load the report into a spreadsheet, allowing filtering and other spreadsheet functions.

File Extension?

GnuCash does not enforce any particular file naming convention or extension. However, the following extensions are described in the "shared-mime-info" package used by almost every distro and desktop environment to associate applications with files. Naming your datafile with one of these extensions will allow the gnucash to be opened when a file is seen and activated in a file browser.
  • .xac (short for "X-Accountant", the predecessor of GnuCash), still in use for your backup files,
  • .gnc (the "internal" three-letter-abbreviation of GnuCash)
  • .gnucash (recommended and the only one that works on Windows)