How to Make a Monthly Budget in Google Sheets: Free Template, Formulas, and Spending Review
Google Sheetsbudgetingspreadsheetstemplatespersonal finance

How to Make a Monthly Budget in Google Sheets: Free Template, Formulas, and Spending Review

HHow-To Hub Editorial Team
2026-11-15
6 min read

Build a reusable monthly budget in Google Sheets with a copy-ready template, formulas, transaction tracking, and a practical review routine.

Learn how to make a monthly budget in Google Sheets using a reusable layout for income, bills, flexible spending, savings, and irregular costs. This step-by-step guide includes a copy-ready template, practical Google Sheets budget formulas, a worked example, and a monthly review routine so you can plan before spending and compare your plan with what actually happened.

Overview

A monthly budget spreadsheet works best when it separates three things: money you expect to receive, money you plan to spend, and money you actually spend. Google Sheets is useful because you can duplicate a month, change a few inputs, and let formulas recalculate totals without rebuilding the budget.

Before you begin, create a new spreadsheet at sheets.google.com and name it something recognizable, such as Monthly Budget 2026. Keep the file private unless you intentionally need to share it. If another person will review the budget, check the sharing setting and give only the access level they need. Avoid entering full account numbers, passwords, or other sensitive information.

Use two sheets:

  • Budget: the monthly plan, category totals, and summary.
  • Transactions: the individual purchases, deposits, and transfers you record during the month.

This separation keeps the summary readable while preserving enough detail to investigate a category later. If you already track academic expenses, you can also adapt the same structure for tuition, books, transport, and school supplies. For another spreadsheet workflow, see how to track grades in Google Sheets.

How to estimate

Start with a conservative estimate rather than an ideal month. Use income you reasonably expect to receive during the month, and use recent bills, receipts, or account records to estimate spending. When an amount varies, choose a figure that leaves some room instead of assuming the lowest possible cost.

1. Set up the Budget sheet

In row 1, enter a title such as Monthly Budget — January. In row 3, create these headers:

CategoryTypePlannedActualDifferenceNotes
PaycheckIncome000Expected deposit
Rent or housingFixed000Due date
GroceriesVariable000Weekly estimate
Emergency savingsSavings000Transfer amount
Annual fee fundIrregular000Set-aside

Replace the example rows with categories that match your situation. Common categories include utilities, phone, internet, transportation, insurance, debt payments, dining out, subscriptions, healthcare, school expenses, personal care, gifts, and entertainment.

2. Add summary formulas

Place a small summary near the top of the sheet, for example in cells H3:I7:

Summary itemFormula
Planned income=SUMIF(B4:B100,"Income",C4:C100)
Actual income=SUMIF(B4:B100,"Income",D4:D100)
Planned spending and savings=SUMIF(B4:B100,"<>Income",C4:C100)
Actual spending and savings=SUMIF(B4:B100,"<>Income",D4:D100)
Planned remaining=I4-I6

Adjust the cell references if your headings or rows are in different locations. The final formula should subtract planned spending and savings from planned income. Add a corresponding actual remaining formula by subtracting actual spending and savings from actual income.

3. Calculate category differences

In E4, enter:

=C4-D4

Copy the formula down the column. A positive result means the actual amount is below the plan. A negative result means the actual amount is above the plan. For income, you may prefer =D4-C4 so that receiving more income appears positive. If you use one difference formula for every row, label the column clearly and interpret income rows separately.

4. Record transactions

On the Transactions sheet, add these headers: Date, Description, Category, Type, Amount, Account, Notes. Enter one transaction per row. Use consistent category names so that totals can be calculated accurately. For example, do not alternate between “Eating out,” “Restaurants,” and “Dining” unless you intend to treat them as separate categories.

You can calculate actual spending for a category with a formula such as:

=SUMIF(Transactions!C:C,A4,Transactions!E:E)

Here, A4 contains the category name on the Budget sheet, column C on Transactions contains categories, and column E contains amounts. If your transaction list includes income and expenses together, use the Type column to refine the calculation with SUMIFS.

Inputs and assumptions

A budget is an estimate, so document the assumptions behind each important number. This makes the spreadsheet easier to update and prevents forgotten costs from appearing as surprises.

  • Income: Enter take-home income or the amount actually available to spend, not a gross figure that includes deductions you will not receive.
  • Fixed bills: Use the amount normally due. If a bill changes regularly, record the expected amount and add a note explaining the estimate.
  • Variable spending: Review several recent weeks or months if records are available. Separate essential and optional categories when that distinction helps you make decisions.
  • Irregular expenses: Divide an expected annual or occasional cost into planned monthly contributions. For example, a $600 expense expected in 12 months can be represented by $50 per month, provided the timing and total are realistic.
  • Savings and debt: List planned transfers or payments as budget lines so they are not mistaken for leftover money.
  • Buffer: Add a category for unplanned but ordinary expenses if your budget regularly changes during the month.

Use data validation for the Type column if you want consistent labels. Select the cells, open Data, choose Data validation, and create a dropdown containing labels such as Income, Fixed, Variable, Savings, and Irregular. Menu names can change, so if the option is not in the same place, use Sheets’ menu search to find “data validation.”

For readability, format planned and actual amounts as currency, freeze the header row, and apply conditional formatting to negative differences. Keep formulas in summary cells separate from manually entered values, and protect formula ranges if several people edit the file.

Worked examples

Suppose a month begins with planned income of $2,400. Your planned costs are $900 for housing, $350 for groceries, $180 for transportation, $120 for utilities and phone, $150 for savings, and $300 for other categories. Planned spending and savings total $2,000, leaving a planned remainder of $400.

During the month, actual groceries reach $390, transportation is $140, and the savings transfer is $150. If the other categories total $280, actual spending and savings are $1,960 for those listed categories. The category difference for groceries is:

=350-390

The result is -40, showing that groceries exceeded the plan by $40. Transportation produces:

=180-140

The result is 40, showing that transportation was $40 below the plan. Do not treat a positive difference in one category as permission to spend more automatically. First check whether another category, an irregular expense, or a lower-than-expected income amount explains the remaining cash.

At the end of the month, add a short note beside each significant difference: “higher grocery prices,” “fewer trips,” “annual renewal,” or “planned transfer moved to next month.” These notes make the next budget more accurate than simply copying last month’s numbers.

When to recalculate

Revisit the spreadsheet at three useful points: before the month starts, during the month, and after the month ends.

  1. Before the month starts: Duplicate the previous month’s Budget and Transactions sheets, rename them, clear transaction amounts that do not carry forward, and update income, due dates, bills, savings, and irregular expenses.
  2. During the month: Record transactions at least weekly. Check the remaining amount in variable categories and adjust future spending while there is still time to act.
  3. At month-end: Compare planned and actual totals, identify the three largest differences, and carry forward only categories that still apply. Do not copy an unusual one-time expense into every future month without deciding whether it should become an irregular-expense sinking fund.

Recalculate immediately after a change in income, housing, debt payments, recurring subscriptions, household responsibilities, or a major financial goal. Review irregular expenses before their likely due dates, and refresh estimates at the start of each calendar year if bills, rates, or personal circumstances have changed.

For a simple monthly checklist, confirm that you have: entered expected income, listed fixed bills, estimated variable categories, included savings and irregular costs, checked the remaining balance, recorded transactions, and reviewed the largest variances. Save a clean blank copy of the workbook as your master template. That way, each new month starts with a reliable structure instead of a new spreadsheet built from scratch.

Related Topics

#Google Sheets#budgeting#spreadsheets#templates#personal finance
H

How-To Hub Editorial Team

Practical How-To Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.