After you’ve copied your table, go over to Column G1 and paste it using “Ctrl + V”. We will skip Column F and start our next section for Expenses.įor the Expenses columns, you can highlight your entire Income Streams table and then click “Ctrl + C” (at the same time) to copy them. We’ll get those full totals in Step 5, don’t worry about it just yet! 4. Type “=sum(C2-D2)” in E2 to get your total difference, and repeat this for all of your boxes in the Difference Column (D3-C3, D4-C4, etc.). You can put them in as numbers, by client or job name, or however is easiest for you to organize. If you have a few jobs or are self-employed as a freelancer, you can use “Income 1”, “Income 2”, “Side Gig 1”, “Side Gig 2”, and so on. In our example, we just use “Paycheck” for someone with a typical job week to week. Under the column labels, type in the names for your income in Column A. In the last column, type “Difference” in E1.įor our example, let’s say you get paid a planned income twice a month from your regular job and twice a month from your side gig. In Column C1, type “Estimated.” You could also call it “Planned Income.” Type “Actual” in Column D1. 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! 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. 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. It’s really the fastest and easiest way to get started when you are a beginner.īut we also see why people like the ease of spreadsheets as well. Now we are a fan of the pen-and-paper method. Monthly Totals (Are You Overspending Money?)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |