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

ABCDE
1CategoryTypeBudgetedActualDifference
2SalaryIncome5,0005,0000
3Side incomeIncome500650150
4RentExpense1,6001,6000
5GroceriesExpense600645-45
6UtilitiesExpense22019822
7TransportExpense25021040
8Dining outExpense200265-65
9SavingsExpense1,0001,0000
10Total income5,5005,650150
11Total expenses3,8703,918-48
12Left over1,6301,732102
Tab: Monthly budget. Teal cells are live formulas; hover one to see it.

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. 1.Download the CSV and open it in Google Sheets (File → Import → Upload).
  2. 2.Replace the sample categories with your own. Keep the Type column as Income or Expense.
  3. 3.Enter your planned amounts in Budgeted at the start of the month.
  4. 4.Add real spending to Actual as you go. Totals and Left over update automatically.
  5. 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