Difference between revisions of "Published tools"

From GnuCash
Jump to: navigation, search
(→‎Tools)
(Added UK HMRC filing tools which I have published.)
 
(17 intermediate revisions by 11 users not shown)
Line 1: Line 1:
 
Several users published their tools to work with GnuCash. Here is a reference list:
 
Several users published their tools to work with GnuCash. Here is a reference list:
−
= Disclaimer =
+
== Disclaimer ==
 
*The GnuCash team is in no way responsible for the tools linked here.
 
*The GnuCash team is in no way responsible for the tools linked here.
−
*In particular the access to your Gnucash database should only take place by the ''GnuCash Engine'' in the library '''libgncmod-engine.so'''. The interface is described [http://svn.gnucash.org/docs/HEAD/group__Engine.html here in the developer documentation].
+
*In particular the access to your Gnucash database should only take place by the ''GnuCash Engine'' in the library '''libgncmod-engine.so'''. The interface is described [https://code.gnucash.org/docs/MASTER/group__Engine.html here in the developer documentation].
 
Ask the publisher, if they use it or if your data are endangered.
 
Ask the publisher, if they use it or if your data are endangered.
  
−
= Tools =
+
== Tools ==
 +
;Command line interfaces: [[Ledger-CLI]]
 +
;mixed:
 
* Different [http://sourceforge.net/search/?q=gnucash SourceForge] projects in conjunction to GnuCash.
 
* Different [http://sourceforge.net/search/?q=gnucash SourceForge] projects in conjunction to GnuCash.
 +
* Different [https://github.com/search?utf8=%E2%9C%93&q=gnucash&type= GitHub] projects in conjunction to GnuCash.
  
 
* [http://bokeep.org/ Bo-Keep] a Desktop application, which uses GnuCash as backend by the Python interface.  
 
* [http://bokeep.org/ Bo-Keep] a Desktop application, which uses GnuCash as backend by the Python interface.  
 
* Email with [https://lists.gnucash.org/pipermail/gnucash-de/2010-March/007310.html csv2qif.py - csv to qif converter] by Nils Andresen.
 
* Email with [https://lists.gnucash.org/pipermail/gnucash-de/2010-March/007310.html csv2qif.py - csv to qif converter] by Nils Andresen.
−
 
 
* [http://gnucashtoqif.sourceforge.net gnucashtoqif] Java Export to QIF files by [http://slawrance.users.sourceforge.net/ Steven Lawrance]
 
* [http://gnucashtoqif.sourceforge.net gnucashtoqif] Java Export to QIF files by [http://slawrance.users.sourceforge.net/ Steven Lawrance]
−
 
 
* [http://apps.sourceforge.net/mediawiki/jgnucashlib/index.php?title=Main_Page jgnucashlib] Java access on GnuCash XML files by M. Wolschon
 
* [http://apps.sourceforge.net/mediawiki/jgnucashlib/index.php?title=Main_Page jgnucashlib] Java access on GnuCash XML files by M. Wolschon
 
: [https://lists.gnucash.org/pipermail/gnucash-devel/2005-October/014163.html Comment by C. Stimming] about it.
 
: [https://lists.gnucash.org/pipermail/gnucash-devel/2005-October/014163.html Comment by C. Stimming] about it.
 
* [http://jportfolioview.berlios.de jPortfolioView] -  [https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025521.html Announcement]
 
* [http://jportfolioview.berlios.de jPortfolioView] -  [https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025521.html Announcement]
 
* [http://eggert.org/software Lars Eggert] offers e.g. Lufthansa Miles&More-Import, updated F::Q-Modul cominvest.pm.
 
* [http://eggert.org/software Lars Eggert] offers e.g. Lufthansa Miles&More-Import, updated F::Q-Modul cominvest.pm.
−
* [https://github.com/codinguser/gnucash-android Gnucash Mobile for Android] is companion application for desktop Gnucash designed for the Android operating system. It allows you to record transactions on-the-go and export them in the OFX format and later import the data into Gnucash for the desktop.
 
 
* [[Bayes]] A PERL script to prune the import map of Bayes to get rid of obsolete or unwanted accounts and to remove insignificant entries.
 
* [[Bayes]] A PERL script to prune the import map of Bayes to get rid of obsolete or unwanted accounts and to remove insignificant entries.
 +
* [https://github.com/goodvibes2/BackupGnuCashWin/blob/master/src/backupgnucash/classes/org/openjfx/README.md BackupGnuCash] - Easily create offsite encrypted backups of GnuCash data files by Chris Good. Java, GNU/Linux and Windows.
 +
* [https://github.com/goodvibes2/IngAusOfxFixLinux/blob/master/README.md IngAusOfxFix] - Fix problems with OFX files from ING before importing into GnuCash by Chris Good. Java, GNU/Linux and Windows.
 +
* [http://bramblesoft.com/gnucashreporting.html GnuCash-Reporting] - Report charts for your GnuCash data. Simple question based UI. Reads from SQL. Java, JavaFX, Linux and Windows.
  
−
Export invoices:
+
;Spreadsheet to GnuCash (XLSX, CSV to QIF) tools:
 +
* [https://github.com/OneClickToQif/OneClickToQif OneClickToQif] - a set of templates and macros, which are used to export data from your spreadsheets to QIF format, as used by GnuCash. You can use the templates as provided, or adapt your own spreadsheet, so your data is automatically exported to QIF with a single click
 +
* [http://gnucash.1415818.n4.nabble.com/Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680333.html XLSM2QIF] [http://gnucash.1415818.n4.nabble.com/Re-XLSM2QIF-Import-Export-64-bit-Excel-QIF-XML-GnuCash-td4680402.html XLSM2QIF-Link2] is a application for make conversions between 64-bit Excel spreadsheets and Quicken QIF data and GnuCash Android QIF data and GnuCash Desktop QIF and XML data.
 +
* [http://llg.cubic.org/csv2iif/ csv2iif suite], offers perl programs to download PayPal business account transactions via the PayPal API and convert the transactions into IIF, OFX or QIF files. For GnuCash you can use the paypal2qif.pl program from their software suite.
  
 +
;Python based (As of 2015 our MacOSX and Windows builds are without Python):
 +
* [http://piecash.readthedocs.org/en/latest/doc/doc.html PieCash] a simple and pythonic interface to GnuCash files stored in SQL
 +
* [https://github.com/niknow/BankCSVtoQif BankCSVtoQif] converts csv from banks to qif and automatically replaces descriptions and accounts of transactions according to predefined customizable rules along the way.
 +
* [https://gitlab.com/m8ram/vikingcsv2qif vikingcsv2qif] converts csv from [https://mobilevikings.be/en/ Mobile Vikings] to qif with customizable accounts and category
 +
* [https://github.com/cybermaggedon/gnucash-uk-vat gnucash-uk-vat] files a UK HMRC VAT return from GnuCash accounts.
 +
* [https://github.com/cybermaggedon/gnucash-ixbrl gnucash-ixbrl] creates an [https://www.xbrl.org/the-standard/what/ixbrl/ IXBRL] report with information derived from GnuCash  accounts (tested only with UK XBRL taxonomies).
 +
* [https://github.com/cybermaggedon/gnucash-uk-corptax gnucash-uk-corptax] files the output of <code>gnucash-ixbrl</code> with the UK HMRC corporation tax API.
 +
 +
;Export invoices:
 
* [http://stefans.datenbruch.de/gnucash/gc2latex.shtml gc2latex] - Gnucash invoices with LaTeX and Perl
 
* [http://stefans.datenbruch.de/gnucash/gc2latex.shtml gc2latex] - Gnucash invoices with LaTeX and Perl
 +
* [https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025615.html Announcement GIP: GnuCash Invoice Printer]
 +
* https://bitbucket.org/smoerz/gcinvoice can create invoices from arbitrary user provided templates, not only for LaTeX.
  
−
* [https://lists.gnucash.org/pipermail/gnucash-user/2008-June/025615.html Announcement GIP: GnuCash Invoice Printer]
+
;Modified Invoice forms:
 +
* [http://web.archive.org/web/http://clusterconsult.thtesche.com/download/gnucash_2_2_7_invoice_de.tgz von thtesche (cluster:Systems) für Version 2.2.7]
 +
 
 +
=== Mobile Apps ===
 +
 
 +
There is a separate page for [[GnuCash and Mobile Devices]]
  
 +
== Fonts ==
 +
Some translations use scripts which are missing in most popular fonts. So here is a list:
 +
;mni: Meithei (Manipuri) can be written either in '''Meitei Mayek''' or Bengali. While Bengali is in many fonts, Meitei Mayek has been forbiddden over a century and is very rare:
 +
: http://tabish.freeshell.org/eeyek/download.html GPL2+
 +
: http://e-pao.net/epPageExtractor.asp?src=MeiteiMayek.meetei_mayek_keys.html.. Page with download link and mapping
  
−
Modified Invoice forms:
 
  
−
* [http://web.archive.org/web/http://clusterconsult.thtesche.com/download/gnucash_2_2_7_invoice_de.tgz von thtesche (cluster:Systems) für Version 2.2.7]
+
[[category: Usage]] [[category: Tools]]

Latest revision as of 11:29, 17 May 2021

Several users published their tools to work with GnuCash. Here is a reference list:

Disclaimer

  • The GnuCash team is in no way responsible for the tools linked here.
  • In particular the access to your Gnucash database should only take place by the GnuCash Engine in the library libgncmod-engine.so. The interface is described here in the developer documentation.

Ask the publisher, if they use it or if your data are endangered.

Tools

Command line interfaces
Ledger-CLI
mixed
  • Different SourceForge projects in conjunction to GnuCash.
  • Different GitHub projects in conjunction to GnuCash.
Comment by C. Stimming about it.
  • jPortfolioView - Announcement
  • Lars Eggert offers e.g. Lufthansa Miles&More-Import, updated F::Q-Modul cominvest.pm.
  • Bayes A PERL script to prune the import map of Bayes to get rid of obsolete or unwanted accounts and to remove insignificant entries.
  • BackupGnuCash - Easily create offsite encrypted backups of GnuCash data files by Chris Good. Java, GNU/Linux and Windows.
  • IngAusOfxFix - Fix problems with OFX files from ING before importing into GnuCash by Chris Good. Java, GNU/Linux and Windows.
  • GnuCash-Reporting - Report charts for your GnuCash data. Simple question based UI. Reads from SQL. Java, JavaFX, Linux and Windows.
Spreadsheet to GnuCash (XLSX, CSV to QIF) tools
  • OneClickToQif - a set of templates and macros, which are used to export data from your spreadsheets to QIF format, as used by GnuCash. You can use the templates as provided, or adapt your own spreadsheet, so your data is automatically exported to QIF with a single click
  • XLSM2QIF XLSM2QIF-Link2 is a application for make conversions between 64-bit Excel spreadsheets and Quicken QIF data and GnuCash Android QIF data and GnuCash Desktop QIF and XML data.
  • csv2iif suite, offers perl programs to download PayPal business account transactions via the PayPal API and convert the transactions into IIF, OFX or QIF files. For GnuCash you can use the paypal2qif.pl program from their software suite.
Python based (As of 2015 our MacOSX and Windows builds are without Python)
  • PieCash a simple and pythonic interface to GnuCash files stored in SQL
  • BankCSVtoQif converts csv from banks to qif and automatically replaces descriptions and accounts of transactions according to predefined customizable rules along the way.
  • vikingcsv2qif converts csv from Mobile Vikings to qif with customizable accounts and category
  • gnucash-uk-vat files a UK HMRC VAT return from GnuCash accounts.
  • gnucash-ixbrl creates an IXBRL report with information derived from GnuCash accounts (tested only with UK XBRL taxonomies).
  • gnucash-uk-corptax files the output of gnucash-ixbrl with the UK HMRC corporation tax API.
Export invoices
Modified Invoice forms

Mobile Apps

There is a separate page for GnuCash and Mobile Devices

Fonts

Some translations use scripts which are missing in most popular fonts. So here is a list:

mni
Meithei (Manipuri) can be written either in Meitei Mayek or Bengali. While Bengali is in many fonts, Meitei Mayek has been forbiddden over a century and is very rare:
http://tabish.freeshell.org/eeyek/download.html GPL2+
http://e-pao.net/epPageExtractor.asp?src=MeiteiMayek.meetei_mayek_keys.html.. Page with download link and mapping
Retrieved from "https://code.gnucash.org/wiki/index.php?title=Published_tools&oldid=19396"