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 situation | Template | Built for |
|---|
| You are paid once a month, or you just want one simple budget. | Monthly Budget | One salary, one month at a time |
| You are paid every other week and bills do not line up with your paycheck. | Biweekly Paycheck Budget | Paid every two weeks, 26 paychecks a year |
| You want income minus assigned money to equal zero. | Zero-Based Budget | You want every dollar assigned |
| You want to see needs, wants and savings as a share of income. | 50/30/20 Budget | You want a simple rule, not a system |
| You share bills and want a fair split, equal or by income. | Couples and Household Budget | Two incomes and shared bills |
| You plan the whole year and have costs that come once a year. | Annual Budget | Planning 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.
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.
| Row | A | B | C | D |
|---|
| 1 | Category | Planned | Actual | Difference |
|---|
| 2 | Income | | | |
|---|
| 3 | Paycheck | $4,200.00 | $4,200.00 | $0.00 |
|---|
| 4 | Other income | $100.00 | $150.00 | $50.00 |
|---|
| 5 | Total income | $4,300.00 | $4,350.00 | $50.00 |
|---|
| 6 | | | | |
|---|
| 7 | Expenses | | | |
|---|
| 8 | Rent | $1,500.00 | $1,500.00 | $0.00 |
|---|
| 9 | Utilities | $180.00 | $170.55 | $9.45 |
|---|
| 10 | Groceries | $520.00 | $573.93 | -$53.93 |
|---|
| 11 | Transportation | $260.00 | $237.40 | $22.60 |
|---|
| 12 | Insurance | $210.00 | $207.00 | $3.00 |
|---|
| 13 | Phone and internet | $120.00 | $119.00 | $1.00 |
|---|
| 14 | Dining out | $200.00 | $198.50 | $1.50 |
|---|
| 15 | Subscriptions | $45.00 | $44.97 | $0.03 |
|---|
| 16 | Health | $90.00 | $81.50 | $8.50 |
|---|
| 17 | Fun | $150.00 | $136.00 | $14.00 |
|---|
| 18 | Household and other | $120.00 | $102.45 | $17.55 |
|---|
| 19 | Debt payment | $250.00 | $250.00 | $0.00 |
|---|
| 20 | Savings | $400.00 | $400.00 | $0.00 |
|---|
| 21 | Total 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.
| Row | A | B | C | D |
|---|
| 1 | Date | Description | Category | Amount |
|---|
| 2 | Oct 1, 2026 | Employer payroll | Paycheck | $4,200.00 |
|---|
| 3 | Oct 1, 2026 | Landlord | Rent | $1,500.00 |
|---|
| 4 | Oct 2, 2026 | Grocery store | Groceries | $96.40 |
|---|
| 5 | Oct 3, 2026 | Electric and gas | Utilities | $112.35 |
|---|
| 6 | Oct 3, 2026 | Mobile and internet | Phone and internet | $119.00 |
|---|
| 7 | Oct 4, 2026 | Gas station | Transportation | $48.20 |
|---|
| 8 | Oct 5, 2026 | Coffee and lunch | Dining out | $34.75 |
|---|
| 9 | Oct 6, 2026 | Streaming and apps | Subscriptions | $44.97 |
|---|
| 10 | Oct 7, 2026 | Grocery store | Groceries | $132.18 |
|---|
| 11 | Oct 8, 2026 | Auto insurance | Insurance | $207.00 |
|---|
| 12 | Oct 9, 2026 | Pharmacy | Health | $36.50 |
|---|
| 13 | Oct 10, 2026 | Transit pass | Transportation | $90.00 |
|---|
| 14 | Oct 11, 2026 | Dinner out | Dining out | $78.60 |
|---|
| 15 | Oct 12, 2026 | Cinema | Fun | $41.00 |
|---|
| 16 | Oct 13, 2026 | Hardware store | Household and other | $62.30 |
|---|
| 17 | Oct 14, 2026 | Student loan | Debt payment | $250.00 |
|---|
| 18 | Oct 15, 2026 | Freelance payment | Other income | $150.00 |
|---|
| 19 | Oct 16, 2026 | Grocery store | Groceries | $118.92 |
|---|
| 20 | Oct 17, 2026 | Gas station | Transportation | $51.40 |
|---|
| 21 | Oct 18, 2026 | Concert tickets | Fun | $95.00 |
|---|
| 22 | Oct 19, 2026 | Water bill | Utilities | $58.20 |
|---|
| 23 | Oct 20, 2026 | Brunch | Dining out | $46.25 |
|---|
| 24 | Oct 22, 2026 | Grocery store | Groceries | $124.77 |
|---|
| 25 | Oct 24, 2026 | Dentist copay | Health | $45.00 |
|---|
| 26 | Oct 25, 2026 | Transfer to savings | Savings | $400.00 |
|---|
| 27 | Oct 27, 2026 | Grocery store | Groceries | $101.66 |
|---|
| 28 | Oct 28, 2026 | Gas station | Transportation | $47.80 |
|---|
| 29 | Oct 29, 2026 | Takeout | Dining out | $38.90 |
|---|
| 30 | Oct 30, 2026 | Household supplies | Household and other | $40.15 |
|---|
| 31 | | | | |
|---|
| 32 | | | | |
|---|
| 33 | | | | |
|---|
Summary Income, expenses and what is left, planned against actual.
| Row | A | B | C |
|---|
| 1 | Measure | Planned | Actual |
|---|
| 2 | Total income | $4,300.00 | $4,350.00 |
|---|
| 3 | Total expenses | $4,045.00 | $4,021.30 |
|---|
| 4 | Net (income minus expenses) | $255.00 | $328.70 |
|---|
| 5 | Share of income left | 5.9% | 7.6% |
|---|
Formulas explained
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.
| Row | A | B | C | D | E | F |
|---|
| 1 | Pay date | Net pay | Paycheck of month | Bills due | Left over | Flag |
|---|
| 2 | Jan 1, 2027 | $2,400.00 | 1 | $1,975.00 | $425.00 | |
|---|
| 3 | Jan 15, 2027 | $2,400.00 | 2 | $1,595.00 | $805.00 | |
|---|
| 4 | Jan 29, 2027 | $2,400.00 | 3 | $0.00 | $2,400.00 | Extra paycheck |
|---|
| 5 | Feb 12, 2027 | $2,400.00 | 1 | $1,975.00 | $425.00 | |
|---|
| 6 | Feb 26, 2027 | $2,400.00 | 2 | $1,595.00 | $805.00 | |
|---|
| 7 | Mar 12, 2027 | $2,400.00 | 1 | $1,975.00 | $425.00 | |
|---|
| 8 | Mar 26, 2027 | $2,400.00 | 2 | $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.
| Row | A | B | C | D |
|---|
| 1 | Bill | Due day | Paid from paycheck | Amount |
|---|
| 2 | Rent | 1 | 1 | $1,450.00 |
|---|
| 3 | Car insurance | 5 | 1 | $140.00 |
|---|
| 4 | Phone | 8 | 1 | $85.00 |
|---|
| 5 | Groceries, first half | 1 | 1 | $300.00 |
|---|
| 6 | Student loan | 17 | 2 | $260.00 |
|---|
| 7 | Utilities | 20 | 2 | $190.00 |
|---|
| 8 | Internet | 22 | 2 | $70.00 |
|---|
| 9 | Credit card payment | 24 | 2 | $300.00 |
|---|
| 10 | Streaming | 25 | 2 | $25.00 |
|---|
| 11 | Gym | 26 | 2 | $40.00 |
|---|
| 12 | Groceries, second half | 15 | 2 | $300.00 |
|---|
| 13 | Car payment | 28 | 2 | $410.00 |
|---|
| 14 | | | | |
|---|
| 15 | | | | |
|---|
| 16 | | | | |
|---|
| 17 | Paycheck 1 bills | | | $1,975.00 |
|---|
| 18 | Paycheck 2 bills | | | $1,595.00 |
|---|
Summary Year totals and the money from the two extra paychecks.
| Row | A | B |
|---|
| 1 | Measure | Amount |
|---|
| 2 | Paychecks in the year | 26 |
|---|
| 3 | Net pay for the year | $62,400.00 |
|---|
| 4 | Bills for the year | $42,840.00 |
|---|
| 5 | Left over for the year | $19,560.00 |
|---|
| 6 | Extra paychecks (third in a month) | 2 |
|---|
| 7 | Left over from extra paychecks | $4,800.00 |
|---|
Formulas explained
MoneyCoach also has a guide to a free biweekly budget template: read the biweekly budget guide.
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.
| Row | A | B |
|---|
| 1 | Source | Monthly amount |
|---|
| 2 | Paycheck | $3,900.00 |
|---|
| 3 | Side income | $300.00 |
|---|
| 4 | | |
|---|
| 5 | Total income | $4,200.00 |
|---|
Assign Give every dollar a category. Type what you assigned and what you spent.
| Row | A | B | C | D | E |
|---|
| 1 | Group | Category | Assigned | Spent | Remaining |
|---|
| 2 | Giving | Charity | $200.00 | $200.00 | $0.00 |
|---|
| 3 | Saving | Emergency fund | $400.00 | $400.00 | $0.00 |
|---|
| 4 | Saving | Retirement | $300.00 | $300.00 | $0.00 |
|---|
| 5 | Housing | Rent | $1,350.00 | $1,350.00 | $0.00 |
|---|
| 6 | Housing | Utilities | $210.00 | $224.60 | -$14.60 |
|---|
| 7 | Food | Groceries | $450.00 | $478.35 | -$28.35 |
|---|
| 8 | Food | Restaurants | $150.00 | $171.20 | -$21.20 |
|---|
| 9 | Transportation | Gas | $160.00 | $148.90 | $11.10 |
|---|
| 10 | Transportation | Car insurance | $120.00 | $120.00 | $0.00 |
|---|
| 11 | Transportation | Car repairs | $130.00 | $0.00 | $130.00 |
|---|
| 12 | Insurance | Health insurance | $180.00 | $180.00 | $0.00 |
|---|
| 13 | Personal | Phone | $90.00 | $90.00 | $0.00 |
|---|
| 14 | Personal | Clothing | $60.00 | $82.50 | -$22.50 |
|---|
| 15 | Personal | Fun money | $150.00 | $139.00 | $11.00 |
|---|
| 16 | Debt | Credit card | $250.00 | $250.00 | $0.00 |
|---|
| 17 | | | | | $0.00 |
|---|
| 18 | | | | | $0.00 |
|---|
| 19 | Total | | $4,200.00 | $4,134.55 | $65.45 |
|---|
Summary Left to assign turns green at exactly zero. Groups show your split.
| Row | A | B | C |
|---|
| 1 | Measure | Amount | |
|---|
| 2 | Total income | $4,200.00 | |
|---|
| 3 | Assigned | $4,200.00 | |
|---|
| 4 | Left to assign | $0.00 | |
|---|
| 5 | Status | Every dollar has a job | |
|---|
| 6 | | | |
|---|
| 7 | Group | Assigned | Share of income |
|---|
| 8 | Giving | $200.00 | 4.8% |
|---|
| 9 | Saving | $700.00 | 16.7% |
|---|
| 10 | Housing | $1,560.00 | 37.1% |
|---|
| 11 | Food | $600.00 | 14.3% |
|---|
| 12 | Transportation | $410.00 | 9.8% |
|---|
| 13 | Insurance | $180.00 | 4.3% |
|---|
| 14 | Personal | $300.00 | 7.1% |
|---|
| 15 | Debt | $250.00 | 6.0% |
|---|
Formulas explained
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.
| Row | A | B | C |
|---|
| 1 | Line | Amount | Type |
|---|
| 2 | Rent | $1,400.00 | Needs |
|---|
| 3 | Utilities | $160.00 | Needs |
|---|
| 4 | Groceries | $450.00 | Needs |
|---|
| 5 | Transportation | $240.00 | Needs |
|---|
| 6 | Insurance | $130.00 | Needs |
|---|
| 7 | Dining out | $280.00 | Wants |
|---|
| 8 | Subscriptions | $60.00 | Wants |
|---|
| 9 | Shopping | $330.00 | Wants |
|---|
| 10 | Travel fund | $300.00 | Wants |
|---|
| 11 | Entertainment | $150.00 | Wants |
|---|
| 12 | Hobbies | $150.00 | Wants |
|---|
| 13 | Emergency fund | $400.00 | Savings |
|---|
| 14 | Retirement | $300.00 | Savings |
|---|
| 15 | Extra debt payoff | $150.00 | Savings |
|---|
| 16 | | | |
|---|
| 17 | | | |
|---|
| 18 | | | |
|---|
Split Targets against what you actually assigned to each bucket.
| Row | A | B | C | D | E | F |
|---|
| 1 | After-tax monthly income | $4,500.00 | | | | |
|---|
| 2 | | | | | | |
|---|
| 3 | Bucket | Target % | Target | Actual | Actual % | Actual minus target |
|---|
| 4 | Needs | 50.0% | $2,250.00 | $2,380.00 | 52.9% | $130.00 |
|---|
| 5 | Wants | 30.0% | $1,350.00 | $1,270.00 | 28.2% | -$80.00 |
|---|
| 6 | Savings | 20.0% | $900.00 | $850.00 | 18.9% | -$50.00 |
|---|
| 7 | Total | 100.0% | $4,500.00 | $4,500.00 | 100.0% | $0.00 |
|---|
| 8 | Not tagged to a bucket | | | $0.00 | | |
|---|
Formulas explained
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 mode | Alex pays | Sam pays | Total |
|---|
| 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.
| Row | A | B | C |
|---|
| 1 | Person | Monthly net income | Share of income |
|---|
| 2 | Alex | $5,200.00 | 57.8% |
|---|
| 3 | Sam | $3,800.00 | 42.2% |
|---|
| 4 | Total | $9,000.00 | 100.0% |
|---|
| 5 | | | |
|---|
| 6 | Split mode | By income | |
|---|
| 7 | First person pays this share | 57.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.
| Row | A | B | C | D |
|---|
| 1 | Bill | Amount | Alex pays | Sam pays |
|---|
| 2 | Rent | $2,400.00 | $1,386.67 | $1,013.33 |
|---|
| 3 | Utilities | $218.43 | $126.20 | $92.23 |
|---|
| 4 | Internet | $79.99 | $46.22 | $33.77 |
|---|
| 5 | Groceries | $684.17 | $395.30 | $288.87 |
|---|
| 6 | Renters insurance | $24.50 | $14.16 | $10.34 |
|---|
| 7 | Streaming | $29.97 | $17.32 | $12.65 |
|---|
| 8 | Pet costs | $118.00 | $68.18 | $49.82 |
|---|
| 9 | Household supplies | $91.36 | $52.79 | $38.57 |
|---|
| 10 | | | $0.00 | $0.00 |
|---|
| 11 | | | $0.00 | $0.00 |
|---|
| 12 | Total | $3,646.42 | $2,106.84 | $1,539.58 |
|---|
Split What each person pays and keeps after shared bills.
| Row | A | B | C | D | E |
|---|
| 1 | Person | Net income | Pays for shared bills | Left after shared bills | Share of shared bills |
|---|
| 2 | Alex | $5,200.00 | $2,106.84 | $3,093.16 | 57.8% |
|---|
| 3 | Sam | $3,800.00 | $1,539.58 | $2,260.42 | 42.2% |
|---|
| 4 | Total | $9,000.00 | $3,646.42 | $5,353.58 | 100.0% |
|---|
Formulas explained
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.
| Row | A | B | C | D | E | F | G | H | I | J | K | L | M | N |
|---|
| 1 | Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|
| 2 | Month number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
|---|
| 3 | Income | | | | | | | | | | | | | |
|---|
| 4 | Paycheck | $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 |
|---|
| 5 | Other 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 |
|---|
| 6 | Total 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 | | | | | | | | | | | | | | |
|---|
| 8 | Expenses | | | | | | | | | | | | | |
|---|
| 9 | Rent | $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 |
|---|
| 10 | Utilities | $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 |
|---|
| 11 | Groceries | $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 |
|---|
| 12 | Transportation | $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 |
|---|
| 13 | Insurance | $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 |
|---|
| 14 | Phone 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 |
|---|
| 15 | Dining 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 |
|---|
| 16 | Subscriptions | $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 |
|---|
| 17 | Fun 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 |
|---|
| 18 | Debt 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 |
|---|
| 19 | Savings | $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 |
|---|
| 20 | Sinking 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 |
|---|
| 21 | Total 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 |
|---|
| 22 | Net (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.
| Row | A | B | C | D | E | F | G | H | I | J | K | L | M | N |
|---|
| 1 | Category | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|
| 2 | Month number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
|---|
| 3 | Income | | | | | | | | | | | | | |
|---|
| 4 | Paycheck | $4,300.00 | $4,300.00 | $4,300.00 | $4,300.00 | $4,300.00 | $4,300.00 | | | | | | | $25,800.00 |
|---|
| 5 | Other income | $100.00 | $120.00 | $100.00 | $100.00 | $85.00 | $100.00 | | | | | | | $605.00 |
|---|
| 6 | Total 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 | | | | | | | | | | | | | | |
|---|
| 8 | Expenses | | | | | | | | | | | | | |
|---|
| 9 | Rent | $1,450.00 | $1,450.00 | $1,450.00 | $1,450.00 | $1,450.00 | $1,450.00 | | | | | | | $8,700.00 |
|---|
| 10 | Utilities | $182.40 | $171.15 | $138.60 | $118.25 | $109.80 | $146.30 | | | | | | | $866.50 |
|---|
| 11 | Groceries | $512.30 | $478.95 | $531.40 | $497.20 | $520.85 | $488.10 | | | | | | | $3,028.80 |
|---|
| 12 | Transportation | $236.00 | $251.40 | $244.15 | $229.90 | $262.30 | $240.00 | | | | | | | $1,463.75 |
|---|
| 13 | Insurance | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | | | | | | | $1,200.00 |
|---|
| 14 | Phone and internet | $130.00 | $130.00 | $130.00 | $130.00 | $130.00 | $130.00 | | | | | | | $780.00 |
|---|
| 15 | Dining out | $194.50 | $168.20 | $221.75 | $175.00 | $189.40 | $203.65 | | | | | | | $1,152.50 |
|---|
| 16 | Subscriptions | $45.00 | $45.00 | $52.98 | $45.00 | $45.00 | $45.00 | | | | | | | $277.98 |
|---|
| 17 | Fun and personal | $140.00 | $95.00 | $160.00 | $180.00 | $120.00 | $150.00 | | | | | | | $845.00 |
|---|
| 18 | Debt payments | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | $350.00 | | | | | | | $2,100.00 |
|---|
| 19 | Savings | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | | | | | | | $2,400.00 |
|---|
| 20 | Sinking funds | $225.00 | $225.00 | $225.00 | $225.00 | $225.00 | $225.00 | | | | | | | $1,350.00 |
|---|
| 21 | Total 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 |
|---|
| 22 | Net (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.
| Row | A | B | C | D |
|---|
| 1 | Yearly bill | Yearly cost | Set aside per month | Due month |
|---|
| 2 | Car registration | $240.00 | $20.00 | Mar |
|---|
| 3 | Holiday gifts | $600.00 | $50.00 | Dec |
|---|
| 4 | Vacation | $1,200.00 | $100.00 | Jul |
|---|
| 5 | Memberships | $180.00 | $15.00 | Jan |
|---|
| 6 | Medical and dental | $480.00 | $40.00 | Sep |
|---|
| 7 | | | $0.00 | |
|---|
| 8 | | | $0.00 | |
|---|
| 9 | Total | $2,700.00 | $225.00 | |
|---|
Summary Year plan, year to date and what is left, for each category.
| Row | A | B | C | D | E |
|---|
| 1 | Months completed | 6 | | | |
|---|
| 2 | | | | | |
|---|
| 3 | Line | Planned year | Planned YTD | Actual YTD | Actual minus planned YTD |
|---|
| 4 | Total income | $53,300.00 | $26,400.00 | $26,405.00 | $5.00 |
|---|
| 5 | Total expenses | $48,190.00 | $24,060.00 | $24,164.53 | $104.53 |
|---|
| 6 | Net (income minus expenses) | $5,110.00 | $2,340.00 | $2,240.47 | -$99.53 |
|---|
| 7 | | | | | |
|---|
| 8 | Expense category | Planned year | Planned YTD | Actual YTD | Left in year plan |
|---|
| 9 | Rent | $17,400.00 | $8,700.00 | $8,700.00 | $8,700.00 |
|---|
| 10 | Utilities | $1,750.00 | $840.00 | $866.50 | $883.50 |
|---|
| 11 | Groceries | $6,000.00 | $3,000.00 | $3,028.80 | $2,971.20 |
|---|
| 12 | Transportation | $2,880.00 | $1,440.00 | $1,463.75 | $1,416.25 |
|---|
| 13 | Insurance | $2,400.00 | $1,200.00 | $1,200.00 | $1,200.00 |
|---|
| 14 | Phone and internet | $1,560.00 | $780.00 | $780.00 | $780.00 |
|---|
| 15 | Dining out | $2,160.00 | $1,080.00 | $1,152.50 | $1,007.50 |
|---|
| 16 | Subscriptions | $540.00 | $270.00 | $277.98 | $262.02 |
|---|
| 17 | Fun and personal | $1,800.00 | $900.00 | $845.00 | $955.00 |
|---|
| 18 | Debt payments | $4,200.00 | $2,100.00 | $2,100.00 | $2,100.00 |
|---|
| 19 | Savings | $4,800.00 | $2,400.00 | $2,400.00 | $2,400.00 |
|---|
| 20 | Sinking funds | $2,700.00 | $1,350.00 | $1,350.00 | $1,350.00 |
|---|
Formulas explained
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).
- 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).
- 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).
- 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.
- Clear the sample data. Delete the numbers in the yellow cells and type your own. Leave the white cells alone, because they hold formulas.
- 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.
- Make two tabs, Budget and Transactions.
- On Budget, type categories in column A and planned amounts in column B.
- On Transactions, add the headers Date, Description, Category and Amount in columns A to D.
- On Budget, put this in C2 and fill it down:
=SUMIF(Transactions!$C$2:$C$200,A2,Transactions!$D$2:$D$200) - Put this in D2 and fill it down:
=B2-C2. A negative number means you spent more than planned. - Total each column under the last category:
=SUM(B2:B12). - 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.
- Google Docs Editors Help: Create, view, or download a file, checked 17 Nov 2026
- Google Docs Editors Help: Use templates, checked 17 Nov 2026
- Google Workspace Learning Center: Tips to edit and collaborate on files, checked 17 Nov 2026
- Google Docs Editors Help: Use both Excel & Sheets: Best practices, checked 17 Nov 2026
- Google Docs Editors Help: Use conditional formatting rules in Google Sheets, checked 17 Nov 2026
- Google Docs Editors Help: Share and manage access to files and folders in Google Drive, checked 17 Nov 2026
- Google Docs Editors Help: Work on Google Docs, Sheets, and Slides offline, checked 17 Nov 2026
- Ramsey Solutions: How to Budget Guide, checked 17 Nov 2026
- Ramsey Solutions: The 50/30/20 Budget Rule Explained, checked 17 Nov 2026