In this economy, having control of your finances is key. Knowing your position as compared to your income and your expenses is extremely important. A lot of us have seen others stand in line at the store and have their credit cards rejected, even after trying them multiple times. Ask anyone who has experienced this, and you know that it is probably one of the most embarrassing situations that someone can experience. Protect yourself from this by keeping track of your finances and other assets.

One of the best ways to record your budget is to use Microsoft Excel and record your budget every month. This can be made even easier if you receive a fixed income every month. It will be a little more complicated if you work an hourly job and never know how many hours you may work in one month. Having some experience in Excel is also warranted. Being able to use the finance formulas will help you immensely month to month.

Begin by organizing a spreadsheet into a simple and easy-to-read format. Do not worry whether others will think it is good enough; this is for you and you alone. When organizing your sheet, please separate different aspects of your budget. An easy separation is to list your full monthly income in one cell along with your total expenses. You should explain these expenses below the table. You can do this by separating them into your monthly bills, your household expenses, such as food and other necessities, car expenses, your current savings, an emergency fund, and a spending amount.

Subtract your expenses from your monthly income. What you have left you can either add to your investments, savings, your spending amount, or, even better, an emergency fund. Another fund you can create is one for your retirement if you do not have one through an employer, or even a private social security fund. No matter what you want for a personal fund, it will be easy to keep track of using this method.

If you know how to use formulas in Excel, this process can be simplified by organizing your budget with these formulas. It is best to learn it on your own, as it will make much more sense without having an article attempt to explain it.

If you have investments, you should also keep track of these. Always try to check your investments and stocks and record them in your spreadsheet, or spreadsheets.

Maybe you do not want to use Excel; if that is the case, you can use iPhone Apps, or even find a program on the internet. Anything you find, you can use, as long as it is able to help you track your expenses.

Average rating: