Building a budget spreadsheet takes about 30 minutes and requires nothing more than Google Sheets, Excel, or any other spreadsheet app. The core idea is simple: list your income at the top, your expenses below it, and use a few formulas to track where every dollar goes. Here’s how to set one up from scratch.
Choose Your Spreadsheet Tool
Google Sheets is free and accessible from any device with a browser. Excel works well if you already have a Microsoft 365 subscription or the desktop app. Both support the same formulas, charts, and formatting features you’ll need. LibreOffice Calc and Apple Numbers are also fine. Pick whichever you’re most comfortable with.
Set Up Your Column Headers
Create a row of headers across the top. At minimum, you need four columns:
- Category: The name of each income source or expense (rent, groceries, car payment).
- Budgeted: How much you plan to spend or earn in that category this month.
- Actual: What you actually spent or earned, filled in as the month progresses.
- Difference: The gap between budgeted and actual, calculated automatically with a formula.
If you want to track a full year on one sheet, you can repeat the Budgeted, Actual, and Difference columns for each month, or create a separate tab for each month. Monthly tabs tend to be easier to read.
List Your Income
Start with your take-home pay, the money that actually hits your bank account after taxes, retirement contributions, and other payroll deductions. If you have a single paycheck, one row is enough. If you freelance or have side income, give each source its own row.
Below the last income row, add a Total Income row. Use a SUM formula to add up all your income entries. In Google Sheets or Excel, that looks like =SUM(B2:B5), where B2 through B5 are the cells containing your income amounts. This total becomes the number your entire budget is built around.
If your income varies month to month, use your lowest recent month as the planned figure. That keeps your budget conservative, and any extra income can go straight to savings or debt.
Build Your Expense Categories
Below the income section, list every category where money leaves your account. A solid starting framework uses these ten groups, with rough percentage-of-income guidelines to help you gauge whether your allocations are reasonable:
- Housing (25 to 35 percent): rent or mortgage, property taxes, HOA fees
- Transportation (10 to 15 percent): car payment, gas, insurance, parking, transit passes
- Food (10 to 15 percent): groceries and dining out
- Utilities (5 to 10 percent): electric, water, gas, internet, phone
- Insurance (10 to 25 percent): health, life, renters or homeowners
- Medical and Healthcare (5 to 10 percent): copays, prescriptions, dental
- Savings and Debt Payments (10 to 20 percent): emergency fund contributions, extra loan payments, investments
- Personal Spending (5 to 10 percent): clothing, haircuts, subscriptions
- Entertainment (5 to 10 percent): streaming, hobbies, concerts, sports
- Miscellaneous (5 to 10 percent): gifts, donations, pet costs, anything that doesn’t fit elsewhere
These percentages are guidelines, not rules. Someone in an expensive housing market will spend more on rent and less elsewhere. The point is to make sure you have a row for every type of spending so nothing slips through uncounted. Add categories like kids, pets, education, or travel if they apply to your life.
After the last expense row, add a Total Expenses row with another SUM formula covering all expense amounts.
Add the Key Formulas
Three formulas do most of the work in a budget spreadsheet. None of them require advanced spreadsheet knowledge.
Sum Totals
You’ve already placed SUM formulas for Total Income and Total Expenses. The syntax is the same in both Excel and Google Sheets: =SUM(B2:B10) adds up everything in cells B2 through B10. Adjust the cell range to match your actual rows.
Difference (Budgeted Minus Actual)
In your Difference column, subtract the actual amount from the budgeted amount. If your budgeted groceries are in cell B12 and actual groceries are in C12, the formula is =B12-C12. A positive number means you came in under budget. A negative number means you overspent. Copy this formula down the Difference column for every category.
Remaining Balance
At the bottom of your sheet, add a row that subtracts Total Expenses from Total Income: =B2-B25 (substituting your actual cell references). This is the single most important number in your budget. If you’re using a zero-based approach, where every dollar of income is assigned to a category including savings, this number should be zero. If it’s positive, you have unassigned money. If it’s negative, your planned spending exceeds your income and you need to cut somewhere.
Consider the Zero-Based Approach
A zero-based budget means income minus all expenses (including savings) equals zero. Every dollar has a job. If you earn $5,000 a month, your expense categories should add up to exactly $5,000, with savings and debt payments treated as “expenses” that get funded just like rent or groceries.
To set this up in your spreadsheet, prioritize your categories from top to bottom in order of importance: savings first, then essentials like food, utilities, housing, and transportation, then insurance and healthcare, then everything else. Fill in budgeted amounts starting from the top. When you reach zero remaining, stop. If you overspend in one category during the month, move money from another category to keep the balance at zero rather than just going over.
Keeping a buffer of $100 to $300 in your checking account is smart even with a zero-based budget. Think of it as a built-in safety net for rounding errors and timing mismatches between bills and paychecks. You can add a “Buffer” row in your spreadsheet so it’s accounted for.
Enter Transactions Throughout the Month
A budget only works if you update it regularly. You have a few options for getting spending data into your sheet.
The simplest method is manual entry. Each time you spend money or at the end of each day, type the amount into the Actual column for the right category. This takes a couple of minutes and has the side benefit of forcing you to look at every purchase.
If you prefer batch updates, most banks let you download your transaction history as a CSV file. Open that file in your spreadsheet app, sort or filter by merchant type, and total each category. Then paste those totals into your budget sheet’s Actual column weekly or biweekly.
For a more automated setup, third-party services like Tiller can link directly to your bank accounts and pull transactions into Google Sheets automatically. These tools typically charge a subscription fee but save significant time if you have many accounts or hate manual data entry.
Add Visual Indicators
Numbers alone can be hard to scan quickly. Two visual tools make your budget easier to read at a glance.
Conditional formatting lets you color-code cells based on their values. Set a rule so that cells in your Difference column turn green when positive (under budget) and red when negative (over budget). In Google Sheets, select the cells, click Format, then Conditional formatting, and create rules for “less than 0” and “greater than or equal to 0.” Excel has a nearly identical process under the Home tab.
A pie chart showing your expense breakdown by category gives you an instant picture of where your money goes. Select your category names and their actual spending amounts, insert a chart, and choose pie. If housing dominates 60 percent of the chart and you expected 30 percent, that visual makes the problem obvious in a way a column of numbers might not.
Make a Fresh Budget Each Month
Your expenses shift from month to month. Car insurance might be due quarterly, holiday gifts spike in December, and summer utility bills look different from winter ones. Before each new month starts, duplicate your sheet’s tab, clear the Actual column, and adjust the Budgeted column to reflect what you know is coming. Keep old months’ tabs intact so you can look back and spot trends.
After two or three months of tracking, your Actual columns become your best planning tool. If you consistently budget $400 for groceries but spend $500, either adjust the budget to $500 and cut elsewhere, or change your shopping habits. The spreadsheet doesn’t judge. It just shows you the math.