Free Google Sheets Budget Template
List your income and expenses once, fill in the actual amounts as the month goes, and the totals and leftover cash update on their own. Positive differences mean you came in better than planned.
What it looks like
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Type | Budgeted | Actual | Difference |
| 2 | Salary | Income | 5,000 | 5,000 | 0 |
| 3 | Side income | Income | 500 | 650 | 150 |
| 4 | Rent | Expense | 1,600 | 1,600 | 0 |
| 5 | Groceries | Expense | 600 | 645 | -45 |
| 6 | Utilities | Expense | 220 | 198 | 22 |
| 7 | Transport | Expense | 250 | 210 | 40 |
| 8 | Dining out | Expense | 200 | 265 | -65 |
| 9 | Savings | Expense | 1,000 | 1,000 | 0 |
| 10 | Total income | 5,500 | 5,650 | 150 | |
| 11 | Total expenses | 3,870 | 3,918 | -48 | |
| 12 | Left over | 1,630 | 1,732 | 102 |
What's included
- Budget vs actual for every category
- Income and expense totals with SUMIF, so new rows are picked up by type
- Leftover cash for the month, planned and real
- Positive difference always means "better than planned"
How to set up the budget template
- 1.Download the CSV and open it in Google Sheets (File → Import → Upload).
- 2.Replace the sample categories with your own. Keep the Type column as Income or Expense.
- 3.Enter your planned amounts in Budgeted at the start of the month.
- 4.Add real spending to Actual as you go. Totals and Left over update automatically.
- 5.Duplicate the tab each month (right-click the tab → Duplicate) to keep a history.
Questions
- Is this budget template free?
- Yes. Download the CSV, import it into Google Sheets, and it is yours to edit. No sign-up.
- How do I add more categories?
- Insert a row above "Total income" and fill in Category, Type, Budgeted and Actual. Expand the SUMIF ranges (B2:B9 etc.) to include the new row.
More templates
Expense Tracker
Log every expense with a date and category, and see totals per category update instantly.
Get the templateInvoice Template
A clean Google Sheets invoice with line items, subtotal, tax and total due calculated for you.
Get the templateCalendar Template 2026
A Monday-first monthly calendar for Google Sheets that rebuilds itself when you change the month.
Get the template