Personal Budget Spreadsheet Template: Build One in Excel

How-to basics · Updated November 21, 2026

A personal budget spreadsheet template is a worksheet that compares planned income and expenses with what actually comes in and goes out. In Excel for Microsoft 365, start with four columns—category, planned, actual, and difference—then add monthly totals and a remaining-balance summary; the layout and formulas below give you a practical template to build or adapt.

What a personal budget spreadsheet does

A budget spreadsheet turns a monthly plan into figures you can check against real transactions. The planned column records what you expect to earn or spend; the actual column records what happened. Comparing them can show whether a category is running over its plan and whether your remaining money is different from what you expected.

A spreadsheet is not a prediction of exactly what every month will cost. It is a record and planning aid, and its usefulness depends on entering complete, correctly categorized amounts. It also does not automatically account for timing unless you choose to track dates and due dates. A month can have enough income overall but still feel tight if several bills fall before payday.

Keep the basic idea simple: use the same monthly period for income and expenses, record amounts consistently, and check the result against bank or card records. A personal budget is different from a business accounting system; this template is intended for household planning, not tax reporting or formal financial statements.

Set up a simple monthly worksheet

Create a worksheet named Budget. Put the first day of the month you are budgeting in B3—for example, November 1, 2026—and format it as a date. Use column A for category names, B for planned amounts, C for actual amounts, and D for the difference. Enter income categories in rows 6–9, put an income total on row 10, enter expense categories in rows 14–24, and put an expense total on row 25. Use rows 28–30 for a short summary.

Here is one possible starting set of categories. Adjust it to match your household rather than keeping categories that do not apply:

  • Income: wages, other regular income, and occasional income.
  • Fixed or predictable expenses: housing, insurance, phone, and subscriptions.
  • Variable expenses: groceries, utilities, transport, health, and dining out.
  • Goals and irregular costs: savings contributions, annual fees, gifts, repairs, and travel.

For a worked example, suppose planned monthly income is $4,200 and actual income is $4,300. Planned expenses total $2,500; actual expenses total $2,555. The difference is not a judgment about whether spending is good or bad. It is a prompt to check whether the amounts and categories match your plan and priorities.

Choose useful categories and a time period

Categories should be specific enough to help you make decisions, but not so detailed that recording purchases becomes a chore. If you want to know whether food spending is changing, separating groceries from restaurant meals may help. If you will not act on a distinction, combining the categories may make the sheet easier to maintain.

Decide how to handle expenses that do not arrive monthly. One option is to set aside a monthly planned amount for an annual bill: divide the expected yearly cost by 12. For example, a hypothetical $600 annual premium averages $50 per month. The monthly budget can show that planned amount even though the payment itself happens once a year. Keep the actual payment in the month it is paid if you want the sheet to reflect cash flow; alternatively, use a separate savings or sinking-fund category. Choose one method and use it consistently so the total is not counted twice.

Use the calendar month if that is easiest to compare with statements and bills. If your pay cycle makes another period more useful, make the start and end dates explicit. Avoid mixing a paycheck period with calendar-month expenses without labeling the difference; that can make a correct total look confusing.

Add formulas for totals and differences

With income category names in A6:A9 and planned and actual amounts in B6:C9, enter this in B10 to total planned income: =SUM(B6:B9). With planned amounts of $4,000 and $200 in the first two rows and zeros in the others, the result is $4,200. In C10, with actual income of $4,100 and $200, =SUM(C6:C9) returns $4,300. SUM adds the values in the stated range.

With planned amounts in B14:B24 and actual amounts in C14:C24, enter =SUM(B14:B24) in B25 for planned expenses. If those planned categories total $2,500, the formula returns $2,500. With actual amounts in C14:C24, enter =SUM(C14:C24) in C25; if they total $2,555, it returns $2,555.

With planned income in B10 and actual income in C10, put =C10-B10 in D10 to show the income difference. The example returns $100. With planned and actual amounts in B14 and C14 for a rent category, put =C14-B14 in D14; if both are $1,400, the result is $0. Copy the difference formula down the category rows to compare actual with planned. A positive expense difference means actual spending exceeded the plan; a negative one means it was lower.

For the summary, label B28 and C28 planned and actual income, and B29 and C29 planned and actual expenses. Link the summary to the totals: with the income totals in B10 and C10, enter =B10 in B28 and =C10 in C28. These return $4,200 and $4,300 in the example. With expense totals in B25 and C25, enter =B25 in B29 and =C25 in C29; they return $2,500 and $2,555.

With planned income in B28 and planned expenses in B29, enter =B28-B29 in B30 to calculate planned money remaining. It returns $1,700. With actual income in C28 and actual expenses in C29, enter =C28-C29 in C30; the example returns $1,745. These are simple arithmetic results, not a recommendation about how to use the remaining amount. Check that income and expenses use the same period and that no amount has been omitted or counted twice.

Track transactions instead of typing monthly actuals

For more detail, add a Transactions worksheet with columns A–D labeled Date, Category, Amount, and Type. Enter each transaction on its own row, use positive amounts, and choose Income or Expense in the Type column. This keeps the record separate from the monthly summary and makes it possible to calculate actuals from individual entries. Do not enter both a card purchase and the later card-bill payment as expenses: that would count the same spending twice.

With transaction dates in Transactions!A2:A500, categories in B2:B500, positive amounts in C2:C500, and types in D2:D500, and with the budget month’s first day in Budget!B3 and the category in Budget!A14, use this formula in Budget!C14 to total that category’s expenses for the month: =SUMIFS(Transactions!$C$2:$C$500,Transactions!$B$2:$B$500,$A14,Transactions!$D$2:$D$500,"Expense",Transactions!$A$2:$A$500,">="&$B$3,Transactions!$A$2:$A$500,"<"&EDATE($B$3,1)). If the category is Groceries, B3 is November 1, 2026, and matching November transactions are $65, $82, and $48, it returns $195. The date conditions include the first day of the month and exclude the first day of the next month. EDATE advances the date by one month.

SUMIFS requires the sum range and each criteria range to cover corresponding rows, so keep those ranges aligned when you expand them. The example stops at row 500; increase the row limits if needed. Check that transaction dates are real Excel dates, category spelling matches the budget, and amounts are numeric. If a transaction list grows substantially, you can format it as a table using Insert > Table; structured references can make formulas easier to extend, but the basic fixed-range example is simpler to inspect.

Make the workbook readable and easier to maintain

Format planned, actual, and difference cells consistently as currency. In Excel for Microsoft 365 on Windows, select the cells and use Home > Number to choose a currency or accounting format. On Mac, use the Home tab’s number-format controls; ribbon layout can differ slightly. A number format changes how a value appears, not the underlying value.

Make headings clear and avoid using color as the only signal. For example, label the difference column and use a note such as “positive expense difference = over plan.” You can apply Home > Conditional Formatting > Highlight Cells Rules to draw attention to values above zero, but review the rule after copying it so it applies to the intended expense rows rather than income rows as well.

For a transaction list, select the data and choose Insert > Table. Tables can provide filter buttons and expand as you add rows. To restrict category entries to a list, select the relevant cells and choose Data > Data Validation, then choose List and provide the category values or a range containing them. On Mac or Excel for the web, the exact ribbon arrangement may vary, but use the Data tab’s validation control when available.

Save a clean copy of the workbook before making major structural changes. If you keep one worksheet per month, name each tab clearly and carry forward categories carefully. A single month selector with a transaction log can reduce repeated sheets, but it requires formulas and date entries to be maintained consistently. Pick the arrangement you are most likely to update.

Common problems and how to check them

  • Totals do not match a statement: Look for missing transactions, duplicate entries, pending transactions, and purchases assigned to the wrong month. A bank balance can also differ from a budget total if the budget includes cash spending or transactions from another account.
  • A formula shows zero or an error: Confirm that the formula range covers the cells containing data and that amounts are numbers rather than text. For a SUMIFS formula, check category spelling, the Type value, date cells, and matching range sizes.
  • Transfers appear as spending: A transfer between your own accounts is not necessarily a new expense. Decide whether the budget tracks transfers as a separate category or excludes them, and apply that choice consistently.
  • The budget feels too complicated: Reduce categories, automate only the calculations that save time, and choose a regular moment to update the sheet. A simpler sheet updated consistently is generally more useful than a detailed one left unfinished.
  • Actual spending is below plan: Check that the month is complete and that delayed bills have not been left out before interpreting the result. A low total early in the month is not directly comparable with a full-month plan.

Spreadsheet or budgeting app?

A spreadsheet gives you control over categories, layout, and calculations. It can be a good fit when you want a transparent monthly summary, prefer entering transactions yourself, or need a format tailored to your household. It does require upkeep: formulas do not know about purchases unless you enter or import them, and a mistake in a copied formula can distort a total.

A budgeting app may offer features such as account connections, transaction categorization, or alerts, depending on the product and its terms. Those features can save manual work, but may involve account access, subscriptions, data-sharing choices, or categorization that needs correction. Compare current fees, supported institutions, privacy practices, and export options before choosing. A plain spreadsheet is not automatically safer or more accurate; both tools need sensible security and review.

You can also use a bank’s own spending summaries or a paper-based plan. Those alternatives may suit someone who wants less setup or does not need custom calculations. The useful tool is the one that helps you see income, spending, and timing clearly enough to make your own decisions.

Frequently Asked Questions

Is there a free personal budget spreadsheet template in Excel?
Excel may provide templates through its start screen or template search, but availability can change by account, region, and version. You can also create the basic layout above in a blank workbook without paying for a separate template. Review any downloaded workbook’s formulas and data sources before entering personal information.

What should a monthly budget spreadsheet include?
At minimum, include the month, income categories, expense categories, planned and actual amounts, totals, and a remaining-balance figure. Add transaction dates or a separate transaction log if you need to see when money moved or want actuals calculated automatically.

How do I calculate money left over in Excel?
Subtract expenses from income for the same period. In the example layout, planned remaining money is =B28-B29, and actual remaining money is =C28-C29. The example results are $1,700 and $1,745 respectively; those totals depend on the amounts entered.

Should I use one spreadsheet for each month?
Either approach can work. Separate monthly tabs are easy to understand but can become repetitive; a transaction log with a month selector avoids copying the same layout but needs reliable dates and formulas. Keep a year-to-date record or archive if you want to compare months later.

Can I use this template in Excel for Mac or Excel for the web?
Yes, the basic worksheet and formulas use standard Excel features available in Microsoft 365. Ribbon placement and some keyboard shortcuts can differ on Mac and in the web app. On Windows, Ctrl+T creates a table after selecting data; on Mac, Command+T is commonly used for a table. Check the current menu or shortcut shown in your version if it differs.

Is a budget spreadsheet financial advice?
No. It organizes figures you provide and performs arithmetic; it cannot determine what choices are right for your circumstances. This template is not financial, tax, investment, or legal advice. Check actual account or lender terms with the relevant provider, and consult a qualified professional for advice specific to your situation.

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.