Quick answer: how to make a simple budget spreadsheet
- Open Google Sheets, Excel or LibreOffice Calc and create two tabs: Transactions and Summary.
- In Transactions, use the columns Date, Description, Category, Type (Income or Expense) and Amount.
- Create a fixed category list with a dropdown, so you don't mistype.
- In Summary, use SUMIF to add up each category and compare planned and actual.
- 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

- 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

- 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.
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

- 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.
Problem and fix
| Problem | Likely cause | Fix |
|---|---|---|
| Formula shows an error | Wrong separator | Swap commas for semicolons, or the other way around (step 4) |
| Category adds up to zero | Name typed differently | Use a dropdown (step 3) |
| Balance doesn't match the bank | Missing entries | Check against the statement (step 8) |
| Installments distort the month | Full price entered | Enter only the installment (step 8) |
| I don't notice overspending | No visual alert | Conditional formatting (step 6) |
| I give up on the spreadsheet | Writing only at month-end | Use 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.
Related content
More practical solutions in Financial budget.
How to Cancel Forgotten Subscriptions and Save Money
Find recurring subscriptions that may be consuming your budget and learn how to identify automatic charges and cancel services you no longer use.
Credit Score: How It Works and What Influences Your Score
Understand what a credit score is, which factors may influence it, and how to maintain a more organized financial history.
How to Cut Unnecessary Expenses Without Giving Up Everything
Learn how to identify low-value spending, reduce waste, and save money without unnecessarily sacrificing your quality of life or essential needs.
Sources
- Google Help: SUMIF function
- Google Help: create an in-cell dropdown list
- Google Help: use conditional formatting rules
- Microsoft Support: SUMIF function in Excel
- Central Bank of Brazil: Starting adult life (knowing your expenses, in Portuguese)
The images on this page are illustrations created by Fixfy. Amounts are examples. Menu names may change depending on the app version.