Excel Sheet Template for Budget: How to Build One

How-to basics · Updated November 22, 2026

The fastest way to get an Excel budget template is to open Excel and search the built-in template gallery—go to File > New, type “budget” in the search box, and pick one like “Personal Monthly Budget” or “Family Budget.” These templates come with pre-filled formulas for income, expenses, and totals, so you can start entering numbers immediately. If you prefer to build your own from scratch, a simple layout with income in one section, expenses in another, and a formula like =SUM(B2:B10) for totals works just as well.

Why Use an Excel Budget Template?

Excel templates save time and reduce errors compared to a blank worksheet. They already contain the categories most people need—housing, food, transportation, utilities, insurance, savings, and debt payments—and they often include built-in formulas that automatically calculate totals, differences, and percentages. A template also gives you a consistent structure, so you can compare month to month without rebuilding the file. Because Excel is widely available, you can open the same file on Windows, Mac, or the web, and share it with a partner or financial advisor if needed.

How to Find and Open a Built-In Template

In Microsoft Excel for Microsoft 365 on Windows, the template gallery is under File > New. Type “budget” in the search field and press Enter. You’ll see options like “Personal Monthly Budget,” “Simple Budget,” “College Budget,” and “Event Budget.” Click any one to preview it, then click Create to open a copy. On a Mac, the path is the same: File > New from Template… (or File > New) and then search. In Excel for the web, go to File > New and search the same gallery. These templates are free and require no download from third-party sites.

Building a Simple Budget Template from Scratch

If the built-in templates don’t fit your needs, create your own in a few minutes. Here’s a layout that works for most people:

  1. In row 1, put labels: A1 = “Category,” B1 = “Planned,” C1 = “Actual,” D1 = “Difference.”
  2. In column A, list income items (e.g., Salary, Freelance, Other) starting at A2, then expense items (Rent, Groceries, Utilities, etc.) below.
  3. Enter your planned amounts in column B and actual amounts in column C as you spend.
  4. In D2, enter =C2-B2 and copy down to calculate the difference (positive means you spent more than planned; negative means under).
  5. For totals, place a “Total” row at the bottom. In B10 (assuming data goes to row 9), use =SUM(B2:B9) for planned total and =SUM(C2:C9) for actual total.
  6. For net savings, subtract total expenses from total income: =B2-B10 (if income is in B2 and expenses total in B10).

For a quick example, suppose you have income of $3,000 in B2 and expenses in B3:B9 that sum to $2,400 in B10. The formula =B2-B10 returns $600, which is your planned surplus. Replace B2 with the actual income cell if you track actuals separately.

Key Formulas Every Budget Template Needs

Most budget templates rely on a few core Excel functions. Here are the ones you’ll use most, with the cell layout assumed:

  • SUM – Adds a range. With expenses in B3:B9, =SUM(B3:B9) returns the total.
  • IF – Flags overages. With planned in B2 and actual in C2, =IF(C2>B2,"Over","OK") returns “Over” if you spent more than planned.
  • AVERAGE – Finds the mean of a range, e.g., average monthly spending: =AVERAGE(B2:B13).
  • COUNTIF – Counts how many categories exceed a threshold. With actual amounts in C2:C10, =COUNTIF(C2:C10,">500") counts categories over $500.
  • SUMIF – Adds amounts that meet a condition. With categories in A2:A10 and amounts in C2:C10, =SUMIF(A2:A10,"Food*",C2:C10) sums all food-related categories (like “Food” and “Food out”).

All of these functions work in Excel 2010 and later, so they’re safe to use even if you have an older version. For newer versions, you could also use SUMIFS for multiple conditions, but the basic versions are enough for most budgets.

How to Choose the Right Template for Your Situation

Consider your income stability and financial goals. If you have a regular salary, a simple monthly template with fixed categories works. If your income varies month to month, look for a template with a “variable income” section or build one that lets you adjust planned amounts easily. For debt payoff, choose a template that includes a debt tracker with columns for balance, interest rate, and minimum payment. For a family, a template with separate categories for kids’ activities and school expenses is useful. Read the template description before downloading—many built-in ones are designed for U.S. users and may use $ currency by default, but you can change the number format to your local currency by selecting the cells and pressing Ctrl+1 (Windows) or Cmd+1 (Mac) to open Format Cells.

Common Problems and How to Fix Them

One frequent issue is that formulas don’t update when you add new rows. If you insert a row inside a SUM range, Excel usually adjusts the formula automatically, but if you add a row below the range, the total won’t include it. To avoid this, leave a few blank rows in your template or use a table (select your data and press Ctrl+T to create an Excel Table). Tables automatically expand formulas when you type in a new row. Another problem is that some templates use “Running Balance” formulas that reference the previous row, which can break if you sort data. Keep your data in the original order or use absolute references like =C2-B2 and copy down carefully. Also, be careful with merged cells—they can interfere with formulas and sorting. If a template has merged cells, unmerge them before editing.

Comparing Excel Templates to Other Tools

Excel is not the only option. Google Sheets offers similar templates for free in your browser, and it allows real-time collaboration, but it lacks some advanced features like Power Query. Dedicated budgeting apps like Mint or YNAB automate transaction imports and categorization, but they require a subscription (YNAB) or have limited free versions. A spreadsheet gives you full control and privacy—your data stays on your device—and you can customize every formula. The trade-off is that you must manually enter transactions. If you prefer automation, an app might be better; if you want flexibility and one-time cost (Excel is part of Microsoft 365), a template is a solid choice.

Safety, Accuracy, and Financial Advice

When using any budget template, double-check that formulas reference the correct cells. A common error is a formula that sums the wrong range, leading to a misleading total. Also, be aware that Excel templates are not financial advice—they are tools to help you track numbers. For decisions about investments, debt payoff strategies, or tax implications, consult a qualified financial professional. Never share your budget file with unknown parties, and if you download a template from a third-party website, scan it with antivirus software first. Microsoft’s built-in templates are generally safe, but third-party ones can contain macros; if you enable macros, make sure you trust the source. Always save a copy of your original file before making major changes, especially if you plan to use VBA macros.

Frequently Asked Questions

Can I use an Excel budget template on my phone? Yes, the Excel mobile app (iOS and Android) can open and edit budget templates, but some formatting may shift. You can download a template on your computer, save it to OneDrive, and then access it on your phone. The mobile app supports most formulas, but complex macros may not run.

How do I change the currency in an Excel budget template? Select the cells with amounts, press Ctrl+1 (Windows) or Cmd+1 (Mac), go to the “Number” tab, choose “Currency” or “Accounting,” and select your desired symbol from the drop-down. You can also type a custom format like $#,##0.00 or €#,##0.00.

Does Excel have a free budget template? Yes, the built-in template gallery includes many free budget templates. They are part of Excel, so no extra cost beyond your Excel subscription. Some third-party sites also offer free templates, but check for macros and compatibility.

What is the difference between a budget and a cash flow forecast? A budget tracks planned vs. actual income and expenses over a period (usually a month). A cash flow forecast projects future cash inflows and outflows to ensure you have enough cash to cover upcoming bills. A budget is retrospective, while a forecast is forward-looking. Excel templates exist for both, but they serve different purposes.

Can I use Excel formulas to automatically categorize transactions? Yes, you can use functions like IF or VLOOKUP to categorize based on keywords. For example, if you have a transaction description in A2, =IF(ISNUMBER(SEARCH("grocer",A2)),"Food","Other") will categorize it. However, this requires consistent naming—automated apps are better at this.

Is it better to use a monthly or yearly budget template? Monthly is more common because most bills are monthly, and it’s easier to track. A yearly template can help you see annual totals and plan for irregular expenses like insurance premiums. You can also create a yearly summary that sums monthly totals using =SUM(Jan!B2,Feb!B2,...) if you have separate sheets for each month.

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.