The Chinese Fishing Nets
Money Manager Ex - SQL Query
Money Manager Ex is a personal finance management software. It lets you manage your personal faineance. You can manage your expenses, investments and stocks using Money Manager Ex. The most appealing feature of this software is custom reports. It lets you run custom queries against its Sqlite database.
In my previous post on Money Manager, I explained its different features. In this post, I will explain how you can get category wise report of your expenses. Money manager manages your accounts in categories and sub-categories. It has many pre-defined categories. Each category is further classified into subcategories. Usually these are sufficient for the general use.
However you can create new category or subcategory easily. One lacking feature of this software is that it does not provide category-wise report of your transactions. You can see transactions summed up by sub-categories however.
To overcome this shortcoming, I wrote a simple SQL statement that allowed me to see the amount I spent on different categories.
SQL to view category-wise report:
The SQL statement to see categori-wise report is written below.
select a.categid, categname, round(sum(transamount),0) amount from checkingaccount_v1 a inner join category_v1 b on a.categid = b.categid group by a.categid having transdate >= '2008-06-01' and transdate < '2008-07-01'
The above statement displays amount spent on different categories for the month of June 2008 i.e. between 1st June and 30th June (both inclusive). You may need to replace the dates i.e. '2008-06-01' and '2008-07-01' as per your requirement.
To execute this statement, select 'Custom SQL Report' from the 'Reports' menu on the Money Manager. If you cannot see 'Custom SQL Report' option, you may need to expend the Reports section by clicking on the '+' sign.
Selecting the 'Custom SQL Report' will open a 'Custom SQL Dialog' box that will ask you to type the query. Copy and paste above statement into the white box and click on the Run Query. It will show your desired report.
If you have any problem running the query, please let me know through comments of this post.
If you need any specific query for your requirement, please put your requirement in the comments and I will be happy to help you out.
Note: In future, I will be writing more SQL queries for MME. If you are interested in these queries, please subscribe the RSS.
Related Post:
Money Manager Ex - Described
Popular posts from this blog
Redirecting to new window in c#
As a developer, many time I wished to redirect user to a new URL into a new browser window. I wanted to use response.redirect at server side and open the new web page into a new window. But the way redirection works makes it impossible to open a new window from server side. The common solution to this problem is to use java script's window.open statement at client side and then fetch the new URL into the new window. To me, this is totally unacceptable while I am writing server side code. So I decided to write some code to do this. But before writing, I googled for the same. I found a good solution for the problem. I would like to give proper credit to the author, who chose not to publish his/her name. As they say a code worth one thousand words, here is the code: ResponseHelper Class: The ResponseHelper class does all the magic. It adds a client side script to the response which opens the new window. Use this class in place of response class if you want to open new window. Yo
CBSE Class X Result 2010 – How to Calculate Percentage
Today, CBSE Board, India declared class X result for year 2010. But here is a catch – this year they changed the rating from numbers to grades. Most of the students are apparently confused how to get percentage from their GPA. How to convert CGPA to Percentage Here is the simple method to convert GPA into percentage: Percentage = 9.5 × CGPA Example: CGPA = 6.8 Percentage = 9.5 x CGPA = 9.5 x 6.8 = 64.60% The percentage calculated by this manner is the overall percentage. How to convert GP to Percentage Here is the simple method to calculate percentage from GP: Percentage = 9.5 x GP Example: GP = 06 Percentage = 9.5 x 6 = 57.6%. The percentage calculated in this manner is the percentage in that particular subject. Technorati Tags: CBSE , CBSE Result , CBSE Result 2010 , Percentage from GPA SUBJECT WISE GRADE POINT: Marks Range Grade Grade Point
Monitor Lizard @Kakkanad, Kochi, Kerala
We were in the middle of market the other day when we found this Monitor Lizard at the corner of the road. Some locals have tied it with a rope while they were waiting for the forest official. Pic taken at Kakkanad, Kochi, South of India.