Monthly Expense Tracker Excel Template Free: A Checklist

You can build a monthly expense tracker Excel template free with five columns (date, description, category, amount, payment method) and a summary that adds up by category with SUMIF. A monthly expense sheet is a file that records every outgoing payment and groups it, so you can see where your paycheck goes. Everything else is optional.

Key takeaways

• Start with five columns and no more: if you won't use a field in the summary, you don't need it yet.
• Set roughly 8–12 categories before the first entry and close the list with "Other": more options make filling it in so tedious that you quit.
• Check that the total by category matches the grand total: if the difference isn't zero, a row has no category or a misspelled one.
• Use a single log for the whole year and only change the month's start date in the summary: no files to duplicate.
• When you need to get money back from other people, a personal sheet isn't enough: you need a tool built for shared money.

Which columns do you need in a monthly expense spreadsheet in Excel?

Five columns are enough: date, description, category, amount and payment method. It's the same structure that Microsoft suggests for a transaction log linked to a monthly summary. Each column answers a question you'll ask the sheet at the end of the month.

Column	What you enter	Why you need it
Date	11/14/2026	Lets you filter by month without retyping anything
Description	Weekly shopping	Helps you find the row when an amount surprises you
Category	Groceries	It's the key SUMIF works on
Amount	62.40	Numbers only, no text like "$" typed by hand
Payment method	Card	Lets you reconcile the sheet with your statement

Optional extras: subcategory, notes, a "necessary yes/no" field and tax. As a rule of thumb, add them only after a couple of months of use, when you really know what you're missing.

One useful detail: select the range and press Ctrl+T to turn it into a table. Formulas extend on their own with every new row.

Which categories should you set before entering the first amount?

Before writing a single figure, list 8–12 categories on a separate sheet called Categories: housing, utilities, groceries, transport, health, subscriptions, leisure, savings and other. A short list gets filled in quickly; a long one tends to get abandoned.

A typical mistake is splitting too finely, for example separating the café from the snack. The summary becomes unreadable and choosing the category slows down every entry.

If you want a framework, the 50/30/20 rule (50% needs, 30% wants, 20% savings) is also described in the Microsoft guides to budget plans. You can turn it into one extra column in the Categories table: "Need", "Want" or "Savings". But it's an add-on, not a requirement.

Which formulas does a monthly expense Excel template need?

The monthly summary rests on three formulas: SUMIFS for each category's expenses in the chosen month, SUM for the totals and a subtraction for the difference with income. SUMIF is enough if you keep one file per month. With a yearly log you need SUMIFS, because it has to filter by date too.

On the Summary sheet, put the first day of the month in B1 (for example 11/01/2026) and the categories in A4:A12. Then in B4:

=SUMIFS(Expenses[Amount],Expenses[Category],A4,Expenses[Date],">="&$B$1,Expenses[Date],"<"&EDATE($B$1,1))

Drag the formula down to the end of the list. Then add these rows:

1. Total expenses: =SUM(B4:B12)
2. Income for the month: a cell where you enter your take-home pay and other income.
3. Difference: =Income - Total expenses. If it's negative, you spent more than came in.
4. Savings rate: =Difference / Income, formatted as a percentage.
5. Balance check: =Total expenses - SUMIFS(Expenses[Amount],Expenses[Date],">="&$B$1,Expenses[Date],"<"&EDATE($B$1,1)). It must return 0.

If it isn't zero, at least one row has an empty category or one spelled differently from the list.

How do you avoid entry errors with dropdown lists and formats?

Data validation protects you from typos: a cell that accepts only entries from the list can't contain "Grocery" instead of "Groceries". In Excel the path is Data, Data Validation, List. As the source, you point to the range on the Categories sheet. The same goes for payment method.

Three checks to set up just once:

• Amount: Currency format, with a "decimal number" validation rule. That way "62.40 dollars" typed as text is rejected.
• Date: mm/dd/yyyy date format and "date" validation. A date typed as text slips past the summary's filters without any warning.

Add conditional formatting to the Difference cell: red if negative, green if positive.

How do you reuse the same file every month without rebuilding it?

Keep a single log for the whole year and only change the date in B1 of the summary: all the formulas recalculate for the new month.

At the start of the month:

1. Change B1 to the first day of the new month.
2. Update the Income cell.
3. Add the recurring expenses (rent, subscriptions, installments) with their dates: roughly two minutes, once a month.
4. Check that the balance cell reads 0.

Before you begin, save a clean copy of the file as a backup. If you ever break a formula, start over from there.

At the end of the year, save a copy as "2026 archive", empty the Expenses table and start again. The file can also work with Google Sheets or LibreOffice Calc, but function names and tables with structured references may not be compatible: check the formulas after opening it.

When is an Excel spreadsheet no longer enough?

An Excel spreadsheet holds up as long as the money is yours. It stops being enough when an expense has to be split with others and someone has to pay you back a share: at that point the log doesn't tell you who paid for whom, or how much is still owed. The "advanced by" and "share of" columns make the file grow until it's unmanageable.

If you live with roommates or you're on a group trip, the spreadsheet checklist for shared expenses shows where a file shared by several people breaks down. For couples with different incomes, proportional splitting is a calculation in itself: you'll find it explained in how to split expenses as a couple with different salaries.

For everything else, Excel is fine. An app to split expenses with a link is only needed when the others have to pay their share.

Frequently asked questions

Can I fill in the sheet from my phone?

Yes, if you save the file on OneDrive or Google Drive and open it with the Excel or Sheets app. It's best to enter expenses as soon as you make them, so you don't forget them.

What date do I enter for a credit card purchase that's billed the following month?

Enter the date you spent the money, not the date it's debited from your account. That way the expense lands in the month when you decided to make it. To make your bank balance add up, use the payment method column: filter on "Credit card" and compare the total with your statement.

How do I handle savings in the sheet: is it an expense?

Treat it as a category called "Savings" that counts among the month's expenses. That way the difference from income is close to zero when you've assigned every dollar. If you'd rather see savings as what's left over, leave the category out and look at the final difference.

Where do I start today?

Enter three real expenses from this week.

When one of those expenses is to be split with others, Split The Bill starts from a photo of the receipt, calculates the shares and sends a link that lets everyone settle their part, with no app to download.