Tutorials

·

How to Make a Monthly Budget in Google Sheets (Budget vs. Actual, Step by Step)

How to Make a Monthly Budget in Google Sheets (Budget vs. Actual, Step by Step)

How to Make a Monthly Budget in Google Sheets (Budget vs. Actual, Step by Step)

How to make a monthly budget in Google Sheets

A monthly budget in Google Sheets is one of the most useful spreadsheets you'll ever make. You type each purchase once, and the sheet tells you how much is left in every category, where you overspent and how much you can still spend today. Here's how to build one that stays simple enough to keep using.

Quick answer: To make a monthly budget in Google Sheets, create a Transactions tab with date, category and amount, then a Budget tab that lists each category with a planned amount. Use SUMIFS to total actual spending per category for the month, subtract it from the budget to see what’s left, and color negative numbers red. The Budget Planner does all of this automatically across 6 connected tabs for a one-time $6.

Before you start: pick a budgeting method

A spreadsheet is just a tool. The method decides how you fill it in. Three popular options:

  • 50/30/20: Roughly 50% of take-home pay to needs, 30% to wants and 20% to savings and debt payoff. Simple and a good starting point.

  • Zero-based budgeting: Every dollar of income gets a job, so income minus planned spending equals zero.

  • Pay yourself first: Move savings out at the start of the month, then budget what’s left.

Choose one, but don’t overthink it. Most people adjust their categories after the first month anyway. This is general information, not financial advice.

Step 1: Create a transaction log

  1. Name the first tab Transactions.

  2. Add headers in A1 to E1: Date, Category, Sub-category, Amount and Note.

  3. Select the Category column and use Data > Data validation to make a dropdown of your categories, such as Rent, Groceries, Transport, Eating out and Fun money. Dropdowns stop typos from breaking your totals.

  4. Format the Date column as a date and Amount as currency.

Step 2: Set up your budget tab

  1. Name the second tab Budget.

  2. In F1 enter the first day of the month, for example =DATE(2026,11,1).

  3. List your categories in A2 down, with headers Category, Budget, Actual and Left in A1 to D1.

  4. Type your planned amount for each category in column B.

Step 3: Calculate budget vs. actual with SUMIFS

In C2 enter this formula and fill down:

=SUMIFS(Transactions!D:D,Transactions!B:B,A2,Transactions!A:A,">="&$F$1,Transactions!A:A,"<="&EOMONTH($F$1,0))

It adds up every transaction in that category between the first and last day of the month. In D2 enter =B2-C2 to show what’s left. Change F1 to next month and the whole budget recalculates.

Step 4: Make overspending obvious

Select D2:D20, open Format > Conditional formatting and choose Less than 0 with a red fill. Add a second rule, Greater than or equal to 0, in green. One glance now shows where you’re over.

Step 5: Add income, totals and a daily spend limit

  • Income: Type your expected income in F2 and actual income in F3.

  • Total spent: =SUM(C2:C20).

  • Left to spend: =F3-SUM(C2:C20).

  • Daily spend limit: =(F3-SUM(B2:B20))/DAY(EOMONTH(F1,0)) shows how much flexible money you have per day after your planned categories. Adjust it to fit how you budget.

  • Savings rate: =(F3-SUM(C2:C20))/F3 formatted as a percentage.

Step 6: Chart it

Select your categories and the Actual column and choose Insert > Chart, then a pie chart for spending by category. A column chart with Budget and Actual side by side is the clearest budget vs. actual view.

Monthly cash flow summary in Google Sheets with budget vs. actual chart and spending by category

The faster way: the Budget Planner

If you’d like the result without building it, the Budget Planner is a fully automated Google Sheet with 6 connected tabs. Enter a transaction once and your totals, charts and summaries update instantly.

The main dashboard shows income, spent, saved, left to spend and ending balance, with pie, bar and daily-spending charts. Expenses show budget vs. actual for every category, with overspending in red. There’s a daily spend limit that turns a day red when you go over, bills with paid checkboxes, debt balances and payoff progress, and savings goals with a monthly target.

It works in any currency, can be used through 2035 and keeps a separate summary for each month. You can pick a start and end date for your month, which helps if you’re paid mid-month.

Common budgeting mistakes in spreadsheets

  • Too many categories. Start with 8 to 12. You can split them later.

  • Forgetting irregular costs. Add a category for yearly expenses and set aside a monthly amount.

  • Logging once a month. A two-minute log every few days is far easier than reconstructing a month of receipts.

  • No buffer. Add a small “miscellaneous” category so one surprise doesn’t break the budget.

For why this habit is worth it, read why tracking your budget matters.

What buyers say

The Budget Planner is rated 4.9/5, and we’ve sold over 45,000 templates across our shop.

“This is a very beautiful budget spreadsheet. It’s very simple to use & easy to understand.”

Verified buyer

Frequently asked questions

How do I make a simple monthly budget in Google Sheets?

Log transactions on one tab, list categories with planned amounts on another, and use SUMIFS to total actual spending per category for the month. Subtract to see what’s left.

What is the best formula for budget vs. actual in Google Sheets?

SUMIFS, filtered by category and by the first and last day of the month. EOMONTH gives you the last day automatically.

Does Google Sheets have a free budget template?

Yes, the template gallery includes a basic monthly budget. It’s a good starting point, though it doesn’t include bills, debt or subscription tracking.

Can I use a Google Sheets budget on my phone?

Yes. Logging expenses in the Google Sheets app works well. Setup is easier on a computer.

Can I budget in a currency other than dollars?

Yes. Change the number format to your currency. The Budget Planner works in any currency.

The bottom line

A monthly budget in Google Sheets needs only two tabs and one key formula: a transaction log, a budget tab and SUMIFS. Build it with the steps above, or use the Budget Planner for a ready-made dashboard with bills, debt, savings and subscriptions included. For a broader overview, see our guide to the budget planner spreadsheet. New here? Enter code WELCOME20 at checkout for 20% off your first order.

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore

About

Organized Dashboard is a cozy corner for aesthetic Notion & Google Sheets templates ♡ helping you become more organized & productive.

organizeddashboard@gmail.com

Explore