A monthly budget template for Google Sheets gives you one place to plan what you will spend, log what you actually spend, and see what is left before the month ends. This page shows what a good monthly template should include, how to set one up in about ten minutes, and where to get a free one that already does the math.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Google Sheets has a basic monthly budget in its template gallery, and it is fine for a first try. Most people outgrow it within a month, because it handles one month at a time and has no dashboard. A template that actually sticks does four jobs:
Plan: a planned amount for each spending category, grouped into essentials, lifestyle, savings and debt.
Track: a log where each expense gets a date, a category from a dropdown and an amount, so it lands in the right budget line automatically.
Compare: planned vs. actual for each category, every month, with overspending shown in red.
Summarize: one view of the whole year, so you can see which months went well and which did not.
Start with your income. Use what you reliably take home in a month. If it changes, see How to Budget with Irregular Income.
List your categories. Rent or mortgage, utilities, groceries, transport, insurance, debt payments, subscriptions, dining out, savings. Twenty or so is plenty.
Give every category a monthly amount. Essentials first, then savings and debt, then lifestyle with what is left.
Log spending as it happens. Once a day or every few days. A dropdown for the category keeps the totals honest.
Check the month once a week. Look at what is left in each category and adjust before the month ends, not after.
Grouping categories makes the budget easier to read. The free template uses four groups:
Essential: rent or mortgage, utilities, internet and phone, groceries, transportation, insurance, health, childcare, business expenses.
Lifestyle: subscriptions, dining out, shopping, entertainment, personal care, gifts and donations, travel, other.
Savings: sinking funds, emergency fund, retirement.
Debt: debt payments.
You can rename any of them. The point of the groups is the question they answer at a glance: "Are my essentials covered, and am I saving anything?"
A single month tells you very little. A monthly summary for the whole year shows income, spending, plan vs. actual and money left over for each month side by side, plus a running total. That is where patterns show up: the month the car insurance renewed, the holiday spike, the slow start of the year.
If you would rather not build it yourself, 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 →
Want the step-by-step version? Read How to Make a Budget in Google Sheets or How to Use a Google Sheets Budget Template.
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.
Yes. Open Google Sheets, choose the template gallery and look under Personal for "Monthly budget". It covers one month. The free template on this page adds a full-year summary, category dropdowns and a dashboard.
Yes. Type 0 in the price box on the download page. If it helps you, you can pay what you want.
Yes. The workbook starts counting from your first entry, so you can start in any month.
Yes. The same .xlsx file opens in Excel 2016 or newer and in Google Sheets.
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.