Budget Tracking Spreadsheet: Plan and Review Spending

How-to basics · Updated November 21, 2026

A budget tracking spreadsheet is a workbook for comparing the money you plan to spend with what you actually spend. In Excel for Microsoft 365 on Windows, a practical setup uses one sheet for planned amounts by category and another for dated transactions; a SUMIFS formula can total actual spending automatically.

What a budget tracking spreadsheet does

A budget tracker turns a spending plan into something you can check and update. Instead of relying on a single estimate such as “food costs about $500,” you record transactions, assign them to categories, and compare their total with the amount you set aside. The difference helps answer a useful question: how much of the plan remains?

A spreadsheet is not a bank account or an accounting system. It only reflects the information entered or imported into it. Its value is that you can see the assumptions, categories, and arithmetic, then adjust them to fit your situation. A simple monthly workbook may be enough for someone who wants a spending overview; a household sharing bills may need clearer rules about who records each transaction and when.

For a basic personal tracker, keep expenses as positive amounts and use a separate Type field to distinguish expenses from income. This avoids confusing a purchase with a refund or paycheck. Decide how to treat transfers between your own accounts: counting both sides as income or spending can make totals misleading.

Choose a layout that separates plans from transactions

Use two worksheets, named Budget and Transactions. The Budget sheet holds one row per spending category, so each category has one planned amount and one calculated actual amount. The Transactions sheet holds the individual entries that feed those totals. This separation prevents the planned budget from being repeated on every purchase row.

  • Budget: columns A–D are Category, Planned, Actual, and Remaining. Put categories in A2:A4 and planned amounts in B2:B4. For example, Groceries, Utilities, and Transport might have planned amounts of $400, $150, and $100.
  • Transactions: columns A–E are Date, Description, Category, Type, and Amount. Record each purchase as a positive amount with Type set to Expense. Record incoming pay as Income.
  • Summary: use a few cells below the category list for planned total, actual total, remaining amount, and income if those figures help you review the month.

For an illustrative month, enter grocery purchases of $180 and $95, a utility bill of $120, and transport spending of $80. Those expense transactions total $475. If the three planned amounts are $400, $150, and $100, the overall plan is $650, leaving $175 unspent. These sample values demonstrate spreadsheet arithmetic; they are not a recommended budget.

Build the workbook in Excel

  1. Open a blank workbook and rename the first sheet Budget. Add a second sheet with the plus button and name it Transactions.
  2. Enter the column headings and example category rows described above. Format money columns as currency using Home > Number, and format the transaction dates as dates.
  3. On Transactions, enter one transaction per row. Use consistent category names that match the Budget sheet exactly; “Transport” and “Transportation” will not match as the same category in a formula.
  4. Turn each data range into an Excel table: select a cell in the range and choose Insert > Table, confirm that the table has headers, and select OK. Tables make it easier to add and filter rows. Excel for Mac also has Insert > Table; the ribbon layout may differ slightly.
  5. Enter the formulas in the Budget sheet, then copy the category formulas down. Add a total row and check that its figures agree with the sample arithmetic or your own records.

On Windows, Ctrl+T is also a shortcut for creating a table from a selected range. On Mac, use the Insert > Table ribbon command if the shortcut differs in your Excel setup. Excel for the web has similar table and formula features, though some ribbon details vary.

Use formulas to calculate actuals and balances

With Transactions!A1:E100 set up as Date, Description, Category, Type, and Amount, and Budget!A2:A4 containing the category names, put this formula in Budget!C2. It totals expense amounts whose category matches the name in A2. With the illustrative records above, it returns $275 for Groceries; copy it down to calculate Utilities and Transport.

=SUMIFS(Transactions!$E$2:$E$100,Transactions!$C$2:$C$100,$A2,Transactions!$D$2:$D$100,"Expense")

With Budget columns B and C holding Planned and Actual, enter this in D2 and copy it down. For Groceries, the result is $125 ($400 planned minus $275 actual). A positive amount means the category is below its plan; a negative amount means spending is above it.

=B2-C2

With the three category rows in rows 2–4 and a total row in row 5, enter this in B5 to total the planned amounts. It returns $650 ($400 + $150 + $100).

=SUM(B2:B4)

With actual category totals in C2:C4, enter this in C5. It returns $475 ($275 + $120 + $80), the total expenses in the example.

=SUM(C2:C4)

With the total planned amount in B5 and total actual amount in C5, enter this in D5. It returns $175 ($650 minus $475).

=B5-C5

If you also want to total income, with the same Transactions columns and a $2,400 income entry in E2 whose Type in D2 is Income, enter this in a summary cell. It returns $2,400 and ignores rows marked Expense.

=SUMIF(Transactions!$D$2:$D$100,"Income",Transactions!$E$2:$E$100)

These formulas use standard Excel functions. For larger workbooks, expand the transaction ranges or use table-based references; fixed ranges ending at row 100 will not include entries below row 100 until you extend them. XLOOKUP and other newer functions are not required for this basic tracker.

Make categories and data entry dependable

Useful categories are specific enough to reveal patterns but not so numerous that recording becomes a chore. A starter list might include housing, groceries, utilities, transport, health, dining, subscriptions, and personal spending. Adjust it to match the questions you want the workbook to answer. If every small purchase gets its own category, the summary can become hard to interpret.

To reduce spelling differences, create a category list and use Data > Data Validation to make the Category cells a dropdown list. In the Data Validation dialog, choose List for Allow and select the cells containing the permitted categories as the source. You can use the same approach for the Type field, with Expense and Income as the choices. The dialog is available in Excel for Microsoft 365 on Windows and Mac, though its controls may be arranged differently.

Keep refunds consistent. One straightforward method is to enter a refund as a negative expense amount in the original category, while leaving ordinary purchases positive. That makes the category’s net spending lower. Alternatively, treat refunds as a separate Type and build a formula that accounts for them; do not mix approaches without documenting the rule. Transfers between accounts should usually be excluded from spending totals unless the workbook is deliberately tracking cash movement rather than consumption.

Review the budget and spot problems

A tracker becomes useful through regular review, not by adding elaborate formatting. Reconcile the transaction list against bank or card statements at a consistent interval. Check for missing entries, duplicates, incorrect dates, and category mistakes. A single omitted bill can make a category look healthier than it is, while a duplicate purchase can make it seem worse.

To flag overspending visually, select the Remaining cells and choose Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter 0 and choose a format. Negative balances then stand out without changing the underlying calculation. Use a clear label such as “Remaining” rather than “Savings”: an underspend in one category is not necessarily money saved if other expenses or obligations remain.

Monthly plans also need a time boundary. A transaction from the previous month should not quietly affect the current month’s actual total. One simple method is to use a separate workbook or transaction sheet for each month. Another is to add a Month column and include a month criterion in the formulas. Whichever method you choose, define whether the budget follows the calendar month, a pay period, or another schedule, and apply that rule consistently.

Common limitations and privacy considerations

Manual entry can be slow and error-prone, especially when transactions are frequent. If you paste data from a bank export, inspect its columns and date formats before relying on totals. Imported descriptions may not match your categories, and a credit-card payment can appear alongside the individual purchases it paid for. Counting both as expenses would double-count the spending.

Protect the workbook as you would other files that reveal personal finances. Store it somewhere appropriate for your privacy needs, limit access if it is shared, and avoid putting full account numbers or other unnecessary sensitive details in transaction descriptions. A password or sharing restriction is not a substitute for careful storage and access decisions. If using cloud storage, review who can open the file.

A spreadsheet can summarize cash flow, but it cannot decide which expenses are necessary or whether a financial choice is suitable. Treat its outputs as a record based on the entries and assumptions you supplied. For financial, tax, or legal questions, check the relevant documents and consult a qualified professional where appropriate.

Spreadsheet versus an app or a paper budget

A spreadsheet offers flexible categories, visible formulas, and control over how data is arranged. It can be a good fit if you want a custom monthly view or prefer to enter transactions yourself. Its trade-off is upkeep: unless you import and verify records, it will not automatically know what you spent. Changes to formulas or ranges can also introduce errors, so keep a clean copy before making major structural edits.

A dedicated budgeting app may offer account connections, automatic transaction imports, or shared access, depending on its features and terms. That can reduce manual work, but it also means reviewing its privacy practices, fees, and category rules. A paper budget can be simpler and avoids spreadsheet setup, but totals and comparisons need to be calculated by hand. There is no single best format; choose the one you are likely to maintain and can verify.

Frequently Asked Questions

What should a budget tracking spreadsheet include?

At minimum, include a period, spending categories, planned amounts, actual transactions, and a comparison between plan and actual. A transaction date, description, category, type, and amount make the records easier to review.

How do I calculate remaining budget in Excel?

Subtract actual spending from the planned amount. If Planned is in B2 and Actual is in C2, enter =B2-C2 in D2. A negative result indicates that actual spending is greater than the plan.

Can Excel automatically track bank transactions?

A basic workbook does not monitor accounts by itself. You can enter transactions manually or import a file supplied by your bank, then check the imported rows and categories. Whether an account connection is available depends on the service and setup you use.

How often should I update a budget tracker?

Choose a schedule you can sustain, such as recording transactions weekly and reconciling totals when statements are available. More frequent updates can make errors easier to find, but consistency matters more than a particular schedule.

Should I count savings as a budget category?

You can include a planned savings contribution as a category if your goal is to track it alongside other planned uses of income. Keep it distinct from unspent budget: the latter is simply a difference between planned and recorded amounts, not proof that cash has been saved.

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.