To make a budget in Google Sheets, create one tab for your plan, one for your expenses and one for a summary, then connect them with a category dropdown and a SUMIFS formula. Here is the exact setup, step by step, plus a free template if you would rather start from a finished one.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Go to sheets.google.com and open a blank spreadsheet (Google's own guide: How to use Google Sheets). Rename the first tab Budget Plan and add two more tabs: Expenses and Summary.
On Budget Plan, put categories in column A (Rent, Groceries, Transportation and so on) and the planned monthly amount in column B. Add a total at the bottom with =SUM(B2:B25).
On Expenses, use five columns: Date, Category, Description, Amount, Paid with. Select the Category column and add a dropdown from a range (Data > Data validation, or see Create an in-cell dropdown list). Point it at the category list on Budget Plan. Now every expense must use a real category.
Back on Budget Plan, add a Spent column that adds up each category from the log, for example =SUMIFS(Expenses!D:D, Expenses!B:B, A2). To count only this month, add two date conditions on column A of Expenses. Then a Left column: =B2-C2. Use conditional formatting to turn negative values red.
On Summary, list the twelve months down column A and use SUMIFS with date ranges to total income and spending per month. Add a chart (Insert > Chart) for income vs. spending. This is the part most people skip, and it is the part that shows whether the budget is working.
Color the cells you type in (yellow works) and protect the formula ranges (Data > Protect sheets and ranges). One wrong paste over a formula is the most common reason a home-made budget breaks.
All six steps take an evening if everything goes right. The free template below has them done already: the plan, the expense log with dropdowns, the monthly summary, a dashboard with charts and protected formulas.
If you would rather start from a finished file, the Free Monthly Budget Template does all of this for you in Google Sheets or Excel. It is free (type 0 in the price box), and you can preview it in Google Sheets first.
Budget plan: 21 ready categories in four groups (Essential, Lifestyle, Savings, Debt). Rename or add your own.
Expense tracker: date, category dropdown, description, amount and payment method.
Income log: one row per payment, from any source.
Monthly summary: income, spending, plan vs. actual and money left over for all 12 months.
Dashboard: income and spending this year, money left over, what is left to spend this month, two charts and quick checks.
Two files: a blank template and a demo file filled with a year of sample data.
Download the free budget template →
Already have a template? See How to Use a Google Sheets Budget Template. Paid irregularly? Start with How to Budget with Irregular Income.
Free template: a complete monthly budget. Best if your paycheck is the same every month. Get it free.
Irregular Income Budget Bundle ($9): everything in the free template plus steady salary, buffer, taxes, pending invoices, bills, sinking funds and debt payoff. Best for freelancers and anyone with changing income. See the full bundle.
Your rows copy straight across, so you can start free and upgrade later without retyping anything.
SUMIFS. For example =SUMIFS(Expenses!D:D, Expenses!B:B, A2) adds every amount in column D whose category in column B matches A2.
Select the column, open Data > Data validation, choose "Dropdown (from a range)" and point it to your category list.
Yes. Google Sheets is free with a Google account and works in the browser and on the Sheets phone app.
You can log income and expenses in the Google Sheets app. Building the formulas is easier on a computer.
Download the free budget template (Google Sheets + Excel) →
Get the Irregular Income Budget Bundle ($9) →
About this page: written by Abdallah Elsied, who makes the Free Monthly Budget Template (free) and the Irregular Income Budget Bundle ($9), both linked on this page. Last updated October 2026. This is general budgeting information, not financial, tax or legal advice.