How to Create a Simple Financial Plan in Excel to Track Income, Savings, and Expenses

Managing your finances doesn’t have to be complicated. With a simple Excel financial plan, you can easily track your income, expenses, and savings—helping you stay on top of your financial goals.

Whether you’re budgeting for personal use or running a small business, this guide will walk you through the exact steps to set up your financial plan in Excel.

Why You Need a Financial Plan

Tracking your money allows you to:

✅ Understand where your money goes – Avoid unnecessary spending.

✅ Save consistently – Build an emergency fund or invest.

✅ Stay financially organized – Make better financial decisions.

✅ Plan for the future – Reach your financial goals faster.

Step-by-Step Guide to Creating an Excel Financial Plan

Step 1: Set Up Your Excel Sheet

Open Microsoft Excel (or Google Sheets).

In Row 1, create column headers:Date, Income Source, Income Amount Expense Category, Expense Amount Savings Amount

Tip: Use bold formatting to make headers stand out.

Step 2: Enter Your Financial Data

Income Source: Record all money coming in (salary, side hustle, passive income).

Income Amount: How much you received.

Expense Category: Categorize expenses (rent, food, transport, entertainment, etc.).

Expense Amount: Record how much you spent.

Savings Amount: Track the portion of your income you’re saving.

Step 3: Automate Calculations with Formulas

To make tracking easier, use these simple Excel formulas:

✅ Total Income:=SUM(C2:C100)

✅ Total Expenses:=SUM(E2:E100)

✅ Total Savings:=SUM(F2:F100)

✅ Balance after Expenses & Savings:Copy code=C2 – (E2 + F2)

Copy these formulas down the column to track your balance automatically!

Step 4: Add a Monthly Summary Section

At the bottom of your sheet, create a summary table:Category Total Amount

Total Income =SUM(C2:C100)

Total Expenses =SUM(E2:E100)

Total Savings =SUM(F2:F100)

Net Balance =C2 – (E2 + F2)

Step 5: Create Visual Charts (Optional)Want a clearer view of your finances?

Create charts in Excel:Highlight Income & Expense columns

Click Insert > Chart Choose a Pie Chart or Bar Graph.

This will help you see where your money is going at a glance!

Free Excel Template Download

To make things easier, I’ve created a ready-to-use Excel financial plan template for you!

👉 Download the Financial Plan Template (Free)

A simple financial plan in Excel can transform your money habits by helping you save more and spend wisely. The best part? It only takes a few minutes to update!

What’s your biggest financial challenge? Drop a comment below! If you found this helpful, share it with a friend who needs to track their finances!

Bookmark this page and start tracking your money today.

Follow ThriveNest360 for more finance and money-saving tips!