You’re almost there!  Only one more week until I describe how to create your budgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More.  Before you can do that, you’ll want to make sure that the income and expenses you’ve entered don’t have too many mistakes.  In this post, I’ll talk hot to review the expenses and income you’ve entered in the spreadsheet to make sure you have an accurate starting point for your budgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More.

Before getting to that topic, here are your budgeting tasks for this week:

1. Continue using and refining your expense tracking system.
2. Continue to enter your income and expenses into the spreadsheet.
3. Make sure to update the number of months you have been entering information on the Basic Inputs tab.
4. Review the first two columns of the BudgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More tab, as described in the rest of this post.

Make Sure Categories are Right

Over the past several weeks, you’ve been entering the category name with each income and expense line item.  Mistakes I’ve made include using more than one variation on some of my category names, such as household expense and household supplies.  I also sometimes misspell one or more of category names.

If you’ve made similar mistakes, you’ll want to correct these mistakes so you have exactly one line in your budgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More for each type of income and expense.  Here are the steps to find and correct these mistakes:

1. Go to the BudgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More tab.
2. Review the category names to see if there is more than one row in Column A that corresponds to the same category.
3. If there is, figure out which category name you want to use.
4. Make note of all of the incorrect names.
5. Go to each of the Bank Transactions, Cash Transactions, Credit Card Transactions, Less-Than-Monthly Expenses, and Income tabs.
6. Hold down the Alt Key and hit E.
7. Hold down the Alt Key and hit F.
8. Enter one of the incorrect names in the box next to “Find What.”
9. Hit the Find Next button.
10. Any time Excel finds the incorrect category name, replace it with the correct name.
11. Repeat steps 9 and 10 on each of the tabs listed in Step 5 until the incorrect label no longer appears on the BudgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More tab.
12. Then repeat steps 6 through 11 for any other incorrect names.

You’ll know you are done when each category name appears exactly once on the BudgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More tab.

Make Sure Amounts Look Reasonable

Once all of the category names appear only once and have the names you want, you’ll want to make sure that the values in Column B look reasonable.  These values are the totals of the values you entered on the various tabs, adjusted to either an annual or monthly basis depending on the choice you made in Cell B5 on the Basic Inputs tab.  Two reasons these amounts could look wrong are (1) you entered the wrong amount for a transaction or (2) you entered an incorrect value in the “How Many Times a Year” column.

If a number looks too high or too low, you can use the following steps to help find the problematic input:

1. Identify the category name in Column A of any value in Column B that looks too high or too low.
2. Go to each of the Bank Transactions, Cash Transactions, Credit Card Transactions, Less-Than-Monthly Expenses, and Income tabs.
3. Hold down the Alt Key and hit E.
4. Hold down the Alt Key and hit F.
5. Enter a category name that has an unexpected value in the box next to “Find What.”
6. Hit the Find Next button.
7. Look in the Amount column of any row in which Excel finds your category name.
8. Does the amount look right? Common entry errors are to transpose digits (i.e., enter them in the wrong order) and put the decimal point in the wrong place.
9. Fix any errors in the amount.
10. Look in the “How Many Times a Year” column.
11. This column can be blank for any row that contains an expense you pay every month.
12. For payments made less than once a month, the entries in this column should be the numbers of times per year you make payments of the amount shown. For example, if you pay your auto insurance bill twice a year, the semi-annual amount should be in the Amount column and 2 should be in the “How Many Times a Year” column.
13. Repeat steps 7 through 12 on each of the tabs listed in Step 2 until the amount on the BudgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More tab for this category looks reasonable.

Next Steps

Next week, I will talk about how you can create your budgetA plan showing targets for income and expenses over a fixed time period, such as a month or a year. More using the income and expense information you have tabulated so far and corrected.

Download Budgeting Spreadsheet Here

Susie Q

Susie Q is a retired property-casualty actuaryA professional who assesses and manages the risks of financial investments, insurance policies and other potentially risky ventures. Source: www.investopedia.com/terms/a/actuary.asp More and mother of two adult children.  As her children were moving from their teens into their 20s, she found she was frequently a resource on many, many financial decisions and she had insights and information she could provide to them.  She spent a significant portion of my career building statistical models of all of the financial risks of an insurance company and interpreting their findings to help senior management make better financial decisions.  She is the primary author at Financial IQ by Susie Q and volunteers with other organizations related to financial education.