How to Keep Track of Your Budget in Excel: Step by Step

To keep track of a budget in Excel, record each transaction in a dated log, assign it a type and category, then use a monthly summary to compare planned amounts with actual spending. A SUMIFS formula can total transactions for each category and month, while a remaining column shows how much of each budget is left.

The example below is for Microsoft Excel for Microsoft 365 on Windows. It uses positive amounts for both income and expenses, with a separate Type column to distinguish them. The figures are illustrative, not financial, tax, investment, or legal advice; check actual loan or account terms with your lender or a qualified professional.

What You’ll Need

Excel for Microsoft 365 on Windows, or Excel on Mac or the web. The core formulas work in all three; ribbon placement and some keyboard shortcuts can differ.
A list of expected monthly income, spending categories, and planned amounts. You can start with estimates and adjust them as you learn what you spend.
Recent receipts, bank or card statements, or another reliable source for transaction dates and amounts. Do not share sensitive account details in a workbook you plan to share.

Step-by-Step

Create a transaction log. In a blank worksheet, enter these headings in cells A1:E1: Date, Description, Type, Category, Amount. Each row after that should represent one transaction. For example, a grocery purchase might have a date, a short description, Expense as its type, Groceries as its category, and 62 as its amount. Enter income as a positive amount too, but label its type Income. Use real Excel dates and numeric amounts rather than typing a currency symbol into the amount itself; apply number formatting afterward.
Make the log easier to maintain. Select a cell in the headings or data, choose Insert > Table, confirm that My table has headers is selected, and choose OK. A table makes it easier to filter and sort entries and extends its formatting as you add rows. Keep one transaction per row, avoid blank rows inside the list, and do not merge cells in the log. You can use filters on Type or Category to review just one kind of transaction.
Add a monthly summary area. Use a second worksheet or a clear area beside the log. In A1, type Month start; enter a real date such as November 1, 2026, in B1. In A3, type Monthly income and leave B3 for a formula. In row 5, enter the headings Category, Plan, Spent, Left in A5:D5. List categories in A6:A10, such as Groceries, Housing, Transport, Utilities, and Personal. Enter the amount you plan to spend for each one in B6:B10. Keep the category spelling consistent between the summary and transaction log.
Calculate income for the selected month. With transaction dates in A2:A1000, transaction types in C2:C1000, amounts in E2:E1000, and the month-start date in B1, enter this in B3:

=SUMIFS($E$2:$E$1000,$C$2:$C$1000,"Income",$A$2:$A$1000,">="&$B$1,$A$2:$A$1000,"<"&EDATE($B$1,1))

This adds amounts labeled Income from the first day in B1 up to, but not including, the first day of the next month. For example, if November has one salary transaction of 3,200 and no other income, B3 returns 3,200. The end-date condition also works for months of different lengths. If your log may grow beyond row 1000, increase all three formula ranges consistently or use a larger range.
Total actual spending by category. With dates in A2:A1000, transaction types in C2:C1000, categories in D2:D1000, amounts in E2:E1000, the selected month in B1, and the summary category in A6, enter this in C6:

=SUMIFS($E$2:$E$1000,$D$2:$D$1000,A6,$C$2:$C$1000,"Expense",$A$2:$A$1000,">="&$B$1,$A$2:$A$1000,"<"&EDATE($B$1,1))

In this example, the Groceries category has three November expense entries of 62, 48, and 74, so C6 returns 184. Copy C6 down through C10 using the fill handle; the category reference changes for each row while the transaction ranges remain fixed. Make sure all spending entries use the exact type Expense.
Show what remains in each category. With planned spending in B6 and actual spending in C6, enter this in D6:

=B6-C6

If the Groceries plan is 250 and the actual total is 184, D6 returns 66. A positive result means the recorded spending is below the plan; a negative result means it is over. Copy the formula down through D10. To create a total row in row 11, enter these formulas: with planned amounts in B6:B10, use =SUM(B6:B10) in B11; with category spending in C6:C10, use =SUM(C6:C10) in C11; with remaining amounts in D6:D10, use =SUM(D6:D10) in D11. These totals add the five listed categories, so include every category you want represented.
Format the dates and money. Select the date cells and choose a date format from Home > Number. Select the amount and summary cells and choose a currency or number format from the same Number group. Formatting changes how values appear, not the underlying values used in calculations. Use the same currency throughout this workbook, and avoid entering amounts as text such as “$62 dollars,” which can prevent Excel from summing them.
Check the result and update it regularly. Compare a few summary totals with the source statements before relying on the workbook. Add new entries as they happen or set a weekly reminder to enter them. To review a different month, change B1 to that month’s first day; the monthly formulas recalculate. In Excel for Mac, the same worksheet formulas and Insert > Table feature are available, though ribbon layout can differ. In Excel for the web, use the corresponding ribbon commands in the browser.
Make overspending easy to spot. Select D6:D10, then choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter 0 and select a formatting style, then confirm. Negative remaining amounts will stand out. This is a visual cue, not a change to the calculation, and you can remove or edit the rule from the Conditional Formatting menu.

Common Mistakes

Mixing transaction types or signs. This setup expects positive amounts for income and expenses and uses the Type field to separate them. If you enter expenses as negative amounts as well as labeling them Expense, totals and remaining balances will not follow the example. Choose one convention and apply it consistently.
Using inconsistent category names. Groceries, Grocery, and groceries may not match as expected in a category-based summary. Pick a standard list and reuse it. A typo in the log can leave a transaction out of the intended summary.
Entering text instead of dates or numbers. A date that looks correct but is stored as text may not meet the formula’s date conditions. Amounts containing words or pasted currency text may not sum. Check cell formatting and re-enter or convert invalid values.
Forgetting transactions or duplicating them. A summary can only reflect the information entered. Include cash purchases and recurring bills if they belong in your tracking plan, and check source statements to find missed or repeated entries.
Changing formula ranges accidentally. If you copy a formula and its transaction ranges shift, totals may differ by row. In the example, dollar signs keep those ranges fixed. If you edit the formula, confirm that date, type, category, and amount ranges all cover the same rows.

Tips

Keep categories useful rather than overly detailed. A small, stable list is easier to maintain and makes month-to-month comparisons clearer.
Use the same date convention every time. The month selector should be the first day of the month, such as November 1, not the last day or a text label.
Save a clean copy of the workbook before experimenting with formulas, and keep a backup somewhere secure. Avoid including full account numbers or other unnecessary personal information.
Turn on filters for the transaction table and filter by month, type, or category when reviewing entries. Sorting the whole table is safer than sorting only one column, which can separate amounts from their descriptions.
Review the plan after a full month of entries. Treat the plan as a tracking reference, not a guarantee that expenses will match it; revise categories or planned values when your circumstances change.

Troubleshooting

A total is zero when transactions exist: Check that the dates are real Excel dates within the selected month, the type is exactly Income or Expense as appropriate, and the category matches the summary. Confirm that the amount cells contain numbers. Also check that the transaction is inside the formula’s row range.

The formula displays as text or does not calculate: Make sure the cell is not formatted as Text. Change it to General, click the formula bar, and press Enter. Check that the formula begins with an equals sign and that the parentheses are balanced. Some regional settings use semicolons instead of commas between formula arguments; if Excel rejects the comma version, use the separator expected by your installation.

The result is too high or low: Look for duplicate entries, omitted transactions, a wrong Type value, or expenses recorded with a negative sign. Compare the underlying rows with a statement, and check that the selected month in B1 is correct. The formula includes the first date of that month and excludes the first date of the next month.

New rows are missing from the summary: The example formulas stop at row 1000. If entries extend below that, extend each relevant range to cover them, keeping each range the same size. Alternatively, use an Excel table and revise formulas to use table references if you are comfortable with structured references; do not mix ranges that cover different sets of rows.

Frequently Asked Questions

Do I need a special Excel budget template?
No. A workbook with a transaction log and monthly summary is enough to begin. A template can save setup time, but check its categories, formulas, and date ranges before using it.

Can I track several months in the same workbook?
Yes. Keep one continuous transaction log and change the summary’s month-start date when you want another month’s totals. For a longer history, duplicate the summary sheet for each month or build a separate monthly overview, while keeping the transaction records in one place.

Can I use this budget tracker in Excel on Mac or the web?
Yes. SUMIFS, EDATE, basic arithmetic, and the worksheet layout work in current Excel for Mac and Excel for the web. Ribbon placement may vary. The keyboard shortcut to create a table differs: Ctrl+T on Windows and Command+T on Mac.

Why is my remaining amount negative?
The formula subtracts actual spending from the planned amount. A negative result means the recorded category total is greater than its plan. Check the transactions and category first; if they are correct, the number is accurately showing the difference.

How often should I update the transaction log?
Choose a routine you can maintain, such as entering purchases daily or reconciling once a week. More frequent updates make it easier to identify missing entries, but consistency matters more than choosing a particular schedule.

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.