Grisbi Graph

Grisbi Graph is a graphing tool writen to visualize finances kept in Grisbi.
I am using Grisbi to keep track of my personal finances since 2005. I like the program very much, but I was always disappointed not being able to visualize my expenses; with Grisbi Graph you can! The program is written in Java to make it available for any platform. Just open your Grisbi data file and see for yourself!

Screenshots


Pie chart	Bar chart	Timeline

How-to

At the moment the program is very simple and thus the how-to also. After starting the application, first click the "open grisbi file" button. Point the program to the location of your grisbi database file. Grisbi Graph will only read this file, no alterations are made.

UPDATE: Some people reported having trouble starting the application. Normally I just double-click the program and let my OS take care of the rest. I discovered that with Windows XP it runs straight away, with SUSE I had so set the 'is executable' bit. You can always start the program from a command line, just tell java to execute a jar-file. You can do this by entering: 'java -jar grisbiGraph.jar'.

After reading the database file, your first account is selected from the pulldown menu. All expense categories are listed and selected on the left and a graph is automatically plotted. The first graph always represents the distribution of all expenses (pie chart). By selecting different accounts, expense categories, dates and graph types you can easily visualize the data you want. To select more than one expense categorie use ctrl and/or shift when clicking them. You can also use the "select all" button to select all categories.

Note to Internet Explorer users: when you download the file it is somehow renamed to a '.zip' file. Rename the file (hit F2) to a '.jar' file again, should do the trick. Other browsers don't show this 'feature'.

Todo

Grisbi Graph is a very simple tool to graph your expenses. Depending on whether graphing of expenses will be available in Grisbi, this tool can be further developed. Naturally the first, implementing in Grisbi, has my vote!
Some things I have in mind for this program at the moment:

Combining income and expense categories
Have an overview of all accounts
Different types of graphs
Print functionality
Evolution over time [first attempt is online, thanks to Julien Furgerot]
Select multiple accounts and aggregate values [Julien from Paris, first alpha attempt is online, thanks to Christophe Desirant]
Generate categorie-to-colors map only once, don't update colors [Robin from Feucherolles]

License

Grisbi Graph is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

Update

I am in the middle of finishing my PhD-thesis, so regrettably I don't have any spare time for further programming and development at the moment. Hopefully in the near future (somewhere after September first :) )

v0.05alpha - Now multiple accounts can be selected; use CTRL to select multiple. Thanks and credits go to Christophe Desirant for implementing this feature.
v0.04 - Added timeline graph. Thanks and credits go to Julien Furgerot for implementing this feature.
v0.03 - Added compliance mode. GrisbiGraph now also works with java 1.5 (specially for some Linux users).
v0.02 - Added command line argument: 'java -jar grisbiGraph.jar myaccountfile.gsb' should work.
v0.01 - Fixed comma instead of a dot to indicate decimal figures in some countries.
v0.00 - Initial release

Download

Download the latest version (v0.04) here.
Download an alpha version (v0.05alpha) here (Note: first read update above!)
You need to have java installed. If you haven't get it from here.

If you want to help further develop this program download the source code from here.
The source code of the v0.05alpha can be downloaded here.

Before you start coding please contact me, in order to prevent double work. Leave a message below or sent me a message.
Download the GNU GPL here.

Feedback

Please, leave a note or message below!

Hello, Bonjour,

I set up a subversion repository on http://svn.furgerot.fr/grisbigraph/trunk/. Guest can access it read-only. If you want to help, ask me for a write access on my gmail.com, user julien.furgerot

Sincerely, Cordialement,

Julien FURGEROT from Champs Sur Marne, France @ 11:00:14 on 28-07-2010

Hello, Bonjour,

[EN] Since there's still no graphs in Grisbi 6, i'm working on a totally new version of GrisbiGraph which will work with both v0.5.0 and v0.6.0 files and allow to display stats closest to reports in Grisbi. I should be able to do a first release in mid-september. More information coming next week.

[FR] Comme Grisbi 6 n'integre pas l'affichage en graphique comme ils l'avaient annoncé, je travaille sur une nouvelle version de GrisbiGraph qui pourra lire les fichiers au format 0.5.0 et 0.6.0, et permettra d'afficher des statistiques détaillées au plus près de ce qui existe dans les rapports Grisbi. Je devrais avoir une première version mi-septembre. Plus d'information la semaine prochaine.

Sincerely, Cordialement,
Julien Furgerot

Julien FURGEROT from Champs Sur Marne, France @ 09:57:28 on 28-07-2010

I just spend half a day on trying to rewrite the program in order for it to be able to work with Grisbi v6. Unfortunately, the xml file format really changed a lot and I think it would be better to completely rewrite the software. I don't have time for this now. Maybe the version of Mathieu from FRANCE works? I don't know whether the official Grisbi crew is looking for this functionality.
Sorry!

Wessel from The Netherlands @ 14:53:12 on 22-07-2010

EXISTE T-IL UNE VERSION POUR GRISBI v6,

Do you write a spécial prog for grisbi V6?

Lajoie J P from Ile De La Reunion @ 18:40:19 on 14-07-2010

Thank you very much for your piece of code!

Cedric from Toulon, France @ 14:59:43 on 13-05-2010

Would it be possible, when showing a Graph of a Categorie, that the result is split into the Sub-Categories?

Mark Johnson from Berlin Germany @ 13:02:58 on 09-07-2009

Error message:

/home/eric/bin/grisbiGraph.sh
Exception in thread "Basic L&F directory loader" Exception in thread "Basic L&F directory loader" Exception in thread "Basic L&F directory loader" Exception in thread "Basic L&F directory loader" java.lang.NullPointerException
at javax.swing.plaf.basic.BasicDirectoryModel$DirectoryLoadThread.run(libgcj.so.70)
java.lang.NullPointerException
at javax.swing.plaf.basic.BasicDirectoryModel$DirectoryLoadThread.run(libgcj.so.70)
java.lang.NullPointerException
at javax.swing.plaf.basic.BasicDirectoryModel$DirectoryLoadThread.run(libgcj.so.70)
java.lang.NullPointerException
at javax.swing.plaf.basic.BasicDirectoryModel$DirectoryLoadThread.run(libgcj.so.70)
Reading grisbi file /home/le_grillon/BUREAU/GESTION/COMPTABILITE
Exception during event dispatch:
java.lang.NullPointerException
at main.MainWindow.readGrisbiFile(MainWindow.java:126)
at main.MainWindow$1.actionPerformed(MainWindow.java:100)
at javax.swing.AbstractButton.fireActionPerformed(libgcj.so.70)
at javax.swing.AbstractButton$1.actionPerformed(libgcj.so.70)
at javax.swing.DefaultButtonModel.fireActionPerformed(libgcj.so.70)
at javax.swing.DefaultButtonModel.setPressed(libgcj.so.70)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(libgcj.so.70)
at java.awt.Component.processMouseEvent(libgcj.so.70)
at java.awt.Component.processEvent(libgcj.so.70)
at java.awt.Container.processEvent(libgcj.so.70)
at java.awt.Component.dispatchEventImpl(libgcj.so.70)
at java.awt.Container.dispatchEventImpl(libgcj.so.70)
at java.awt.Component.dispatchEvent(libgcj.so.70)
at java.awt.LightweightDispatcher.handleMouseEvent(libgcj.so.70)
at java.awt.LightweightDispatcher.dispatchEvent(libgcj.so.70)
at java.awt.Container.dispatchEventImpl(libgcj.so.70)
at java.awt.Window.dispatchEventImpl(libgcj.so.70)
at java.awt.Component.dispatchEvent(libgcj.so.70)
at java.awt.EventQueue.dispatchEvent(libgcj.so.70)
at java.awt.EventDispatchThread.run(libgcj.so.70)

Joseph Tux from Eric.valissant+grisbi@gmail.com @ 17:13:39 on 10-05-2009

Hello
i've made some corrections and evolution on your version. Please find it here:
http://mathieugravil.e3b.org/softs/java/grisbiGraphMGv6.0.jar

Mathieu from FRANCE @ 14:59:35 on 17-03-2009

If you have several account, your software takes date from and date to from the min and the max of the first account. So if your first account is an older one, you cannot see data from an other account which has operations with doesn't belong to date from and date to of the first account...

Mathieu from FRANCE @ 17:37:28 on 27-02-2009

Hi Wessel,

Found one issue with the multiple acounts selection. On one particular category I get correct figures when drawing account by account and when selecting all accounts, it gives me an aberrant figure (4 account, approx 5+100+50+10=3000 !).

If you want to investigate deeper, I can provide you the file for you to look at.

@+

Benoît 'Mutos' ROBIN

Benoît 'Mutos' ROBIN from Feucherolles, France @ 09:29:27 on 01-02-2009

Hi Wessel,

I downloaded the code, but couldn't get through it. I must say it's my first time in Java. But I saw the part where the graph is defined and it would seem the function used doesn't give the choice of colors. It seems it's the graphing API that defines its own palette on the fly.

@+

Benoît

Benoît 'Mutos' ROBIN from Feucherolles, France @ 18:33:48 on 22-11-2008

Hi Benoît 'Mutos' ROBIN,

I put the alpha code also in the download section. Happy coding.

Wessel

Wessel from The Netherlands @ 21:29:23 on 09-09-2008

Hi Wessel,

Got the code but of course it's stable. How could I get the alpha code ? Thanks in advance !

@+

Benoît 'Mutos' ROBIN

Benoît 'Mutos' ROBIN from Feucherolles, France @ 06:34:35 on 06-09-2008

Hi Wessel,

Thanks for your answer. I'll download the code and see if I can find something, it should make your work lighter ^-^

@+

Benoît 'Mutos' ROBIN

Benoît 'Mutos' ROBIN from Feucherolles, France @ 06:26:57 on 06-09-2008

Nice and easy ! Good work ! Please put in the how-to that Internet Explorer save the file in a .zip format that must be changed. It took me a while to find the solution in your feedback area. Good day.

Virginie from Belgium & France @ 19:43:28 on 01-09-2008

really great ! thanks !

Stephan from Belgium @ 17:34:31 on 27-08-2008

I have just installed vr 0.5.9 for windows. Looks like a great tool. I have imported OFX files from my bank. Is there any way to automatically associate the third party title with a category? Example, a transaction “CARD PMNT 11DEC TESCO UPT 4055”, the word “CARD” linked to a debit card, the phrase “Tesco UPT” linked to the category Car and sub category Fuel…. If not, is there a way of selecting multiple transactions to categorise together?

Lee from Great Britain @ 10:23:29 on 20-08-2008

As to your post about interest in an I Phone front end. The answer is yes!!! I have used Grisbi for years and bought splash money for the iphone and it is horrible on the phone and the desktop.

Dave from USA @ 01:03:37 on 14-08-2008

Benoît 'Mutos' ROBIN,

As the version says it is still in alpha state. I've not been able to verify all code. I hope to do so when I have the time, which at the moment I do not :(

I am also planning to try and make a grisbi front-end application for the iPhone. Would be nice to update your finances while on the road. But that is also something for the future. Any interest??

Wessel from The Netherlands @ 19:50:59 on 05-08-2008

Hi Wessel,

Many thanks for this app, it helps so much ! I like the Timeline feature and multiple acounts on 0.05. Previously I had to edit the Grisbi file to merge the accounts to get all-accounts graphs.

However, the multiple account seems to have a problem with my file. Each individual account seems to be OK, as seen by comparing Grisbi numbers with graph. But for instance today the multiple accounts graph displays 10500€ when it should display 4500€.

Is there a way to get this fixed ? Are there other people experiencing the same problem ? Do you have any clue to it ? Would it help if I send you my file to get it examined ?

Thanks in advance !

Benoît 'Mutos' ROBIN

Benoît 'Mutos' ROBIN from Feucherolles, France @ 16:19:55 on 27-07-2008

Caro, consegui instalar.... estava usando o Java 1.6. Troquei para 1.5 e consegui acessar. Grato.

Sebastião from Brasil @ 20:58:58 on 25-07-2008

Por favor, eu fiz o download, mas não consigo instalar. Uso o Windows XP.

Sebastião from Brasil @ 18:14:44 on 25-07-2008

thanks

Henri from France @ 19:58:41 on 23-07-2008

Merci

Atika BOUHADDOU from Maroc @ 09:09:34 on 26-06-2008

Thank you for the great tool.

Some categories cannot be recognized in the Graph. So just some of my amount will be displayed :)

Keep your great job, please!

Kyanh At O2 Dot Pl from Vietnam @ 17:14:35 on 17-06-2008

Do you have Java installed? What OS are you using? What exactly goes wrong?
Please be more specific!

Wessel from The Netherlands @ 09:18:12 on 06-06-2008

I downloader the GrisbiGraph but I can't start it Please help me

HdK from Hubert.dekeuwer@gmail.com @ 17:41:34 on 05-06-2008

I downloader the GrisbiGraph but I can't start it Please help me

PASCAL from FRANCE @ 09:00:14 on 24-05-2008

I've just uploaded a new aplha version: v0.05alpha.

Now multiple accounts can be selected, but only seems to work for timeline plots. So do not expect stable results. Thanks and credits go to Christophe Desirant for implementing this feature.

Wessel from The Netherlands @ 20:51:56 on 14-05-2008

GREAT !!!!!

Joleb from Lebanon @ 08:28:27 on 09-05-2008

It's a great visualization indeed, though I would suggest visualization not only for accounta but categories as well. eg. I select 2: "Car sale" (credit) and "Car buy" (debit) categories and then I could see how the business goes, whether I spent more then I earned. Like "Car sale" 60%, EUR 600 and "Car buy" 40% EUR 400 - I would donate for it EUR 10. Anyone else to add some bucks for development?

Brown from Czech Rep. @ 16:06:10 on 06-05-2008

Hi,

thanks for this nice complement to Grisbi. I would like to suggest the addition of a linear regression plot on the timeline graph, in order to able to predict the evolution of an account.

Thanks,

--
Gilles

Gilles B from France @ 21:03:44 on 06-04-2008

I've just uploaded a new version: v0.04.

In this version a timeline graph is added. Thanks and credits go to Julien Furgerot for implementing this feature.

Wessel from The Netherlands @ 20:17:42 on 05-04-2008

Thanck's a lot.

Patrick from Toulouse @ 10:41:01 on 26-03-2008

I have ubuntu 7.10. Grisbi graph works fine with java environment provided by "sun-java6-jre" package.

Romain from Rouen, France @ 14:31:10 on 22-03-2008

Patrick,

Ubuntu comes with an older version of Java (1.4), you need to download a newer version from java.com: use the second file from http://java.com/en/download/linux_manual.jsp

Follow the instructions from the website.

After installation be sure to use the updated java binary. You can find this file under 'java-install-dir'/bin/java
'java -version' should give version 1.6 and NOT 1.4.

Now it works!

(* I just tried this on my brand new Ubuntu installation *)

Wessel from The Netherlands @ 13:53:03 on 20-03-2008

Hello
My os is ubuntu 7.10.

I can't use your program because :
presario@presario-laptop:~/Desktop$ java -jar grisbiGraph_v0.03.jar
Exception in thread "main" java.awt.AWTError: Cannot load AWT toolkit: gnu.java.awt.peer.gtk.GtkToolkit
at java.awt.Toolkit.getDefaultToolkit(libgcj.so.81)
at java.awt.EventQueue.invokeLater(libgcj.so.81)
at javax.swing.SwingUtilities.invokeLater(libgcj.so.81)
at main.MainWindow.main(MainWindow.java:603)
Caused by: java.lang.UnsatisfiedLinkError: libgtkpeer: libgtkpeer.so: Ne peut ouvrir le fichier d'objet partagÃ©: Aucun fichier ou rÃ©pertoire de ce type
at java.lang.Runtime._load(libgcj.so.81)
at java.lang.Runtime.loadLibrary(libgcj.so.81)
at java.lang.System.loadLibrary(libgcj.so.81)
at gnu.java.awt.peer.gtk.GtkToolkit.(libgcj.so.81)
at java.lang.Class.initializeClass(libgcj.so.81)
at java.lang.Class.forName(libgcj.so.81)
at java.awt.Toolkit.getDefaultToolkit(libgcj.so.81)
...3 more

What can i do ?

Thanks.

Patrick

Patrick (oulouse - France) from Toulouse FRance @ 14:47:50 on 19-03-2008

Hi Wessel, hi all,

Juste discovered Grisbi Graph, and it completes pretty well my use of Grisbi !

Only thing I would like to add to the Todo list, which I think is not too difficult, is to generate te categorie-to-colors map once and for all when opening the file. Then one will identify categories at one glance when switching accounts.

Thank you for this nice litle tool, so useful and simple to use ^-^

Benoît 'Mutos' ROBIN from Feucherolles, France @ 08:03:05 on 16-03-2008

Thank's for this nice software!!

Marco from Rimini, Italy @ 00:05:01 on 14-03-2008

Thanks very much for your outstanding help.As you mention,Wessel, the problem has been sorted out using Mozilla firefox.
So now I can enjoy both, Grisbi and Graphs at once.
Thanks again for your time

Fumanchu from Madrid @ 16:03:45 on 04-03-2008

Fumanchu,

If you download the .jar file, somehow internet explorer renames this file to a .zip file. Therefore when you double click it, you just go into the package. Try to either use another browser (eg. Firefox) to download the file, or rename the downloaded file back to a .jar file. I guess you have to have "Hide extensions for known file types" turn off in the Tools -> Folder Options -> View tab menu.

Good luck.
If it doesn't work I'll try to setup a ftp-site to host the files. Hopefully Internet Explorer doesn't rewrite file extensions from ftp site.

Wessel from Zwolle @ 19:27:19 on 03-03-2008

Hi I have java installed, and tried to add the graphics as Mihael Suggest but it doesn´t work.Does anybody know where can I download the graphic jar file from?
I just manager to unzipped the file with the same results as Chely from Madrid.

thanks in advance

Fumanchu from Madrid @ 20:05:36 on 23-02-2008

Never mind :)))
when i clicked the link to download the file, XP changed the name to .zip
solved.
thanks and keep up the good work

Cheli from Madrid @ 19:05:24 on 17-02-2008

I just downloaded the zip file but don't see the .jar file anywhere except those 'main', 'com', 'org' and 'META-INF' folders and all those .class files inside them.
Thanks

Cheli from Madrid @ 19:02:25 on 17-02-2008

Michel,

In XP you can just double click the .jar file if you have java installed.
Otherwise start the application by java itself by typing: "java -jar grisbiGraph.jar" in the command prompt. Evidently for both routines you need java installed.

Wessel from Zwolle @ 08:36:47 on 17-02-2008

Hello,
for Open Office users here : http://poumarede.free.fr/wiki/doku.php?id=vrac_geek#faire_ses_comptes_sous_linux_avec_grisbi_avec_des_graphiques you can find the ODS template that I built for graphics from Grisbi CSV export (just copy/paste the CSV lines in the first tab) then refresh the dynamic tables. I you are not afraid by some tuning in OO to customize the reports to your needs, it can help you.

Raphael Poumarede from Yvelines (France) @ 16:02:24 on 16-02-2008

Hello, im french so excuse my english.
I download your software, but i haven't executable file in your package. I use windows xp and have grisbi on an usb key. Can you help me. thanks for your application

Michel from France Boulogne Sur Mer @ 09:29:33 on 15-02-2008

David,

Perhaps you downloaded the source file instead of the binary?
The filename should be: grisbiGraph_v0.03.jar

Wessel from Zwolle @ 09:14:04 on 01-02-2008

In the command line I type:

$ java -jar grisbiGraph.jar &

and get the response:

$ Failed to load Main-Class manifest attribute from grisbiGraph.jar

I extracted the .jar archive, but cannot find the main program (executable) to launch.

David @ 17:18:57 on 31-01-2008

Thank you! This is really useful...it gives you immediately a clear situation of how you're spending your money.

Looking forward to further development!

Thank you!
ale

Alessandro from Trento, Italy @ 09:08:25 on 11-01-2008

Thanks a lot for Grisbi Graph.
Great work

I just have a request for evolution :
For a category, it's a big graph.
Would it be possible to see how this category is changing month by month

Nico from Nancy, France @ 08:12:38 on 11-01-2008

Excellent logiciel (Ubuntu 7.10 Gutsy (avec JRE6))

Merci du travail fourni qui permet à Grisbi d'avoir quelques graphiques.

René-Pierre from Rodez, France @ 11:54:10 on 03-01-2008

Thanks, software very easy and useful.

Rafael Marcos from Spain @ 14:14:41 on 02-01-2008

thank's

Guy @ 09:53:45 on 31-12-2007

Hi Wessel!,

Thank you very much for developing the application.

I appreciate you very much.

Raju Venkat from India @ 20:28:41 on 21-11-2007

Hi.
Good programm. Besides all previously mentioned, it would be nice if this programm read compressed Grisbi files.

MJP from Wroclaw, Poland @ 13:42:16 on 16-11-2007

Hello Wessel
First, thanks for this tool :
Grisbi is a good software and the only missing thing WAS charts.
1 question :
1) is it possible to see also incomes ? I can only see my expanses is it normal ? is there something to configure grisbi side ?
Enhancement suggestions:
1) 2 new drop down menus :
- 1 to choose % or amounts
- 1 to choose expanse/income
- add a new var chart combined with expanses and incomes.
2) add the possibility to zoom :
click on a part of the graph to get the data lines behind the computation...

OK I know that I ask a lot ;-)
So if I get a chance I'll look a little bit the code to see how hard it would be to help you to implement this kind of stuff.
In this case I will let you know of course.

Thanks again !
Best Regards

Raphael Poumarede from Yvelines (France) @ 15:31:14 on 10-11-2007

Hello,
Absolutely wonderful your work.
As promised, I applied under Ubuntu version 7.10.
And very good news, it works.
I am available if anyone wants more information to post online command in a terminal, as evidenced by my experience, I found that we can do some bad orders before arriving at a beautiful result .
My explanation can be given in English or french.
Thanks again.

Van De Velde, Patrice from Patrice.vdvelde@gmail.com @ 15:06:29 on 10-11-2007

Thanks, it's exactly what I was after. I also would like to see Gilles third suggestion

Thanks again

Bobs

Bobs from Ipswich UK @ 13:01:20 on 10-11-2007

great soft, thank

Damien from France @ 19:22:28 on 05-11-2007

Hello Wessel,

Thanks for Grisbi Graph.

I just have a request for evolution : Could it be possible to select multiple accounts and aggregate values for each category on the graph.

Cheers,
Julien

Julien from Paris, France @ 14:43:02 on 27-10-2007

Hello,
I work with Grisbi under Ubuntu 7.10, also with windows Xp Pro at the office.
My preference is for Ubuntu for my work privately.
I discovered Grisbi Graph, really amazing and congratulatory.
I managed to make it work under window Xp Pro and not under Ubuntu July 10
Can the method again adapted for Ubuntu?
Thanks in advance
patrice.vdvelde@gmail.com

Patrice Van De Velde from Hamme-Mille - Belgium @ 08:12:10 on 27-10-2007

Gilles,

I added your second comment to the program, as it was fairly easy to do. Number 1 and 3 I have to look into.

Thanks for the response!
Cheers,

Wessel from The Netherlands @ 12:10:37 on 10-10-2007

Hi Wessel!

I just tried your piece of software - very promising, thanks for that!

Here are a few comments:
Background: running under linux ubuntu 7.04 feisty
1/ Only jre 6 is supported, I got an error while trying to run with 1.5 You probably should add a release note or compile with jdk 1.5 compat (if possible...)

2/ You could add a command line parsing to directly open a file from the command line (like java -jar grisbiGraph.jar myaccountfile.gsb)

3/ As another graph, I would like to see the evolution of my account's balance over time. More generally, you can get some inspiration from ms-money, they are quite good at doing pretty graphs :)

Once again, thanks for this and hope it can get into gribi soon!

Cheers,
Gilles

Gilles from Grenoble, France @ 11:18:46 on 09-10-2007

I already fixed one bug. It seems in some countries Grisbi uses a comma instead of a dot to indicate decimal figures.

Wessel from The Netherlands @ 10:14:04 on 06-10-2007