How To Make A Budget In Spreadsheet

A few years ago, I found myself staring at a stack of credit card statements, a grocery receipt. A rent invoice, all of which added up to more than I made in a month. That moment was a wake-up call. I knew I needed to take control of my money, but I had no idea where to start. After some research and trial and error, I discovered that making a budget using a spreadsheet was the most practical, flexible, and empowering way to do it. It wasn't about strict rules or complicated formulas — it was about understanding where my money was going and where it needed to go.^[1]

The process of creating a budget in a spreadsheet was like building a puzzle — each piece mattered, and the picture only made sense when everything fit. I used an Excel file I had on my laptop, and within a few hours, I had a clear view of my income, my expenses, and where I could cut back. It was surprising how much I was spending on small, daily purchases. The spreadsheet didn't just help me track money; it helped me build habits. I didn't feel like I was being forced into austerity — I felt in control, which made all the difference.^[4]

Since that time, I've been helping others create budgeting spreadsheets, and I’ve learned that the key is to be specific, honest, and consistent. The best spreadsheets are not the ones with the fanciest formulas, but the ones that are tailored to your life. Whether you're a new graduate, a parent, or a freelancer, this method can help you take charge of your finances. Making a budget in a spreadsheet is not just about numbers; it's about clarity, freedom, and the peace of mind that comes with knowing where your money is going.

Getting Started: The Basics of a Budget Spreadsheet

As of September 2026, to begin, I recommend opening a new Excel or Google Sheets file and labeling the first sheet 'Income' and the second 'Expenses'. In the 'Income' sheet, list all of your sources of income — your salary, freelance payments, any side gigs, and even passive income like dividends or rental income. Be sure to note the frequency of each, whether it's monthly, weekly, or irregular.^[2]

In the 'Expenses' sheet, list all of your spending categories — rent, utilities, groceries, transportation, insurance, and so on. I found that breaking down expenses into subcategories, like 'groceries' under 'food', or 'entertainment' under 'social', helped me see where I was overspending. I used a simple formula to calculate my total income and total expenses, which made it easy to see if I was living within my means or overspending.

Once you've categorized your expenses, you can begin entering your actual spending. I used different colors to highlight different categories, which made the spreadsheet more visually engaging and easier to read. After a few weeks of tracking, I could see which areas of my life needed more attention — and that was the first step toward making real changes.

Part of our Budgeting for beginners step by step guides guide.

The Magic of the 50/30/20 Rule

The 50/30/20 rule is a simple but powerful guideline for budgeting. It divides your income into three categories: 50% for needs, 30% for wants, and 20% for savings and debt repayment. I found that applying this rule to my own budget helped me prioritize my spending in a way I hadn’t before.^[3]

Needs include essentials like rent, utilities, groceries, and transportation. Wants are things like dining out, entertainment, and shopping. Savings and debt repayment cover things like emergency funds, retirement accounts, and credit card payments. By following this rule, I was able to balance my spending without feeling restricted.

I started by calculating my monthly income and then dividing it by 0.5, 0.3, and 0.2. This gave me clear targets for each category. I used color-coding to highlight these areas in my spreadsheet, which made it easier to see if I was staying within my limits. After a few months, I found myself naturally spending less on wants and more on savings — all without feeling deprived.

The 50/30/20 rule isn't a one-size-fits-all solution, but it’s a great starting point for financial clarity.

Related: Budgeting for beginners guides for beginners

Using Formulas for Automation

One of the most valuable aspects of using a spreadsheet is the ability to automate calculations. Instead of manually totaling your expenses each time, you can use formulas to calculate totals, track progress, and set alerts. I used the SUM function to automatically calculate my total income and expenses, which made the process much quicker.

I also used formulas to calculate how much I was spending in each category. For example, I created a formula that added up all my grocery expenses and displayed the total in a separate cell. I used conditional formatting to highlight any categories where I exceeded my budget, which made it easy to spot areas where I needed to adjust.

By automating these calculations, I saved a lot of time and was able to focus more on analyzing my spending patterns. I also used formulas to track my savings progress, which kept me motivated to stay on track with my financial goals.

“A few years ago, I found myself staring at a stack of credit card statements, a grocery receipt, and a rent invoice, all of which…”— Budgetlearner editors

Related: Best budgeting for beginners guides

Tracking Your Progress

Once your spreadsheet is set up, the next step is to use it consistently. I made it a habit to update my spreadsheet every week, which helped me stay on top of my spending and track my progress toward my goals. By the end of the month, I could see how much I had spent in each category and compare it to my budget.

I also used my spreadsheet to track my savings. I set a target for my emergency fund and tracked how much I had saved each month. This kept me motivated and gave me a clear sense of accomplishment when I hit my goals. I used charts to visualize my progress, which made it easier to see where I was doing well and where I needed to improve.

Over time, I noticed that I was getting better at sticking to my budget. I was able to cut back on unnecessary expenses and increase my savings. Tracking my progress not only helped me save money but also gave me a sense of control over my finances.

Related: Simple budgeting for beginners step

Adjusting for Irregular Income

For people with irregular income, like freelancers or gig workers, budgeting can be a bit more challenging. However, a spreadsheet can still be a powerful tool. I used my spreadsheet to track my income over the course of a few months, which gave me an average that I could use as a base for my budget.

I also created a separate sheet for monthly projections, where I estimated my income and expenses based on past patterns. This helped me plan for months when my income was lower and adjust my spending accordingly. I used formulas to calculate my average income and expenses, which made it easier to set realistic goals.

By using my spreadsheet to track my income and expenses over time, I was able to create a more flexible budget that worked for my lifestyle. I also used it to plan for unexpected expenses, which gave me more peace of mind and helped me avoid going into debt.

Related: Budgeting for beginners step for small spaces

Setting Financial Goals

One of the best things about using a spreadsheet is that it allows you to set and track financial goals. Whether it's saving for a vacation, paying off debt, or building an emergency fund, having a clear target in mind can keep you motivated.

I used my spreadsheet to track my progress toward my savings goals. I created a separate section where I listed my goals, along with the amount I needed to save and the time frame I had set. I used formulas to calculate how much I needed to save each month to reach my goals, which made it easier to stay on track.

Over time, I saw how my small savings added up, and that gave me a sense of accomplishment. I also used charts to visualize my progress, which made it easier to see how close I was to reaching my goals. Setting financial goals in my spreadsheet not only helped me save money but also gave me a sense of purpose and direction.

Setting financial goals in your spreadsheet gives you a roadmap to follow — and it keeps you motivated along the way.

Related: Budgeting for beginners step by step guides for small spaces

Keeping Your Budget Updated

To keep your budget effective, it's important to update it regularly. I made it a habit to review my spreadsheet every week and update my expenses and income as needed. This helped me stay on top of my spending and track my progress toward my goals.

I also used my spreadsheet to set reminders for myself. For example, I created a column for upcoming bills and used the 'Today' function to highlight any bills that were due soon. This made it easier to stay on top of my payments and avoid late fees.

By keeping my spreadsheet updated, I was able to make adjustments as needed and stay on track with my financial goals. I also used it to plan for unexpected expenses, which gave me more peace of mind and helped me avoid going into debt.

How To Make A Budget In Spreadsheet