Best Excel Formulas for Budget Tracking — 12 Essential Formulas

Managing your personal finances doesn't require expensive software. With just 12 Excel formulas, you can build a complete budget tracker that rivals any paid app. Whether you're tracking household expenses, saving for a goal, or paying off debt — these formulas are your foundation.

Setting Up Your Budget Spreadsheet

Before using formulas, structure your data with these columns:

Column A: Date
Column B: Category (Groceries, Rent, Transport, etc.)
Column C: Description
Column D: Type (Income or Expense)
Column E: Amount

Formula 1: SUM — Total Monthly Spending

=SUM(E2:E100)

Adds all amounts. Use for total income, total expenses, or total savings.

Formula 2: SUMIF — Spending by Category

=SUMIF(B:B, "Groceries", E:E)

Adds amounts only where category = "Groceries". Repeat for each category.

Formula 3: SUMIFS — Multi-Condition Totals

=SUMIFS(E:E, B:B, "Groceries", D:D, "Expense")

Total grocery expenses only (excluding refunds). Multiple conditions in one formula.

Formula 4: AVERAGEIF — Typical Spending

=AVERAGEIF(B:B, "Groceries", E:E)

Average grocery spending per transaction. Spots unusual expenses.

Formula 5: MAXIFS — Biggest Single Expense

=MAXIFS(E:E, B:B, "Groceries")

Largest grocery transaction. Useful for catching one-off big purchases.

Formula 6: COUNTIF — Transaction Frequency

=COUNTIF(B:B, "Restaurant")

How often did you eat out? Counting reveals habits that totals hide.

Formula 7: IF — Budget Status Alert

=IF(SUMIF(B:B,"Groceries",E:E)>500,"Over budget ⚠️","On track ✅")

Automatic alert when spending exceeds your set limit.

Formula 8: Percentage of Income

=SUMIF(B:B,"Rent",E:E)/SUMIF(D:D,"Income",E:E)

Format as percentage. Shows what % of income goes to rent. Target: under 30%.

Formula 9: Running Balance

=F1 + IF(D2="Income", E2, -E2)

Daily cash flow tracker. Shows exact balance on any given day.

Formula 10: DATEDIF — Days Until Savings Goal

=DATEDIF(TODAY(),"2026-12-31","D")

Days remaining to reach a savings goal. Updates automatically every day.

Formula 11: Monthly Totals

=SUMIFS(E:E,D:D,"Expense",A:A,">="&DATE(2026,1,1),A:A,"<="&DATE(2026,1,31))

Total January 2026 expenses only. Build monthly comparison tables.

Formula 12: Net Savings Rate

Total Income: =SUMIF(D:D,"Income",E:E)
Total Expenses: =SUMIF(D:D,"Expense",E:E)
Net Savings: =Income - Expenses
Savings Rate: =Net_Savings/Total_Income (format as %)

💡 Pro Tip

Start with just 4 formulas: SUM, SUMIF, IF, and AVERAGEIF. These 4 cover 80% of personal budgeting needs. Add the rest as your tracking becomes more detailed.

The 50/30/20 Rule in Excel

The popular budgeting rule — 50% needs, 30% wants, 20% savings — is easy to track:

Needs %: =SUMIFS(E:E,B:B,"Rent",D:D,"Expense")/Income_Total
Wants %: =SUMIFS(E:E,B:B,"Restaurant",D:D,"Expense")/Income_Total
Savings %: =Net_Savings/Income_Total