GnuCash is a powerful financial-accounting app that is designed to help you with all manner of financial related tasks. The app can be used to keep track of all your financial operations from your bank accounts, stocks and other income and expenses.
GnuCash supports databases including PostgreSQL, SQLite3 and MySQL (backend XML). Note, the default storage is a gzipped XML file and that using a SQL database instead is optional. Note, the default storage is a gzipped XML file and that using a SQL database instead is optional. In addition the GnuCash for Mac app bundle supports only SQLite3 out-of-the-box; users of MySQL or Postgresql will have to build and install a dbd driver.
Key Features include:
- Double entry accounting.
- Online banking support.
- Multiple currency support.
- Checkbook style registry.
- Reporting tools.
- Mutual fund and stock portfolios.
- Income and expense account management.
- HBCI support.
- General accounting ledgers.
- Vendor and customer tracking.
- OFX and QIF support.
- Statement reconciliations.
- Bill payments and invoicing.
GnuCash has been designed to be easy to use, flexible and powerful. It feels quick and intuitive to use and has a solid base around professional accounting principles, therefore it is able to provide balanced books and accurate reports.
Overall, GnuCash is well presented and contains a diverse array of accounting features such as multiple currency support, double entry accounting and invoicing. On the downside, the integrations with tax software comes up short, however it can support some online banking services.
Long currency names untranslated.
Notes not imported when using update and reconcile in import transactions from CSV.
VERY large queries (over 11000 fields in IN clause) slow down GnuCash.
git-master - Save Corrupts Data File / Not Open Data File.
Startup takes several minutes.
Transaction matcher window blank when importing QFX.
Dates default to 01/01/1970.
Fails to find environment file at startup when installation prefix is '/opt'.
3.0 does not open previously saved sqlite3 files properly - corrupted business data.
Both print icons export to pdf.
Ellipsize on short tab labels.
Double click does not work on saved reports.
Display Alphavantage key in full.
3.0 Crashes on loading when opening 2.6.19 file.
Crash on startup using Technicolor Style sheet in report.
GnuCash crashes when searching for a newly created bill.
GnuCash 2.6.20-1 (Fedora Linux package) is unable to open MariaDB.
Enable subtotal-only if either sortkeys are dates.
src/optional/python-bindings missing several files.
Some dates reset to 01/01/1970.
CSV import crashes if a transaction's 'Account' field is empty and no default Account set.
Scrollbar floats and covers toggle buttons.
Unable to enter account codes in business sheets.
CSV import does not distinguish between deposit and withdrawal.
Australian (GMT+10) OFX transactions imported have previous days date.
Reads and saves Gnucash 2.6.19 XML file, then can't reread it, due to bad date in old file.
Hard to see figures in the budget window.
All Dates in Price Database Off-By-One After 3.0 Upgrade.
On Windows there is a blank tip of the day.
Budget window scrolls edited cell out of site.
Fixes and improvemts:
On Windows the tooltip for saved reports was incorrect.
When the mouse was placed over a saved report description on Windows an empty tooltip was displayed. Setup the query tooltip callback so it does not display a tooltip for description column.
Fix crash when loading sql book with posted transactions.
Add ability to recognize and use a pre-compiled libgmock.so.
html-font: add default font family.
Windows ships with GTK2 in which the default font styles are named "Sans" "Sans Bold" "Sans Normal" etc. There is no "Sans" font in Windows; I vote to add a default "Sans-Serif" font-family which is valid CSS. This ensures exported reports are shown as intended.
Several improvements to the Transaction and GST reports.
csv-impport - Allow empty amount fields.
Treat empty amount fields as 0. This is necessary for example in the case the csv import file has both a deposit and a withdrawal column.
Remove the set transient parent setting for Reconcile window.
The Reconcile option is already a window so it is not necessary to set this value which allows the jump to transaction to work properly.
Date Format dialog flashes up when file/properties used.
When you select the File/Properties dialog, in the construction of that a 'Date Format' dialog flashes up while the date component is moved to the properties dialog. Can mainly be seen on Windows so remove the visible setting in glade file.
Prevent throw in gnc-pricedb.
If a price lookup is given an invalid time64/timespec (i.e. INT64_MAX) then just return NULL instead of trying to find the nearest price.
Set GNC_VCS at build time instead of when making the tarball.
Because the tarball is always made from a VCS repo.
If there are no prices in the db, critical errors are flagged.
When dialog transfer is used between two commodities and there are no prices in the db a critical error is logged. Test for price object being NULL before retrieving the price for the error message.