#Making a personal budget how to#
#Making a personal budget plus#

In Column A1, type “Income Streams.” Next, in Column B1, type “Date.” If you want borders like I do, you can highlight the section you’ll use, then click on the box underneath the font size to get some options for your borders.įirst, we are going to label the columns. For this section, we are going to use Columns A-E. In the first section of your spreadsheet, make columns for your primary source of income and any secondary sources of income.

Now that you have a blank sheet open, the first step in making a budget in Excel is organizing your income sources. When you open the Excel program, choose “New” on the main screen and use the search bar in the middle to search for “budget” in the templates. If you don’t want to make your own Excel budget template to use, you can use an Excel template. After you’ve opened the program, click on the Blank Workbook in the top left corner or in the center area of Excel. If you already have Excel downloaded on your computer, go ahead and open it up. To create your own budget spreadsheet, you’ll need to get a new blank workbook open in Excel for your budgeting spreadsheet. Having specific, measurable goals in place will make it easier to track your spending habits throughout the month. The answers to these questions will help you set your short-term and long-term goals. These are all questions that you can use to help determine your financial health and the best budget plan for you. What are your current financial goals? Are you saving each month, or have something to save for? Are you paying off credit cards or student loans? It will be much easier to create your monthly budget once you have all of your goals in mind. It’s essential to remember that budgets are all about planning for your spending, so the first step is to identify your financial goals. You can create a new sheet with ease, and separate your records however you please, but we’ll give you run down of how we make our budget at our Savvy home: 1. Now that we’ve told you why you may want to make a budget in Excel, let’s show you how it’s done!

#Making a personal budget how to#

If you don’t want to follow steps for how to make a budget in Excel, you can find one that fits your needs and plug in the numbers for each month. You can create a budget with just a few simple formulas, and you can adjust the spreadsheet to your specific needs as they change over time.Īnother great option with Excel is the budget templates that are available online. It’s also easy to use and helps you organize your information to make sense for your financial plan. It’s top-rated for personal finance usage! Why Use Excel?Įxcel is an excellent program for creating budgets because it is a powerful and flexible program. For example, if you want to track your budget for health care expenses, you can filter expenses by category and make everything easy to find.

#Making a personal budget plus#

Plus a spreadsheet like Excel means you can more easily find expenses and income in your budget. The great thing about using a spreadsheet to organize your budget is that you can use it again and again once you have your setup done and formulas created.Ī spreadsheet allows you to use different formulas or functions that help you organize your data into useful information, such as how much cash is left at the end of the month or if you’re over budget. Now we are a fan of the pen and paper method– we even created the Savvy Budget Binder for people who like doing their finances out by hand and skipping the computer work.īut we also see why people like the ease of spreadsheets too, so we made an easy and pre-made Excel file for you guys!

Monthly Totals (Are You Overspending Money?)