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

  1. Create a new workbook and rename the first sheet to Budget.
  2. Enter the headers in row 1: Category, Planned, Actual, Difference.
  3. List your expense categories in column A (e.g., Rent, Utilities, Groceries, etc.).
  4. Fill in your planned amounts in column B and actual amounts in column C.
  5. In the Difference column (D), enter the formula =B2‑C2 in D2 and copy it down.
  6. 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.