Spreadsheet Templates
â˘
Published on Nov 20, 2026
â˘
By SheetVault Editorial Team
â˘
Free .XLSX
Free Simple Monthly Personal Budget Spreadsheet for Excel & Google Sheets (Download)
=SUM(B2:B7)
What Is a Simple Monthly Personal Budget Spreadsheet?
A simple monthly personal budget spreadsheet helps you compare your planned spending against what you actually spent, giving you clear insight into where your money goes each month.
Benefits
- Easy to set up in Excel or Google Sheets
- Instant visual of overspending or savings
- Automatic totals and differences
StepâbyâStep Setup
- Create a new workbook and rename the first sheet to Budget.
- Enter the headers in rowâŻ1: Category, Planned, Actual, Difference.
- List your expense categories in columnâŻA (e.g., Rent, Utilities, Groceries, etc.).
- Fill in your planned amounts in columnâŻB and actual amounts in columnâŻC.
- In the Difference column (D), enter the formula
=B2âC2in D2 and copy it down. - In the total row, use
=SUM(B2:B7)for total planned,=SUM(C2:C7)for total actual, and=SUM(D2:D7)for total difference.
Pro Tips
- Format columnâŻD as red for negative values and green for positive values using conditional formatting.
- Use a pie chart to visualise the share of each category.
- Copy the sheet each month and rename it (e.g., âJanâ2024â).
Download Ready-to-Use Spreadsheet
Instant .xlsx file download with pre-loaded formulas, formatted totals, and clean design.
Download Template (.xlsx)Frequently Asked Questions
Can I track income as well?
Yes, add an Income section above expenses and subtract total expenses from total income to see net savings.
How do I copy the formulas for new months?
Duplicate the sheet, rename it, and Excel/Sheets will keep the relative references intact.
What if I have variable categories each month?
Add or remove rows as needed; the SUM ranges can be adjusted or use dynamic named ranges.