![]() Budgeting options help you to make the most of your money and save up for bigger expenditure such as holidays or a new car. There are numerous reporting options available in the app as well as asset management and the ability to track stocks and shares. And if you're concerned about security, the SQLite data base is locked down with AES encryption.Īs long as you keep up with the ongoing maintenance and data entry relating to your spending and income, Money Manager Ex can give you an at-a-glance overview of the state of your finances. You just need to provide information about all of your banks accounts and so on, enter details of your bills and regular payments, and then keep the database up to date with your incomings and outgoings from moving forward. If you've already been using another financial program, or you've been using a spreadsheet to track your finances, you can speed up the process of getting Money Manager Ex setup by simply importing this data directly into the app. You will have to set aside some time to manually create the database in which Money Manager Ex will store all of your financial information, but this is very much a guided process it's a little on the time-consuming side, but it's certainly not difficult. ![]() The program is easy enough to use that it is suitable for everyday personal finance management, but it is also powerful enough to meet the needs of small businesses. There are various commercial offerings to choose from, but Money Manager Ex is a free, open source and cross-platform app that makes it easy to track spending, plan budget, monitor assets and generally manage your money. If you are interested in these queries, please subscribe the RSS.Although online banking has made it possible for all of us to gain far better insights into our finances than used to be possible, there's still very much a place for money management software. 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. #MONEY MANAGER EX REPORTS SOFTWARE#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 |