A budget vs actual spreadsheet puts what you planned next to what you really spent, for each category, so the gaps jump out. It is the single most useful view in personal budgeting. Here is how it works in Google Sheets, how to read it, and a free template that builds it for you.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Each category has three numbers: planned (your budget), actual (the sum of your logged expenses) and variance (planned minus actual). Positive variance means you came in under plan; negative means you overspent. Over a year, the same view per month shows which categories are always off.
Actual: =SUMIFS(Expenses!D:D, Expenses!B:B, A2, Expenses!A:A, ">="&start, Expenses!A:A, "<"&end)
Variance: =B2-C2
Percent used: =C2/B2, formatted as a percentage
Red when over: Format > Conditional formatting > "Less than 0" on the variance column
One month over is noise. Three months over means the plan is wrong, not you. Raise the plan and cut somewhere else.
Always under in a category means money you could move to savings or debt.
Big totals hide small leaks. Check dining out, subscriptions and shopping individually.
A column chart with planned and actual side by side for each month makes trends visible. The free template has an income vs. spending chart on the dashboard and a plan vs. actual line in the monthly summary.
Get it ready-made: 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 →
The Irregular Income Budget Bundle goes further with a Spending by Category tab: every category, every month, red where you spent more than planned.
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.
A sheet that compares planned spending with actual spending per category and shows the difference.
Planned minus actual. A negative result means you went over.
Yes. The free template on this page includes plan vs. actual in its monthly summary.
Yes, in the Irregular Income Budget Bundle's Spending by Category tab.
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.