Budget Template Google Sheets

Free. No email, no sign-up.

Google Sheets budget template: six free versions with formulas

These are free budget templates for Google Sheets. Pick the one that matches how you get paid, make a copy or download the .xlsx, and replace the sample numbers with your own.

Start with Monthly Budget if you are paid once a month. Use Biweekly if you are paid every two weeks, Zero-Based or 50/30/20 if you want a method, Couples for shared bills, and Annual for the whole year.

Updated November 17, 2026

CategoryPlannedActualDifference
Paycheck$4,200.00$4,200.00$0.00
Rent$1,500.00$1,500.00$0.00
Groceries$520.00$573.93-$53.93
Dining out$200.00$198.50$1.50
Subscriptions$45.00$44.97$0.03
Total expenses$4,045.00$4,021.30$23.70
C21 adds the Actual column. Each line above it is a SUMIF over your transactions.

Which budget template should I use?

Match the template to how you get paid and how you like to plan. Monthly Budget fits one salary. Biweekly fits a paycheck every two weeks. Zero-Based and 50/30/20 are methods. Couples splits shared bills. Annual plans all twelve months.

Your situationTemplateBuilt for
You are paid once a month, or you just want one simple budget.Monthly BudgetOne salary, one month at a time
You are paid every other week and bills do not line up with your paycheck.Biweekly Paycheck BudgetPaid every two weeks, 26 paychecks a year
You want income minus assigned money to equal zero.Zero-Based BudgetYou want every dollar assigned
You want to see needs, wants and savings as a share of income.50/30/20 BudgetYou want a simple rule, not a system
You share bills and want a fair split, equal or by income.Couples and Household BudgetTwo incomes and shared bills
You plan the whole year and have costs that come once a year.Annual BudgetPlanning 12 months, with yearly bills

Is there a free budget template for Google Sheets?

Yes. The six templates below are free, with no email address and no sign-up. Each one has live formulas, sample data you can clear, and a short guide to its formulas.

Yellow cells are inputs. White cells are formulas. The sample figures are realistic US numbers, and the totals shown on this page are computed by the same formulas as the files.

01

Monthly Budget

One salary, one month at a time

Planned against actual for one month. Type payments on the Transactions tab and the Actual column fills itself.

Sample results

Planned left over
$255.00
Actual left over
$328.70
Actual expenses
$4,021.30

Tabs and preview

Budget Planned amounts you type, actuals that fill themselves, and the difference.
RowABCD
1CategoryPlannedActualDifference
2Income
3Paycheck$4,200.00$4,200.00$0.00
4Other income$100.00$150.00$50.00
5Total income$4,300.00$4,350.00$50.00
6
7Expenses
8Rent$1,500.00$1,500.00$0.00
9Utilities$180.00$170.55$9.45
10Groceries$520.00$573.93-$53.93
11Transportation$260.00$237.40$22.60
12Insurance$210.00$207.00$3.00
13Phone and internet$120.00$119.00$1.00
14Dining out$200.00$198.50$1.50
15Subscriptions$45.00$44.97$0.03
16Health$90.00$81.50$8.50
17Fun$150.00$136.00$14.00
18Household and other$120.00$102.45$17.55
19Debt payment$250.00$250.00$0.00
20Savings$400.00$400.00$0.00
21Total expenses$4,045.00$4,021.30$23.70
Transactions One line per payment or paycheck. The category must match a category on the Budget tab.
RowABCD
1DateDescriptionCategoryAmount
2Oct 1, 2026Employer payrollPaycheck$4,200.00
3Oct 1, 2026LandlordRent$1,500.00
4Oct 2, 2026Grocery storeGroceries$96.40
5Oct 3, 2026Electric and gasUtilities$112.35
6Oct 3, 2026Mobile and internetPhone and internet$119.00
7Oct 4, 2026Gas stationTransportation$48.20
8Oct 5, 2026Coffee and lunchDining out$34.75
9Oct 6, 2026Streaming and appsSubscriptions$44.97
10Oct 7, 2026Grocery storeGroceries$132.18
11Oct 8, 2026Auto insuranceInsurance$207.00
12Oct 9, 2026PharmacyHealth$36.50
13Oct 10, 2026Transit passTransportation$90.00
14Oct 11, 2026Dinner outDining out$78.60
15Oct 12, 2026CinemaFun$41.00
16Oct 13, 2026Hardware storeHousehold and other$62.30
17Oct 14, 2026Student loanDebt payment$250.00
18Oct 15, 2026Freelance paymentOther income$150.00
19Oct 16, 2026Grocery storeGroceries$118.92
20Oct 17, 2026Gas stationTransportation$51.40
21Oct 18, 2026Concert ticketsFun$95.00
22Oct 19, 2026Water billUtilities$58.20
23Oct 20, 2026BrunchDining out$46.25
24Oct 22, 2026Grocery storeGroceries$124.77
25Oct 24, 2026Dentist copayHealth$45.00
26Oct 25, 2026Transfer to savingsSavings$400.00
27Oct 27, 2026Grocery storeGroceries$101.66
28Oct 28, 2026Gas stationTransportation$47.80
29Oct 29, 2026TakeoutDining out$38.90
30Oct 30, 2026Household suppliesHousehold and other$40.15
31
32
33
Summary Income, expenses and what is left, planned against actual.
RowABC
1MeasurePlannedActual
2Total income$4,300.00$4,350.00
3Total expenses$4,045.00$4,021.30
4Net (income minus expenses)$255.00$328.70
5Share of income left5.9%7.6%

Formulas explained

  • =SUMIF(Transactions!$C$2:$C$33,A3,Transactions!$D$2:$D$33)in Budget!C3Adds every transaction whose category matches the name in column A. This is the Actual column.
  • =B8-C8in Budget!D8Planned minus actual. A negative number means you spent more than planned, and the cell turns red.
  • =SUM(B3:B4)in Budget!B5Adds the planned income lines. The same pattern totals each column.
  • =B2-B3in Summary!B4Total income minus total expenses. This is the money left.

02

Biweekly Paycheck Budget

Paid every two weeks, 26 paychecks a year

Each bill is assigned to the first or second paycheck of the month. Two months a year have three paychecks, and the third one carries no bills.

Sample results

Left over for the year
$19,560.00
Extra paychecks
2
Left from extra paychecks
$4,800.00

Tabs and preview

Paychecks One row per paycheck for the year. Pay dates chain from the first date, 14 days apart.
RowABCDEF
1Pay dateNet payPaycheck of monthBills dueLeft overFlag
2Jan 1, 2027$2,400.001$1,975.00$425.00
3Jan 15, 2027$2,400.002$1,595.00$805.00
4Jan 29, 2027$2,400.003$0.00$2,400.00Extra paycheck
5Feb 12, 2027$2,400.001$1,975.00$425.00
6Feb 26, 2027$2,400.002$1,595.00$805.00
7Mar 12, 2027$2,400.001$1,975.00$425.00
8Mar 26, 2027$2,400.002$1,595.00$805.00

Showing 8 of 27 rows. The file has all of them.

Bills Each bill and which paycheck of the month pays it. The third paycheck of a month carries no bills.
RowABCD
1BillDue dayPaid from paycheckAmount
2Rent11$1,450.00
3Car insurance51$140.00
4Phone81$85.00
5Groceries, first half11$300.00
6Student loan172$260.00
7Utilities202$190.00
8Internet222$70.00
9Credit card payment242$300.00
10Streaming252$25.00
11Gym262$40.00
12Groceries, second half152$300.00
13Car payment282$410.00
14
15
16
17Paycheck 1 bills$1,975.00
18Paycheck 2 bills$1,595.00
Summary Year totals and the money from the two extra paychecks.
RowAB
1MeasureAmount
2Paychecks in the year26
3Net pay for the year$62,400.00
4Bills for the year$42,840.00
5Left over for the year$19,560.00
6Extra paychecks (third in a month)2
7Left over from extra paychecks$4,800.00

Formulas explained

  • =A2+14in Paychecks!A3Adds 14 days to the date above. Type the first pay date once and the other 25 follow.
  • =IF(MONTH(A3)=MONTH(A2),C2+1,1)in Paychecks!C3Counts which paycheck of the month this is. It restarts at 1 when the month changes.
  • =IF(C2=1,Bills!$D$17,IF(C2=2,Bills!$D$18,0))in Paychecks!D2Looks up the total for the paycheck of the month. A third paycheck has no bills.
  • =SUMIF($C$2:$C$15,1,$D$2:$D$15)in Bills!D17Adds every bill marked as paid from paycheck 1. The row below does the same for paycheck 2.
  • =SUMIF(Paychecks!$C$2:$C$27,3,Paychecks!$E$2:$E$27)in Summary!B7Adds what is left from every third paycheck in the year.

MoneyCoach also has a guide to a free biweekly budget template: read the biweekly budget guide.

03

Zero-Based Budget

You want every dollar assigned

Assign all of your income to categories. The Left to assign cell turns green at exactly zero.

Sample results

Income
$4,200.00
Assigned
$4,200.00
Left to assign
$0.00

Tabs and preview

Income Every source of income for the month.
RowAB
1SourceMonthly amount
2Paycheck$3,900.00
3Side income$300.00
4
5Total income$4,200.00
Assign Give every dollar a category. Type what you assigned and what you spent.
RowABCDE
1GroupCategoryAssignedSpentRemaining
2GivingCharity$200.00$200.00$0.00
3SavingEmergency fund$400.00$400.00$0.00
4SavingRetirement$300.00$300.00$0.00
5HousingRent$1,350.00$1,350.00$0.00
6HousingUtilities$210.00$224.60-$14.60
7FoodGroceries$450.00$478.35-$28.35
8FoodRestaurants$150.00$171.20-$21.20
9TransportationGas$160.00$148.90$11.10
10TransportationCar insurance$120.00$120.00$0.00
11TransportationCar repairs$130.00$0.00$130.00
12InsuranceHealth insurance$180.00$180.00$0.00
13PersonalPhone$90.00$90.00$0.00
14PersonalClothing$60.00$82.50-$22.50
15PersonalFun money$150.00$139.00$11.00
16DebtCredit card$250.00$250.00$0.00
17$0.00
18$0.00
19Total$4,200.00$4,134.55$65.45
Summary Left to assign turns green at exactly zero. Groups show your split.
RowABC
1MeasureAmount
2Total income$4,200.00
3Assigned$4,200.00
4Left to assign$0.00
5StatusEvery dollar has a job
6
7GroupAssignedShare of income
8Giving$200.004.8%
9Saving$700.0016.7%
10Housing$1,560.0037.1%
11Food$600.0014.3%
12Transportation$410.009.8%
13Insurance$180.004.3%
14Personal$300.007.1%
15Debt$250.006.0%

Formulas explained

  • =B2-B3in Summary!B4Income minus everything you assigned. Zero means every dollar has a job.
  • =IF(ROUND(B4,2)=0,"Every dollar has a job",IF(B4>0,"Money left to assign","Assigned more than income"))in Summary!B5Rounds to cents before it checks for zero, so tiny float errors do not hide a match.
  • =C2-D2in Assign!E2Assigned minus spent. A negative number means the category is over.
  • =SUMIF(Assign!$A$2:$A$18,A8,Assign!$C$2:$C$18)in Summary!B8Adds the assigned amounts for one group, for example Housing.

04

50/30/20 Budget

You want a simple rule, not a system

Tag each line as Needs, Wants or Savings. The sheet compares your split with the 50/30/20 targets.

Sample results

Needs (target 50.0%)
$2,380.00, 52.9%
Wants (target 30.0%)
$1,270.00, 28.2%
Savings (target 20.0%)
$850.00, 18.9%

Tabs and preview

Inputs Every monthly line with its amount and a Needs, Wants or Savings tag from the dropdown.
RowABC
1LineAmountType
2Rent$1,400.00Needs
3Utilities$160.00Needs
4Groceries$450.00Needs
5Transportation$240.00Needs
6Insurance$130.00Needs
7Dining out$280.00Wants
8Subscriptions$60.00Wants
9Shopping$330.00Wants
10Travel fund$300.00Wants
11Entertainment$150.00Wants
12Hobbies$150.00Wants
13Emergency fund$400.00Savings
14Retirement$300.00Savings
15Extra debt payoff$150.00Savings
16
17
18
Split Targets against what you actually assigned to each bucket.
RowABCDEF
1After-tax monthly income$4,500.00
2
3BucketTarget %TargetActualActual %Actual minus target
4Needs50.0%$2,250.00$2,380.0052.9%$130.00
5Wants30.0%$1,350.00$1,270.0028.2%-$80.00
6Savings20.0%$900.00$850.0018.9%-$50.00
7Total100.0%$4,500.00$4,500.00100.0%$0.00
8Not tagged to a bucket$0.00

Formulas explained

  • =ROUND($B$1*B4,2)in Split!C4Target dollars for the bucket: income times the target percentage, rounded to cents.
  • =SUMIF(Inputs!$C$2:$C$18,A4,Inputs!$B$2:$B$18)in Split!D4Adds every line on the Inputs tab whose tag matches the bucket name.
  • =IF($B$1=0,0,D4/$B$1)in Split!E4Actual dollars divided by income, shown as a percentage.
  • =D4-C4in Split!F4Actual minus target. Positive means you are above the target.

05

Couples and Household Budget

Two incomes and shared bills

Pick Equal or By income from a dropdown. Each shared bill splits to the cent.

Sample results

Shared bills
$3,646.42
Alex pays (by income)
$2,106.84
Sam pays (by income)
$1,539.58
Split modeAlex paysSam paysTotal
Equal$1,823.23$1,823.19$3,646.42
By income$2,106.84$1,539.58$3,646.42

Tabs and preview

Incomes Each person's income, each share, and the split mode dropdown.
RowABC
1PersonMonthly net incomeShare of income
2Alex$5,200.0057.8%
3Sam$3,800.0042.2%
4Total$9,000.00100.0%
5
6Split modeBy income
7First person pays this share57.8%
Shared bills Every shared bill with each person's share. The second share is the total minus the first, so the cents always add up.
RowABCD
1BillAmountAlex paysSam pays
2Rent$2,400.00$1,386.67$1,013.33
3Utilities$218.43$126.20$92.23
4Internet$79.99$46.22$33.77
5Groceries$684.17$395.30$288.87
6Renters insurance$24.50$14.16$10.34
7Streaming$29.97$17.32$12.65
8Pet costs$118.00$68.18$49.82
9Household supplies$91.36$52.79$38.57
10$0.00$0.00
11$0.00$0.00
12Total$3,646.42$2,106.84$1,539.58
Split What each person pays and keeps after shared bills.
RowABCDE
1PersonNet incomePays for shared billsLeft after shared billsShare of shared bills
2Alex$5,200.00$2,106.84$3,093.1657.8%
3Sam$3,800.00$1,539.58$2,260.4242.2%
4Total$9,000.00$3,646.42$5,353.58100.0%

Formulas explained

  • =IF(SUM($B$2:$B$3)=0,0,B2/SUM($B$2:$B$3))in Incomes!C2This person's income divided by combined income.
  • =IF(B6="Equal",0.5,C2)in Incomes!B7Uses 50% in Equal mode, or the income share in By income mode.
  • =ROUND(B2*Incomes!$B$7,2)in Shared bills!C2The first person's share of the bill, rounded to cents.
  • =B2-C2in Shared bills!D2The bill minus the first share. The two shares always add back to the bill.

06

Annual Budget

Planning 12 months, with yearly bills

Twelve months of plan and actual, a year-to-date summary, and sinking funds for yearly bills.

Sample results

Set aside each month for yearly bills
$225.00
Planned net for the year
$5,110.00
Actual net, year to date
$2,240.47

Tabs and preview

Plan Planned amounts for each month. Sinking funds fill from the Sinking funds tab.
RowABCDEFGHIJKLMN
1CategoryJanFebMarAprMayJunJulAugSepOctNovDecYear
2Month number123456789101112
3Income
4Paycheck$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$51,600.00
5Other income$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$100.00$600.00$1,700.00
6Total income$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,400.00$4,900.00$53,300.00
7
8Expenses
9Rent$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$17,400.00
10Utilities$170.00$160.00$140.00$120.00$110.00$140.00$170.00$180.00$150.00$120.00$130.00$160.00$1,750.00
11Groceries$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$6,000.00
12Transportation$240.00$240.00$240.00$240.00$240.00$240.00$240.00$240.00$240.00$240.00$240.00$240.00$2,880.00
13Insurance$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$200.00$2,400.00
14Phone and internet$130.00$130.00$130.00$130.00$130.00$130.00$130.00$130.00$130.00$130.00$130.00$130.00$1,560.00
15Dining out$180.00$180.00$180.00$180.00$180.00$180.00$180.00$180.00$180.00$180.00$180.00$180.00$2,160.00
16Subscriptions$45.00$45.00$45.00$45.00$45.00$45.00$45.00$45.00$45.00$45.00$45.00$45.00$540.00
17Fun and personal$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$150.00$1,800.00
18Debt payments$350.00$350.00$350.00$350.00$350.00$350.00$350.00$350.00$350.00$350.00$350.00$350.00$4,200.00
19Savings$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$400.00$4,800.00
20Sinking funds$225.00$225.00$225.00$225.00$225.00$225.00$225.00$225.00$225.00$225.00$225.00$225.00$2,700.00
21Total expenses$4,040.00$4,030.00$4,010.00$3,990.00$3,980.00$4,010.00$4,040.00$4,050.00$4,020.00$3,990.00$4,000.00$4,030.00$48,190.00
22Net (income minus expenses)$360.00$370.00$390.00$410.00$420.00$390.00$360.00$350.00$380.00$410.00$400.00$870.00$5,110.00
Actual What you really spent and earned, month by month.
RowABCDEFGHIJKLMN
1CategoryJanFebMarAprMayJunJulAugSepOctNovDecYear
2Month number123456789101112
3Income
4Paycheck$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$4,300.00$25,800.00
5Other income$100.00$120.00$100.00$100.00$85.00$100.00$605.00
6Total income$4,400.00$4,420.00$4,400.00$4,400.00$4,385.00$4,400.00$0.00$0.00$0.00$0.00$0.00$0.00$26,405.00
7
8Expenses
9Rent$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$1,450.00$8,700.00
10Utilities$182.40$171.15$138.60$118.25$109.80$146.30$866.50
11Groceries$512.30$478.95$531.40$497.20$520.85$488.10$3,028.80
12Transportation$236.00$251.40$244.15$229.90$262.30$240.00$1,463.75
13Insurance$200.00$200.00$200.00$200.00$200.00$200.00$1,200.00
14Phone and internet$130.00$130.00$130.00$130.00$130.00$130.00$780.00
15Dining out$194.50$168.20$221.75$175.00$189.40$203.65$1,152.50
16Subscriptions$45.00$45.00$52.98$45.00$45.00$45.00$277.98
17Fun and personal$140.00$95.00$160.00$180.00$120.00$150.00$845.00
18Debt payments$350.00$350.00$350.00$350.00$350.00$350.00$2,100.00
19Savings$400.00$400.00$400.00$400.00$400.00$400.00$2,400.00
20Sinking funds$225.00$225.00$225.00$225.00$225.00$225.00$1,350.00
21Total expenses$4,065.20$3,964.70$4,103.88$4,000.35$4,002.35$4,028.05$0.00$0.00$0.00$0.00$0.00$0.00$24,164.53
22Net (income minus expenses)$334.80$455.30$296.12$399.65$382.65$371.95$0.00$0.00$0.00$0.00$0.00$0.00$2,240.47
Sinking funds Yearly bills divided by 12, so each one is paid for before it is due.
RowABCD
1Yearly billYearly costSet aside per monthDue month
2Car registration$240.00$20.00Mar
3Holiday gifts$600.00$50.00Dec
4Vacation$1,200.00$100.00Jul
5Memberships$180.00$15.00Jan
6Medical and dental$480.00$40.00Sep
7$0.00
8$0.00
9Total$2,700.00$225.00
Summary Year plan, year to date and what is left, for each category.
RowABCDE
1Months completed6
2
3LinePlanned yearPlanned YTDActual YTDActual minus planned YTD
4Total income$53,300.00$26,400.00$26,405.00$5.00
5Total expenses$48,190.00$24,060.00$24,164.53$104.53
6Net (income minus expenses)$5,110.00$2,340.00$2,240.47-$99.53
7
8Expense categoryPlanned yearPlanned YTDActual YTDLeft in year plan
9Rent$17,400.00$8,700.00$8,700.00$8,700.00
10Utilities$1,750.00$840.00$866.50$883.50
11Groceries$6,000.00$3,000.00$3,028.80$2,971.20
12Transportation$2,880.00$1,440.00$1,463.75$1,416.25
13Insurance$2,400.00$1,200.00$1,200.00$1,200.00
14Phone and internet$1,560.00$780.00$780.00$780.00
15Dining out$2,160.00$1,080.00$1,152.50$1,007.50
16Subscriptions$540.00$270.00$277.98$262.02
17Fun and personal$1,800.00$900.00$845.00$955.00
18Debt payments$4,200.00$2,100.00$2,100.00$2,100.00
19Savings$4,800.00$2,400.00$2,400.00$2,400.00
20Sinking funds$2,700.00$1,350.00$1,350.00$1,350.00

Formulas explained

  • =ROUND(B2/12,2)in Sinking funds!C2Yearly cost divided by 12. Set this aside every month.
  • ='Sinking funds'!$C$9in Plan!B20Pulls the monthly sinking-fund total from the Sinking funds tab.
  • =SUM(B4:M4)in Plan!N4Adds January to December for a line.
  • =SUMIF(Plan!$B$2:$M$2,"<="&$B$1,Plan!B6:M6)in Summary!C4Planned year to date: adds only the months up to the number of months completed.
  • =SUMIF(Actual!$B$2:$M$2,"<="&$B$1,Actual!B6:M6)in Summary!D4Actual year to date, with the same rule.

Does Google have its own budget template?

Yes. Google says its templates include budgets, and you can find them in the Template Gallery in Google Sheets. Google's template help (Google Docs Editors Help, checked 17 Nov 2026). The six templates here cover different pay schedules and methods in one place, and each one shows its formulas.

How do I make a copy of a Google Sheets budget template?

Open the template, choose File, then Make a copy, name it, and save it to your Drive. The copy is yours to edit, and the original stays unchanged.

A view-only sheet cannot be edited. Google says viewers can see a file but cannot change it, so copy it first. Google's sharing roles (Google Docs Editors Help, checked 17 Nov 2026).

  1. Open the template. Open the copy link on the template card. A "Make a copy" link lets people make their own copy of a Sheets file with one click, as Google describes (Google Workspace Learning Center, checked 17 Nov 2026).
  2. Choose File, then Make a copy. In Google Sheets, open the File menu and choose Make a copy. Google's steps (Google Docs Editors Help, checked 17 Nov 2026).
  3. Name the copy and pick a folder. Type a name, choose where it saves in your Drive, and click OK. The copy is yours to edit.
  4. Clear the sample data. Delete the numbers in the yellow cells and type your own. Leave the white cells alone, because they hold formulas.
  5. Using the .xlsx file instead. Upload the file to Google Drive, open it, and choose File, then Save as Google Sheets. Google explains (Google Docs Editors Help, checked 17 Nov 2026) how it converts Excel files.

Is Google Sheets good for budgeting?

Yes, for a plan you keep by hand. Sheets gives you formulas, sharing and a phone app, and you decide every category. The cost is typing each payment yourself.

Where a sheet works well

  • You control every category and every formula.
  • Two people can edit the same file.
  • You can copy last year's file for the new year.

Where it strains

  • These templates take typed or pasted transactions. They do not connect to a bank.
  • One deleted row inside a formula range can skew a total without any warning.
  • Logging payments on a phone is slow in a large grid.

How do I build my own budget in Google Sheets, step by step?

Make a Budget tab with planned amounts and a Transactions tab. Add an Actual column that uses SUMIF to add each category, then subtract actual from planned.

  1. Make two tabs, Budget and Transactions.
  2. On Budget, type categories in column A and planned amounts in column B.
  3. On Transactions, add the headers Date, Description, Category and Amount in columns A to D.
  4. On Budget, put this in C2 and fill it down: =SUMIF(Transactions!$C$2:$C$200,A2,Transactions!$D$2:$D$200)
  5. Put this in D2 and fill it down: =B2-C2. A negative number means you spent more than planned.
  6. Total each column under the last category: =SUM(B2:B12).
  7. Format column B to D as currency and freeze the header row.

Category names must match exactly, because SUMIF compares text. If you would rather start with a working sheet, copy Monthly Budget, which is this layout with a Summary tab added.

What is Dave Ramsey's budget format?

Dave Ramsey's budget format is a zero-based budget. Income minus planned spending equals zero, so every dollar has a job before the month starts. Ramsey Solutions describes it (Ramsey Solutions, checked 17 Nov 2026).

Ramsey Solutions also says zero does not mean an empty bank account, and suggests leaving a buffer of about $100 to $300 in its how-to-budget guide (Ramsey Solutions, checked 17 Nov 2026). The Zero-Based Budget template shows Left to assign and turns it green at exactly zero. Add your buffer as its own category if you want one.

How do I track actual spending against my budget?

Log each payment on a Transactions tab. Then use SUMIF to add each category into an Actual column and subtract it from the planned amount.

=SUMIF(Transactions!$C$2:$C$200,A2,Transactions!$D$2:$D$200)
=B2-C2

To flag overspending, select the Difference cells and add a conditional formatting rule for numbers less than 0. Google's conditional formatting steps (Google Docs Editors Help, checked 17 Nov 2026) cover the menu. The Monthly Budget template already has this rule.

Keep category names identical on both tabs. "Grocery" and "Groceries" are different text to SUMIF, so the second one would show $0 actual.

Can I use a Google Sheets budget on my phone?

Yes. Google says you can create, view and edit Sheets files offline in the Google Sheets app on Android and iOS once you make files available offline. Google's offline steps (Google Docs Editors Help, checked 17 Nov 2026).

Typing into a wide grid is slow. On a phone, add payments on the Transactions tab and read the Summary tab for totals.

How do I share a budget with my partner?

Share the single budget sheet from the Share button, enter your partner's email, and give them Editor access. Google lists Viewer, Commenter and Editor roles. Google's sharing help (Google Docs Editors Help, checked 17 Nov 2026).

Share the one file, not a whole folder. If you split bills, the Couples and Household template splits each bill equally or by income share, to the cent.

When does a spreadsheet stop working for budgeting?

When typing payments by hand costs more time than the budget saves, or when you want your numbers on your phone without opening a grid.

  • You skip a month of logging and never catch up.
  • A broken formula has gone unnoticed for weeks.
  • Two people edit the same cells and overwrite each other.

If you want an app instead, we make MoneyCoach. It works without a bank connection, and a bank connection is optional. New users start with a free Premium trial.

Sources

Every third-party fact on this page comes from the publisher below. All checked 17 Nov 2026.