Good morning friends, haters, and frenemies. Microsoft offers several budget templates already in Excel or via the Office Template website. First Step: Start up the Excel program as it opens up a blank spreadsheet. At the top, youll see a wrap-up section of moneys in and out along with the net amount, totals, and averages. Your bottom line is how much you have leftover for fun, or tells you how much spending to cut. See Also: Best Mint Alternatives Our Top Picks This Year. The following steps will walk you through customizing a monthly budget template in Excel. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. 1. If you're a freelancer, this section will most likely look different each month, but leave yourself enough room to add and remove items as needed. Alternatively, you can also select the last line in that column and input the formula =SUM(E4:E10). For example, group all of your utilities and group all of your entertainment expenses. Have you created your own budgeting spreadsheet in Excel? Select the range with expenses and the two titles named Actual and Estimated. These are going to named items, budget amount, actual amount and difference. Read More Why My Emergency Fund is the BombdiggityContinue, Good morning, peeps! Next, select cell B2, click the lower right corner of the cell and drag it across to cell M2. Notes: Instead of typing the constants into your formula, you can select . It will allow you to set up a zero-based budget plan over multiple periods and track your money flows with ease. Dont be afraid to create a whole new budget spreadsheet for tracking your vacation budget, holiday spending, debt repayment, and more. This cell will show a negative number if you spent more than your earned. Start by selecting cells in A1-G2 II. Learn more about Greg here. Download. If you prefer to use a template, you can follow these steps to prepare a budget in Excel: 1. If you have more than one source of income such as more than one earner, multiple jobs, or dividends from investments, you can list those separately in your income section. Click File, then New from Template. Best of all, if youre already a Microsoft customer, it wont cost you an arm and a leg to get started. To begin creating a budget, the user will open a fresh Workbook in Excel by hitting File > New > Blank Workbook. Label rows in column A with the budget categories you're assigning. We select and review products independently. To add a shape to your worksheet, in the Quick Access Ribbon go to the insert tab and then select shapes under the illustrations tab. Visit the Font section of the Home tab for options like these. Once you like the look of your budget spreadsheet, its time to add the formulas that will automatically calculate everything for you. Excel or Google Sheets Budget Template ( Download my FREE Digital Budgeting Spreadsheet) 2. This is done by clicking the Excel icon in your computer (located on your desktop or your start-up page) Second Step: You need to input data to help you calculate the figures for the budget. Explanation: we created two conditional formatting rules to highlight cells lower than 0 and greater than 0. Type "budget" in the search box. Best Mint Alternatives Our Top Picks This Year, Cash Money: $9,438 in September Incomeand a Business Card Giveaway, Best High-Yield Savings Accounts for December 2022. Label columns B-F as follows: Date Paid Description Budgeted Cost Actual Cost Remaining Add as many sections or sheets to your Excel budget as you want. These numbers automatically feed information to the Cash Flow tab to keep track of how much you are earning and spending. The template from Spreadsheet123 is a good option for a family monthly budget. Step 6: Fill/Update your budget with actual and budgeted numbers. Heres how to start building your very own budget spreadsheet right away! Sites like Vertext42 and Spreadsheet123 offer nice collections of budget templates. I personally use the paid app Every Dollar (on my 3rd year). In the example below, I added Total to the B11 cell. This is where you'll be able to see the total for the month (cell C51, in the picture below). 2. Heres why I love my emergency fund and why youll love yours too! It's a dark-green app with a white "X" on it. Enter Excel. Plus, Google Sheets works (almost) seamlessly with Excel, meaning you can easily import an Excel budget template you created into Sheets. Everything is formula-driven, making it easy to see a snapshot for the month. Lets face it: The COVID-19 pandemic has turned into a financial nightmare for many of us. Select a chart style you like that best represents your data. 2) Click on Data > Data Analysis. How to Make a Budget in Excel - Part 1 Abyssal Spark 8.2K subscribers Subscribe 6K 1M views 8 years ago This is part 1/5 in a series of step-by-step instructional videos aimed to help the viewer. How to calculate the total balance? To do this, select the first two rows in columns A-G and select Merge and Center from the workbooks Home menu. Start by opening Excel and choosing Blank Workbook or go to File>New>Blank Workbook. Go to File, select New, then click Blank Workbook. You can save your Excel budget spreadsheet as a template to use every month. Include your email address to get a message when this question is answered. If you dont like the style you chose, you can always change it afterwards by right clicking your graph and selecting Change Chart Type.. It will show you how to effectively create a company budget using the Excel spreadsheet. You can then copy both total formulas across the rows for the remaining months. FREE Budget Spreadsheet Does making your own budget template sound too complex? Thankfully, you can leave your calculator buried in your drawer and track it automatically in Excel. Honestly, once you start using this type of budget, I dont think youll ever use a different style of budget again. You can also make your expense budget on a spreadsheet or worksheet. Samantha specializes in personal finance, working with clients to understand their money personality while teaching them how to build their credit, manage cash flow, and accomplish their goals. I can only hope. Excel Budget Template | Automate your budget in 15 minutes - YouTube Want a template that is already built for you? With many people losing jobs and others taking a big hit to their monthly income, creating a solid budget has never been more important. If you click on the 7,200, you will see =Income[[#Totals],[Projected]] pop up next to the fx input box. Compare projected costs with actual costs to hone your budgeting skills over time. =SUM (J2+H3-I3) Now, you can copy the formula to all the cells to calculate the running balance throughout the first quarter. If you already use Microsoft Excel, you can create a budget easily using a template or making one from scratch. On Mac, skip this step if a blank Excel presentation opens when you open Excel. Open a new Excel workbook. Manage your moneywithout ever leaving Excel. I know youre excited.but please try to contain yourself. Categories to Add to The Budget. Before diving into building the perfect budget, they need to save this file somewhere . Select a template and click Choose. Download Business Budget Excel Template View your budget and expenses in real time so you can make the most informed decisions, track income against expense, and ensure no item goes unseen in savings, spending, or debt repayment goals. Follow these steps. The household monthly budget in Excel template will download and open. Rather than type the formula in each cell, you can speed up the process by dragging the same formula across an entire row. > Get this personal budget template The Microsoft program has long been an excellent way to create a budget spreadsheet. In my fictional example below, the budget is over by $115. If you continue to use this site we will assume that you are happy with it. Sticking with a simple Excel budget template can work wonders for your money management, so dont feel like you have to become an Excel genius. Don't worry, we've got you covered. Select your favorite budget template based on your needs and liking. You can add and delete categories as you see fit. If you kept your income, expenses, savings, etc. You can then pick a template to download and use in Excel, or open it online and use it in Excel for the web. 1. Were committed to providing the world with free how-to resources, and even $1 helps us in our mission. RELATED: 7 Essential Microsoft Excel Functions for Budgeting. 3. If you sell more units of your product or service, these expenses go up with revenue. We will learn to create a budget both automatically and manually, step-by-step. To calculate savings, find out the difference between total income and total expenses. Label cell D3 as Date to help keep track of when this payment came in. If you cant find a template to fit your needs or just want something simple, or if you have unique circumstances and needs, you can create a budget from scratch with helpful Excel budget functions. Although this guide explained how to make a budget in Excel, youre definitely not limited to what I showed you here. Next, gather your bills, a pen, some scratch paper, and- of course- the device you will be using. As you can see by the example, I just added another column. Excel can automatically do the math for you. 1. We use cookies to make wikiHow great. In the totals row, sum all your income values using the sum function. Excel automatically adds the other months. At the end of the year, you can then create a new formula to add up your yearly savings, spending, and earnings. You can also create an Estimated sub-section in the Expenses heading if you wish to compare your actual costs or expenses with estimated or planned costs. In the inserted chart, right click at the Actual Value series then in the context menu, click Format Data Series. It helps in getting the collect figures from the rows and columns hence no exaggerated figure in whatsoever circumstances. Notify me of follow-up comments by email. Its that time againtime for our February budget breakdown. Click the second cell on the third row and type the first expenditure for the business. Repeat this for your planned total and your actual total. Read this post for some examples. Did you know you can get expert answers for this article? You are going to first create 4 main columns. Windows 11 Is Fixing a Problem With Widgets, Take a Look Inside a Delivery Drone Command C, Snipping Tool Is Becoming a Screen Recorder, Disney+ Ad-Supported Tier is Finally Live, Google Is Finally Making Chrome Use Less RAM, V-Moda Crossfade 3 Wireless Headphone Review, TryMySnacks Review: A Taste Around the World, Orbitkey Ring V2 Review: Ridiculously Innovative, Diner 7-in-1 Turntable Review: A Nostalgic-Looking, Entry-Level Option, Satechi USB-4 Multiport w/ 2.5G Ethernet Review: An Impressive 6-in-1 Hub, How to Make a Simple Budget in Microsoft Excel, Budget section of Microsofts Office Template site, How to Use Microsoft Excel Templates for Event Planning, How to Track Almost Anything with Excel List Templates, How to Link to Another Sheet in Microsoft Excel, How to Find the Smallest or Largest Number in Microsoft Excel, How to Make and Share a Household Budget in Google Sheets, You Can Get a Year of Paramount+ for $25 (Again), How to Tell the Difference Between AirPods Generations, What Is Packet Loss? Check out this video: https://youtu.be/c3vmacKGVkgOr Visit My Etsy Store:. Let us know how it went in the comments below! Income vs. expenses. If youre keeping everything on one sheet, this is super easy. Level up your tech skills and stay ahead of the curve. I just outlined my budget for the rest of the year with this! Enter the SUM function into cell O4. I covered addition and subtraction, but here are the formulas for multiplication and division too: Lets say you want the bottom row to add all the sums. Step 4: Use simple formulas to minimize your time commitment. Next, you can include a money remaining section at the bottom as mentioned above. Whether your budget is super simple or extremely complex, this step-by-step guide will teach you how to create a budget in Excel that can quickly be customized to meet your familys budgeting needs. Debt. You can see that we have successfully calculated the savings amount for the month. We use cookies to ensure that we give you the best experience on our website. These categories represent your income and all expenses for the month. Heres a free spreadsheet template you can use to seize control of your money! For Excel 2007-2019: From the Home tab, select Conditional Formatting > Highlight Cells Rules > Less Than. Year at a glance spending overview. Add a comments row just below the tables. Group your expenses in a way that makes sense to you and add them to the spreadsheet. Method 1 Using Templates Download Article 1 Open Microsoft Excel. Type Total in the last once you have listed all your income sources. Finally, after you've listed the Inflows and Outflows, you'll want to make sure you are within budget. Samantha Gorelick is a Lead Financial Planner at Brunch & Budget, a financial planning and coaching organization. This wikiHow teaches you how to create a record of your expenses, income, and balance on a day-to-day basis using Microsoft Excel. Then, do the same for your expenses. You'll want to split your sheet into two sections: One for income and one for expenses. By using our site, you agree to our. For this, look at cell C54: Because weve made our budget using a spreadsheet, its super easy to see where the family overspent and under earned. Excel monthly Budget Worksheet is the template to try if you're sick of wondering where your monthly revenue goes! His work and commentary have been featured in publications like Newsweek, Kiplingers Personal Finance, Dough Roller, CreditCardReviews.com, and more. To automatically calculate the difference between your Planned and Actual income, input the formula =SUM(F4-E4) after each row. Dont worry, weve done it for you! This was super helpful! =SUM ( Running Balance + [Income - Expense] ). How-To Geek is where you turn when you want experts to explain technology. Step 2: Give your worksheet a title and create categories for income and expenses. Why budget in Excel? It may not be useful if your paychecks are predictable. III. 1. The 10+ worksheets in this budget binder include: Monthly spending overview. Structure Your Personal Budget Spreadsheet If you've ever tried to make a personal budget you know the basics. Click on columns Acc No in both tables. In the Table/Range field, click the icon at the end and and select your whole data table from your Raw Data sheet. Then go to the Home tab and pick Currency in the Number drop-down box. Remember, for the final balance you must do the total spent minus the total income to get an accurate total. Making a budget in Excel can seem like a daunting task, especially if you dont use the program regularly. Thanks in advance if you have any ideas, To calculate the total planned budget, input the formula =SUM(Planned Expenses Total, Planned Funds Total, Planned Savings Total). Double-click the green X on the dock, or open the Applications folder and then the Microsoft Office folder, before clicking Excel. Step 3: Determining the period for your budget. In the Total spending column or Final balance column? Of course, youll want to replace the E4 and E10 designations with the range of cells you want to add together. Event income. (And How to Test for It), 2022 LifeSavvy Media. Skip a cell below Total and create a new heading named Expenses. 4. In our case, the income consists of entry fees. Some people might want to track their natural gas, trash, and electric separately while others may want to lump it together as utilities. Its totally up to you! 1. You can keep these sheets organized in any 1-inch binder and use dividers for each month. Select the Sum button in the Editing section of the Home tab and pick Sum from the list. This will also let you easily see how much money you have remaining at the end of the month. When you purchase through our links we may earn a commission. The first column should have several major categories: Income. You can follow the link to learn more about this topic. Get yours here. I had tried this step by step and able to make a monthly budget plan. To calculate the difference between your income and total spending, select the cell where you want the balance to display. First Step: Start up the Excel program as it opens up a blank spreadsheet. Heres how an expenses list with actual and estimated expenses would look like. Shift+0) twice, and. How to Open Household monthly budget Excel template Open a new instance of Excel and select New In the search bar search for Household budget. 2 Click the search bar. Adding a date section is optional and helpful if your income sources are varied each month. Click on More Templates. First, open a new workbook and select the "Budget" template from the list of available templates. This budget Excel template compares project and actual income and projected and actual expenses. Budgets help you increase your savings or profits by helping you stay within the estimated costs and expenses. After accessing your Excel application, go to File > New and search for the word "budget.". Step 2: Cost of Goods Sold These are variable costs. On the Number tab, choose the format type in the Category list on the left. Fixed expenses will be those expenses that are the same month after month. Learn how your comment data is processed. The graph displayed below is a donut chart, and I like how it neatly breaks down spending categories. In This video we will learn How to Create Personal Monthly Budget in MS ExcelWi Excel Expert#excel #excel_tips #excel_formulas_and_functions #exceladvance #e. For more about our advertising policies, read ourfull disclosure statementhere. =SUM (J2+H3-I3) Now, you can copy the formula to all the cells to calculate the running balance throughout the first quarter. For calculating your expenses, you want to use the formula, =SUM(Planned Number-Actual Number) to calculate how much you overspent. How convenient, isnt it? Required fields are marked *. Club Thrifty and CardRatings may receive a commission from card issuers. In the example, this is =SUM(Income!F11-D2). This is done by clicking the Excel icon in your computer (located on your desktop or your start-up page) Second Step: You need to input data to help you calculate the figures for the budget. In this tutorial, we are going to learn to make a monthly budget in Excel. Simply create another section at the bottom of the sheet. You're then on your way to budgeting your money with premade sections and built-in formulas. To see the budget templates in Excel, open the application and select More Templates in the Home section. How to Make a Budget in Excel First, decide what you'd like to track. If you never learn the other functions and options in Excel but simply follow these steps, youll be just fine. No worries, we got you covered. 3) Choose Variance from the list of options and click OK. 4) Enter your input range and output range, and choose whether you wantto label your columns or rows. However, finding a program that fits your unique needs can be challenging. On the worksheet, click the cell in which you want to enter the formula. Excel copies the function and border to the other cells. For example, if I went with the family budget spreadsheet, I would get a premade spreadsheet with a Cash Flow chart on the first tab. With her B.S. Once youve created all of the sections you want to track, its important to always know your running balance. Instead, you will find places to input your data on the other two tabs Monthly Income and Monthly Expense. Feel free to comment below if you have any doubts regarding creating a budget in Excel. Track Your Business Budget in Smartsheet Department Budget Grab a FREE Budget Template Need a spreadsheet budgeting template but dont want to do it yourself? For more options, visit the Budget section of Microsoft's Office Template site. To create a budget from an Excel template, follow these steps: Open up Excel. Save time and effort by grabbing our free budget spreadsheet! A fully stocked emergency fund can be one of the best financial friends you have. Most templates come with built-in formulas, so any changes that you make to one part of your template will update everywhere else. To create a pie chart or bar graph that displays your spending, you first need to create a column for percentages. Step 2 - Set up Your Income Tab - after creating blank workbook, create Income and source tab. Enter the SUM function into cell B6. Disclaimer: Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Plus, you can easily view several months (or years) of budgeting data with just a few clicks. Although some months display $0, youll have the formulas ready to go when you add the amounts later. Now it is starting to get fun! Once your problem is solved, reply to the answer (s) saying Solution Verified to close the thread. In the Difference column, rather than using the =SUM(Actual Number-Planned Number) formula, youll need to switch it around. Should you click on these links, we may be compensated. You might also type "Recurring" next to a row containing an expense for a subscription or a monthly (or weekly) service. Heres how to make a budget in Excel from scratch, including some of my favorite tips and tricks for customizing your new budget. on one sheet, you can also copy all of the boxes and paste them on a new sheet. A pop-up list of available budget templates will appear. Go to the bottom of the column for the first month, below expenses. then, use the borders tool on the workbook ' s " Home " pill ( looks like a squarely divided into four ) and choose " All Borders. Thanks so much for reading, and good luck! You'll use this same exact formula for the "Income" and "Balance" fields as well, except that you'll use "D" and "E" respectively instead of "C". Does Excel have a monthly budget template? Part 3. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); This site uses Akismet to reduce spam. Then, to calculate your planned balance use the formula =SUM(Total Planned Spending Total Planned Income). Money in Excel is a dynamic, smart template and add-in for Excel that allows you to securely connect your bank, credit card, investment, and loan accounts to Excel and automatically import your transaction and account information into an Excel spreadsheet. In our example, the formula would read =F2/F24. For instance, our income total is in cell B6, and expense total is in cell B19, so wed use this formula: Press Enter or Return and youll see your remaining money at the end of the month. Here's a free spreadsheet template to help you take control of your money!Hello is dir hier. How to Create a Budget Spreadsheet STEP 1: Open up Google, head to your Sheets page, create a new sheet, and name it. Meal planner. The wikiHow Tech Team also followed the article's instructions and verified that they work. Go to Next Chapter: Data Validation, Budget 2010-2022 To make your Excel budget look a little cleaner, select the entire section. RELATED: How To Create Custom Templates in Excel. Excel does the math so you can concentrate on your finances. 1) Select the data that you want to analyze. You can create excel budget spreadsheet from the scratch. Next, select cellsA3-A11, choose Merge and Center, and write and center the word Income. If you want to get creative, feel free to choose different fonts and colors. Example: =F32-B32 Step Eight: Adjust Your Spending What's your monthly remaining balance? 1. Then, use the same column headings Due Date, Planned, Actual, and Difference as you did earlier. If it doesnt, select the small down arrow next to the Projected column, and you will be able to include your new column to the calculations. Begin Creating Your Excel Budget. After you have your Total label, select everything in the Planned column and use the AutoSum feature to get your total for the month. 3 Type budget into the search bar, then press Enter. Here's Super Easy Tricks to Get You Started, 3 Easy Ways to Convert Microsoft Excel Data to Word, Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization, Unlock expert answers by supporting wikiHow, Een persoonlijk budget opstellen in Excel, Membuat Anggaran Pribadi Menggunakan Microsoft Excel. Grocery list budgeting. Bottom Line: This Excel tutorial teaches you how to create a full-blown personal budget management template in Excel. Follow these steps. STEP 2: Create a column, label it "Income," and list out all your sources of income. Well, apparently I replaced, Read More How to Make a Budget in Excel: Our Simple Step-by-Step GuideContinue. And Microsoft Excel automatically adds the other months respectively. Step 1: Open a Blank Workbook Your goal here is to create a zero-based budget where you account for every dollar you spend and earn. You can do this easily by subtracting the cell containing your total expenses from the one containing your total income. I hope this guide to creating a budget in Excel has been helpful. Similar to the personal budget template above, you have places for income and expenses but also with estimated and actual amounts. Making a budget spreadsheet template in Microsoft Excel has the advantage of being simple to download and use online. Last Updated: July 28, 2022 Note: on the Home tab, in the Font group, you can use the different commands to change the font size and font style of text. Finally, a Difference column in G3 will automatically keep track of the difference between your planned and actual income. 4. Plug that into the revenue section of the Excel spreadsheet. Were in public. Once you have a blank workbook, block off a chunk of columns to use as a heading for the month. Choose the template you want to use to see more details and click Create to open the template. You simply have to add the figures that are relevant to you and youre good to go. On Mac, first click File in the upper-left corner, then click New from Template in the drop-down menu. To calculate the total planned budget, input the formula =SUM(Planned Expenses Total, Planned Funds Total, Planned Savings Total). Heres how you can do it. Once your income section is figured out, its time to calculate your expenses. For more options, visit the Budget section of Microsofts Office Template site. Learn much more about templates > The budget dashboard will bring all your data together and enables the most insightful monitoring of your personal budget performance. For a simple and easier way of calculating the budgeted figures, an excel sheet is always advocated. Do the same for the actual spending and balance sections but instead use the actual totals. 1. The top section shows you your estimated and actual totals with the differences per month. 2. Make sure the rule is set to "Less than" and that the value is set to "0" (to look for cells that are less than . Tested. This ready-made template eases your task of manually creating a budget. This is a great way to save an entire years worth of spending in one Excel workbook. Go to Template > Generate to create an Excel file for this layout. 5. Your budgets will most likely turn out to be a little bit inaccurate, as there is almost always an expense that you'll forget about or have to add in later. If you created separate sheets for your spending, savings, and other funds, choose which sheet you want to put the total on. Find the income variance by subtracting the projected annual income from the actual annual income. Responses have not been reviewed, approved or otherwise endorsed by this website or our advertisers. Its as simple as that. By submitting your email, you agree to the Terms of Use and Privacy Policy. Finally, add formulas to calculate your total income and expenses for each month. Repeat this for each row of income. To achieve this, select cell B6, type an equal sign (=), enter SUM(, select the range B4:B5, close with a ")" and press Enter. 1. Excels budget templates are completely automated. Now you have a fresh canvas to start with. We'll be using $4,000 for illustrative purposes. Enter the SUM function into cell B6. Why do my budgets never turn out correct? You can use just red for the number or place the number in parentheses and make it red. Use it to try out great new products and services nationwide without paying full pricewine, food delivery, clothing and more. Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. Read More December Budget Breakdown and Savings UpdatesContinue. Part 2. 3 Into cell B1, type the date 01/31/16, or the current year if other than 2015. Next, click "Merge & Center" on the toolbar. Outstanding debt tracker. Still not sure how to get started budgeting? Enter the word "budget" into the search box and you'll see many options. As I reported a few months ago, I lost one fairly lucrative job andinstantly wenton the hunt for something to replace it. It includes an array of categories and subcategories, so you can set it up exactly how you'd like. Click Layouts to view the budget plan document layout configuration. It is not the responsibility of our advertisers or this website to ensure that all comments and/or questions are answered. Input your costs and income, and any difference is calculated automatically so you can avoid shortfalls or make plans for any projected surpluses. Youll also want to merge each row of B&C individually through row 11. Support wikiHow by Thankfully, you dont need to be an accountant to set up an Excel budget template. Spending Tracker. your main paycheck, your side gig, etc. Springboard America Review: Is It a Scam or Legit? Note: For those whose preferences go beyond what Excel can offer, you may choose from the pre-existing budget in excel templates in template.net. You can either do this on the same sheet or start a new sheet. RELATED: How to Create Expense and Income Spreadsheets in Microsoft Excel. Now, list down all your expenses under this heading. In fact, she says that she cant wait to go back tomorrow. You can then start adding the amounts for income and expenses starting with your current month. All Rights Reserved. 2. Depending on the software version you have, you may see an option to click on the "New from template" tab in a drop-down menu or "New tab." Clicking either tab changes the . However, you can add it at the bottom of however many sources of income you want to track. He holds two bachelor's degrees, is a licensed travel insurance agent in Indiana, and is the co-author of the book Zero Down Your Debt. California Consumer Privacy Act (CCPA) Policy. Variable Expenses. List down all sources of income like salary, dividends, etc. Here's a list of 100 expenses to account for in your budget to get you started. In this case, the formula looks as follows. As a small thank you, wed like to offer you a $30 gift card (valid at GoNift.com). The more you can focus, the quicker you can get it done. Select OK at the bottom to apply the change. The formula will automatically calculate the running balance after the addition of income in the next month. For Excel 2003 and earlier: Go to Format > Conditional Formatting. For the purpose of this tutorial, well make a basic monthly budget. Section F3 is your Actual column, and this represents the actual amount of money that hits the bank account hopefully more than you planned for. Savings goals. Find the annual projected and actual income by multiplying your answer in question 1 by 12. Its a great way to keep track of your money because it is so darn accurate. Then, use the borders tool on the workbooks Home tab (looks like a square divided into four) and choose All Borders. To make it even easier to read, you can also shade a few areas. The key is to make tracking your regular spending easy. Use the MAX function to see your most costly expense. Hit the 'Enter' key. 3. Make it as specific or vague as you want. Then, label one row Total Spending and another Final Balance. This is an easy way to help you track your spending so you can compare your planned totals to your actual totals. If youd like to add to the existing template, simply select where you want to add a box and right click. Fixed Expenses. Select the cell with the formula, use the fill handle to drag to the remaining columns, and release. Take a look at this neat personal monthly budget template that was created automatically. Open the Microsoft Excel program. Select the figures and add Accounting format to them to display numbers with a $ sign. This is also possible using templates in Google Sheets if you don't have access to Microsoft Excel. The "File" tab is on the top ribbon in Excel. Do this for both projected and actual monthly income to manage personal finance in Excel. Notice that the template also allows you to enter estimated cost as well as actual cost for an item. Confirm the cell range and press Enter or Return. This article was written by Samantha Gorelick, CFP and by wikiHow staff writer, Jack Lloyd. After making a budget, you have to track your expenses in order to stick to your plan, so we are going to start by tracking expenses as well. Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles. Since we are talking about budget here, you will need to put in figures for . Scroll down to Insert and choose to add either Table Columns to the Left or Table Rows Above. This should automatically sync the new information with the existing tabs. Learn more about editing legends and axes on a chart in Microsoft Excel here. Enter the word budget into the search box and youll see many options. Click on the right border of the column A header to increase the column width. On the right, pick one of the two red options in the Negative numbers box. Excel can be a crucial tool to transform your spending habits, so play around with it until youre comfortable. Open Excel. Next, highlight the category column and the percentage column simultaneously. Step 1: Opening a Workbook and Creating the First Month. Each department using the budget template for excel eases the calculation, and real editing cam be done to print . 2. You should use a spending tracker to keep track of each of your transactions during the month. Title the top, leftmost worksheet, "Actuals". This article was all about creating a budget and representing it graphically in Microsoft Excel. 4 Select cell range B1:M1. The Actuals are recorded at a detailed level, while the Budget is maintained at a higher level. When listing your expenses, you can customize the categories to your liking. If you arent sure where to begin, I strongly suggest starting with one of the softwares budget templates to get a feel for what you might want to include in your own budget. She learned how technology can enrich both professional and personal lives by using the right tools. Your website is great, but Im looking for a way to export my B of A data into an Excel spreadsheet instead of me retyping each exp/income every time I have a transaction. If youd like to see how much extra you saved than what you planned for, feel free to leave them in. In the example, I added a Funds and Savings section. Step 4: Setting up the budget to see a difference between actual and budgeted income/expense. The expenses for each month are created in a fresh new sheet within the same workbook. Enjoy! Its also a great option if youre a Money in Excel user and looking for a replacement for the vanishing service. Greg travels the world for about 20 weeks each year and has visited over 40 countries. It's at the top of the Excel window. followed it step by step. Then, to calculate your planned balance use the formula =SUM(Total Planned Spending Total Planned Income). {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9c\/Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg\/v4-460px-Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/9\/9c\/Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg\/aid1492711-v4-728px-Make-a-Personal-Budget-on-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"