Free Budget Expense Tracker Spreadsheet: Excel Guide

How-to basics · Updated November 21, 2026

Yes. You can make a free budget expense tracker spreadsheet in Excel by creating a transaction log, a monthly budget by category, and a summary that uses SUMIFS formulas to total income and expenses. The template below uses ordinary worksheet cells and built-in Excel features; you do not need to buy a budgeting template, though using the Excel desktop app may require a license.

What a budget and expense tracker does

A budget tracker compares the money you planned to spend with what you actually spent. An expense tracker records purchases and bills as they happen. Putting both jobs in one workbook lets you see whether a category is on track and how much money remains for the month.

A spreadsheet is useful when you want to define your own categories, review individual transactions, or avoid connecting a budgeting service to a bank account. It will not automatically know about purchases: you need to enter or import transactions and check them against statements. The numbers are only as current and complete as the data you provide.

The workbook described here has three sheets:

  • Transactions: a record of income and expenses, one transaction per row.
  • Budget: monthly planned amounts and actual spending for each category.
  • Summary: totals for a selected month and a simple remaining-balance calculation.

Set up the transaction log

In a blank workbook, rename the first sheet Transactions. Add these headings in row 1: Date, Description, Category, Type, Amount, and Account. Enter each transaction on a new row, using actual Excel dates in the Date column and positive numbers in Amount. Set Type to Income or Expense. Keeping amounts positive makes the meaning of each entry clear; the Type field determines which total includes it.

For example, a grocery purchase might have a date of January 8, a description of Groceries, category Groceries, type Expense, amount 82.40, and account Debit card. A paycheck would use type Income and an appropriate category such as Pay. Use a consistent spelling for categories. “Dining out,” “Dining,” and “Restaurants” will be treated as three different labels by a formula.

For easier sorting and filtering, select the header and data area and choose Insert > Table in Excel for Microsoft 365 on Windows. Confirm that the table has headers. A table can expand as you add rows and provides filter controls; the formulas below use rows 2 through 1000, so increase those ranges if your log grows beyond row 1000. On Excel for the web, the table command is also available from Insert, though the ribbon layout can vary.

Create a monthly budget by category

On a second sheet named Budget, enter category names in column A, planned monthly amounts in column B, actual spending in column C, and the amount remaining in column D. Put the headers in row 1. Example categories might include Housing, Utilities, Groceries, Transportation, Insurance, Phone, Dining, and Household. Make a separate row for any category you want to monitor independently.

Enter the selected month’s first day in Summary cell B1, for example January 1, 2026. Format B1 as a date. With transaction dates in Transactions!A2:A1000, categories in Transactions!C2:C1000, types in Transactions!D2:D1000, amounts in Transactions!E2:E1000, and the category name in Budget!A2, put this formula in Budget!C2 and copy it down: =SUMIFS(Transactions!$E$2:$E$1000,Transactions!$D$2:$D$1000,"Expense",Transactions!$C$2:$C$1000,$A2,Transactions!$A$2:$A$1000,">="&Summary!$B$1,Transactions!$A$2:$A$1000,"<"&EDATE(Summary!$B$1,1)). The formula totals expenses in that category from the first day of the selected month up to, but not including, the first day of the next month. If January groceries total $460, C2 returns 460.

With planned amounts in Budget!B2:B20 and actual amounts in Budget!C2:C20, enter =B2-C2 in Budget!D2 and copy down. If the groceries budget is $500 and actual spending is $460, D2 returns $40. A negative result means spending is over the planned amount; it is not an error. Format the budget and amount columns as Currency or Accounting using Home > Number Format.

Build the monthly summary formulas

On a third sheet named Summary, label B1 Selected month and enter the first day of the month there. The formulas below assume dates in Transactions!A2:A1000, transaction types in D2:D1000, and amounts in E2:E1000. They use the first day in B1 as the start of the period and EDATE to find the next month, which avoids missing transactions late in months of different lengths.

With the date, type, and amount columns in those locations and Summary!B1 set to January 1, 2026, enter this in Summary!B3 for income: =SUMIFS(Transactions!$E$2:$E$1000,Transactions!$D$2:$D$1000,"Income",Transactions!$A$2:$A$1000,">="&$B$1,Transactions!$A$2:$A$1000,"<"&EDATE($B$1,1)). If the January log contains $3,500 of income, B3 returns $3,500.

With the same transaction layout and selected month, enter this in Summary!B4 for expenses: =SUMIFS(Transactions!$E$2:$E$1000,Transactions!$D$2:$D$1000,"Expense",Transactions!$A$2:$A$1000,">="&$B$1,Transactions!$A$2:$A$1000,"<"&EDATE($B$1,1)). If the example month includes rent of $1,400, utilities of $180, groceries of $460, transportation of $220, insurance of $160, phone of $60, dining of $120, and household spending of $140, the total is $2,740.

With income in Summary!B3 and expenses in Summary!B4, enter =B3-B4 in Summary!B5 and label it Income minus expenses. The example returns $760 because $3,500 minus $2,740 equals $760. This is a simple monthly difference, not necessarily the same as a bank balance: it does not account for opening balances, transfers, pending transactions, or other accounts unless you add those items to your design.

Make the sheet easier to use

Small design choices reduce entry errors and make the workbook easier to review. Consider these setup steps:

  • Freeze the transaction headings with View > Freeze Panes > Freeze Top Row so they stay visible while scrolling.
  • Use Data > Data Validation to make a list for Type with the allowed entries Income and Expense. You can also use a list for common categories, but update it when you add categories to the Budget sheet.
  • Use Home > Conditional Formatting to highlight negative remaining amounts in Budget column D. For example, Home > Conditional Formatting > Highlight Cells Rules > Less Than lets you set a visible warning for values below zero.
  • Format dates as dates and money as currency, and avoid typing currency symbols directly into numeric cells.
  • Keep a separate category for irregular spending, or add a note in Description for unusual one-off costs, so they do not disappear into an unexplained total.

Excel for Microsoft 365 on Windows has the ribbon paths listed above. Excel for Mac has the same core features, but the ribbon and dialogs may be arranged somewhat differently. Excel for the web supports ordinary formulas and basic workbook editing, but some desktop interface details and advanced features differ. If you use the web version, check the relevant Home, Insert, Data, or View tab for the corresponding command.

Keep monthly records accurate

Choose a routine for entering transactions, such as updating the log once or twice a week. Reconcile the entries with account statements or transaction exports. If you import a CSV file, inspect the date and amount columns: dates may be interpreted differently depending on regional settings, and imported amounts may arrive as text instead of numbers. A number stored as text may not be included in a sum.

Decide how to handle refunds and transfers before you start. A refund can be entered as a negative expense or as income, but mixing approaches makes category comparisons less clear. One straightforward convention is to record a refund as a negative amount with Type Expense and the original category. A transfer between two of your own accounts is not income or spending overall; either leave it out of the spending totals or record it with a Transfer type that the income and expense formulas do not include.

These formulas cover a fixed range through row 1000. If a monthly total seems too low, check whether a transaction is outside the range, whether its date is a real date value, whether the type is spelled exactly Income or Expense, and whether the category matches the Budget sheet. Also check for blank dates and accidental duplicate rows. Changing the end of each formula range to a larger row number is a simple fix for a log that outgrows its original range.

Privacy, storage, and cost

The spreadsheet template itself can be created without paying for a template. Excel for the web is available with a Microsoft account, while the desktop Excel app may require a Microsoft 365 subscription or another license. Availability and account terms can change, so check Microsoft’s current product information for the version you plan to use. A workbook saved locally is under your device’s storage and backup arrangements; a workbook saved to a cloud service is subject to that service’s account and storage terms.

A spreadsheet does not need bank credentials to work. Avoid putting full account numbers, card numbers, passwords, or other sensitive identifiers in the workbook. If you store financial details in cloud storage, use a strong account password and any available multifactor authentication, and be mindful of who can access a shared file. Keep a backup before making large structural changes or importing a new set of transactions.

Spreadsheet versus an app or a downloadable template

A spreadsheet offers flexible categories, transparent calculations, and a way to keep a record you can inspect row by row. Its trade-offs are manual upkeep and the possibility of formula or entry mistakes. A downloadable template can save setup time, but check its formulas, categories, and compatibility before entering personal data. “Free” does not by itself establish that a file is safe or that its provider will keep it available.

A budgeting app may automate transaction imports or provide phone notifications, depending on its features and terms. That convenience can involve creating an account, sharing financial data, or paying for optional services. A spreadsheet is a reasonable choice if you value control and do not mind entering or importing information yourself. Google Sheets is another no-cost spreadsheet option for many users, but its interface and some features differ from Excel; do not assume that every Excel instruction or feature transfers exactly.

Frequently Asked Questions

Is there a free budget expense tracker spreadsheet in Excel?
You can create one in a blank workbook without buying a template. Excel for the web is an option for people who want browser-based spreadsheet editing with a Microsoft account; the desktop application may have separate licensing requirements.

Can Excel automatically track my bank transactions?
The workbook described here does not connect to a bank. You enter transactions or import a file, then review the data for omissions, duplicates, and formatting problems. Any automatic connection depends on a separate product or service and its current terms.

How do I track expenses by month?
Store a date on every transaction and use a monthly start date in the summary. The SUMIFS examples above include entries dated on or after that start date and before the first day of the next month, so the selected month updates when you change the date in Summary!B1.

Should expenses be entered as negative numbers?
Not in this design. Enter positive amounts and use the Type column to distinguish income from expenses. A separate remaining calculation subtracts total expenses from total income, making the entries easier to read and check.

Why is my spreadsheet total wrong?
Check date values, transaction types, category spelling, and whether amounts are numeric. Confirm that every row falls inside the formula’s referenced range and that imported records have not been duplicated. A transfer or refund may also need a consistent treatment.

Can I use this tracker in Excel for the web or on a Mac?
The SUMIFS and EDATE formulas used here are available in modern Excel versions, including Microsoft 365. Excel for the web and Mac may arrange commands differently from Windows, but the basic workbook structure and calculations are the same.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.