The payees and categories feature indicate the reason an expenditure is made or an income is received. The personal finance software then allows searching, filtering, and sorting by every field to have a clear situation of bank accounts at any time. Money Manager EX allows users to take note of all expenses and incoming in a clear view by dividing and highlighting them with different status. The wizard supports multiple currencies for each account to have more flexibility. Money Manager EX offers a wizard that makes it easy to create accounts and start to use MMEX. The key features offered by Money Manager EX include reminders for recurring bills and deposits, budgeting, and cash flow forecasting, importing data from any CSV format, simple one-click reporting with graphs and pie charts, international language support, and non-proprietary SQLite database with AES encryption. Money Manager EX primarily helps to organize one’s finances and keeps track of where, when, and how the money goes. If you are interested in these queries, please subscribe the RSS.Money Manager Ex is a free open source, cross-platform, and easy to use personal finance software that acts as an excellent tool for providing one with a bird's eye view of their financial worth. Note: In future, I will be writing more SQL queries for MME. 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. If you have any problem running the query, please let me know through comments of this post. Copy and paste above statement into the white box and click on the Run Query. Selecting the ‘Custom SQL Report’ will open a ‘Custom SQL Dialog’ box that will ask you to type the query. If you cannot see ‘Custom SQL Report’ option, you may need to expend the Reports section by clicking on the ‘+’ sign. To execute this statement, select ‘Custom SQL Report’ from the ‘Reports’ menu on the Money Manager. between 1st June and 30th June (both inclusive). The above statement displays amount spent on different categories for the month of June 2008 i.e. 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 >= ‘’ and transdate < ‘’ The SQL statement to see categori-wise report is written below. To overcome this shortcoming, I wrote a simple SQL statement that allowed me to see the amount I spent on different categories. You can see transactions summed up by sub-categories however. One lacking feature of this software is that it does not provide category-wise report of your transactions. However you can create new category or subcategory easily. Usually these are sufficient for the general use. Each category is further classified into subcategories. Money manager manages your accounts in categories and sub-categories. In this post, I will explain how you can get category wise report of your expenses. In my previous post on Money Manager, I explained its different features. It lets you run custom queries against its Sqlite database. The most appealing feature of this software is custom reports. You can manage your expenses, investments and stocks using Money Manager Ex. It lets you manage your personal faineance. Money Manager Ex is a personal finance management software.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |