en
Back to Financial budget
Simple budget spreadsheet screen: writing without adding crossed out, categories added with SUMIF and an automatic month's balance, with a spreadsheet ready badge
Financial budget

Simple Budget Spreadsheet: How to Build It in 10 Steps, With Formulas

Create Transactions and Summary tabs, use fixed categories with a dropdown, copy the SUMIF total and balance formulas, compare planned and actual and enter expenses every week.

⚪ Intermediate Estimated time 15 minutes Step by step 10 steps

By

Quick answer: how to make a simple budget spreadsheet

  1. Open Google Sheets, Excel or LibreOffice Calc and create two tabs: Transactions and Summary.
  2. In Transactions, use the columns Date, Description, Category, Type (Income or Expense) and Amount.
  3. Create a fixed category list with a dropdown, so you don't mistype.
  4. In Summary, use SUMIF to add up each category and compare planned and actual.
  5. Enter expenses every week and, at the end of the month, see where you went over.

What's your case?

How to build a simple budget spreadsheet: 10 steps

1Pick the app and create two tabs

  • Google Sheets: free, works in the browser and in the phone app, and saves automatically.
  • Excel or LibreOffice Calc (free): good for using on a computer.
  • Create a file with two tabs: Transactions (each income and expense) and Summary (the month's totals).

2Set up the Transactions tab columns

Example transactions tab: R$ 3,000 salary as income, R$ 1,100 rent, R$ 420 groceries and R$ 65 delivery as expenses, with a R$ 1,415 balance
  • In row 1, type the headers: A Date, B Description, C Category, D Type, E Amount.
  • In Type, use only two words: Income or Expense.
  • Always type the amount as a positive number; the Type column decides whether it adds or subtracts.
  • One row for each transaction, including bank transfers and cash spending.

3Use a few categories with a dropdown

  • Use 8 to 10 categories: Earnings, Housing, Food, Transportation, Health, Education, Bills, Leisure, Debt, Savings.
  • In column C, create a dropdown with those categories. That way you won't have “Groceries” one month and “groceries” the next, which would break the totals.
  • In Google Sheets, select the column and use Insert > Dropdown (or Data > Data validation). Do the same in column D with Income and Expense.

4Copy the total and balance formulas

  • Total income: =SUMIF(D:D,"Income",E:E)
  • Total expenses: =SUMIF(D:D,"Expense",E:E)
  • Month's balance: =SUMIF(D:D,"Income",E:E)-SUMIF(D:D,"Expense",E:E)
  • SUMIF adds only the rows that meet a condition. In English-language settings, separate the arguments with commas; if your spreadsheet uses another region, it may require semicolons.

5Build the Summary tab with planned and actual

How to build the spreadsheet, in this order: transactions tab, fixed categories with a dropdown, summary tab with planned and actual, sum and balance formulas and a color alert
  • In the Summary tab, create the columns: A Category, B Planned, C Actual, D Difference, with one category per row.
  • In B, type how much you plan to spend on each category that month.
  • In C2, add up what was spent: =SUMIF(Transactions!C:C,A2,Transactions!E:E) and drag it down to the other rows.
  • In D2, the difference: =B2-C2. A negative number means you went over.

See how to organize your monthly budget to set the planned amounts.

6Turn overspending red

  • Select the Actual column (C2 down to the end) and open Conditional formatting.
  • Choose the custom formula option and use =C2>B2, with a red fill.
  • Done: the category turns red on its own when spending goes over plan.

7Enter expenses from your phone

  • Install your spreadsheet's app and keep the file pinned or starred.
  • Enter each expense right away or set aside 5 minutes a week. Don't rely on memory: small expenses vanish fast.
  • Add your fixed bills at the start of the month, with their due dates.

See how to track daily expenses.

8Check against your statement and card bill

  • Once a week, compare the spreadsheet with your bank statement and credit card bill and add what's missing.
  • Many banks let you export the statement as a spreadsheet file, which makes copying entries easier.
  • Installment purchases: enter only that month's installment, not the full price.

9Start a new month without redoing everything

  • At the end of the month, make a copy of the file and name it after the new month (for example, “Finances 2026-12”).
  • In the copy, delete only the transactions. Categories, formulas and colors keep working.
  • Adjust the planned amounts based on what happened the previous month.

10Use the summary to make decisions

Finished spreadsheet checklist: transactions tab, fixed category list with a dropdown, summary tab with planned and actual, SUMIF formulas, month's balance and red alert
  • Look at the 3 categories with the highest spending: that's where a cut makes a difference.
  • Negative balance? Cut waste first, such as late fees and interest, then nonessentials.
  • Positive balance? Add a Savings row and transfer the money on payday.

See how to cut unnecessary expenses.

Problem and fix

Common budget spreadsheet problems and how to fix each one
ProblemLikely causeFix
Formula shows an errorWrong separatorSwap commas for semicolons, or the other way around (step 4)
Category adds up to zeroName typed differentlyUse a dropdown (step 3)
Balance doesn't match the bankMissing entriesCheck against the statement (step 8)
Installments distort the monthFull price enteredEnter only the installment (step 8)
I don't notice overspendingNo visual alertConditional formatting (step 6)
I give up on the spreadsheetWriting only at month-endUse it on your phone every week (step 7)

Frequently asked questions

Which app should I use for a budget spreadsheet?

Any of them works. Google Sheets is free and works on your phone; Excel and LibreOffice Calc are good options on a computer.

Which columns does a budget spreadsheet need?

Date, Description, Category, Type (Income or Expense) and Amount. If you like, add the payment method.

How do I add up spending by category?

Use SUMIF: =SUMIF(Transactions!C:C,A2,Transactions!E:E), where A2 is the category name in the Summary tab.

Why does my formula show an error?

The most common cause is the separator. Some regional settings use commas between arguments and others use semicolons. Also check that the tab name matches exactly.

How do I calculate the month's balance?

Add income and subtract expenses: =SUMIF(D:D,"Income",E:E)-SUMIF(D:D,"Expense",E:E).

How many categories should I use?

Between 8 and 10. Too many categories make the spreadsheet hard to keep up and to analyze.

How do I enter an installment purchase?

Enter only the installment amount each month, on the date of the card bill where it shows up.

How do I make next month's spreadsheet?

Make a copy of the file, delete the transactions and adjust the planned amounts. Formulas and colors keep working.

How often should I update it?

Ideally, right away. If you can't, set aside 5 minutes a week and check against your statement.

Spreadsheet or budgeting app?

A spreadsheet gives you full control and is free. Apps categorize on their own. The best one is the one you'll actually use every week.

More practical solutions in Financial budget.

Sources

The images on this page are illustrations created by Fixfy. Amounts are examples. Menu names may change depending on the app version.