Monthly Budget Spreadsheet – Budget Planner & Expense Tracker with Dashboard, Google Sheets & Excel

A monthly budget spreadsheet that works in Google Sheets and Excel, with a dashboard that updates itself. Plan every category, log spending in seconds, and see your savings rate at a glance — no formulas to touch, ever.

WHAT IT DOES

• Dashboard: income, expenses, net, savings rate and "goal met?" for any month you pick, plus two charts (planned vs actual by category; income vs expenses across the year).

• Monthly Budget: planned vs actual for up to 20 expense and 20 income categories, with "left to spend" and colour alerts when you're near or over budget.

• Transactions: a 1,000-row log with dropdown categories. Month and year fill in automatically.

• Annual Overview: every category by month for the whole year, with totals, net and savings rate.

• Settings: your categories, your savings goal, the month to display. Change them once; everything updates.

WHAT YOU GET (instant download)

• PDF guide with your Google Sheets copy link

• Excel file (.xlsx) for Excel 2016 or newer, Windows and Mac

• Start Here tab with 5 set-up steps and sample data you can clear in one click

HOW IT WORKS

1. Download the PDF, open the link, File → Make a copy (or open the Excel file).

2. On Settings, set your year, month, savings goal and categories.

3. Type planned amounts on Monthly Budget and log spending on Transactions. Done.

COMPATIBILITY

Google Sheets (free Google account) and Microsoft Excel 2016+. You can enter data in the Sheets mobile app, but set-up is easiest on a computer. Not designed for Apple Numbers.

LICENSE

Personal use (or one business of your own). Please don't resell, share or redistribute the files.

FAQ

Refunds: digital files can't be returned once downloaded, but if anything doesn't work as described, contact me and I'll fix it — usually the same day.

Currency: the file shows $ by default; change the number format in Sheets/Excel to use any currency.

Support: use the Contact link on the PlanfulPanda store. Replies within one business day.

Looking for debt payoff, savings and net-worth trackers too? They're all in the PlanfulPanda store.

Designed by PlanfulPanda with AI-assisted tools; every formula and layout is hand-checked.