Weekly Expense Tracker Spreadsheet: Build One in Excel

How-to basics · Updated November 21, 2026

A weekly expense tracker spreadsheet is a simple Excel worksheet for recording purchases by date and category, then totaling spending over a seven-day period. In Microsoft Excel for Microsoft 365 on Windows, set up columns for transactions and use a date-based SUMIFS formula to calculate each week’s total; the guide below shows a practical layout and how to keep it useful.

What a weekly expense tracker does

A weekly tracker helps answer a focused question: where did money go during a particular week? It is not the same as a full budget, which may also plan future income, bills, savings, and longer-term goals. A spreadsheet can support either purpose, but recording actual transactions is the first step.

Weekly tracking is useful when monthly totals feel too broad or when spending changes from week to week. It can reveal recurring patterns, such as frequent small food purchases, without requiring complicated budgeting software. The tracker is only as complete as the information entered, so treat it as a practical record rather than a bank statement or an automatic account feed.

Choose a consistent week boundary before you start. Monday through Sunday is a common choice, but Sunday through Saturday may fit another person’s routine better. Neither is inherently more accurate; consistency makes weeks comparable. If you are tracking household spending, agree on whether the sheet includes one person’s purchases, shared expenses, or both.

A useful spreadsheet layout

Keep one transaction per row and use a single header row. For example, place a title and selected week-start date above the data, then put column headers in row 5 and transaction records beginning in row 6:

  • Date: the date the purchase occurred, entered as an Excel date.
  • Category: a consistent label such as Groceries, Transport, or Housing.
  • Description: a short reminder, such as market shop or bus fare.
  • Account: an optional card, cash, or account label.
  • Amount: the amount spent, entered as a positive number.
  • Type: optional labels such as Expense, Refund, or Reimbursement.

For the example formulas in this article, Date is column A, Category is column B, and Amount is column E. The selected week’s Monday date goes in B2. The records occupy rows 6 through 105, with headers in row 5. You can change the locations, but update every formula to match your own sheet.

In Excel for Microsoft 365 on Windows, select the header row and a reasonable number of blank rows beneath it, then choose Insert > Table and confirm that the table has headers. A table makes it easier to filter transactions and carries formatting into added rows. Keep the date and amount columns in consistent formats, and avoid merged cells in the transaction area because they make sorting and filtering harder.

Build the tracker in Excel

Start by creating the headers and entering a few sample transactions. Select the date column and use Home > Number Format to choose a date format. Select the amount column and choose a currency format that matches the currency you actually use. Formatting changes how values appear; it does not convert text into valid dates or numbers, so check that Excel recognizes entries as values.

Enter the week-start date in B2. To make the entry easier to change, you can label A2 “Week starting” and format B2 as a date. If you want a Monday-based week, choose a Monday for B2. The formulas below include that date and stop before the following Monday, so transactions on the next Monday will not be counted in the previous week.

To make categories consistent, list the approved labels in an unused area of the sheet and use Data > Data Validation to create a list for the Category cells. Consistent labels matter: Groceries and grocery would otherwise be treated as separate categories. If your version of Excel presents different validation controls, use the list option in the Data Validation dialog and point it to the category cells.

Calculate the weekly total

With transaction dates in A6:A105, amounts in E6:E105, and the Monday start date in B2, enter this formula in a summary cell such as B3:

=SUMIFS($E$6:$E$105,$A$6:$A$105,">="&$B$2,$A$6:$A$105,"<"&$B$2+7)

For an illustrative week beginning April 6, 2026, suppose the recorded expenses are $42 for groceries on April 6, $12.50 for transport on April 7, $9.50 for coffee on April 8, $35 for household items on April 10, and $18 for groceries on April 12. The formula returns $117: 42 + 12.50 + 9.50 + 35 + 18. The date criteria include April 6 and dates after it up to, but not including, April 13. This also avoids counting a transaction dated exactly at midnight on the next Monday.

For a category summary, list a category in H6 and put its total in I6. With the same transaction layout, H6 containing Groceries, dates in A6:A105, categories in B6:B105, amounts in E6:E105, and the week start in B2, use:

=SUMIFS($E$6:$E$105,$B$6:$B$105,H6,$A$6:$A$105,">="&$B$2,$A$6:$A$105,"<"&$B$2+7)

For the sample transactions, that category formula returns $60, from the $42 and $18 grocery entries. Copy it down beside other category names. These examples use fixed ranges ending at row 105; expand the ranges if you expect more records, or use a well-named Excel table and structured references to make formulas adapt as the table grows.

Record transactions and review the week

Enter purchases regularly rather than relying on memory at the end of the week. A brief description can help distinguish similar transactions, while the category makes totals meaningful. If you import or copy data from a bank or payment service, compare the entries with the source and remove duplicates. Avoid recording a transaction once as a card purchase and again as the later card bill: that counts the same spending twice.

At the end of the chosen week, compare the total with the transaction list and check missing dates, repeated charges, and unusual amounts. A refund can be recorded as a negative amount if the goal is to show net spending, or kept as a separate type and summarized separately. Pick one method and label it clearly; mixing negative refunds with positive expense totals without explanation can confuse later comparisons.

For a quick weekly review, filter the table by date or category and sort by amount. You can also add a category summary beside the transaction list. If the sheet is used over many weeks, keep old rows rather than overwriting them, and change B2 to review a different week. For a year-over-year or monthly analysis, a separate summary or PivotTable may be more convenient than a single weekly view.

Choose categories that answer real questions

Categories should be specific enough to guide a useful review but not so numerous that every entry becomes a judgment call. A starting list might include groceries, dining, transport, housing, utilities, health, personal, entertainment, and other. Adjust it to the questions you want the tracker to answer. For example, someone who wants to understand food spending may separate groceries from restaurants; someone who does not need that detail can combine them.

Keep fixed bills and one-off purchases distinguishable if that distinction helps. A Type column can label recurring or occasional expenses, but it should not replace the main category. Also decide how to handle shared bills, cash withdrawals, gifts, and reimbursements. If an ATM withdrawal is recorded as an expense, later purchases made with that cash should not be counted again unless the withdrawal is treated as a transfer and only the purchases are logged.

There is no universal correct category system. A useful test is whether you can classify a typical purchase quickly and whether the resulting totals help you make sense of the week. If “Other” grows large, review its contents and split it only when the extra detail is worth maintaining.

Formatting, checks, and common problems

Use filters to find blanks or inspect one category at a time. To highlight unusually large amounts, select the amount cells and choose Home > Conditional Formatting > Highlight Cells Rules, then set a threshold that makes sense for your own data. A highlight is a visual prompt, not proof that a transaction is wrong.

  • A total is zero: check that B2 contains a real date and that transaction dates are real Excel dates within the selected week.
  • A category is missing from its summary: compare spelling, spaces, and punctuation in the transaction and category list.
  • Amounts are not adding: check whether values were imported as text, whether the formula range reaches the latest row, and whether amounts were entered in the intended column.
  • The total seems too high: look for duplicate imports, repeated card-bill entries, or a refund entered as a positive expense.
  • Weeks do not match expectations: confirm the start day and use the same seven-day boundary each time.

Use View > Freeze Panes > Freeze Top Row if the header row should remain visible while scrolling. For long tables, Excel’s filters can help locate records, but do not delete data simply to make the current week’s view cleaner. Keeping a source record makes later checks more reliable.

Spreadsheet versus app or template

A spreadsheet offers flexible categories, visible calculations, and easy customization. It is a good fit when you want a simple manual record and are comfortable maintaining rows and formulas. Its limitations are also clear: it will not automatically know whether a transaction is missing, and an inaccurate formula range or inconsistent entry can distort a total.

A budgeting app may offer bank connections, notifications, or automatic categorization, depending on the service and region. Those features can save data-entry time, but they involve account permissions and the provider’s privacy and security practices. A downloadable spreadsheet template can save setup time, though it is still important to inspect its categories, formulas, and sharing settings before entering personal information. A paper log is another option for people who prefer writing purchases down and can transfer totals later if needed.

Excel for the web and Excel for Mac can open ordinary workbooks and support common spreadsheet features, but menus and some interface details can differ from Excel for Microsoft 365 on Windows. This guide uses Windows ribbon paths. If a command appears in a different place on Mac or the web, use the equivalent table, validation, or formatting control rather than assuming a Windows menu path is identical.

Privacy and reliable recordkeeping

Expense records can reveal routines, locations, and purchases. Store the workbook somewhere you control, use your device’s normal sign-in and security protections, and be cautious about sharing a file that includes account details or descriptions you consider private. A tracker generally does not need full card numbers, passwords, or other credentials; leave those out.

Keep a backup if the records matter to you, and make sure it is stored securely as well. If a workbook is shared, remember that people with access may be able to see more than the currently filtered rows. The examples here are arithmetic for organizing expenses, not financial, tax, or legal advice. Check account-specific fees or terms with the relevant provider, and consult a qualified professional for advice about your circumstances.

Frequently Asked Questions

What should a weekly expense tracker include?
A practical tracker usually includes the transaction date, category, description, and amount. An account or payment-method column is optional. Add fields only when they help you review spending or reconcile records.

Should I start my expense-tracking week on Sunday or Monday?
Either can work. Choose the boundary that suits your routine and use it consistently. The formula in this guide treats the date in B2 as the first day and includes the next six days.

Can I use this spreadsheet for income as well as expenses?
Yes. Add a Type column or keep income in a clearly separate section, and decide how you want refunds and reimbursements handled. Do not combine unlike entries without labeling them, or a total may stop meaning “expenses.”

How do I make the weekly total update automatically?
Enter a new start date in B2 and ensure new transactions fall within the formula’s date and amount ranges. If you regularly add records beyond row 105, extend those ranges or use an Excel table with suitable structured-reference formulas.

Is a weekly expense tracker a budget?
Not by itself. A tracker records what happened. A budget sets or compares planned amounts, so you would need to add a plan for categories or weeks and compare actual spending against it.

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.