Computerized Investing > December 1, 2012

Vertex42 Money Manager

| | | COMMENTS (8) | A A   Reset

The Vertex42 Money Manager is an Excel spreadsheet that helps to manage personal financial planning. This free template provides pre-configured formulas to record, budget and plan your finances all in one organized format. The Money Manager encompasses all aspects of your spending, income, savings and more in an easy-to-use spreadsheet that can assist newcomers and frequent Excel users alike in tracking expenses and planning for the future.

The Money Manager helps you organize your financial situation using different worksheets within the file: Budget, Transactions, Categories and Report. This allows you to set a yearly budget and track your expenses by specific sub-categories, such as money going into a college fund, investments or charitable donations.

Unlike many other budgetary tools, the Money Manager allows you to set a budget for the entire year rather than just by month. With a yearly budget, you can project how much you will have (or would like to have) at the end of the year if you spend X amount of money each month. In the Budget worksheet, you can record variable expenses that occur month to month, but vary in amount, such as groceries and gas; when entering the amount spent in the groceries sub-category each month, for example, the worksheet will show you how much you spent total year-to-date as well as your monthly average, so you can budget accordingly for the future. You can also track irregular (non-monthly) expenses, such as vacations and birthday gifts. For instance, if you know you will spend about $600 on Christmas gifts, you can create a special savings sub-category and budget $50 each month in order to prepare for December. This is a great tool for all ages and all income levels. Whether you want to ensure you have enough money for retirement or for next year’s spring break trip, the yearly budget can keep you in check.

In the Transactions worksheet, you can record cash inflow and outflow for multiple accounts, including checking, savings and even the cash in your purse or wallet. The downside to this program versus other online budgetary tools is that you can’t link this spreadsheet to an online banking account, and therefore the transactions won’t upload automatically. Thus, it is important to keep up-to-date with manually tracking and inputting your expenses, and doing so efficiently.

The Report tab illustrates your expenditure and, most importantly, compares your actual spending versus your budgeted spending on a monthly and year-to-date basis. One of the highlights of the Report worksheet is that it provides an actual versus budgeted spending comparison within the categories as well. For example, if you have been going over budget month-to-month, you can view which specific categories you are overspending in. Perhaps decreasing your restaurant expenditure and marginally increasing your grocery budget may do the trick.

This comprehensive personal financial planning spreadsheet is complemented with a thorough Help tab, which details each feature as well as the steps to take in order to make full use of the spreadsheet. Vertex42 notes, however, that though this is a simple management tool, errors in calculations may occur. If formulas within the Money Manager are deleted or shifted, the calculations become error-prone. As long as you follow the directions while customizing categories (which causes the most problems, according to Vertex42) and are careful when adding and deleting rows, the Vertex42 Money Manager will be a great asset in your financial planning. With 2013 quickly approaching, this spreadsheet may be just the tool that will give a boost to your new year’s resolutions, and since it’s free, you won’t need to add it to your budget.


System Requirements: Windows XP/2003/Vista/7

Size: 78.11 K

Price: Free


John Carsten from NY posted over 5 years ago:

This file is an Executable file ie .EXE.

Executables may contain things that I don't want in my system.
I elected to not download, as I do with all executable files that are presented to me.

Mark Gahagan from IL posted over 5 years ago:

Tried to open this in a windows virtual machine. It is an .exe file which ostensibly does nothing. I suspect it has done something in the background but my virus checker found nothing. Doesnt work anyway!!

Doug Hart from MD posted over 5 years ago:

Try downloading direct from the Vertex42 site, it is an Excel file only, not executable.

S Gilford from CA posted over 5 years ago:

If you want a more robust free software application to manage your money, then I would suggest Microsoft Money. Although the retail version of Microsoft Money has been discontinued, Microsoft has made available a free Microsoft Money Plus Sunset version. Money Plus Sunset is available in two versions: Money Plus Deluxe Sunset and Money Plus Home & Business Sunset. Both versions provide the ability to import QIF and OFX file types that most financial institutions provide, thus eliminating much of the manual data entry. Additionally, if you Google "microsoft money forum", you will find free applications that make it easy to obtain and import stock and mutual fund prices into the sunset edition. In summary, Microsoft Money is alive and well.

Gilbert Parker from MI posted over 5 years ago:


Antonio Alvarez from PA posted over 5 years ago:

I am using windows Vista and got the same message as Gilbert Parker:"APP HAS REQUESTED THE RUNTIME TO TERMINATE IT IN AN UNUSAL WAY".

It was not a plain Excel File but an executable file.

Yusuf Qamar from KS posted over 5 years ago:

This program does not download ! Error messages appear. Not good.

Richard Tuttle from FL posted over 5 years ago:

I got the error message using the cnet download site. The site has a lot of templates for free download. You have to download them directly from the site as the Excel file format. The cnet download has an .exe file that performs the download which causes a virus error mentioned above.

You need to log in as a registered AAII user before commenting.
Create an account

Log In