✦Template Printable Ideas Insights

Youtube: Step-by-Step Guide to Create a Budget in Excel

By

Diving into the world of personal finance, today we're going to tackle a crucial skill: creating a budget in Excel. Whether you're managing your own finances or taking on a budgeting role at work, Excel is an invaluable tool for tracking and understanding your finances. Let's break it down into simple, step-by-step instructions.

Before we dive in, ensure you have Excel installed on your computer, and familiarize yourself with the basic layout and functions. We'll be using Microsoft Excel for this guide, but most of these steps apply to other spreadsheet programs like Google Sheets or LibreOffice Calc.

Setting Up Your Budget Spreadsheet

First, we need to create a new blank workbook in Excel. Click on 'File', then 'New', and select 'Blank workbook'. Name it 'Budget' or something similarly descriptive.

Free Monthly Budget Excel Spreadsheet
Free Monthly Budget Excel Spreadsheet
How to Create a Budget in Excel
How to Create a Budget in Excel
How to Build Your Own Budget in Google Sheets | Step-by-Step Tutorial for Beginners
How to Build Your Own Budget in Google Sheets | Step-by-Step Tutorial for Beginners

Next, let's set up the basic structure of your budget. In the first row, starting from Column A, list the following headers: 'Category', 'Planned', 'Actual', 'Difference', and 'Percent of Income'. These will help you categorize, plan, track, and analyze your budget.

Categories: The Building Blocks of Your Budget

Beneath these headers, starting from Row 2, list all your expenses in Column A. These can include savings, groceries, rent, utilities, entertainment, and so on. Be as comprehensive as possible. For now, we're just creating a list; we'll fill in the amounts later.

How to Create a Budget in Excel and Understand Your Spending
How to Create a Budget in Excel and Understand Your Spending
How to create Ultimate Personal Budget in Excel
How to create Ultimate Personal Budget in Excel
Step-By-Step Guide to Budgeting in Excel (FREE Template)
Step-By-Step Guide to Budgeting in Excel (FREE Template)

Each category represents a 'row' in your budget, and each of these rows will interact with the totals in a way that lets you track and analyze your spending patterns. So, take your time and ensure you've covered everything.

Adjusting Your Budget for Income

Now, let's focus on your income. In Row 16 or so, add a 'Total' category at the top. Below it, in Column B, start listing your income sources - salary, freelance work, side hustles, investments, etc. If you're managing a business, this is where you'll also add your revenue.

Each income source gets its own row, just like your expenses do. Don't forget to include any tax deductions or savings from your income, like your 401(k) or other pre-tax contributions.

Create a monthly budget in Excel
Create a monthly budget in Excel
How to Make a Budget in Excel - Aux. 1
How to Make a Budget in Excel - Aux. 1
How to Make a Budget Spreadsheet - Frugal Financiers
How to Make a Budget Spreadsheet - Frugal Financiers
How to Create a Budget in Excel (Even if You’re Spectacularly Bad at Excel)
How to Create a Budget in Excel (Even if You’re Spectacularly Bad at Excel)
How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable Expenses
How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable Expenses
How to Make a Budget in Google Sheets
How to Make a Budget in Google Sheets

Planned vs. Actual: Tracking Your Budget

With your categories and income set up, it's time to start planning your budget. In Column B, enter the amount you plan to spend or earn for each category. This is your 'Planned' amount. We'll use these figures to calculate your 'Percent of Income'.

Now, as the month progresses, update Column C ('Actual') with how much you've actually spent or earned. This will allow you to compare your planned expenses with reality, and see how well you're sticking to your budget.

Calculating Your 'Difference' And 'Percent of Income'

Difference is straightforward: just subtract 'Actual' from 'Planned'. If the result is positive, you've spent more than planned. If it's negative, you've underspent.

How to Create a Budget in Excel
How to Create a Budget in Excel
How To Make A Budget On Google Sheets in 2026 (+ Examples)
How To Make A Budget On Google Sheets in 2026 (+ Examples)
Beginners Guide to Building a Basic Home Budget Spreadsheet in Excel
Beginners Guide to Building a Basic Home Budget Spreadsheet in Excel

Percent of Income is a bit more complex. It tells you what percent of your income each expense represents. In the 'Percent of Income' row for each category, enter `= C2 / B16`, with cell B16 being your total income. Adjust the cell references as needed for your specific rows.

Totaling Up Your Budget

Finally, at the bottom, add up all the 'Planned', 'Actual', 'Difference', and 'Percent of Income' columns to give you a complete picture of your budget. You can use Excel's built-in SUM function for this. This will help you see where you're over or underbudgeting, and where you might need to make adjustments.

That's it! You're now well on your way to mastering your budget with Excel. Keep updating your sheet as the month goes on, and watch your financial health improve. Happy budgeting!