What's inside
The workbook has five sheets, each focused on one part of the budgeting cycle.
- Dashboard — monthly budget vs. actual summary for all 10 categories, with a surplus/shortfall indicator and a simple chart showing where your money goes. This is the only sheet you need to check week-to-week.
- Budget Plan — set your monthly income target, then allocate amounts to housing, transportation, food, utilities, insurance, healthcare, savings, debt repayment, entertainment, and personal spending. A 50/30/20 reference column helps you sanity-check allocations.
- Actuals — enter what you actually spent by category each month. SUMIFS pulls category totals from a transaction log so you can paste in a bank export instead of hand-keying entries.
- Transaction Log — date, payee, category (dropdown), and amount. Feeds the actuals sheet automatically. Paste your bank CSV here or type entries directly.
- Annual View — twelve months side by side, so you can spot seasonal spikes and see year-to-date totals without leaving the workbook.
How to use it
- Download the ZIP. The bundle includes a blank workbook (your working copy) and a filled example showing a realistic household budget so you can see how the formulas behave with real data before you overwrite anything.
- Open in Excel or upload to Google Sheets. The file is a native .xlsx, so it opens in Excel, Numbers, and LibreOffice Calc. For Google Sheets, drag the blank file into Drive and choose Open with → Google Sheets.
- Set your monthly income. Enter gross and net income on the Budget Plan sheet. The 50/30/20 reference column recalculates automatically — 50% needs, 30% wants, 20% savings.
- Allocate your categories. Fill in your budget targets for each of the 10 categories. If you prefer zero-based budgeting, keep adjusting until income minus all allocations equals zero.
- Log transactions. Add spending to the Transaction Log as the month progresses, or paste a CSV export from your bank at month-end. The Actuals sheet totals by category automatically.
- Review on the Dashboard. The surplus/shortfall row shows budget vs. actual for each category. Red conditional formatting flags any category where you spent over budget.
Customize with AI
Need to add a custom category, split a category into subcategories, or build a formula that rolls up a date range differently? Generate the formula with the DropFile Formula Generator. Describe the calculation in plain English and paste the result straight into the workbook.
Frequently asked
- Is this template free?
- Yes. The 2026 Monthly Budget Template is a free download — no sign-up, no email gate, no watermark. Use it for personal or household budgeting and share it with anyone who needs it.
- Can I edit it in Google Sheets?
- Yes. Drop the blank .xlsx into Google Drive, right-click and choose Open with → Google Sheets, then File → Save as Google Sheets if you want a fully native copy. All formulas, dropdowns, and conditional formatting transfer without modification.
- What budgeting method does it support?
- The template is method-agnostic but includes a 50/30/20 reference column on the Budget Plan sheet (50% needs, 30% wants, 20% savings) as a starting point. For zero-based budgeting, allocate every dollar until income minus allocations equals zero — the surplus/shortfall indicator on the Dashboard shows when you're balanced.
- How many spending categories are included?
- Ten: housing, transportation, food, utilities, insurance, healthcare, savings, debt repayment, entertainment, and personal. You can rename any category directly in the Budget Plan sheet — the dropdown in the Transaction Log and the Dashboard chart update automatically.
- Can I track multiple months in one file?
- Yes. The Annual View sheet shows all 12 months side by side and calculates year-to-date totals. Each month's budget and actual data feeds into the annual view automatically as you fill in the monthly sheets.