{"id":633,"date":"2011-09-05T21:38:45","date_gmt":"2011-09-05T21:38:45","guid":{"rendered":"http:\/\/www.gssezisoft.com\/main\/?p=633"},"modified":"2013-06-25T03:38:50","modified_gmt":"2013-06-25T03:38:50","slug":"exporting-gnucash-data","status":"publish","type":"post","link":"http:\/\/www.gssezisoft.com\/main\/2011\/09\/exporting-gnucash-data\/","title":{"rendered":"Exporting GnuCash Data"},"content":{"rendered":"

It is easy to get information into GnuCash, but getting it out is a different matter. <\/p>\n

Background<\/h1>\n

\"\"<\/a>The version of GnuCash that I’m using at the moment (2.4.2) doesn’t have an option to export the data.<\/p>\n

It makes sense – a lot of programs these days are happy to import data from other programs they are replacing; but are reluctant to provide information for anything replacing it. Still, it’s not really a very “Open Source” attitude.<\/p>\n

It is really just a minor annoyance because GnuCash is Open Source and they’ve done a lot of good things which does make exporting possible. One example is the use of XML for the data so, * in theory *, you can get the information into anything else in any format imaginable. In practice, it is a little harder.<\/p>\n

The Easiest Way<\/h1>\n

It really was very very simple to Export. You just pick Reports, Transaction Report, Select All Accounts, Sort by Date, include the things you need, and don’t do any totalling.
\nYou got a nice report listing everything.<\/p>\n

Then you click the top left and drag to the bottom right of the report, copy, and paste wherever you want (Excel worked great).<\/p>\n

The only slight inconvenience was the report was fairly long and you had to drag for some time (Ctrl-A = Select All, would have been nice).<\/p>\n

Unfortunately, when I upgraded to 2.4.2 I could no longer select All Accounts. Maybe it is a feature. Maybe it’s a bug that is being fixed.<\/p>\n

The Workaround<\/h1>\n

You can still make it work if you select Assets and Liabilities, export that, select Income and Expenses, and export those.
\nIt is a bit harder, and you do end up with duplicates that aren’t totally obvious, but it does work and it is easier than any other option I’ve tried.<\/p>\n

The report settings I use are:
\n\"\"<\/a>\"\"<\/a><\/p>\n

 <\/div>\n

To QIF<\/h1>\n

There is a great little tool that will take a GnuCash data file and create a QIF file from it. This is neat because we usually get data in from a QIF file. Going back to QIF makes it a symmetric process – you can get back what went in.<\/p>\n

The other neat thing is the author wrote it in Java so it should run under any Operating System.<\/p>\n

You do need to un-ZIP the gnucash data file but that is easily done. On Windows I use 7Zip but you could just as easily use WinZip or Windows’ built in tool. With earlier versions of GnuCash you had to fix the XML header but that has already been fixed in 2.4.2<\/p>\n

The program is GnuCashToQIF<\/a>.<\/p>\n

It simply asks for the XML file to convert and where to put the QIF.<\/p>\n

You can open the QIF file in Notepad, copy the content, and paste it into Sheet1 of the following Excel spreadsheet. It has a macro which will read the raw QIF information and make a transaction list in Sheet2. Use Alt-F8 QIFtoSheet to run the macro.
\nNOTE: Excel loses “$” at the start of split lines in the QIF so this doesn’t work well if you have a lot of splits.
\nAlso, the Java program outputs unix style newlines which looks wierd (no line breaks) in many Windows programs. However, Excel will happily process the information.<\/p>\n

The spreadsheet is QIFtoExcel-Example<\/a><\/p>\n

Easy Ways for Lucky People<\/h1>\n

If you have installed GnuCash with a MySQL database there is probably an SQL select statement that will export the data in one step.<\/p>\n","protected":false},"excerpt":{"rendered":"

It is easy to get information into GnuCash, but getting it out is a different matter.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[41],"tags":[],"_links":{"self":[{"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/posts\/633"}],"collection":[{"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/comments?post=633"}],"version-history":[{"count":0,"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/posts\/633\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/media?parent=633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/categories?post=633"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gssezisoft.com\/main\/wp-json\/wp\/v2\/tags?post=633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}