How to create a budget in Google Sheets — step-by-step

How to create a budget in Google Sheets: set up a sheet with income and expense categories, enter recurring and variable items, add formulas (SUM, SUMIF or simple arithmetic) to calculate totals and remaining balance, then create a summary table and a chart. Below is a practical, step-by-step method you can apply to a personal or household monthly budget, with formulas, a worked example, and a short checklist for ongoing maintenance.

Quick plan: what this guide covers

Short answer first: create two working tables (income and expenses), add totals with SUM and conditional totals with SUMIF, build a summary section that shows net cash and progress toward goals, and add a chart for visual tracking. The instructions that follow assume basic familiarity with Sheets navigation and the ability to enter a formula into a cell.

1. Prepare your Google Sheet: columns, categories, and layout

Start a new spreadsheet and name the file so you can reuse it as a template. Reserve the first sheet for the monthly working budget and add a second sheet for a yearly overview or for storing category lists.

2. Add income and expense entries

Record each transaction as a separate row. For recurring items use a single row per recurrence or copy the row for each month depending on how granular you want reporting to be.

Category lists and consistency

Use the lookup table or Data Validation to enforce category choices. Consistent categories let SUMIF and pivot summaries work correctly without manual cleanup.

3. Core formulas: totals and conditional sums

Key formulas you will use are SUM for simple totals, SUMIF for category or type-based totals, and simple arithmetic for balances. You can find additional guidance on common budget formulas at essential sheet formulas.

Basic examples

  1. Total expenses (assuming Amount in column D and Type in column E): =SUMIF(E:E,"Expense",D:D)
  2. Total income: =SUMIF(E:E,"Income",D:D)
  3. Net balance: =Total income cell - Total expenses cell

For per-category totals use =SUMIF(CategoryRange,"Groceries",AmountRange). If you want to summarize by date range use SUMIFS to set multiple criteria.

4. Build a summary section and a visual chart

Create a compact summary at the top-right of the sheet that pulls totals and highlights remaining cash and savings progress. A short summary improves clarity when you open the file each month.

What to include in the summary

Adding a chart

Select the summary rows or a small pivot table and use Insert > Chart to create a column or pie chart. A pie chart is helpful for showing expense distribution; a column chart works for month-to-month comparisons. Charts refresh when you update the underlying data.

5. Worked example: three-step setup with numbers

This short example shows how formulas interact. Imagine these entries for a month: Salary

,000 (Income), Rent
,000 (Expense), Groceries
50 (Expense), Utilities
50 (Expense), Freelance
00 (Income), Savings transfer 00 (Expense).

  1. Enter each as a row with Type marked Income or Expense and Amount values.
  2. Compute totals:
  3. Net balance cell: =Total income - Total expenses returns
    ,600. Use that to decide if the planned savings transfer is sustainable and how much to allocate to an emergency fund.

Adjust categories or amounts and watch how the summary and charts update automatically.

6. Templates and automating repetitive tasks

When your sheet is working, save it as a template by making a copy and clearing the transaction rows or keeping a blank "template" sheet inside the file. You can also automate entry with external forms or bank exports. For options to streamline entries, see automating data entry.

If you expect similar monthly rows, create a duplicate month tab in one click and update dates instead of rebuilding formulas.

7. Maintenance checklist (monthly)

  1. Reconcile entries with bank or card statements to catch missing transactions.
  2. Copy last month’s sheet to preserve a record and start a fresh month.
  3. Update recurring items and adjust category mappings if you introduced new expense types.
  4. Review charts and the net balance; move any excess to savings if possible.

8. Common mistakes and how to avoid them

Many budgets fail because of inconsistent categories, broken formulas, or missing recurring entries. Watch for these pitfalls:

9. Next steps and resources

After you have one month working reliably, create a single page that rolls up monthly totals for the year. If you prefer a ready-made layout, test a prebuilt option such as a monthly budget template and adapt it to your categories and local currency.

Keep the sheet simple at first. The goal is accuracy and regular updating, not complexity. Once the basics are reliable you can add conditional formatting, alerts, and additional charts for savings and debt reduction.

Closing: A practical Google Sheets budget combines clear categories, consistent entry, a few SUM and SUMIF formulas, and a small summary with a chart. Save your working file as a template, establish a short monthly checklist, and adjust categories as your finances change to keep the budget useful.