How to Make an Expense Tracker in Excel

An expense tracker in Excel needs a transaction table, consistent categories, and a summary that totals spending for a selected month. Use positive amounts for purchases and negative amounts for refunds. Keep transfers and credit card repayments out of the expense total when the original purchases are already recorded.

The walkthrough below builds a personal expense tracker using an Excel Table and SUMIFS formulas. It includes sample results so you can check the workbook before adding your own transactions.

Create the expense table

Open a blank workbook and name the first worksheet Expenses. Paste this tab-separated example into cell A1:

Date    Merchant    Category    Amount  Currency    Account Notes
2026-10-03  Example Market  Groceries   52.40   USD Debit   Weekly shop
2026-10-08  Example Rail    Transport   18.00   USD Credit  Train tickets
2026-10-12  Example Market  Groceries   -7.40   USD Debit   Returned item
2026-11-02  Example Market  Groceries   60.00   USD Debit   Weekly shop

These amounts are illustrative, not recommended spending limits. Check that dates are stored as dates and amounts as numbers. Format the Amount column to show two decimal places.

Select the data and choose Insert → Table, confirming that the range has headers. Name the table ExpensesTable. Microsoft's guide to structured references explains the named-column notation used below.

Add future entries as new table rows. Before relying on a total, check that each new row is inside the table rather than separated from it by a blank area.

Add a monthly summary

Create a worksheet named Summary. Enter this layout:

In B5, enter:

=SUMIFS(ExpensesTable[Amount],ExpensesTable[Category],$A5,ExpensesTable[Date],">="&$B$1,ExpensesTable[Date],"<"&EDATE($B$1,1),ExpensesTable[Currency],$B$2)

Copy B5 down into B6. This adds amounts only when category, date range, and currency all match. Microsoft describes the multiple-condition calculation in its SUMIFS guide.

The formulas use English names and commas. Excel installations using another locale may require translated function names or semicolon separators.

With the sample data, October Groceries should show 45.00 and Transport should show 18.00. The refund reduces grocery spending, and the November purchase stays outside the selected month.

In B8, enter:

=SUMIFS(ExpensesTable[Amount],ExpensesTable[Date],">="&$B$1,ExpensesTable[Date],"<"&EDATE($B$1,1),ExpensesTable[Currency],$B$2)

B8 should show 63.00. This total includes all matching expenses, including entries with a blank category. Compare it with the sum of the category rows to find spending missing from the category summary.

Compare actual spending with a budget

In D5, enter =C5-B5 and copy it into D6. For the sample budget, the results are:

These are demonstration limits. Set your own budget using your obligations and actual spending history. A positive Remaining value means the category is below its limit; a negative value means it is over.

Do not assume a positive category balance is money you can freely spend. Other bills, upcoming purchases, and categories outside this small example still need funding. The budget categories guide can help you build a more complete list.

Test the tracker before entering a full month

Use three small checks:

1. Change B1 to =DATE(2026,11,1). Groceries and total spending should both become 60.00, and Transport should become 0.00.
2. Restore October, then add a new October grocery purchase of 5.00 USD inside ExpensesTable. Groceries should become 50.00 and the total 68.00.
3. Remove that temporary row. Confirm that the October results return to 45.00 and 63.00.

If a result stays unchanged, check the table boundary, date value, currency, and whether the amount is numeric. These checks catch common problems before you have dozens of rows to investigate.

Record purchases once

Credit cards create a common source of double counting. If you record a $40 grocery purchase when it appears on the card, the later payment from checking to the card is settlement of that balance. Adding it as another grocery expense would count the purchase twice.

The same principle applies when moving money between your own accounts. Keep an account ledger if you need to track those movements, but exclude them from this expense-only table. For a register that includes transfers and income explicitly, use the income and expense tracker guide.

Record a purchase refund as a negative amount in the relevant category. An October purchase refunded in November then affects October and November separately under this transaction-date approach. Retain a note connecting the entries so you can explain the change.

Keep the workbook usable

Start with categories you can assign reliably. Groceries, Housing, Transport, Health, Subscriptions, and Personal spending may be enough for an initial household tracker. Use a category dropdown if you find yourself typing inconsistent labels.

Store the workbook somewhere you can back up, and keep a dated copy after reviewing each month. When comparing it with account statements, investigate missing transactions as well as duplicates. A formula can total the rows you entered; it cannot find cash purchases you forgot to record.

If you use more than one currency, keep the currency field and summarize each separately. Changing a cell's currency symbol does not convert the underlying amount.

Use receipt capture when manual entry becomes the obstacle

Excel is useful when you want custom formulas and control over the workbook. Receipt capture is a different task: getting each purchase recorded while the details are available.

BudJet offers AI receipt scanning and category spending views. It can be a useful option when maintaining a spreadsheet means receipts pile up. Review the scanned values and categories against the receipt before relying on them. You can also compare the approaches in our receipt scanner app guide. To fill the sheet from a single receipt, our free receipt to CSV tool turns a photo into rows you can paste in.

Common Excel expense tracker questions

Can I make a business expense tracker in Excel?

Yes. Add fields such as business purpose, project, document reference, and review status. Keep business and household records distinguishable. The 1099 expense tracker guide explains a records workflow for US freelancers and contractors.

Why does SUMIFS return zero?

Check for dates or amounts stored as text, mismatched category names, a different currency code, or a month selector that is not the first day of the intended month. Also confirm that new rows belong to ExpensesTable.

Should I create a separate sheet for every month?

One transaction table with a month selector is easier to maintain for this setup. It lets you reuse the same category formulas instead of copying a new worksheet every month.

Can I use Google Sheets instead?

Yes. Use our Google Sheets business expense tracker tutorial for a version with ordinary range references rather than Excel Table references.