Excel Budget Template Generator
Build a monthly budget workbook with your own categories, live totals, and a running net figure.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Monthly Budget | ||||||||
| 2 | |||||||||
| 3 | Category | January | February | March | April | May | June | July | August |
| 4 | |||||||||
| 5 | Income | ||||||||
| 6 | Salary | ||||||||
| 7 | Freelance | ||||||||
| 8 | Other income | ||||||||
| 9 | Total income | =SUM(B6:B8) | =SUM(C6:C8) | =SUM(D6:D8) | =SUM(E6:E8) | =SUM(F6:F8) | =SUM(G6:G8) | =SUM(H6:H8) | =SUM(I6:I8) |
| 10 | |||||||||
| 11 | Expenses | ||||||||
| 12 | Rent / Mortgage | ||||||||
| 13 | Utilities | ||||||||
| 14 | Groceries | ||||||||
| 15 | Transport | ||||||||
| 16 | Insurance | ||||||||
| 17 | Phone & Internet | ||||||||
| 18 | Subscriptions | ||||||||
| 19 | Dining out | ||||||||
| 20 | Savings | ||||||||
| 21 | Total expenses | =SUM(B12:B20) | =SUM(C12:C20) | =SUM(D12:D20) | =SUM(E12:E20) | =SUM(F12:F20) | =SUM(G12:G20) | =SUM(H12:H20) | =SUM(I12:I20) |
| 22 |
Preview of the first 22 rows. Cells shown as =SUM(...) are live formulas in the downloaded workbook, not pasted numbers.
What you get
- •One column per month, with a Total column that sums the year across each category.
- •Separate income and expense sections, each with its own subtotal row.
- •A Net row that subtracts total expenses from total income for every month.
- •Every total is a real SUM formula, so the workbook keeps working when you add rows.