Monthly Budget Spreadsheet

Plan each category, log what you spend and see plan against actual for any month and for the whole year, with Over and Watch flags. No bank logins.

  • See plan vs. actual for any month
  • Over and Watch flags
  • A whole-year view
$7.99
Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

Monthly Budget Spreadsheet in Google Sheets on a laptop, shown with sample data

What's inside

  • Start HereYour welcome page: a 5-step setup checklist, how the tabs fit together, a guide to every tab with clickable links, and the color legend.
  • Monthly BudgetPick a month and see your plan against what you actually spent, by group (Needs, Wants, Savings, Debt) and by category, with flags for Over and Watch, planned and actual income, left to assign and your savings rate. A chart shows plan against actual by group.
  • BudgetYour monthly plan for each category, with this month's spending, what is left, the percent used, a flag when you are over or close, and your 12-month average. 24 starter categories are included.
  • TransactionsEvery dollar in, out and moved: income, expenses, transfers, debt payments and savings, each with a date, category and amount. A Check column says what is missing.
  • YearPick a year and see every category by month against your plan, with income, money out, savings and your savings rate for each month.
  • SettingsSet up once: your household name, your expected monthly income and your category list with each category's group (Needs, Wants, Savings or Debt).

A closer look

Plan against actual, by group: Needs, Wants, Savings and Debt for any month, with a chart. (Monthly Budget Spreadsheet, sample data)
Every category, flagged: Over and Watch flags show where the month is going wrong. (Monthly Budget Spreadsheet, sample data)
Your plan in one list: A monthly amount for every category, with this month and a 12-month average. (Monthly Budget Spreadsheet, sample data)
Log every dollar: Pick a category and a type; the Check column says what is missing. (Monthly Budget Spreadsheet, sample data)
The whole year at a glance: Every category by month, with your plan and savings rate. (Monthly Budget Spreadsheet, sample data)

Screenshots show the Sample copy with made-up data.

Get set up in minutes

  1. Open your copy's Start Here tab.
  2. Settings: your expected monthly income and your categories.
  3. Budget: plan an amount for each category.
  4. Transactions: log each purchase and each bit of income.
  5. Monthly Budget and Year: pick a month or a year and see where you stand.

Good to know

  • Google Sheets: you need a free Google account. This isn't an Excel file.
  • Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
  • Nothing to install: no add-ons, no scripts.
  • You get a ready-to-use copy plus a Sample copy filled with example data, and a step-by-step PDF guide.
How Monthly Budget Spreadsheet fits together

Ready when you are

$7.99
Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

More in Personal Finance

Personal Finance Command Center Google Sheets template
All-in-onePersonal Finance

Personal Finance Command Center

Run your household money from one Google Sheet: budget by paycheck and by month, bills, spending, savings goals, debt payoff and net worth, all…

$30.99View template →
Paycheck Budget Planner Google Sheets template
Personal Finance

Paycheck Budget Planner

Budget by paycheck: see which bills each paycheck covers, what to set aside for savings and debts, and how much is safe to spend before the next…

$8.99View template →
Bill Tracker & Bill Calendar Google Sheets template
Personal Finance

Bill Tracker & Bill Calendar

List every bill once, log each payment and see what is due soon, what is overdue and what is paid, on a month calendar and a 12-month checklist.

$5.99View template →
Spending Tracker Google Sheets template
Personal Finance

Spending Tracker

Log each purchase with a category, then see where the money goes by category and month, your top spending categories and a chart. No bank logins.

$4.00View template →

See all Personal Finance templates →