---
description: Learn to manage your personal finance with Excel. Template to BUDGET personal finance with Excel is included.
title: Personal Finance Budget Template in Excel
image: https://www.guru99.com/images/personal-finance-budget-template-in-excel.png
---

[Skip to content](#main)

**⚡ Smart Summary**

Personal Finance in Excel turns a budget into a working model of projected and actual income and expenditure. This page explains the components of a personal finance system, builds income and expenditure sheets, computes variances, and visualizes the budget with a pie chart.

- 🎯 **Goal:** A personal finance system tracks money so that you spend less than you earn and save the surplus.
- 🧱 **Four Components:** Projected income, budget, actual income, and actual expenditure form the basic system.
- 📉 **Variance:** The gap between projected and actual figures measures how accurate the estimates and how disciplined the spending are.
- 📄 **Two Sheets:** One workbook records income, the other records the budget and expenditure.
- 🧮 **Formulas:** SUM totals each column, a subtraction gives the variance, and IF shows a comment on performance.
- 🎨 **Conditional Formatting:** Colours the comment red for a negative variance and green for a positive one.
- 🥧 **Chart:** A pie chart of the item and subtotal columns shows where the money goes.

Read More

![Personal Finance Budget Template in Excel](https://www.guru99.com/images/personal-finance-budget-template-in-excel.png)

“Money is a tool. Used properly it makes something beautiful- used wrong, it makes a mess!” – Bradley Vinson

It takes discipline to use money properly. In this tutorial, we are going to look at how to use Excel for personal finance to properly manage our budget and finances. We will cover the following topics.

## Why manage Budget?

Let’s face it, the world we live in is fuelled by money. We go to school to get a good job, engage in business and other related activities with the main goal of making money. If we do not manage our personal finances properly, then all of our efforts go to waste.

Most people spend more than they earn. In order to be financially successful, one needs to develop a habit of spending less than they earn and invest the surplus in business ventures that will multiply the invested money

## Major components of a personal finance system

This is a basic personal finance system so we will consider the following components;

1. **Projected income** – this is the money that you expect to earn now and in the future.
2. **Budget** – this is a list of the items that you expect to buy, quantities and their respective prices
3. **Actual income** – this is the actual money that you earn as time progresses
4. **Actual expenditure** – this is the money that you actually spend buying things

The variance between the projected income and actual income gives us the performance indicator of how accurate our estimates are or how hard we are working.

The variance between the budget and the actual expenditure give us the performance indicator of how disciplined we are when it comes to sticking to a budget.

Since saving is a part of the goal of having a personal finance system, the actual income vs. the actual expenditure say on a monthly basis gives us an idea of how much we would save over a year.

## Using Excel to set personal budgets, and record income and expenses

We have looked at the components of a personal finance system, and we will now use what we have learnt so far to implement the above personal finance Excel workbook. We will create two workbooks for this Excel for personal finance tutorial, one for income and the other for budgets.

When you are done with this tutorial, your workbooks should look as follows

[![Using Excel to Set Personal Budgets, Record Income and Expenses]()](https://www.guru99.com/images/5-2015/050215_1007_CaseStudyMa1.png)

[![Using Excel to Set Personal Budgets, Record Income and Expenses]()](https://www.guru99.com/images/5-2015/050215_1007_CaseStudyMa2.png)

Here are the steps on how to create a personal budget in [Excel](https://www.guru99.com/introduction-to-microsoft-excel.html):

Open Excel and create a new workbook

### Income sheet

- Rename the Sheet1 to Income
- Enter the data shown below
- Projected Monthly Income

| S/N | Description | Amount ($) |
| --- | --- | --- |
| 1 | Salary | 600.00 |
| 2 | Freelance works | 250.00 |
| 3 | Others | 180.00 |
| **Grand Total** |  | |
|  |  | |
| **Expected annual income:** |  | |

**Actual Income**

| S/N | Description | Amount ($) |
| --- | --- | --- |
| 1 | Salary | 600.00 |
| 2 | Freelance works | 200.00 |
| 3 | Others | 150.00 |
| **Grand Total** |  | |
|  |  | |
| **Actual annual income:** |  | |

**Don't Miss:**

- [How to Create Charts in Excel: Types & Examples](https://www.guru99.com/visualizing-data-using-charts-in-excel.html)
- [How to Open & Convert XML File to Excel](https://www.guru99.com/connecting-microsoft-excel-to-external-data-sources.html)
- [How to Convert CSV File to Excel](https://www.guru99.com/import-csv-data-excel.html)
- [10 Best FREE Microsoft Courses with Certification Online (2026)](https://www.guru99.com/free-microsoft-courses-certifications.html)

### Formulas for Income sheet

We will now need to;

1. Calculate the monthly income for both projected and actual income.
2. Compute the projected annual income and actual annual income based on the monthly total.
3. Find the variance between the actual and project annual income
4. Show tips on how we are doing using logical functions
5. Use conditional formatting to highlight how well we are managing our finances

### Tutorial Exercise 1

1. Find the sum of all monthly income sources. Use the **SUM** function. Do this for both projected and actual monthly income to manage personal finance in Excel.
2. Find the annual projected and actual income by multiplying your answer in question 1 by 12.
3. Find the income variance by subtracting the projected annual income from the actual annual income.
4. Add a comments row just below the tables. Use the IF functions to display “You need to work extra hard to meet your income targets” if the variance is less than zero (0) else display “Great job working smart and harder”.
5. Use conditional formatting to change the text colour to red if the variance is less than 0 else change the text colour to green.

If you are stuck on what to do, read the articles on [formulas and functions](https://www.guru99.com/introduction-to-formulas-and-functions-in-excel.html), and Visualizing data using charts in Excel.

### Expenditure sheet

Add a new sheet and rename it to Expenditure

Enter the data as shown below

**Budget**

| S/N | Item | Qty | Price | Subtotal |
| --- | --- | --- | --- | --- |
| 1 | Rentals | 12 | 210.00 | |
| 2 | Bills | 12 | 100.00 | |
| 3 | Groceries | 12 | 230.00 | |
| 4 | School | 2 | 500.00 | |
| 5 | Miscellaneous | 6 | 133.00 | |
| **Grand Total:** |  |  |  | |
| **Expected Annual savings:** |  |  |  | |

**Actual income**

| S/N | Description | Qty | Price | Subtotal |
| --- | --- | --- | --- | --- |
| 1 | Rentals | 12 | 210.00 | |
| 2 | Bills | 12 | 145.00 | |
| 3 | Groceries | 12 | 240.00 | |
| 4 | School | 2 | 500.00 | |
| 5 | Miscellaneous | 6 | 233.00 | |
| **Grand Total:** |  |  |  | |
| **Actual Annual Savings:** |  |  |  | |

### Formulas for Expenditure sheet

We will need to;

1. Calculate the subtotal
2. Calculate the grand total based on sub totals
3. Compute the expected annual savings. The expected annual savings is the difference between the projected annual income and the budget total amount. This will be done for the actual income and actual expenditure too.
4. Compute the monthly savings variance
5. Add a comments row just below the tables. Use the IF functions to display “You need to minimize your expenses.” if the variance is less than zero (0) else display” Great job sticking to the budget”.
6. Use conditional formatting to change the text colour to red if the variance is less than 0 else change the text colour to green.

**Tutorial exercise 2**

Write formulas that implement the above scenarios.

## Visualizing the data using charts

Charts are a great way of visualizing our data. We will now add a pie chart to our income sheet for the projected monthly income. The image below shows our data

[![Visualizing the Data using Charts]()](https://www.guru99.com/images/5-2015/050215_1007_CaseStudyMa3.png)

As marked in the above image our chart should only show the data for

1. Item column
2. Subtotal column

Highlight items **1 to 5 in Item column**

Hold Ctrl button on the keyboard and highlight the subtotals from **1 to 5 in subtotals column**.

Your selection should look as shown in the image below

[![Visualizing the Data using Charts]()](https://www.guru99.com/images/5-2015/050215_1007_CaseStudyMa4.png)

Click on INSERT tab from main menu

[![Visualizing the Data using Charts]()](https://www.guru99.com/images/5-2015/050215_1007_CaseStudyMa5.png)

- Use the charts ribbon bar, click on the pie chart drop down and select a pie chart of your choice.
- Your pie chart should now look similar to the one shown below

[![Visualizing the Data using Charts]()](https://www.guru99.com/images/5-2015/050215_1007_CaseStudyMa6.png)

### Tutorial exercise three

Create charts for the actual expenditure, projected income, and actual income

[Download Excel Budget Template](https://docs.google.com/spreadsheets/d/1Onhju1vL3zbQSiZH3sMPBjGVdWjLds4q/export?format=xlsx)

## FAQs

⚡ What is a budget variance?

A budget variance is the difference between a planned figure and the actual figure. A positive variance on income or savings is good, while a negative variance shows you earned less or spent more than planned.

🎨 How does conditional formatting help a budget?

Conditional formatting changes the colour of a cell based on a rule, so a negative variance turns red and a positive one turns green. The status of the budget is then visible at a glance without reading the numbers.

📆 Why multiply the monthly total by 12?

The monthly total is multiplied by 12 to project the annual figure, because there are twelve months in a year. It gives a quick yearly estimate that is then compared with the actual annual income.

🤖 Can AI build a personal budget in Excel?

Yes. AI features such as Copilot in Excel build the income and expenditure tables, add the SUM and variance formulas, and set the conditional formatting from a plain description. The user checks the figures and the rules.

🧠 Can AI give advice from my budget figures?

Yes. AI assistants read the variances and point out where spending exceeds the budget, then suggest categories to reduce. The advice is general, so the user still decides what to change in the plan.

#### Summarize this post with:

ChatGPTPerplexityGrokGoogle AI

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.**

##### Sign up for the newsletter

Subscribe for Free

You have successfully subscribed.  
Please check your inbox.

![AI-Newsletter]() Chosen by over **350,000+** professionals

[Scroll to top](#wrapper)

×

Search for:

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/personal-finance-budget-template-in-excel.png","url":"https://www.guru99.com/images/personal-finance-budget-template-in-excel.png","width":"700","height":"250","caption":"Personal Finance Budget Template in Excel","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/excel","name":"Excel"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html","name":"Personal Finance Budget Template in Excel"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html#webpage","url":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html","name":"Personal Finance Budget Template in Excel","dateModified":"2026-10-10T13:01:51+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/personal-finance-budget-template-in-excel.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"Excel","headline":"Personal Finance Budget Template in Excel","description":"Learn to manage your personal finance with Excel. Template to BUDGET personal finance with Excel is included.","keywords":"excel","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-10T13:01:51+05:30","image":{"@id":"https://www.guru99.com/images/personal-finance-budget-template-in-excel.png"},"copyrightYear":"2026","name":"Personal Finance Budget Template in Excel","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is a budget variance?","acceptedAnswer":{"@type":"Answer","text":"A budget variance is the difference between a planned figure and the actual figure. A positive variance on income or savings is good, while a negative variance shows you earned less or spent more than planned."}},{"@type":"Question","name":"How does conditional formatting help a budget?","acceptedAnswer":{"@type":"Answer","text":"Conditional formatting changes the colour of a cell based on a rule, so a negative variance turns red and a positive one turns green. The status of the budget is then visible at a glance without reading the numbers."}},{"@type":"Question","name":"Why multiply the monthly total by 12?","acceptedAnswer":{"@type":"Answer","text":"The monthly total is multiplied by 12 to project the annual figure, because there are twelve months in a year. It gives a quick yearly estimate that is then compared with the actual annual income."}},{"@type":"Question","name":"Can AI build a personal budget in Excel?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI features such as Copilot in Excel build the income and expenditure tables, add the SUM and variance formulas, and set the conditional formatting from a plain description. The user checks the figures and the rules."}},{"@type":"Question","name":"Can AI give advice from my budget figures?","acceptedAnswer":{"@type":"Answer","text":"Yes. AI assistants read the variances and point out where spending exceeds the budget, then suggest categories to reduce. The advice is general, so the user still decides what to change in the plan."}}]}],"@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html#schema-1144717","isPartOf":{"@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/case-study-managing-personal-finance-using-microsoft-excel.html#webpage"}}]}
```