#Best monthly budget planner excel how to

This tells us in-depth how much we expect to spend per item in our category, how much it costs, and the difference in price between our expected cost of the item versus the actual cost.įor instance, if we have a table of housing categories, we could use it to group expenses such as rent, utilities, and supplies. To Calculate the subtotal of the difference column: We want to use the formula sum(entire column of the sub-total categories). To Calculate the difference: We want to use the formula PROJECTED COST – ACTUAL COST. In the “Actual Cost” column, enter the amount you actually spend on each expense each month. In the “Projected Cost” column, enter the amount you plan to spend on each expense. For example, if you budgeted $500 for groceries but only spent $450, the difference would be -$50. In the “Difference” column, enter a formula to calculate the difference between the budgeted amount and the actual amount for each expense. In this category, We want a main category and sub-category with the following columns, which are “projected cost”, “actual cost,”, and “difference,” and at the bottom of the difference column, you want to sum the entire values. We need to create our expense categories now that we have our spreadsheet. Choose a location on your computer or device where you want to save the workbook, and then click on the “Save” button.In the “Save As” window, enter a descriptive name for your workbook in the “File name” field, such as “Monthly Budget” or “Personal Finance Tracker.”.To give it a descriptive name, click on the “File” menu again, and then select “Save As” from the drop-down menu. Your new workbook will open in a new window.In the “New” window, select “Blank workbook” from the list of templates.Click on the “File” menu at the top of the screen, and then select “New” from the drop-down menu.Open Microsoft Excel on your computer or device.

To create a new Excel workbook with a descriptive name, follow these steps: Most importantly it allows you to understand its significance, so make sure the name is memorable and saved at a place where you’ll access it easily! A descriptive name will also help you remember what the workbook contains, so you can quickly and easily refer to it when needed.įor example, if you name your workbook “Monthly Budget,” you will know at a glance that it contains your monthly budget information, and you can easily open it to review your income and expenses or make updates to your budget. It is important to create a workbook with a descriptive name because it will help you to easily find and access your budget spreadsheet in the future.

#Best monthly budget planner excel how to

How To Create A Monthly Budget Spreadsheet Step 1: Create a new Excel workbook with a descriptive nameīefore, we get started we need to firstly create an excel workbook and save it with a descriptive name.

Step 5: Duplicate your worksheet for each month.

Step 5: Make a summary of your monthly balance.

Step 4: Create your monthly Income section.

Step 3: Make a summary section of your expenses.

Step 1: Create a new Excel workbook with a descriptive name.

How To Create A Monthly Budget Spreadsheet.