DEV Community

Muhammad Asif
Muhammad Asif

Posted on

Build a Monthly Budget Spreadsheet in Google Sheets

Most budgets fail for a simple reason: they live in your head instead of on a page you can actually see. A monthly budget spreadsheet fixes that. It shows exactly what comes in, what goes out and what is left, and it costs nothing to build in Google Sheets. You do not need a paid budgeting app or any special skills — just three tabs, a few simple formulas and ten minutes a week to keep it up to date.

Why a spreadsheet beats a budgeting app

Budgeting apps are convenient, but they come with subscriptions, ads and categories you cannot change. A spreadsheet is yours. You decide the categories, you see every formula, and your data stays in your own Google account. It also works offline in the Sheets app, and you can share it with a partner or a family member without paying for another seat. For beginners, especially anyone selling digital products or freelancing with irregular income, that control matters more than fancy charts.

The three-tab setup

A good budget spreadsheet has three tabs, each with one job:

  • Budget: your plan for the month — every category and how much you intend to spend on it.
  • Transactions: a running log of everything you actually spend.
  • Dashboard: a simple summary that compares the plan with reality.

Keeping the plan, the log and the summary separate is what makes the system easy to maintain. When something goes wrong, you can see at a glance whether the plan was unrealistic or the spending was.

Step 1: set up the Budget tab

Start with four columns: Category, Budgeted, Spent and Remaining. Then list the categories that cover your real life: Rent, Utilities, Food, Transport, Subscriptions, Health and Savings are a solid starting point. Add your monthly income at the top so you can see the full picture, and give every category a number — even a rough one is better than a blank cell.

If you are not sure how much to allow for each category, the 50/30/20 rule is a useful starting point: roughly 50 percent of your income for needs, 30 percent for wants and 20 percent for savings and extra debt payments. Adjust the split to fit your situation, but keep the total of your budgeted amounts at or below your income.

Step 2: log every transaction

The Transactions tab needs four columns: Date, Category, Description and Amount. Every time you spend money, add one row. A coffee, a bus fare, a subscription renewal — log it the same day if you can, or at least once a week. This is the habit that makes the whole system work, and it takes less than a minute a day.

Then let formulas do the maths. In the Budget tab, the Spent column can pull its totals from the Transactions tab with SUMIF, which adds up every transaction in a given category. The Remaining column is even simpler: Budgeted minus Spent. When a category goes over budget, the remaining figure turns negative, which is your signal to slow down or move money from another category.

Step 3: build a simple dashboard

The Dashboard tab is where the spreadsheet earns its keep. Use SUM to total your income, your budgeted spending and your actual spending, then show the difference so you always know how much of the month is left in money terms. A pie chart of spending by category makes it obvious where the money is going, and a bar chart comparing budgeted against actual spending shows which categories need attention.

Add a little conditional formatting — red when a category is over budget, green when it is on track — and you can read the whole month in seconds without studying any numbers.

Habits that make it stick

A spreadsheet only helps if you open it. Set a weekly reminder to log the week's spending and check the dashboard, and a monthly reminder to review the month and set next month's budget. If a category is over budget every single month, the budget is wrong, not you — raise the limit and cut somewhere else. And keep a small buffer in the budget for surprises, because surprises are the one expense that always arrives.

Get the full walkthrough

This guide covers the structure and the habits, but if you want every formula, column layout and chart step spelled out, follow our step-by-step budget spreadsheet tutorial. It walks through the same three tabs — Budget, Transactions and Dashboard — with the exact formulas to copy, so you can have a working monthly budget spreadsheet in Google Sheets today and start next month knowing exactly where your money stands.

Top comments (0)