A clean, no-fuss budget spreadsheet that does the maths for you. Set your categories once, log what comes in and goes out each month, and the planner shows where your money went, what is left in each budget and how close you are to your savings goals.

What’s inside

Setup tab – currency symbol, budget year, up to 8 income sources and up to 15 spending categories, each with its own monthly budget.
12 monthly tabs (Jan–Dec) – an income table (20 rows), an expense table (80 rows) and a Budget vs actual block with remaining amount and % used per category.
Savings Goals – up to 8 goals with target, target date, monthly contributions, progress bar and the amount you would need to save per month to get there on time.
Annual dashboard – income, spending, net saved and savings rate, a month-by-month table, a bar chart (income vs spending) and a donut chart of spending by category.
Start Here guide plus a README with setup and import steps.

Features

Real formulas throughout (SUM, SUMIF and simple IF logic) – nothing is hard-coded.
Dropdown lists for income sources, categories and payment method, so entries stay consistent.
Conditional formatting flags categories that are over budget (red) or nearly used up (amber).
An “uncategorised” check on each month so no expense slips through.
Rename any category on Setup and every month plus the dashboard follow automatically.
Frozen headers and print-ready pages (landscape, fit to one page wide).
Sample data in January to March so you can see the charts working before you start; delete it in a few clicks.

Works with

Microsoft Excel 2016 or newer (Windows and Mac) and Excel for the web, and Google Sheets via a simple import. No macros, VBA or add-ins. It also opens in LibreOffice Calc and Apple Numbers, though charts and some formatting may look different there. This is a digital download: you receive one .xlsx file and a README in a zip, and nothing physical is shipped.

How to start

Download the zip and open the .xlsx in Excel, or upload it to Google Drive and choose File › Save as Google Sheets.
Fill in the Setup tab with your currency, year, income sources and category budgets.
Clear the sample rows on Jan–Mar and start logging this month’s income and expenses.
Check the Dashboard at the end of each month to see your savings rate and where you can adjust.

License: personal and small-business use, one client project per purchase. Please do not resell, share or use the file for print-on-demand. See the License page.

expense tracker

expense tracker

Monthly Budget Planner Spreadsheet