Excel templates / Monthly budget
Monthly budget template
Planned against actual income and spending, with what’s left, the share of each budget used, and a savings rate.
Download the monthly budget template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.
How to use it
- Put the month in
B2. - Fill in the yellow cells: what you plan to earn and spend in column B, and what you actually earned and spent in column C.
- Rename the categories in
A11toA20to suit you. Everything else updates by itself.
How it works
D5:D7=C5-B5: How much more (or less) came in than planned: actual minus planned.B8=SUM(B5:B7): Adds up the income. The same SUM totals each column of spending in row 21.D11:D20=B11-C11: What’s left of each budget. It turns negative when you overspend.E11:E20=IF(B11=0,"",C11/B11): The share of the budget used, shown as a percentage. IF leaves it blank for a category with no budget, instead of dividing by zero.F11:F20=IF(C11>B11,"Over","OK"): Flags a category as Over when you spent more than you planned.C24=IF(C8=0,"",C23/C8): Your savings rate: what’s left over as a share of your income.C25=COUNTIF(F11:F20,"Over"): Counts the categories marked Over.
Learn the skills behind it
Functions used: SUM, IF, COUNTIF.