Skip to main content

How do you set up a spreadsheet budget?

A spreadsheet budget is a digital tool—typically built in Excel, Google Sheets, or a similar program—where you list your income, categorize your expenses, track actual spending against planned amounts, and calculate how much money is left over for savings or debt payoff. Unlike budgeting apps that import bank data automatically, a spreadsheet requires you to manually enter transactions or upload them, giving you a hands-on awareness of your finances. It's infinitely customizable, it's free or low-cost (if you use Google Sheets), and it makes patterns in your spending visible through formulas, subtotals, and charts.

A spreadsheet budget bridges the gap between the tactile cash-stuffing method and fully automated budgeting apps. You get the control and customization of a spreadsheet plus enough structure to enforce discipline without overwhelming complexity.

Quick definition: A spreadsheet budget is a digital record of income and expenses organized by category, with formulas that compare budgeted vs. actual spending and flag overage automatically.

Key takeaways​

  • A basic spreadsheet has columns for category, budgeted amount, actual amount, and difference; rows for each spending category.
  • Formulas (SUM, IF, subtotals) automate calculations so you don't add numbers manually.
  • Charts (bar, pie, waterfall) reveal spending patterns visually—which categories consume the most and where you're overspending.
  • The spreadsheet must be updated weekly or monthly to stay current; if you let it lapse, it becomes a historical record, not a living budget.
  • Shared spreadsheets work for couples and families if both people commit to entering transactions and respecting the agreed totals.

Why use a spreadsheet instead of an app?​

Budgeting apps (Mint, YNAB, EveryDollar) are powerful because they connect to your bank and automatically categorize transactions. The downside: they charge monthly fees (often $10-$15), they require sharing banking credentials, and they force you into their category structure. A spreadsheet is free, private, and entirely under your control.

Spreadsheets also make it easier to see your full financial picture. Many apps compartmentalize data—one view for spending, another for savings, another for debt. A spreadsheet can show everything side-by-side in a single workbook: income on one sheet, expenses on another, debt payoff on a third, and a dashboard summarizing all of it on a fourth.

The trade-off: you update it manually. You have to remember to log transactions or sit down weekly to enter them. This friction, however, is often a feature for beginners. Manually logging each expense builds awareness in a way that passive automation doesn't. Research on budgeting shows that people who actively track spending are more likely to stick to their budgets than those who rely on automatic categorization alone.

The anatomy of a basic spreadsheet budget​

A minimal spreadsheet has this structure:

Category               Budgeted    Actual    Difference    % of Budget
Groceries               $400       $420      -$20          105%
Dining Out              $150       $180      -$30          120%
Entertainment          $100       $60       +$40          60%
Gas/Transportation     $250       $240      +$10          96%
Utilities              $200       $205      -$5           103%
Personal Care           $80       $70       +$10          88%
---
TOTAL VARIABLE        $1,180    $1,175     +$5          99.6%
---
Rent (Fixed)         $1,200     $1,200      $0           100%
Insurance (Fixed)      $300      $300       $0           100%
---
TOTAL ALL            $2,680     $2,675     +$5          99.8%

Income               $3,500
Expenses             -$2,675
Surplus/Deficit      +$825

Here's what each column does:

  • Category: the spending bucket (groceries, rent, dining, utilities, etc.).
  • Budgeted: the amount you planned to spend in that category this month.
  • Actual: the amount you've actually spent so far (or total, at month-end).
  • Difference: Budgeted minus Actual (a negative number means you overspent; positive means you spent less).
  • % of Budget: Actual divided by Budgeted, as a percentage (100% means you hit your target; 105% means you overspent by 5%).

At the bottom, you subtotal variable expenses (groceries, dining, gas—the ones that change month-to-month) and fixed expenses (rent, insurance—the same every month). Then you show total expenses and calculate the surplus (income minus expenses).

Building the spreadsheet from scratch in Google Sheets​

Step 1: Create a new sheet. Go to sheets.google.com, click "Create new spreadsheet," and give it a name like "2024 Budget."

Step 2: Set up headers. In row 1, enter your column names:

  • A1: Category
  • B1: Budgeted
  • C1: Actual
  • D1: Difference
  • E1: % of Budget

Step 3: List categories. Starting in row 2, list your spending categories. You might have:

  • Row 2: Groceries
  • Row 3: Dining Out
  • Row 4: Entertainment
  • Row 5: Gas/Transportation
  • Row 6: Utilities
  • Row 7: Phone
  • Row 8: Personal Care
  • Row 9: Gifts/Charity
  • Row 10: Subscriptions
  • (rows for fixed expenses: Rent, Insurance, Loan Payment, etc.)

Step 4: Enter budgeted amounts. In column B, enter the amount you plan to spend in each category. For groceries, if your average is $400, enter 400 in B2. For dining, if your average is $150, enter 150 in B3. Use data from your last 2-3 months of statements to set realistic targets.

Step 5: Add formulas to the Actual column. In column C, you'll log actual spending. For the first week of the month, C2 might be 95 (groceries spent so far). By week two, it might be 210. By month-end, it should be your final total.

Step 6: Calculate the Difference column. In cell D2, enter the formula =B2-C2. This subtracts actual spending from budgeted spending. A positive number means you spent less; a negative number means you overspent. Copy this formula down to all category rows (click D2, then drag the fill handle—the small square in the bottom-right corner—down to the last row).

Step 7: Calculate the % of Budget column. In cell E2, enter the formula =C2/B2. This divides actual by budgeted, showing how much of your budget you've consumed as a percentage. Format this column as a percentage (right-click, "Format as percent"). Copy the formula down.

Step 8: Create subtotals for variable and fixed expenses. Let's say rows 2-9 are variable expenses. In row 10, enter "TOTAL VARIABLE" in column A. In B10, enter =SUM(B2:B9). In C10, enter =SUM(C2:C9). In D10, enter =B10-C10. This sums all the variable spending.

Repeat for fixed expenses (rows 12-15 might be rent, insurance, loan payment, subscriptions). In row 16, enter "TOTAL FIXED" and the same SUM formulas.

In row 17, enter "TOTAL ALL." In B17, enter =B10+B16 (budgeted variable plus budgeted fixed). In C17, enter =C10+C16 (actual variable plus actual fixed).

Step 9: Calculate the surplus. Below your totals, add rows for income and net surplus.

  • Row 19: "Income" with your monthly take-home in column C (e.g., C19: 3500)
  • Row 20: "Expenses" with the formula =C17 (or just reference C17 directly)
  • Row 21: "Surplus/Deficit" with the formula =C19-C20 (income minus expenses)

If C21 is positive, you're saving money; if negative, you're spending more than you earn and going into debt.

Tracking actual spending: the weekly vs. monthly update cadence​

Once your spreadsheet is set up, you need to populate the "Actual" column. There are three approaches:

Weekly update. Every Sunday evening, log the transactions from your bank or credit card statement. Open your bank's app, look at the past week's transactions, and add them to the appropriate rows in your "Actual" column. This takes 10-15 minutes. The upside: you catch overspending early. If by week two your dining envelope is already 70% consumed, you can dial back restaurant visits before the month is over. The downside: you have to remember to do it weekly.

Monthly update. At month-end, download your full bank statement, categorize all transactions, and sum them into the spreadsheet. This is faster (one 30-minute session instead of four 15-minute sessions) but riskier: by the time you see the data, it's too late to adjust this month's spending. You can only adjust next month.

Hybrid approach. Update variable, discretionary categories weekly (groceries, dining, entertainment) because these are easy to overspend and adjust. Update fixed categories monthly since they're the same every month. This strikes a balance between awareness and effort.

For most people, a weekly update—Sunday evening, 15 minutes—becomes a routine. Some people pair it with a brief weekly "money date" where they also review savings progress or discuss financial goals with a partner.

Using formulas to flag overages automatically​

Once your spreadsheet is set up, you can add conditional formatting to highlight overspending. This is optional but useful.

In Google Sheets, select column D (the Difference column). Go to Format > Conditional formatting. Set the rule: "Less than 0" (which means you overspent). Choose a highlight color (red). Now, any time you overspend a category, that cell turns red automatically. No math required; you just scan for the red cells.

Similarly, you can add a rule to column E (% of Budget): if the percentage is greater than 100%, highlight yellow or red. This gives you a visual dashboard at a glance.

Real examples: four household budgets​

Example 1: The single person earning $4,500/month after taxes.

Her spreadsheet looks like this:

Groceries              $350       $380      -$30         109%
Dining                 $200       $150      +$50         75%
Entertainment         $100       $85       +$15         85%
Gas                    $200       $210      -$10         105%
Utilities              $150       $165      -$15         110%
Phone                  $75        $75       $0           100%
Personal Care          $80        $60       +$20         75%
Subscriptions          $50        $45       +$5          90%
---
TOTAL VARIABLE        $1,205     $1,170    +$35         97%
---
Rent                  $1,500     $1,500     $0          100%
Insurance              $300      $300       $0          100%
---
TOTAL ALL             $3,005     $2,970    +$35         99%

Income               $4,500
Expenses             -$2,970
Surplus              +$1,530

She's spending $2,970 and earning $4,500, leaving her $1,530 to allocate to savings, debt payoff, or next month's buffer. Her spreadsheet shows that she's overrunning on groceries and utilities (likely seasonal—winter heating costs) but coming in under on dining and personal care.

Example 2: The dual-income household with kids earning $6,500/month combined after taxes.

Their spreadsheet:

Groceries              $500       $550      -$50         110%
Dining                 $200       $160      +$40         80%
Kids Activities        $200       $220      -$20         110%
Childcare              $1,200     $1,200     $0          100%
Entertainment         $100       $60       +$40         60%
Gas                    $300       $310      -$10         103%
Utilities              $250       $280      -$30         112%
Phone (two lines)      $100       $100      $0          100%
Personal Care          $120       $85       +$35         71%
Subscriptions          $60        $60       $0          100%
---
TOTAL VARIABLE        $3,030     $3,025    +$5          99.8%
---
Mortgage              $2,000     $2,000     $0          100%
Insurance (home+car)   $250      $250       $0          100%
---
TOTAL ALL             $5,280     $5,275    -$5          99.9%

Income               $6,500
Expenses             -$5,275
Surplus              +$1,225

They're almost exactly on budget, with a $1,225 cushion for the month. The spreadsheet shows their utilities are running 12% over (they're setting the thermostat higher to accommodate new family members). They're under on personal care and entertainment, which suggests they're being careful about non-essentials.

Example 3: The irregular freelance income household.

This person's income varies ($2,500 one month, $4,200 the next). Their spreadsheet tracks this explicitly:

Month: January

Groceries              $400       $390      +$10         98%
Dining                 $150       $165      -$15         110%
... (other categories)

TOTAL EXPENSES                           $2,100

Income (Freelance)                       $2,800
Surplus                                  +$700 → goes to savings

Month: February

(Same categories, but freelance income was only $2,200 this month.)

TOTAL EXPENSES                           $2,150
Income (Freelance)                       $2,200
Surplus/Deficit                          +$50

They don't have a fixed monthly surplus; instead, they maintain a buffer account (separate savings) to cover months when freelance income dips. Their spreadsheet helps them forecast: in months like February, they might reduce dining and entertainment to build the buffer back up.

Example 4: The debt-payoff focused budget.

This household is aggressively paying down credit-card debt:

Groceries              $350       $340      +$10         97%
Dining                 $80        $75       +$5          94%
Entertainment         $50        $40       +$10         80%
... (minimal discretionary spending)

TOTAL EXPENSES                           $2,200

Income                                   $3,500
Extra (available for debt payoff)        -$1,300
Debt payoff (Credit Card)                $1,300

Their spreadsheet has an explicit row for debt payoff. Once they've cut discretionary spending to the minimum (97% of groceries budget, 80% of entertainment), they take the full surplus and apply it to their credit-card principal. This spreadsheet makes visible how much their lifestyle changes (eating at home, no restaurants, no shopping) are accelerating the debt payoff.

Charts and visualizations​

Once you have three or four months of data, create charts to see patterns.

Pie chart of total spending. Create a pie chart with categories on the x-axis and actual spending on the y-axis. You'll see immediately that rent is 45% of your budget, childcare is 20%, groceries are 12%, and everything else is 23%. This makes priorities visible: if you want to save more, reducing rent or childcare is the move, not cutting out $20/month on subscriptions.

Bar chart: Budgeted vs. Actual. Create a bar chart comparing budgeted and actual amounts side-by-side for each category. If the "Actual" bar is taller than the "Budgeted" bar, you overspent that category. This chart, month-over-month, shows whether you're improving or getting worse at controlling specific categories.

Waterfall chart of surplus. Starting with income, subtract each major expense category (rent, childcare, groceries, etc.) and show what's left at the end. This visual makes it clear: "We earn $6,500. After rent ($2,000), childcare ($1,200), groceries ($500), and utilities ($250), we have $2,550 left. Of that, debt payoff takes $1,300, and we save $1,250." The waterfall shows every decision's impact visually.

Spending over time. Plot actual expenses on a line chart over 6-12 months, with a horizontal line showing the budgeted average. If the line trends upward, your spending is increasing; if it trends downward, you're controlling costs. This catches gradual budget creep that you'd miss month-to-month.

Updating the spreadsheet after a big life change​

Your budget isn't static. When your circumstances change, your spreadsheet must adapt.

You get a raise. Your income goes from $3,500 to $4,200 (+$700). Update your income row. Now you have an extra $700/month. Consciously decide: does it go to savings, extra debt payoff, or increased discretionary spending? Update your budgeted amounts accordingly. Don't let lifestyle inflation (spending every penny of your raise without intention) happen by accident.

You move and rent increases. Rent was $1,200; your new place is $1,400. You lose $200/month elsewhere. Review your actual spending over the past three months and find $200 in cuts: maybe dining drops from $200 to $150, entertainment from $100 to $80, etc. Update budgeted amounts. Adjust the surplus accordingly (it shrinks by $200 + whatever the new rent actually is).

You pay off a debt. A $300/month car loan is paid off. The $300 was in your "Expenses" row; now it's gone. Add a row for "Extra Savings" or "Credit Card Payoff Acceleration" and apply that $300 there. Don't let the $300 disappear into higher spending; that's how people never build wealth.

You have a baby. Childcare, diapers, medical visits, and formula appear overnight. You might need $1,500/month extra. Restructure your budget: what gives? Maybe dining drops from $200 to $80, entertainment from $100 to $40. Maybe you reduce retirement savings temporarily. Your spreadsheet helps you model these trade-offs before they surprise you.

Common mistakes​

Mistake 1: Creating the spreadsheet but not updating it. You build a beautiful, detailed spreadsheet in January with all your categories and formulas. By March, you haven't logged a single transaction. The spreadsheet becomes a relic—your original estimates, but no actual data, so it tells you nothing. Fix: commit to weekly or monthly updates. Set a recurring calendar reminder: "Sunday 7 PM: Update budget spreadsheet." Treat it as non-negotiable as brushing your teeth.

Mistake 2: Budgeting based on wishful spending, not historical spending. You decide groceries will be $250/month because that sounds reasonable, but your last three months averaged $380. By week two, you're over budget and demoralized. Fix: base budgets on actual historical data. Look at the last 90 days of spending, calculate the average, and use that as your starting point. If you want to reduce grocery spending, do it consciously and gradually (aim for $350 next month, $320 the month after) rather than setting a fantasy number.

Mistake 3: Mixing savings goals with spending categories. You have a row for "Rent $1,500" and a row for "Savings $500." The problem: savings isn't an expense category; it's what's left after expenses. By treating it as an expense, you're conflating your outflows. Fix: keep the spreadsheet focused on income minus expenses. Below that, show the surplus and where it's allocated (savings, debt payoff, emergency fund, etc.). Savings should be calculated, not budgeted in the traditional sense.

Mistake 4: Including occasional expenses in the monthly budget. You allocate $100/month for "car maintenance" even though you don't service your car monthly. By year-end, you've "saved" $600 in car-maintenance budget that your car never needed, creating an illusion of financial health. Fix: separate occasional expenses from monthly ones. Create an "Annual Expenses" section at the bottom where you list things like car maintenance ($400/year = $33/month), annual insurance premiums ($800/year = $67/month), etc. Sum these separately. Or create a "Sinking Fund" row where you accumulate money monthly for occasional costs.

Mistake 5: Spreadsheet complexity that confuses rather than clarifies. You create a spreadsheet with 40 columns, nested subtotals, multiple sheets, complex formulas, and conditional formatting on every cell. By week two, you don't remember what half the columns do, and when you try to update it, you accidentally delete a formula and break the whole thing. Fix: start with the simplest possible structure (Category, Budgeted, Actual, Difference). Add complexity only if the simple version stops meeting your needs. Most people never need more than one sheet with five columns.

FAQ​

Should I use Excel or Google Sheets?​

Google Sheets is free, cloud-based (accessible from any device), and shareable with a partner. Excel is more powerful for advanced users but requires Microsoft Office (usually a paid subscription) and storing files on your computer or OneDrive. If you're starting out, Google Sheets is fine and probably better. If you're already deep in Excel and comfortable, stick with it.

Can a couple use a shared budget spreadsheet?​

Yes, absolutely. Both partners can log transactions in the shared sheet, and updates appear in real-time. The downside: you might overwrite each other's entries or misunderstand formatting. The fix: agree on a discipline—one person logs transactions, or each person updates their own spending categories (person A logs groceries and their personal spending, person B logs utilities and their spending). Have a weekly or monthly money date to review the spreadsheet together and discuss any surprises.

How many categories should I have?​

Start with 10-15 categories: groceries, dining, transportation, utilities, insurance, entertainment, personal care, subscriptions, gifts, and a few others specific to your life. If your category list gets to 25+, most are probably never spent in, and the spreadsheet becomes bloated. You can always add a category later if a new spending pattern emerges.

What if I have irregular monthly expenses (car registration, annual subscriptions)?​

Create a row for "Annual/Irregular Expenses" and divide the annual cost by 12 to get a monthly average. For example, if your car registration is $300/year, allocate $25/month ($300 ÷ 12). When the bill comes due, the money is already there, and you're not surprised. This is called a "sinking fund"—money accumulated over time for a future large expense.

How do I handle shared household expenses with a partner or roommate?​

Option 1: One person owns all expenses in the spreadsheet, and the other reimburses half monthly. Option 2: Create separate columns for each person's expenses, then sum them at the bottom. Option 3: Track shared expenses in one part of the sheet, personal expenses separately, and divide the shared portion. The key is transparency—both people should see the spending and agree it's accurate.

Should the spreadsheet include savings and investments?​

Track them separately. Your primary budget sheet shows income minus expenses equals surplus. Then, below that, show how the surplus is allocated: "$1,500 saved" + "$500 to investment account" + "$200 to emergency fund" = total $2,200 surplus. This keeps your spending budget focused on controllable decisions and makes it clear how much you're setting aside.

What if my income varies (freelance, commission-based)?​

Use a conservative estimate of average monthly income (your lowest reasonable month, or the 12-month average if it's volatile). Build a cushion for months when income is lower. Or, create a "Variable Income" sheet that tracks your actual income month-to-month, and adjust expenses when months are lean. Some people with variable income budget conservatively and treat income above the estimate as extra to save.

Summary​

A spreadsheet budget is a customizable, free digital tool for tracking income and expenses. You list categories, estimate monthly budgets based on historical data, log actual spending, and use formulas to calculate surpluses and flag overages. Unlike automated apps, spreadsheets require manual updates—a drawback that doubles as a feature, increasing spending awareness. With consistent weekly or monthly logging, charts, and quarterly adjustments, a spreadsheet becomes a living financial dashboard that makes your entire budget visible at a glance and enables intentional decisions about where your money goes.

Next​

→ Budgeting app comparison